Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and device for automatically constructing a data vault model data warehouse

A technology for automatic construction and model data, applied in multi-dimensional databases, database models, electrical digital data processing, etc., can solve the problems of inability to build enterprise data warehouses in batches, time-consuming and labor-intensive, and save time for logical analysis.

Active Publication Date: 2018-03-02
GUANGDONG KINGPOINT DATA SCI & TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It is impossible to build enterprise data warehouses in batches, which is time-consuming and labor-intensive

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
  • A method and device for automatically constructing a data vault model data warehouse
  • A method and device for automatically constructing a data vault model data warehouse
  • A method and device for automatically constructing a data vault model data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] Such as figure 1 As shown, it is a structural block diagram of a device for automatically building a Data Vault model data warehouse according to the present invention, and the device includes: a table query device 10 and a table building device 20 . The table query device 10 is used to receive the center field group input by the user, the center field group includes a plurality of center fields, and after processing the center field group, output the overall information table and the center field association information table; The overall information table records each central field in the central field group and the table number information of the main table and the supplementary table of the central field in the source database table, and the central field association information table records the central field group The logical relationship between all the central fields in . The business entity is the business entity that the user wants to use to create the centra...

Embodiment 2

[0057] Such as figure 2 Shown is a flow chart of a method for automatically building a Data Vault model data warehouse of the present invention, the method comprising:

[0058] Table query step S10: a table query device receives the central field group input by the user, and after processing the central field group, outputs the overall information table and the central field related information table.

[0059] Wherein, the overall information table records the table number information of each central field in the central field group and the main table and supplementary table of the central field in the source database table, and the central field association information table records the The logical relationship between all central fields in the central field group;

[0060] Table building step S20: a table building device receives the overall information table and the center field association information table, obtains an intermediate table by analyzing and processing the c...

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 present invention provides a method and apparatus for automatically constructing a Data Vault-modeled data warehouse. The apparatus comprises a table query apparatus and a table creation apparatus. The table query apparatus comprises a first initialization unit, a search unit, a judgment unit, a writing unit, a matching unit, and a recording unit. The table creation apparatus comprises a first processing unit, a second initialization unit, a second processing unit, and a table creation unit. The method comprises a table query step and a table creation step. According to the method and apparatus for automatically constructing a Data Vault-modeled data warehouse, a relation between desired central tables can be explored by using field names and an association relation between tables; a logical relation between the central table, the link table and the accessory table can be established; tables can be extracted from a database table and an enterprise data warehouse can be constructed. In this way, the time used for logical analysis by the enterprise-level data warehouse construction personnel in constructing the enterprise data warehouse is saved.

Description

technical field [0001] The invention relates to the construction field of a data warehouse, in particular to a method and device for automatically constructing a Data Vault model data warehouse. Background technique [0002] Data Vault is a modeling method for building a data warehouse. Regardless of whether the data is right or wrong at the business level at that time, this modeling method retains all historical data. The data warehouse built with this modeling method is called an enterprise-level data warehouse. It includes all the historical data integrated from various databases of the enterprise. It is located between the business system and the data mart, and is the only data mart. Data Sources. Data Vault is detail-oriented and history-trackable. It is a collection of standardized tables with connection relationships, and these tables can support one or more business functions. Data Vault only saves data as it is, without any interpretation, filtering, cleaning, or ...

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/283
Inventor 简宋全李青海侯大勇邹立斌许飞月
Owner GUANGDONG KINGPOINT DATA SCI & TECH CO LTD