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.
South, Jesse T. (Monterey, California. Naval Postgraduate School, 1991-09);In conventional relational database systems, a view is a virtual relation whose definition is stored in the systems catalog. When a query is issued on the view, the system retrieves the view from the catalog and modified ...
Stevens, Clark D.; Robbins, Bruce; Huynh, Chan; Doan, Dzung; Kohler, Todd; Neushul, James D. (Monterey, California: Naval Postgraduate School., 2003);OneSAF Objective System (OOS) is the army’s next generation model for brigade and below training, research, development and acquisition and for analysis and has been selected as the embedded training driver for Future Combat ...
Integration of Computer-Aided Acquisition & Logistic Support (CALS) components into the ROK Army information infrastructure Jo Sang (Monterey, California. Naval Postgraduate School, 1995-06);The goal of the CALS initiative is to enable integration of enterprises on a worldwide basis. The vision is for all or parts of a single enterprise, or for example, an original equipment manufacturer and its suppliers, or ...