SpringerLink
Log in

Choosing a Data Model for a Data Warehouse from a Non-experienced End-User Perspective

  • Conference paper
  • First Online:
Good Practices and New Perspectives in Information Systems and Technologies (WorldCIST 2024)

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 987))

Included in the following conference series:

  • 69 Accesses

Abstract

A critical decision that will determine if the implementation of a data warehouse is a success or a failure is selecting the data modelling approach. This research was done in the Design Science Research (DSR) Paradigm. As part of the first phase (awareness of the problem), questionnaires were completed by 112 respondents at companies in South Africa. The results of these showed that data models and the use thereof still present problems in many of these companies in South Africa. The aim of this paper is to assist an end user or company to choose a suitable data model. The Data Modelling Selection Framework (DMSF) is introduced in this paper. This framework considers: business information needs, data parameters, enterprise size, business processes, current data architecture and environment, as well as data strategy. The DMSF includes 15 guidelines that can be followed by an end-user or a company when having to decide which data model will be suitable for a data warehouse.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
EUR 29.95
Price includes VAT (Thailand)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
EUR 154.07
Price includes VAT (Thailand)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
EUR 199.99
Price excludes VAT (Thailand)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free ship** worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Makele, P., Doss, S.: A survey on data warehouse approaches for higher education institution. Int. J. Innov. Res. Appl. Sci. Eng. 1, 223–227 (2018). https://doi.org/10.29027/IJIRASE.v1.i11.2018.223-227

    Article  Google Scholar 

  2. Shahid, M.B., et al.: Application of data warehouse in real life: state-of-the-art survey from user preferences’ perspective. Int. J. Adv. Comput. Sci. Appl. 7, 415–426 (2016). https://doi.org/10.14569/IJACSA.2016.070455

    Article  Google Scholar 

  3. Imhoff, C., Galemmo, N., Geiger, J.G.: Mastering Data Warehouse Design - Relational and Dimensional Techniques. Indiana Wiley Publishing Inc., Indianapolis (2003)

    Google Scholar 

  4. Joseph, M.V.: Significance of data warehousing and data mining in business applications. Int. J. Soft Comput. Eng. 3, 329–333 (2013). https://www.ijsce.org/wp-content/uploads/papers/v3i1/A1391033113.pdf

  5. Olszak, C.M.: Dynamic Business Intelligence and Analytical Capabilities in Organizations (2014)

    Google Scholar 

  6. Azeroual, O., Theel, H.: The effects of using business intelligence systems on an excellence management and decision-making process by start-up companies: a case study. Int. J. Manag. Sci. Bus. Administ. 4, 30–40 (2018). https://arxiv.org/ftp/arxiv/papers/1901/1901.10555.pdf

  7. Guerra, J., Andrews, D.: Why You Need a Data Warehouse. http://magnitude.com/wp-content/uploads/2014/01/2013-03-Why-You-Need-a-Data-Warehouse.pdf

  8. Mullins, C.S.: Big Data Guidance for Relational DBAs (2016). www.dbta.com/Columns/DBA-Corner/Big-Data-Guidance-for-Relational-DBAs-113356.aspx

  9. Blaha, M.: Data Models Have Many Benefits. Here Are 10 of Them (2014). https://www.dataversity.net/data-models-many-benefits-10/

  10. Korada, M.: Why Organizations Can't Afford Not to Have a Data Model (2012). https://www.ibmbigdatahub.com/blog/why-organizations-can-t-afford-not-have-data-model

  11. Inmon, W.H., Linstedt, D.: Data Architecture: A Primer for the Data Scientist. Elsevier Inc., Waltham (2015)

    Google Scholar 

  12. Vaishnavi, V.K., Kuechler, W.L.: Design Science Research Methods and Patterns. Auerbach Publications, Boca Raton (2007)

    Book  Google Scholar 

  13. Bichler, M.: Design science in information systems research. Wirtschaftsinformatik 48(2), 133–135 (2006). https://doi.org/10.1007/s11576-006-0028-8

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. North-West University, Potchefstroom, South Africa

    L. Botha & E. Taylor

Authors
  1. L. Botha
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. E. Taylor
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to E. Taylor .

Editor information

Editors and Affiliations

  1. ISEG, Universidade de Lisboa, Lisbon, Portugal

    Álvaro Rocha

  2. College of Engineering, The Ohio State University, Columbus, OH, USA

    Hojjat Adeli

  3. Institute of Data Science and Digital Technologies, Vilnius University, Vilnius, Lithuania

    Gintautas Dzemyda

  4. DCT, Universidade Portucalense, Porto, Portugal

    Fernando Moreira

  5. Institute of Information Technology, Lodz University of Technology, Łódz, Poland

    Aneta Poniszewska-Marańda

Rights and permissions

Reprints and permissions

Copyright information

© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Botha, L., Taylor, E. (2024). Choosing a Data Model for a Data Warehouse from a Non-experienced End-User Perspective. In: Rocha, Á., Adeli, H., Dzemyda, G., Moreira, F., Poniszewska-Marańda, A. (eds) Good Practices and New Perspectives in Information Systems and Technologies. WorldCIST 2024. Lecture Notes in Networks and Systems, vol 987. Springer, Cham. https://doi.org/10.1007/978-3-031-60221-4_26

Download citation

Publish with us

Policies and ethics

Search

Navigation