![]()
![]() |
| 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 |