Difference between ActivePivot and Amazon SimpleDB
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. |
Contact Us