Description: Intermediate-level design and implementation of database systems, building on topics studied in INLS 523. Additional topics include MySQL, indexing, XML, and non-text databases.

Textbooks:

Fundamentals of Database Systems (2004)
Elmasri, R. & Navathe, S.

Database Management Systems (2002)
Ramakrishnan, Raghu, & Gehrke, Johannes

::: See bookshelf for all texts :::

Concepts:

  • Introduction and Database Design
  • SQL and MySQL
    • Constraints
    • Assertions
    • Triggers
  • DB Tuning
    • Nondense vs. Dense Indexing
    • Primary, Clustering, Secondary, Multilevel Indexes
    • B+ Tree
    • Disk Storage, Basic File Structures, Hashing
  • DB Application Development and Internet Applications
    • Dynamic SQL, Embedded SQL, SQLJ, Stored Procedures
    • Three-Tier Application Architecture
  • XML
    • DTD, Quantifiers, XSL, XML Schema, XSLFO, XQuery, XPath
  • Data Mining
  • Non-text Databases