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

Data warehouse data table monitoring method, device and system

A technology of data warehouse and data table, applied in the field of data warehouse, can solve problems such as labor-intensive, large amount of program calculation, inconsistency of lower-level data, etc., to achieve the effect of ensuring consistency, improving processing efficiency, and avoiding data errors

Active Publication Date: 2022-04-12
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, no matter whether the program is run based on the configuration file through the scheduling platform, or the program is directly invoked and run through the SecureCRT tool, there is a problem that the upper-level data is recalculated and inconsistent with the lower-level data, resulting in errors in the running results of the lower-level program.
In addition, in a large data warehouse, the calculation volume of the program is very large every day. Once a data error occurs, a large amount of labor is required, which seriously affects the data processing efficiency of the data warehouse.

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 warehouse data table monitoring method, device and system
  • Data warehouse data table monitoring method, device and system
  • Data warehouse data table monitoring method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and fully convey the concept of example embodiments to those skilled in the art. The drawings are merely schematic illustrations of the invention and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted.

[0030] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the invention. However, those skilled in the art will appreciate...

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 application discloses a monitoring method, device and system for data tables of a data warehouse. The method includes: detecting whether there is a data table to be updated in the data warehouse; when detecting that there is a data table to be updated in the data warehouse, judging whether the data table to be monitored includes a data table to be updated; when the data to be monitored When the table includes a data table to be updated, record the current first information of the data table to be updated; judge whether the data table to be updated has been updated; when the data table to be updated has been updated, record the data table The updated second information; judging whether the first information is the same as the second information; and sending an update notification of the data table when the first information is different from the second information. The method can timely notify other users of the updated data table, ensure data consistency in the data warehouse data table, and avoid data errors.

Description

technical field [0001] The invention relates to the technical field of data warehouses, in particular to a method, device and system for monitoring data tables in a data warehouse. Background technique [0002] A data warehouse is a large factory for collecting, storing and processing data. In order to make the data easier to manage and improve efficiency in the subsequent data cleaning and data application, the data warehouse will be layered. It is usually divided into four layers: buffer data layer, basic data layer, general data layer and aggregation application layer. These four layers all involve data tables with different characteristics, which are used to store data with different purposes and different granularities. There are sufficient and necessary conditions between data tables and data tables. The data table is processed by different programs, which makes various sufficient and necessary conditions be satisfied between programs. In practical applications, th...

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): G06F16/23G06F16/28G06F11/30
CPCG06F11/3034G06F16/2358G06F16/2365G06F16/283
Inventor 何林艳
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD