Invention Grant
US08688625B1 Extract, transform, and load application complexity management framework
有权
提取,变换和加载应用程序复杂性管理框架
- Patent Title: Extract, transform, and load application complexity management framework
- Patent Title (中): 提取,变换和加载应用程序复杂性管理框架
-
Application No.: US13341433Application Date: 2011-12-30
-
Publication No.: US08688625B1Publication Date: 2014-04-01
- Inventor: Larry W. Clark , Jason P. Hendry , Mark Steen
- Applicant: Larry W. Clark , Jason P. Hendry , Mark Steen
- Applicant Address: US TX San Antonio
- Assignee: United Services Automobile Association (USAA)
- Current Assignee: United Services Automobile Association (USAA)
- Current Assignee Address: US TX San Antonio
- Agency: Brooks, Cameron & Huebsch, PLLC
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Extract, transform, and load application (ETL) complexity management framework systems and methods are described herein. The present disclosure describes systems and methods that reduce the complexity in managing ETL flow and correcting errant data that is subsequently identified. One or more methods include defining an ETL job definition, defining a data asset definition, defining a data asset dependency definition, receiving an ETL flow to provide execution of one or more ETL flow steps, providing retrieval of data from a source data asset, applying a data control to the source asset data, and producing an ETL job registration, a data asset status, a latest asset available date, a data asset consumer identifier, and a target data asset based on at least one of the ETL job definition, the data asset definition, the data dependency definition, and the source asset data.
Information query