Browse Prior Art Database

Dynamic Assignment of tables to table spaces

IP.com Disclosure Number: IPCOM000032188D
Original Publication Date: 2004-Oct-26
Included in the Prior Art Database: 2004-Oct-26
Document File: 1 page(s) / 28K

Publishing Venue

IBM

Abstract

Disclosed is a system aimed to increase database performance my being proactive and monitoring database usage.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 80% of the total text.

Page 1 of 1

Dynamic Assignment of tables to table spaces

Disclosed is a system aimed to increase database performance by being proactive and monitoring database usage. The database will sense the activity of access to tables. Based on this access activity, the database can move tables to appropriate physical storage locations. In database products one can assign tables to table spaces and map table spaces to physical storage. This technique can offer control over the performance of one's database. One can opt to use the fastest storage devices for more frequently used tables and store less frequently used data on slower storage devices. The problem with current database setups is that the provisioning process is manual and not autonomic.

The proposed system aims to increase database performance by being proactive and monitoring database usage. The database will sense the activity of access to tables. Based on this access activity, the database can move tables to appropriate physical storage locations. The database will keep track of the activity on tables. Based on this access information, tables might be reallocated to different physical storage locations. The offering will allow for the dynamic reallocation process to occur without having to disrupt access. To allow for this, the following implementation might be used:

1) A sync operation is started.
2) A table is rebuilt at the target location (in a new physical location) using a table backup. This of course will only cont...