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.

Aug. 13. 2018

 

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

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.

A telco with over 250 million subscribers utilizes Altibase to implement real time billing with its prepaid services

A Telco With Over 250 Million Subscribers Utilizes Altibase to Implement Real Time Billing With its Prepaid Services

Altibase Was Chosen Over Oracle TimesTen and SolidDB

NEW YORKJuly 23, 2018 /PRNewswire/ — The telco is the third largest telecommunications provider in China with 250 million subscribers.

Historically, the company suffered from payment defaults and operational deficiencies for its online charging system. Those problems manifested themselves in three core areas.

1. Inability to effectively terminate service. The company was unable to identify and cut customer usage when prepaid balances were exhausted. Essentially, customers who chose to game the system would continue to talk for free until its systems “caught up.” The company’s legacy DBMS could not efficiently detect negative balances. Worse yet, losses shadowed increasing latency. The result was a vast amount of uncollectible receivables.

2. Inability to reinstate timely service.Unfortunately, customers who inadvertently exhausted their balances and subsequently paid their overages suffered as well. Limitations in its legacy DBMS speed prevented swift reactivation of service to these loyal customers. The result was a catastrophic loss of consumer confidence, customer satisfaction and, ultimately, retention.

3. Inability for customers to accurately check remaining balances. Since customers could not accurately check their current balances, they could not preemptively replenish their accounts. The balance information was stale, and loyal customers paid the price with defunct service.

The company tested various database products including Oracle TimesTen, soildDB and Altibase. It chose Altibase in 2010. Since then, the company has adopted Altibase in consideration of performance, reliability and functionality all with the underpinnings of a complete solution.

The results are:

  1. The company has the capacity to precisely check and act on balances.
  2. Its system latency was reduced, which corrected errors that some customers took advantage of.
  3. Outstanding balances, when paid, coincided with swift restoration of service.
  4. Customers can accurately check remaining balances, knowing when to reload funds.
  5. Customer satisfaction, loyalty, attraction and retention are maximized.
  6. Customer attrition is minimized.

After nearly 20 years as an enterprise grade closed source database, Altibase went open source in February this year.

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

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

What is a hybrid database?

WHAT IS A HYBRID DATABASE?

Jun 23, 2018

A hybrid database is a database management system that is a balanced database management system that offers high performance data processing in main memory with the vast storage capabilities of physical disk. A hybrid database has both in-memory database features and on-disk database features in a single unified engine. As a result, data can be stored and manipulated in main memory alone, on physical disk alone or a combination of both. The integrated combination of both database types allows for unrivaled flexibility and robust functionality.

Altibase was the first commercially available true hybrid database in the world and has served over 600 enterprise clients including 8 Fortune Global 500 companies since 1999. Altibase’s hybrid architecture allows for utilization of memory tables for high performance and disk tables for economical storage and consequently eliminates the need to purchase an in-memory database and a disk resident database seperately.

Working in a true hybrid environment provides significant benefits over both in-memory and disk-resident databases.

To fully understand why, it is important to understand the respective benefits of in-memory and disk-resident databases.

In-memory databases are almost always significantly faster than any disk-resident database. In addition, the fact that data resides directly in RAM means that response times and latency are extremely low (microsecond scale). However, the downside is that RAM is significantly more expensive than traditional hard disks, and also has smaller storage capacity.

In contrast, disk-resident databases generally have fairly poor performance. This is because disk I/O is very expensive, and the architecture of the database often spends a lot of CPU resources optimizing disk access patterns. However, disk-resident databases have immense storage capacity and this storage is fairly cheap.

This is why a hybrid engine is so attractive. By combining an in-memory database and a disk-resident database into one solution, you effectively get all the benefits and eliminate all the disadvantages. Need high performance? Use memory tables. Need lots of storage? Use disk tables.

Other database solutions try to emulate this architecture, sometimes by using a different IMDB as a caching layer for their disk database. But the implementation is often complex, buggy and expensive due to the need to maintain multiple disparate database licenses.

With Altibase, you get all of these advantages in one easy-to-use solution. In addition, the engine is truly unified in the sense that you can perform operations such as joins between memory tables and disk tables without issues.

This functionality is at the heart of why Altibase has so many satisfied customers worldwide. The following case studies have hybrid architecture usages of Altibase.

  • Automated Taxi Dispatch Service – KOREA Transportation Safety Authority (TS) : operations for memory tables and disk tables without any additional solutions
  • Smart City Project – A Small Provincial City : Altibase’s hybrid mode avoided extra license and maintenance fees.

Altibase – Downloading is Believing.

SUPERIOR DEPLOYMENT FLEXIBILITY

SUPERIOR DEPLOYMENT FLEXIBILITY

Combines the benefits of in-memory speed
and on-disk storage in a single relational database

Support for Varied Workloads

  • Real time access to time critical hot data
  • Access to historical data for audit or analytics
  • Complex transactions through integrated data
  • Easy bidirectional data movement between memory and disk tables
  • Joins between memory and disk tables

Flexible Deployment Mode

  • In-memory only
  • On-disk only
  • Hybrid (memory and disk tables)

HIGHLY AVAILABLE HYBRID DATABASE

Replication: Built-in Feature

HIGHLY AVAILABLE IN-MEMORY DATABASE
  • Log-based, TCP/IP replication
  • Additional layer of durability
  • Adaptive consistency (Synchronous vs. Asynchronous)
  • Non-stop service architecture (Active-Active vs. Active-Standby)
  • Near standalone replication performance
  • 96% Active-Standby
  • Near linear async scaling
  • Conflict detection and resolution
  • Flexible load balancing strategy

FAMILIAR PROGRAMMING INTERFACES

Robust Driver Set

  • ODBC
  • JDBC
  • .NET & Entity Framework
  • OLEDB
  • Embedded SQL
  • CLI
  • Perl DBD
  • PHP

Support for Common Communication Protocols

  • TCP/IP (IPv4 and IPv6)
  • Unix Domain Socket
  • IPC
FAMILIAR PROGRAMMING INTERFACES
A RICH SET OF TOOLS AND UTILITIES

A RICH SET OF TOOLS AND UTILITIES

Productivity and Administration

  • iSQL (Command line SQL Utility)
  • Orange for Altibase(GUI SQL Utility, WareValley )
  • Replication Manager (GUI Replication Utility )
  • altiComp (Command line Comparing database Utility )
  • altiProfile (Command line  Profiling database Utility)
  • altiMon (Command line  Monitoring database Utility)

Interoperability and Migration

  • Migration Center (GUI Migration Utility)
  • aExport (Command line Migration Utility )
  • iLoader (Command line Data Import/Export Utility )
  • oraAdaptor (Data transfer for Oracle Utility)

OPEN PLATFORM HYBRID DATABASE

Linux

IBM AIX

Sun Solaris

HP HP-UX

Microsoft Windows

Police agency utilizes Altibase’s hybrid DB to cross

Police Agency Utilizes Altibase’s Hybrid Database to Cross-Reference and Apprehend Criminals More Quickly and Accurately

NEWS PROVIDED BY

Altibase Corp. 

Jun 25, 2018, 08:45 ET

Untitled design (7)

NEW YORKJune 25, 2018 /PRNewswire/ — Altibase announced that it provides the Korean National Police Agency with its database technologies to meet the specific needs of the agency.

The Korean National Police Agency monitors, investigates and fights crimes for over 51 million citizens.

The agency has needed to enhance its existing finger and palm identification system. The ability to utilize fresh finger and palm prints at the crime scene and couple them with historical data is critical for swift and positive apprehension.

After a series of BMTs of various database vendors, Altibase was chosen.

In choosing Altibase, the agency took the following factors into consideration:

1. Hybrid Architecture. Altibase’s hybrid architecture, combining the power of real time speed with massive storage capacity, proves to be the perfect solution for cross-referencing historical data with live ones.

2. Cost. The agency did not have to purchase disk-resident databases separately to store huge amounts of rarely accessed historical data.

3. In-Memory Capabilities. Altibase’s in-memory features enable the agency to have real time access to all data with complete transparency nationwide.

4. Implementation Costs. Altibase is relational and ACID and SQL compliant, and the agency had no difficulty in migrating data from other legacy DBMSs to Altibase.

5. DBA Costs. The agency did not need to hire new DBAs or retrain existing DBA resources to handle completely different database paradigms such as NoSQL.

6. Built-In Replication. Altibase’s built-in replication provides the agency with non-stop service and unfaltering reliability with strong fail-safe capabilities at no extra cost. Other DBMSs vendors used to charge the agency for replication functionality separately.

Since 2013, the agency has adopted Altibase for various other core systems to further fight crime.

After nearly 20 years as an enterprise grade closed source database, Altibase went open source in February this year.

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

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

SOURCE Altibase Corp.

Related Links

https://altibase.com