Physical Sciences and Mathematics Commons^™

Materialized View Algorithms, Yubo Fan

Dissertations and Theses

A data warehouse is a stand-alone repository of integrated information available for decision support OLAP querying and analysis. Aggregate views can be materialized (stored in disk) to improve query performance in a data warehouse.

Several static and dynamic algorithms for selecting materialized aggregate views (MA V) in a data warehouse are proposed in this thesis. The algorithms are then compared by running a simulation system, which can be configured to compare several algorithms on different type of data warehouses. Simulation results for static algorithms are presented to show that several proposed algorithms perform close to an existing good algorithm (HRU …

Development And Implementation Of An Isentropic Potential Vorticity Algorithm For Use At Air Force Global Weather Center, Jay B. Desjardins Jr.

Theses and Dissertations

This thesis presents and validates methods for calculating isentropic potential vorticity (IPV) and applies these methods in software programs planned for implementation at the Air Force Global Weather Center (AFGWC). The IPV programs will provide Air Force Weather forecasters additional tools to diagnose atmospheric kinematics and understand atmospheric dynamics. A FORTRAN program is recommended using mandatory-level isobaric data projected to be available on AFGWC computer systems, specifically, from the Navy Operational Global Atmosphere Prediction System and Medium Range Forecast models. Program development and analysis consists of three main steps: (1) data retrieval; (2) IPV calculations; and, (3) interpolation to an …