Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for dynamically expanding SQL query statements based on annotations

A query statement and dynamic expansion technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problem that SQL query statements cannot be dynamically expanded

Active Publication Date: 2019-07-16
AEROSPACE INFORMATION
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a method and system for dynamically expanding SQL query statements based on annotations to solve the problem that existing SQL query statements cannot be dynamically expanded

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 and system for dynamically expanding SQL query statements based on annotations
  • Method and system for dynamically expanding SQL query statements based on annotations
  • Method and system for dynamically expanding SQL query statements based on annotations

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0131] The original SQL query statement is annotated as follows:

[0132] Select a.field1@field[a.field1]

[0133] from table_a a@table[table_a a]

[0134] where a.name="Name"

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 and a system for dynamically expanding SQL (Structured Query Language) query statements based on annotations, and is characterized in that the method comprises the following steps: acquiring existing SQL query statements and one or more scenes to which the existing SQL query statements are applied; analyzing the one or more scenes, and determining the structure ofthe existing SQL query statement; according to an annotation adding rule and the structure of the existing SQL query statement, configuring the annotation of the existing SQL query statement, and obtaining the annotated SQL query statement; analyzing annotation parameters of the annotated SQL query statement to obtain queried related column information, associated database table information, queryconditions and a sorting mode; and performing dynamic expansion on the annotated SQL query statement by utilizing an expansion rule according to the queried related column information, the associateddatabase table information, the query condition and the sorting mode.

Description

Technical field [0001] The present invention relates to the field of SQL statement processing, and more specifically, to a method and system for dynamically expanding SQL query statements based on annotations. Background technique [0002] Informatization has become a major trend in world economic and social development, and the construction of information systems is the key to informatization work. This is enough to see the importance of information systems. In our software products, in order to meet the various needs of different industries, different regions, and different customers, there will be multiple display styles for the display of the same type of data. [0003] In order to meet these needs, we classify customers and develop industry-specific pages for different industries, different regions, etc. This can increase the adaptability of our software. But this does not fully meet the individual needs of each industry or region. Therefore, for the same query requirements,...

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): G06F16/2453
CPCG06F16/24547
Inventor 曹召换解军伟
Owner AEROSPACE INFORMATION