Posts

Altibase is Deployed for Data Management Platform for Airport Traffic Control

Altibase is Deployed for Data Management Platform for Airport Traffic Control

NEW YORKApril 1, 2019 /PRNewswire/ — Altibase announces that Korea Airports Corporation (KAC) has adopted Altibase for its big data platform harnessing various IoT technologies.

KAC carries out construction, management and operation of airports and manages and controls airport traffic. It manages and operates total of 14 airports in Korea.

KAC has long been looking for databases for its big data platform to utilize cutting-edge IoT technologies to improve the efficacy of collecting and analyzing of data such as passenger and airport flow. However, KAC’s legacy DBMSs failed to meet its requirements:

  • KAC is inundated with a huge amount of data influx from its 14 airports. The legacy DBMSs did not meet the throughput requirement, a minimum of 100,000 transactions per second in storing and manipulating formal data. As a result, the whole system often fell into arrears.
  • Even mere seconds of database downtime cannot be tolerated with KAC, which could lead to fatal casualties, not to mention lost revenues and reputation. Consequently, an extremely high level of stability is required of its DBMSs.
  • The new DBMS should be compatible and interoperable with other core systems of Hadoop and the platform as well.

KAC conducted a number of BMTs and eventually chose Altibase over Oracle.

  • Altibase’s 19 years’ accumulated knowhow in the field of MES and experience in storage and analysis of big data gained high scores.
  • Altibase’s in-memory capabilities allow for high throughput and low latency, particularly high processing performance of big data.
  • High performance was a requisite in the use of UI/UX.
  • KAC’s zero tolerance of database downtime was met by Altibase.

As a result, KAC is now able to collect and analyze big data (i.e. flight status and passenger flow) in real time, to anticipate airport congestion, improve passenger convenience and to more efficiently operate airport resources. Moreover, with cooperation with mobile service providers, KAC has added new passenger services by providing the shortest routes from their departing points to their airports to avoid heavy traffic.

After nearly 20 years as a closed-source database, Altibase is now open source, and that includes its state-of-the-art scale-out technology, sharding.

For more information and download, please visit: http://altibase.com

Company Name: Altibase Corp.
Address: 40 Wall Street, 28th Floor
City: New York
State: New York
Country: United States

Media Contact: Paul Nahm
631 708 4749
211653@email4pr.com

SOURCE Altibase Corp

Related Links

http://altibase.com

Intel officially launches its beta program in partnership with Altibase and other IMDBs

Intel Optane DC Persistent Memory, what it is and how it works. Go to the beta program

Intel officially launches the beta program: hardware manufacturers and partner companies will be able to preview the new Intel Optane DC memories. What they are and why they are destined to change the storage market by speeding up the processing in the cloud

We have often talked about Intel Optane : it is a technology on which the Santa Clara company has invested so much and is increasingly being offered in our country too.
As explained in the Intel Optane Memory article or how to accelerate the performance of the system those currently available on the market are memory modules that drastically accelerate the performance of systems based on traditional hard drives and SATA SSDs .

Intel Optane DC Persistent Memory, what it is and how it works.  Go to the beta program

Although Intel has recently decided to take a step back and let Micron develop the XPoint 3D technology on which Optane is based ( Xpoint 3D technology will pass into Micron’s hands ), the company will continue to develop new products.

Intel Optane DC Persistent Memory is a bit considered as the evolution of Intel Optane Memory because it also combines skills aimed at the persistent preservation of data : Intel presents Optane DC memories that can be used both as RAM modules and as SSD .Today Intel has announced that it has started the “beta program” focused on Intel Optane DC Persistent Memory : this means that every cloud provider and every partner company (OEM) will be able to use a preview of the new memories that will be officially brought to the market during the first half year 2019 .

Thanks to the new Intel Optane DC Persistent Memory, combined with the new Xeon processors of the next generation, companies can revolutionize the ways in which heavy workloads, cloud processing, databases and high performance computing are managed: it becomes possible to bring performance to a much higher level, thanks to the ability to store and move data in memory quickly .

Intel Optane DC Persistent Memory, what it is and how it works.  Go to the beta program

Used in the App Dire mode , applications can count on performances never seen before thanks to the possibility of keeping in store, in a persistent way, an important amount of information. The Memory mode mode , however, allows you to use Intel Optane DC as a volatile memory using it as additional memory capacity than that offered by the RAM modules installed at the motherboard level.
It will thus be possible to have an additional, extremely fast, large storage capacity up to 512 GB . All this without the need to change a line of software side code.

Intel partner companies that have embraced Intel Optane DC Persistent Memory right from the start are Alibaba, Cisco, Dell EMC, Fujitsu, Google Cloud, Hewlett Packard Enterprise, Huawei, Lenovo, Oracle and Tencent.
Intel is also working with the most important software developers to optimize their solutions so they can take full advantage of using Intel Optane DC. The companies that have decided to join are, for the moment, Aerospike, Altibase, Apache Spark, AsiaInfo, Cassandra, DataBricks, Gigaspaces, IBM, Microsoft, Red Hat, RedisLabs, RocksDB, SAS, SAP, Sunjesoft, SuSE, Ubuntu, Virtuozzo and VMWare.

MEZMO adopts Altibase for its mobile app for the hearing impaired

Altibase Announces that MEZMO has Adopted Altibase for its Mobile Communication App for the Hearing Impaired

INNOCAPTION

Altibase is pleased to announce that MEZMO, the communication provider approved by the FCC as a TRS provider for the deaf in the US, has switched from MySQL to Altibase. Altibase will now function as its core database for telecommunication replay  service (TRS), which enables phone calls to the hearing impaired by showing the voice of the other party by letter.

MEZMO, headquartered in the US, operates the service, InnoCaption. The company found its MySQL database service inadequate in meeting its specific requirements. The challenges it was facing included performance deterioration as the number of subscribers increased and more services were added. Another issue was no real time updates of information on subscribers, billing status and logs. The process also requires some manual handling from time to time in batch mode. In addition, product instability, mediocre performance scaling and heavy dependence on add-ons of MySQL were often a cause for concern.

MEZMO required a database that could update and process its data without performance degradation. It also wanted to address the performance degradation issue with minimal investment in hardware additions or upgrade. The new database was required to allow for easy migration of data objects from MySQL and allow for easy adoption in the Amazon cloud. SQL databases, moreover, could pose problems with inter-operating with other systems built by the company on relational databases.

The above considerations were met by Altibase, and MEZMO adopted Altibase in 2014. Since then, Altibase has served MEMZO as a core database that provides both performance and reliability. MEZMO has been able to avoid performance degradation even when more subscribers and services are added.

Data processing and updating is now executed at a fraction of the cost that could have incurred with hardware addition for equal performance. Altibase’s hybrid architecture is utilized to store frequently used, recent data in memory, and less frequently used, historical data on disk.

The migration was easy and straightforward between relational databases, MySQL and Altibase.

MEZMO currently updates its system to analyze big data using Altibase in light of the performance and reliability Altibase has provided in the past 3 years.

After nearly 20 years as a closed source database, Altibase is now open source, and that includes its state-of-the-art sharding.

Learn more about Altibase at: https://youtu.be/pooexk0glK8, and download its open source database including sharding at: http://altibase.com.

 

Altibase announces that Seoul Transportation adopts Altibase for real time subway traffic control management

Altibase announces that Seoul Transportation adopts Altibase for real time subway traffic control management

24/7 uninterrupted operation and 99.999% high availability were the key reasons in its choice of database.

Use Case: Traffic Signal Control System

Current Customers: Seoul Transportation Corporation

Industry: Public

Who

Seoul Transportation Corporation is a public entity responsible for the city’s subway transit. The daily average number of subway transit passengers operated by the entity is 6.8 million vs. New York (5.6 million) & Paris (4.2 million). It has a total subway length of 300 km, making it the fourth longest in the world.

Problem

The corporation was in the process of overhauling its subway traffic system with a view to improving the safety and the ability to better act on emergency situations. The corporation looked for a database that could meet the following requirements:

  • Since subway traffic facilities should not tolerate any system disruption/failure, they should be supported by databases with the highest degree of product stability
  • 24/7 uninterrupted operation and 99.999% high availability
  • Even in the event of the system going down abnormally, all data should be automatically saved and protected.
  • Data should be collected and stored in real time so that prompt actions can be taken in case of system abnormalities/failures.
  • The database should provide and adhere to strict technical SLAs.
  • The database should have a track record of having been deployed for other mission critical applications.
  • The database should be relational as all of the corporation’s systems are built on relational DBMSs.
  • The database costs should be within its IT budget.

Solution

In 2018, the corporation chose Altibase after a series of BMTs of various databases.

  • Altibase’s previous deployments in other subway traffic systems was a major appeal.
  • Altibase’s in-memory capabilities allow for real time data collection and anaylsis.
  • Using Altibase’s move technology, data is stored on disk when it become stale and historical.
  • Database induced system downtime has been eliminated with Altibase’s HA and disaster recovery solutions that have features of in-memory based real time replication for synchronous/asynchronous data duplication and in-memory based real time backup and recovery.
  • Altibase’s pricing met the corporation’s budget requirement.
  • Altibase provides hybrid partitioned tables that can manage a large set of  data log while simultaneously ensuring high performance.

Results

  • Altibase has a demonstrated history of providing glitch free operation in the past 10 years in the all subway traffic signal control systems it has served.
  • Altibase’s active-active and active-standby replication function allows for stable and interruption-free operation through data duplication in the event of any system failure/outage.
  • The corporation is now able to back up its data through Altibase’s checkpoint image file and redo log file.
  • Data loss could be prevented via Altibase’s durability assurance even with abnormal DBMS shutdown.

After nearly 20 years as a closed source database, Altibase is now open source, and that includes its state-of-the-art sharding.

Learn more about Altibase at https://youtu.be/pooexk0glK8, and download its open source database including sharding at http://altibase.com.

Why is SQL so pular again after so much hype about NoSQL? @Tom-Armstrong

Why is SQL so popular again after so much hype about NoSQL?

 Tom Armstrong
Tom Armstrong, 3 years as SSMS database support developer, 2 years as SSMS DBA/SQL developer

This question infers that SQL lost popularity after the advent of NoSQL. I would argue that it did not.

You must compare what the two technologies are, and what they are used for.

SQL is for “structured” data. Data that is fairly predictable. So an entity such as persons address will generally always have the same fields (e.g. House number, street, city, postcode, country). This is generally best in SQL. It can be indexed, queried against, reported on, and stored in a relatively efficient manner.

However NoSQL is very good for unstructured data. Typically “Big data” is unstructured because of the range of information that it can contain. Big data could be a full credit report which may be provided in XML or JSON and contain thousands of columns if imported into a SQL database. This table would become unmanageable wide and be inefficient to maintain. Also the structure of data like credit reports can change often leading to updates to your table, indexes, procedures, triggers, application code, reports etc etc etc.

Other unstructured data could be the finger tap pattern when tracking how a person navigates around an app or website on their phone. This is nearly impossible to get into a structured format efficiently and without diluting the richness of the data.

These types of big data very quickly become very large collections of data, and expensive to store on a SQL database system in their raw format.

NoSQL provides a method of querying this data and interrogating it.

Very often (in my experience) NoSQL is used for exploratory work to understand the data manually, or to extract specific information out of big data into a data warehouse where SQL is again used. There are other uses which would only use NoSQL but generally NoSQL and SQL would be used in my systems for very different purposes.

So at the moment SQL is still popular. NoSQL HAS specific benefits for specific applications, but for a typical transactional database, SQL is still very popular.

Having said that, NoSQL is a much less mature technology, and exciting developments come up often, so who knows what the future will hold…