Data warehouse modeler: A CASE tool for warehouse design

被引:0
作者
Miller, L [1 ]
Nilakanta, S [1 ]
机构
[1] Iowa State Univ, Dept Comp Sci, Coll Liberal Arts & Sci, Ames, IA 50011 USA
来源
PROCEEDINGS OF THE THIRTY-FIRST HAWAII INTERNATIONAL CONFERENCE ON SYSTEM SCIENCES, VOL VI: ORGANIZATIONAL SYSTEMS AND TECHNOLOGY TRACK | 1998年
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Darn 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 fi om a set of operational relational databases. The warehouse designer simply specifies a list of attribute names that will 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.
引用
收藏
页码:42 / 48
页数:7
相关论文
empty
未找到相关数据