Translating database mathematical schemes into relational database software applications with MatBase
For database designers and researchers, this provides a practical translation method from a mathematical data model to relational databases, but the work is incremental as it builds on existing MatBase research.
The paper presents a fast, solid, complete, and optimal algorithm for translating Mathematical Data Model schemes into relational database schemes and non-relational constraints, implemented in the MatBase system, with application to genealogical tree modeling.
We present a pseudocode algorithm for translating our (Elementary) Mathematical Data Model schemes into relational ones and associated sets of non-relational constraints, used by MatBase, our intelligent data and knowledge base management system prototype. We prove that this algorithm is very fast, solid, complete, and optimal. We apply it to a Mathema tical scheme modeling the genealogical trees subuniverse. We also provide examples of SQL and VBA code for enforcing some of its non-relational constraints, as well as guidelines to develop code for enforcing such constraints.