CS 348: Information Systems

List of Topics:

1. Data modeling: physical, logical and conceptual data models, the entity-relationship model

2. The relational model and relational algebra

3. SQL query language

4. Other relational query languages (QBE and Datalog)

5. Relational database integrity and security

6. Relational database design, functional dependencies, and normalization

7. Object-oriented database systems (fundamentals of object-orientation and models: object structures, objects and classes, generalization and inheritance, multiple inheritance, identity and persistence)

8. Object database languages: persistent C++, the ODMG definition and manipulation languages

9. Object-relational database systems: extensibility features and object orientation in relational systems

10. XML/web databases: semi-structured data, querying, ODBC, JDBC

11. Database system architectures: two-tier (client-server), three-tier, parallel and distributed database architectures

12. Database administration and database tuning

13. Data mining, data warehousing, online analytical processing, and information retrieval

2005.12