Notices
| 05.06.08 | Assignment's results are available on the Assignment page. Please come and collect the scripts at the consultation sessions of 12 and 13 June 2008 at room 78-525. |
| 02.06.08 | Consultation for Final Exam with Ken (Ke Deng): 3.00 - 4.00 pm Tuesday 10 June Room 78-639 (Topics: Data Cleansing, Intensively Distributed Data, Spatial Data Management) |
| 27.05.08 | There will be two one-hour consultation sessions for the final exam at 1:00 pm of 12 and 13 June 2008 at room 78-525 (GPS). |
| 26.05.08 | Information for the final exam |
| 07.05.08 | Quiz's results are available on the Exam page |
| 06.05.08 |
Lecture schedule for remaining weeks: Week 11: Spatial Databases Week 12: Data Cleansing Week 13: Intensively Distributed Databases and Revision |
| 06.05.08 | Article for today's session on Data Models available here |
| 22.04.08 | There will be two one-hour consultation sessions for Assignment at 1:00 pm on 15 and 16 May 2008 at room 78-525 (GPS). |
| 15.04.08 | Consultation for Mid Semester Exam with Shazia: 9.00 - 10.00 Friday 18 April Room 78-652 |
| 07.04.08 | Assignment released. Due date 23 May 2008 @ 5.00 PM |
| 07.04.08 | Guidelines for Mid semester exam. 21 April 2008 @ 12.00 in lecture room (78-420) |
| 18.03.08 | There is one two-hour consultation session for Mid Semester Exam at 1:00 pm of 16 April 2008 at room 78-525 (GPS). |
| 12.03.08 | Please find weekly plan adjusted according to change in timetable |
| 28.02.08 |
Timetabling has confirmed that we can move the lecture Tues 8-10, 32-214 to Mon 12-2, 78-420. The problem solving session (starting week 3) will remain as is i.e. Tue 1-2. This change is effective from next week, that is there will be a lecture on Monday 3 March at 12-2 in 78-420. |
Overview
This course is structured into several modules. The
modules cover a wide range of related topics, including database systems
architectures, functionality of DBMS components, distributed database
management and design, client server architectures, multi-database systems,
interoperability, data warehousing, selected aspects of data mining techniques
and intensively distributed data.
Objective
The objective of this course is to provide an
understanding of the fundamental issues involved in designing and implementing a
large scale information system. By putting emphasis on illustrations, current
trends, the course aims at providing an insight into cutting edge technology.
This should equip the students with sufficient conceptual and practical
knowledge, to be able to recognize the challenges, analyse the appropriateness
of the technology and understand the design and implementation complexities
while building modern information systems.
Assumed Background
Information Systems Concepts Relational DB design: data aspect - ER and process aspect - DFDs Relational Database Management Systems architecture and main functions: Query processing, Transactions, Concurrency, Recovery, Security, Views, Views update-ability, SQL
General information
Lecturer: Dr. Shazia Sadiq, Room 652, General Purpose
South, x53481; shazia[at]itee.uq.edu.au
Textbook: Elmasri & Navathe Fundamentals of Database
Systems 5th Edition Pearson Education 2006 (4th Edition
acceptable)
Lecture notes: Copies of tutorials and lecture slides will
be made available from course website and the Print-on-Demand service at the UQ
Bookstore.
Students are expected to attend 2 hours lectures and 1
hour Problem Solving Session per week.