Difference between Altibase and Amazon Redshift
Last Updated :
30 Jul, 2020
1. Altibase :
The Altibase is an open-source relational database. First version of it is called Spiner which was released in 2000. It is an enterprise-grade, in-memory, hybrid, high-performance RDBMS. It is manufactured by Altibase Corporation. It supports complete SQL standard. It also features Multiversion concurrency control (MVCC), implements Fuzzy and Ping-Pong Checkpointing.
2. Amazon Redshift :
Amazon Redshift is an efficient solution to collect and store all your data and enables you to analyze it. It is a large scale data warehouse service for use with business intelligence tools. Feature of Amazon Redshift – fast, simple, cost-effective data warehousing service. It forms part of larger cloud-computing platform Amazon Web Services.
Difference between Altibase and Amazon Redshift :
| S.NO. |
Altibase |
Amazon Redshift |
| 1. |
Developed By Altibase in 1999. |
Developed By Amazon in 2012. |
| 2. |
It is enterprise-grade, high-performance RDBMS. |
It is a large scale data warehouse service for use with business intelligence tools. |
| 3. |
License of Altibase is Open Source. |
License of Amazon Redshift is commercial. |
| 4. |
Server operating systems for Altibase are AIX, HP-UX, and Linux. |
In Amazon Redshift, Hosted server operating systems. |
| 5. |
Its Primary database model is Relational DBMS. |
Its primary database model is Relational DBMS. |
| 6. |
It stored procedures and stored functions. |
It supports user-defined functions for Server-side scripting in python. |
| 7. |
It is not available as cloud service. |
It is available as cloud service. |
| 8. |
It uses ANSI SQL-92 as query language. |
It supports SQL query language. But it does not fully support SQL-standard. |
| 9. |
It is written in C++ language. |
It is written in C language. |
| 10. |
It supports secondary indexes. |
It supports restricted secondary indexes. |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...