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 条
  • [31] Data mapping diagrams for data warehouse design with UML
    Luján-Mora, S
    Vassiliadis, P
    Trujillo, J
    CONCEPTUAL MODELING - ER 2004, PROCEEDINGS, 2004, 3288 : 191 - 204
  • [32] Adapting data modeling techniques for data warehouse design
    Raisinghani, MS
    JOURNAL OF COMPUTER INFORMATION SYSTEMS, 2000, 40 (03) : 73 - 77
  • [33] Spatial data in the data warehouse: A nomenclature for design and use
    Mennecke, B
    Higgins, G
    ASSOCIATION FOR INFORMATION SYSTEMS - PROCEEDINGS OF THE FIFTH AMERICAS CONFERENCE ON INFORMATION SYSTEMS (AMCIS 1999), 1999, : 274 - 276
  • [34] Data currency quality satisfaction in the design of a data warehouse
    Theodoratos, D
    Bouzeghoub, M
    INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS, 2001, 10 (03) : 299 - 326
  • [35] Automating Data Warehouse Design Using Ontology
    Aadil, Bouchra
    Wakrime, Abderrahim Ait
    Kzaz, Larbi
    Sekkaki, Abderrahim
    2016 INTERNATIONAL CONFERENCE ON ELECTRICAL AND INFORMATION TECHNOLOGIES (ICEIT), 2016, : 42 - 48
  • [36] Multidimensional normal forms for data warehouse design
    Lechtenbörger, J
    Vossen, G
    INFORMATION SYSTEMS, 2003, 28 (05) : 415 - 434
  • [37] A GOAL METHOD FOR CONCEPTUAL DATA WAREHOUSE DESIGN
    Zepeda, Leopoldo
    Zatarain, Ramon
    Celma, Matilde
    ICEIS 2008: PROCEEDINGS OF THE TENTH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL DISI: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2008, : 457 - +
  • [38] Design and Rresearch on Data Warehouse of Insurance Industry
    Zhang Jianhu
    Lei Lei
    Cui Xinyou
    Wu Yong
    Li Lintao
    FRONTIERS OF MANUFACTURING AND DESIGN SCIENCE IV, PTS 1-5, 2014, 496-500 : 2108 - +
  • [39] Research on the Design of a New Data Warehouse System
    Qiang, Song
    Liu, Lingxia
    2009 2ND IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY, VOL 4, 2009, : 462 - +
  • [40] Design and realization of data warehouse for coastal restoration
    Kuntala, Pavani
    Chu, Chee-Hung Henry
    Raghavan, Vijay V.
    2006 INTERNATIONAL CONFERENCE ON COMPUTER ENGINEERING & SYSTEMS, 2006, : 466 - +
12345