Relational Databases as Graph Databases = Mindful (openCypher-2-SQL) — A limited subset of openCypher graph queries over any relational database is the Mindful initiative. The queries are read-only and without metagraph queries at this stage. Mindful is a closed-source modification of Microsoft’s openCypher to SQL transpiler under the MIT license, and where Mindful generates SQL to operate over any…

Redefining the Relational Database and its DDL — FactEngine’s mission is to radically change how people envision databases and knowledge graphs. Every database can be viewed as either a graph or relational database and FactEngine exploits this. FactEngine pioneered this notion with the release of the Boston multi-model conceptual modelling software: Relational Graphs / Graph Relational Databases The vision is expanded to develop software…

And it said… — During a conversation on B-Trees and the structure of a SQLite database file…I asked… It’s like mingled spaghetti, but where each spaghetti joins at the root? ChatGPT said… While the analogy of “mingled spaghetti” may not accurately represent the internal organization of a B-tree in SQLite, I understand the idea…

How and when ORM models can be unambiguous — I have written quite a bit about the cases where sentences of Object-Role Modeling (ORM) may be ambiguous, and without having heard a word, I know it upsets some in the ORM community who hold onto a Platonic ideal of an isomorphism of ORM models to theorems of finite model…

ORM2 is a type of fact-based modelling — 2023–03–18 — Resubmitted in full, with further notes for genuine researchers. Original of this article at 2023–03–01 on GitHub: here ORM2 (Object-Role Modeling v2) is a type of fact-based modeling, which is a type of concept Role Modeling is a graphical language. The short answer to the question posed in…

Why a proof theoretic mapping of greater Object-Role Modeling to a theory under finite model theory holds no guarantee of unambiguous models. — In an earlier article we explored why certain graphical models of Object-Role Modeling can be ambiguous and where for any semblance of formalism to be attributable to Object-Role Modeling (ORM), models under ORM need to be seen in the greater context of the natural language verbalisations that may be derived…

Understanding the triumvirate of Object-Role Modeling — Object-Role Modeling (ORM) is a amalgamous conceptual modelling system used for various tasks including database design, capturing business rules and developing ontologies. In some guises, ORM is used to express the logical construction of a conceptual model ranging over a Universe-of-Discourse. In this article we explore how modern-day Object-Role Modeling…

A suitable counterexample to the notion that the graphical notation of Object-Role Modeling is unambiguous — We take a model for a UoD (Universe of Discourse) where we model the data requirements to store information about Round the World Tickets for an Airline. The scenario is where a person outlines the cities and countries that they would like to visit, and where the data model captures…

A 29 Year History of Building NIAM/ORM Software — It dawned on me the other day that people don’t know what they don’t know and that on a global scale those who use Object-Role Modeling (ORM) are entitled to ask “who is this chump?” when they think of Object-Role Modeling and FactEngine. When I think about it, only a…