Data Warehouse Query Construction and Situation Presentation

Abstract

Data warehouse (DW) queries represent the information need of a manager in the CDDP model. DW queries are constructed based on the mapping relationships between the manager’s SA, the experience base, the ontology and the data warehouse. Once DW queries are constructed, situation information can be retrieved from the data warehouse through executing the queries. The retrieved situation information is presented to the manager for SA development. Part of the work presented in this chapter has been reported in one of our publications (Niu et al. 2008). Section 8.1 introduces the basic grammar of DW query languages. Section 8.2 outlines the process of query construction. The detailed processes of query construction are discussed in Sections 8.3 and 8.4. The method of presenting situation information is discussed in Sections 8.6 and 8.7.