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 条
  • [41] A logical model for data warehouse design and evolution
    Bouzeghoub, M
    Kedad, Z
    DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2000, 1874 : 178 - 188
  • [42] Data warehouse design for sales performance analysis
    Nasir, J.A.
    Shahzad, M.K.
    Pasha, M.A.
    Information Technology Journal, 2006, 5 (05) : 964 - 969
  • [43] An Automatic Tool for Anchor Model Data Warehouse Development
    Simanjuntak, Humasak
    Tambunan, Marcella
    Manullang, Kamaruddin
    Panjaitan, Hanna
    INTERNETWORKING INDONESIA, 2016, 8 (02): : 33 - 38
  • [44] The ESA Data Warehouse: A tool for effective management reporting
    Bourguignon, Y.-M.
    Chevrier, M.
    Douzal, M.
    Gendreau, G.
    European Space Agency Bulletin, 2001, (108): : 83 - 88
  • [45] Design of Warehouse Contol System For Automated Warehouse Environment
    Son, Dong Woo
    Chang, Yoon Seok
    Kim, Nam Uook
    Kim, Woo Ram
    PROCEEDINGS 2016 5TH IIAI INTERNATIONAL CONGRESS ON ADVANCED APPLIED INFORMATICS IIAI-AAI 2016, 2016, : 980 - 984
  • [46] The Design and Implementation of Agricultural Production Data Warehouse
    Zhou Lijuan
    He Xiaoxu
    Li Kang
    ADVANCES IN MECHANICAL ENGINEERING, PTS 1-3, 2011, 52-54 : 978 - 983
  • [47] Design of Marine Data Warehouse ETL System
    Wen WeiJun
    MECHANICAL COMPONENTS AND CONTROL ENGINEERING III, 2014, 668-669 : 1374 - 1377
  • [48] Data Warehouse Design For Earth Observation Satellites
    Liu, Shenggang
    Han, Chao
    Wang, Shaokai
    Luo, Qinqin
    2012 INTERNATIONAL WORKSHOP ON INFORMATION AND ELECTRONICS ENGINEERING, 2012, 29 : 3876 - 3882
  • [49] A design and practical use of spatial data warehouse
    Park, JM
    Hwang, CS
    IGARSS 2005: IEEE INTERNATIONAL GEOSCIENCE AND REMOTE SENSING SYMPOSIUM, VOLS 1-8, PROCEEDINGS, 2005, : 726 - 729
  • [50] Dynamic Evolution and Improvement of Data Warehouse Design
    Sahpaski, Dragan
    Velinov, Goran
    Jakimovski, Boro
    Kon-Popovska, Margita
    PROCEEDINGS OF THE 2009 FOURTH BALKAN CONFERENCE IN INFORMATICS, 2009, : 107 - 112
12345