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.
翻译:我们提出了一种伪代码算法,用于将(基础)数学数据模型模式转换为关系模式及其相关的非关系约束集,该算法被我们的智能数据与知识库管理系统原型MatBase所采用。我们证明了该算法具有极快、稳健、完备且最优的特性。我们将其应用于一个建模谱系树子宇宙的数学模式。同时,我们提供了实施其中部分非关系约束的SQL和VBA代码示例,以及开发此类约束代码的指导原则。