A performance analysis of view materialization strategies for general expressions
Barefield, Curtis G., Jr.
Kamel, Magdi N.
MetadataShow full item record
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.
Approved for public release; distribution is unlimited
Showing items related by title, author, creator and subject.
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 ...
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 ...
Rowe, Neil C. (Monterey, California. Naval Postgraduate School, 2012-08);The National Software Reference Library (NSRL) is an essential data source for forensic investigators, providing in its Reference Data Set (RDS) a set of hash values of known software. However, the NSRL RDS has not ...