"EXTRACT, TRANSFORM AND LOAD (ETL) SYSTEM AND METHOD"

An ETL system for extracting transactional data from a plurality of source machines is provided. The ETL system includes a data query module configured to provide an interface to enable a data analyst to define an input query to extract transactional data. The transactional data is present on a plur...

Full description

Saved in:
Bibliographic Details
Main Authors ABHILASH L L, PRASUN KUMAR, PRAVANJAN CHOUDHURY, SUDIPTA SAMANTA, KRISHNA KUMAR MEHRA
Format Patent
LanguageEnglish
Published 03.07.2015
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:An ETL system for extracting transactional data from a plurality of source machines is provided. The ETL system includes a data query module configured to provide an interface to enable a data analyst to define an input query to extract transactional data. The transactional data is present on a plurality of source machines. The plurality of source machines form a multi-tenant system and each source machine is identified by a unique tenant identifier. The system also includes a query parsing module coupled to the data query module and configured to deconstruct the input query to create a tree structure. The tree structure comprises a plurality of distinct queries. The system further includes a data extraction module coupled to the query parsing module and configured to extract transactional data based on the plurality of distinct queries and copy the transactional data to a destination system wherein the transactional data comprises a plurality of data types.
Bibliography:Application Number: IN2013CHE6122