Announcements
- Exam venue: Dec 11, 19:00-22:00 @ OEE601
- Final paper due Dec 4, 24:00 - comments and marks (htm)
- Presentation slides due on Nov 25 - I shall talk
about your projects in class as there is not enough time for individual
presentation.
- Fixed link to materials for analyzing a domain:
Internal Analysis (.ppt) External Analysis (.ppt)
- Assignment 1 due
Nov 13 Nov 20, 24:00. (html)
- Answers (.doc) *** Marks (htm)
- Survey paper due Nov 8, 24:00. *** Marks and Comments (htm)
- Sample study survey paper for your reference: (survey1)(survey2)
- Oracle accounts are now ready for students. However, I suggest you
install your own PostgreSQL so that you can experience DBA functions.
- 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.
-
Dickson K.W. Chiu received
the B.Sc. (Hons.) degree in Computer Studies from the University of Hong
Kong2 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 (HKUST).
He started his own computer company while studying part-time. He has also
taught at several universities in Hong Kong. His research interest is in
e-business with a cross-disciplinary approach and the results have been
published in over 120 papers in international journals and conference
proceedings, including many practical master and undergraduate project
results. He received a best paper award in the 37th Hawaii International
Conference on System Sciences in 2004. He is the founding Editor-in-chief of
the International Journal on Systems and Service-Oriented Engineering and
serves in the editorial boards of several international journals. He
co-founded several international workshops and co-edited several journal
special issues. He also served as a program committee member for over 70
international conferences and workshops.
Assessment
- Final Exam (60%) - Open book + slides.
- Assignment (10%) (html)
- due: Nov 13
- 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
- Individual Survey Paper (10%)
- Guidelines (htm)
- Topic proposals - due late September
- survey paper submission - due late October
- Individual Project Report / Paper (20%)
- Guidelines (htm)
- Should normally carry on with your survey paper
- Final submission (paper and .ppt) - 1 week after the last
presentation
Textbook
- Connolly & Begg, Database Systems, 5th Edition, Pearson,
2010. (Website)
(In case you got only the 4th edition, there are no major problems.)
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)
- C4
- Relational Algebra (.ppt) - C5
-
SQL (.ppt)(.ppt) - C6,7
- Database Modeling & Design
(.ppt)(.ppt)(.ppt)-
C12,13,16
- Normalization (.ppt) - C14
-
Database Security (.ppt) - C20
- Database
Analysis, Engineering, & Administration (.ppt)- C9
- Database
Transaction and Integrity (.ppt) - C22
-
File Organization and index (.ppt)
- C-AppendixC
- Physical Database Design
- C18 (.ppt)
- Query Optimization
- C23 (.ppt)
- Advanced / Current Topics
- Distributed Database - C24 (.ppt)
- Data Warehouse - C32 (.ppt),
C33(.ppt)
Oracle Accounts (TBD)
- 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 ***
In case you want to clarify some jargons
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,
cdict.net
UML fun: pdf
Suggested case studies for project - elaborate on the database design
aspect on the following applications as described in the following papers:
(To be updated)
- 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)