DBMS > PostgreSQL vs. searchxml vs. Tibero
System Properties Comparison PostgreSQL vs. searchxml vs. Tibero
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||PostgreSQL Xexclude from comparison||searchxml Xexclude from comparison||Tibero Xexclude from comparison|
|Description||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||DBMS for structured and unstructured content wrapped with an application server||A secure RDBMS, designed for easy portability from Oracle|
|Primary database model||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Native XML DBMS|
|Secondary database models||Document store|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||informationpartners gmbh||TmaxSoft|
|Initial release||1989 1989: Postgres, 1996: PostgreSQL||2015||2003|
|Current release||12.1, November 2019||1.0||6, April 2015|
|License Commercial or Open Source||Open Source BSD||commercial||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.
|Implementation language||C||C++||C and Assembler|
|Server operating systems||FreeBSD|
|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.||yes specific XML-type available, but no XML query functionality.||yes||yes|
|SQL Support of SQL||yes standard with numerous extensions||no||yes|
|APIs and other access methods||ADO.NET|
native C library
streaming API for large objects
|RESTful HTTP API|
Oracle Call Interface (OCI)
|Supported programming languages||.Net|
|C++ most other programming languages supported via APIs||C|
|Server-side scripts Stored procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||yes on the application server||Persistent Stored Procedure (PSM)|
|Partitioning methods Methods for storing different data on different nodes||partitioning by range, list and (since PostgreSQL 11) by hash||none||horizontal partitioning by range, hash, list or composite|
|Replication methods Methods for redundantly storing data on multiple nodes||Master-slave replication other methods possible by using 3rd party extensions||yes sychronisation to multiple collections||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||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||multiple readers, single writer||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||no planned for next version|
|User concepts Access control||fine grained access rights according to SQL-standard||Domain, group and role-based access control at the document level and for application services||fine grained access rights according to SQL-standard (SQL 92, SQL 99)|
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||Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.|
SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
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!
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
pgDash: In-Depth PostgreSQL Monitoring.
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
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
|Conferences and events|
PGCon 2020, PostgreSQL Conference for Users and Developers
|Recent citations in the news|
Aqua Data Studio Version 20.5 Introduces Support for Amazon RDS
Aqua Data Studio Version 20.5 Introduces New Database Support
Hands-on SQL in PostgreSQL
PostgreSQL turns performance up for v12 release
Sr Software Developer job with Altice USA | 408916
provided by Google News
TmaxSoft to Supply Database Management Software to Hyundai and Kia
Hyundai and Kia Say Good-bye to Oracle and Choose Tmax as DBMS Vendor
TmaxSoft is using clear licensing to woo Oracle database users
provided by Google News
PostgreSQL Consultant - remote
Entry Level Data Scientist
Baseball Research and Development Analyst
PostgreSQL Database Administrator
MySQL DBA (US Hours) - remote
Share this page