Profiling and inquiring method for massive database records

A query method and database technology, which is applied in the field of archiving and querying massive database records, can solve problems such as difficulty in mastering by users, low performance, limited archive records, etc., and achieve the effect of easy backup and recovery

Inactive Publication Date: 2010-03-24
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF0 Cites 51 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] The technical problem to be solved by the present invention is to provide a method for archiving massive database records, which can efficiently archive and query massive database records, overcome the shortcomings of limited archive records, complex query, low performance, and difficulty for users to grasp

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
  • Profiling and inquiring method for massive database records
  • Profiling and inquiring method for massive database records

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The archiving method of massive database records of the present invention, such as figure 1 As shown, different processing methods are implemented according to different requirements. The basic steps are as follows:

[0029] 1. Obtain the records in a table that needs to be archived in the database, and group the records in the table. The grouping can be grouping the massive database records according to the fixed number of records in each group, for example figure 1 Shown are M records grouped together. In actual operation, the optimal value of M can be determined through experiments under the condition of satisfying the archiving performance. If the size of each archived record is relatively average, a fixed value M can be used to group massive database records. If the size difference of the records is relatively large , it is also possible to group massive database records according to the fixed value of each group of data.

[0030] 2. Create an index file for each...

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 profiling and inquiring methods for massive database records. The record profiling process includes grouping the records of the massive database, establishing an index file bya reserve index technique, partitioning the word segment which needs to be fuzzy inquired; compressing records in groups by a compression algorithm and writing to a data file; storing the index file and the data file to the file system. The record inquiring process includes processing the inquiry conditions, partitioning words, finding the file pointer information of the matched record in the datafile among the index according to the inquiry condition; decoding the corresponding record and returning the detailed information of the record to the user or other systems. The method is capable ofhighly efficiently profiling and inquiring massive records of the database, overcoming defects of limited arching records, low complexity and performance of the inquiry, difficulty for user to understand; independent from the database system, without any effect to the original system; while capable of great integration and concordance with a first party system.

Description

technical field [0001] The invention relates to a method for filing and querying database records, in particular to a method for filing and querying massive database records. Background technique [0002] In the database system, for the database table whose data volume will continue to grow, when the data volume accumulates to a certain scale, the performance of the system will often decline very obviously. Whether it is querying, adding, modifying or deleting, after the data volume increases, The daily maintenance of the database system, such as backup, will cause a lot of trouble. For such a table whose data will continue to grow, such as operation logs, the chances of the records in it will be modified after a certain period of time will be very small, forming historical records. A better way to process these records is to perform archiving. Although there are many ways to deal with the archiving of a large number of historical records, none of them is very ideal; either...

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 SHANGHAI BAOSIGHT SOFTWARE CO LTD
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