Multi-source database statement checking method and device

An inspection method and inspection device technology, applied in the database field, can solve problems such as consuming database resources, and achieve the effect of improving accuracy and execution efficiency

Pending Publication Date: 2020-11-17
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF1 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the existing statement analysis method needs to connect to the database to submit the statement to a specific database to obtain the statement execution plan for inspection, which needs to consume database resources for 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
  • Multi-source database statement checking method and device
  • Multi-source database statement checking method and device
  • Multi-source database statement checking method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0050] It should be noted that this application can be used in the field of big data technology, and can also be used in any field other than the field of big data technology, and the application technology field of the application is not limited.

[0051]In order to solve the problems in the prior art, according to one aspect of the present invention, this embodiment discloses a multi-source database statement checking method. Such as figure 1 As shown, in t...

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 multi-source database statement checking method and device, which can be applied to the technical field of big data, and the method comprises the following steps: performing grammatical analysis on to-be-analyzed structured query statements respectively corresponding to a plurality of databases to obtain an abstract syntax tree; determining preset rules according to the databases corresponding to the to-be-analyzed structured query statements; and performing rule analysis on the structured query statements of the abstract syntax tree node through the preset rules to obtain a statement check result. The invention can realize check of the structured query statement of the multi-source databases so as to improve accuracy and the execution efficiency of the structuredquery statements.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to the technical field of big data, in particular to a multi-source database statement checking method and device. Background technique [0002] With the continuous development of Internet technology, the storage of data information is not limited to a single stand-alone relational database. More and more enterprises begin to use distributed database and big data technology to deal with massive data scenarios. By writing SQL (structured query language) to operate on data in the database. For business personnel, data analysts, etc., facing a variety of heterogeneous data sources, if they are not familiar with the characteristics of each data source, it is easy to write SQL scripts with low execution efficiency. In a production environment, SQL scripts with low execution efficiency will occupy more computer resources, which in turn will affect the normal development of othe...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36G06F8/41
CPCG06F11/3604G06F8/427
Inventor 罗玮唐家星阳兵黄萌
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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