SOFTWARE, SYSTEMS, AND METHODOLOGIES FOR REALIGNMENT OF REMOTE DATABASES BY A CENTRAL DATABASE IN SUPPORT FIELD REPRESENTATIVE TERRITORY ASSIGNMENTS

• US 20080104134A1
• Filed: 10/26/2007
• Published: 05/01/2008
• Est. Priority Date: 10/27/2006
• Status: Active Grant

• Current Assignee: Purdue Pharma L.P.
• Original Assignee: Purdue Pharma L.P.
• Inventors: Raghavan, Rajeshwara, Natarajan, Sayee, Chellappa, Balaji
• Granted Patent: US 7,979,390 B2
• Time in Patent Office: Days
• US Class Current: 707/201
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning

Abstract

A method for realigning a database server and a client database is provided. During realignment at least one table of the database server is copied to a workspace, and a set of records copied to the workspace is identified that are associated with the client. The set of records associated with the client are modified and can include a subset of records newly associated with the client. An association-rule is created that defines the modified set of records as accessible by the client and includes an effective time. The association-rule and the newly associated records are distributed to the client, preferably during database synchronization. At the effective time, the modifications to the workspace records are made effective on the server and activated on the client. Optionally, the association-rule and the newly associated records are distributed in response to receiving approval of the modified set of records.

Claims

1. A method for realigning a database of a server and a database of a respective client among one or more of a plurality of clients, comprising the steps of:

copying at least one table of the database server to a workspace, the workspace having a plurality of records;

identifying a set of records among the plurality of records that are associated with the respective client;

modifying in the workspace the set of records associated with the respective client, the modified set of records including a subset of records newly associated with the respective client;

creating an association-rule for the respective client defining the modified set of records as accessible by the respective client, the association-rule having an effective time;

distributing to the respective client the association-rule and the subset of newly associated records; and

making effective in the database server at the effective time the modifications to the set of records in workspace.

2. The method of claim 1, further comprising the step of receiving approval of the modified set of records, and performing the distributing step in response to receiving approval.

3. The method of claim 1, further comprising the step of distributing to the respective client secondary data external to the workspace related to the modified set of records.

4. The method of claim 3, wherein the secondary data is retrieved from the database server.

5. The method of claim 1, further comprising the steps of:

synchronizing the respective client with the server; and

transmitting the subset of newly associated records during synchronization.

6. The method of claim 1, wherein the association-rule comprises a database view.

7. The method of claim 1, further comprising the step of generating a report concerning the set of records modified in the workspace.

8. The method of claim 1, wherein the copy of the at least one table of the database server creates respective workspace tables, and the step of making effective the modifications to the set of records includes the step of merging the workspace tables into the respective database server table.

9. The method of claim 1, further comprising the steps:

determining if the modifying step alters one or more secondary data records external to the workspace; and

in response to the determination step, selectively copying the secondary data records into the workspace,

wherein the modifying step alters the secondary data records in the workspace.

10. The method of claim 1, including the additional step of activating the association-rule at the effective time at the respective client.

11. A method for realigning data responsibility in a client-database server environment, comprising the steps of:

copying a table from a database server to a workspace, the database server associating respective first sets of database records with respective clients, each having a client database;

establishing a proposed realignment of database records for each respective client;

creating in the workspace respective second sets of database records corresponding to respective proposed assignments;

defining an accessibility-rule for each respective client having a common effective time;

distributing to each client the respective accessibility-rule and second set of database records; and

making effective the second association of the workspace table in the database server at the effective time.

12. The method of claim 11, further comprising the step of receiving approval of the proposed assignment, and performing the distributing step in response to receiving approval.

13. The method of claim 11, further comprising the step of distributing to the respective client database at least one secondary data record related to the second set of data records.

14. The method of claim 13, wherein the secondary data is retrieved from the table of the database server.

15. The method of claim 11, further comprising the steps of:

synchronizing the respective client with the server; and

transmitting the data records associated with the associated second set during the synchronization.

16. The method of claim 11, wherein the accessibility-rule comprises a database view.

17. The method of claim 11, further comprising the step of generating a report concerning the proposed realignment.

18. The method of claim 11, wherein the step of making effective the modifications of the workspace table includes the step of merging the workspace table into the database server table.

19. The method of claim 11, further comprising the steps:

determining if the creating step requires alteration of a data record stored in a secondary table external to the workspace; and

in response to the determination step, copying the secondary table into the workspace,

wherein the creating step modifies data records in the secondary table.

20. The method of claim 11, including the additional step of activating the association-rule at the effective time at the respective client.