Go to  Advanced Search

Automating physical reorganizational requirements at the access path level of a relational database management system

Show full item record

Files in this item

Files Size Format Description   View
UBC_1980_A6_7 W44.pdf 6.976Mb Adobe Portable Document Format   View/Open
 
Title: Automating physical reorganizational requirements at the access path level of a relational database management system
Author: Weddell, Grant Edwin
Degree Master of Science - MSc
Program Computer Science
Copyright Date: 1980
Subject Keywords Information storage and retrieval systems; Database management
Abstract: Any design of an access path level of a database management system must make allowance for physical reorganization requirements. The facilities provided for such requirements at the access path level have so far been primitive in nature (almost always, in fact, requiring complicated human intervention)This thesis begins to explore the notion of increasing the degree of automation of such requirements at the access path level; to consider the practical basis for self-adapting or self-organizing data management systems. Consideration is first given to the motivation (justification) of such a notion. Then, based on a review of the relevant aspects of a number of existing data management systems, we present a complete design specification and outline for a proposed access path level. Regarding this system we consider in detail the automation of two major aspects of physical organization: the clustering of records on mass storage media and the selection of secondary indices. The results of our analysis of these problems provides a basis for the ultimate demonstration of feasibility of such automation.
URI: http://hdl.handle.net/2429/22191
Series/Report no. UBC Retrospective Theses Digitization Project [http://www.library.ubc.ca/archives/retro_theses/]
Scholarly Level: Graduate

This item appears in the following Collection(s)

Show full item record

All items in cIRcle are protected by copyright, with all rights reserved.

UBC Library
1961 East Mall
Vancouver, B.C.
Canada V6T 1Z1
Tel: 604-822-6375
Fax: 604-822-3893