DBMS > YugabyteDB
YugabyteDB System Properties
Please select another system to compare it with YugabyteDB.
|Editorial information provided by DB-Engines|
|Description||High-performance distributed SQL database for global, internet-scale applications. Wire compatible with PostgreSQL.|
|Primary database model||Relational DBMS|
|Secondary database models||Document store|
Wide column store
|Current release||2.2.0, July 2020|
|License Commercial or Open Source||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C and C++|
|Server operating systems||Linux|
|Data scheme||depending on used data model|
|Typing predefined data types such as float or date||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|
|SQL Support of SQL||yes, PostgreSQL compatible|
|APIs and other access methods||YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language|
|Supported programming languages||C|
|Server-side scripts Stored procedures||yes sql, plpgsql, C|
|Partitioning methods Methods for storing different data on different nodes||Hash and Range Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Based on Raft distributed consensus protocol, minimum 3 replicas for continuous availability|
|MapReduce Offers an API for user-defined Map/Reduce methods||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Strong consistency on writes and tunable consistency on reads|
|Foreign keys Referential integrity||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||Distributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.|
|Concurrency Support for concurrent manipulation of data||yes|
|Durability Support for making data persistent||yes based on RocksDB|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no|
|User concepts Access control||yes|
|More information provided by the system vendor|
Gain Developer Agility
Leverage full power of PostgreSQL-compatible SQL and distributed ACID transactions. Absolute correctness guaranteed.
Operate Resilient Services
Ensure continuous availability even when underlying compute, storage or network fails.
Add and remove nodes at will. Say no to over-provisioned clusters forever.
Lower User Latency
Leverage geo-distribution and global consistency to wow users and drive business growth.
Manage your data alongside your Kubernetes applications across public and private clouds.
Accelerate with Open Source
No hidden traps to slow you down. Apache 2.0 open source even for enterprise features.
More details available at What is Distributed SQL?
YugabyteDB is a distributed ACID-compliant database that brings together four must-have needs of cloud-native microservices, namely SQL as a flexible query language, continuous availability under failures, low-latency read performance, and globally-distributed write scalability.
Other databases do not serve all of these needs simultaneously.
- Monolithic SQL databases offer SQL with ACID transactions and low-latency reads but neither have ability to tolerate failures not can scale writes across multiple nodes, zones, regions and clouds.
- Distributed NoSQL databases offer high availability, read performance and write scalability but give up on SQL features such as multi-key/relational data modeling, ACID transactions and strong consistency.
Comparisons with various databases is available in YugabyteDB Docs.
|Typical application scenarios|
YugabyteDB is a good fit for fast-growing, cloud native applications that need to serve business-critical data reliably, with zero data loss, high availability and low latency. Common use cases include:
- Distributed Online Transaction Processing (OLTP) applications needing multi-region scalability without compromising strong consistency and low latency. E.g. User identity, Retail product catalog, Financial data service.
- Hybrid Transactional/Analytical Processing (HTAP), also known as Translytical, applications needing real-time analytics on transactional data. E.g User personalization, fraud detection, machine learning.
- Streaming applications needing to efficiently ingest, analyze and store ever-growing data. E.g. IoT sensor analytics, time series metrics, real-time monitoring.
|Licensing and pricing models|
YugabyteDB is a 100% open source project licensed under the permissive Apache 2.0 license. There is no "Enterprise Edition" of the database that commercializes "open core" database features such as backups and security. These features are included in the core open source project itself.
Yugabyte, the company behind YugabyteDB, has two commercial offerings focused on the management aspect of the database.
1. Yugabyte Platform - a self-managed database management platform that allows users to build their own YugabyteDB-as-a-Service on any cloud or Kubernetes infrastructure. Pricing is based on the number of CPU cores (physical or virtual) in your environment.
2. Yugabyte Cloud - a fully-managed YugabyteDB-as-a-Service running on major public clouds. Offering is currently in Beta with expected GA in Summer 2020. Pay-as-you-go pricing will be announced at GA.
More details available at Why We Changed YugabyteDB Licensing to 100% Open Source
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
Yugabyte Delivers the Most Comprehensive Multi-Cloud Distributed SQL Deployment Options
Yugabyte Announces Inaugural Distributed SQL Summit Asia
Chef cofounder on CentOS: It's time to open source everything
Yugabyte raises $30M for its cloud-native distributed SQL database
provided by Google News
Senior Data Architect (Yugabyte DB)
Sr Software Engineer - Systems Developer
Big Data Pipeline Engineer
Data Visualization Developer
Share this page