DBMS > Amazon Redshift vs. Graph Engine
System Properties Comparison Amazon Redshift vs. Graph Engine
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Amazon Redshift Xexclude from comparison||Graph Engine former name: Trinity Xexclude from comparison|
|Description||Large scale data warehouse service for use with business intelligence tools||A distributed in-memory data processing engine, underpinned by a strongly-typed RAM store and a general distributed computation engine|
|Primary database model||Relational DBMS||Graph DBMS|
|Developer||Amazon (based on PostgreSQL)||Microsoft|
|License Commercial or Open Source||commercial||Open Source MIT License|
|Cloud-based only Only available as a cloud service||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C||.NET and C|
|Server operating systems||hosted||.NET|
|Typing predefined data types such as float or date||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|SQL Support of SQL||yes does not fully support an SQL-standard||no|
|APIs and other access methods||JDBC|
|RESTful HTTP API|
|Supported programming languages||All languages supporting JDBC/ODBC||C#|
|Server-side scripts Stored procedures||user defined functions in Python||yes|
|Partitioning methods Methods for storing different data on different nodes||Sharding||horizontal partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes informational only, not enforced by the system||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes||optional: either by committing a write-ahead log (WAL) to the local persistent storage or by dumping the memory to a persistent storage|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes|
|User concepts Access control||fine grained access rights according to SQL-standard|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Amazon Redshift||Graph Engine former name: Trinity|
|DB-Engines blog posts|
Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years Increased popularity for consuming DBMS services out of the cloud
The popularity of cloud-based DBMSs has increased tenfold in four years Increased popularity for consuming DBMS services out of the cloud
Increased popularity for consuming DBMS services out of the cloud
|Recent citations in the news|
AWS doubles down on innovations that redefine the database management experience
Amazon launches Zero ETL for Redshift | Medium
These 3 Stocks Have Undeniable Long-Term Upside
Select Star closes $15M round to add context to disparate data
Amazon (AMZN) to Report Q4 Earnings: What's in the Cards?
provided by Google News
Quine Streaming Graph Processes Over One Million Events Per ...
Open source Microsoft Graph Engine takes on Neo4j
Can Streaming Graphs Clean Up the Data Pipeline Mess?
AWS, IBM, Microsoft, Google emerge Cloud DBMS leaders
Cutting-edge Katana Graph scores $28.5 million Series A Led by ...
provided by Google News
Remote - Data Team Analyst I
Senior AWS Data Architect with Amazon RedShift
Share this page