Posts

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.

What is sharding? @Alexander Lielacher

What Is Sharding?

 by 

What Is Sharding?

Sharding is a concept in database design, and as implied by its name, sharding involves creating smaller parts from a larger one. In the context of databases, sharding results in the creation of smaller partitions in the ledger. These partitions are thus referred to as shards.

It is important to note that in sharding, the partitioning is done horizontally as opposed to vertically. A shard may contain data that is in all the other shards; however, these partitions are designed to include data that is accessible only through it, which means that the data in each shard is unique to it. To access the data and use it, one must queue the specific shard that contains said data.

Sharding is employed in database architecture because it can improve the performance of a database or search engine. The design tool does this because it reduces the index size of a ledger. As a result, the ledger can provide search results quicker. Additionally, because different shards can be stored on different servers, the tool can be beneficial for large corporations with large data sets that they need to store separately such as multinational corporations operating in different countries.

Sharding in Distributed Ledgers

Sharding has grown in popularity within the cryptocurrency community as a result of widespread concerns over blockchain scalability issues. For instance, the Bitcoin Network processes about seven transactions per second, and Ethereum is only slightly faster, handling around 15 operations per second. These are both paltry compared to large payment processors like Visa and Mastercard.

While the bitcoin community has dealt with its scaling issues in various ways, the Ethereum project has outlined a more streamlined approach to solving its scalability concerns. Ethereum’s approach involves switching to a Proof of Stake (PoS) algorithm, which will work in tandem with a sharded database design.

How Would Sharding Work on Ethereum?

During his keynote speech at an event held at the School of Business of the Singapore University of Social Sciences, Ethereum’s cocreator Vitalik Buterin attempted to explain the concept of sharding the Ethereum ledger in a straightforward manner. In his talk entitled “The Road Ahead,” he stated:

“Imagine that Ethereum has been split into thousands of islands. Each island can do its own thing. Each of the islands has its own unique features and everyone belonging on that island, i.e., the accounts, can interact with each other and they can freely indulge in all its features. If they want to contact with other islands, they will have to use some sort of protocol.”

Currently, on the Ethereum network, as well as other blockchains, each node stores the global state. The globals state refers to the account balances, contract code and storage and all additional relevant information. Additionally, all nodes process all transactions. While this provides for a very secure ledger, it dramatically limits to what extent the network can scale because, within this design, a blockchain is only as good as a single node on its network.

In other words, the speed of a blockchain is defined by how quick a single node is as all nodes must perform the same transaction over and over.

Altibase can be used as a persistent cache and is open source. Thus, there is no need to purchase separate caching solutions

How does Altibase perform as a persistent cache?

Aug. 23. 2018

Altibase can be utilized as a persistent in-memory cache which eliminates common issues associated with commercial caching solutions.

The following case studies include related stories.

Caching is a good strategy to use when specific query results need to be returned quickly. However, using this method does not give full flexibility for increasing performance amongst all data and operations:

  • Caching is only useful for common read operations; any DML (INSERT, UPDATE, and DELETE) that is executed will run at low, disk-based speeds. When used in an in-memory only mode, Altibase stores all data in memory, so any query that is run on the data will perform at cached speeds, including DML.
  • Unlike many commercial caching solutions, Altibase does not lose data when shut down or restarted. Altibase adheres to full, real time ACID compliance that guarantees data durability. Altibase’s persistent cache is a default setting, and can recover all data without any issues.
  • Since Altibase combines an in-memory database and an on-disk database in a single unified database, strict durability is possible and so is complete data durability.
  • Altibase provides MOVE technology, allowing DBAs to decide which sets of data should be high-speed and which are designated for long-term storage.
  • Altibase is a single database solution that meets all needs in any use case. With persistent in-memory and on-disk in a single database, flexibility and data integrity are given. With Altibase, there is no need to purchase separate caching solutions.

Representative Use Cases That Can Take Advantage of Altibase’s Persistent Cache Solution?

Any business that needs high performance can take advantage of it instantly:

  • Risk Management
  • Fraud Detection
  • Security Intelligence
  • Supply Chain Tracking
  • Telecom/Media Revenue Leakage
  • Service Delivery
  • Online Gaming
  • Inventory Forecasting
  • Transportation Operation Management
  • Software-as-a-Service
  • Real time Analytics
  • Profitability Analysis
  • Global Web Commerce
  • Sales Incentive Promotions Management

Altibase – Downloading is Believing.

SK telecom with over 26 million subscribers utilizes Altibase as a front-end to Oracle for higher performance and lower TCO

A Telco With Over 26 Million Subscribers Utilizes Altibase as a Front End to Oracle for Higher Performance and Lower Database-Related TCO

The telco’s use case epitomizes Altibase’s compatibility with Oracle: Altibase can replace Oracle or can interoperate with Oracle when replacement of all Oracle databases is not feasible.

The cost savings are manifesting greatly as Altibase is now open source.

NEW YORKAug. 13, 2018 /PRNewswire/ — The telco is the largest mobile service provider in Korea with 26 million subscribers.

Before the telco chose to deploy Altibase, it had been adopting Oracle on a legacy mainframe-based IT infrastructure for its real time rating system. However, it identified the following limitations of its legacy DBMS:

  • Its billing service suffered from major delays as the number of subscribers grew substantially.
  • With growing demands on the legacy system, database-related TCO became progressively onerous.
  • The company was unable to detect and shut off service when prepaid balances were depleted.
  • The inability to accurately detect customer balances resulted in negative balances and uncollectible funds.

The company tested various databases and eventually chose Altibase. Altibase was used as a front-end to Oracle, which was used for hosting historical data with a view to enhancing the performance and lowering database-related TCO. The results are:

  • It has been able to precisely check and act on customer balances.
  • It was enabled to process customer usage on a per-second basis.
  • Revenue losses resulting from undetectable free usage and uncollected negative balances were eliminated.
  • It has the ability to efficiently integrate billing services for subscribers using multiple services.
  • Customers can have access to their balances in real time and without error.
  • It replaced an aging and expensive mainframe-based legacy system with an open UNIX platform, which resulted in lower TCO.
  • Most importantly, it was able to reduce its reliance on Oracle and to achieve higher performance with lower TCO.

Altibase is a hybrid database which can be utilized in a hybrid, in-memory only or on-disk only mode.

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

Contact:
Paul Nahm
Chairman
40 Wall St. 28th Fl.
New York, NY 10005
1-888-837-7333 X901

CisionView original content with multimedia:http://www.prnewswire.com/news-releases/a-telco-with-over-26-million-subscribers-utilizes-altibase-as-a-front-end-to-oracle-for-higher-performance-and-lower-database-related-tco-300695383.html

SOURCE Altibase

10 In-Memory Database Options Power Speedy Performance

10 In-Memory Database Options Power Speedy Performance

From Altibase to VoltDB, and covering options from IBM, Microsoft, Oracle, and SAP, we wrap up leading in-memory databases and add-on options. When you need speed, here are 10 tools to choose.

Altibase offers two in-memory options 
Product description: Altibase HDB is a hybrid database offering an in-memory tier, plus disk-based storage, blending the benefits of RAM speed and disk economy. Altibase XDB is the 'extreme' in-memory pure-play database, said by the vendor to handle up to 1.5 million transactions per second. 

Notable customers: Korea Telecom, Hewlett Packard, Samsung Company status: Private; founded 1991 

Comment: Altibase is a 20-plus-year-old Korean company that is among the pioneers of in-memory technology. Altibase is best known in the Asian market, but it's gaining customers in North America through offices in Fort Lee, N.J., and Palo Alto, Calif. The vendor's hybrid HDB supports transactional and analytic decisions with an ability to blend hot data in RAM and cooler, historical data on disk. The purely in-memory XDB extreme database is aimed at ultra-high-throughput applications seen in telecom, financial, manufacturing, and Internet-of-things applications.

Altibase offers two in-memory options
Product description: Altibase HDB is a hybrid database offering an in-memory tier, plus disk-based storage, blending the benefits of RAM speed and disk economy. Altibase XDB is the “extreme” in-memory pure-play database, said by the vendor to handle up to 1.5 million transactions per second.
Notable customers: Korea Telecom, Hewlett Packard, Samsung
Company status: Private; founded 1991

Comment: Altibase is a 20-plus-year-old Korean company that is among the pioneers of in-memory technology. Altibase is best known in the Asian market, but it’s gaining customers in North America through offices in Fort Lee, N.J., and Palo Alto, Calif. The vendor’s hybrid HDB supports transactional and analytic decisions with an ability to blend hot data in RAM and cooler, historical data on disk. The purely in-memory XDB extreme database is aimed at ultra-high-throughput applications seen in telecom, financial, manufacturing, and Internet-of-things applications.

2 of 12