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

Database query method and device

A data query and database technology, applied in the field of database query, can solve the problem of high compatibility between SQL database and ODBC database, and achieve the effect of reducing development costs

Inactive Publication Date: 2017-06-06
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The invention provides a method and device for database query, which can solve the problem of high compatibility cost between SQL database and ODBC database

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
  • Database query method and device
  • Database query method and device
  • Database query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0024] Please refer to figure 1 , which shows a flowchart of a database query method provided by this embodiment. Such as figure 1 As shown, the method for database query may include the following steps:

[0025] 101. Receive a structured query language SQL script.

[0026] The SQL script is carried in the query request sent by the front end for database query. Variables used as query conditions are included in the SQL script. ...

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 database query and a device, which relates to the network field, the invention is provided to solve the problem of the higher compatible cost between the SQL database and ODBC database. The method comprises the following steps receiving structured query language SQL script, the SQL script carries change quantity for data query; querying script convertor matching with object database type; converting the SQL script into the executable SQL scrip through the script convertor queried, the executable SQL script is that transfer parameter is consistent with target data type; transferring the executable SQL script to the target database to make the target database carry out data query according to the change quantity carried by the executable SQL script. The invention is applied in the process that the SQL script of named reference form is converted into the SQL script of anonymity reference form.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a database query method and device. Background technique [0002] Structured Query Language (Structured Query Language, referred to as SQL) database is a database that does not need to be described in a procedural language. The queryer only needs to describe the "what to do" of the database through SQL statements, and does not need to care about and describe the "what to do" of the database. How to do it". SQL statements are powerful, easy to learn, and convenient to use, and have become the basis of database operations. At present, almost all databases on the market support SQL queries. [0003] The existing process of SQL database query is that the queryer adds a named parameter (also called variable name) to the business data (also called variable) corresponding to the query condition, and then adds the matching pair of "variable + variable name" to the variable The col...

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): G06F17/30
CPCG06F16/24534G06F16/2455
Inventor 赵立贺
Owner BEIJING GRIDSUM TECH CO LTD
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