DBMS > Amazon Redshift vs. InfinityDB vs. Spark SQL
System Properties Comparison Amazon Redshift vs. InfinityDB vs. Spark SQL
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Amazon Redshift Xexclude from comparison||InfinityDB Xexclude from comparison||Spark SQL Xexclude from comparison|
|Description||Large scale data warehouse service for use with business intelligence tools||A Java embedded Key-Value Store which extends the Java Map interface||Spark SQL is a component on top of 'Spark Core' for structured data processing|
|Primary database model||Relational DBMS||Key-value store||Relational DBMS|
|Developer||Amazon (based on PostgreSQL)||Boiler Bay Inc.||Apache Software Foundation|
|Current release||4.0||3.5.0 ( 2.13), September 2023|
|License Commercial or Open Source||commercial||commercial||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||hosted||All OS with a Java VM||Linux|
|Data scheme||yes||yes nested virtual Java Maps, multi-value, logical â€˜tuple spaceâ€™ runtime Schema upgrade||yes|
|Typing predefined data types such as float or date||yes||yes all Java primitives, Date, CLOB, BLOB, huge sparse arrays||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||no|
|Secondary indexes||restricted||no manual creation possible, using inversions based on multi-value capability||no|
|SQL Support of SQL||yes does not fully support an SQL-standard||no||SQL-like DML and DDL statements|
|APIs and other access methods||JDBC|
|Access via java.util.concurrent.ConcurrentNavigableMap Interface|
Proprietary API to InfinityDB ItemSpace (boilerbay.com/docs/ItemSpaceDataStructures.htm)
|Supported programming languages||All languages supporting JDBC/ODBC||Java||Java|
|Server-side scripts Stored procedures||user defined functions in Python||no||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||none||yes, utilizing Spark Core|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||none||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency READ-COMMITTED or SERIALIZED|
|Foreign keys Referential integrity||yes informational only, not enforced by the system||no manual creation possible, using inversions based on multi-value capability||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID Optimistic locking for transactions; no isolation for bulk loads||no|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no||no|
|User concepts Access control||fine grained access rights according to SQL-standard||no||no|
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||InfinityDB||Spark SQL|
|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 adds more zero-ETL integrations to Amazon RedShift
Amazon enhances its serverless data platforms to kick off re:Invent ...
Precisely Data Integrity Suite Achieves Amazon Redshift Service ...
AWS re:Invent: Text and Image Generative AI Embeddings Come to ...
provided by Google News
Databáze Redis (nejenom) pro vývojáře používající Python
provided by Google News
Analysts Utilize the S&P Global Marketplace Workbench to Explore ...
Intel Granulate Optimizes Databricks' Data Management Operations
How Big Data Is Saving Lives in Real Time: IoV Data Analytics ...
Google-NVIDIA Partnership: Everything You Need To Know
Java or Python: Which One is Better for Data Science?
provided by Google News
Sr. Software Development Engineer, Amazon Redshift
Software Development Engineer - AWS, Amazon Redshift
Data Scientist SME
Cloud Database Administrator
Business Intelligence Manager
Tech Lead, Data Engine
Data Scientist (L5) - Infrastructure Experimentation
Machine Learning Associate, 2024 Graduate U.S.
Senior Backline Engineer - Spark
Python/Spark/SQL Data Egnineer
Share this page