Data model generation method and device, data warehouse generation method and device and electronic equipment

A data warehouse and data model technology, applied in the computer field, can solve the problems of high skill requirements and difficulties in data development, difficulty in obtaining by mass users and enterprises, etc., and achieve the effect of reasonable and effective construction process and results, and improved efficiency

Active Publication Date: 2020-04-14
ALIBABA GRP HLDG LTD
View PDF7 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The above methods have the following defects: firstly, the conventional modeling method has high requirements for data development skills and requires professionals with strong industry background and development experience, which is difficult for mass users and enterprises to obtain; secondly, manual methods System business data, and a comprehensive understanding of these business data, it is difficult to build a data warehouse; thirdly, based on the model to determine the logic in the table items, and then develop the physical table, the logic understanding and implementation process is relatively long

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 model generation method and device, data warehouse generation method and device and electronic equipment
  • Data model generation method and device, data warehouse generation method and device and electronic equipment
  • Data model generation method and device, data warehouse generation method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0076] Based on the idea of ​​the above data warehouse generation scheme, such as image 3 As shown, it is the flow of the data warehouse generation method shown in the embodiment of the present invention Figure 1 , the execution body of this method can be figure 2 The data warehouse generation device 230 shown in . Such as image 3 As shown, the data warehouse generation method includes the following steps:

[0077] S310. Acquire raw data corresponding to the database.

[0078] Wherein, the original data may be field data of each data table in the database. By scanning all table item data in the database, the original data of the database can be obtained.

[0079] While acquiring the above original data, metadata corresponding to the database may also be acquired. Metadata mentioned in this scheme includes all data used to describe the original data in the database. For example, the metadata may include, but not limited to, execution logs generated after business ope...

Embodiment 2

[0116] On the basis of the previous embodiment, this embodiment adds the following extended content.

[0117] First, if Figure 6 As shown, it is the data warehouse generation method flow of the embodiment of the present invention Figure three . On the basis of the method shown in the previous embodiment, a post-processing process for the formed data warehouse is added. Such as Figure 6 As shown, after step S340, the following steps can also be performed:

[0118] S610. Add and / or delete some data tables, add and / or delete data table fields in the data tables, and adjust associations between data tables in the formed data warehouse according to the construction requirements of the preset data warehouse. At least one update operation in .

[0119] Usually, due to the limited sample data for training the data warehouse template, the data warehouse built based on the data warehouse template cannot meet all the content requirements of the data warehouse that the user wants ...

Embodiment 3

[0141] Such as Figure 9 As shown, it is the structure of the data warehouse generating device of the embodiment of the present invention Figure 1 , the data warehouse generating device can be set in figure 2 In the data warehouse generation system shown, it is used to execute such as image 3 Shown method step, it comprises:

[0142] A data acquisition module 910, configured to acquire raw data corresponding to the database;

[0143] A business meaning identification module 920, configured to identify the original data to obtain the business meaning of the business pointed to by the original data;

[0144] The template matching module 930 is used to select a data warehouse template that matches the identified business meaning from the data warehouse template library; the data warehouse template includes a predefined process method used to construct the data warehouse of the business meaning;

[0145] The data warehouse construction module 940 is configured to process th...

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

Embodiments of the invention provide a data model generation method and device, a data warehouse generation method and device and electronic equipment. The data warehouse generation method comprises the steps of obtaining original data corresponding to a database; identifying the original data to obtain the business meaning of the business pointed by the original data; determining a data warehousetemplate matched with the identified business meaning, wherein the data warehouse template comprises a process method used for predefined construction of a data warehouse, and each data warehouse template uniquely belongs to one business meaning; and performing process processing on the original data based on the selected data warehouse template to form a data warehouse corresponding to the database. According to the scheme of the embodiment of the invention, the data warehouse meeting user management requirements can be quickly generated.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a data model generation method and a data warehouse generation method, device and electronic equipment. Background technique [0002] When users are continuously collecting and storing business data, they don't know how to standardize and manage the raw data accumulated continuously from the business system, and build a data model that conforms to the business system to facilitate the understanding and use of data. Faced with this problem, a common industry solution is to invite industry experts to rebuild the data model (also called "data warehouse") for convenient data management, and then transform the data collection and storage process to meet the new data model architecture system; [0003] The above methods have the following defects: firstly, the conventional modeling method has high requirements for data development skills and requires professionals with stro...

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/28
Inventor 张谦
Owner ALIBABA GRP HLDG 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