Reorganization of data under continuous workload
First Claim
1. A database management system comprising:
- one or more computer readable storage media storing executable instructions that when executed by a processor provide;
a reorganization component configured to monitor performance parameters of a database relative to performance limits and perform dynamic adjustment of a composition of logical database units that provide online data of the database to increase or decrease the logical database units of the composition in response to changes that impact database performance, the reorganization component configured to merge multiple logical database units into a single logical database unit, the multiple logical database units being primary replicas of different partitions, the primary replicas receiving data modifications, the single logical database unit being a secondary replica, the secondary replica receiving the data modifications from the primary replicas.
2 Assignments
0 Petitions
Accused Products
Abstract
Architecture that provides the capability to automatically (e.g., dynamically) reorganize (repartition) an existing partition by dividing (splitting) or recombining (merging) logical databases. This reorganization can be performed to logical databases belonging to the same customer, and based on the partitioning of the tables in these databases. This can include not only splitting secondary replicas of a partition or merging secondary replicas of the partition, but also splitting off secondary replicas of the partition to create a new partition and merging two partitions into one partition. Moreover, these operations can occur while the logical databases are accepting workload (online).
-
Citations
20 Claims
-
1. A database management system comprising:
one or more computer readable storage media storing executable instructions that when executed by a processor provide; a reorganization component configured to monitor performance parameters of a database relative to performance limits and perform dynamic adjustment of a composition of logical database units that provide online data of the database to increase or decrease the logical database units of the composition in response to changes that impact database performance, the reorganization component configured to merge multiple logical database units into a single logical database unit, the multiple logical database units being primary replicas of different partitions, the primary replicas receiving data modifications, the single logical database unit being a secondary replica, the secondary replica receiving the data modifications from the primary replicas. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. A computer-implemented database management system comprising:
-
a reorganization component, at least partially implemented by a processor, configured to monitor parameters of a database that is operable with a physical media relative to performance limits of the database relative to replication and perform dynamic adjustments to a composition of replicas of the database configured to provide data to increase or decrease the replicas of the composition in response to changes that impact database performance, the reorganization component configured to; commit a dynamic adjustment when fewer than all of the plurality of replicas affected by the dynamic adjustment acknowledge the dynamic adjustment, and merge multiple replicas into a single replica, the multiple replicas being primary replicas of different partitions, the primary replicas receiving data modifications, the single replica being a secondary replica, the secondary replica receiving the data modifications from the primary replicas. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A computer-implemented database management method that executes on a processor and memory, comprising:
-
organizing a database as a partition of logical database units; monitoring parameters associated with performance limits that impact performance of the database; dynamically reorganizing a composition of the partition in response to database performance and while the logical database units are online, dynamically reorganizing including committing a dynamic reorganization when a replica of a portion of the database has not acknowledged the dynamic reorganization; and merging multiple replicas into a single replica, the multiple replicas being primary replicas of different partitions, the primary replicas receiving data modifications, the single replica being a secondary replica, the secondary replica receiving the data modifications from the primary replicas. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification