Method and system for acquiring background data through structured query language (SQL) custom-made template
A background data and template technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as potential safety hazards, low timeliness, and long cycle
Active Publication Date: 2014-04-02
北京思特奇信息技术股份有限公司
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] The conventional data acquisition method of background database is that business personnel submit requirements and entrust technicians to export data through the database client; this method has problems such as high dependence on technicians, low timeliness, and long cycle; if you are not familiar with SQL Business personnel write SQL directly through the client to obtain data. On the one hand, it takes a long time to get familiar with and understand, and there are also many security risks
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0029] The present invention is mainly composed of three parts: SQL definition and parsing module, template semantic description module, and template-based data acquisition module; SQL definition and parsing module, technicians input SQL language according to business abstraction, and in the SQL definition and parsing module Mark the condition field, and the system performs grammatical analysis on the SQL language, splitting the SQL language into conditions, indicators, and groups; the template semantic description module, through the specified database and the output data of the SQL definition and analysis module, from the database table Obtain metadata corresponding to indicators and conditions. During this process, template designers can also modify relevant metadata. Metadata mainly includes type, length, description, etc. to form a data acquisition template; data acquisition module, users acquire templates through data Select the data column and set the conditions for data...
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
Login to View More Abstract
The invention discloses a method and a system for acquiring background data through a structured query language (SQL) custom-made template. The method comprises the specific operations comprising the following steps of: an SQL defining and analyzing module abstractly inputs SQL according to the service, and marks and analyzes the service in the SQL defining and analyzing module; a template semantization description module acquires metadata with corresponding indexes and conditions from a database through a specified database and the output data from the SQL defining and analyzing module so as to form a data acquisition template; and a data acquisition module selects data columns through the data acquisition template and sets the conditions of the acquired data through the user, executes the operation and acquires the data. The system comprises the SQL defining and analyzing module, the template semantization description module and the data acquisition module based on the template. The flexibility of the SQL is combined with the template, the metadata and the semantic description, and the workload of a technician and barrier in a communication link are effectively relieved.
Description
technical field [0001] In the field of business application systems, the invention provides a semantic language through SQL (Structured Query Language) structured query language definition template, and provides users with a more intuitive, simple and flexible way of acquiring database data. Background technique [0002] SQL is Structured Query Language, which is a database query and programming language used to store and retrieve data and to query, update and manage relational database systems. [0003] The conventional data acquisition method of background database is that business personnel submit requirements and entrust technicians to export data through the database client; this method has problems such as high dependence on technicians, low timeliness, and long cycle; if you are not familiar with SQL Business personnel directly write SQL through the client to obtain data. On the one hand, it takes a long time to get familiar with and understand, and there are also man...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 严敏李定福高建国
Owner 北京思特奇信息技术股份有限公司