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

Data warehouse construction method and device

A data warehouse and logic model technology, applied in the database field, can solve problems such as poor maintainability and low efficiency, and achieve the effects of improving efficiency, maintaining good maintainability, and saving the ETL development process

Active Publication Date: 2019-07-16
YOUMENG TONGXIN BEIJING TECH CO LTD
View PDF7 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of the above problems, the embodiment of the present application provides a data warehouse construction method, which includes basic information including one less logical table, attributes for the logical table, execution logic for the attributes, and associated dimensions for the attributes Logical model, building a data warehouse, and solving the problems of low efficiency, reusability, and poor maintainability in prior technologies

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 construction method and device
  • Data warehouse construction method and device
  • Data warehouse construction method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0025] In the embodiment of this application, an innovative logic model is provided. When defining the logic model, the attributes and the corresponding execution logic are defined together. The definition process is as follows:

[0026] 1) Define the basic information of the logical model

[0027] When defining the basic information, you can define the basic information of the logical table, such as the name of the table, the primary key and other information.

[0028] In practical applications, the logical model may include one or more of the two types of dimension logical tables and detail logical tables. There can also be multiple logical tables of each type, and each table is constructed for a cert...

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 data warehouse construction method and device, and relates to the technical field of databases. The method comprises the following steps: providing a logic model, wherein thelogic model comprises basic information of at least one logic table, attributes aiming at the logic table, execution logic aiming at the attributes and association dimensions aiming at the attributes,the execution logic is used for obtaining data required by the attributes from a target table when the table is constructed based on the attributes; and constructing a data warehouse according to thelogic model. According to the method and the device, a logic model definition mode combining dimension and execution logic is realized, how to generate the physical table and how to generate the execution logic codes are not concerned in an ETL development process, and a data warehouse can be constructed only by utilizing the logic model, so that the ETL development process can be saved, the efficiency is improved, and the maintainability is good.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data warehouse construction method and device. Background technique [0002] Data warehouse, the English name is Data Warehouse, which is a strategic collection that provides all types of data support for the decision-making process at all levels of the enterprise. It can be created for analytical reporting and decision support purposes, providing guidance for business process improvement, monitoring time, cost, quality and control, etc. for businesses that require data analysis. [0003] In the prior art, there are two types of ways to build a data warehouse: first, define a logical model first, and then generate physical tables based on the logical model and store them in the data warehouse. The second category uses free mode to directly generate physical tables and store them in the data warehouse. For the first category, its logical model can adopt 3NF (the th...

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/28G06F16/22
CPCG06F16/2282G06F16/283
Inventor 王永伟王赛江岚谢锋张谦邓中华董芳英
Owner YOUMENG TONGXIN BEIJING TECH CO LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com