Geetika Agrawal

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.

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.

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.

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.