Metadata processing method and device

A technology of processing equipment and processing methods, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of inability to accurately know the relationship of data flow direction, incapable of reliable and effective management of data warehouse, and avoid data islands Effect

Active Publication Date: 2011-12-14
MINSHENG BANKING CORP
View PDF6 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At this time, if the data management is still based on the preset metadata, the flow relationship between the data cannot be accurately known, so that the data warehouse cannot be managed reliably and effectively

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
  • Metadata processing method and device
  • Metadata processing method and device
  • Metadata processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0020] figure 1 It is a schematic flowchart of the metadata processing method of the present invention. like figure 1 As shown, the metadata processing method includes:

[0021] Step S101, the metadata processing device obtains the ETL execution log, and obtains a first database definition language (Data Definition Language, DDL) command from the data warehouse, wherein the first DDL command is used for the data objects included in the ETL execution log Mak...

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 equipment for processing metadata. The method comprises the following steps that: the equipment for processing the metadata acquires an extraction-transformation-loading (ETL) execution log and acquires a first data definition language (DDL) command, wherein the first DDL command is used for performing node definition on a data object included by the ETL execution log; the equipment for processing the metadata analyzes the acquired ETL execution log to acquire a second DDL command and a data manipulation language (DML) command, wherein the second DDL command is used for performing node definition on a temporary object included by the ETL execution log, and the DML command is used for recording the conversion operation of the data object and / or the temporary object in an ETL execution process; and the equipment for processing the metadata acquires the metadata which is used for representing the data flow direction of the data object and / or the temporary object by analyzing the first DDL command, the second DDL command and the DML command. By the method and the equipment for processing the metadata, the metadata which reflects the real data flow direction can be acquired.

Description

technical field [0001] The invention relates to metadata processing technology, in particular to a metadata processing method and equipment. Background technique [0002] With the rapid development of office automation, information has become an important resource of modern enterprises, and it is the basis for enterprises to use scientific management and decision analysis. Data warehouses for independent data management have also been widely used. [0003] Data extraction, transformation and loading (Extraction-Transformation-Loading, ETL) is an important part of building a data warehouse, which is responsible for extracting data from distributed and heterogeneous data sources, such as relational data and flat data files, to temporary intermediate After cleaning, transforming and loading, and integrating into the data warehouse, it becomes the basis of online analytical processing and data mining. The ETL process is centrally managed using a metadata approach. Among them, ...

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 MINSHENG BANKING CORP
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