Systems and methods for synchronizing data in a cache and database

• US 9,009,116 B2
• Filed: 03/28/2006
• Issued: 04/14/2015
• Est. Priority Date: 03/28/2006
• Status: Active Grant

• Current Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Cattell, Roderic G., Russell, Craig L.
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Hoffler, Raheem
• Application Number:
  US11/393,163
• Publication Number:
  US 20070239797A1
• Time in Patent Office: 3,304 Days
• Field of Search: None
• US Class Current: 707/656
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Methods, systems, and articles of manufacture consistent with the present invention provide for managing a database. A data store is provided that is distributed over at least two sub data processing systems. A first information in the data store is associated with a first consistency level and a second information in the data store is associated with a second consistency level. At least one of the first consistency level and the second consistency level is selected according to an algorithm.

Claims

1. A method in a data processing system having a plurality of independent sub data processing systems, the data processing system including a processor and a memory which runs a program to manage a database, comprising the steps of:

providing a data store in one of the plurality of sub processing systems;

providing a plurality of data sub stores which are distributed over at least two of the plurality of sub data processing systems and connected to the data store via a network;

associating a first information with a first synchronization strategy and a second information with a second synchronization strategy;

wherein the first and second synchronization strategies are used to synchronize the reading and writing of the first and second information between the data store and each of the plurality of data sub stores; and

synchronizing the first information and the second information between the data store and each of the plurality of data sub-stores using the first and second synchronization strategies;

wherein,

the first and second synchronization strategies are automatically selected according to one or more of the following;

the frequency with which the first and second information is accessed, the type of data represented by the first and second information, or an algorithm.

2. The method of claim 1, wherein the algorithm is based on static information received.

3. The method of claim 2, wherein the static information identifies a synchronization strategy for at least one of a field, a row, a table, and part of a table.

4. The method of claim 1, wherein at least one of the first synchronization strategy and the second synchronization strategy is selected automatically based on dynamic information.

5. The method of claim 1, wherein the data store is a database cache.

6. The method of claim 1, wherein the data store is an in-memory database.

7. The method of claim 1, wherein the data store is distributed by partitioning the data store over the at least two sub data processing systems.

8. The method of claim 1, wherein the data store is distributed by replicating the data store over at least two of the sub data processing systems.

9. The method of claim 1, wherein the data store is distributed by partitioning the data store over the at least two sub data processing systems, and replicating at least one of the partitions over at least two of the sub data processing systems.

10. The method of claim 1, wherein the data store comprises a backend database or another data sub-store that is remote from the plurality of data sub-stores.

11. A data processing system having a processor, a memory, a plurality of independent sub data processing systems, and a program containing instructions for performing a method for managing a database, comprising the steps of:

providing a data store in the memory of one of the plurality of sub processing systems;

providing a plurality of data sub stores which are distributed over at least two of the plurality of sub data processing systems and connected to the data store via a network;

associating a first information with a first synchronization strategy and a second information with a second synchronization strategy, wherein the first information is primarily updated via one of the at least two sub data processing systems and the first synchronization strategy overwrites data in the data store with the first information from the one of the at least two sub data processing systems, and wherein the second information is primarily updated via both of the at least two sub data processing systems and the second synchronization strategy overwrites data in the plurality of data sub stores of the at least two sub data processing systems with the second information from the data store; and

synchronizing the first information and the second information between the data store and each of the plurality of data sub-stores;

wherein,

the first and second synchronization strategies are automatically selected according to one or more of the following;

the frequency with which the first and second information is accessed, the type of data represented by the first and second information, or an algorithm.

12. The data processing system of claim 11, wherein the algorithm is based on static information.

13. The data processing system of claim 11, wherein at least one of the first synchronization strategy and the second synchronization strategy is selected automatically based on dynamic information.

14. The data processing system of claim 11, wherein the data store is a database cache.

15. The data processing system of claim 11, wherein the data store is an in-memory database.

16. The data processing system of claim 11, wherein the data store is distributed by partitioning the data store over the at least two sub data processing systems.

17. The data processing system of claim 11, wherein the data store is distributed by replicating the data store over at least two of the sub data processing systems.

18. The data processing system of claim 11, wherein the data store comprises a backend database or another data sub-store that is remote from the plurality of data sub-stores.

19. A data processing system comprising:

a plurality of independent sub data processing systems, each sub data processing system having a memory and a processing unit, wherein a first of the sub data processing systems has a program that provides a data store;

a plurality of data sub-stores that are distributed over at least two of the plurality of sub data processing systems and connected to the data store via a network;

wherein, a first information is associated with a first synchronization strategy and a second information is associated with a second synchronization strategy, wherein the first and second synchronization strategies are used to synchronize the reading and writing of the first and second information between the data store and the plurality of data sub stores;

wherein the data processing system is configured to synchronize the first information and the second information between the data store and each of the plurality of data sub-stores over the network using the first and second synchronization strategies.

20. The data processing system of claim 19, wherein the first and second synchronization strategies are automatically selected according to one or more of the following:

the frequency with which the first and second information is accessed, the type of data represented by the first and second information, or an algorithm.

21. The data processing system of claim 20, wherein the algorithm uses one of static information and dynamic information.

22. The data processing system of claim 19, wherein the first and second synchronization strategies are different.

23. A non-transitory computer-readable medium containing instructions for managing data of a plurality of independent sub data processing systems, comprising:

instructions for providing a data store in the memory of one of the plurality of sub processing systems;

instructions for providing a plurality of data sub stores which are distributed over at least two of the plurality of sub data processing systems and connected to the data store via a network;

instructions for associating a first information with a first synchronization strategy and a second information with a second synchronization strategy, wherein the first information is primarily updated via one of the at least two sub data processing systems and the first synchronization strategy overwrites data in the data store with the first information from the one of the at least two sub data processing systems, and wherein the second information is primarily updated via both of the at least two sub data processing systems and the second synchronization strategy overwrites data in the plurality of data sub stores of the at least two sub data processing systems with the second information from the data store; and

instructions for synchronizing the first information and the second information between the data store and each of the plurality of data sub-stores;

wherein,

the first and second synchronization strategies are automatically selected according to one or more of the following;

the frequency with which the first and second information is accessed, the type of data represented by the first and second information, or an algorithm.

24. The non-transitory computer-readable medium of claim 23, wherein the first and second synchronization strategies are different.

25. A non-transitory computer-readable medium containing instructions for managing data in a data processing system, wherein the data processing system includes a plurality of independent sub data processing systems, wherein a first of the sub data processing systems has a program that provides a data store, wherein the data processing system includes a plurality of data sub-stores that are distributed over at least two of the plurality of sub data processing systems and connected to the data store via a network, and wherein the non- transitory computer-readable medium comprises:

instructions for associating a first information with a first synchronization strategy and a second information with a second synchronization strategy, wherein the first and second synchronization strategies are used to synchronize the reading and writing of the first and second information between the data store and the plurality of data sub stores;

instructions for synchronizing the first information and the second information between the data store and each of the plurality of data sub-stores over the network using the first and second synchronization strategies.

26. The non-transitory computer-readable medium of claim 25, wherein the first and second synchronization strategies are different.