Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Service change frequency based data warehouse modeling method and device

A data warehouse and modeling method technology, applied in the computer field, can solve problems such as incompatibility, trouble, and poor performance, and achieve the effects of ensuring stability, reducing data redundancy, and improving data extraction performance

Active Publication Date: 2015-03-25
YONYOU
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when judging whether a record is updated, a full-field comparison must be done. SQL (Structured Query Language, Structured Query Language) is cumbersome to write, has poor performance, and is not universal

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
  • Service change frequency based data warehouse modeling method and device
  • Service change frequency based data warehouse modeling method and device
  • Service change frequency based data warehouse modeling method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0036] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the present invention is not limited to the specific embodiments disclosed below limit.

[0037] figure 1 A schematic flowchart of a data warehouse modeling method based on service change frequency according to an embodiment of the present invention is shown.

[0038] like figure 1 As shown, according to a data warehouse modeling method based on business change frequency according to an embodiment of the present invention, a computer system is used to realize the database warehouse model...

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 service change frequency based data warehouse modeling method and device. The method includes the steps: 102, setting service change frequency ranges; 104, analyzing service change frequency of each attribute of a service database source data table according to the service change frequency ranges; 106, setting the number of database tables according to the number of the service change frequency ranges of the service change frequency; 108, adding Hash fields to each database table so as to judge whether the database table is changed or not; S110, establishing corresponding data warehouse models according to all the database tables. Through the method and device, data history integrity is guaranteed, data redundancy or change frequency can be reduced effectively, influence on a whole data warehouse due to changes of the service data can be shielded effectively, data extraction performance is improved, and further stability of the data warehouse is guaranteed.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data warehouse modeling method based on service change frequency and a data warehouse modeling device based on service change frequency. Background technique [0002] A very important feature of the data warehouse is data stability, because the data in the data warehouse changes, and the superstructure that relies on the data warehouse must change to maintain data consistency. [0003] When encountering a very long business database table and the field changes of the business database table are very inconsistent, if the simple modeling method is used without any processing, it will lead to frequent changes in the data warehouse table (or frequent zippers), and the Disastrous for both storage space and superstructure. [0004] For business documents that need to be zipped, the current processing method is: [0005] (1) Directly add the start time and end time as a zipper ...

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/30
CPCG06F16/174G06F16/212
Inventor 靳海彬胡沛兰
Owner YONYOU
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products