Patent ID: 9195701
Filing Date: 2015-11-24
Classification: G06F

Abstract:
1. A method for logically dividing a database into multiple independently operated smaller databases, comprising: determining a number of partition groups desired for the database; partitioning a first table into a plurality of first partitions based on the determined number of partition groups desired, wherein the first partitions are less than or equal to the number of partition groups; partitioning a second table separate and at least partially different from the first table into a plurality of second partitions based on the number of partition groups desired, wherein the second partitions are less than or equal to the number of partition groups; and rearranging the first table and the second table into new tables corresponding to the partition groups by distributing the first partitions and the second partitions across the same partition groups, each one of the first partitions and each one of the second partitions moved into one of the partition groups forming a new table, wherein each one of the partition groups is an independently operated database comprising corresponding data, indexes, and internal catalogs allowing the each one of the partition groups to function as a database independently from the other partition groups.