Difference between Altibase and Amazon SimpleDB
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.
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.
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.|