Notes:
| 12 June 2009 | Assignment Results are available here |
| 6 June 2009 | Since 8 June, Monday is public holiday, the consultation at this day is changed to (2:00-3:00pm, 10 June, Wednesday) at same location. |
| 1 June 2009 | Ke Deng's final exam consultation will be (2:00-3:00pm, 8 June, Monday) and (1:00-2:00pm, 9 June, Tuesday) at GPS Room 639; or by appointment up to 12 June |
| 1 June 2009 | The slide of the course review is available here. You should double check final exam timetable through mySI-net in case there is change. |
| 14 May. 2009 | The assignment is due 28 May,
5:00pm in GPS Room 639 (Building 78). (The assignment due time shown on assignment task sheet is incorrect and just rectified) |
| 13 May. 2009 | If you want to review the mid semester exam paper, you can make an appointment with me through email dengke@itee.uq.edu.au. |
| 4 May. 2009 | Just want to remind we have lecture tomorrow (5 May) on Data Model by A/Prof. Shazia Sadiq. |
| 29 Apr. 2009 | The results for mid semester exam is here. |
| 23 Apr. 2009 | I invited A/Prof. Shazia Sadiq to lecture the Module 5, Data Warehousing on Monday, 27 April. |
| 12 Apr. 2009 | I notice that some students believe that the mid semester exam is from tutorial only. This is not correct. Here I want to stress again that the mid semester exam covers all concepts and techniques introduced in the lecture, tutorial in the module 0, 1, 2, 3. |
| 9 Apr. 2009 | The mid semester exam is held in lecture time and venue,
Monday 12:00-2:00, 20 April It covers all concepts and techniques introduced in the lecture, tutorial in the module 0, 1, 2, 3. |
| 2 Apr. 2009 | For the tutorial exercise 3, you need to answer the question 3. The solutions for the questions 1,2,4 are provided so that it would be easier for you to understand the context. |
| 1 Apr. 2009 | The assignment is available now |
| 22 Mar. 2009 | The PDF version of lecture notes are available now. |
| 11 Mar. 2009 | One more tutorial session has been arranged. Please use mySI-net to find the time and venue. |
| 7 Mar. 2009 | The tutorial starts from week 3. The questions for the
first tutorial is available now. We do not have Lecture tomorrow as planned. |
| 6 Mar. 2009 | Due to the room capacity issue, the Monday lecture room now has changed to 76-228 (was in 01-E107). It should appear on Si-net tomorrow. |
| 5 Mar. 2009 | The newsgroup of this course is open now.
This is a place that you post any questions related to your study of this
course. To access the newsgroup, login https://my.uq.edu.au/index.html , click "myNewsgroups" on the right column, then select UQ.ITEE and tick infs3200. |
| 2 Mar. 2009 | Welcome to Infs3200/infs7907 ! The weekly plan of this course is here |
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, analyze 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
Course Coordinator: Dr. Xue Li, Room
650, General Purpose South, x52379; xueli[at]itee.uq.edu.au
Lecturer: Dr. Ke Deng, Room 639, General Purpose South, x54739;
dengke[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.