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
关键词
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 条
  • [21] A Methodology for the Design of a Fuzzy Data Warehouse
    Sapir, Lior
    Shmilovici, Armin
    Rokach, Lior
    2008 4TH INTERNATIONAL IEEE CONFERENCE INTELLIGENT SYSTEMS, VOLS 1 AND 2, 2008, : 60 - 67
  • [22] Design and implementation of a climatic data warehouse
    Velázquez-Alvarez, J
    Torres-Jiménez, J
    DATA MINING III, 2002, 6 : 407 - 416
  • [24] The data warehouse
    Donaldson, WR
    AM/FM INTERNATIONAL CONFERENCE XX, PROCEEDINGS - ENTERING THE MAINSTREAM, 1997, : 21 - 29
  • [25] Working Warehouse: Setting the table for a data warehouse
    Simon, A.
    Database Programming & Design, 11 (03):
  • [26] Warehouse design for marine products storing warehouse
    Hwang, Heung Suk
    Bae, Suk-Tae
    Cho, Gyu-Sung
    PROCEEDING OF THE SEVENTH INTERNATIONAL CONFERENCE ON INFORMATION AND MANAGEMENT SCIENCES, 2008, 7 : 741 - 741
  • [27] Data Warehouse
    Peter Gluchowski
    Informatik-Spektrum, 1997, 20 (1) : 48 - 49
  • [28] From Traditional Data Warehouse To Real Time Data Warehouse
    Bouaziz, Senda
    Nabli, Ahlem
    Gargouri, Faiez
    INTELLIGENT SYSTEMS DESIGN AND APPLICATIONS (ISDA 2016), 2017, 557 : 467 - 477
  • [29] Tool for aiding warehouse design process: development and validation
    Chackelson, Claudia
    Santos, Javier
    Errasti, Ander
    MEMORIA INVESTIGACIONES EN INGENIERIA, 2013, (11): : 15 - 27
  • [30] Application of Data Warehouse Technology in Data Center Design
    Hu Xuanzi
    Wang Kuanfu
    2008 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND SECURITY, VOLS 1 AND 2, PROCEEDINGS, 2008, : 484 - +