Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction

A replacement method and marking technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as background data limitations, and achieve the effect of improving system support and ease of use

Inactive Publication Date: 2013-12-25
北京思特奇信息技术股份有限公司
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is to provide a method and system for realizing data self-fetching by using the SQL tag replacement method, which is used to solve the problem of limitations in using SQL to obtain background data in the prior art

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 adopting structured query language (SQL) mark substitution method to achieve data self-extraction
  • Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction
  • Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0031] Such as figure 1 As shown, this embodiment provides a method for implementing data self-fetching using the SQL tag replacement method, including:

[0032] Step 1: For SQL of any complexity, when it needs to perform visual retrieval, mark the fields and conditions in the SQL that need to be displayed;

[0033] Step 2: Parse the optional export fields and optional export conditions in the marked SQL, and obtain the metadata information corresponding to the fields and conditions from the specified database system table according to the parsed data;

[0034] Step 3: Generate an access template for the marked SQL based on the obtained metadata information;

[0035] Step 4: When extracting data, enter the SQL fie...

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 method for adopting a structured query language (SQL) mark substitution method to achieve data self-extraction. The method comprises a first step of marking fields and conditions needing displaying in an SQL when the SQL with a random complexity needs to perform visualized data extraction, a second step of parsing selectable derived fields and selectable derived conditions in the SQL after marking, and obtaining metadata information corresponding to the fields and the conditions from an appointed database table according to the parsed data, a third step of generating a data extraction template aiming at all the marked SQLs on the basis of the obtained metadata information, and a fourth step of inputting marks of SQL fields and conditions needing extracting when the data are extracted, adopting the generated data extraction template to obtain the metadata information matched with the corresponding marks, utilizing the metadata information to substitute the fields and conditions needing extracting, and deriving the SQL after substitution. By establishing the data extraction template, the SQL is solidified to be in a graphic interface mode, and system supporting capacity and usability are improved.

Description

technical field [0001] The present invention relates to the field of computer business application technology, in particular to a method and system for realizing data self-fetching by using SQL (Structured Query Language, Structured Query Language) tag replacement method. Background technique [0002] SQL is Structured Query Language, which is a database query and programming language used to access data to query, update and manage database systems. [0003] The conventional way to obtain background database data is that business personnel submit requirements and entrust technical personnel to export data through the database client. This method is troublesome for those who are not familiar with SQL. Therefore, the existing database system pursues higher usability under the premise of ensuring that the needs of users are met, and needs to put more complex operations in the background program for analysis and processing, which requires the analysis program to be more intellig...

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 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