ECS 165B: Database Systems

Subject
ECS 165B
Title
Database Systems
Status
Active
Units
4.0
Effective Term
2019 Winter Quarter
Learning Activities
Lecture: 3 hours
Discussion: 1 hour
Description
Data modeling (object-relational, graph-based, spatiotemporal models). Querying semistructured data (XML). Database theory (normalization, integration, provenance). Database programming (stored procedures, embedded SQL, web programming). Advanced topics (data warehousing, parallel data processing). GE Prior to Fall 2011: SciEng. GE: SE.
Prerequisites
ECS 165A; (ECS 060 or ECS 034 or ECS 036C)
Enrollment Restrictions
Pass One open to Computer Science and Computer Science Engineering Majors only.

Summary of Course Content

  1. Data Modeling
    1. E/R alternatives: UML, Object-Role Modeling (ORM)
    2. Object-oriented and object-relational models
    3. Graph-based models
    4. Temporal and spatial models
    5. Metadata, data quality, data curation
  2. Semistructured Data on the Web (XML)
    1. XML DTDs, XML-Schema
    2. Querying XML: XPath, XQuery, XSLT
  3. Database Theory
    1. Normalization: functional dependencies, multivalued dependencies, BCNF
    2. Data integration
    3. Data provenance
  4. Database Programming
    1. Stored procedures
    2. Embedded SQL
    3. Web programming
  5. Selected Advanced Topics
    1. Data warehousing, OLAP
    2. Big data, parallel data processing, cloud databases
    3. NoSQL, linked data
    4. Geographic information systems

Illustrative Reading

  • R. Elmasri and S. Navathe. Fundamentals of Database Systems, 6th edition. Addison-Wesley, 2010 • A. Silberschatz, H. Korth, and S. Sudarshan. Database System Concepts, 6th edition. McGraw-Hill, 2010 • H. Garcia-Molina, J. Ullman, and J. Widom. Database Systems: The Complete Book, 2nd edition. Prentice-Hall, 2008

Potential Course Overlap
None

Course Category

Upper Division