Recent work on database application development platforms has sought to include a declarative formulation of a conceptual data model in the application code, using annotations or attributes. Some recent work has used metadata to include the details of such formulations in the physical database, and this approach brings significant advantages in that the model can be enforced across a range of applications for a single database. In previous work, we have discussed the advantages for enterprise integration of typed graph data models (TGM), which can play a similar role in graphical databases, leveraging the existing support for the unified modelling language UML. Ideally, the integration of systems designed with different models, for example, graphical and relational database, should also be supported. In this work, we implement this approach, using metadata in a relational database management system (DBMS).
翻译:近期关于数据库应用开发平台的研究致力于在应用程序代码中以声明方式定义概念数据模型,并采用注解或属性标记实现。部分最新研究利用元数据将此类建模细节纳入物理数据库,该方法具有显著优势,即能够在同一数据库的多个应用间强制执行该模型。在前期工作中,我们探讨了类型化图数据模型(TGM)对企业集成的优势——该模型可借助对统一建模语言(UML)的现有支持,在图形化数据库中发挥类似作用。理想情况下,应同时支持不同模型设计的系统集成,例如图形数据库与关系数据库的集成。本研究通过关系数据库管理系统(DBMS)中的元数据实现了该方案。