Method and device for processing dimension in data warehouse

A technology of data warehouse and processing method, applied in the dimension processing field of data warehouse, can solve the problem of slow update speed of snapshot dimension table, and achieve the effect of improving update speed

Active Publication Date: 2014-12-24
BEIJING GRIDSUM TECH CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a dimension processing method and device in a data warehouse to solve the problem of slow update speed of the snapshot dimension table in the case of updating the historical dimension table

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 and device for processing dimension in data warehouse
  • Method and device for processing dimension in data warehouse
  • Method and device for processing dimension in data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0026] In order for those skilled in the art to better understand the solution of the present invention, the technical solution in the embodiment of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the present invention. Obviously, the described embodiment is only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall belong to the protection scope of the present invention.

[0027]It should be noted that the terms "first" and "seco...

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 device for processing the dimension in a data warehouse. A first dimension table and a second dimension table which are created in advance are stored in the data warehouse, wherein the first dimension table is used for storing all historical data in the data warehouse; the second dimension table is used for updating according to the first dimension table for storing data of one lately dimension processing time period in the first dimension table. The method comprises the following steps of acquiring data to be updated in the data warehouse; adding the data to be updated in the second dimension table for updating the second dimension table, and updating the first dimension table based on the data to be updated. According to the method and the device, the problem that the update speed of a snapshot dimension table is low when a historical dimension table is updated is solved, and the effect of increasing the update speed of the snapshot dimension table is realized.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a dimension processing method and device in a data warehouse. Background technique [0002] A data warehouse is a unit or a general data processing system in an application field, which stores a collection of related data belonging to enterprises and business departments, groups and individuals. The data in the data warehouse is established for many users to share their information, and has got rid of the restrictions and restrictions of specific programs. Different users can use the data in the data warehouse according to their own usage, and multiple users can share the data resources in the data warehouse at the same time, that is, different users can access the same data in the data warehouse at the same time. Data sharing not only meets the requirements of each user for information content, but also meets the requirements of information communication between users. ...

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/2264G06F16/2282G06F16/23G06F16/283
Inventor 洪超
Owner BEIJING GRIDSUM 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