Method for utilizing fixed length field for optimizing iteration inquiry
What is AI technical title?
AI technical title is built by PatSnap AI team. It summarizes the technical point description of the patent document.
A fixed-length field and iterative technology, applied in the application field of database data management, can solve the problems of unavailability, consuming a lot of memory, fast query speed, etc., and achieves the effect of fast query speed, fast positioning speed, and satisfying query requirements.
What is AI technical title?
AI technical title is built by PatSnap AI team. It summarizes the technical point description of the patent document.
A fixed-length field and iterative technology, applied in the application field of database data management, can solve the problems of unavailability, consuming a lot of memory, fast query speed, etc., and achieves the effect of fast query speed, fast positioning speed, and satisfying query requirements.
Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0043] The purpose of this invention is to introduce a method for optimizing iterative query using fixed-length fields, and optimize the widely used iterative query method at present, so that users can obtain faster query speed when querying large amounts of data without consuming a large amount of memory . Specific embodiments are described in detail below, but not as a limitation to the present invention.
[0044] like figure 2 As shown, the iterative query method operating steps of the present invention are as follows:
[0045] Step 201, adding a fixed-length primary key field to the table to uniquely identify a record;
[0046] Step 202, taking out the primary key field values of all records satisfying the conditions from the database and storing them in a disk file;
[0047] Step 203, setting an iterator, and using the iterator to query in batches;
[0048] Step 204, the iterative query is completed, and the iterator and the binary file storing the primary key valu...
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 using fixed-length fields to optimize iterative inquiry, including: set up a fixed-length major key field in database; choose the values of all the condition-matched recorded major key fields and save in a disk file according to specific requirements; set up iterative device and batch inquire the database through iterative device, construct the SQL sentence through read the values of major key fields in disk file during inquiry; after the completion of iterative inquiry, delete the iterative device and the value saved in disk file. The invention optimizes the present widely used iterative inquiry method, solve problems that when large amount of data inquiries can not obtain high inquiry speed and occupies large amounts of EMS memory problem and so on.
Description
technical field [0001] The invention relates to the application field of data management using a database (DBMS), especially large-scale relational database management systems, such as sybase, oracle, mssql and the like. Background technique [0002] Query is the most frequently used operation in the database, so for a database application system, users are most concerned about query efficiency. In the telecommunication network management system, in order to meet the large amount of data query requirements of users, an iterative query method is adopted. [0003] The basic idea of iterative query is to return a very large result set in batches to avoid memory processing difficulties or even system crashes caused by too much data acquired at one time. An iterator is a data structure used in the iterative query process, which stores the total number of records that meet the conditions, the number of records obtained each time, the number of times that have been queried, the ...
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