DBMS > KairosDB vs. PostgreSQL vs. SAP SQL Anywhere
System Properties Comparison KairosDB vs. PostgreSQL vs. SAP SQL Anywhere
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||KairosDB Xexclude from comparison||PostgreSQL Xexclude from comparison||SAP SQL Anywhere formerly called Adaptive Server Anywhere Xexclude from comparison|
|Description||Distributed Time Series DBMS based on Cassandra or H2||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments|
|Primary database model||Time Series DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Document store|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||SAP formerly Sybase|
|Initial release||2013||1989 1989: Postgres, 1996: PostgreSQL||1992|
|Current release||1.2.2, November 2018||12.3, May 2020||17, July 2015|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source BSD||commercial|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
|Typing predefined data types such as float or date||yes||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||yes specific XML-type available, but no XML query functionality.||yes|
|SQL Support of SQL||no||yes standard with numerous extensions||yes|
|APIs and other access methods||Graphite protocol|
native C library
streaming API for large objects
|Supported programming languages||Java|
|Server-side scripts Stored procedures||no||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||yes, in C/C++, Java, .Net or Perl|
|Partitioning methods Methods for storing different data on different nodes||Sharding based on Cassandra||partitioning by range, list and (since PostgreSQL 11) by hash||none|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor based on Cassandra||Source-replica replication other methods possible by using 3rd party extensions||Source-replica replication Database mirroring|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency based on Cassandra|
Immediate Consistency based on Cassandra
|Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||ACID|
|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.||no||no||yes|
|User concepts Access control||simple password-based access control||fine grained access rights according to SQL-standard||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||Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service|
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
CYBERTEC: your professional partner for PostgreSQL services and Data Science based on PostgreSQL since 2000. With offices in Austria, Uruguay, Estonia and Switzerland, CYBERTEC operates worldwide!
pgDash: In-Depth PostgreSQL Monitoring.
2ndQuadrant: Mission Critical Databases.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|KairosDB||PostgreSQL||SAP SQL Anywhere formerly called Adaptive Server Anywhere|
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Conferences and events|
PostgreSQL Online Trainings
|Recent citations in the news|
The new rise of time-series databases
Using Redis as a Time Series Database: Why and How
Real-Time Performance and Health Monitoring Using Netdata
The Rise of Time Series Databases
provided by Google News
maintain a postgresql database using osm2pgsql - Linux & Unix
Crunchy Certified PostgreSQL 12 Achieves In Evaluation Status for Common Criteria Certification
PostgreSQL Multi-Model Graph Extension Announced
provided by Google News
Best Database Management Software 2020
SAP SQL Anywhere
SAP gives SQL Anywhere a new IoT injection
SAP BAPI (Business Application Programming Interface)
SAP IoT products: How do they work with ERP and big data?
provided by Google News
Jr. QA Analyst Trainee
Database Developer w/strong Postgres Skills-3
SQL Developer I/II
Data Technician (Full- or Part-Time)
Dynamic Recitation Developer
Share this page