Title :
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
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;
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
DOI :
10.1109/HICSS.1998.654756
