Difference between 4D and Amazon SimpleDB

1. 4th Dimension (4D) :
The 4th Dimension is a relational database management system and IDE developed by Laurent Ribardière. 4D can run as server so that multiple clients can manage single database. 4D was created in 1984 and had slightly delayed public release for Macintosh in 1987. It is an application development environment with integrated database management system.

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 4D and Amazon SimpleDB :

S.No.	4D	Amazon SimpleDB
1.	It is developed By 4D, Inc in 1984.	It is developed By Amazon in 2007.
2.	It is an application development environment with integrated database management system.	It is hosted simple database service by Amazon, with data stored in Amazon Cloud.
3.	It supports PHP as programming languages.	The programming languages supported are .Net, C, C++, Erlang, Java, PHP, Python, Ruby, and Scala.
4.	Server operating systems for 4D are OS X and Windows.	In Amazon SimpleDB, Hosted server operating systems.
5.	Its primary database model is Relational DBMS.	Its primary database model is Key-value store.
6.	It supports Server-side scripting.	It does not support Server-side scripting.
7.	It is not available as cloud service.	It is available as cloud service.
8.	It supports SQL query language.	It does not support SQL query language.
9.	It supports only one replication method – Master-master replication.	It support replication methods.
10.	4D provides concept of Referential Integrity. Hence, there is Foreign Keys.	It does not provides concept of Referential Integrity. Hence, no Foreign Keys.
11.	It supports ACID property.	It does not support ACID property.
12.	Immediate Consistency is used to ensure consistency in distributed system.	Eventual Consistency and Immediate Consistency are used to ensure consistency in distributed system.