Comparing relational database designing approaches: Some managerial implications for database training

Industrial Management and Data Systems

Volumn 103, Issue 3-4, 2003, Pages 150-166

  Yang, Heng Li ^a  

^a NATIONAL CHENGCHI UNIVERSITY   (Taiwan)

Author keywords

Database packages; Databases; Decomposition method; Relational databases; User studies

Indexed keywords

DATA STRUCTURES; FORMAL LOGIC; INFORMATION MANAGEMENT; OBJECT ORIENTED PROGRAMMING; PERSONNEL TRAINING;

DATABASE DESIGNERS;

RELATIONAL DATABASE SYSTEMS;

EID: 0041862608     PISSN: 02635577     EISSN: None     Source Type: Journal    
DOI: 10.1108/02635570310465634     Document Type: Review

References (49)

1. Anjard, R.P. (1994), "The basics of database management systems (DBMS)", Industrial Management & Data Systems, Vol. 94 No. 5, pp. 11-15.
2. Bachman, C. (1969), "Data structure diagrams", Data Base, Summer, Vol. 1 No. 2, pp. 4-10.
3. Batra, D. (1997), "The effect of user view characteristics on data design performance of novices", Journal of Database Management, Summer, Vol. 8 No. 3, pp. 27-36.
4. Batra, D. and Antony, S.R. (1994), "Novice errors in conceptual database design", European Journal of Information Systems, Vol. 3 No. 1, pp. 57-69.
5. Batra, D. and Davis, J.G. (1992), "Conceptual data modeling in database design: similarities and differences between expert and novice designers", International Journal of Man-Machine Studies, Vol. 37, pp. 83-101.
6. Batra, D., Hoffer, J.A. and Bostrom, R.P. (1990), "Comparing representations with relational and EER model", Communications of the ACM, Vol. 33 No. 2, pp. 126-39.
7. Blaha, M.R., Premerlani, W.J. and Rumbauch, J.E. (1998), "Relational database design using an object-oriented methodology", Communications of the ACM, Vol. 31 No. 4, pp. 414-27.
8. Bock, D.B. (1997), "Entity-relationship modeling and normalization errors", Journal of Database Management, Winter, Vol. 8 No. 1, pp. 4-12.
9. Bock, D.B. and Ryan, T. (1993), "Accuracy in modeling with extended entity relationship and object oriented data models", Journal of Database Management, Vol, 4 No. 4, pp. 30-9.
10. Bracewell, A. (1996), "Databases - the black box concept: creating applications without creating costs and problems", Industrial Management & Data Systems, Vol. 96 No. 7, pp. 32-4.
11. Brosey, M. and Schneiderman, B. (1978), "Two experimental comparisons of relational and hierarchical database models", International Journal of Man-Machine Studies, Vol. 10 No. 6, pp. 625-37.
12. Carlis, J.V. (1985), Logical Data Structures, Computer Science Department, University of Minnesota, Minneapolis, MN, TR 85-23.
13. Chen, P.P. (1976), "The entity-relationship model toward a unified view of data", ACM Transactions On Database Systems, Vol. 1 No. 1, pp. 9-36.
14. Childs, D. (1968), "Feasibility of a set-theoretical data structure - a general structure based on reconstituted definition of relation", Proceedings of the 1968 International Federation for Information Processing Congress.
15. Codd, E. (1970), "A relational model of data for large shared data banks", Communications of the ACM, Vol. 13 No. 6, pp. 377-87.
16. Date, C. J. (1990), An Introduction to Database Systems: Vol. I, 5th ed., Addison-Wesley, Reading, MA.
17. Date, C. J. (1995), An Introduction to Database Systems, 6th ed., Addison-Wesley, Reading, MA.
18. Davis, F.D. (1985), "A technology acceptance model for empirically testing new end-user information systems: theory and results", doctoral dissertation, Sloan School of Management, Massachusetts Institute of Technology, MA.
19. Elmasri, R. and Navathe, S.B. (2000), Fundamentals of Database Systems, 3rd ed., Addison-Wesley, Reading, MA.
20. Elmasri, R., Weeldreyer, J. and Hevner, A. (1985), "The category concept: an extension to the entity-relationship model", Data Knowledge Engineering, Vol. 1 No. 11, pp. 75-116.
21. Halpin, T. (1995), Conceptual Schema and Relational Database Design, 2nd ed., Prentice-Hall, Englewood Cliffs, NJ.
22. Hardgrave, B.C. and Dalal, N.P. (1995), "Comparing object-oriented and extended-entity-relationship data models", Journal of Database Management, Vol. 6, No. 3, pp. 15-21.
23. 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, Vol. 31, pp. 367-91.
24. Kim, Y.-G. and March, S.T. (1995), "Comparing data modeling formalisms", Communications of the ACM, Vol. 38 No. 6, pp. 103-15.
25. Kroenke, D.M. (1995), Database Processing, 5th ed., Macmillan, New York, NY.
26. Lee, H. and Choi, B.G. (1998), "A comparative study of conceptual data modeling techniques," Journal of Database Management, Spring, Vol. 9 No. 2, pp. 26-35.
27. McFadden, F.R. and Hoffer, J.A. (1994), Database Management, 4th ed., Benjamin/Cummings, Redwood City, CA.
28. Marshall, T.E. and Gibson, M.L. (1996), "Technology versus methodology support for database design: a study of designer choice related to perception and performance", Journal of Database Management, Vol. 7 No. 4, pp. 3-12.
29. Myers, I.B. and McCaulley, M.H. (1985), Manual: A Guide to the Development and Use of the Myers-Briggs Type Indicator, Consulting Psychologists Press, Palo Alto, CA.
30. Nord, G.D. and Nord, J.H. (1997), "Information system project development: knowledge and domain requirements for the systems analyst", Industrial Management & Data Systems, Vol. 97 No. 1, pp. 17-24.
31. Palvia, P.C., Liao, C. and To, P. (1992), "The impact of conceptual data models on end-user performance", Journal of Database Management, Vol. 3 No. 4, pp. 4-15.
32. Prietula, M.J. and March, S. (1991), "Form and substance in physical database design: an empirical study", Information System Research, Vol. 2 No. 4, pp. 287-314.
33. Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F. and Lorensen, W.(1991), Object-Oriented Modeling and Design, Prentice-Hall, Englewood Cliffs, NJ.
34. Ryan, S.D., Bordoloi, B. and Harrison, D.A. (2000), "Acquiring conceptual data modeling skills: the effect of cooperative learning and self-efficacy on learning outcomes", The DATA BASE for Advances in Information Systems, Fall, Vol. 31 No. 4, pp. 9-24.
35. Sankar, C.S. and Marshall, T.E. (1993), "Database design support: an empirical investigation of perceptions and performance", Journal of Database Management, Vol. 4 No. 3, pp. 4-14
36. Shlaer, S. and Mellor, S. (1988), Object-Oriented System Analysis, Modeling the World in Data, Yourdon Press, Englewood Cliffs, NJ.
37. Shoval, P. and Even-Chaime, M. (1987), "Database schema design: an experimental comparison between normalization and information systems", Database, Vol. 18, pp. 30-9.
38. Slocum, J.W. and Hellriegel, D. (1983), "A look at how managers' minds work", Business Horizons, Vol. 26 No. 4, pp. 58-68.
39. Srinivasan, A. and Téeni, D. (1995), "Modeling as constrained problem solving: an empirical study of the data modeling process", Management Science, March, Vol. 41 No. 3, pp. 419-34.
40. Stamper, D. and Price, W. (1990), Database Design and Management: An Applied Approach, McGraw-Hill, New York, NY.
41. Storey, V.C. (1988), View Creation: An Expert System for Database Design, ICIS Press, Washington, DC.
42. Storey, V.C., Thompson, R.C. and Ram, S. (1995), "Understanding database design expertise", Data and Knowledge Engineering, August, Vol. 16, pp. 97-124.
43. Teorey, T., Yang, D. and Fry, J. (1986), "A logical design methodology for relational databases using the extended entity-relationship model", ACM Computing Survey, Vol. 18 No. 2, pp. 197-222.
44. Ullman, J.D. (1982), Principles of Database Systems, 2nd ed., Computer Science Press, Rockville, MD.
45. Ullman, J.D. (1989), Principles of Database and Knowledge-base Systems. Vol. 1, Computer Science Press, Rockville, MD.
46. Verheijen, G.M. and Van Bekkum, J. (1982), "NIAM: an information analysis method", in Olle, T.W., Sol, H.G. and Verryn-Stuart, A.A. (Eds), Information System Design Methodologies: A Comparative Review, North-Holland, Amsterdam, pp. 537-90.
47. Waltz, T.J., Yen, D. and Lee, S. (1995), "Object-oriented database systems: an implementation plan", Industrial Management & Data Systems, Vol. 95 No. 6, pp. 8-17.
48. Whitley, E.A. (1998), "Method-ism in practice: investigating the relationship between method and understanding in Web page design", Proceedings of ICIS, Helsinki, Finland.
49. Zhang, Q. (2001), "Object-oriented database systems in manufacturing: selection and applications", Industrial Management & Data Systems, Vol. 101 No. 3, pp. 97-105.