An educational perspective on database management systems and object-oriented methodology: a 12 year journey

ABSTRACT

Relational database management systems are an essential component of many data intensive applications. At USC, a course entitled "File and Database Management" introduces students to fundamental concepts in relational databases. Students are introduced to conceptual, logical and physical organization of data, use of both formal and commercial query languages, e.g., SQL, indexing techniques for efficient retrieval of data, the concept of a transaction, concurrency control and crash recovery techniques. This paper summarizes our experiences with this course and the challenges of educating students on use of object-oriented concepts and their mapping to tables.

REFERENCES

• 1: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 2: Proc. of the third international conference on Entity-relationship approach to software engineering, December 1983
• 3: Harvey M. Deitel , Paul J. Deitel, Java How to Program, Prentice Hall PTR, Upper Saddle River, NJ, 2001
• 4: Ramez A. Elmasri , Shamkant B. Navathe, Fundamentals of Database Systems, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1998
• 5: Charles Petzold, Programming Windows with C# (Core Reference), Microsoft Press, Redmond, WA, 2001
• 6: Cris Kobryn, UML 2001: a standardization odyssey, Communications of the ACM, v.42 n.10, p.29-37, Oct. 1999 [doi>10.1145/317665.317673]
• 7: Bernhard Thalheim , B. Thalheim, Entity-Relationship Modeling: Foundations of Database Technology, Springer-Verlag New York, Inc., Secaucus, NJ, 2000

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.0 General

General Terms:
Design, Human Factors

Keywords:
database management, education, object-oriented