Dr Andrew Scott G7VAV

My photo
 
February 2018
Mo Tu We Th Fr Sa Su
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 1 2 3 4
5 6 7 8 9 10 11


CSc 243: Database Systems

This course aims to:

Recommended Texts
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
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
John Wiley & Sons, 30 October 2000, Hardcover: 464 pages
ISBN:0471383848
Stonebroker
Michael Stonebroker,
Object-relational DBMSs: Tracking the Next Great Wave
Morgan Kaufmann, 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
JDBC
Installing and running MySQL and Connector/J


for client 54.159.30.26: 55590
© Andrew Scott 2006 - 2018,
All Rights Reserved
http://www.andrew-scott.uk/
http://www.andrew-scott.co.uk/
http://www.andrew-scott.eu/