DBMS > BigchainDB vs. PostgreSQL vs. TimesTen
System Properties Comparison BigchainDB vs. PostgreSQL vs. TimesTen
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||BigchainDB Xexclude from comparison||PostgreSQL Xexclude from comparison||TimesTen Xexclude from comparison|
|Description||BigchainDB is scalable blockchain database offering decentralization, immutability and native assets||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||In-Memory RDBMS compatible to Oracle|
|Primary database model||Document store||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||Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005|
|Initial release||2016||1989 1989: Postgres, 1996: PostgreSQL||1998|
|Current release||12.1, November 2019||11 Release 2 (22.214.171.124.0)|
|License Commercial or Open Source||Open Source AGPL v3||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||FreeBSD|
|Typing predefined data types such as float or date||no||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.||no|
|SQL Support of SQL||no||yes standard with numerous extensions||yes|
|APIs and other access methods||CLI Client|
RESTful HTTP API
native C library
streaming API for large objects
Oracle Call Interface (OCI)
|Supported programming languages||Go|
|Server-side scripts Stored procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||PL/SQL|
|Partitioning methods Methods for storing different data on different nodes||Sharding||partitioning by range, list and (since PostgreSQL 11) by hash||none|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor||Master-slave replication other methods possible by using 3rd party extensions||Master-master replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency or Eventual Consistency depending on configuration|
|Foreign keys Referential integrity||no||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes,with MongoDB ord RethinkDB||yes||yes by means of logfiles and checkpoints|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes|
|User concepts Access control||yes||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||The world's first commercial In-Memory Relational Database offering (launched in...|
|Competitive advantages||TimesTen offers many advantages over competing products: Mature product with nearly...|
|Typical application scenarios||TimesTen can be used in a wide range of application areas. Some examples include:...|
|Key customers||Some of our key customers include Ericsson , Telcordia , China Mobile, China Telecom,...|
|Market metrics||TimesTen is used by thousands of customers in tens of thousands of deployments worldwide...|
|Licensing and pricing models||Standard Oracle licence models ; end user and ISV/OEM licence terms available.|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.|
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
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!
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
pgDash: In-Depth PostgreSQL Monitoring.
SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Recent citations in the news|
Blockchain Government Market 2019-2025| Take A Look at The Market Strategies of Key Players Such As ModulTrade, Blocko, Symbiont, brainbot technologies, Guardtim, BigchainDB
Automotive Blockchain Market Top Key Players- Microsoft, carVertical, Gem, RSK Labs, FOAM, Consensys, Cube, BigchainDB
Blockchain in Energy Market Top Key Players- SAP SE, BigchainDB, BTL Group Limited, Deloitte, Grid+, Infosys, Microsoft
Blockchain Government Market Growing Rapidly With Latest Trends & Future Scope by 2019-2027 | Top Companies – IBM, SAP, Microsoft, Oracle, Deloitte, AWS, Infosys, Bitfury, and Auxesis Group
provided by Google News
Introducing PostgREST, a REST API for any PostgreSQL database written in Haskell
Greenplum 6 review: Jack of all trades, master of some
NoSQL Market 2019 Trend - Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database
Cockroach Labs Announces CockroachCloud, a Fully-Managed Distributed SQL Database in Beta
provided by Google News
Oracle gooses Exalytics in-memory appliance with flash, fat DDR3 sticks
provided by Google News
Data Scientist Intern
Full Stack Software Developer
Space Systems Engineer (Entry Level)
Share this page