Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Method for economized storage, construction í‹greeníŒ database

A data warehouse and green technology, applied in the direction of data exchange network, digital transmission system, electrical components, etc., can solve the problems of waste data warehouse, pollution, etc., and achieve the effect of saving storage

Inactive Publication Date: 2008-05-21
CHINA MOBILE QUANTONG SYST INTEGRATION CO LTD
View PDF0 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The waste of these "garbage" data and storage will pollute the data warehouse, which is equivalent to the pollution of the natural environment by harmful gas emissions.

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 economized storage, construction í‹greeníŒ database
  • Method for economized storage, construction í‹greeníŒ database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0039] The user's call record in the data warehouse of the telecom industry is one of the main data, which has a large amount of data and has great business significance. This embodiment takes the call record as an example to illustrate the specific implementation method of the present invention:

[0040] 1. Basic layer:

[0041] Call records are generally kept for about half a year. Through analysis, the fields in it, such as: calling and called, long-distance roaming, own party's attribution, counterparty's attribution, settlement party and other fields are all enumerated fields. Using the data compression technology of the data warehouse can greatly save data storage. Specific steps are as follows:

[0042] 1) Compression value selection:

[0043] When the field type is CHAR, the average length of bytes occupied by the field value is relatively uniform, and the value range does not exceed 255, you can compress all the value ranges as compressed values ​​to achieve an ef...

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 relates to a method of saving memory and constructing a green data warehouse, comprising procedures as follows: (1) Saving memory of a base layer using method of data compression; (2) Saving memory of a collection layer using method of granularity memory such as user class-fine-grained class-coarse-grained class; establishing automatic, configurable and regular data cleaning mechanism for business data which exceeds memory cycle; (3) Adjusting memory cycle according to life cycle of application analysis for application layer; establishing automatic, configurable and regular data cleaning mechanism for business data which exceeds memory cycle. The invention has the advantage of effectively saving memory, automatically cleaning data garbage in time, and enabling clean and neat green data warehouse.

Description

technical field [0001] The invention relates to a method for saving storage and building a "green" data warehouse, which is suitable for the telecommunications industry. Background technique [0002] A data warehouse is a subject-oriented, integrated, time-varying, non-volatile collection of data that supports management decision making. The data warehouse built by telecom operators generally includes data in multiple subject areas such as customers, accounts, bills, customer service, and network management. Through the ETL process, the production data is extracted from BOSS, CALLCENTER and network management system to the data warehouse system, and then loaded into the data warehouse after conversion. Then, through the automatic scheduling mechanism, the data is layered, divided into granularities, and summarized, and the data is formed into a data mart or an application summary layer, and then according to different applications, the application layer data of each star st...

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): H04L12/24H04M3/24
Inventor 贾殿承张树文乔辉武海斌卢建辉庞咏李祎易剑光
Owner CHINA MOBILE QUANTONG SYST INTEGRATION 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
Eureka Blog
Learn More
PatSnap group products