International Business Machines Corporation

Google Inc.

Hoa Thu Tran

Douglas R Fish

Brian John Cragun

David Alan Wall

Cale T Rath

Travis Michael Drucker

Jordi A Albornoz

Judy I Djugash

William Craig Rapp

Peter Martin Schwarz

Sean James Martin

Julia Elizabeth Rice

Lee David Feigenbaum

William Clarence Swope

Judy Immaculate Tina Djugash

Richard D Dettinger

Jeffrey Wayne Tenner

Christine A Grev

Methods, systems and articles of manufacture are provided for migrating entity relationship data residing in an object oriented program environment to a relational database schema. Further, functionality is provided to facilitate more efficient searching and reconstruction of the entity relationship data in the relational database.

Method and system for reconstruction of object model data in a relational database

Methods, systems, and articles of manufacture for indexing annotations made for a variety of different type (i.e., heterogeneous) data objects are provided. A set of parameters uniquely identifying an annotated data object may be converted to an index comprising a set of index values, each corresponding to a column in a homogeneous index table. In order to accommodate the indexing of heterogeneous data objects, a mapping may be provided for each different type (or classification) of data object that may be annotated, that defines how the identifying parameters of that type will be mapped to the columns of the homogeneous index table.

Heterogeneous multi-level extendable indexing for general purpose annotation systems

Methods, systems and articles of manufacture are disclosed for providing secure access to data. Public UDTFs, private UDTFs and a metadata processor are utilized to facilitate secure access to data residing in a variety of data repositories. User security attributes and UDTF attributes are gathered. A table is queried based on the gathered attributes.

Providing secure access to data with user defined table functions

Techniques are provided for accessing data within data repositories. Public UDTFs, private UDTFs and a metadata processor are utilized to provide access to data residing in a variety of data repositories.

Providing access to data with user defined table functions

The present invention generally provides methods, systems, and articles of manufacture for managing an annotation system that includes storing annotations for a document family, i.e., a series of versions of a data source. Annotations created for one version of the data source may be viewed in context from both subsequent and prior versions of the same data source. Embodiments of the invention associate annotations with both a data source 'family identifier' as well as a 'version identifier.' Other than adding a family ID to the data source, the data source remains unchanged. The family ID is maintained across different versions of the data source, whereas version IDs are determined for a specific version of the data source. Version IDs can be constructed from each data source directly, and do not need to be stored.

Associating annotations with document families

Methods, systems and articles of manufacture are disclosed for providing secure access to data. Public UDTFs, private UDTFs and a metadata processor are utilized to facilitate secure access to data residing in a variety of data repositories.

System and method for providing secure access to data with user defined table functions

Methods, systems and articles of manufacture are provided to facilitate efficient searching and reconstruction of entity relationship data in a relational database. The entity relationship data in the relational database is migrated from an object oriented program environment.

Methods, systems and articles of manufacture are provided for accessing data within data repositories. Public UDTFs, private UDTFs and a metadata processor are utilized to provide access to data residing in a variety of data repositories.

System and method for providing access to data with user defined table functions

Methods, systems, and articles of manufacture that may be used for identifying and indicating annotations made for a variety of different type (i.e., heterogeneous) data objects are provided. According to some embodiments, an annotation store may be queried to identify annotations for data objects in a current view of data. For certain identifiable portions of the view (e.g., a row in a relational view), a callable function may be created that returns a set of indicia maps indicating which objects in the portions are annotated. Bits in an indicia map may correspond to different objects (e.g., individual cells in a row or the row itself). Using these indicia maps, an indication of which data objects are annotated may be provided in the view, for example, by displaying annotation icons proximate annotated objects.

Including annotation data with disparate relational data

Method for associating annotations with document families

A graphical query and data mining interface provides visual feedback to a user during the construction of a query that helps the user determine the quality of the query as the query is being built. The graphical query and data mining interface determines relationships in the database from a database relationship document, such as an XML document. These relationships may be between columns, including columns in different tables. The relationship of columns in the database is then graphically displayed to a user. When the user selects a column in the database, a filtered display mechanism displays only those columns or records that satisfy the portion of the query already constructed. In this manner dynamic information is provided to the user as the user builds the query that indicates to the user the quality of the query.

Dynamic graphical database query and data mining interface

Methods, systems, and articles of manufacture that may be used to attach annotations to a particular view of data described by the annotation are provided. The annotation may be attached in a manner that allows the annotation to be viewed when subsequent views having at least some visible cells in common with the annotated view are displayed. An annotation created for a view of data may be stored with links to each cell visible in the view. When a predetermined set of cells visible in the annotated view are subsequently displayed in another view, the annotation may be retrieved via the cell links and an indication of the annotation may be provided.

Growing community of inventors

Rochester, MN, United States of America

Hoa Thu Tran