Intendierte Lernergebnisse
Students understand and know advanced database technologiesare able to use advance database technologies for the development of information systems and other applicationsare able to design, operate and maintain large database systems.
Lehrmethodik
Lectures with student presentations and associated lab exercises, and group discussions. Active participation is required.
Inhalt/e
This course complements course 621.510 taking a practical perspective.Topics include: Advanced logical and physical Database designDatabase evolution and support of agile software developmentDatabases on new hardwareTuning of Database systemsData mining essentialsOLAP in Data warehousesTemporal databasesInformation retrieval and Search engines, PageRank
Erwartete Vorkenntnisse
A first course in Databases, in particular:Entity-Relationship model and UML class diagramsRelational modelNormalizationIndexesSQL and Database programmingXML, XML-Schema, XQueryBasic transaction models