Method and system for managing data, and data analyzing device

A data management and data analysis technology, applied in the field of data management, can solve the problems of occupying online high-end storage resources, long response time, slow data speed, etc., to improve the corresponding speed, reduce management costs, and reduce response time.

A data management and data analysis technology, applied in the field of data management, can solve the problems of occupying online high-end storage resources, long response time, slow data speed, etc., to improve the corresponding speed, reduce management costs, and reduce response time.

CN103092867AActive Publication Date: 2013-05-08中国移动通信集团甘肃有限公司
3 Cites 23 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for managing data, and data analyzing device
  • Method and system for managing data, and data analyzing device
  • Method and system for managing data, and data analyzing device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Hot data is data that is frequently used. Data can only reflect its value when it is used. The number of times the data is used within a certain period of time can directly reflect the "cold" or "hot" degree of the data. The hot data in a certain time range is the most valuable data in the system, and the most vital data in the system.

[0035] At the storage hardware device level, there are mature hot data discovery technologies, but this technology is based on the disk level of the storage device and cannot reflect the degree of "hot and cold" of objects at the logical level (such as tables, indexes, etc.). Certain limitations.

[0036] The data is ultimately used by the application. The application uses the SQL language to access the data. For this reason, you can indirectly find the hot objects in the database by recording and analyzing the data objects accessed in the application SQL executed by the database layer within a certain period of time .

[0037] The present...

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 and a system for managing data, and a data analyzing device. The method includes: collecting structured query language (SQL) statements executed by an application program, and performing persistent storage; decomposing the SQL statements to obtain access objects of the SQL statements; recording accessed times of each access object in preset time; and extracting corresponding access objects as hot point data according to threshold value of the accessed times. According to the method and the system for managing the data, and the data analyzing device, the accessed times of the access objects of the SQL statements are obtained by analyzing the SQL statements executed by the application program, and accordingly the hot point data is obtained. Use status of logic layer objects (such as a chart and an index) is accurately reflected by finding the hot point data on a data application layer, and furthermore the hot point data can be accurately managed, system processing response time is decreased, system processing corresponding speed is improved, demand for high-end storage devices is reduced, and mass data management cost is reduced.

Description

Technical field [0001] The invention relates to a data management technology, in particular to a data management method and system, and a data analysis device. Background technique [0002] With the rapid development of my country's telecommunications industry, especially the continuous growth of mobile communication users and broadband users, various telecommunications operators store and manage all kinds of massive data. Data life cycle management is an effective way to solve massive data management. [0003] Since traditional data lifecycle management only bases on the time dimension when defining the life of data, specifically, the lifecycle management of data is simply carried out in chronological order, such as bills, detailed statements, transaction records and other time-tagged objects. Carry out specific operations such as backup, archive, and historical data migration according to time. [0004] The existing methods for implementing data lifecycle management according to ...

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
08 May 2013
Publication
CN103092867A
IPC
G06F17/30
Inventors
李吉元