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

Method for providing data service for multi-source data unified SQL

A data service and multi-source data technology, applied in database models, electronic digital data processing, structured data retrieval, etc., can solve problems such as low efficiency, limited cross-platform, and inability to capitalize data, so as to ensure efficiency and prevent unsatisfactory Effects of Compatibility Issues

Active Publication Date: 2020-02-25
中科大数据研究院
View PDF3 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] For the current multi-source data, it is difficult to record new data storage, existing data records cannot be managed uniformly, data cannot be capitalized, and traditional cross-platform data acquisition methods are limited and inefficient.
The present invention provides a method for providing data services with multi-source data unified SQL, which solves the problem of integrating and analyzing external data and systems while maintaining the independence of other systems

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 providing data service for multi-source data unified SQL
  • Method for providing data service for multi-source data unified SQL
  • Method for providing data service for multi-source data unified SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] This embodiment implements a method for standardizing data processing and automatically generating data services through unified SQL. refer to figure 1 shown. First, build data standards through the self-developed data governance platform, add data label management, clarify data element definitions and data element formats, and then automatically generate the data model required by the client through custom selection fields, and then combine data elements, data Model version control forms a set of independent and unique data elements and data models. Then, the client sinks the built data model to the external database according to its actual business needs. Finally, according to the unified SQL, the local server directly generates a Restful-style interface to provide data services for the client to use.

[0028] The specific implementation process of data label management is: refine labels through industry and standard classification, form a tree structure, labels ca...

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 provides a method for providing data service for multi-source data unified SQL. The method comprises the steps of data label management, data element standard management, data model management, data instantiation management and data service management. According to the method, standardized management of the data is realized, and the unified CRUD method of the heterogeneous data is provided through the standardized SQL. And the problems of disorder of data formats and definitions, disorder caused by different architecture modes of DBAs with different capability levels to the database, and difficulty in integration of different DSLs are solved. The problem of fusion analysis of external data and the system under the condition of keeping independence of other systems is solved.Unified data management of a multi-data system and multiple data sources and standardization, capitalization and servitization of a data layer are realized.

Description

technical field [0001] The invention belongs to the fields of data management and data middle platform, and relates to a method for providing data by unified SQL of multi-source data. Background technique [0002] In the current society, the amount of data is growing explosively. According to different systems and business needs, many different databases have also been born, including relational databases, document databases, retrieval databases, columnar databases, and graph databases. Different databases are designed in different ways, and their data content formats are independent of each other, which cannot be effectively integrated and utilized by the cloud application platform (Saas), so that the data center can only provide limited data services, and many current databases also have a certain learning and use cost. , it is obviously difficult for most programmers to fully grasp. [0003] The definition of data standards has a large degree of freedom, which leads to d...

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/21G06F16/242G06F16/28
CPCG06F16/21G06F16/219G06F16/242G06F16/28
Inventor 冯凯贵恒王元卓
Owner 中科大数据研究院
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