20-11-2014 дата публикации
Номер: US20140344221A1
Автор:
Lev Novik,
Andrew Kimball,
Tony Petrossian,
Cihangir Biyikoglu,
Santeri Olavi Voutilainen,
Tomas Talius,
Istvan Cseri,
Joachim Hammer,
Jason D. Clark,
Marc T. Friedman,
Ajay Kalhan,
NOVIK LEV,
KIMBALL ANDREW,
PETROSSIAN TONY,
BIYIKOGLU CIHANGIR,
VOUTILAINEN SANTERI OLAVI,
TALIUS TOMAS,
CSERI ISTVAN,
HAMMER JOACHIM,
CLARK JASON D,
FRIEDMAN MARC T,
KALHAN AJAY,
CLARK JASON D.,
FRIEDMAN MARC T.
Принадлежит:
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. 1. At a distributed database system including one or more processors and system memory , the distributed database system also including a plurality of database partitions , including a first database partition and a second database partition , in a federation , the federation configured to store a plurality of rows of data , each row of data identified by a federation key value such that the federation stores data for a set of federation key values , each of the plurality of database partitions configured to store any rows of data having a federation key values within a specified subset of the set of federation key values , a method for dropping rows of data from the distributed database system , the method comprising:an act of receiving a partition drop directive indicating how to process at least some of one or more of the plurality of specified subsets of federation key values to drop corresponding rows of data stored in the plurality of database partitions; andan act of executing a drop operation to drop the corresponding rows of data in accordance with the partition drop directive and while the plurality of database partitions remain online, including for each database partition that is to drop corresponding rows of data, configuring one or more other database partitions to store portions of the rows of data to be dropped.2. The method of claim 1 , wherein configuring another database to store portions of the rows of ...
Подробнее