A Mapping Method Between Common Information Model and Relational Database

A technology of public information model and mapping method, which is applied in the field of relational database mapping, can solve problems such as waste of storage space, difficult mapping methods, large number of tables, etc., and achieve the effects of avoiding connection operations, improving system performance, and stabilizing table structures

CN103186628BActive Publication Date: 2016-09-28ASAT CHINA TECH +1
3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Publication Date
2016-09-28

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a method for mapping between a CIM (common information model) and a relational database. The method comprises the steps as follows: building meta-model descriptions of a class and an object respectively to remove semantic differences related with the class and the object from the meta-model systems of the class and the object; and mapping meta-models to a relational database so as to build the database tables of the two meta-models, namely a pattern relation table collection (called as a pattern library) formed by mapping the class meta-model and an object relation table collection (called as an object library) formed by mapping the object meta-model. The database built by the method has limited number of tables; and as the meta-models are universal, the situation means that the table struture is stable and the arbitrary expansion requirement and the referential integrity constraint on an infomation model in a CIM appliation can be met.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to a relational database mapping technology Background technique

[0002] Most of the existing common information model (Common Information Model, referred to as "CIM") implementation comes from the Object Management Group (Object Management Group, referred to as "OMG") "Utility Management System (UMS) Data Access Facility Specification" Appendix C - SQL Examples. This document proposes a paradigm for mapping GDA interfaces to SQL statements. This leads to a question: how to map the CIM model described based on the object-oriented model to the relational database.

[0003] In the object model, there are various relationships between objects, such as association, combination, aggregation, inheritance, etc., which cannot be directly expressed in the relational database, which is the so-called relationship between the object model and the relational model. "impedance mismatch". In order to solve these problems, the O / R (object-rel...

Examples

Embodiment Construction

[0066] In order to make the purpose, technical solution and advantages of the present invention clearer, the following will further describe the implementation of the present invention in detail in conjunction with the accompanying drawings.

[0067] A preferred embodiment of the present invention relates to a mapping method between a CIM model and a relational database, which is a specific implementation technology for CIM. CIM is defined by object-oriented modeling technology. According to object-oriented theory, an object is an instance of a class, and a class is an abstract description of a group of things with the same attributes and behaviors. There is also a relationship between classes, and this relationship includes class hierarchical relationships (i.e. inheritance) and class logic relationships (such as association, combination, etc.); the inventors of the present invention have found that since the definition of CIM is to facilitate data exchange, the CIM entity is ...