Relational database storage-based objective data model query method and device
A data model and database technology, applied in the field of database query, can solve the problems of inability to accurately locate the main model object and its embedded sub-model objects, limit the application scope of object model-based data management, and difficult to query functions.
Active Publication Date: 2016-01-13
FOUNDER INTERNATIONAL CO LTD +1
View PDF4 Cites 18 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Or although you can set the conditions of the main model element and its embedded sub-model array at the same time, you can only locate the main model object, and you cannot accurately locate the combination of the main model object and its embedded sub-model objects that meet the conditions. , which greatly limits the scope of application of object-based data management, making it difficult to complete more complex query functions
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0058] The method for querying object-oriented data models based on relational database storage provided by the present invention will be described in more detail below in conjunction with the accompanying drawings and embodiments.
[0059] A major feature of the master data management system is to describe data in the form of an object-oriented data model, separate the presentation mode from the internal storage mode, and more often display data in the form of business objects. However, due to the two-dimensional table storage mode of the underlying relational database, its query access based on business objects is greatly restricted. It can only set simple attribute conditions and use the main model object as the retrieval target, or cannot use combined conditions, or cannot locate internal Embedded model objects have various flaws.
[0060] The purpose of the present invention is to solve the connection conversion difference between object model-based data management and re...
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
Login to View More Abstract
The invention provides a relational database storage-based objective data model query method and device. The method comprises the following steps: receiving a query request transmitted by a user, wherein the query request comprises one or more conditional terms or a combination relation thereof; associating tables with an association relation in a relation database in advance according to a data model structure of a structured object, and setting the conditional terms and optional combination relation between the conditional terms; determining an expansion method on the basis of the association relation between the tables in a relational database and query request conditions, and expanding the content recorded in all tables into a two-dimensional virtual view including a plurality of records according to the determined expansion method, wherein one record comprises the content of all elements included in various branches in the data model of the structured object; and searching the records which conform to the query conditions in the two-dimensional virtual view, and displaying the records in a query interface according to the form of the data model of the structured object. According to the relational database storage-based objective data model query method and device, the retrieval efficiency of the relational database is improved.
Description
technical field [0001] The invention relates to the technical field of database query, in particular to an object-based data model query method and device based on relational database storage. Background technique [0002] The structured data in the traditional data center is stored in a relational database. The advantage is that the relationship is clear and the data query and access efficiency is high. The disadvantage is that the data is stored in multiple tables, which is far away from the business concept, poor intuition, and difficult to understand. Therefore, in recent years, the master data management (MDM) system has gradually emerged. The master data management system manages data in the form of an object-oriented data model, which is closer to business practice and is more intuitive and intuitive for both data managers and users. easy to use. [0003] However, since relational databases are widely used in data centers at present, the underlying storage of object ...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/24534G06F16/284
Inventor 刘畅周大良李平立王生
Owner FOUNDER INTERNATIONAL CO LTD