Method and device for creating data warehouse table blood relationship graph

A data warehouse and blood relationship technology, applied in the computer field, can solve problems such as error-prone, large amount of business data, and heavy workload of data warehouse managers, and achieve the effect of reducing manual workload, improving speed and accuracy

Active Publication Date: 2014-07-02
珠海多玩信息技术有限公司
View PDF5 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the data warehouse managers construct the blood relationship diagram of the data warehouse table, it is easy to make mistakes; moreover, the amount of business data in the data warehouse is large, resulting in a heavy workload for the data warehouse managers.

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 creating data warehouse table blood relationship graph
  • Method and device for creating data warehouse table blood relationship graph
  • Method and device for creating data warehouse table blood relationship graph

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0058] An embodiment of the present invention provides a method for constructing a blood relation diagram of a data warehouse table. see figure 1 , where the method includes:

[0059]Step 101: Analyze each data warehouse operation statement for accessing the data warehouse, and obtain the table name of the data warehouse destination table accessed by each data warehouse operation statement;

[0060] Step 102: storing the corresponding relationship between the statement identifier of each data warehouse operation statement and the table name of the accessed data warehouse destination table in the corresponding relationship table;

[0061] Step 103: Obtain the table name of the data warehouse source table corresponding to each data warehouse destination table in the corresponding relationship table according to the corresponding relationship table;

[0062] Step 104: According to the table name of each data warehouse destination table and the table name of the data warehouse s...

Embodiment 2

[0065] An embodiment of the present invention provides a method for constructing a blood relation diagram of a data warehouse table. see figure 2 Among them, the method includes:

[0066] Step 201: the server obtains the data warehouse operation statement for accessing the data warehouse of each business point from the data warehouse;

[0067] Specifically, according to the business type, the server obtains from the data warehouse the data warehouse operation statements for each business point belonging to the same business type to access the data warehouse, and assigns a statement identifier to each data warehouse operation statement.

[0068] Wherein, the corresponding relationship between the business type and the data warehouse operation statement for accessing the data warehouse is stored in the server, and each corresponding to the business type can be obtained from the corresponding relationship between the business type and the data warehouse operation statement for ...

Embodiment 3

[0139] An embodiment of the present invention provides a device for constructing a blood relationship diagram of a data warehouse table. see image 3 , where the device includes:

[0140] The analysis module 301 is used to analyze each data warehouse operation statement for accessing the data warehouse, and obtain the table name of the data warehouse destination table accessed by each data warehouse operation statement;

[0141] The first storage module 302 is used to store the corresponding relationship between the statement identifier of each data warehouse operation statement and the table name of the accessed data warehouse purpose table in the corresponding relationship table;

[0142] The first obtaining module 303 is used to obtain the table name of the data warehouse source table corresponding to each data warehouse destination table in the corresponding relationship table according to the corresponding relationship table;

[0143] The construction module 304 is conf...

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 device for creating a data warehouse table blood relationship graph and belongs to the field of computers. The method comprises the steps of analyzing each data warehouse operational statement which has access to a data warehouse to obtain the name of a data warehouse destination table to which each data warehouse operational statement has access, storing the corresponding relationship between the statement identification of each data warehouse operational statement and the name of the corresponding data warehouse destination table in a corresponding relationship table, obtaining the name of a data warehouse source table corresponding to each data warehouse destination table in the corresponding relationship table, and creating the data warehouse table blood relationship graph according to the name of each data warehouse destination table and the name of the data warehouse source table corresponding to each data warehouse destination table. The device comprises an analyzing module, a first storage module, a first obtaining module and a creating module. According to the method and device, a server can automatically create the data warehouse table blood relationship graph.

Description

technical field [0001] The invention relates to the computer field, in particular to a method and a device for constructing a data warehouse table blood relationship graph. Background technique [0002] Various business data are stored in the data warehouse, and different business data are stored in different business tables. Therefore, there are multiple business tables stored in the data warehouse, and how to construct the multiple business tables stored in the data warehouse into a data warehouse table kinship relationship graph is an urgent problem to be solved. [0003] At present, it is the data warehouse managers who analyze the data warehouse operation statements and construct the blood relationship diagram of the data warehouse tables. However, it is easy for data warehouse managers to make mistakes when constructing blood relationship diagrams of data warehouse tables; moreover, the amount of business data in the data warehouse is large, resulting in a heavy workl...

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/2282G06F16/283
Inventor 陈武刘超洪
Owner 珠海多玩信息技术有限公司
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