Geetika Agrawal from San Jose, CA

Common Interface To Access Catalog Information From Heterogeneous Databases
view source
US Patent:

8051094, Nov 1, 2011
Filed:

Oct 12, 2008
Appl. No.:

12/249957
Inventors:

Geetika Agrawal - San Jose CA, US
Mary Ann Roth - San Jose CA, US
Peter Martin Schwarz - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 7/00
G06F 17/30
US Classification:

707770, 709203
Abstract:

Various embodiments of a system and computer program product to access metadata from a plurality of data servers from a federated database management system are provided. In one embodiment, a request for metadata, from a client application, is received by the federated database management system. Data servers which are accessible from the federated database management system are identified. For each data server, metadata describing data of a data source of that data server is retrieved in accordance with the application request. The retrieved metadata from each of the data servers is aggregated to produce an aggregated result in a uniform format. The aggregated result is provided. In another embodiment, for each data server, a source metadata request for metadata of that data server is generated in accordance with the application request and a source metadata application programming interface. A view is created based on the source metadata request for metadata for each data server.

Managing Validation Models And Rules To Apply To Data Sets
view source
US Patent:

8401987, Mar 19, 2013
Filed:

Jul 17, 2007
Appl. No.:

11/779251
Inventors:

Geetika Agrawal - San Jose CA, US
Jacques Joseph Labrie - Sunnyvale CA, US
Mary Ann Roth - San Jose CA, US
Yannick Saillet - Stuttgart, DE
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06N 5/00
US Classification:

706 47, 706 45
Abstract:

Provided are a method, system, and article of manufacture for managing validation models and rules to apply to data sets. A schema definition describing a structure of at least one column in a first data set having a plurality of columns and records providing data for each of the columns is received. At least one model is generated, wherein each model asserts conditions for at least one column in a record of the first data set. The schema definition and the at least one model are stored in a data quality model. Selection is received of a second data set and the data quality model. A determination is made as to whether a structure of the second data set is compatible with the schema definition in the selected data quality model. Each model in the data quality model is applied to the records in the second data set to validate the records in the second data set in response to determining that the structure of the second data set and the schema definition are compatible.

Common Interface To Access Catalog Information From Heterogeneous Databases
view source
US Patent:

20060265385, Nov 23, 2006
Filed:

May 17, 2005
Appl. No.:

11/131792
Inventors:

Geetika Agrawal - San Jose CA, US
Mary Roth - San Jose CA, US
Peter Schwarz - San Jose CA, US
International Classification:

G06F 17/30
US Classification:

707010000
Abstract:

Various embodiments of a method, system and article of manufacture to access metadata from a plurality of data servers from a federated database management system are provided. In one embodiment, a request for metadata, from a client application, is received by the federated database management system. Data servers which are accessible from the federated database management system are identified. For each data server, metadata describing data of a data source of that data server is retrieved in accordance with the application request. The retrieved metadata from each of the data servers is aggregated to produce an aggregated result in a uniform format. The aggregated result is provided. In another embodiment, for each data server, a source metadata request for metadata of that data server is generated in accordance with the application request and a source metadata application programming interface. A view is created based on the source metadata request for metadata for each data server.

Web 2.0 System And Method For Dynamic Categorization Of Heterogeneous And Regulated Enterprise Assets
view source
US Patent:

20090144296, Jun 4, 2009
Filed:

Dec 3, 2007
Appl. No.:

11/949680
Inventors:

Geetika Agrawal - San Jose CA, US
Benjamin Honzal - Isny im Allgaeu, DE
Jacques Joseph Labrie - Sunnyvale CA, US
Mary Ann Roth - San Jose CA, US
Assignee:

International Business Machines Corporation - Armonk NY
International Classification:

G06F 17/30
US Classification:

707100, 707E17044
Abstract:

A system and method for the dynamic categorization of heterogeneous, regulated enterprise information assets. In one embodiment of the invention a system includes a computer network controlled by an enterprise and a database including a plurality of enterprise data entities. A user interface, through which a plurality of enterprise users may access the enterprise data entities, is also used by the plurality of users to assign user-defined categories to the enterprise data entities. The user interface is configured to enable a plurality of the users to access and assign additional user-defined categories to enterprise data entities having user-defined categories previously assigned by other users.