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

Method and device for querying databases

A query method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve a large number of development and maintenance costs, reduce system performance and other problems, and achieve the effect of low development and maintenance costs

Inactive Publication Date: 2010-05-12
BEIJING ZHONGCHUANG TELECOM TEST
View PDF3 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

With the continuous increase of the system, the types of databases are gradually increasing, and the application scenarios of SQL queries are becoming more and more complex. If a development framework (such as Hibernate) that can support different The database is queried, but the development framework requires a lot of development and maintenance costs, and when the amount of data in the database in the system is large, the performance of the system will be reduced

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 device for querying databases
  • Method and device for querying databases
  • Method and device for querying databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to realize the purpose of the present invention, the present invention provides a database query method and device. The method converts the first SQL for querying a certain type of database to obtain the second SQL, and uses the second SQL to query the database.

[0045] The above is the core idea of ​​the present invention. In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying 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.

[0046]...

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 embodiment of the invention discloses a method and a device for querying databases. The method for querying the databases specifically comprises the following steps of: receiving a first structured query language (SQL) for querying a target database of a certain type; according to a preset SQL processing class, converting the first SQL into a second SQL; and querying the target database by using the second SQL. By using the method for querying the databases, the conversion from certain SQL to another SQL can be achieved by using a very small amount of code developments or modifiers so as to support different database types. The method for querying the databases develops a system simultaneously applicable for various database types with a low development cost, and achieves the support to various database types; besides, the system performance cannot be reduced by the use of a development framework.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database query method and device. Background technique [0002] SQL (Structured Query Language, Structured Query Language) is a set of operation commands specially established for databases, and it is a database language. The main function of SQL is to establish relationships with various databases and enable communication between different types of databases. According to ANSI (American National Standards Institute), SQL is used as a standard language for relational database management systems. When using SQL, you only need to issue the "what to do" command without thinking about "how to do it". SQL statements can be used to perform various operations on the database, such as updating data in the database, extracting data from the database, and so on. At present, most popular relational database management systems, such as Oracle, Sybase, Microsoft SQL Server, Access, etc...

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
Inventor 贾林李永利袁大勇钱世启
Owner BEIJING ZHONGCHUANG TELECOM TEST
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