Method and system for data separation

A data separation and data technology, applied in the database field, to achieve the effect of rationalizing density distribution, increasing speed, and increasing timeliness
CN102708188AInactive Publication Date: 2012-10-03SUZHOU CODYY NETWORK SCI & TECH
0 Cites 10 Cited by

Patent Information

Authority / Receiving Office
CN ยท China
Current Assignee / Owner
SUZHOU CODYY NETWORK SCI & TECH
Publication Date
2012-10-03
Estimated Expiration
Not applicable ยท inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides a method and a system for data separation. The method comprises the steps of recording precise query times and fuzzy query times of each data item in a data table; according to the precise query times, fuzzy query times and preset weight of each data item, computing query coefficient of the data; according to the data item number in the data table and the query coefficient of the data, determining partition coefficient of the data table; creating a cold data table and a heat data table respectively; comparing the query coefficient of the data and the partition coefficient of the data table; and inserting the data in the data table to the cold data table or the heat data table according to the comparative result.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the technical field of databases, in particular to a data separation method and system. Background technique

[0002] With the increasing development of social informatization, databases have been widely used in enterprises, schools and libraries. In daily applications, database systems need to store a large amount of data, and with the continuous development of business, the amount of data continues to increase. The main operation type of the daily data table is query, and the query frequency of different data in the data table is not the same. If the data with low query frequency is always combined with the high-frequency query data and placed in the data table, the data that is rarely accessed Will reduce the average query speed of the overall database. In the prior art, the way of separating and storing the data tables is mainly to distinguish by data type, or to split the fields and store them. When faced with a large a...

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