QLDB

Amazon Quantum Ledger Database (QLDB) is a managed ledger database management system. Its core storage architecture is an immutable and cryptographically verifiable transaction log. Unlike a blockchain DBMS where trust is distributed among participants, QLDB uses a centralized trusted authority (i.e., Amazon).

Concurrency Control

Optimistic Concurrency Control (OCC)

QLDB supports ACID transactions with serializability and it implements optimistic concurrency control (OCC). Similar to other OCC protocols, QLDB allows users to read/update an entry, and then it validates if the current transaction has conflicts with other transactions. But before committing, QLDB needs to verify that the transaction is successfully written into the journal. If yes, then it notifies the clients that the transaction is committed In both cases of validation failure or journal verification failure, QLDB returns a conflict exception. It’s up to applications to decide whether it needs to rerun the transaction or abort it.

Data Model

Document / XML

Amazon QLDB uses a document-oriented data model Ion, which is originally developed by Amazon for internal use (now [open source](http://amzn.github.io/ion-docs/docs/spec.html)). It is a superset of JSON in terms of types and validation, as it provides richer data types including int, float, decimal, and timestamp. It can also perform built-in validation by predefined Ion Struct, which not only validates data type and range but also regex expressions if specified. Ion is a strictly value-based model and supports embedded (hierarchical) documents, but not references.

Indexes

Hash Table

QLDB limits users to create 5 indexes per table. Composite and range indexes are not supported, and created indexes are only used in queries with equality predicates.

Logging

Physical Logging

QLDB uses journal as the immutable transaction log for the ledger. The journal keeps track of the updates and provide a verifiable history over time. The content of journal can be used analytics, auditing and verification purpose.

Query Interface

PartiQL

QLDB supports Amazon’s SQL dialect PartiQL. As its name implies, PartiQL is a small subset of SQL and it supports basic INSERT, SELECT, DELETE, UPDATE, and INNER JOIN. Here’s a list of clauses that PartiQL does not support yet [DISTINCT, EXISTS, HAVING, LIMIT, UNION, INTERSECT, EXCEPT, PIVOT, UNPIVOT, GROUP BY, ORDER BY, LEFT, RIGHT, OUTER JOIN].

Storage Architecture

Disk-oriented

QLDB supports monitoring on the disk storage used by journals and indexes.

Storage Model

N-ary Storage Model (Row/Record)

QLDB stores records as documents, which internally are serialized Ion objects in binary-encoded form.

System Architecture

Shared-Disk

People Also Viewed

QLDB Logo
Website

https://aws.amazon.com/qldb/

Tech Docs

https://aws.amazon.com/qldb/features/

Developer

Amazon

Country of Origin

US

Start Year

2018

Project Type

Commercial

Operating Systems

Hosted

Licenses

Proprietary

People Also Viewed