Product
-
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 could be disastrous. If critical data cannot be accessed due to an application or database failure, the enterprise is forced to overcome damages to productivity, product/service quality, customer satisfaction, and ultimately the bottom line. Unexpected downtime of a database/server negatively impacts enterprises each and every day.Altibase provides non-stop HA solutions to customers with its disaster recovery solution that has features of in-memory based real time replication for synchronous/asynchronous data duplication and in-memory based real time backup and recovery.Altibase Provides Non-Stop HA Disaster Recovery Solutions via:In-memory databasesReal time replicationReal time backup/recoveryIn-Memory DatabaseAltibase with its hybrid architecture combines the extreme speed of an in-memory database with the storage capacity of an on-disk database in a single unified engine. Altibase provides over 10 times faster processing ability than traditional on-disk databases such as Oracle, SQL Server, and IBM DB2. Altibase disaster recovery solution provides processing speed 5 times faster than other traditional on-disk databases in replication and backup/recovery.Real Time ReplicationAltibase features real time replication for synchronous/asynchronous data duplication. Replication provides non-stop HA service to mitigate database server, storage server, or network switch failures. Altibase provides two types of replication modes: synchronous for high integrity and asynchronous for high speed.Altibase supports 10,240 replication nodes whereas Oracle only supports 32 nodes.Altibase provides the fastest data replication based on in-memory computing through high speed of parallel replication.Altibase provides heterogeneous database replication to Oracle, Microsoft, and other DBMSs, including Altibase via Altibase Log Analyzer.Altibase provides a variety of replication configurations such as master-slave, all-master, fan-in, fan-out and propagation.Altibase provides table-based replications whereas other DBMSs are tablespace-based.Altibase provides easy configuration and scalability compared to other DBMSs.Real Time Backup/RecoveryData failures are usually caused by data storage failures. Altibase provides intrinsic backup and recovery solutions that prevent all kinds of data storage failures and guarantee data availability and integrity via:The fastest backup/recovery based on in-memory computing through parallel backup/recovery technologyA variety of backup/recovery techniques such as online, offline, incremental, full, and utility backup/recoveryUnmatched flexibility as compared to any other in-memory database
-
What is online resharding?
Sharding refers to an architecture where data is distributed across commodity (cheap) computers. Sharding, or scale-out, compares favorably to scale-up which requires replacing 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 is needed, additional shard nodes will need to be added, and vice versa. In adding or reducing the nodes, the existing data should be redistributed. This is called resharding.When resharding can allow for non-stop data redistribution without pausing or interfering with existing applications, the resharding is called online resharding.Most of the online resharding is provided by NoSQL database vendors. It is very rare that relational database vendors provide online resharding. In the case of relational databases, they provide either client-side sharding or server-side sharding, not both.Providing the two-way sharding requires a very sophisticated transaction sharing technology. This technology combines and processes transactions requested by both client-side sessions and coordinator/server-side sessions so that those multiple transactions can be handled as one logical shared transaction.Altibase, a relational database, is unique in that it provides both client-side and server-side sharding. It is called hybrid sharding.It analyzes SQL in the application program and automatically executes in the optimal path by analyzing whether to execute automatically by client-side sharding or server-side sharding.Altibase’s hybrid sharding takes advantage of server-side sharding that can process complex data, while minimizing performance bottlenecks caused by coordinators, and taking advantage of client-side sharding that is advantageous in terms of expansion and performance. In doing so, it can mitigate the performance burden on coordinators, and the net result is to increase the overall performance of the scale-out by minimizing coordinator-related bottlenecks.
-
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 8 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 SLAs to guarantee peace of mind and accountability.Altibase is a relational DBMS and is compatible and interoperable with Oracle and other legacy DBMSs.Altibase has an over 90% customer retention rate.Altibase has a quality reference customer base including HP, Samsung, E*Trade, Hyundai, China Mobile, etc. (see the full list here)Altibase has 22 years of experience of serving over 650 enterprise clients including 9 Fortune Global 500 companies. Their adoption and utilization of Altibase are, in almost all cases, for their mission-critical applications. For them, mere minutes of downtime can translate into millions of dollars in losses and can lead to serious legal disputes with their customers. Altibase has an over 90% customer retention rate.Altibase provides and adheres to strict technical SLAs to guarantee peace of mind and accountability. Altibase has 22 years of accumulated know-how of dealing with clients in the face of great crises and dangers related to their databases.Altibase’s full adherence to traditional relational principles and paradigms paves the way for adopting and utilizing Altibase for other applications currently using Oracle, DB2, and SQL Server.
-
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 with NoSQL.Backup and recovery are significantly more complex.NoSQL is not suitable for ad-hoc queries and analysis.NoSQL has low product maturity and has stability and reliability issues.It is difficult to install and maintain NoSQL.There is inadequate support for NoSQL users.There are few experts available specialized in NoSQL.The following case studies include related stories.Global Cloud Authentication Service – Samsung Electronics : Altibase is used instead of Oracle Coherence.Altibase vs. NoSQLCategoryClassItemAltibaseNoSQLBusinessUseVersatileGeneralRestricted, specificRelationalRelationalNon-relationalInterfacesODBC/JDBCRestricted, specificCompetitorCompetitorEnterprise RDBMSs(Oracle, MSSQL)Many products(Cassandra, MongoDB, Redis)StandardANSISupport ANSINon-standardTechniqueTransactionGuaranteedGuaranteed (ACID)Not guaranteedQueryUpdateEasyDifficultComplex queryAvailableNot supportedSortingAvailable, easyNot supported or difficultJoinAvailableNot supportedGroupingAvailableNot supportedRange queryAvailableNot supportedIndexAvailableNot supportedDevelopment and MaintenanceDevelopmentDevelopmentFamiliarUnfamiliarExpert poolRichPoorTable designGeneral, flexibleComplex, fixedData redundancyRare (normalization)Many (denormalization)SchemaCheck by DBCheck by appHybridSupportedNot supportedMaintenanceTechnical supportStrongVendor support weak, Community support dependentReference siteManyManyTrainingStrongWeakMaintenanceEasyHardBackup/RestoreSimpleComplex
-
How does Altibase compare to MariaDB, PostgreSQL, and EnterpriseDB?
Altibase is a High-Performance Enterprise RDBMS. Altibase is a time-tested and proven DBMS. Altibase has 27 years of experience in producing, selling, and supporting DBMS solutions for over 700 enterprise clients including 22 of Fortune Global 500.Altibase is the most reliable DBMS. Altibase has been deployed exclusively for over 8,000 mission-critical applications where mere minutes of downtime can translate into millions of dollars in losses and lead to serious litigation and financial risks.Altibase is a relational DBMS and is compatible and interoperable with Oracle and other legacy DBMSs.Altibase has an over 90% customer retention rate.Enterprise customers are almost always the most discerning customers. While some companies are often willing to assume some risks by adopting the latest and sometimes unproven technologies, enterprise clients tend to take a much more calculated approach to adoption. Particularly those with mission-critical systems need the security and peace of mind provided by strict SLAs, technical support availability, and responsiveness.The cost savings from the use of open source DBMSs do not always justify the downtime or compliance risks. In addition, the ability to interoperate with other core systems is a significant cause for concern. Enterprise clients demand the following:High-quality standards and stabilityStrong functionality and ability to interoperate with other systemsAbility to scale effectively with demanding and/or very large workloadsRobust disaster recovery and high availability featuresHigh-quality documentation and 24/7 technical support availabilityQuality reference customersExperience with Fortune 500 companiesFor these reasons, the vast majority of enterprises are still unwilling to risk their most mission-critical systems on open source products with questionable product stability and support.This situation has left enterprises without any attractive and/or viable options for decades. Stay with legacy databases and pay exorbitant costs for stability, accountability, and support. Or switch to open source databases and take the risk of being hung out to dry during a disaster situation.This is where Altibase should come into play. All things considered, Altibase is an attractive and viable choice. Altibase is an open source but is enterprise grade. Altibase has 27 years of experience in servicing over 700 enterprise customers including 22 of Fortune Global 500.Altibase combines cost efficiency with the reliability and accountability required for mission-critical enterprise systems.Altibase has competed with various open source databases. The following case studies include related stories.Mobile User Authentication System – Korea Telecom : switched to Altibase after its use of other open source databases Altibase vs. Other Open Source DatabasesCategoryValue IndexAltibaseOpen Source DatabasesProductLife cyclePermanentNon-permanentStabilityGuaranteedLimitedPerformanceGuaranteedLimitedSecurityHighLowRoadmapPlannedUnplannedStandard ComplianceStandardNon-standardScalabilityUnlimitedLimitedReplicationHALimitedWindows CompatibilityHighLowR&D and SupportDevelopmentProfessional dedicated developersVolunteered developersSupportOrganizedLimitedProblem Solving24/7/365 supportSupport by thrid parties Altibase vs. MariaDB, PostgreSQL & EnterpriseDBFunctionAltibaseMariaDBPostgreSQLEDB PASHybrid Partitioned TableYesNoNoNoMemory TableYesYesNoNoParallel QueryYesNoNoNoUpdatable ViewYesYesNoNoMerge IntoYesNoNoNoMove ~ IntoYesNoNoNoQueueYesYesNoNoSynonymYesNoYesYesMulti~InsertYesNoNoNo(+)Outer JoinYesNoNoNoExternal ProcedureYesYesNoNoFlashback TableYesYesNoNoDirect Access Connection TypeYesNoNoNo
-
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 its data durability in system failure situations is more stable.Altibase provides various communication channels (TCP/IP, SSL/TLS, Unix Domain Socket, IPC and IPC-DA) to optimize performance.Altibase’s IPC-DA and Oracle TimesTen’s DA are similar in that both allow applications to directly read and write data to shared memory, which minimizes memory access and maximizes access performance.However, Altibase’s IPC-DA compares favorably to Oracle TimesTen’s DA because the former is safer than the latter. With Altibase’s IPC-DA, a client program accesses only a communication buffer, not data itself, so that it is not possible for the data to be exposed to corruption whereas Oracle TimesTen’s DA accesses a database directly so that data in the database is always potentially exposed to corruption.Since 1999, Altibase has competed neck and neck with Oracle TimesTen. The following case studies include related stories.Manufacturing Execution System and Process Control System – POSCO : chosen through benchmark tests over Oracle TimesTen and IBM SolidDBBilling and Order Support System – One of the World’s Largest Mobile Telecommunications Providers : chosen over Oracle Exadata and Oracle TimesTenAltibase vs. Other In-Memory DatabasesCategoryItemsAltibaseOracle TimesTenIBM SolidDBSAP HANACommunication ChannelDirect AccessSupportedSupportedNot SupportedNot SupportedLock MechanismMVCCSupportedSupportedSupportedSupportedFunctionalitySQLSQL92, SQL99SQL92, SQL99SQL92, SQL99, SQL2003SQL92, SQL99ReplicationSupportedSupportedSupportedSupportedPerformance(Complex Queries)TPC-HHigh performanceLow performanceLow performanceHigh performanceProductivityDevelopmentConvenienceAPRE, PSM(PL/SQL)ProC, PL/SQLSA API, procedurePrecompiler Not offered, stored procedureUsabilityManagement ToolsOrangeOracle Enterprise ManagerSolid consoleSPS 07PlatformsFully supportedFully supportedFully supportedFully supportedInteractive SQL ToolSupportedSupportedSupportedSupportedStorage ManagementOn-Disk TableSupportedNot supportedNot supportedNot supportedMultiple DB Files ConfigurationSupportedNot supportedNot supportedSupportedDB AutoextendSupportedNot supportedNot supportedSupportedReplication1:N waySupportedSupportedSupportedSupportedReplication b/t Heterogeneous SystemsSupportedSupportedSupportedSupportedReplication UnitTableTable, databaseTableTableOffline ReplicationSupportedNot supportedNot supportedNot supportedTransactionSave-PointSupportedSupportedSupportedSupportedRollbackSupportedSupportedSupportedSupportedStabilityDB BackupOffline, online, logical, incrementalOffline, online, logical, incrementalOffline, online, logical backupOffline, online, logical backupRange of Data RecoveryTransaction, media,system failureTransaction, media,system failureTransaction, media,system failureTransaction, media,system failureInterfaceEmbedded SQLSupportedSupportedSupportedSupportedODBCSupportedSupportedSupportedSupportedJDBCSupportedSupportedSupportedSupportedXA APISupportedSupportedSupportedNot supportedSQLCLISupportedSupportedSupportedNot SupportedC APISupportedSupportedSupportedNot SupportedAdvanced SQLSQL Plan CacheSupportedNot supportedNot supportedSupportedQueue TableSupportedNot supportedNot supportedNot supportedDB LinkSupportedNot supportedNot supportedSupported
-
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 that allows modified data in Altibase to be sent directly into an Oracle database. Altibase and Oracle are interoperable with each other.The following case studies include related stories.Real Time Rating System – SK Telecom : Data integration between Altibase and Oracle was achieved by using Altibase’s OraAdapter tool.Manufacturing Execution System and Process Control System – POSCO : OraAdapter tool integrated data between Oracle and Altibase DBMS AccelerationApplication AccelerationReduces the workload of back-end databasesImproves response time and throughput for SQL requestsREAD/WRITE caching for session controlHA and data persistenceLow latency response time Hot data: frequently accessed dataCold data: historical/infrequently accessed dataAltibase Can Exchange Data with Oracle without Any RestraintsTable-based parallel replication enables fine-grained data exchange among several databases.Asynchronous and synchronous modes are available.Altibase Adapter for OracleAltibase Adapter for Oracle is a utility that enables modified data in Altibase to be applied to Oracle’s databases.It minimizes system resources by capturing log files. XLog is a transmission log to be replicated between database systems.XLog sender thread creates and sends the Xlog and meta information for handshaking to the Xlog collector on the other database system.The Xlog collector converts Altibase data to Oracle data via ALA (Altibase Log Analysis API)
-
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 a native memory pointer whereas Oracle accesses a record indirectly through a logical Row ID (RID). With a 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 is much slower performance.The buffer cache typically can only store a very small subset of data. Anytime a client requests data that does not currently exist in the buffer cache, it must fetch the data from the physical disk and load it into the buffer cache before it is read. This corresponding disk read dramatically reduces performance.In addition, this data caching is really only useful for reads. There is no real performance improvement when it comes to inserts, updates, or deletes. In contrast, Altibase, an in-memory and hybrid database, dramatically improves the total performance of the database regardless of the type of the SQL query made.As such, a buffer cache is absolutely not identical to an in-memory database while it is true that the buffer cache resides in memory and dramatically improves performance.Altibase vs. Oracle’s Database Buffer CacheItemAltibaseOracle Database Buffer CacheArchitecture INSERTSpeedFasterSlowerUPDATESpeedFasterSlowerDELETESpeedFasterSlowerSELECTSpeedFasterSlowerData Access MethodDirect access by native memory pointerIndirect access by logical Row ID
-
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 disadvantages of shared-storage is that it maintains a single point of failure. But the biggest disadvantage of Oracle RAC is cost. Oracle RAC implementations are enormously expensive, and the same availability targets can often be met with much simpler solutions.Most importantly, Altibase's replication is free of charge. It is also worth noting that only a very small percentage of Oracle customers (around 3~5%) have deployed RAC.The following case studies show how Altibase is used instead of Oracle RAC/Exadata.Real Time Rating System – SK Telecom : Active-Active configurationBilling and Order Support System – One of the World’s Largest Mobile Telecommunications Providers : flexible scale-outComparison by CostItemAltibase ReplicationOracle RACHA Option PriceIncluded at no extra cost$184K(public price list for Oracle RAC for 2 nodes with DR and QA options)Additional HardwareNoneRequiredAdditional SoftwareNoneClusterware, Data GuardOperational CostsNoneHighComparison by Performance and FeaturesAltibase replication utilizes a shared-nothing architecture which provides significant speed and stability gains over Oracle’s shared disk architecture. RAC’s shared disk system utilizes global exclusive locks which dramatically increase latency whereas Altibase replication offers excellent features that Oracle RAC does not support.ItemAltibase ReplicationOracle RACArchitectureRecovery Time<5 seconds30-60 secondsTPS per Extra NodeNegligible (<5%)Degrades by 18%Linear Scale-OutEasyComplexSet Up and ConfigurationEasyComplexCompliance to Commodity HardwareCompliantNon-compliant(which requires Voltaire, Cache Fusion switches, SAN storage, etc.)ScalabilityEasy(1:N, up to unlimited nodes)Difficult
-
How does Altibase compare to Oracle, SAP Hana, and IBM DB2?
Altibase matches Oracle and other legacy DBMSs function for function.Altibase provides richer sets of features and functionality and great reliability.Since 1999, Altibase has served over 700 global enterprises including 22 Fortune Global 500 companies.Altibase’s subscription fees are flexible and competitive.Altibase’s 27 years’ accumulated know-how of dealing with over 8,000 mission-critical use cases provides peace of mind and accountability.Altibase provides cutting-edge sharding.Altibase is designed to supper-minimize the use of coordinators so that you can add as many servers as necessary without experiencing coordinator-related performance degradation in scaling out your systems.It is easy and straightforward to deploy Altibase’s sharding as it does not require any changes to your existing applications if your systems are built on relational databases.Altibase is a hybrid database.Altibase combines an in-memory database and an on-disk database into a single product to achieve the speed of memory and the storage capacity of the disk.Altibase’s hybrid architecture eliminates the need to purchase an in-memory database and an on-disk database separately, thus resulting in lower TCO.Altibase’s in-memory capabilities provide significantly higher throughput than Oracle (100,000+ transactions per second) and low and predictable response times (microsecond scale).Altibase has been deployed in over 6,000 extremely demanding use cases such as billing and authentication for mega telecom companies and other applications for finance and manufacturing companies with very high throughput requirements.Since 1999, Altibase has competed neck and neck with Oracle and other legacy database vendors. The following case studies include related stories.Billing and Order Support System – One of the World’s Largest Mobile Telecommunications Providers : replaced OracleOnline Trading System – E*TRADE : switched from OracleKorea Workers’ Compensation & Welfare Service : switched from SybaseAltibase vs. other legacy DBMSsFunctionAltibaseOracle 11gSAP HanaIBM DB2 10.1ProcessMulti threadMulti processMulti threadMulti processModelRelational modelRelational modelRelational modelRelational modelArchitectureClient-serverClient-serverClient-serverClient-serverDBMS typeHybrid(In-Memory &On-disk)On-disk onlyIn-memory onlyOn-disk onlyLOBSupportedSupportedSupportedSupportedReplicationData replicationShared storageData replicationShared storage64bit modeSupportedSupportedSupportedSupportedLocking modeRow level lockingRow level lockingRow level lockingRow level lockingLock for SELECTNo lockingNo lockingLockingLockingConsistent viewSupportedSupportedNot supportedNot supportedDB recoverySupportedSupportedSupportedSupportedTableSupportedSupportedSupportedSupportedMulti key-indexSupportedSupportedSupportedSupportedStored procedureSupportedSupportedSupportedSupportedStored functionSupportedSupportedSupportedSupportedSequenceSupportedSupportedSupportedSupportedQueue tableSupportedSupportedSupportedSupportedDB auditSupportedSupportedSupportedSupportedSnapshotNot supportedSupportedNot supportedNot supportedDB linkSupportedSupportedSupportedSupportedSynonymSupportedSupportedSupportedSupportedTable partitioningSupportedSupportedSupportedSupportedUser defined typeSupportedSupportedSupportedSupportedOn-line backupSupportedSupportedSupportedSupportedMonitoring viewSupportedSupportedSupportedSupportedPerformance Comparison Against Traditional On-disk DBMSsAltibase processes DML statements 10 times faster than other DBMSs:Memory table DML: 10 times faster than on-disk DBMSsMemory table SELECT: 2~5 times faster than on-disk DBMSsTest environment: memory-30GB, CPU-4.4GHZ (4 Cores), OS-AIX 6.1 64bitPerformance: 2 times faster than other in-memory DBMSs