DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

PNUTS


PNUTS is a distributed key-value database system designed for web-scale online transaction processing workloads. It provides a flexible schema supporting entity-attribute-value storage, with data partitioned across nodes and replicated for fault tolerance. The system uses a centralized coordinator for metadata management and transaction coordination, employing multi-version concurrency control to support snapshot isolation and serializable transactions.

Developer
Country of Origin
US
Start Year
2008
Project Type
Internal / Non-Public
Written in
Java
Operating Systems
All OS with Java VM, Linux
License
Proprietary

Database Entry

PNUTS


PNUTS is a distributed key-value database system designed for web-scale online transaction processing workloads. It provides a flexible schema supporting entity-attribute-value storage, with data partitioned across nodes and replicated for fault tolerance. The system uses a centralized coordinator for metadata management and transaction coordination, employing multi-version concurrency control to support snapshot isolation and serializable transactions.

History


Developed at Yahoo Research, PNUTS was introduced in 2008 to address scalability challenges in hosting web applications. The architecture features a master-slave design with data partitioning by entity identifier and primary-backup replication. It was utilized internally for various Yahoo services but was not released as open-source software.

Development focus gradually shifted as cloud-native database technologies emerged, leading to the project's eventual discontinuation without a formal public announcement.

Checkpoints


Concurrency Control


Coordination


Data Model


Fault Tolerance


Foreign Keys


Indexes


Isolation Levels


Joins


Logging


Query Interface


Storage Architecture


Storage Organization


Stored Procedures


System Architecture


Views


Citations

2 sources
  1. http://dl.acm.org/citation.cfm?id=1454167 acm.org
  2. https://dl.acm.org/doi/10.1145/1376616.1376698 acm.org
Revision #3 Last Updated: