Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data warehouse operation scheduling method and system based on ETL framework and computer readable medium

A data warehouse and operation scheduling technology, applied in the field of data processing, can solve the problem of low efficiency of full scheduling development and testing, and achieve the effect of flexible scheduling, improving efficiency and reducing costs

Pending Publication Date: 2022-04-05
浙江太美医疗科技股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is to provide a data warehouse operation scheduling method, system and computer-readable medium based on the ETL framework to solve the problem of low efficiency of full scheduling, development and testing

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 operation scheduling method and system based on ETL framework and computer readable medium
  • Data warehouse operation scheduling method and system based on ETL framework and computer readable medium
  • Data warehouse operation scheduling method and system based on ETL framework and computer readable medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In order to make the above objects, features and advantages of the present invention more comprehensible, specific implementations of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0019] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways than those described here, so the present invention is not limited by the specific embodiments disclosed below.

[0020] As indicated in this application and claims, the terms "a", "an", "an" and / or "the" do not refer to the singular and may include the plural unless the context clearly indicates an exception. Generally speaking, the terms "comprising" and "comprising" only suggest the inclusion of clearly identified steps and elements, and these steps and elements do not constitute an exclusive list, and the method or device may also contain other st...

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 data warehouse operation scheduling method and system based on an ETL framework and a computer readable medium. The method comprises the following steps: determining a data table with an operation fault in a data layer; starting a script program corresponding to the data table with the running fault; the script program re-runs the data table with the running fault based on the running dependency relationship data, re-runs the running dependency relationship data based on the data table with the running fault, and performs backtracking calling on the data table in the data layer until the data table with correct running is called; and determining whether the data table with the running fault runs correctly or not according to a re-running result. According to the method and the device, the data tables in the data layer are subjected to backtracking calling based on the operation dependency relationship data of the data tables with the operation faults, and only the data tables marked as the data tables with the operation faults are called, so that the development and test efficiency is improved.

Description

technical field [0001] The present invention mainly relates to the field of data processing, in particular to an ETL frame-based data warehouse operation scheduling method, system and computer-readable medium. Background technique [0002] ETL, the abbreviation of Extract-Transform-Load in English, is used to describe the process of extracting, transforming, and loading data from the source to the destination. ETL is the process of loading the business system data into the data warehouse after extraction, cleaning and conversion. The purpose is to integrate the scattered, messy, and non-uniform data in the enterprise to provide analysis basis for the decision-making of the enterprise. ETL is BI (Business Intelligence) project is an important part. [0003] For customers who provide services to enterprises in the form of Software-as-a-Service (SaaS for short), the data warehouse based on the ETL framework must have high real-time performance when processing reports. The cur...

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
IPC IPC(8): G06F11/36G06F9/48G06F16/21G06F16/25G06F16/28
Inventor 王仕凯陈诚戴橙
Owner 浙江太美医疗科技股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com