Partitioning online databases

US9372882B2 · kind B2 · utility

Assignee

• MICROSOFT TECHNOLOGY LICENSING, LLC · 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: Aug 5, 2014
• Grant date: Jun 21, 2016
• Expiry date: Aug 5, 2034

Classification

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

Abstract

Methods, systems, and computer program products are provided 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.