Partitioning online databases

US8805784B2 · kind B2 · utility

Assignee

• Microsoft Corporation · US

Inventors

• Lev Novik · Bellevue, US
• Andrew E. Kimball · Sammamish, US
• Tony Petrossian · Bellevue, US
• Cihangir Biyikoglu · Issaquah, US
• Santeri Olavi Voutilainen · Seattle, US
• Tomas Talius · Sammamish, US
• Istvan Cseri · Seattle, US
• Joachim Hammer · Redmond, US
• Jason Clark · Fort Lupton, US
• Marc T. Friedman · Seattle, US
• Ajay Kalhan · Redmond, US

Key dates

• Filing date: Jun 21, 2011
• Grant date: Aug 12, 2014
• Expiry date: Feb 17, 2033

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/971
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

The present invention extends to methods, systems, and computer program products for partitioning online databases. Online database operations, such as, for example, SPLIT, MERGE, and DROP, are used to alter the arrangement of partitions in a federated database. A SPLIT operation splits rows at one partition across a plurality of other partitions. A MERGE operation merges rows at a plurality of partitions in to one partition. A DROP operation shifts responsibility for rows of data from one partition to another partition and then drops the rows from the one partition.