Data warehouse modeling method and modeling device based on business change frequency

A data warehouse and modeling method technology, applied in the computer field, can solve problems such as poor performance, troublesome, non-universal, etc., to achieve the effect of improving data extraction performance, ensuring stability, and shielding influence

Active Publication Date: 2017-11-07
YONYOU NETWORK TECH CO LTD
View PDF4 Cites 0 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
  • Data warehouse modeling method and modeling device based on business change frequency
  • Data warehouse modeling method and modeling device based on business change frequency
  • Data warehouse modeling method and modeling device based on business change frequency

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] Such as 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 mo...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/174G06F16/212
Inventor 靳海彬胡沛兰
Owner YONYOU NETWORK TECH 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
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