TerminusDB

TerminusDB
Developer(s)TerminusDB
Initial release2019; 5 years ago (2019)
Stable release
11.0.0 / January 30, 2023; 14 months ago (2023-01-30)[1]
Repository
Written inRust, Prolog[2]
TypeGraph database
License
Websiteterminusdb.com

TerminusDB is an open source knowledge graph and document store. It is used to build versioned data products. It is a native revision control database that is architecturally similar to Git. It is listed on DB-Engines.

TerminusDB provides a document API for building via the JSON exchange format. It implements both GraphQL and a datalog variant called WOQL. TerminusCMS is a cloud self-serve content and data platform built on TerminusDB.

TerminusDB is available under the Apache 2.0 license. TerminusDB is implemented in Prolog and Rust.

History[edit]

TerminusDB, previously known as DataChemist,[3][4] was founded in Dublin, Ireland. Starting in Trinity College Dublin,[5] the development team behind TerminusDB ran the Horizon 2020 project ALIGNED that worked from February 2015 to January 2018. An open-access e-book entitled Engineering Agile Big-Data Systems was published on completion of the ALIGNED project.[6]

Version 1.0 was released in October 2019.[7] TerminusDB was first released under the GPLv3 license with the client libraries released with the Apache 2 license. With v4.0, which was released in December 2020, TerminusDB switched to the Apache 2.0 license. The shift was discussed extensively.[8]

Release history[edit]

TerminusDB release history
Version Release date Feature notes Refs
1.0 October 2019
  • first server release with HDT backend
 [9]
1.1 January 2020
  • instance and schema checking
 [10]
2.0 June 2020
  • Rust based storage backend
  • Delta encoding
  • Commit Graph
  • Time-travel on databases
  • Regular path queries
 [11]
3.0 September 2020
  • Added reverse path queries
  • Non-backtracking side-effect
  • Reset API allows resetting branch to arbitrary commit
  • Squash API operation now available
  • Default branch is now called main and not master[12]
 [13]
4.0 December 2020
  • CSV support
  • Automatic CSV schema generation
  • Extraction or filtering of types from arbitrary nodes
  • New CLI interface
  • Graphical Model Building Tool
4.1 December 2020
  • Multiple witness flag
  • Add deb repo
4.2 February 2021
  • Delta rollups for optimize
  • Large data transfers over TUS protocol
  • Document interface with CRUD actions
  • New frame for adding class choices
  • New branch management actions: squash, reset, delete, optimize
 [14]
10.0 September 2021
  • JSON schema interface
  • Radically simplified document interface
  • JSON documents can refer to other documents in the graph.
 [15]
11.0 January 2023
  • New TerminusDB dashboard
  • GraphQL Integration
  • New storage backend introduces a layer archive format reducing storage use and latency and simplifying interchange
  • Added typed storage for a wide variety of XSD types, reducing storage overhead and improving search performance

[16]

Name[edit]

TerminusDB is named after the Roman God of Boundaries, Terminus. It is also named after the home planet of the Foundation in the series of science-fiction novel by Issac Asimov.[17] TerminusDB uses a CowDuck mascot - the motif finds its origins in the examples used by core engineer Matthijs van Otterdijk when first demonstrating the append only immutable data store[18]

Software design[edit]

TerminusDB is an in-memory graph database management system with a rich query language. The design of the underlying data structure, which is implemented in a Rust library, uses a succinct data structures and delta encoding approach drawing inspiration from software source control systems like Git.[19] This allows all of the Git semantics to be used in TerminusDB.

Data model[edit]

TerminusDB is based on the RDF standard. This standard specifies finite labelled directed graphs which are parameterized in some universe of datatypes. The names for nodes and labels are drawn from a set of IRIs (Internationalized Resource Identifiers). TerminusDB uses the XSD datatypes as its universe of concrete values. For schema design, TerminusDB used the OWL language until version 10.0. Since version 10 it uses a JSON schema interface allowing users to build schemas using a simple JSON format. This provides a rich modelling language which enables constraints on the allowable shapes in the graph.

TerminusDB has a promise based client for the browser and node.js it is available through the npm registry, or can be directly included in web-sites.[20] It also has a Python client for the TerminusDB RESTful API and a python version of the web object query language, WOQLpy.[21]

Query language[edit]

GraphQL is implemented to allow users to query TerminusDB projects in such a way that deep linking can be discovered.[22]

WOQL (web object query language) is a datalog-based query language. It allows TerminusDB to treat the database as a document store or a graph interchangeably, and provides query features to make relationship traversals easy. This gives a relatively straightforward human-readable format which can be easily stored in TerminusDB itself.

Example[edit]

A simple query which creates a document in the database, along with labels and cardinality constraints.[23] 

WOQL.doctype("BankAccount").label("Bank Account")     .property("owner","xsd:string")        .label("owner")        .cardinality(1)     .property("balance","xsd:nonNegativeInteger")        .label("owner")        .cardinality(1)

TerminusCMS[edit]

TerminusCMS is a headless open-source content management system that uses a model-driven, API-first approach to content management. The CMS is built on TerminusDB and focused on software engineer users. It was released in February 2023[24]

References[edit]

  1. ^ "Releases · terminusdb/terminusdb". GitHub. Retrieved 27 September 2022.
  2. ^ "TerminusDB Repository". GitHub.
  3. ^ "DataChemist wants to make sense of big-picture intelligence in the data analytics 'arms race'". Fora.ie. Retrieved 2020-05-06.
  4. ^ "Innovadores | Cómo lograr la paz en el mundo con ayuda del big data". Innovadores (in Spanish). Retrieved 2020-05-06.
  5. ^ "Show HN: TerminusDB – An open source in-memory graph database | Hacker News". news.ycombinator.com. Retrieved 2020-05-06.
  6. ^ Feeney, Kevin; Davies, Jim; Welch, James; Hellmann, Sebastian; Dirschl, Christian; Koller, Andreas; Francois, Pieter; Marciniak, Arkadiusz (2018-10-30). Engineering Agile Big-Data Systems. River Publishers. ISBN 978-87-7022-016-3.
  7. ^ Feeney, Luke (2019-10-07). "Today we release TerminusDB — the database for data people". Medium. Retrieved 2019-12-06.
  8. ^ "We Love GPLv3, but Are Switching License to Apache 2.0 | Hacker News". news.ycombinator.com. Retrieved 2020-12-09.
  9. ^ "GitHub - terminusdb/terminusdb at v1.0.0". GitHub. Retrieved 2021-09-27.
  10. ^ "GitHub - terminusdb/terminusdb at v1.0.0". GitHub. Retrieved 2021-09-27.
  11. ^ "Release Notes for TerminusDB 2.0 to 10.0". github.com. 24 November 2022.
  12. ^ Feeney, Luke (31 August 2020). "TerminusDB: From 'Master' to Main | Graph Database Blog - News and Tutorials from TerminusDB". terminusdb.com/blog. Retrieved 2021-09-27.
  13. ^ terminusdb/terminusdb, TerminusDB, 2021-09-27, retrieved 2021-09-27
  14. ^ terminusdb/terminusdb, TerminusDB, 2021-09-27, retrieved 2021-09-27
  15. ^ "Release Notes for TerminusDB 10.0". github.com. 24 November 2022.
  16. ^ "Releases · terminusdb/terminusdb". GitHub. Retrieved 2023-02-19.
  17. ^ Feeney, Luke (2019-10-01). "TerminusDB — what's in a name?". Medium. Retrieved 2019-12-06.
  18. ^ terminusdb/terminus-store, TerminusDB, 2020-05-06, retrieved 2020-05-06
  19. ^ "Succinct Data Structures and Delta Encoding for Modern Databases" (PDF). GitHub. 24 November 2022.
  20. ^ terminusdb/terminus-client, TerminusDB, 2020-04-29, retrieved 2020-05-06
  21. ^ terminusdb/terminus-client-python, TerminusDB, 2020-05-06, retrieved 2020-05-06
  22. ^ Gavin (2023-02-07). "Putting the Graph in GraphQL Query". TerminusDB. Retrieved 2023-02-19.
  23. ^ "Taking TerminusDB to The Bank (Part I)". Graph Database Blog - News and Tutorials from TerminusDB. Retrieved 2020-12-09.
  24. ^ "TerminusDB Introduces TerminusCMS, Brand Networks Acquired by Augeo, More News". CMSWire.com. Retrieved 2023-02-19.

External links[edit]

Retrieved from "https://en.wikipedia.org/w/index.php?title=TerminusDB&oldid=1191416545"