A METHOD AND SYSTEM FOR PROCESSING DATA

摘要

A system of redistributing partitions across servers having multiple partitions that each process transactions. Where the transactions are related to one another and the transactions are able to access one or a set of partitions simultaneously. The system comprising: a monitoring module operable to determine a transaction rate of the number of transactions processed by the multiple partitions on the first server; an affinity module operable to determine affinity between partitions, wherein the affinity being a measure of how often group transactions access sets of respective partitions; a partition placement module operable to determine a partition mapping in response to a change in a transaction workload on at least one partition on the first server, the partition placement module operable to receive input from at least one of: a server capacity estimator module; wherein server capacity estimator module is operable to determine the maximum transaction rate and use a pre- determined server-capacity-function; the affinity module; and distributing the partitions according to the determined partition mapping from the first server to a second server.