By Topic

A data warehouse for policy making: a case study

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
J. F. F. Weilbach ; Dept. of Inf., Pretoria Univ., South Africa ; H. L. Viktor

Traditionally, decision support systems are used to obtain information from a limited amount of data to support the decision making process. However, such decision support systems have difficulty dealing with complex, multiple data sources that are typically found in large organizations. Data warehousing is a new technology that structure data to simplify the phases of the decision support process. This paper discusses experience gained while building and implementing a data warehouse concerning an audit by a South African government institution to obtain knowledge about science and technology resources available nationally. The data warehouse was created by using the data contained in five operational relational databases. The use of the soft systems methodology during the data warehouse development life cycle ensured continued stateholder participation. The results obtained indicate that a data warehouse implementation simplifies information generation when compared to the data reporting features of an operational database system. Also, the data warehouse produced an integrated, historic source of information about the subjects included therein. In addition, the data pre-processing methods employed eliminated most data anomalies and inconsistencies.

Published in:

Systems Sciences, 1999. HICSS-32. Proceedings of the 32nd Annual Hawaii International Conference on  (Volume:Track7 )

Date of Conference:

5-8 Jan. 1999