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

Method and system for converting query sentence of database

A query statement and conversion system technology, applied in the field of database query statement conversion and conversion system, can solve problems such as inability to meet new requirements, time lag, and inconvenient use

Inactive Publication Date: 2010-07-28
厦门东南融通系统工程有限公司
View PDF0 Cites 77 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since the query functions provided in the software application system are all pre-designed, when users need to make new queries, they can only do so by upgrading the system. There is a time lag, and it is still unable to meet possible new needs in the future.
Querying through database tools can meet the user's new query needs at any time, but if the user is not proficient in database tools and SQL (Structured Query Language) syntax (usually in English), he cannot query the database flexibly and freely. cause inconvenience

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 system for converting query sentence of database
  • Method and system for converting query sentence of database
  • Method and system for converting query sentence of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The present invention is applicable to the auditing system or business system based on the J2EE framework technology platform, and the translation of database query sentences and business data processing activities can only be performed depending on the basic table of the tool or the database table and standard field table of the business system.

[0043] like Figure 4 , 5As shown, the conversion system based on the present invention includes two parts of a translator 1 (Translator) and a compiler 2 (Compiler). The translator 1 is responsible for the interactive work with the business system 3, and the compiler 2 is responsible for syntax verification and data processing, etc. core work. The present invention applies the ANTLR meta-language technology tool (a language recognition tool), uses BNF Backus-Naur Form (Backus-Naur Form) to carry out grammar definition, adopts the grammatical compilation principle technology based on LL (K) to realize, and realizes database ...

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 a method and a system for converting the query sentence of a database. After a database table and a field are set, the name and field of the required database are selected in the foreground and the self-defined query sentence is inputted by a user according to the service requirement, and the query sentence inputted by the user is subjected to grammar analysis and validation, thus finishing the analysis by scanning the query sentence for only one time. By converting the service Chinese query sentence into a standard English SQL (structured query language) query sentence required by a service system, the invention fulfills the function of converting a service database query sentence into a standard executable SQL sentence, wherein the sentence acquired by the service system is directly available to the system, so that a common user can flexibly and freely use the database without mastering the query tool, SQL syntax and other professional technique of the database.

Description

technical field [0001] The invention relates to a conversion method and a conversion system of database query sentences. Background technique [0002] In current large-scale software application systems, it is often necessary to combine programs and databases for use. These databases can be queried through the query function provided by the software application system, or through the database tools provided by the database manufacturer. Since the query functions provided in the software application system are all pre-designed, when users need to make new queries, they can only do so by upgrading the system. There is a time lag, and it still cannot meet possible new needs in the future. Querying through database tools can meet the user's new query needs at any time, but if the user is not proficient in database tools and familiar with SQL (Structured Query Language) syntax (usually in English), he cannot query the database flexibly and freely. cause inconvenience in use. ...

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
Inventor 贾晓工刘荣黄建德
Owner 厦门东南融通系统工程有限公司
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