International Business Machines Corporation

Daniel T Chang

Robert N Summers

Basuki N Soetarman

Douglas Michael Hembry

Siyi Terry Donn

Frank C Tung

Tae Jae Lee

Neelakantan Sundaresan

Jian J Xu

Jyh-Herng Chow

Christina P Lau

Robbert C Van Der Linden

Taejae Lee

Mary C Lehner

Bruce A Benfield

Sundararaman Saiprasad

Josephine Miu Cheng

Yaron Wolfsthal

Josephine Miu-Kung Cheng

Hemant S Kolwalkar

An entity-relationship (ER)-eXtensible Markup Language (XML) hybrid data model includes an unmarked entity and an entity marked to be transformed as an XML column. In transforming the ER-XML hybrid data model to a physical data model, the unmarked entity is transformed to a table in the physical data model. It is determined whether the marked entity has an unmarked parent entity. If so, the marked entity, and the transitive closure of the marked entity, is transformed to an XML column in a table representing the unmarked parent entity in the physical data model, an XML schema document (XSD) for the XML column is generated, and the XSD is associated with the XML column. A relational-XML hybrid data model includes one or more XML columns marked to transform to a set of entities in the ER model by expanding the contents of the XSD associated with the XML column.

Defining and transforming entity relationship-XML hybrid data models

Disclosed is a system and program for managing schemas. A schema and one or more associated schema documents are registered. A schema information document is automatically generated based on the schema and the one or more associated schema documents. A request to be performed on at least one of the schema, an associated schema document, and the schema information document is processed.

Schema management

Disclosed is a method, system, and program for managing schemas. A schema and one or more associated schema documents are registered. A schema information document is automatically generated based on the schema and the one or more associated schema documents. A request to be performed on at least one of the schema, an associated schema document, and the schema information document is processed.

A Mail Facility Layer providing a general, semantics-free mail paradigm for asynchronous communication between distributed objects. It provides a level of abstraction in terms of mail, virtual mailbox, post office, and mail queue. It hides the details of implementation and transport and provides location transparency. A mail is asynchronously communicated between distributed objects by associating a destination with a name, wherein the destination is located on a remote system; associating the name with a first virtual mailbox representing the destination, wherein the first virtual mailbox is located on a local system; creating the mail; opening the first virtual mailbox; putting the mail in the first virtual mailbox; sending the mail from the first virtual mailbox to a second virtual mailbox, wherein the second virtual mailbox is located on the remote system; opening the second virtual mailbox; and getting the mail from the second virtual mailbox.

Method, system and computer product for providing an object class based distributed virtual mailbox and post office for communicating electronic mail messages between remote computers

Database extender for storing, querying, and retrieving structured documents

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 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

A method, apparatus and article of manufacture for computer-implemented creation of an index in a database system is defined, wherein a structured document, interactively entered by an operator or already stored in the database system, is parsed into at least one corresponding element, then abstracted using a predefined abstraction procedure to obtain a set of abstracted values, the set of abstracted values being stored in the index for efficient execution of structured queries.

Method and apparatus for creating an index in a database system

Federated searching of heterogeneous datastores using a federated query object

A communication infrastructure providing communication between agents, between agents and agent-hosting servers, and between agent-hosting servers. The communication infrastructure consists of three layers (from bottom to top): Mail Facility Layer, Message Facility Layer, and Agent Management Communication Facility Layer. The Mail Facility Layer is the lowest layer providing a general, semantics-free mail paradigm for asynchronous communication between distributed objects, whether they are local or remote to each other. The Mail Facility Layer provides a level of abstraction in terms of mail, virtual mailbox, post office, and mail queue, and hides the details of implementation and actual transport. It is designed to provide location transparency and to be implementable using various transport protocols. The next Message Facility Layer provides a typed messaging paradigm for asynchronous and synchronous message passing between distributed objects. The Message Facility Layer uses the Mail Facility Layer for sending messages and for getting responses to requests sent. It allows for the association of typed message handlers with typed messages such that the format and semantics of messages are encapsulated through their types, are extensible, and can be processed by the associated message handlers. The Agent Management Communication Facility Layer is the highest layer providing the services for inter-agent communication between agents, agent-agent-server communication between an agent and an agent server, and inter-agent-server communication between agent servers for managing agents such as locating an agent, dispatching an agent, retrieving an agent, etc. The key abstractions provided in this layer include agent manager, agent, and agent identifier. It uses the Message

Agent-based management system having an open layered architecture for synchronous and/or asynchronous messaging handling

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

A user may define a mapping between object schema and data store schema by use of a high level language, Schema Mapping Definition Language (SMDL), which is data store independent, object oriented language independent, and extensible. The user may either write SMDL directly or generate SMDL through the use of a graphical user interface Smart Schema whose graphical semantics support the SMDL semantics. A Schema Mapping Internal Representation (SMIR) containing representations of the object schema, the data store schema, and the mapping of the object schema and the data store schema is generated by an SMDL Parser from the SMDL. The SMIR is represented such that it may be accessible by both development interfaces and run-time environments. It supports the accessing of the mapping information given either the object schema or data store schema such that the data store schema may be accessed from the object schema, and the object schema may be accessed from the data store schema. An SMDL Generator may be used to generate the SMDL from the SMIR. The SMIR, SMDL Generator, SMDL Parser, and SMDL may be registered in a Data Store Manager (DSM) having a single, uniform, object oriented application programming interface for accessing one or more data stores, regardless of the type of data store.

System and method for providing a high level language for mapping and

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.

Growing community of inventors

San Jose, CA, United States of America

Daniel T Chang