365
Views
2
CrossRef citations to date
0
Altmetric
Articles

Are models easier to understand than code? An empirical study on comprehension of entity-relationship (ER) models vs. structured query language (SQL) code

, , &
Pages 343-362 | Received 06 May 2011, Accepted 27 Sep 2011, Published online: 29 Nov 2011

References

  • Batra , D. and Antony , S. R. 1994 . Effects of data model and task characteristics on designer performance: A laboratory study . International Journal of Human-Computer Studies , 41 : 481 – 508 .
  • Batra , D. , Hoffer , J. A. and Bostrom , R. P. 1990 . Comparing representations with relational and EER models . Communications of the ACM , 33 : 126 – 139 .
  • Carver , J. , Jaccheri , M. L. , Morasca , S. and Shull , F. 2003 . “ Using empirical studies during software courses ” . In Empirical methods and studies in software engineering, experiences from ESERNET Edited by: Conradi , R. and Wang , A. I. 81 – 103 .
  • Chan , H. and Wei , K. 1993 . User-database interface: The effect of abstraction levels on query performance . MIS Quarterly , 17 : 441 – 464 .
  • Chan , H. C. , Siau , K. and Wei , K. K. 1997 . The effect of data model, system and task characteristics on user query performance: An empirical study . SIGMIS Database , 29 : 31 – 49 .
  • Chan , H. C. , Teo , H. H. and Zeng , X. 2005 . An evaluation of novice end-user computing performance: Data modeling, query writing and comprehension . Journal of the American Society for Information Science and Technology (JASIST) , 56 : 843 – 853 .
  • Chan , H. C. , Wei , K. K. and Siau , K. 1994 . An empirical study on end-users' update performance for different abstraction levels . International Journal of Human-Computer Studies , 41 : 309 – 328 .
  • Chen , P. P. 1976 . The entity-relationship model – toward a unified view of data . ACM Transactions on Database Systems , 1 ( 1 ) : 9 – 36 .
  • Elsmari , R. and Navathe , S. 2010 . Fundamentals of database systems , Boston, MA : Pearson Education .
  • Gennick , J. 2010 . SQL Pocket Guide , Sebastopol, CA : O'Reilly .
  • Hanenberg , S. An experiment about static and dynamic type systems: Doubts about the positive impact of static type systems on development time . Proceedings of the 25th annual conference on Object-Oriented Programming, Systems, Languages and Applications (OOPSLA) . pp. 22 – 35 . New York : ACM .
  • Higgins , J. J. 2003 . Introduction to modern nonparametric statistics. Duxbury Advanced Series , Pacific Grove, CA : Thomson .
  • ISO/IEC 9075-1 . 2008 . Information technology database languages SQL Part 1: Framework (SQL/Framework) , Geneva, , Switzerland : International Organization for Standardization .
  • Jarvenpaa , S. L. and Machesky , J. J. 1989 . Data analysis and learning: An experimental study of data modeling tools . International Journal of Man-Machine Studies , 31 : 367 – 391 .
  • Kühne , T. 2006 . Matters of (meta-)modeling . Software and System Modeling , 5 : 369 – 385 .
  • Ludewig , J. 2003 . Models in software engineering . Software and System Modeling , 2 ( 1 ) : 5 – 14 .
  • Rankins , R. , Bertucci , P. T. , Gallelli , C. and Silverstein , A. T. 2010 . Microsoft SQL server 2008 R2 unleashed , Boston, MA : Sams .
  • Rozenberg , G. 1997 . Handbook of graph grammars and computing by graph transformation , Singapore : World Scientific Publishing .
  • Seidewitz , E. 2003 . What models mean . IEEE Software , 20 : 26 – 32 .
  • Wohlin , C. , Runeson , P. , Höst , M. , Ohlsson , M. C. , Regnell , B. and Wesslén , A. 1999 . Experimentation in software engineering: An introduction , Norwell, MA : Kluwer Academics .

Reprints and Corporate Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

To request a reprint or corporate permissions for this article, please click on the relevant link below:

Academic Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

Obtain permissions instantly via Rightslink by clicking on the button below:

If you are unable to obtain permissions via Rightslink, please complete and submit this Permissions form. For more information, please visit our Permissions help page.