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. …

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…

Schema-Aware Semantic Search with FactEngine — There are multiple ways that Schema-Aware Semantic Search has been delivered; this article focuses on how it is achieved using FactEngine. Let us has a look at what Schema-Aware Semantic Search is. The term, “Semantic Search”, generally means: Returning results for a natural language query over a knowledge store where…

In defense of graphs within graphs — and/or hypergraphs — For those of you familiar with FactEngine Query Language (FEQL), you may have noticed that every piece of data is considered as if it were a node in a graph database. Take the following FEQL query for instance: The FEQL query is asking to show a list of employees that…