Siebel Systems, Inc.

Robert S Brodersen

Peter S Lim

John L Coker

Mark Curtis Hastings

Prashant Chatterjee

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 method for upgrading (-of FIG.) a software application (-) from a prior version to a subsequent version while preserving user modifications to the prior application. The method includes comparing differences between the two versions of the software applications. This is followed by enumerating the differences between the two versions of the software applications; and determining which differences between the two versions of the software are conflicting and which are compatible. The compatible changes are made (). Also disclosed is an article of manufacture containing computer readable program code for carrying out the above process, and a program storage device carrying the code.

Method and apparatus for upgrading a software application in the presence of user modifications

Updates made to a central database ( ) or to another partially replicated database ( - ) are selectively propagated to a partially replicated database ( - ) if the owner of the partially replicated database ( - ) is deemed to have visibility to the data being updated. Visibility is determined by use of predetermined rules stored in a rules database. Stored rules are assessed against data content of various tables that make up a logical entity, known as a docking object that is being updated. The stored rules are assessed against data content of various tables that make up a docking object, not necessarily being the docking object that is being updated. The visibility rules of these related docking objects are recursively determined. Changes in visibility are determined to enable the central computer to direct the nodes to insert the docking object into its partially replicated database. The predetermined rules are in a declarative form and specify visibility of data based upon structure of the data without reference to data content. Database objects and transactions have an associated visibility strength used to determine the visibility of a transaction to an object.

Method of using cache to determine the visibility to a remote database client of a plurality of database transactions

Method of using a cache to determine the visibility to a remote database client of a plurality of database transactions

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.

A method for upgrading ( - of FIG. ) a software application ( - ) from a prior version to a subsequent version while preserving user modifications to the prior application. The method includes comparing differences between the two versions of the software applications. This is followed by enumerating the differences between the two versions of the software applications; and determining which differences between the two versions of the software are conflicting and which are compatible. The compatible changes are made ( ). Also disclosed is an article of manufacture containing computer readable program code for carrying out the above process, and a program storage device carrying the code.

Method of upgrading a software application in the presence of user modifications

The invention relates to a method of managing a database. The database includes a central database (,) and separate partially replicated databases (,-,-,-,). Each partially replicated database resides on a separate node (,-,-,-,). Each replicated database has an associated visibility strength. The method of managing a database determines the visibility strength of a partially replicated database to data being propagated, determines therefrom the visibility of the partially replicated database to the data being propagated, and propagates the data to a partially replicated database only if the node of the partially replicated database has visibility to the data.

Method of determining visibility to a remote database client of a plurality of database transactions having variable visibility strengths

Database management method and system, for a database having a central database and a plurality of partially replicated databases. The database management method and system determine the visibility of a user of a separate replicated database to the central database from a set of visibility rules stored at a central location.

Growing community of inventors

Redwood City, CA, United States of America

Robert S Brodersen