International Business Machines Corporation

Douglas Michael Hembry

Robert N Summers

Daniel T Chang

Basuki N Soetarman

Siyi Terry Donn

Frank C Tung

Tae Jae Lee

Dragutin Petkovic

Peter C Yanker

Gerald Johann Wilmot

Mimi Phuong-Thao Vo

Nelson Mendonca Mattos

David Couttie Fallside

Carlton Wayne Niblack

Jing-Song Jang

Jean C Ho

Tri Quac Ha

Matthew Paul Anderson

Peter Paval Uhrowczik

Josephine Min-Kung Cheng

A system, method, and computer program product for collecting sets of related data with minimal redundancy, at a mainframe, and for transferring the collected data to a local workstation for processing. The mainframe remotely executes a utility application to construct an object model describing a desired structure of database elements. The object model is encoded into a single descriptive stream, such as XML, and converted to a metadata class for subsequent transfer to the local workstation. At the local workstation, the metadata class is decoded into a reconstructed object model for further processing.

System and method for collecting and transferring sets of related data from a mainframe to a workstation

A computer method and system capable of searching multiple heterogeneous datastores with heterogeneous data types by employing an object oriented data model to define a federated datastore object. The federated query object translates a generic query into the appropriate queries for each datastore, the federated datastore object acts as a virtual datastore for multiple heterogeneous datastores with the ability to map concepts between datastores, and the federated collection object represents results from a federated query in a hierarchy that maintains sub-grouping information from each datastore to allow accessing of results by datastore or as a single collection of results. The federated objects thus provide user applications with enhanced accessibility of different hierarchies of information, as well as more robust search capabilities.

Federated searches of heterogeneous datastores using a federated datastore object

A method, apparatus, and article of manufacture for defining object classes to match corresponding specialized data types stored in a relational database. An object-oriented application program may create an instance of a class for the purpose of representing data in a relational table that comprise a specialized data type. The attributes and behavior of the specialized data type in the database are preserved, where appropriate, in the corresponding class, and are available to the application program.

Defining object classes to match corresponding specialized data types in a relational database

A computer method and system capable of searching multiple heterogeneous datastores with heterogeneous data types by employing an object oriented data model to define a federated query object, a federated collection object and a federated datastore object. The federated query object translates a generic query into the appropriate queries for each datastore, the federated datastore object acts as a virtual datastore for multiple heterogeneous datastores with the ability to map concepts between datastores, and the federated collection object represents results from a federated query in a hierarchy that maintains sub-grouping information from each datastore to allow accessing of results by datastore or as a single collection of results. The federated objects thus provide user applications with enhanced accessibility of different hierarchies of information, as well as more robust search capabilities.

Managing results of federated searches across heterogeneous datastores with a federated collection object

Federated searching of heterogeneous datastores using a federated datastore object

Federated searching of heterogeneous datastores using a federated query object

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, a fifth table containing the names of the second and third tables for each object defined in the first table, a sixth table containing a reference to each object handle removed from the first table and including one column dedicated to containing a reference to the location of the object data associated with the removed object handle, and a seventh table having at least one column which describes a property of the data type of each object defined in the first table. The relational extender further includes an eighth table as a temporary holding table for the second table, and a ninth table as a temporary holding table for the third table. Both the eighth and ninth tables are used in conjunction with the extender triggers to ensure data integrity.

Computer program product for database relational extenders

A program product is described in which a class library is provided to permit object oriented applications to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table. Nontraditional datatypes of a relational table include multimedia and large object datatypes. The data is manipulable by virtue of extended data objects that each represent a cell of a relational row, and that each inherit type-specific behaviors from the class library. Special handling is provided for large objects.

Object aggregation representation of relational database rows having

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handles and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Relational database extenders for handling complex data types

A program product is described in which a particularly advantageous hierarchical class library is provided to permit object oriented applications to instantiate objects to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table. Nontraditional datatypes of a relational table include multimedia and large object datatypes. The data is manipulable by virtue of extended data objects that each represent a cell of a relational row, and that each inherit type-specific behaviors from the class library. The class library is advantageously structured into a hierarchy that ensures the availability of certain member functions for extended data objects.

Class hierarchy for object aggregation representation of relational

A program product is described in which a class library is provided to permit object oriented applications flexibly to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table. Nontraditional datatypes of a relational table include multimedia and large object datatypes. The data is manipulable by virtue of extended data objects that each represent particular cells of a relational table, and that inherit type-specific behaviors from the class library.

Flexible object representation of relational database cells having

A program product is described in which a class library is provided to permit object oriented applications to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table and, in particular, large objects. The data is manipulable by virtue of extended data objects that each represent a cell of a relational row, and that each inherit type-specific behaviors from the class library. Special handling for large objects is provided so as to avoid undue burdens on performance.

Object representation of relational database cells having nontraditional

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Growing community of inventors

Los Gatos, CA, United States of America

Douglas Michael Hembry