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