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
相关论文
共 50 条
  • [1] ''Design warehouse'': a ''data warehouse'' for computer aided design
    Laureri, P
    Moke, GM
    PROCEEDINGS OF THE THIRD BASQUE INTERNATIONAL WORKSHOP ON INFORMATION TECHNOLOGY - DATA MANAGEMENT SYSTEMS (BIWIT'97), 1997, : 197 - 205
  • [2] Building data warehouse: Design and case analysis
    Dipartimento di Informatica, Università di Bari, via Orabona 4, 70125 Bari, Italy
    WSEAS Trans. Inf. Sci. Appl., 2006, 3 (510-517):
  • [3] Data warehouse architecture and design
    Rifaie, Mohammad
    Kianmehr, Keivan
    Alhajj, Reda
    Ridleya, Mick J.
    PROCEEDINGS OF THE 2008 IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION, 2008, : 58 - +
  • [4] Volunteer Design of Data Warehouse
    Bimonte, Sandro
    ADVANCED INFORMATION SYSTEMS ENGINEERING, CAISE 2020, 2020, 12127 : 561 - 562
  • [5] Incremental design of a data warehouse
    Theodoratos, D
    Sellis, T
    JOURNAL OF INTELLIGENT INFORMATION SYSTEMS, 2000, 15 (01) : 7 - 27
  • [6] Towards data warehouse design
    Ravat, F
    Teste, O
    Zurfluh, G
    PROCEEDINGS OF THE EIGHTH INTERNATIONAL CONFERENCE ON INFORMATION KNOWLEDGE MANAGEMENT, CIKM'99, 1999, : 359 - 366
  • [7] Data warehouse design solutions
    Wiley, DL
    ONLINE, 1999, 23 (04): : 85 - 86
  • [8] Incremental Design of a Data Warehouse
    Dimitri Theodoratos
    Timos Sellis
    Journal of Intelligent Information Systems, 2000, 15 : 7 - 27
  • [9] The case for building a data warehouse
    Furlow, G.
    2001, Institute of Electrical and Electronics Engineers Computer Society (03)
  • [10] Past Indeterminacy in Data Warehouse Design
    Khnaisser, Christina
    Lavoie, Luc
    Burgun, Anita
    Ethier, Jean-Francois
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, DEXA 2017, PT II, 2017, 10439 : 90 - 100
12345