1. Amazon Neptune :
Amazon Neptune is a fast, reliable graph database built for cloud product by Amazon.com. It is part of Amazon Web Services (AWS). It was announced on November 29, 2017. It supports both open-source Apache TinkerPop Gremlin graph traversal language. It allows user to encrypt databases using keys created through AWS Key Management Service.
2. Amazon Redshift :
Amazon Redshift is an efficient solution to collect and store all your data and enables you to analyze it. It is a large scale data warehouse service for use with business intelligence tools. Feature of Amazon Redshift – fast, simple, cost-effective data warehousing service. It forms part of larger cloud-computing platform Amazon Web Services.
Difference between Amazon Neptune and Amazon Redshift :
S.NO. | Amazon Neptune | Amazon Redshift |
---|---|---|
1. | It was developed by Amazon in 2017. | It was developed by Amazon in 2012. |
2. | It is fast, reliable graph database built for cloud product by Amazon.com. | It is large scale data warehouse service for use with business intelligence tools. |
3. | It supports schema-free Data scheme. | It supports simple Data scheme. |
4. | It does not support secondary indexes. | It supports restricted secondary indexes. |
5. | Its Primary database models are Graph DBMS and RDF store. | Its primary database model is Relational DBMS. |
6. | It does not support Server-side scripting. | It supports user-defined functions for Server-side scripting in python. |
7. | It does not support partitioning methods. | It supports partitioning methods with Sharding. |
8. | It does not support SQL query language. | It supports SQL query language. But it does not fully support SQL-standard. |
9. | It supports multi-availability zones high availability. | It also supports replication methods. |