Skip to content
Related Articles

Related Articles

Difference between Altibase and Amazon Redshift

View Discussion
Improve Article
Save Article
  • Last Updated : 30 Jul, 2020
View Discussion
Improve Article
Save Article

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.AltibaseAmazon 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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!