Data Warehouse Modeler: a CASE tool for warehouse design

Author

Miller, Les ; Nilakanta, Sree

Author_Institution

Dept. of Comput. Sci., Iowa State Univ., Ames, IA, USA

Volume

6

fYear

1998

fDate

6-9 Jan 1998

Firstpage

42

Abstract

Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of operational relational databases. The warehouse designer simply specifies a list of attribute names that are to appear in the warehouse, conditions if any are desired, and a description of the operational databases. The tool returns the queries needed to populate the warehouse table

Keywords

SQL; computer aided software engineering; query processing; relational databases; software tools; very large databases; CASE tool; Data Warehouse Modeler; SQL query generation; attribute names; conditions; data warehouse design; operational relational databases; systems development; warehouse table; Computer aided software engineering; Data models; Data warehouses; IEEE news; Information retrieval; Law; Legal factors; Process design; Relational databases; User interfaces;

fLanguage

English

Publisher

ieee

Conference_Titel

System Sciences, 1998., Proceedings of the Thirty-First Hawaii International Conference on

Conference_Location

Kohala Coast, HI

Print_ISBN

0-8186-8255-8

Type

conf

DOI

10.1109/HICSS.1998.654756

Filename

654756