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

Unified SQL execution and query method and system

A query method and query system technology, applied in the field of unified SQL execution and query, can solve problems such as accidents and distribution, and achieve the effect of improving security

Pending Publication Date: 2020-09-11
SF TECH
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the expansion of business scale and diversification of business forms, there are more and more database instances. Database operation and maintenance personnel log in to the database to execute SQL. Whether using a visual database tool or logging in to the database through commands in the Linux environment, not only the database IP, For port, user name, password and other information, you need to log in to the database through the bastion host and springboard host, and to execute SQL in different databases, you need to execute them one by one, and you cannot uniformly send SQL to different database instances
If the operation and maintenance personnel accidentally execute a wrong SQL, the executed SQL has no whitelist restrictions, which can easily cause accidents

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
  • Unified SQL execution and query method and system
  • Unified SQL execution and query method and system
  • Unified SQL execution and query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] The unified SQL execution and query method of this embodiment includes:

[0040] S1: Obtain database related information, query a matching database, and select a database, which is used to execute SQL statements;

[0041] Wherein, the database-related information includes the name of the database instance or the IP address.

[0042] S1 includes: selecting databases in batches, and the databases are used to execute SQL statements.

[0043] First, the user enters the instance name or ip, and queries the database instance that meets the conditions. The user selects the database that needs to execute SQL statements. Here, users can select databases in batches. The SQL input box supports the input of multiple different types of SQL statements and supports SQL statement comments. filter.

[0044] In this embodiment, by selecting databases to execute SQL statements in batches, the SQL statements can be uniformly distributed to different database instances, and batch databases are suppo...

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 unified SQL execution and query method and system. The method comprises the following steps: obtaining database related information, inquiring a matching database, selectingthe database, wherein the database is used for executing SQL statements; receiving an SQL statement, checking whether the SQL statement is in a white list; if the SQL statement is in the white list,checking the SQL grammar, and if the grammar is correct, analyzing the type of the SQL statement; and transferring the SQL statement into a server for execution, and returning a result set. Accordingto the invention, a related information instance name or ip is input; database operation and maintenance personnel can execute SQL without logging in the database; the database ip, the port, the username, the password and other information do not need to be owned, a bastion host and a springboard machine are not needed, the SQL can be issued to different database instances in a unified mode, batch databases are supported to execute the unified SQL, and in addition, a white list is arranged, so that the safety of a database system is improved.

Description

Technical field [0001] The present invention relates to the field of database technology, in particular to a unified SQL execution and query method and system. Background technique [0002] With the expansion of business scale and diversification of business forms, there are more and more database instances. Database operation and maintenance personnel log in to the database to execute SQL. Whether using visual database tools or logging in to the database through commands in a Linux environment, not only need to have database ip, Port, user name, password and other information, you also need to log in to the bastion machine, jumper to log in to the database, and to execute SQL in different databases, it also needs to be executed one by one, and SQL cannot be uniformly distributed to different database instances . If the operation and maintenance personnel accidentally executes a wrong SQL, the executed SQL is not restricted by the whitelist, which can easily cause accidents. Su...

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/242
Inventor 陈小玲钟易程
Owner SF TECH
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