Siebel Systems, Inc.

Mark Coyle

Robert A Brodersen

Sanjin Tulac

Jeffrey Fischer

Shuang Huang

Peter S Lim

Min Lu

Alexander S Warshavsky

A data adapter including method and apparatus is presented. In one embodiment, the data adapter is a method. The method includes finding a set of records of a relational database matching an object instance of an object type. The method further includes updating the set of records of the relational database based on a first set of instances of components of the object instance, the instances of components of the first set corresponding to the records of the set of records. The method further includes inserting new records in the relational database corresponding to a second set of instances of components of the object instance, the instances of components of the second set not matching records of the set of records. The method also includes recursively repeating the finding, updating and inserting with respect to child components of the components.

Data adapter

Techniques to support modification of certain data in a database during an upgrade to a new version. In one method, objects in an original database are marked as either modifiable or read-only, with changes being allowed for modifiable objects during the upgrade. An upgraded database of objects is generated based on objects in the original database (e.g., by copying objects in the original database and upgrading the copied objects to new schema and binaries). Changes to modifiable objects in the original database (e.g., after these objects have been copied) are logged. After the upgraded database has been created, objects in this database may be updated (e.g., individually or all at once) by identifying modifiable objects in the original database having changes not yet incorporated into the upgraded database and updating objects in the upgraded database based on the modified objects in the original database.

Method, system, and product for maintaining software objects during database upgrade

Techniques to track and publish changes to object instances. For an 'outbound process' to publish object instances, a list of object instances is initially received. For each received object instance, a determination is made whether or not the object instance has changed since its last publication. For each changed object instance, a delta snapshot is generated and includes data indicative of changes between the current and last published versions of the object instance. Delta snapshots for all changed object instances are then published. For an 'inbound process' to receive object instances, the published delta snapshots are initially received. For each received delta snapshot, the corresponding object instance is retrieved and updated with the changes included in the delta snapshot. A new snapshot is also generated for each updated object instance such that the received changes are not published, and unpublished changes made locally are noted for subsequent publication.

Method and system for tracking and exchanging incremental changes to hierarchical objects

A method and system for using integration objects with enterprise business applications is disclosed. A method comprises importing external objects having a first format for a first enterprise application into a second enterprise application; using integration objects to transform the first format external objects into second format external objects formatted for the second enterprise application; and using the second format external objects in the second business application.

Growing community of inventors

San Francisco, CA, United States of America

Mark Coyle