skip to main content
10.1145/1097002.1097011acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
Article

Goal-oriented requirement analysis for data warehouse design

Published: 04 November 2005 Publication History

Abstract

Several surveys indicate that a significant percentage of data warehouses fail to meet business objectives or are outright failures. One of the reasons for this is that requirement analysis is typically overlooked in real projects. In this paper we propose a goal-oriented approach to requirement analysis for data warehouses, based on the Tropos methodology. Two different perspectives are integrated for requirement analysis: organizational modeling, centered on stakeholders, and decisional modeling, focused on decision makers. Our approach can be employed within both a demand-driven and a mixed supply/demand-driven design framework: in the second case, while the operational sources are still explored to shape hierarchies, user requirements play a fundamental role in restricting the area of interest for analysis and in choosing facts, dimensions, and measures. The methodology proposed, supported by a prototype, is described with reference to a real case study.

References

[1]
A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta, and S. Paraboschi. Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol., 10(4):452--483, 2001.
[2]
P. Bresciani, P. Giorgini, F. Giunchiglia, J. Mylopoulos, and A. Perini. Tropos: An agent-oriented software development methodology. Journal of Autonomous Agents and Multi-Agent Systems, 8(3):203--236, 2004.
[3]
R. Bruckner, B. List, and J. Schiefer. Developing requirements for data warehouse systems with use cases. In Proc. 7th Americas Conf. on Information Systems, pages 329--335, 2001.
[4]
D. Bulos. Designing OLAP with ADAPT. Technical report, Atos Origin, 1999.
[5]
J. Castro, M. Kolp, and J. Mylopoulos. Towards requirements-driven information systems engineering: The Tropos project. Information Systems, 27(6):365--389, 2002.
[6]
A. Dardenne, A. van Lamsweerde, and S. Fickas. Goal-directed requirements acquisition. Science of Computer Programming, 20(1--2):3--50, 1993.
[7]
P. Giorgini, E. Nicchiarelli, J. Mylopoulos, and R.Sebastiani. Formal reasoning techniques for goal models. Journal of Data Semantics, 1, 2003. Springer.
[8]
M. Golfarelli, D. Maio, and S. Rizzi. The dimensional fact model: A conceptual model for data warehouses. Intl' Journal of Cooperative Information Systems, 7(2-3):215--247, 1998.
[9]
M. Golfarelli and S. Rizzi. A methodological framework for data warehouse design. In Proc. DOLAP, pages 3--9, 1998.
[10]
M. Golfarelli, S. Rizzi, and E. Saltarelli. WAND: A CASE tool for workload-based design of a data mart. In Proc. SEBD, pages 422--426, Portoferraio, Italy, 2002.
[11]
B. Hüsemann, J. Lechtenbörger, and G. Vossen. Conceptual data warehouse design. In Proc. 2nd DMDW, pages 3--9, Stockholm, Sweden, 2000.
[12]
W. H. Inmon. Building the Data Warehouse. QED Press/John Wiley, 1992.
[13]
R. Kimball, L. Reeves, M. Ross, and W. Thornthwaite. The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, 1998.
[14]
J. Lechtenbörger. Data warehouse schema design. Technical Report 79, DISDBIS Akademische Verlagsgesellschaft Aka GmbH, 2001.
[15]
B. List, R. Bruckner, K. Machaczek, and J. Schiefer. A comparison of data warehouse development methodologies: Case study of the process warehouse. In Proc. DEXA, pages 203--215, 2002.
[16]
S. Luján-Mora and J. Trujillo. A comprehensive method for data warehouse design. In Proc. DMDW, 2003.
[17]
S. Luján-Mora, J. Trujillo, and I. Y. Song. The Gold Model Case Tool: An environment for designing OLAP applications. In Proc. ICEIS, pages 699--707, 2002.
[18]
J-N. Mazon, J. Trujillo, M. Serrano, and M. Piattini. Designing data warehouses: From business requirement analysis to multidimensional modeling. In Proc. 1st Int. Workshop on Requirements Engineering for Business Need and IT Alignment, Paris, France, 2005.
[19]
D. Moody and M. Kortink. From enterprise models to dimensional models: A methodology for data warehouse and data mart design. In Proc. 2nd DMDW, Stockholm, Sweden, 2000.
[20]
F. R. S. Paim and J. B. Castro. DWARF: An approach for requirements definition and management of data warehouse systems. In Proc. Int. Conf. on Requirements Engineering, Monterey Bay, CA, 2003.
[21]
N. Prakash and A. Gosain. Requirements driven data warehouse development. In CAiSE Short Paper Proc., 2003.
[22]
R. Sebastiani, P. Giorgini, and J. Mylopoulos. Simple and minimum-cost satisfiability for goal models. In Proc. CAiSE'04, pages 20--33, 2004.
[23]
R. Winter and B. Strauch. A method for demand-driven information requirements analysis in data warehousing projects. In Proc. HICSS, pages 1359--1365, Hawaii, 2003.
[24]
E. Yu. Modelling Strategic Relationships for Process Reengineering. PhD thesis, University of Toronto, Department of Computer Science, 1995.

Cited By

View all

Index Terms

  1. Goal-oriented requirement analysis for data warehouse design

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    DOLAP '05: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
    November 2005
    122 pages
    ISBN:1595931627
    DOI:10.1145/1097002
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 04 November 2005

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. data warehouse design
    2. requirement analysis

    Qualifiers

    • Article

    Conference

    CIKM05
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 29 of 79 submissions, 37%

    Upcoming Conference

    CIKM '25

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)52
    • Downloads (Last 6 weeks)2
    Reflects downloads up to 04 Jan 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2024)Data Analytics from a Social PerspectiveSocial Modeling Using the i* Framework10.1007/978-3-031-72107-6_10(149-162)Online publication date: 1-Dec-2024
    • (2022)Data AnalyticsNew Approaches to Data Analytics and Internet of Things Through Digital Twin10.4018/978-1-6684-5722-1.ch001(1-27)Online publication date: 30-Sep-2022
    • (2022)Leveraging Software Quality Attributes in NoSQL Database Systems2022 5th International Conference on Information and Computer Technologies (ICICT)10.1109/ICICT55905.2022.00048(240-246)Online publication date: Mar-2022
    • (2022)Improve Quality of Data Management and Maintenance in Data Warehouse SystemsProceedings of the 6th International Conference on Advance Computing and Intelligent Engineering10.1007/978-981-19-2225-1_60(691-700)Online publication date: 22-Sep-2022
    • (2022)A Process Warehouse for Process Variants AnalysisBig Data Analytics and Knowledge Discovery10.1007/978-3-031-12670-3_8(87-93)Online publication date: 26-Jul-2022
    • (2022)Automatic Machine Learning-Based OLAP Measure Detection for Tabular DataBig Data Analytics and Knowledge Discovery10.1007/978-3-031-12670-3_15(173-188)Online publication date: 26-Jul-2022
    • (2021)30 Years Business Intelligence: FromData Analytics to Big DataEURO Working Group on DSS10.1007/978-3-030-70377-6_7(115-128)Online publication date: 10-Aug-2021
    • (2020)Research on Friendvertising-Counter Technology in Big DataMachine Learning for Cyber Security10.1007/978-3-030-62460-6_25(283-289)Online publication date: 11-Nov-2020
    • (2019)Data Warehouse Support for Policy Enforcement Rule FormulationNew Perspectives on Information Systems Modeling and Design10.4018/978-1-5225-7271-8.ch011(255-273)Online publication date: 2019
    • (2019)One-Pot Synthesis of Requirements Elicitation for Operational BI (OBI) System: in the Context of the Modern Business EnvironmentJournal of Information Systems Engineering and Business Intelligence10.20473/jisebi.5.2.131-1455:2(131)Online publication date: 24-Oct-2019
    • Show More Cited By

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media