Informatica Corporation

Girish Pancha

Sankaran Suresh

Sanjeev K Gupta

Diaz Nesamoney

Mohan Sankaran

Spencer Allen Lord

Parth S Chandra

M S Zamanian

Frank Joseph DeRose

Jyotindra Pramathnath Gautam

Jeffrey B Taylor

A Adam Wilson

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 is then generalized into generic objects and presented on the mobile devices by device specific application templates.

System and method for coupling remote data stores and mobile devices via an internet based server

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 transformation used in this architecture is built up with transformation components selected from an extensible set of transformation components. Besides simplifying source code maintenance and adjustment for the data warehouse users, these transformation components also provide these users the building blocks to effectively construct pertinent and functionally sophisticated transformations in a pipelined manner. Within a pipeline, each transformation component automatically stages or streams its data to optimize ETL throughput. Furthermore, each transformation either pushes data to another transformation component, pulls data from another transformation component, or performs a push/pull operation on the data. Thereby, the pipelining; staging/streaming; and pushing/pulling features of the transformation components effectively optimizes the throughput of the ETL process.

Method and architecture for automated optimization of ETL throughput in data warehousing applications

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. Stored within the folders of the linked data marts are references pointing to certain metadata stored in the shared folders of the global repository. Multiple data marts can reference the same metadata in the global repository. Thereby, the same metadata can be accessed, used, and shared by multiple users across different data marts, provided that they have been granted the proper authority. New metadata can be promoted from a linked data mart into the global repository so that it can be shared, and updates to shared metadata can be automatically propagated to all users referencing that metadata.

Method and apparatus for sharing metadata between multiple data marts

Growing community of inventors

San Francisco, CA, United States of America

Girish Pancha