SQL executing method and device based on multiple database types

A database and type grammar technology, applied in the computer field, can solve the problems affecting the coding efficiency of developers, different grammar structures, etc., to achieve wide application prospects, reduce workload, and improve efficiency.

Inactive Publication Date: 2015-05-13
INSPUR COMMON SOFTWARE
View PDF5 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Customers generally choose one of these database systems when using them. Standard application software products generally support multi-database applications, which requires that multi-database applications should be considered when designing and developing software. However, different The grammatical structure of the database system is different, which causes developers to write a large number of different database system grammatical conversions when coding
For example: if the software product to be developed supports three mainstream databases, one SQL statement needs to be executed according to three different grammars, and three SQL statements with different grammars must be written respectively. This work includes a lot of repetitive work, thus Coding efficiency of developers that has a great impact on the program

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
  • SQL executing method and device based on multiple database types
  • SQL executing method and device based on multiple database types
  • SQL executing method and device based on multiple database types

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. 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.

[0036] An embodiment of the present invention proposes a SQL execution method based on multiple database types, see figure 1 ,include:

[0037] Step 101: Create a global function or method object, set the entry parameters including the first parameter corresponding to the SQL statement to be converted and the second parameter corresponding to the target database type; and set the output result as the converted SQL statement;

[0038] Step 102: In the g...

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 an SQL executing method and device based on multiple database types. The method comprises the steps of calling a global function or a global method, and inputting the current SQL statement according with the grammar of a front universal database to the global function or global method through a first parameter; inputting the current target database type to the global function or global method through a second parameter; executing the global function or global method, and obtaining the SQL statement according with the grammar of the current target database type output by the global function or global method. By the adoption of the SQL executing method and device based on multiple database types, encoding efficiency can be improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to an SQL execution method and device based on multiple database types. Background technique [0002] In the software project of informatization application, it is essential to interact with the database, and there are various types of database management systems. Customers generally choose one of these database systems when using them. Standard application software products generally support multi-database applications, which requires that multi-database applications should be considered when designing and developing software. However, different The grammatical structure of the database system is different, which causes developers to write a large number of grammatical conversions of different database systems when coding. For example: if the software product to be developed supports three mainstream databases, one SQL statement needs to be executed according to three di...

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): G06F17/30
CPCG06F16/25G06F16/903
Inventor 张强任艳青
Owner INSPUR COMMON SOFTWARE
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