Systems Dynamics-Based Modeling of Data Warehouse Quality

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

Data warehouses (DW) are a key component of business intelligence and decision-making. In this paper, we present an approach that combines Grounded Theory and System Dynamics to develop causal loop diagrams/models for data warehouse quality and processes. We used the top 51 data warehousing academic papers to arrive at concepts and critical success factors. A simple data warehouse quality causal model and a Data Warehouse Project Initialization Loop Analysis, Data Source Availability & Monitoring Loop Analysis and Data Model Quality and DBMS Quality Analysis models were developed. Visualization of the cause-effect loops and how data warehouse variables are interrelated provide a clear understanding of DW process. Key findings include data quality and data model quality that are more important than DBMS quality for ensuring data warehouse quality, and the number of data entry errors and the level of data complexity can be major detriments to DW quality.

Original languageEnglish (US)
Pages (from-to)384-391
Number of pages8
JournalJournal of Computer Information Systems
Volume59
Issue number4
DOIs
StatePublished - Jul 4 2019

Fingerprint

Data warehouses
data quality
Dynamical systems
Data structures
warehousing
Competitive intelligence
model analysis
grounded theory
visualization
Data acquisition
data analysis
Visualization
Decision making
Availability
monitoring
decision making
cause
Monitoring

All Science Journal Classification (ASJC) codes

  • Information Systems
  • Education
  • Computer Networks and Communications

Cite this

@article{1cc7a4bf0e094ea79289337293cabcae,
title = "Systems Dynamics-Based Modeling of Data Warehouse Quality",
abstract = "Data warehouses (DW) are a key component of business intelligence and decision-making. In this paper, we present an approach that combines Grounded Theory and System Dynamics to develop causal loop diagrams/models for data warehouse quality and processes. We used the top 51 data warehousing academic papers to arrive at concepts and critical success factors. A simple data warehouse quality causal model and a Data Warehouse Project Initialization Loop Analysis, Data Source Availability & Monitoring Loop Analysis and Data Model Quality and DBMS Quality Analysis models were developed. Visualization of the cause-effect loops and how data warehouse variables are interrelated provide a clear understanding of DW process. Key findings include data quality and data model quality that are more important than DBMS quality for ensuring data warehouse quality, and the number of data entry errors and the level of data complexity can be major detriments to DW quality.",
author = "Girish Subramanian and Kai Wang",
year = "2019",
month = "7",
day = "4",
doi = "10.1080/08874417.2017.1383863",
language = "English (US)",
volume = "59",
pages = "384--391",
journal = "Journal of Computer Information Systems",
issn = "0887-4417",
publisher = "International Association for Computer Information Systems",
number = "4",

}

Systems Dynamics-Based Modeling of Data Warehouse Quality. / Subramanian, Girish; Wang, Kai.

In: Journal of Computer Information Systems, Vol. 59, No. 4, 04.07.2019, p. 384-391.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Systems Dynamics-Based Modeling of Data Warehouse Quality

AU - Subramanian, Girish

AU - Wang, Kai

PY - 2019/7/4

Y1 - 2019/7/4

N2 - Data warehouses (DW) are a key component of business intelligence and decision-making. In this paper, we present an approach that combines Grounded Theory and System Dynamics to develop causal loop diagrams/models for data warehouse quality and processes. We used the top 51 data warehousing academic papers to arrive at concepts and critical success factors. A simple data warehouse quality causal model and a Data Warehouse Project Initialization Loop Analysis, Data Source Availability & Monitoring Loop Analysis and Data Model Quality and DBMS Quality Analysis models were developed. Visualization of the cause-effect loops and how data warehouse variables are interrelated provide a clear understanding of DW process. Key findings include data quality and data model quality that are more important than DBMS quality for ensuring data warehouse quality, and the number of data entry errors and the level of data complexity can be major detriments to DW quality.

AB - Data warehouses (DW) are a key component of business intelligence and decision-making. In this paper, we present an approach that combines Grounded Theory and System Dynamics to develop causal loop diagrams/models for data warehouse quality and processes. We used the top 51 data warehousing academic papers to arrive at concepts and critical success factors. A simple data warehouse quality causal model and a Data Warehouse Project Initialization Loop Analysis, Data Source Availability & Monitoring Loop Analysis and Data Model Quality and DBMS Quality Analysis models were developed. Visualization of the cause-effect loops and how data warehouse variables are interrelated provide a clear understanding of DW process. Key findings include data quality and data model quality that are more important than DBMS quality for ensuring data warehouse quality, and the number of data entry errors and the level of data complexity can be major detriments to DW quality.

UR - http://www.scopus.com/inward/record.url?scp=85041633246&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85041633246&partnerID=8YFLogxK

U2 - 10.1080/08874417.2017.1383863

DO - 10.1080/08874417.2017.1383863

M3 - Article

AN - SCOPUS:85041633246

VL - 59

SP - 384

EP - 391

JO - Journal of Computer Information Systems

JF - Journal of Computer Information Systems

SN - 0887-4417

IS - 4

ER -