Browse Prior Art Database

Efficient Deletion of a Table Stored in a Segmented Tablespace

IP.com Disclosure Number: IPCOM000035877D
Original Publication Date: 1989-Aug-01
Included in the Prior Art Database: 2005-Jan-28

Publishing Venue

IBM

Related People

Authors:
Crus, RA Haderle, DJ Teng, JZ [+details]

Abstract

Relational data base tables are normally stored in "tablespaces" - one or more areas of physical storage logically concatenated together to form a single linear addressing range (i.e., starting from 0 to 64 gigabytes). The tablespace is divided into uniquely identified pages of fixed size. Segmented tablespaces include a header page, space map pages, and data pages. The data pages store the actual data, while the header and space map pages provide a framework for rapidly accessing the data pages. The data pages are grouped into uniquely identified segments of equal size which form the fundamental unit of storage in the segmented tablespace. All data pages in a given segment contain data for that segment's table only.