The Object-Role Model Unifying Metamodel — I’ve released my research publicly so that it can be enjoyed by all, link below: Applied Use of Ehrenfeucht Fraisse Games in Conceptual Model Management and Model Transformation In essence, the thesis is that the model transformation technology behind the Boston Architecture behind the Boston Multi-Model Conceptual Modelling software and…

When the penny drops — For years now I have marveled at Derived Fact Types in Object-Role Modeling. Derived Fact Types provide the ability to turn your database into an expert system or or knowledge base system, implementing rules/inference rules over the data in your database. In the 1980s, 90s and early 2000s there were…

Advancement of morphing in the Boston conceptual modelling software — Just over 20 years ago I was employed as a business analyst and took a conceptual model to an architect for review and approval. He took one look at it and asked if I could do the same conceptual model in another language from the one I had drawn the…

Controlled Natural Language to TypeQL…push a button FactEngine is an initiative to radically rethink how databases are designed, viewed and queried. The ultimate goal is to make life easier, and that includes controlled natural language queries over your database. TypeDB is a new breed of database that is based on…

Visual GUI development of a TypeDB database schema — TypeDB is part of a new breed of database management tools that utilises Hypergraph Theory to define the database schema and for operations over data in that database. In an earlier article I outlined the architecture of the product I produce, FactEngine, which also overlays a hypergraph schema over a…

A closer look at Machine Learning for Text-to-SQL — In an earlier article I took a critical look at the likes of the Spider Challenge, a competition to produce a machine learning apparatus to convert natural language queries into SQL. My conclusion, on looking closely at the challenge, is that if at the time of evaluation, the ML apparatus…

Why FactEngine won’t be entering the Spider Text-to-SQL Challenge — Text-to-SQL is a space that has garnered a lot of attention, and I’m going to call it as an AI-Complete problem. Regardless of how well any entrant does in any Text-to-SQL challenge, such as the Spider Challenge, there will always be a model and text that will require human level…

The finer points of how FactEngine semantic parsing works — In the query above, a provider is identified by their name, Kathy Snelling, but how does FactEngine know that a provider is identified by their first name followed by their last name? Why isn’t it last name followed by first name? If we…