Method for managing life cycle of extra-large table data based on Oracle database

A management method and life cycle technology, applied in the field of life cycle management of extra-large table data based on Oracle database, can solve problems such as system query, analysis speed slowdown, data backup and recovery difficulties, etc., to achieve query path improvement and data volume Stable, guaranteed stable effect

Pending Publication Date: 2022-04-26
GUANGXI POWER GRID CORP
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In Guangxi power grid metering automation master station system, with the passage of time, the number of records in the large tables in the system will increase geometrically. If these large tables are not effectively managed in the data life cycle, the query and analysis speed of the system will be reduced. Slower and more difficult to backup and restore data

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 managing life cycle of extra-large table data based on Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Embodiment of the present application provides a management method based on oracle database data life cycle of the extra-large table, by storing the data of the current extra-large table into the historical mega table through the partition exchange technology, so that the current data volume of the extra-large table is relatively stable, thereby ensuring the stability of the system, further compressing the historical extra-large table to improve the utilization rate of storage, and can quickly select the query path according to the periodic control table to improve the query efficiency.

[0021] See Figure 1 , an embodiment of the present application based on oracle database management method of the data life cycle of the extra large table comprises:

[0022] 101. Create the current mega table, the historical mega table and the period control table;

[0023] In this application, after the grid metering automation master station system is established, the current mega tabl...

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 an Oracle database-based extra-large table data life cycle management method. The method comprises the following steps of: creating a current extra-large table, a historical extra-large table and a cycle control table; obtaining a retention period according to the period control table; storing the data of the current extra-large table into the historical extra-large table in combination with the retention period and a partition exchange technology; and performing partition compression on the historical extra-large table to obtain compressed data. According to the method, the data of the current extra-large table is stored into the historical extra-large table through the partition exchange technology, so that the data size of the current extra-large table is relatively stable, the stability of the system is further ensured, the historical extra-large table is further compressed, the storage utilization rate is increased, and the storage efficiency is improved. And the query path can be quickly selected according to the period control table to improve the query efficiency.

Description

Technical field [0001] The present application relates to the field of power data management technology, in particular to a management method based on the Oracle database of the data life cycle of the very large table. Background [0002] The grid metering automation master station system is responsible for storing and managing remotely collected metering data, which can be analyzed and summarized according to the grid model. Electric energy metering requires accurate and timely reflection of the electrical energy activities of the upper and lower gateways in the power grid, providing data support for the power market, marketing management and other systems, and ensuring the development of settlement, assessment, line loss management, balance analysis, profit and loss analysis and other services. [0003] In the Guangxi power grid metering automation master station system, with the passage of time, the number of records of large tables in the system will increase geometrically, ...

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): G06F16/22G06F16/28
CPCG06F16/2282G06F16/2228G06F16/284
Inventor 唐利涛李刚何涌陈俊张智勇周政雷徐植
Owner GUANGXI POWER GRID CORP
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