1
Somakumar R
Firoz Kanchwalla, David Lyle, Sujit Bais, Srinivasan Maadapusi, Amol Dongre, Premkumar Somakumar: Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface. Informatica Corporation, October 3, 2006: US07117215 (48 worldwide citation)

A method and apparatus for transporting data for a data warehousing application. Data is extracted from one or more source containing data having a standard data structure and is translated into data that contains meaningful business terms. The translated data is then stored. In the present embodime ...


2
Kiumarse Zamanian, Diaz Nesamoney: Apparatus and method for performing data transformations in data warehousing. Informatica Corporation, Wagner Murabito & Hao, January 15, 2002: US06339775 (165 worldwide citation)

A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for sto ...


3
M S Kiumarse Zamanian, Diaz Nesamoney: Apparatus and method for performing data transformations in data warehousing. Informatica Corporation, Wagner Murabito & Hao, January 11, 2000: US06014670 (139 worldwide citation)

A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for sto ...


4
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 ...


5
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 ...


6
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 ...


7
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 ...


8
Diaz Nesamoney, Parth S Chandra, Sanjeev Gupta, Girish Pancha, Jeffrey B Taylor, M S Kiumarse Zamanian: Method and apparatus for sharing metadata between multiple data marts through object references. Informatica Corporation, Wagner Murabito & Hao, March 28, 2000: US06044374 (112 worldwide citation)

A method and system for accessing and sharing metadata amongst a number of data marts through the use of object referencing. A global repository is created. Shared folders containing metadata is contained in the global repository. Any number of data marts can be linked to the global repository. Stor ...


9
Dwayne Chung, Gautam H Mudunuri, Fayyaz Younas, Lillian S Lim, Renjie Tang, Steve Carlin, Subramanya Madapura: Method and apparatus with data partitioning and parallel processing for transporting data for data warehousing applications. Informatica Corporation, February 1, 2005: US06850947 (50 worldwide citation)

A method and apparatus for transporting data for a data warehouse application is described. The data from an operational data store (the source database) is organized in non-overlapping data partitions. Separate execution threads read the data from the operational data store concurrently. This is fo ...


10
Eva Man Yan Tse, Pinaki Mukhopadhyay, Sumitro Samaddar: Method and apparatus for synchronizing cache with target tables in a data warehousing system. Informatica Corporation, May 17, 2005: US06895471 (34 worldwide citation)

A method and apparatus for processing (transporting) data, such as in a data warehouse system. In one embodiment, the data are received from a source and compared to data in a lookup cache comprising a subset of data from a first data set (e.g., a dimension table). Instances of the data not present ...