1. Altibase :
It is an open-source relational database model system (RDBMS). The first version of Altibase was called Spiner which was released in 1999. It is an enterprise grade, in-memory, hybrid, high-performance RDBMS. It is manufactured by Altibase Corporation. It supports the complete SQL standard, features and Multi-Version Concurrency Control (MVCC) and also implements Fuzzy and Ping-Pong Checkpointing.
2. Amazon SimpleDB :
It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud. It is Amazon is a web service for running queries on structured data in real-time. This database is written in Erlang by Amazon.com. It has the following features – high availability and flexibility, with little or no administrative burden.
Difference between Altibase and Amazon SimpleDB :
|1.||Developed By Altibase in 1999.||Developed By Amazon in 2007.|
|2.||It is an enterprise-grade, high-performance RDBMS.||It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud.|
|3.||The License of Altibase is an Open Source.||The License of Amazon SimpleDB is commercial.|
|4.||Server operating systems for Altibase are AIX, HP-UX, and Linux.||In Amazon SimpleDB, Hosted server operating systems.|
|5.||Its Primary database model is Relational DBMS.||Its primary database model is the Key-value store.|
|6.||It stored procedures and stored functions.||It does not support the Server-side scripting.|
|7.||The partitioning can be done with Sharding.||It does not support partitioning methods.|
|8.||It uses ANSI SQL-92 as a query language.||It does not support the SQL query language.|
|9.||It supports the ACID property.||It does not support the ACID property.|
|10.||It provides the concept of Referential Integrity. Hence, no Foreign Keys.||It does not provide the concept of Referential Integrity. Hence, no Foreign Keys.|
|11.||It is not available as a cloud service.||It is available as a cloud service.|
|12.||The programming languages supported are C, C++, and Java.||The programming languages supported are .Net, C, C++, Erlang, Java, PHP, Python, Ruby, and Scala.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.