Announcements
- Final Paper Due - Dec 5, 24:00
- Exam Dec 8, 19:00pm
- Open book problem solving type (only text-book allowed)
- Database design is the focus of our course
- Read the textbook (not just the slides) in order to fully understand the
advanced topics such as transactions, query optimization, distributed
database, etc.
- Paper Slide Presentation
- November 24 - 15 minutes for each student.
- Draft paper / slide submission for comment before Nov 23 noon
encouraged.
- Assignment 1
- due Nov 10. (file in
html) - Normalization and security will be taught first for you to
finish the assignment.
- answers (PDF)
- marks (htm)
- Suggested projects and guidelines posted. See below.
- Oracle accounts created for students. See below. However, I suggest you
install your own
PostgreSQL so that you can experience DBA functions.
- Sorry about the typo - lectures should be on Mondays.
- Emphasis on database design, engineering, and management.
Course Description (Academic Calendar)
This course is to provide an in-depth knowledge of relational
database management systems (DBMS). Topics include: conceptual
modeling of a database, relational data model, relational
algebra, database language SQL, relational database design, data
storage, index structures, query evaluation, transaction
processing, concurrency control, and crash recovery. In
addition, advanced topics such as distributed databases and data
warehouses will also be covered. The students will have a
thorough understanding of relational DBMS after taking this
course.
Course Objectives (Academic Calendar)
To give students a solid
background in relational DBMS; to learn general DBMS designs and
internals, including relational data modeling, relational database
design, data storage, index structures, query evaluation, transaction
processing, concurrency control, and crash recovery; and to discuss
advanced topics such as distributed databases and data warehouses.
Learning Outcomes (Department syllabus)
- Knowledge
- Explain the basic concepts of RDBMS design, including
entity-relationship model, relational data model and data normalization
- Explain database languages: relational algebra and SQL
- Explain underlying disk-based data storage, organization and access
methods in RDBMS
- Explain query evaluation, query optimization, concurrency control
and crash recovery techniques
- Identify advanced database technologies such as distributed
databases and data warehouses
- Professional Skill
- Design database given user requirements, populate the database and
formulate SQL queries on the data
- Analyze the tradeoffs of alternative database designs and system
techniques
- Implement some components of a small RDBMS
- Attitude
- Develop team spirit and professional attitude towards database
management
Course Information
Lecturer
- Dr. Dickson K.W. CHIU (Ph.D.,
HKUST; SMIEEE; SMACM; Life MHKCS)
- Email: dicksonchiu@ieee.org Include
"[COMP7640]" in the subject for easy indexing and prompt actions. In case you
cannot get a reply within 48 hours, please resend as I might have missed
that.
- Phone consultation: Leave your phone number and question
by email, and I'll call back.
Dr.
Dickson K.W. Chiu received the B.Sc. (Hons.) degree in Computer Studies
from the University of Hong Kong in 1987. He received the M.Sc. (1994) and
the Ph.D. (2000) degrees in Computer Science from the Hong Kong University
of Science and Technology, where he worked as a Visiting Assistant Lecturer
after graduation. He also started his own computer company while studying
part-time. From 2001 to 2003, he was an Assistant Professor at the
Department of Computer Science, the Chinese University of Hong Kong. He was
a Visiting Assistant Professor in 2006 at the Computing Department, Hong
Kong Polytechnic University for teaching M.Sc. courses. With his solid
industrial experience and cross-disciplinary research, he has taught a wide
range of subjects at various levels. His research interests are in
information systems, information technologies, service computing, and
e-/m-business with a cross-disciplinary approach, involving Internet
technologies, agents, workflows, software engineering, information system
management, security, and databases. His research results have been
published in over 100 papers in international journals and conference
proceedings, including practical results of many master and undergraduate
projects. He received a best paper award in the 37th Hawaii International
Conference on System Sciences (HICSS) in 2004. He serves as Associate Editor
of the Engineering Letters and Editorial Board Member of the International
Journal of Web Service Research (SCI-E), and International Journal of
Software Architecture. He co-founded several international workshops and
co-edited several special issues in journals. He also served as a mini-track
co-chair in the Decision Technologies track of HICSS, a theme (Service
Intelligence and Service Science) co-chair in the International Conference
of Machine Learning and Cybernetics, and program committee member in many
international conferences. Dr. Chiu is a Senior Member of the ACM, a Senior
Member of the IEEE, and a life member of the Hong Kong Computer Society.
Assessment (To be determined)
- Final Exam (60%)
- Assignment (10%) (html)
- due: Nov 10, 23:59
- late submission policy: deduct 10 marks for every day
- submission by email to:
dicksonchiu@ieee.org
- include your name and student number in the assignment file
- Project Report or Paper (30%)
- Guidelines (htm)
- Project / Paper proposals - early October
- Midterm drafts / presentation - early November
- Final submission (paper / code and .ppt) - 1 week after the last
presentation
- Suggested case studies for project - elaborate on the database design
aspect on the following applications as described in the following papers:
- Jenny Y.Y. Wong, K.P. Mak, and D.K.W. Chiu. Effective e-Government
Process Monitoring and Interoperation: A Case Study on the Removal of
Unauthorized Building Works in Hong Kong, HICSS40, Jan 2007. (paper)(ppt)
- Mandy Y.S. Tong and D.K.W. Chiu. Alert Driven Process Integration and
Exception Handing: A Case Study on Audit Confirmation with Web Services,
IEEE Joint Conference on E-Commerce Technology (CEC'07) and Enterprise
Computing, E-Commerce and E-Services (EEE '07), Tokyo, pp. 469-476, July
2007. (paper)(ppt)
- Gilbert H. L. Luk, Dickson K.W. Chiu, and Ho-fung Leung. Web-service
Based Human Resource Recruitment by Using Matchmaking Decision Support, 1st
International Workshop on Service Intelligence and Service Science (SISS
2006), Hong Kong, Oct 2006. (paper)(ppt)
- Cherrie W.W. Ng and D.K.W. Chiu. e-Government Integration with Web
Services and Alerts: A Case Study on an Emergency Route Advisory System in
Hong Kong, 39th Hawaii International Conference on System Sciences (HICSS39),
Jan 2006. (paper)(ppt)
- Gordon K.T. Lau, D.K.W. Chiu and P.C.K. Hung. Web-service Based
Information Integration for Decision Support: A Case Study on e-Mortgage
Contract Matchmaking Service, HICSS39,
Jan 2006. (paper)(ppt)
- Hing-Sum Chan, D.K.W. Chiu, P.C.K. Hung and H.F. Leung. Credibility
Relationship Management in a Web Service Integration Environment, 4th ICIS
Workshop on e-Business, Las Vegas, Dec 10, 2005. (paper)(ppt)
- Raymond C.M. Lee, K.P. Mak, and D.K.W. Chiu. Enhancing Workflow
Automation in Insurance Underwriting Processes with Web Services and Alerts,
HICSS40, Jan 2007. (paper)(ppt)
- Anthony C.Y. Lam and D.K.W. Chiu. Cooperative Brokerage Integration for
Transaction Capacity Sharing: A Case Study in Hong Kong,
HICSS39, Jan 2006. (paper)(ppt)
- Allen K.L. Lam, D.K.W. Chiu, and P.C.K. Hung. Enhancing Availability of
Information and Towards Freedom of News Distribution: Supporting Small-scale
News Agencies with a Web-Service Infrastructure. (paper)
- Winnie N.Y. Yan, and D.K.W. Chiu. Enhancing E-Commerce Processes
with Alerts and Web Services: A case study on Online Credit Card Payment
Notification. International Conference of Machine Learning and Cybernetics (ICMLC
2007), IEEE Press, Hong Kong, August 2007.
(book
chapter)(ppt)
- Jason C.S. Chung, Dickson K.W. Chiu, and E. Kafeza. An Alert
Management System for Concrete Batching Plant. 12th International Conference
on Emerging Technologies and Factory Automation, Patras, Greece, pp.
591-598, Sept. 2007. (paper)
- Donald S.F. Wong and D.K.W. Chiu. Collaborative Workflow
Management with Alerts: An Integrated Retailing System for Garments Brands,
2007 IEEE International Conference on e-Business Engineering (ICEBE), pp.
433-438, Hong Kong IEEE Press, Oct. 2007. (paper)(ppt)
- Vincent C.T. Chan, D.K.W. Chiu, Stephanie Chow, and Patrick C. K.
Hung. e-Monitoring of Outsourcing IS Project in Financial Institutions: A
Case Study on Mandatory Provident Fund Projects in Hong Kong. 2007 IEEE
International Conference on e-Business Engineering (ICEBE), Hong Kong, IEEE
Press, pp. 460-465, Oct. 2007. (paper)(ppt)
Textbook
- Connolly & Begg, Database Systems, 4th Edition, Pearson,
2005. (Website)
References
- Ramez Elmasri and Shamkant B. Navathe, Fundamentals of
Database Systems, 5th Edition, Addison Wesley, 2007. (Website)
- Raghu Ramakrishnan and Johannes Gehrke, Database
Management Systems, 3rd Edition, McGraw Hill, 2003. (Google)(Website)
- C. J. Date, An Introduction to Database Systems, 8th
Edition, Addison-Wesley, 2004. (Website)
- Abraham Silberschatz, Henry F. Korth, and S. Sudarshan,
Database System Concepts, 5th Edition, McGraw Hill, 2006. (Website)
Tentative Course Schedule (Slides also subjected to update)
- Introduction (.ppt)
- Textbook, Chapter 1
- Database Environment (.ppt)
- C2
- Relational Model (.ppt)
- C3
- Relational Algebra (.ppt) - C4
-
SQL (.ppt)(.ppt) - C5,6
- Database Modeling & Design
(.ppt)(.ppt)(.ppt)-
C11,12,15
- Normalization (.ppt) - C13
-
Database Security (.ppt) - C18
- Database
Analysis, Engineering, & Administration (.ppt)- C9
- Database
Transaction and Integrity (.ppt) - C20
-
File Organization and index (.ppt)
- C-AppendixC
- Physical Database Design
- C17 (.ppt)
- Query Optimization
- C21 (.ppt)
- Advanced / Current Topics
- Distributed Database - C22 (.ppt)
- Reference: Data Warehouse - C31 (.ppt),
C32(.ppt)
Oracle Accounts
- username: dxxxxxxx (xxxxxxx = your student number)
- password: dxxxxxxx
- database host: csdb3
- terminal host: mh2
mh2:~>sqlplus
SQL*Plus: Release 10.1.0.3.0 - Production on Mon Oct 6 07:33:40 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: dxxxxxxx@csdb3
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
*** Useful links ***
Digital Libraries
HTML tutorials: (do a web search for "HTML tutorial" for more stuff...):
Paper Writing
XML tutorials:
Many tutorials:
Online Dictionary: www.webster.com,
www.dictionary.com
UML fun: pdf