| |
| Course: | INFO606 - Advanced Database Management |
|
|
| On Campus Offering: | Winter (eve) |
|
| Online Offering: | Summer |
| | Faculty: | Song, Il-Yeol
Li, Jiexun Jason
|
|
| Extended Course Description: | Catalog Course Description:
Examines both traditional database systems and recent advances in database systems. Topics include formal treatment of normalization and denormalization, extended entity-relationship models, advanced query processing techniques, query optimization, physical database design and indexing, and object-oriented database systems.
Pre-requisites and Co-requisites:
INFO 601 Computer Programming for Information Processing or equivalent knowledge
INFO 605 Database Management I
Curriculum Role:
This course is offered to students who finished Database Management I and presents advanced theory and technology for database design and performance improvement of databases.
Course Rationale:
This course establishes the theoretical background of relational databases and advanced technology of improving database performance and database design. This course is offered for students who want to be a database expert for conceptual database design, as well as physical database design.
Course Outcomes:
Upon successful completion of this course, a student will be able to:
• Explain evolving technologies and trends of database systems
• Normalize relations into the third normal form
• Denormalize relations for performance improvement
• Acquire knowledge of functional dependency and inference rules
• Apply inference rules to remove redundant functional dependency
• Acquire knowledge of database tuning to optimize performance
• Design physical database structure, file organization, disk parameters and indexing techniques
• Apply relational algebra operations to query relational databases
Course Content:
Principal topics and the approximate number of weeks devoted to each are:
• Reviews of INFO 605 and normalization and denormalization (3)
• Advanced relational algebra operations (1.5)
• Advanced database tuning for performance optimization (1)
• Physical database structure and indexing (3)
• Beyond relational database systems – XML databases and the Semantic Web (1.5)
Presentation:
Note: Presentation method may vary somewhat from section to section.
Presentation will be by lecture.
Assessment:
Note: Assessment method may vary somewhat from section to section.
Evaluation is based on assignments, project, and examination.
|
|
| Previous | Course List | Course Offerings | Next |
|
|
