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

Sophia is a transactional key-value and row storage library designed as a RAM-disk hybrid system. It provides an MVCC engine with optimistic concurrency control, serializable snapshot isolation, and append-only storage with multi-threaded compaction. The library targets embedded applications and secondary index construction, offering a minimalistic C API with FFI support.

Source Code
https://github.com/pmwkaa/sophia[02]
Country of Origin
RU
Start Year
2014
End Year
2018
Project Type
Open Source
Written in
C
Operating Systems
Linux, macOS, Windows
License
BSD License

Sophia is a transactional key-value and row storage library designed as a RAM-disk hybrid system. It provides an MVCC engine with optimistic concurrency control, serializable snapshot isolation, and append-only storage with multi-threaded compaction. The library targets embedded applications and secondary index construction, offering a minimalistic C API with FFI support.

History


Pavel Krivanek built Sophia as an open-source storage engine focusing on modern architectural choices for transactional key-value and row data. It gained attention for its unique region-based indexing and append-only design.

Development ceased after version v1.1, though its architecture influenced subsequent projects like Amelia and Monotone.

Concurrency Control


Data Model


Isolation Levels


Query Interface


Storage Architecture


Storage Model


Storage Organization


System Architecture


Citations

3 sources
  1. http://sophia.systems sophia.systems
  2. GitHub - pmwkaa/sophia: Modern transactional key-value/row storage library. · GitHub github.com
  3. sophia/documentation at master · pmwkaa/sophia · GitHub github.com
Revision #3