Advanced search
1 file | 295.11 KB Add to list

Quantifying the impact of EER modeling on relational database success : an experimental investigation

Yoram Timmerman (UGent) , Antoon Bronselaer (UGent) and Guy De Tré (UGent)
Author
Organization
Abstract
Despite the widespread idea in literature that the inclusion of EER modeling in the design process of a relational database is beneficial for the success of that database, almost no quantitative cost-benefit analyses of EER modeling exist today to support this statement. In order to fill this need, an empirical study is performed in which the success of a relational database of which the design process contains an EER modeling phase is compared to the success of a relational database in which only the minimally needed design effort was put. Hereby, database success is treated as originally proposed by the DeLone and McLean Information Systems Success Model, by specifically focusing on the information quality and system quality of both databases. To this end, respectively, the total amount of time that is needed by an end user to complete a set of tasks by using the database, and the total execution cost that is needed by the database system before a correct solution to each task is submitted, is analyzed. Moreover, the work accounts for the possible moderation of the technical competence of an end user in the relationship between EER modeling and the success of the eventual relational database. Preliminary results indicate that the inclusion of EER modeling in relational database design significantly highers the perceived information quality and system quality of that database. Moreover, there is statistical evidence that this result is independent of the competence profile of that user.
Keywords
Conceptual modeling, EER, Relational databases, SQL, Information Systems Success, INFORMATION-SYSTEMS SUCCESS

Downloads

  • (...).pdf
    • full text (Published version)
    • |
    • UGent only
    • |
    • PDF
    • |
    • 295.11 KB

Citation

Please use this url to cite or link to this publication:

MLA
Timmerman, Yoram, et al. “Quantifying the Impact of EER Modeling on Relational Database Success : An Experimental Investigation.” International Conference on Conceptual Modeling, edited by Gillian Dobbie et al., vol. 12400, Springer, 2020, pp. 487–500, doi:10.1007/978-3-030-62522-1_36.
APA
Timmerman, Y., Bronselaer, A., & De Tré, G. (2020). Quantifying the impact of EER modeling on relational database success : an experimental investigation. In G. Dobbie, U. Frank, G. Kappel, S. W. Liddle, & H. C. Mayr (Eds.), International Conference on Conceptual Modeling (Vol. 12400, pp. 487–500). Cham, Switzerland: Springer. https://doi.org/10.1007/978-3-030-62522-1_36
Chicago author-date
Timmerman, Yoram, Antoon Bronselaer, and Guy De Tré. 2020. “Quantifying the Impact of EER Modeling on Relational Database Success : An Experimental Investigation.” In International Conference on Conceptual Modeling, edited by Gillian Dobbie, Ulrich Frank, Gerti Kappel, Stephen W. Liddle, and Heinrich C. Mayr, 12400:487–500. Cham, Switzerland: Springer. https://doi.org/10.1007/978-3-030-62522-1_36.
Chicago author-date (all authors)
Timmerman, Yoram, Antoon Bronselaer, and Guy De Tré. 2020. “Quantifying the Impact of EER Modeling on Relational Database Success : An Experimental Investigation.” In International Conference on Conceptual Modeling, ed by. Gillian Dobbie, Ulrich Frank, Gerti Kappel, Stephen W. Liddle, and Heinrich C. Mayr, 12400:487–500. Cham, Switzerland: Springer. doi:10.1007/978-3-030-62522-1_36.
Vancouver
1.
Timmerman Y, Bronselaer A, De Tré G. Quantifying the impact of EER modeling on relational database success : an experimental investigation. In: Dobbie G, Frank U, Kappel G, Liddle SW, Mayr HC, editors. International Conference on Conceptual Modeling. Cham, Switzerland: Springer; 2020. p. 487–500.
IEEE
[1]
Y. Timmerman, A. Bronselaer, and G. De Tré, “Quantifying the impact of EER modeling on relational database success : an experimental investigation,” in International Conference on Conceptual Modeling, Vienna, Austria, 2020, vol. 12400, pp. 487–500.
@inproceedings{8681411,
  abstract     = {Despite the widespread idea in literature that the inclusion of EER modeling in the design process of a relational database is beneficial for the success of that database, almost no quantitative cost-benefit analyses of EER modeling exist today to support this statement. In order to fill this need, an empirical study is performed in which the success of a relational database of which the design process contains an EER modeling phase is compared to the success of a relational database in which only the minimally needed design effort was put. Hereby, database success is treated as originally proposed by the DeLone and McLean Information Systems Success Model, by specifically focusing on the information quality and system quality of both databases. To this end, respectively, the total amount of time that is needed by an end user to complete a set of tasks by using the database, and the total execution cost that is needed by the database system before a correct solution to each task is submitted, is analyzed. Moreover, the work accounts for the possible moderation of the technical competence of an end user in the relationship between EER modeling and the success of the eventual relational database. Preliminary results indicate that the inclusion of EER modeling in relational database design significantly highers the perceived information quality and system quality of that database. Moreover, there is statistical evidence that this result is independent of the competence profile of that user.},
  author       = {Timmerman, Yoram and Bronselaer, Antoon and De Tré, Guy},
  booktitle    = {International Conference on Conceptual Modeling},
  editor       = {Dobbie, Gillian and Frank, Ulrich and Kappel, Gerti and Liddle, Stephen W. and Mayr, Heinrich C.},
  isbn         = {9783030625214},
  issn         = {0302-9743},
  keywords     = {Conceptual modeling,EER,Relational databases,SQL,Information Systems Success,INFORMATION-SYSTEMS SUCCESS},
  language     = {eng},
  location     = {Vienna, Austria},
  pages        = {487--500},
  publisher    = {Springer},
  title        = {Quantifying the impact of EER modeling on relational database success : an experimental investigation},
  url          = {http://dx.doi.org/10.1007/978-3-030-62522-1_36},
  volume       = {12400},
  year         = {2020},
}

Altmetric
View in Altmetric
Web of Science
Times cited: