Posts

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.

Altibase offers an automation tool, Migration Center, that easily migrates various data objects from Oracle to Altibase to ensure 100% data integrity and consistency

How does Altibase migrate data from legacy systems?

Aug 20, 2018

Altibase offers an automation tool: Migration Center. It migrates various kinds of data objects from sources to target databases and ensures 100% data integrity and consistency.

Migration Center

Migration Center is a database migration tool that copies compatible database objects and data from other databases to Altibase. Manual tasks of database migration are complicated, time-consuming and prone to human error. Migration Center helps users to process database migration with a few mouse clicks in the Graphic User Interface (GUI) mode. It also supports the execution of migration using a Command Line Interface (CLI) mode.

Internal Process of Migration Center

  • Define database source and target:
    • Source and target database IP addresses and ports
    • Source and target user ID, password, JDBC driver, character set encoding, etc.
  •  Define data objects to migrate:
    • Source and target data objects information: table, column, index, view, procedure, etc.
  • Define migration options:
    • Selection of options: Thread count, batch size, etc.
    • Selection of migration scope: User mode and table mode
    • Data type mapping
    • Tablespace mapping
    • Stored procedure converting
    • DDL Modification
  • Validate migration rules
  •  Execute migration via rules
  •  Review the report files
    •  RunReport4Summary.html: the summary report file that provides the overall result of migration
    • RunReport4Missing.html: the report file that provides the list of data objects which were not migrated properly
    • DbObj_Failed.sql: the list of failed SQL commands and the cause of each failure

Migration Center Advantages

  • Easy and simple migration from other DBMSs to Altibase
  • Flexible mapping of different types of data objects
  • Migration summary report to review the migration result
  • High performance parallel migration
  • Manual rule modification

Migration Center Specifications

Source Databases

  • Altibase 4.3.9 or high version
  • Oracle 9i ~ 11g
  • Timesten 7 ~ 11
  • SQL Server 2005 ~ 2012
  • MySQL 5.0 ~ 5.5
  • Informix 11.50
  • CUBRID: 8.4.1~9.3.5(ISO-8859-1, UTF-8 charset)

Target Database

  • Altibase 5.5.1 or higher version

GUI Tool

  • JRE : Sun or IBM Java 5 or higher
  • Processor: 800MHz Pentium III or better
  • Memory: 512MB or more
  • Disk: 150MB or more free space
  • Screen resolution: 1024 x 768 pixels or greater
  • OS graphic library

CLI Tool

  • JRE : Sun or IBM Java 5 or higher
  • Processor: 1 CPU or more
  • Memory: 512MB or more
  • Disk: 150MB or more free space

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://13.124.221.141.

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

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 http://13.124.221.141.

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