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