Patent ID: 7890541

Claim:
A computer implemented method for managing a partitioned table space for a database, the computer implemented method comprising: responsive to receiving a request to insert a record into a database table in the database, searching the partitioned table space to find available free space in a set of partitions in the table space, wherein each of the set of partitions which vary in size is created without a need for defining a key range for the set of partitions, the each of the set of partitions is composed of plurality of segments; and each of the plurality of segments is in fixed size; responsive to a determination that free space is unavailable for the record in the set of partitions, creating a new partition for the table space based on a size for the new partition, wherein the new partition is not created based on a key range for the new partition, and wherein the new partition is composed of the plurality of segments, and wherein the size for the new partition is determined from growth characteristics and new keywords in a structured query language statement, and wherein the size for the new partition is not defined at the time the table space is created; and inserting the record into the new partition.