New Search

If you are not happy with the results below please do another search

25 search results for:


What is hybrid partitioned table?

Altibase is the world’s first company to develop hybrid partitioned table. A hybrid partitioned table is a table that is partitioned in a way that data can be effectively and efficiently segregated and stored in corresponding storage mediums according to the temperature of the data in a hybrid database. The purpose is to allow for […]


What is online sharding?

Sharding refers to an architecture where data is distributed across commodity (cheap) computers. Sharding, or scale-out, compares favorably to scale-up which requires to replace existing servers with powerful but very expensive servers in dealing with very large data sets. The former is usually executed at a small fraction of the latter. When more processing capacity […]


How does Altibase compare to Oracle, SAP Hana and IBM DB2?

Altibase matches Oracle and other legacy DBMSs function for function except that Altibase is open source. Altibase provides rich sets of feature and function and great reliability. Since 1999, Altibase has served over 650 global enterprises including 9 Fortune Global 500 companies. There are no license costs with Altibase. Altibase is a freely downloadable DBMS […]


How does Altibase replication compare to Oracle Real Application Cluster (RAC)?

Altibase replication and Oracle RAC are similar in that they both can be used to enable high availability architectures. However, there are some fundamental differences. One of the most obvious differences is that Oracle RAC uses a shared-storage architecture whereas Altibase replication is shared-nothing. While each architecture has advantages and disadvantages, one of the main […]


How does Altibase compare to Oracle’s database buffer cache?

Altibase is significantly faster than Oracle buffer cache because: Altibase accesses a record directly by an operating system providing native memory pointer whereas Oracle accesses a record indirectly through a logical Row ID (RID). With an RID Oracle has to go through a buffer manager, a buffer page and a position of the record in the buffer page. The net result […]


Can Altibase interoperate with Oracle’s on-disk databases?

Yes. Many of our clients employ architectures utilizing Altibase for improved performance while simultaneously using Oracle as the primary data store. For use cases where replacement of all Oracle databases is not feasible, this method provides the optimal balance of performance, cost savings and implementation simplicity. Altibase provides OraAdapter, which is essentially a database link […]


How does Altibase compare to Oracle TimesTen and other in-memory databases?

Altibase provides superior performance in comparison to Oracle TimesTen and other in-memory DBMSs. Representative examples include 99.999% HA, horizontal and vertical scalability, hybrid DB technology and more. When compared against Oracle TimesTen, Altibase excels in overall performance and especially in complex queries and is more stable in system failure situations with its data durability. Altibase […]


How does Altibase compare to MariaDB, PostgreSQL and EnterpriseDB?

  Altibase is an open source database and is enterprise grade. Altibase is a time-tested and proven DBMS. Altibase has 20 years of experience in producing, selling and supporting DBMS solutions for over 650 enterprise clients including 9 of Fortune Global 500 companies. Altibase is a most reliable DBMS. Altibase has been deployed exclusively for […]


How does Altibase compare to NoSQL?

Altibase provides real time ACID and SQL compliance whereas NoSQL does not support these features. Other shortcomings of NoSQL: NoSQL is not a relational database and often does not support ACID, SQL and standard interfaces. NoSQL is not designed to store structured data and is prone to data loss. It is difficult to prevent data duplication […]


Can Altibase be deployed for mission critical systems?

Altibase has 20 years of experience in producing, selling and supporting mature DBMS solutions for over 650 enterprise clients including 9 Fortune Global 500 companies. Altibase has been deployed in over 6,000 mission critical applications where mere minutes of downtime could translate into huge financial and litigation-related losses. Altibase provides and adheres to strict technical […]


How does Altibase handle disaster recovery?

What if your system goes down? With Altibase, there is no need to worry. Altibase provides a time-proven solution that prevents database/server downtime and virtually eliminates the potentially negative effects of system outages. For today’s enterprise businesses, 100% database uptime is essential. At the core of IT, should a database/server go down unexpectedly, the consequences […]


Does Altibase support data partitioning?

Yes. Data partitioning is the division of a large database object into several small pieces for easier management of very large data sets. Objects can be partitioned in three ways: list, range and hash. Altibase’s Partitioning Technology These three ways of partitioning can be selectively used according to data size, data type, data usage, data […]


Does Altibase support vertical and horizontal scaling?

Altibase can scale vertically and horizontally without any issues. Altibase can automatically account for the addition of new RAM and faster processors. In doing so, there will be an immediate performance increase. Altibase also can scale out horizontally via sharding. Please refer to the manual “Altibase Sharding Guide” for further information. Vertical Scaling Altibase’s products are […]


How does Altibase enhance data security?

Data security can only be achieved by a holistic approach. Altibase provides strict data security covering all aspects of its products with extreme speed of in-memory database. Representative data security related features are its secure communication support, Audit SQL support and standard integration method support for 3rd party encryption solutions. Altibase also provides various additional security related features such as policy based […]


How does Altibase perform as a persistent cache?

With Altibase, there is no need to purchase separate caching solutions. 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. Global Cloud Authentication Service – Samsung Electronics : Altibase is used instead of Oracle Coherence. Yield Management System – Samsung Electronics […]


How does Altibase prevent data loss?

Altibase provides multiple durability[1] levels so that a user can select an optimal durability with consideration of its business. For example, Altibase Enhanced Durability level guarantees no data loss with abnormal DBMS shutdown while Altibase Strict Durability level recovers 100% data without any data loss even with abnormal hardware shutdown including power failure. Durability depends […]


How does Altibase cope with storage limitations?

Unlike other in-memory databases, Altibase leverages its hybrid architecture to eliminate limitations experienced by other in-memory database vendors. Altibase can store data in memory, on disk or a combination of both. Altibase stores data according to the temperature of the data. Cold data (historical data) is stored on disk and hot data (frequently used data) is […]


What are the benefits of Altibase’s hybrid architecture?

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 the data resides directly in RAM means […]


Does Altibase support standard SQL and other interfaces?

Yes, Altibase supports SQL-92 and SQL:1999 as well as other SQL provided by other DBMSs. Furthermore, Altibase provides high compatibility with standard interfaces. As an SQL compliant DBMS, Altibase enables its customers to utilize a readily available pool of application developers and administrators at low cost. SQL Function Altibase Oracle SAP HANA IBM DB2 Hint […]


Does Altibase have its own tools for database management and monitoring?

Yes. Altibase has many tools used for SQL execution, migration, replication management, monitoring, query analysis, etc. Category Utility Notes Interactive SQL & OEM Tool Orange, iSQL -Executes all the management functions in Altibase DBMSs -Information about table schemas, users, locks, connection statuses and transactions Migration Tool iLoader, dataport, Aexport, Migration  Center -iLoader saves the data in […]


How does Altibase back up data?

Altibase supports online, offline and utility backup solutions to prevent unexpected disasters such as data loss, data corruption, storage failure, etc. Backup Categories Category Description Backup/Recovery Object Notes Online Backup Real Time Backup Mode Database, Tablespaces, Loganchor Files  Full backup, Incremental backup Offline Backup Manual Backup Mode Database, Tablespaces, Loganchor Files Utility Backup Tool Based […]


Does Altibase support Business Intelligence (BI) solutions?

Yes. Altibase can be used for real time Data Marts in BI solutions for analytical purposes. Altibase has competed with other in-memory databases. The following case studies include related stories. Yield Management System – Samsung Electronics : TIBCO Spotfire is integrated with Altibase as a business intelligence tool for this task. Business Intelligence System – Dongwon F&B : Collect […]


Can the same performance be achieved by using cache solutions?

No. 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 data does not give quick performance for every SELECT query; only the ones that an algorithm determines. Additionally, caching is […]


Which platforms does Altibase support?

Platforms and Specifications OS CPU OS Version Notes AIX PowerPC, 64bit 6.1 TL3 6.1 TL9 7.1 HP-UX IA64, 64bit 11.31 Linux X86, 64bit Redhat 6.x, 7.x CentOS 6.8, 7 Oracle Linux 6.5, 6.6, 7.1 glibc(2.12~2.20) Linux Power7,8, 64bit Redhat 6.5, 7.x glibc(2.12~2.20), big endian Linux Power8(LE), 64bit Redhat 7.2 glibc(2.12~2.20), little endian Altibase – Downloading […]


Is it safe to use Altibase with regard to Intellectual Property?

Yes. It is completely safe to use all Altibase products as they are 100% free of any IP infringement. You are very well protected when using Altibase. Intellectual property is an increasingly important area of concern when making a software purchase. If you are selling/using a software solution that uses an infringing database, you may be […]