Siebel Systems, Inc.

Robert A Brodersen

Prashant Chatterjee

Peter S Lim

Peter Siam Sy Lim, Iii

Jeffrey Ira Cohen

Sanjin Tulac

Mark Coyle

Duane Wandless

John L Coker

Matthew Scott Malden

Gilberto Arnaiz

Risto Lankinen

Peter Siam Sy Lim Iii

A method of and system for collecting, storing, and retrieving data in a data base management system. The database management system includes a master database server (), at least one workgroup server (), and a plurality of workgroup user clients (). The workgroup server () is interposed between the master database server () and said workgroup user clients (). The method creating a transaction in a local database resident on one of the workgroup user clients (), entering the transaction into a transaction log resident on the workgroup user client (), and creating a transaction file corresponding to the transaction in an outbox of said workgroup user client (). Next, the transaction file is copied to an inbox identified to the workgroup user client () and updating the transaction file into a workgroup database () resident on the workgroup server (). The workgroup database () includes a transaction log.

Partially replicated distributed database with multiple levels of remote clients

A system and method for transforming a data object from a source form into a destination form is described. In one embodiment, the data object is stored in its source form as a set of related source components forming a source data structure having a first hierarchical configuration. The data object is stored in its destination form as a different set of related destination components forming a destination data structure having a different hierarchical configuration. A user is enabled to define a transformation map including a set of transformation mapping expressions declared by the user for transforming the data object between its source form and its destination form. The data object is then automatically transformed from its source form into its destination form based on the transformation map defined by the user and the source and destination data structures.

Engine for converting data from a source format to a destination format using user defined mappings

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

A method, system, and computer-readable medium are provided for displaying contents of a database table comprising a plurality of fields arranged in a plurality of rows and columns, selecting a field of the plurality of fields wherein the selected field comprises a reference to an attached file, and opening the attached file in response to the selecting. A row of the plurality of rows of the database table is associated with an attached file. A column of the plurality of columns comprises information about the attached files associated with the rows.

Method, apparatus, system, and program product for attaching files and other objects to a partially replicated database

Distributing and instantiating software version upgrades in a distributed computing environment. This includes defining the required versions of software as the contents of a software version upgrade kit. This is written, e.g., as a table of contents or a list, to a database to generate software version upgrade kit tables. These tables are used to generate software version upgrade kits. The kits are then used as a source to download copies of the upgrade kits to clients to be upgraded. This enables upgrading the software on the client.

Method, system, apparatus and program product for distribution and instantiation of software upgrades

A method, a program product, and a system for assigning resources to tasks in a rule based, resource constrained system. This is done by receiving as inputs tasks and task attributes; resources and resource attributes; and assignment rules. These inputs are used to searching a database of tasks, task attributes, and assignment rules thereof, to search a database of resources including resource attributes thereof, and to retrieve resources based upon the resource attributes. Resources are assigned to tasks based upon matches and scores of the resource attributes, the task attributes, and the assignment rules.

Assignment manager

A method of and system for collecting, storing, and retrieving data in a data base management system. The database management system includes a master database server ( ), at least one workgroup server ( ), and a plurality of workgroup user clients ( ). The workgroup server ( ) is interposed between the master database server ( ) and said workgroup user clients ( ). The method creating a transaction in a local database resident on one of the workgroup user clients ( ), entering the transaction into a transaction log resident on the workgroup user client ( ), and creating a transaction file corresponding to the transaction in an outbox of said workgroup user client ( ). Next, the transaction file is copied to an inbox identified to the workgroup user client ( ) and updating the transaction file into a workgroup database ( ) resident on the workgroup server ( ). The workgroup database ( ) includes a transaction log.

Attaching files and other objects in a distributed computing environment. This includes adding file attachments and non-database objects, such as, text file data, web file data, image file data, and other file attachment objects to databases. These objects may be retrieved at the convenience of a node to which the objects are sent. Visibility rules can be set to determine which attachments and objects are seen by a node. Distribution rules for an object determine whether a node must request the object or whether the node is forced to receive the object.

Upgrading a software application from one or more upgrade package files in a server (,) to a client (,). According to this method a copy of the upgrade package files and an upgrade database table are created on the server (,). A pointer is created in the client's (,) file on the server (,). This pointer points to the upgrade package files on the server (,); In invoking the upgrade the, the upgrade files are made active, and the upgrade database table is scanned when a client (,) docks. This is to determine the status of an upgrade with respect to the particular client (,). The upgrade is copied to the client (,) if the client (,) has not received the upgrade. At this point the upgrade may be invoked at the client (,). Also disclosed is a program product carrying code for the upgrade method.

Method of synchronizing independently distributed software and database schema

A method of and system for collecting, storing, and retrieving data in a data base management system. The database management system includes a master database server (,), at least one workgroup server (,), and a plurality of workgroup user clients (,). The workgroup server (,) is interposed between the master database server (,) and said workgroup user clients (,). The method creating a transaction in a local database resident on one of the workgroup user clients (,), entering the transaction into a transaction log resident on the workgroup user client (,), and creating a transaction file corresponding to the transaction in an outbox of said workgroup user client (,). Next, the transaction file is copied to an inbox identified to the workgroup user client (,) and updating the transaction file into a workgroup database (,) resident on the workgroup server (,). The workgroup database (,) includes a transaction log.

Method of and apparatus for collecting, storing, and retrieving data in a database management system. The database management system has an enterprise server and at least one workgroup user client. The method includes creating a transaction in a local database resident on said workgroup user client, entering the transaction into a transaction log resident on the workgroup user client, and creating a transaction file corresponding to the transaction log in an outbox of the workgroup user client. The workgroup user client transaction log is read, skipping those transactions which originate at the enterprise server, data files are created corresponding to the entries. The data files corresponding to transactions originating at the workgroup user client are read to an inbox on the enterprise server, thus updating the transactions into an enterprise database on the enterprise server.

Growing community of inventors

Redwood City, CA, United States of America

Robert A Brodersen