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

A method and system for dynamically extending SQL query statements based on annotations

A query statement and dynamic expansion technology, which is applied in the fields of instruments, computing, and electrical and digital data processing, and can solve the problem that SQL query statements cannot be dynamically expanded.

Active Publication Date: 2021-05-28
AEROSPACE INFORMATION
View PDF6 Cites 0 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
  • A method and system for dynamically extending SQL query statements based on annotations
  • A method and system for dynamically extending SQL query statements based on annotations

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0131] After adding annotations to the original SQL query statement, it becomes:

[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 present invention discloses a method and system for dynamically extending SQL query statements based on annotations. The method is characterized in that the method includes: acquiring an existing SQL query statement and one or more of the existing SQL query statements to be applied. Scene; analyze the one or more scenarios to determine the structure of the existing SQL query statement; according to the annotation adding rules and according to the structure of the existing SQL query statement, the existing SQL query statement Configure the annotations to obtain the annotated SQL query statement; analyze the annotation parameters of the annotated SQL query statement to obtain the queried related column information, associated database table information, query conditions and sorting methods; and according to the Describe the queried related column information, associated database table information, query conditions and sorting methods and use the expansion rules to dynamically expand the annotated SQL query statement.

Description

technical field [0001] The present invention relates to the field of SQL statement processing, and more specifically, relates to a method and system for dynamically expanding SQL query statements based on annotations. Background technique [0002] Informatization has become the general trend of world economic and social development, and the construction of information system 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 presentation styles for the presentation of the same type of data. [0003] In order to meet these needs, we classify customers and develop industry-specific pages for different industries and regions, which can increase the adaptability of our software. But this cannot fully meet the individual needs of each industry or region. Therefore, for the same inqu...

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