Database Systems II (5 cu) Physical data organization in databases. Sequential, hashed and indexed file structures. Query processing and optimization for relational database systems. Join algorithms. Query optimization for distributed databases. Crash recovery. Concurrency control. Transaction management.
Relational Database Design (3 cu) ER model and relational model. Object-oriented models. Integrity constraints and dependencies. Goals of database design. Axiomatizations of functional and inclusion dependencies. Algorithms for manipulating integrity constraints. Transformations between models. Database design by using examples. Generation of example databases. Dependency inference. Performance issues.
Object-Oriented Databases (4 cu) Basic concepts of object data management. Advanced database applications. Extended relational database systems. Objects and types, composite objects, relationships, inheritance. Associative object access. Object calculus. Views. Object storage. Single-level store. Storage of large objects. Indexing. Clustering. Workstation-server architectures. Transaction management. Performance.
Transaction Processing (4 cu) Serializability theory. Locking and non-locking schedulers. Multiversion concurrency control. Centralized and distributed recovery. Management of replicated data. Multidatabase transaction management. Cooperative transaction management. Prototype systems.
User Interfaces (4 cu) Psychological foundations. Types of users, user modelling. Design guidelines. Basic interaction styles and techniques. Formal description of interaction. Special issues: user support, error handling, screen design. Interfaces to some application systems: database systems, hypertext, information exploration. The course includes a laboratory work where a prototype interface is designed and implemented.
Computer-Supported Cooperative Work (3 cu) Concepts and history of CSCW. Advanced electronic mail and news systems. Meeting support systems. Collaborative writing and hypertext. Shared data. Structural properties behind groupware solutions. Workflow principles. Social and organizational aspects.
Knowledge Bases (3 cu) Knowledge representation. Advanced data models and new database systems, including rule-based, object-oriented, and structured text databases. Knowledge-base systems.
Information Retrieval Methods (3 cu) Traditional information retrieval methods. Information filtering. Digital libraries.
Information Systems Development Methodologies (4 cu) Information system life-cycle models. Comparison of methods. Research on development methodologies. SA, SSADM, JSD, IE, OMT, OOSE, OOA and new object oriented methods. Principles of Computer Aided Software Engineering (CASE). Meta CASE, CASE repositories and processing of CASE data.