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

Method and device for building ODS layer of data warehouse

A technology of data warehouse and establishment method, which is applied in the field of establishment of data warehouse ODS layer, which can solve the problems of insufficient intelligence, error-prone, high labor cost, etc., and achieve the effect of reducing labor cost, ensuring stability and quality, and improving R&D efficiency

Inactive Publication Date: 2016-06-29
ALIBABA GRP HLDG LTD
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, a large number of manual operations require high labor costs, are not intelligent enough, and are prone to errors

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 building ODS layer of data warehouse
  • Method and device for building ODS layer of data warehouse
  • Method and device for building ODS layer of data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0046] The terminology used in this application is for the purpose of describing particular embodiments only, and is not intended to limit the application. As used in this application and the appended claims, the singular forms "a", "the", and "the" are intended to include the plural forms as well, unless the context clearly dictates otherwise. It should also be understood that the term...

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 method and a device for building an ODS layer of a data warehouse. The method comprises the following steps: obtaining metadata of a source system data table according to a source system data table name set by a user; creating an ODS data table corresponding to the source system data table according to the metadata; and synchronizing data in the source system data table into the ODS data table. Through the method and the device, the target that a script does not need to be manually written in the process of building the ODS layer can be achieved, so that the human cost is reduced; the research and development efficiency is improved; and the stability and the quality of the data warehouse are ensured.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a method and device for establishing an ODS layer of a data warehouse. Background technique [0002] The ODS (Operational Data Store, operational data storage) layer is an optional part of the data warehouse architecture. The ODS layer is a source-based data layer built with data extracted from the source system. It is a "subject-oriented, integrated current or near-current, ever-changing" collection of data. [0003] The establishment of the ODS layer involves processes such as table creation, data synchronization, data cleaning, life cycle management, and limit storage. At present, when establishing the ODS layer, the above-mentioned processes such as table creation, data synchronization, data cleaning, life cycle management, and limit storage are all completed through manual configuration, such as: manually writing table creation statements, manually configu...

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
Inventor 吴勇军
Owner ALIBABA GRP HLDG LTD