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 database management system prototype. We prove that this algorithm is very fast, solid, complete, and optimal. We apply it to a mathematical 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.
翻译:本文提出一种伪代码算法,用于将我们的(基础)数学数据模型模式转化为关系型模式及相关的非关系型约束集合,该算法应用于我们研发的智能数据库管理系统原型MatBase。我们证明该算法具有极高的执行效率、鲁棒性、完备性和最优性。通过将其应用于家谱树子宇宙建模的数学模式,我们验证了算法的有效性。同时,本文提供了用于实施部分非关系型约束的SQL和VBA代码示例,并给出了开发此类约束实施代码的指导原则。