1
Sankaran Suresh, Jyotindra Pramathnath Gautam, Girish Pancha, Frank Joseph DeRose, Mohan Sankaran: Method and architecture for automated optimization of ETL throughput in data warehousing applications. Informatica Corporation, Wagner Murabito & Hao, March 27, 2001: US06208990 (132 worldwide citation)

A computer software architecture to automatically optimize the throughput of the data extraction/transformation/loading (ETL) process in data warehousing applications. This architecture has a componentized aspect and a pipeline-based aspect. The componentized aspect refers to the fact that every tra ...


2
Girish Pancha, A Adam Wilson, Sankaran Suresh, Spencer A Lord: System and method for coupling remote data stores and mobile devices via an internet based server. Informatica Corporation, Fenwick & West, November 23, 2004: US06823373 (120 worldwide citation)

The present invention provides a mobile data communication system which couples application specific remote data sources and mobile devices via an internet based server. An interface is provided by the server for extracting data from the application specific remote data sources. The extracted data i ...


3
Mohan Sankaran, Sankaran Suresh, Mon Wong, Diaz Nesamoney: Method for incremental aggregation of dynamically increasing database data sets. Informatica Corporation, Wagner Murabito & Hao, August 11, 1998: US05794246 (115 worldwide citation)

A method of performing incremental aggregation of dynamically increasing database data sets. An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received data to provide current informatio ...


4
Pinaki Mukhopadhyay, Diaz Nesamoney, Mohan Sankaran, Sankaran Suresh, Sanjeev K Gupta: Apparatus and method for capturing and propagating changes from an operational database to data marts. Informatica Corporation, Wagner Murabito & Hao, February 29, 2000: US06032158 (114 worldwide citation)

A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was no ...