Andrew's Page: Teaching

Dr Andrew Scott G7VAV MBCS, MIET, Member ACM, Member IEEE
	Senior Lecturer [D35] School of Computing and Communications InfoLab21 Lancaster University Lancaster, LA1 4WA United Kingdom

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

	Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems Pearson Education, 13 April 2006, Paperback: 1168 pages, ISBN: 032141506X
	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
	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
	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
	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

JDBC

Installing and running MySQL and Connector/J

Submit to: |

	\| Home \| Teaching \| Research \| Hardware \| Software \| Tools \| Calendar \| Links \|	© Andrew Scott 2006 - 2012, All Rights Reserved
http://www.andrewscott.eu/	http://www.andrew-scott.co.uk/	http://www.andrew-scott.eu/