solidDB is a relational "SQL Database" with persistent in-memory - and on-disk tables.
- Developer
- Country of Origin
- FI
- Start Year
- 1992
- Acquired By
- Project Type
- Commercial
- License
- Proprietary
It provides three different replication features: a highly automated HotStandby (HSB), asynchronous log (CRep) replication with arbitrary topologies (with/wo HSB) and a scalable cluster called the Grid. solidDB can be configured as a separate client/server, used as a library which is less need with the client, or shared as a library with multiple client processes and accessed through shared memory. Recent additions include JSON/BSON support, and vector datatype and vector indexing (with hnswlib).
solidDB is a relational "SQL Database" with persistent in-memory - and on-disk tables. It provides three different replication features: a highly automated HotStandby (HSB), asynchronous log (CRep) replication with arbitrary topologies (with/wo HSB) and a scalable cluster called the Grid. solidDB can be configured as a separate client/server, used as a library which is less need with the client, or shared as a library with multiple client processes and accessed through shared memory. Recent additions include JSON/BSON support, and vector datatype and vector indexing (with hnswlib).
Coordination
HotStandby servers are controlled by distributed HA Controller processes.
Fault Tolerance
HotStandby can be configured to run with fine-grained levels ranging from asynchronous to strictly synchronous replication.
Asynchronous (CRep) replication detects schema inconsistencies and conflicting updates.
Indexes
B+-tree for on-disk tables, and combination of compressed Patricia trie and cache conscious B-tree leaf level nodes. Hnswlib uses hardware optimized distance functions if the hardware supports them.
Isolation Levels
Read Committed, Repeatable Read & Serializable for on-disk tables, Read Committed and Repeatable Read for in-memory tables.
Storage Architecture
Per table granularity. Both in-memory - and on-disk tables are supported on same schema. Table types are transparent to queries.
Citations
4 sources- https://teamblue.unicomsi.com/products/soliddb unicomsi.com
- SolidDB help: Reverb unicomsi.com
- solidDB - Wikipedia wikipedia.org
- https://www.marketwatch.com/story/unicomr-global-acquires-soliddbr-from-ibmr-corp-2014-07-09 marketwatch.com