NDLI: Empirical studies to assess the understandability of data warehouse schemas using structural metrics

Content Provider	Springer Nature Link
Author	Serra, Manuel Angel Calero, Coral Sahraoui, Houari A. Piattini, Mario
Copyright Year	2007
Abstract	Data warehouses are powerful tools for making better and faster decisions in organizations where information is an asset of primary importance. Due to the complexity of data warehouses, metrics and procedures are required to continuously assure their quality. This article describes an empirical study and a replication aimed at investigating the use of structural metrics as indicators of the understandability, and by extension, the cognitive complexity of data warehouse schemas. More specifically, a four-step analysis is conducted: (1) check if individually and collectively, the considered metrics can be correlated with schema understandability using classical statistical techniques, (2) evaluate whether understandability can be predicted by case similarity using the case-based reasoning technique, (3) determine, for each level of understandability, the subsets of metrics that are important by means of a classification technique, and assess, by means of a probabilistic technique, the degree of participation of each metric in the understandability prediction. The results obtained show that although a linear model is a good approximation of the relation between structure and understandability, the associated coefficients are not significant enough. Additionally, classification analyses reveal respectively that prediction can be achieved by considering structure similarity, that extracted classification rules can be used to estimate the magnitude of understandability, and that some metrics such as the number of fact tables have more impact than others.
Starting Page	79
Ending Page	106
Page Count	28
File Format	PDF
ISSN	09639314
Journal	Software Quality Journal
Volume Number	16
Issue Number	1
e-ISSN	15731367
Language	English
Publisher	Springer US
Publisher Date	2007-07-11
Publisher Place	Boston
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Data warehouse Quality Metrics Empirical studies Operating Systems Data Structures, Cryptology and Information Theory Programming Languages, Compilers, Interpreters Software Engineering/Programming and Operating Systems
Content Type	Text
Resource Type	Article
Subject	Safety, Risk, Reliability and Quality Media Technology Software

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

A Generalized Structural Model of Structured Programs for Software Metrics Definition

Table Oriented Metrics for Relational Databases

Empirical studies on programming language stimuli

Empirical validation of object-oriented metrics for predicting fault proneness models

Quality on Time

Software quality by administration

A Critical Analysis of Current OO Design Metrics

Lean Software Development: Two Case Studies

Prediction of Run-Time Failures Using Static Product Quality Metrics

Empirical studies to assess the understandability of data warehouse schemas using structural metrics

Similar Documents

A Generalized Structural Model of Structured Programs for Software Metrics Definition

Table Oriented Metrics for Relational Databases

Empirical studies on programming language stimuli

Empirical validation of object-oriented metrics for predicting fault proneness models

Quality on Time

Software quality by administration

A Critical Analysis of Current OO Design Metrics

Lean Software Development: Two Case Studies

Prediction of Run-Time Failures Using Static Product Quality Metrics

Empirical studies to assess the understandability of data warehouse schemas using structural metrics