CODASYS: A Consulting Tool for Novice Database Designers

Data Base for Advances in Information Systems

Volumn 33, Issue 3, 2002, Pages 54-68

  Antony, Solomon R ^a   Batra, Dinesh ^b  

^a TEXAS TECH UNIVERSITY   (United States)

^b FLORIDA INTERNATIONAL UNIVERSITY   (United States)

Author keywords

Consulting system; Database design; Entity relationship; Expert system; Human error; Novice designers; Patterns; Problem solving; Relational

Indexed keywords

EID: 4344707747     PISSN: 00950033     EISSN: None     Source Type: Journal    
DOI: 10.1145/569905.569911     Document Type: Article

References (43)

1. Anderson, J. R., Bole, C. F., and Reiser, B. J. (1985). “Intelligent tutoring system,” Science, Vol. 228, pp. 456–462.
2. Antony, S., Batra, D. and Santhanam, R. (1999). “Empirical validation of knowledge-based systems for conceptual database design,” Proceedings of the Fifth Americas Conference on Information Systems, Milwaukee, Wisconsin, USA, pp. 40–42.
3. Batra, D. and Zanakis, S. H. (1994). “A conceptual database design methodology based on rules and heuristics,” European Journal of Information Systems, Vol. 3, No. 3, pp. 228–239.
4. Batra, D. and Antony, S (1994). “Novice errors in database design,” European Journal of Information Systems, Vol. 3, No. 1, pp. 57–69.
5. Batra, D. and Antony, S. (2001). “Consulting supp. rt during conceptual database design in the presence of redundancy in requirements specifications: An empirical study,” International Journal of Human Computer Studies, Vol. 54, 2001, pp. 25–51.
6. Batra, D. and Sein, M. (1993). “Improving conceptual database design through feedback,” International Journal of Man Machine Studies, Vol. 40, pp. 653–676.
7. Batra, D., Hoffer, J. A., and Bostrom, R. P. (1990). “Comparing representations with the relational and extended entity relationship models,” Communications of the ACM, Vol. 33, pp. 126–139.
8. Bock, D. B. and Ryan, T. (1993). “Accuracy in modelling with extended entity relationship and object oriented data models,” Journal of Database Management, Vol. 4, No. 4, pp. 30–39.
9. Brancheau, J. C. and Brown, C. V. (1993). “The management of end-user computing: Status and directions,” ACM Computing Surveys, Vol. 25, No. 4, pp. 437–482.
10. Carroll, J. M. and Kellogg, W. A. (1989). “Artifact as theory-nexus: Hermeneutics meets theory-based design,” CHI Proceedings, Austin, Texas.
11. 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.
12. Coad, P. (1997). Object models: Strategies, patterns and applications, Prentice Hall, 1997.
13. Codd, E. F. (1970). “A relational model of data for large shared banks,” Communications of the ACM, Vol. No. 13, pp. 377–387.
14. Fernandez, E. B. and Yuan, X. (2000). “Semantic Analysis Patterns,” Proceedings of the 19th International Conference on Conceptual Modeling (ER 2000).
15. Fowler, M. (1997). Analysis Patterns, Reading, Mass.: Addison-Wesley.
16. Gamma, E., Helm, R., Johnson, R., and Vlissides, J. (1995). Design Patterns: Elements of Reusable Object-Oriented Software, Reading, Mass: Addison-Wesley.
17. Glaser, R., and Chi, M. T. H. “Overview,” in M. T. H. Chi, R. Glaser, and M. Farr (Eds), The Nature of Expertise (pp. xv-xxviii). Hillsdale, NJ: Erlbaum.
18. Hammer, M. and Mcleod, D. (1981). “Database description with SDM: A semantic database model,” ACM Transaction of Database Systems, Vol. 6, No. 3, pp. 351–386.
19. Hay, D. C. (1996) Data Model Patterns, New York: Dorset House.
20. Hoffer, J. A., Prescott, Mary B., and McFadden, F. R. Modern Database Management, Upp. r Saddle River, NJ: Prentice Hall, Sixth Edition, 2002.
21. Jones, T. H. and Song, I. Y. (1996). “Analysis of binary/ternary cardinality combinations in entity- relationship modeling,” Data and Knowledge Engineering, Vol. 19, pp. 39–64.
22. Korth, H. F. and Silberschatz, A. (1997). Database research faces the information explosion, Communications of the ACM, Vol. 40, No. 2, pp. 139–142.
23. Kumar, K. and Hillegersberg, J. V. ERP: Experiences and evolution, Communications of the ACM, 2000. Vol. 43, No. 4, pp. 23–26.
24. th Annual Decision Sciences Institute Meeting, Las Vegas, Nevada.
25. McFadden, F. R., Hoffer, J. A., and Srinivasan, A. (1991). A casebook for database management. Redwood City, CA. Benjamin/Cummings.
26. Maier, D. (1988). The Theory of Relational Databases, Rockville, Maryland: Computer Science Press.
27. New York Times (2001) “Job Forecast: Internet's Still Hot”, January 30, 2001.
28. Newsweek (1999). “Your Next Job”, February 1, 1999, pp. 44–46.
29. Purao, S. (1999). “APSARA: A tool to automate system design via intelligent pattern retrieval and synthesis,” Data Base. Vol. 29, No. 4., pp. 45–57.
30. Purao, S. and Storey, V. (1997). “Intelligent supp. rt for selection and retrieval of patterns for object- oriented design,” Proceedings of the 16th International Conference on Conceptual Modeling (ER’97), Los Angeles.
31. Ram, S. (1995). “Deriving Functional Dependencies from the Entity Relationship Model,” Communications of the ACM. Vol. 38, No. 9, pp. 95–107.
32. Rasmussen, J. (1986). Information Processing and Human-Machine Interaction, North-Holland, Amsterdam.
33. Reason J. (1990). Human Error, New York: Cambridge University Press.
34. Reiner D. (1992). “Database design tools”, In Conceptual database design: An entity-relationship approach (Batini C., Ceri S. and Navathe SB Eds), Redwood City, California: Benjamin/ Cummings.
35. Rosenthal, A., and Reiner, D. (1994). “Tools and transformations - rigorous or otherwise - for practical database design,” ACM Transactions of Database Systems, Vol. 19, No. 2, pp. 167–211.
36. Rouse, W. B. (1981). “Models of human problem solving: Detection, diagnosis and compensation for complex engineering systems,” Proceedings of IFAC Conference on Analysis, Design and Evaluation of Man-Machine Systems, FRG.
37. Scheer, A. W. (1989). Enterprise-wide modelling: Information Systems in Industry, Berlin: Springer Verlag.
38. Shoval, P. and Shiran, S. (1997). “Entity-relationship and object-oriented data modelling - an experimental comparison of design quality,” Data & Knowledge Engineering, Vol. 21, pp. 297–315.
39. Storey, V. C. and Goldstein, R. C. (1993). “Knowledge-based approaches to database design,” MIS Quarterly, March 1993, pp. 25–46.
40. Technology Forecast (1999). Menlo Park: Price Waterhouse Technology Center, January 1999.
41. Teorey, T. J. (1990). Database Modeling and Design: The Entity-Relationship Approach, San Mateo, California: Morgan Kaufmann.
42. Teorey, T. J. (1994). Database modeling and design, San Mateo, California: Morgan Kaufmann Publishers.
43. Teorey, T. J., Yang, D., and Fry, J. F. (1986). “A logical design methodology for relational databases using the extended entity-relationship model,” Computing Surveys, Vol. 18, No. 2, pp. 197–222.