Method for mapping 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

Active Publication Date: 2013-07-03
ASAT CHINA TECH
View PDF3 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This leads to a question: how to map the CIM model based on the object-oriented model description to the relational database
There are at least hundreds of classes in the CIM object model, plus the complex relationship between classes, the object-relational model established based on this mapping method has a huge number of tables, which leads to poor maintainability of the system
[0010] 2. A large number of join operations - due to the existence of a large number of relational tables, importing an object requires multiple join operations, which usually loses the performance of database operations, although single-table inheritance and specific table inheritance can avoid problems caused by inheritance relationships. T

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for mapping between common information model and relational database
  • Method for mapping between common information model and relational database
  • Method for mapping between common information model and relational database

Examples

Experimental program
Comparison scheme
Effect test

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 ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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.

Description

technical field [0001] The invention relates to a relational database mapping technology Background technique [0002] Most of the implementations of the existing Common Information Model ("CIM") come from the Object Management Group ("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-relational) mapping method based on the structure mapping mode is mostly us...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 俞高宇林吉梁俊
Owner ASAT CHINA TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap