Altibase

Hybrid database, relational open source database management system
Altibase
ALTIBASE | Mission-Critical Succeed
Developer(s)Altibase Corporation
Initial release2000 (2000)
Stable release
v7.3, 2023 / August 31, 2023; 7 months ago (2023-08-31)[1]
Repositoryhttps://github.com/ALTIBASE/
Operating systemAIX, HP-UX, Linux
Available inEnglish
TypeDatabase Management System, RDBMS
LicenseProprietary
WebsiteAltibase

Altibase is a hybrid database, Relational database management system manufactured by the Altibase Corporation. The software's hybrid architecture allows it to access both memory-resident and disk-resident tables using single interface. It supports both synchronous and asynchronous replication and offers real-time ACID compliance. Support is also offered for a variety of SQL standards and programming languages. Other important capabilities include data import and export, data encryption for security, multiple data access command sets, materialized view and temporary tables, and others.[2]

History

From 1991 through 1997 the Mr. RT project was an in-memory database research project, conducted by the Electronics and Telecommunications Research Institute a government-funded research organization in South Korea.[3] Altibase was incorporated in 1999.[3]

Altibase acquired an in-memory database engine from the Electronics and Telecommunications Research Institute in February 2000, and commercialized the database in October of the same year.[4] In 2001, Altibase changed the name of the in-memory database product from "Spiner" to "Altibase" in 2001.[5] In 2004, Altibase integrated the in-memory database with a disk-resident database to create a hybrid DBMS, released version 4.0 and renamed it as ALTIBASE HDB.[6][7] Altibase released version 5.5.1 and 6.1.1 in 2012, version 6.3.1 in November 2013, and 6.5.1 in May 2015.[8] Altibase claims that this is the world's first hybrid DBMS[citation needed]. Altibase released its open source edition version 7.1, however, closed the source in 2023.

In August 2023, Altibase released its cloud-optimized version 7.3.

Awards

  • In 2006, Received the Presidential Award at the Korea Software Awards
  • In 2007, Selected as World-Class Product by the Ministry of Commerce, Industry and Energy
  • In 2009, Awarded the Outstanding Product Award in China's Telecommunications Industry
  • In 2009, Received Outstanding Product Award at the China Billing China 2009 Telecommunication Industry Awards
  • In 2010, Commendation from the Minister of Knowledge Economy for Technological Practicalization
  • In 2011, Received the Grand Prize at the 10th Software Enterprise Competitiveness Award[9]
  • In 2011, Selected as Top 10 Emerging Technologies and received Special Award at the Korea Technology Grand Prize
  • In 2012, Awarded for Contributions to Military Manpower Administration
  • In 2014~2016, Included in Gartner Magic Quadrant for Operational DBMS[10]
  • In 2015, Selected as Outstanding BSS by China Fujian Mobile.[11]
  • In 2023, Awarded as the Excellent Research and Development Institution by the Korean Ministry Science and ICT[12]
  • In 2023, Won the Global Premium Commercial Software Presidential Award at the 9th Global Commercial Software Grand Exhibition in Korea[13]

Release

The first version, called Spiner, was released in 2000 for commercial use. It took half of the in-memory DBMS market share in South Korea.[14]

In 2002 the second version was released renamed to Altibase v2.0. By 2003, Altibase v3.0 was released[15] and it entered the Chinese market.[16] Released version 4.0 with hybrid architecture, combining RAM and disk databases, was released in 2004.[17]

In 2005 Altibase began working with Chinese telecommunications providers for billing systems,[18] and some financial companies in Taiwan, China, for home trading systems.[19] The software was certified by the Telecommunications Technology Association.[20] The Ministry of Government Administration and Home Affairs gave it an award in 2006.[21] Offices in China and United States opened in 2009.[6]

In 2011, version 5.5.1 was renamed it to HDB (for "hybrid database"). The Altibase Data Stream product for complex event processing was renamed DSM.[22] The product received a Korean technology award.[23] Altibase introduced certification services.[24] In 2012, HDB Zeta and Extreme were announced, and DSM renamed to CEP.[25]

In 2013, yet another variant called XDB was announced,[26] and the company received ISO/IEC 20000 certification.[27] In 2018, Altibase went open source.

Altibase went open source in February, 2018. Altibase Corp has made the decision to discontinue the Altibase 7.1 open source edition, effective March 17, 2023. As a result, the open-source edition of Altibase 7.1 will no longer be available for download or use. Altibase released version 7.3 in September, 2023, with is notable feature is the world’s first hybrid partition, allowing data to be stored in both memory and on disk at the partition level. Version 7.3 also added parallel processing capabilities for high-speed performance in both partitioned and non-partitioned scenarios. Improving potential bottlenecks associated with Commit and logging that impact transaction performance, version 7.3 has achieved an approximately 490% enhancement in performance compared to previous versions.[28][29]

Release history

Release Release date Latest version Latest release date
Old version, no longer maintained: Altibase v3 March 2003; 21 years ago (2003-03) 3.5.7.24 2004-09-03
Old version, no longer maintained: Altibase v4 April 2005; 19 years ago (2005-04) 4.3.9.236 2017-10-23
Old version, no longer maintained: Altibase v5.1.X October 2007; 16 years ago (2007-10) 5.1.5.119 2017-12-06
Old version, no longer maintained: Altibase v5.3.X October 2009; 14 years ago (2009-10) 5.3.5.48 2019-08-13
Old version, no longer maintained: Altibase v5.5.1 February 2011; 13 years ago (2011-02) 5.5.1.8.1 2021-03-19
Old version, no longer maintained: Altibase v6.1.1 April 2012; 12 years ago (2012-04) 6.1.1.10.5 2023-09-08
Old version, no longer maintained: Altibase v6.3.1 October 2013; 10 years ago (2013-10) 6.3.1.12.5 2022-08-10
Old version, no longer maintained: Altibase v6.5.1 June 2015; 8 years ago (2015-06) 6.5.1.10.0 2023-12-11
Older version, yet still maintained: Altibase v7.1 July 2017; 6 years ago (2017-07) 7.1.1.9.2 2023-12-21
Current stable version: Altibase v7.3 August 2023; 8 months ago (2023-08) 7.3.0.0.3 2023-12-14
Legend:
Old version
Older version, still maintained
Latest version
Latest preview version
Future release

Clients

According to marketing research, Altibase have over 700 customers and more than 8,000 of installations and deployments, including 22 Fortune Global 500 Companies.[30]

Altibase's clients in the telecommunications, financial services, manufacturing, and utilities sectors include Bloomberg, AT&T, LG, Intel, LGU+, E*TRADE, HP, UAT Inc., POSCO, SK Telecom, KT Corporation,, Samsung Electronics, Shinhan Bank, Woori Bank, Canon(Toshiba), Hanhwa, The South Korean Ministry of Defense, G-Market, CJ, and Chung-Ang University.[31][32]

Global Clients

  • Japan[33][34]
    • FX Prime, a foreign exchange services company
    • Retela Crea Securities
  • United States[35]
    • AT&T
      • Implemented Altibase for its PS-LTE Safety network, where the Presence service plays a vital role.
      • This service handles the reception and storage of user information, conducting real-time checks for online presence and location as needed.
  • Canada[36]
    • Telus
      • One of the major telecommunication companies.
      • Utilizes Altibase for its operations involving real-time user management, processing high volumes of dedicated terminal data, and managing real-time location information (GIS) for terminals.
      • Altibase contributes to the company's in-house solution for maintaining uninterrupted services during national disasters or similar situations, ensuring efficiency and reliability.
  • China[37]
  • Turkish[38]
    • Ziraat Bank, Halk Bank, Deniz Bank, Garanti BBVA, TEB, Oyak Bank, QNB, Burgan Bank, and others.
      • In 2018, Altibase entered the market through a partnership with ATP-Tradesoft, a subsidiary of Ata Holdings. Collaborating with ATP-Tradesoft.
      • Altibase integrated into the Online Trading System XFront.
      • This integration was well-received by major financial institutions and securities firms in Turkey.
      • Altibase is currently implemented in the XFront Online Trading System, used by 13 significant financial institutions and banks in the Turkey.
  • Thailand
    • Bualuang Securities
      • Altibase has been supplied its DBMS to support the construction of the online stock trading platform.
  • Mongolia[39]
    • MobiCom
      • The Mongolian telecommunication giant, has adopted Altibase’s 7.0 version for its mobile platform for storing the infrequently used data.
  • Azerbaijan[40]
    • M1 highway
      • Altibase has been supplied as the Database Management System (DBMS) for the electronic toll collection system.
      • One of the most crucial transportation networks in the country.
  • India

Industries

Features

ALTIBASE is a so-called "hybrid DBMS", meaning that it simultaneously supports access to both memory-resident and disk-resident tables via a single interface.[2] It is compatible with Solaris, HP-UX, AIX, Linux, and Windows. It supports the complete SQL standard, features Multiversion concurrency control (MVCC), implements Fuzzy and Ping-Pong Checkpointing for periodically backing up memory-resident data, and ships with Replication and Database Link functionality.[2]

  • High performance, large -capacity service
    • Fast real-time data processing and large amounts of data stable
    • Provide parallel processing architecture for large data management
    • Developed and provided Hybrid Partitioned Table function for efficiency according to data personality[42]
  • High stability
    • World's first hybrid database development
    • Strict quality management, Release Process Compliance and Stable technical support
  • Securing high availability, improving scalability
    • Altibase Replication function provides high-availability and high-performance real-time redundancy function
    • Introducing replication performance by introducing replication compression function, maximizing compression efficiency
    • Provide DR (Disaster Recovery) function for stable backup
    • Altibase Kubernetes Utility (AKU) provides Scale-Out and Scale-In convenience[28]
  • Compatibility, development convenience
    • Increasing convenience and productivity by providing a standard development interface perfectly
    • Link support with various MiddleWare and 3rd Party Tool

Supported Application Compatibility

  • Client Development Environment
    • ODBC
    • JDBC
    • SQLCLI
    • Embedded SQL(Pre-Compiler)
    • ADO.NET
    • unixODBC
  • Server Development Environment
    • SQL(SQL92)
    • Built-in Function
    • Stored Procedure & Functions
    • Views
    • Triggers

Tools and Utilities

Version-dependent Tools

Source:[8]

  • iSQL (Command line SQL Utility)
  • altiComp (Command line Comparing database Utility)
  • altiProfile (Command line Profiling database Utility)
  • altiMon (Command line Monitoring database Utility)
  • oraAdaptor (Data transfer for Oracle Utility)
  • Replication Manager (GUI Replication Utility)

Interoperability and Migration

Source:[8]

  • Migration Center (GUI Migration Utility)
  • aexport (Command line Migration Utility)
  • iLoader (Command line Data Import/Export Utility)

GUI Editor

  • DBeaver Community 23.3.3 (Altibase 3rd Party Connector Guide)
  • SQuirreL SQL Client (Altibase 3rd Party Connector Guide)
  • Orange for Altibase(GUI SQL Utility, WareValley)

References

  1. ^ "History for ReleaseNotes/Eng - ALTIBASE/Documents". GitHub. Retrieved 2024-01-25.
  2. ^ a b c "Administrator's Manual". Altibase Corporation. Retrieved May 29, 2015.
  3. ^ a b Kim, Sang-Bum (12 November 2003). "SW 플랫폼 시장의 새로운 기대주 알티베이스". inews24.com (in Korean).
  4. ^ Park, Hee-Bom. "기술이전 성공사례 (Technology Transfer Success Story)" etnews October 16, 2002. Retrieved August 7, 2012.
  5. ^ "주목 e기업 – 알티베이스 (Noteworthy e-Business: Altibase)" Digital Times February 7, 2011. Retrieved August 7, 2012.
  6. ^ a b Kang, Dong-Sik. "알티베이스, 증권시장 90% 점유 국산 DBMS 강자 (Altibase, Korean database powerhouse, occupies 90% of domestic securities database market)" Digital Times February 6, 2011. Retrieved August 7, 2012.
  7. ^ "About Altibase". Altibase. Retrieved 7 June 2016.
  8. ^ a b c "Release Notes".
  9. ^ www.etnews.com (2012-12-19). "[대한민국 SW 명가⑥] 알티베이스". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  10. ^ "[2019년 해외에서 인정받은 국산 데이터관리SW] 알티베이스". 아이티데일리 (in Korean). 2020-02-04. Retrieved 2024-01-26.
  11. ^ www.etnews.com (2019-03-25). "알티베이스, 차이나모바일 표준 DBMS 사업자로 낙점…차세대 빌링시스템 개발 상호 협력". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  12. ^ 남, 혁우 (10 January 2023). "알티베이스, 과기정통부 '우수 기업연구소' 지정". ZDNet Korea. p. 1. Retrieved 10 January 2023.
  13. ^ 남, 혁우 (2023-11-20). "알티베이스 V7.3, 글로벌 상용SW명품대전 협회장상 수상". ZDNet Korea. p. 1. Retrieved 2024-01-26.
  14. ^ Park, Hee-Bum (16 October 2002). "[IT테크노마트 2002]기술이전 성공사례". Electronic Times Internet.
  15. ^ Shin, Hye-Sun (31 March 2003). "알티베이스, 메인메모리DB 새 버전 출시". Electronic Times Internet (in Korean).
  16. ^ Lee, Eun-Yong (7 October 2003). "알티베이스, 중국 MMDBMS 시장 진출". Electronic Times Internet.
  17. ^ Choi, Sung Hoon (2 November 2004). "국내업체, 하이브리드DB 세계 첫 개발". CBS Interactive, Inc. (in Korean).
  18. ^ Cho, Sung-Hoon (January 24, 2005). "알티베이스, 차이나유니콤에 MMDBMS 공급". DigitalTimes (in Korean).
  19. ^ Chung, Jin Ok (February 16, 2005). "대만 증권사에 알티베이스 MMDBMS 진출". CBS Interactive Inc.
  20. ^ Yoon, Sung Gyu (12 September 2005). "알티베이스, 'ALTIBASE 4' GS 인증 획득". 디지털데일리.
  21. ^ Han, Jung-Hoon (7 April 2006). "[신소프트웨어상품대수상작]3월 수상작". Electronic Times Internet.
  22. ^ Chung, Gyung-Mi (January 26, 2011). "알티베이스, DBMS 신규버전 발표". IT Today.
  23. ^ Kim, Tae-Hyoung (December 9, 2011). "알티베이스, 2011 대한민국기술대상 특별상 수상". Boan News.
  24. ^ Sung, Hyun-Hee (July 12, 2011). "알티베이스, 전문가 양성위한 교육센터 확대 개편". etnews.
  25. ^ Kim, Su Yeon (April 12, 2012). "알티베이스 'HDB 제타로 빅데이터 라인업 스타트'". iNews 24.
  26. ^ Kim, Bong Yeon (June 13, 2013). "알티베이스, '알티베이스 XDB' 출시…"기존 제품 대비 10배 성능'". eNews Today.
  27. ^ Kim, Bong Yeon (April 26, 2013). "㈜알티베이스, 고객지원서비스관리 'ISO20000' 인증 획득". eNews Today.
  28. ^ a b "Features - Product - ALTIBASE". altibase.com. Retrieved 2024-02-02.
  29. ^ "알티베이스, '인메모리 DBMS 기술 제공' ALTIBASE V7.3 출시…"기업의 핵심 미션 수행 기대"". 매일경제 (in Korean). 2023-09-13. Retrieved 2024-01-26.
  30. ^ "Altibase References and Clients". Altibase Corp. January 24, 2024.
  31. ^ a b Choi, Donna. "Altibase, the Top Data Performance Solutions Provider" Archived 2014-01-16 at the Wayback Machine Advanced Technology Korea. June 1, 2012. Retrieved June 24, 2012.
  32. ^ a b Chun Go-eun. "Fastest, Most Efficient Databases Imaginable with Altibase" Korea IT Times Friday, August 26th, 2011. Retrieved June 24, 2012.
  33. ^ Lee, Sang-Il. "일본 IT시장, 새로운 먹거리로 떠오르나? (The IT industry in Japan: a promising new market?)" Digital Daily. May 31, 2011. Retrieved July 25, 2012.
  34. ^ 에드몬드 (Edmund). "알티베이스, 일본 증권사에 하이브리드 DBMS 공급 (Altibase provides DBMS for Japanese Securities Companies)" Daily Grid. November 5, 2010. Retrieved July 25, 2012.
  35. ^ www.etnews.com (2019-01-22). "토종 DBMS 알티베이스 미 AT&T 재난망서비스에 공급…제품 안정성 입증·TCO 탁월 인정". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  36. ^ "알티베이스, 미국과 캐나다에 본격 수출…"소프트웨어도 한류 열풍"". 매일경제 (in Korean). 2021-10-18. Retrieved 2024-01-26.
  37. ^ Kim, Kuk-bae. "글로벌 '성공신화' 꿈꾸는 국내SW 기업들 (Korean Software Companies with Global Aspirations)" inews24 July 1, 2012. Retrieved July 25, 2012.
  38. ^ www.etnews.com (2020-02-21). "알티베이스, 터키에 DBMS 두번째 구축 레퍼런스 확보…현지 파트너 원격기술 지원해 수주 성공". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  39. ^ Б.Анхтуяа (2020-04-10). "South Korean company to provide database solution to Mobicom - News.MN". News.MN - The source of news. Retrieved 2024-01-26.
  40. ^ www.etnews.com (2020-08-07). "알티베이스, 아제르바이잔 M1고속도로 전자요금징수시스템에 DBMS 공급". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  41. ^ www.etnews.com (2022-09-26). "알티베이스, 카카오페이증권 주식주문 시스템 DBMS로 선정". 미래를 보는 신문 - 전자신문 (in Korean). Retrieved 2024-01-26.
  42. ^ Corp, Altibase. "Altibase Becomes the World's First Company to Develop Hybrid Partitioned Table for Efficacy and Efficiency in Writing Database Programs". www.prnewswire.com (Press release). Retrieved 2024-01-26.