Method for utilizing fixed length field for optimizing iteration inquiry

A fixed-length field and iterative technology, which is applied in the application field of database data management, can solve the problems of fast query speed, consume a large amount of memory, and cannot be obtained, and achieve the effect of fast query speed, fast positioning speed, and meeting query requirements

Inactive Publication Date: 2008-03-26
GLOBAL INNOVATION AGGREGATORS LLC
View PDF0 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0015] The technical problem solved by the present invention is to provide a method for optimizing iterative query using fixed-length fields to optimize the currently widely used iterative query method, and solve the problem that users cannot obtain faster query speed when querying large amounts of data, and will Problems such as consuming a lot of memory

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 for utilizing fixed length field for optimizing iteration inquiry
  • Method for utilizing fixed length field for optimizing iteration inquiry
  • Method for utilizing fixed length field for optimizing iteration inquiry

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] As shown in Figure 2, the operation steps of the iterative query method described in 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 pri...

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 鲁春怀
Owner GLOBAL INNOVATION AGGREGATORS LLC
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