Related products and services CData: Connect to Big Data & NoSQL through standard Drivers. We invite representatives of system vendors to contact us for updating and extending the system information,Īnd for displaying vendor-provided information such as key customers, competitive advantages and market metrics. yes User concepts Access control fine grained access rights according to SQL-standard More information provided by the system vendor
ODBC Supported programming languages All languages supporting JDBC/ODBC Server-side scripts Stored procedures user defined functions in Python Triggers no Partitioning methods Methods for storing different data on different nodes Sharding 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 Transaction concepts Support to ensure data integrity after non-atomic manipulations of data ACID Concurrency Support for concurrent manipulation of data yes Durability Support for making data persistent yes In-memory capabilities Is there an option to define some or all structures to be held in-memory only. no Secondary indexes restricted SQL Support of SQL yes does not fully support an SQL-standard APIs and other access methods JDBC support for XML data structures, and/or support for XPath, XQuery or XSLT. Implementation language C Server operating systems hosted Data scheme yes Typing predefined data types such as float or date yes XML support Some form of processing data in XML format, e.g. Providers of DBaaS offerings, please contact us to be listed.
Editorial information provided by DB-Engines Name Amazon Redshift Description Large scale data warehouse service for use with business intelligence tools Primary database model Relational DBMS DB-Engines Ranking measures the popularity of database management systems Trend Chart Score 26.19 Rank #31 Overall #18 Relational DBMS Website /redshift Technical documentation /redshift Developer Amazon (based on PostgreSQL) Initial release 2012 License Commercial or Open Source commercial Cloud-based only Only available as a cloud service yes DBaaS offerings (sponsored links) Database as a Service
Our visitors often compare Amazon Redshift with Snowflake, Amazon DynamoDB and Microsoft Azure Synapse Analytics. Please select another system to compare it with Amazon Redshift. DBMS > Amazon Redshift Amazon Redshift System Properties