Method for timely and rapidly analyzing records in relational database
A rapid analysis and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of high system resource occupancy, time occupation, bloated intermediate table structure, etc.
Inactive Publication Date: 2017-02-22
SHANDONG WELL DATA CO LTD
View PDF6 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0002] When analyzing a large number of records in a relational database, it is necessary to obtain the analysis record rule information from multiple tables. When the amount of records is relatively large, there are problems such as slow analysis speed and high system resource usage. How to design a non-fixed column record data table structure , is a difficult problem in analyzing records at present. If the intermediate table is designed according to the largest column, the structure of the intermediate table will be particularly bloated, which will inevitably affect the operation speed; if each field in the record is separated by a delimiter. Strings are placed in a field, and the strings are split when used, so the process of assembling and splitting strings will also take a lot of time
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 1
[0044] Three rules are needed to analyze the original record. If the previous model is followed, the number of fields in the intermediate table is: original record (5 fields) + rule 1 (5 fields) + rule 2 (17 fields) + rule 3 (5 fields)+the rest (5 fields)=32 fields. If the original record and the rule field are combined and stored with the select statement, the number of intermediate table fields is: original record (1 field) + rule 1 (1 field) + rule 2 (1 field) + rule 3 (1 field) + The rest (5 fields) = 9 fields. The number of fields in the intermediate table is only one-third of the previous one.
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 relates to a method for timely and rapidly analyzing records in a relational database. According to the method, the records are timely and rapidly analyzed by building an intermediate table and a task table, starting an automatic scheduling program and storing the multiple unfixed columns of records into a field. The method comprises the following steps of building the task table; interposing and updating data of the task table; building the intermediate table; starting the automatic task scheduling program, periodically and automatically analyzing tasks in the task table, and periodically analyzing the records in the intermediate table; periodically and automatically analyzing the tasks in the task table; periodically and automatically analyzing the data of the intermediate table; and storing the multiple unfixed columns of records into the field of the intermediate table via a select statement, splitting the records via an exec command and then interposing the split records into a temporary table when in use, thus achieving timely and rapid analysis of the records.
Description
technical field [0001] The invention relates to a method for timely and fast analysis of records, in particular to a method for timely and fast analysis of records in a relational database. Background technique [0002] When analyzing a large number of records in a relational database, it is necessary to obtain the analysis record rule information from multiple tables. When the amount of records is relatively large, there are problems such as slow analysis speed and high system resource usage. How to design a non-fixed column record data table structure , is a difficult problem in analyzing records at present. If the intermediate table is designed according to the largest column, the structure of the intermediate table will be particularly bloated, which will inevitably affect the operation speed; if each field in the record is separated by a delimiter. Strings are placed in a field, and the strings are split when used, so the process of assembling and splitting strings will...
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 IPC IPC(8): G06F17/30
Inventor 苏艳辉李绍辉尹孟磊
Owner SHANDONG WELL DATA CO LTD