Storage and query method for large data volume table of database

A large data volume, database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as lack of automatic maintenance

Inactive Publication Date: 2009-04-08
INSPUR SOFTWARE CO LTD
View PDF0 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Most of the above methods do not have the characteristics of automatic maintenance, and are carried out under the condition of manual operation by maintenance personnel.

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
  • Storage and query method for large data volume table of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The method of the present invention solves the problem of large data scales through reasonable partition rules; it does not require maintenance personnel to do too much maintenance work, and does not need to perform regular migration of historical data.

[0020] The daily checkout table in the enterprise is generally based on a specific algorithm to record the sales, inventory and other financial report data of the day; the purpose of the summary is that on the one hand, the enterprise needs to know the cost and profit obtained in the sales process of the day, and on the other hand On the one hand, some specific personnel, such as account managers, need to keep abreast of each customer's order status on the day; this daily checkout form can not only provide report query data for a certain day or a certain period of time, but also serve as a monthly settlement form. Raw data, then looking at the daily checkout table in this way, what is really meaningful to the system is ...

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 provides a method for storing and inquiring mass data tables in a database. The method realizes storage 'partition' of the mass data tables by physical design and logical design of the database instead of depending on whether the database has a partition technology. In the method, reasonable rules are designed according to a plurality of special characteristics of daily reckoning tables, then a table definition is subject to 'partition' design by the rules, which causes the record to be automatically 'distributed' to different storage 'partitions' in the course of inserting into the database; the 'partitioned' daily reckoning table creates a combined view by the rules, and provides an inquiry function by the combined view, thus the achieved daily reckoning table has obvious advantages in terms of data enquiry; and as to the database with limitation on the table space, the data inquiry can be solved even if the mass data of the daily reckoning tables causes the database to reach the upper limit.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a method for realizing the storage and query of a large data volume table in a database. Background technique [0002] In the business systems of many enterprises, there is a function of "daily settlement" or "daily settlement", which will facilitate the enterprise to check the inventory and sales of goods on the day or the whole month; in this process, generally A large number of data records will be generated to be stored in the corresponding daily checkout table of the database. With the accumulation of time, such a table will become larger and larger, and in some relatively centralized enterprise databases, the order of magnitude will reach more than 100 million. [0003] If there are tables with hundreds of millions of records in the database, it will bring a lot of trouble to the data query. In addition to querying the response time of SQL itself, the response...

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/30G06Q10/00
Inventor 宋智强
Owner INSPUR 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