A performance analysis of view materialization strategies for general expressions

Download
Author
Barefield, Curtis G., Jr.
Date
1990-03Advisor
Kamel, Magdi N.
Second Reader
Griffin, Rachel
Metadata
Show full item recordAbstract
Efficient processing of views is critical to many real world applications, particularly real time applications such as surveillance systems which support military applications. This thesis compares the performance of three view materialization strategies: Semi-materialization, full materialization and query modification. This thesis first develops a program that generates databases according to user specification. Second the generated databases are used to conduct an empirical study on the three view materialization strategies using select-project-join and general expression views. The results of the study indicate that for select-project-join definitions, semi-materialization performed best for higher values of P, lower vales of 1, fv and all values of fq with the database stored on hard disk. Full materialization performed best for lower values of P, 1 and all values of fv with the database stored in RAM. The results also indicate that the semi-materialization strategy is the best view processing method for general expressions.
Rights
This publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.Collections
Related items
Showing items related by title, author, creator and subject.
-
DEMIGODS WITH RED STRIPES OR HEIRS OF WILLIAM TELL? THE GENERAL STAFF'S ROLE IN A DEMOCRACY: THE GERMAN REICH AND SWITZERLAND
Amigo, Enric F. (Monterey, CA; Naval Postgraduate School, 2019-12);From 1933 to 1945, the respective general staffs of Germany and Switzerland took two different paths in civil-military relations in German-speaking Europe. Whereas the German general staff did not prevent or substantially ... -
Mass, salt, and heat transport across seven latitude circles in the North Atlantic Ocean: a description of the general circulation based on geostrophic calculations from international geophysical year and adjacent data
Baker, Timothy L. (Monterey, California. Naval Postgraduate School, 1978-06); NPS68-78-004This report using data from a five-year period, including the International Geophysical Year (1954-1959), presents a detailed analysis of several aspects of the physical oceanography of the North Atlantic Ocean. Assuming ... -
Flow field around a finite cone with shock
Muirhead, Vincent Uriel (Pasadena, California; California Institute of Technology, 1949);The objective of this investigation was to study the flow field in the immediate vicinity of a finite cone and to compare the results with analytical values for an infinite cone. Pressure distribution over the surface of ...