Dr Andrew Scott G7VAV
MBCS, MIET, Member ACM, Member IEEE
My photo
Senior Lecturer [D35]
Computing Department
InfoLab 21, South Drive
Lancaster University
Lancaster, LA1 4WA
United Kingdom
 
November 2008
Mo Tu We Th Fr Sa Su
27 28 29 30 31 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
1 2 3 4 5 6 7
CSc 243: Database Systems
This course aims to:
  • Give students a solid grounding in relational database theory and to highlight the practical issues in employing databases.
  • Expose students to the inner workings and file system structures used to support database functionality.
  • Examine the problems of concurrent user access.
  • Explore upcoming, state of the art database models.
Recommended Textbooks
Elmasri and Navathe
Ramez Elmasri, Shamkant B. Navathe,
Fundamentals of Database Systems
Pearson Education, 13 April 2006, Paperback: 1168 pages, ISBN: 032141506X
Connolly and Begg
Thomas Connolly, Carolyn Begg,
Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series)
Addison Wesley, 24 May 2004, Paperback: 1236 pages, ISBN: 0321210255
Chaudhri, Rashid and Zicari
Akmal B. Chaudhri, Awais Rashid, Roberto Zicari,
XML Data Management: Native XML and XML-enabled Database Systems
Addison Wesley, 20 March 2003, Paperback: 688 pages, ISBN: 0201844524
Chaudhri and Zicari
Akmal B. Chaudhri, Roberto Zicari,
Succeeding with Object Databases: A Practical Look at Today's Implementations with Java and XML (Wiley computer publishing)
John Wiley & Sons, 30 October 2000, Hardcover: 464 pages, ISBN: 0471383848
Stonebroker
Michael Stonebroker,
Object-relational DBMSs: Tracking the Next Great Wave (Morgan Kaufmann Series in Data Management Systems)
Morgan Kaufmann Publishers In, 12 August 1999, Paperback: 297 pages, ISBN: 1558604529
Syllabus
Part I
  • History of databases and day to day application scenarios
  • Relational database systems
    • Relational model and relation normalisation
    • Relational algebra
    • Structured Query Language (SQL)
    • Entity-Relationship (ER) model
    • Three schema architecture and relational schema definitions in SQL v
      Relational database access from Java
  • Physical data organisation and access
    • Primary file organisation
    • Secondary file organisation
Part II
  • Query optimisation
  • Transaction processing and concurrency control
  • Object-oriented database systems
    • The ODMG standard
    • Object database evolution
    • Commercial object-oriented database systems
  • Object-relational database systems
  • The Java Data Objects standard
  • XML Data Management
  • XML-enabled database systems
  • Native XML database systems
  • Data Warehouses
Pile of slides
© 2006 - 2008 Andrew Scott