Gustavo Alonso: Catalogue data in Spring Semester 2016

Name Prof. Dr. Gustavo Alonso
FieldInformatik
Address
Institut für Computing Platforms
ETH Zürich, STF K 513
Stampfenbachstrasse 114
8092 Zürich
SWITZERLAND
Telephone+41 44 632 73 06
E-mailalonso@inf.ethz.ch
URLhttp://www.inf.ethz.ch/~alonso
DepartmentComputer Science
RelationshipFull Professor

NumberTitleECTSHoursLecturers
252-0063-00LData Modelling and Databases Information 7 credits4V + 2UG. Alonso
AbstractData modelling (ER and UML class diagrams), relational data model, relational design theory (normal forms), SQL, database integrity, security, transactions and data warehousing (OLAP).
ObjectiveIntroduction to relational databases and data management. Basics of SQL programming and transaction management.
ContentThe course covers the basic aspects of the design and implementation of databases and information systems. The courses focuses on relational databases as a starting point but will also cover data management issues beyond databases such as: transactional consistency, replication, data warehousing, other data models, as well as SQL.
LiteratureKemper, Eickler: Datenbanksysteme: Eine Einführung, Oldenbourg Verlag, 5. Auflage, 2004.
252-0817-00LDistributed Systems Laboratory Information
In the Master Programme max. 10 credits can be accounted by Labs
on top of the Interfocus Courses. Additional Labs will be listed on the Addendum.
10 credits9PG. Alonso, F. Mattern, T. Roscoe, R. Wattenhofer
AbstractThis course involves the participation in a substantial development and/or evaluation project involving distributed systems technology. There are projects available in a wide range of areas: from web services to ubiquitous computing including as well wireless networks, ad-hoc networks, and distributed application on mobile phones.
ObjectiveStudents acquire practical knowledge about technologies from the area of distributed systems.
ContentThis course involves the participation in a substantial development and/or evaluation project involving distributed systems technology. There are projects available in a wide range of areas: from web services to ubiquitous computing including as well wireless networks, ad-hoc networks, and distributed application on mobile phones. The objecte of the project is for the students to gain hands-on-experience with real products and the latest technology in distributed systems. There is no lecture associated to the course.
For information of the course or projects available, please contact Prof. Mattern, Prof. Wattenhofer, Prof. Roscoe or Prof. G. Alonso.