Patent · US Active

Lifecycle-based horizontal partitioning

US9542424B2 · kind B2 · utility

4Cited by

9References

18Claims

0Family size

Assignee

Hasso-Plattner Institut fuer Softwaresystemtechnik GmbH · DE

Inventors

Hasso Plattner · Schriesheim, DE
Martin Grund · Lafayette, US
Jens Krueger · Heidenheim, DE
Alexander Zeier · Berlin, DE

Key dates

Filing date	Jun 30, 2010
Grant date	Jan 10, 2017
Priority date	—
Expiry date	Aug 22, 2030

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/22
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

The invention relates to a computer-implemented method for dynamically and horizontally partitioning a table of a relational database, wherein the table comprises records, wherein the records are mapped to a plurality of states, wherein the table is horizontally partitioned into a plurality of partitions, and wherein the plurality of states is mapped to the plurality of partitions. The method comprises the steps of changing the assignment of a first record from a first state to a second state, wherein the first state is mapped to a first partition, wherein the second state is mapped to a second partition, wherein the first partition is not the second partition, and storing the first record in the second partition. The invention further relates to a computer system implementing the abovementioned method for dynamically and horizontally partitioning a table of a relational database.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.