Difference between ActivePivot and Amazon SimpleDB
Last Updated :
29 Jul, 2020
1. ActivePivot :
The ActivePivot is an in-memory DBMS combining transactional and analytical processing to handle aggregation of ever-changing data. This database uses a columnar storage architecture along with dictionary compression and binary representation of Java objects. It is one of core products of French company ActiveViam – once known as Quartet FS, which was founded in 2005.
2. Amazon SimpleDB :
It is a hosted simple database service by Amazon, with data stored in Amazon Cloud. It is Amazon is web service for running queries on structured data in real-time. This database is written in Erlang by Amazon.com. It has following features – high availability and flexibility, with little or no administrative burden.
Difference between ActivePivot and Amazon SimpleDB :
S.No. |
ActivePivot |
Amazon SimpleDB |
1. |
It was developed by ActiveViam. |
It was developed by Amazon in 2007. |
2. |
It is an in-memory DBMS combining transnational and analytical processing to handle aggregation of ever-changing data. |
It is hosted simple database service by Amazon, with data stored in Amazon Cloud. |
3. |
It does not support any replication method. |
It supports replication methods. |
4. |
It is not available as cloud service. |
It is available as cloud service. |
5. |
Its primary database model is Object-oriented DBMS. |
Its primary database model is Key-value store. |
6. |
It supports Server-side scripting with Post-processors in Java. |
It does not support Server-side scripting. |
7. |
In ActivePivot, partitioning can be done by Sharding and horizontal partitioning. |
It does not support partitioning methods. |
8. |
It supports SQL query language with Multidimensional Expressions (MDX). |
It does not support SQL query language. |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...