Data Warehouse Modeler: a CASE tool for warehouse design

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.

[1]  Jennifer Widom,et al.  A System Prototype for Warehouse View Maintenance , 1996, VIEWS.

[2]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[3]  Rob Mattison.  Data warehousing - strategies, technologies, and techniques , 1996 .

[4]  Nick Roussopoulos,et al.  Efficient refreshment of data warehouse views , 1996 .

[5]  Ronald Fagin,et al.  A simplied universal relation assumption and its properties , 1982, TODS.

[6]  Ronald Fagin,et al.  Degrees of acyclicity for hypergraphs and relational database schemes , 1983, JACM.

[7]  David Maier,et al.  Maximal objects and the semantics of universal relation databases , 1983, TODS.

[8]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[9]  Leslie L. Miller,et al.  Testing arbitrary subhypergraphs for the lossless join property , 1990, Inf. Sci..

[10]  Leslie L. Miller,et al.  Query Translation Based on Hypergraph Models , 1988, Comput. J..

[11]  Jennifer Widom,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..

[12]  Marc Gyssens,et al.  A Decomposition Methodology for Cyclic Databases , 1982, Advances in Data Base Theory.

[13]  Jennifer Widom,et al.  Making views self-maintainable for data warehousing , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[14]  Leslie Miller,et al.  An extensible view system for multidatabase integration and interoperation , 1995 .