Syllabus CS 668 Advanced Topics in Database

0. Review of Relational Databases

0.1 Compare Database Models (Relational, Hierarchical, Object Oriented, XML)

0.2 Review SQL

0.3 Review Database Schemas

0.4 Integrity

1. PL/SQL

1.1 Cursors

1.2 Triggers

1.3 Arrays (Tables)

1.4 Functions & Procedures

1.5 Packages

2. Information Modeling with XML

2.1 XHTML, DTD,CSS, XML Schema

2.2 Introduction

2.3 Creating a XML document

2.4 Creating a DTD and validating an XML document

2.5 Working with Schemas

2.6 Working with XSLT

2.7 Working with XPath

2.8 Working with DOM

2.9 XML as a Data Source

3. Native XML Database

3.1 Introduction

3.2 Features

3.3 System Architecture Overview

3.4 Getting Started

3.5 Query Language Extensions

3.6 Application Development

3.7 Technical Background

4. Embedded XML Databases

4.1 Introduction

4.2 A Primer on Embedded Databases

4.3 Embedded XML Databases

4.4 Building Applications for Embedded XML Databases

5. XML and Relational Databases

5.1 Introduction

5.2 Product and Technology Offering Summaries

5.3 Current Architecture and Technology

5.4 Future Architecture and Technology

6. Supporting XML in Oracle

6.1 Introduction

6.2 Storing XML as CLOB

6.3 XMLType

6.4 Using XSU for Fine-Grained Storage

6.5 Building XML Documents from Relational Data

6.6 Web Access to the Database

6.7 Special Oracle Features

7. XML Support in Microsoft SQL Server

7.1 Introduction

7.2 XML and Relational Data

7.3 XML Access to SQL Server

7.4 Serializing SQL Query Results into XML

7.5 Providing Relational Views over XML

7.6 SQLXML Templates

7.7 Providing XML Views over Relational Data

8. A Generic Architecture for Storing XML Documents in a Relational Database

8.1 Introduction

8.2 System Architecture

8.3 The Data Model

8.4 Creating the Database

8.5 Connecting to the Repository

8.6 Uploading XML Documents

8.7 Querying the Repository

Applications of XML

9. Knowledge Management in Bioinformatics

9.1 Introduction

9.2 A Brief Molecular Biology Background

9.3 Life Sciences Are Turning to XML to Model Their Information

9.4 A Genetic Information Model

10. Case Studies of XML

10.1 Introduction

10.2 Case Study 1: “Customer Relations”

10.3 Case Study 2: “Improve Cash Flow”