Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Relational data semantic modeling method

A technology of relational data and modeling method, applied in the direction of relational database, database model, semantic tool creation, etc., can solve the problems of inconvenient cross-domain query and analysis, complex database client integration, etc., and achieve good scalability and rapid establishment with the effect of refactoring

Pending Publication Date: 2019-07-16
SHENYANG INST OF AUTOMATION - CHINESE ACAD OF SCI
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention mainly aims at the problem that the integration of various database clients in the cross-data source relational database is complicated and inconvenient for cross-domain query and analysis

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
  • Relational data semantic modeling method
  • Relational data semantic modeling method
  • Relational data semantic modeling method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] In order to make the object, technical solution and advantages of the present invention clearer and clearer, the detailed description will be given below with reference to the accompanying drawings.

[0043] The invention proposes a semantic modeling scheme for relational data. Firstly, the data is extracted from the multi-dimensional relational database, and the entity model is generated, in which the user selects the database and data table required for modeling. Then, according to the entity selection result, secondary data extraction is performed in the relevant data source data table to obtain field information, and the database, data table, table name, field and other information are layered and displayed to the user in the form of a node graph. Users establish direct associations between tables and fields by dragging and dropping nodes, connections, and configurations, thereby endowing data with semantic relationships. Finally, a cross-data source relationship mo...

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 relates to a relational data semantic modeling method, which comprises the following steps of: performing data extraction on multi-data source data information on the basis of a multi-dimensional dissimilar data source to obtain a database and data table information; and then selecting a data table required by modeling according to the modeling requirement of the user, completing thevisual deployment of the hierarchical model, and generating a modeling canvas. The user generates a rule document in the JSON format in a node dragging and configuration mode. Multi-user and multi-canvas model establishment is realized through user management and canvas management functions, and finally, a semantic data model is established according to multi-dimensional relational database dataand rules. According to the method, bottom layer support is provided for summarizing and analyzing the multi-data source data, multi-dimensional information is summarized, effective integration and sharing of the data are achieved, and interoperability of resources is improved. The method has good expandability, is convenient for adding new data sources and data tables, and does not influence theuse of the original system.

Description

technical field [0001] The invention relates to a multi-dimensional relational database data collection and semantic modeling method, and belongs to the field of semantic modeling. Background technique [0002] With the rapid development of information technology, the application of information technology is gradually moving towards data access and decision support of multi-dimensional heterogeneous data sources. As the data sources involved in many industries continue to expand and the scope of information sharing continues to expand, the problem of how to effectively communicate and share information between heterogeneous databases has become increasingly prominent. In traditional data integration analysis, managers will use different information management systems, and the data between various systems cannot be interconnected. In terms of data acquisition, according to the original database connection method, the integration of various database clients is complicated. Di...

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): G06F16/28G06F16/36
CPCG06F16/283G06F16/284G06F16/36
Inventor 陈昊飞王挺于海斌曾鹏佟星
Owner SHENYANG INST OF AUTOMATION - CHINESE ACAD OF SCI
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com