The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 18, 2012
Filed:
Dec. 22, 2009
Wei Chang, Jiangsu, CN;
Zhigang Yu, Jiangsu, CN;
Shuquan Liu, Jiangsu, CN;
Guoxiang Liu, Jiangsu, CN;
Pengcheng Shen, Jiangsu, CN;
Qing Lan, Jiangsu, CN;
Guozhen Bian, Jiangsu, CN;
Feng Zhang, Jiangsu, CN;
Wei Chang, Jiangsu, CN;
Zhigang Yu, Jiangsu, CN;
Shuquan Liu, Jiangsu, CN;
Guoxiang Liu, Jiangsu, CN;
Pengcheng Shen, Jiangsu, CN;
Qing Lan, Jiangsu, CN;
Guozhen Bian, Jiangsu, CN;
Feng Zhang, Jiangsu, CN;
Linkage Technology Group Co., Ltd., Nanjing, Jiansu, CN;
Abstract
The data ETL (Extraction-Transformation-Loading) dispatching method of the present invention is applied to a real-time data ETL system, wherein a main ETL dispatching engine executes tasks according to preset sequence. In the execution, some key information are memorized by the main ETL dispatching engine, such as lscycle (latest successful data cycle), curcycle (current processing data cycle), and endcycle (processing end data cycle), etc., and are transferred to called programs. After the execution of the called programs, the main ETL dispatching engine records and keeps the updated dispatching information. In the data re-extraction, the data ETL dispatching method is adopted for the automatic re-extraction of some tasks and some cycles therein. The data ETL dispatching method, solves the problem caused by cyclic closed-loop extraction in traditional ETL dispatching programs according to timestamps in the real-time data ETL system, simplifies the tasks of the called program by allowing the called programs to focus on its own business logic, thereby giving sufficient development time for the real-time data ETL field, resulting in greatly enhancing the efficiency of project implementation.