Course Outline INFO476 Advanced Database Management Systems

1
Course Outline INFO476Advanced Database
Management Systems
2
Course Overview

• INFO 476 is an advanced database management
  systems course designed to
• Extend the topics covered in INFO 475 (formerly
  INFO316)
• Explore evolving issues in database management
  systems. 
• Goal Familiarity with database topics you are
  likely to encounter in your careers.

3
Textbooks

• Database Systems A Practical Approach to Design,
  Implementation, and Management by Connolly,
  Thomas and Begg, Caroline, Addison Wesley, Third
  Edition, ISBN 0-201-70857-4 
• Same text as used for INFO475.

4
Grading
5
Schedule

• No class week of March 17
• Propose an extended class (TBD) to cover missed
  time

6
Topics Database Development Methodologies

• Database Development Methodology
• This section of the course will provide an
  overview of the methodology required to plan,
  design and implement the database component of an
  information system. 
• As conceptual and logical design topic has been
  covered in INFO316/475 and INFO415, we will
  review the conceptual and logical aspects of the
  methodology.
• Focus will be on physical design and database
  monitoring and tuning.

7
Physical Design

• Logical and conceptual database design is
  concerned with what data must be managed.
  Physical database design is concerned with the
  how database will be implemented using specific
  DBMS (e.g., Oracle vs SQL Server) on secondary
  storage .

8
Physical Design

• Topics we will cover include
• Mapping the logical design to the physical
• Designing physical tables
• Choosing the correct file organization
• Implementing indexes to improve performance

9
Monitoring and Tuning

• Relational databases are not inherently efficient
  and need to be monitored and tuned on an on-going
  basis.
• We will examine a number of approaches, including
  their advantages and pitfalls, that can be used
  to optimize the performance of a relational
  database.
• Topics to be covered include
• The importance of monitoring and tuning
• Methods for optimizing database performance

10
Topics Selected Database Issues

• In this section of the course, we will examine
  issues that must be considered when developing
  and implementing a database. Topics include
• Transaction Management
• Programmatic SQL

11
Transaction Management

• We will discuss methods of ensuring the integrity
  of reliability and consistency of data in the
  database. Topics to be covered include
• Transaction support (managing logical units of
  work)
• Concurrency control (process of ensuring that
  transactions do not interfere with each other)
• Database recovery (the process of restoring the
  database to its correct state after an error)

12
Programmatic SQL

• SQL is now the standard language used to access
  data in a database. However, SQL lacks
  computational completeness, which means that it
  lacks (among other things) flow control (IF,
  THEN, ELSE, etc.)
• In this section, we will discuss methods for
  executing SQL statements from high level
  programming languages such as C and Java.

13
Emerging Trends

• We will examine some important developments in
  the world of database management systems
• Data Warehouses
• XML
• Distributed Databases

14
Data Warehousing

• Data Warehouses supply business intelligence to
  organizations. It allows organizations to use
  their data as a strategic asset that can provide
  competitive advantage.
• Topics to be covered include
• Data warehouse concepts and applications
• How Data Warehouses differ from OLTP systems
• The main components of a data warehouse.

15
Semistructured data and XML

• XML has become the de-facto standard for data
  communication on the Web and is having a huge
  impact on many aspects of software development.
  XML is an example of semi-structured data based
  on a model called the object exchange model
  (OEM). In this section, we will discuss
• What semi-structured data is
• OEM concepts
• The major elements of XML and how to construct
  XML documents

16
Trends Distributed Databases

• A Distributed Database Management System (DDBMS)
  is a single logical database that is implemented
  across multiple physical instances, or fragments.
  In this section, we will discuss
• The need for DDBMS
• Advantages and disadvantages of DDBMS as well as
  implementation issues
• Functions to be provided by a DDBMS
• Distributed Database architecture