Method for fast searching database sheet table record

A data recording and database technology, which is applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as record search time, save hardware costs and improve search time.

Inactive Publication Date: 2012-08-29
JIANGSU UNIV OF SCI & TECH +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to solve the problem of searching time for records in data tables, the main purpose of the present invention is to provide a method for quickly searching records in a single table of a database, so that users can quickly find the required details from a data table with a relatively large amount of data. data to meet user needs

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 fast searching database sheet table record
  • Method for fast searching database sheet table record
  • Method for fast searching database sheet table record

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Below in conjunction with accompanying drawing, the implementation process of technical scheme is described in further detail basically according to the order of accompanying drawing:

[0033] exist figure 1 In the present invention, the flow chart of optimizing the query statement is described. The optimization steps include: identifying keyword information and optimizing rules. The descriptions of each part are as follows:

[0034] Step 11, identify keyword information, including: HAVING, >, DELETE, IN, NOT IN, EXISTS, DISTINCT, UNION and other information.

[0035] Step 12, the optimization rule, is to optimize the query statement according to the following optimization principles, including: replace the HAVING clause with the WHERE clause; use the DECODE function; use >= instead of >; use table aliases; use TRUNCATE instead of DELETE; use ROWID Table access; replace IN with EXISTS; replace NOT IN with NOT EXISTS; replace EXISTS with table connection; replace DISTI...

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 for fast searching a database sheet table record, which is used for a table record querying module in a computer database. The method comprises the following steps of: optimizing a query statement, regenerating a new query statement, and applying for a special data area in a computer memory at the same time for storing the result data of the last query; extractingdatabase sheet table names according to a new query statement, reading the data in the extracted database sheet table according to certain rules, and storing the read data into a data exchange area for exchanging the data in the whole query process; dynamically updating the data in the data exchange area; and modifying query objects of the new query statement into the data in the data area, linking the query result to the data area which is applied for, and adding one to the value of query frequency fields in the record containing the query result in the database sheet table at the same time.The method can obviously improve search time for querying the data, does not have additional hardware and hard disk storage spaces and saves hardware cost.

Description

technical field [0001] The invention relates to the technical field of single-table record data access in a database, and more precisely relates to a method for quickly searching a single-table record in a database. Background technique [0002] With the rapid development of science and technology, databases have been widely used in various fields, and databases are the core of major information websites, and the requirements for data acquisition time of tables in databases are getting higher and higher. [0003] Due to the current data-centric websites such as social networks and forums, thousands or more pieces of data need to be stored in the information database every day, such as posting content and reply content of forums, social network Data such as user basic information, user shared information, and messages are currently stored by category, that is, each category of data is stored in a table, so the amount of data in the data table is relatively large in this case ...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 刘镇孙敏张笑非钱萍
Owner JIANGSU UNIV OF SCI & TECH
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