Inhalt

[ 862GRWIDENK15 ] KV (*)Data Engineering

Versionsauswahl
(*) Unfortunately this information is not available in english.
Workload Education level Study areas Responsible person Hours per week Coordinating university
1,5 ECTS (*)W2 - (*)Weiterbildung 2 Business Informatics O.Univ-Prof. Dipl.-Ing. Dr. Christian Stary 2 hpw Johannes Kepler University Linz
Detailed information
Original study plan Initial study programme Applied Knowledge Management (discontinuing) 2015W
Objectives Successful participants will on completion of the course

  • know the overall process of database design (conceptual design, logical design, physical design)
  • be able to read conceptual designs specified in an object-oriented data model (UML) or similar high-level data models (Entity Relationship Model)
  • be able to design a conceptual schema of a database in an object-oriented data model (UML) or Entity-Relationship Model given a written requirement specification
  • be able to map a conceptual database schema to a logical (or relational) database schema
  • know the basic concepts of the relational data model, as a representative of a frequently used implementation data model
  • be able to query a relational database using SQL
  • know about the concepts of database management systems (DMBS)
  • be able to decide on the use of different storage management facilities to increase performance of queries against a database
  • be able to make elementary physical database design decisions
  • know about concurrency control and recovery mechanisms provided by database management systems to ensure consistency of data
  • know basic concepts of distributed database systems
  • know basic concepts of object-oriented database systems
  • know about current trends in database systems
Subject Database Design and Use:

  • process of database design (conceptual design, logical design, physical design)
  • Unified Modeling Language (UML), Entity Relationship Model (ER)
  • relational data model and SQL

Database Technology:

  • concepts of database management systems (DMBS)
  • storage management (indexes, clustering, … )
  • concurrency control and recovery
  • basic concepts of distributed database systems, object-oriented database systems, active database systems, temporal database systems
Criteria for evaluation
  • Cooperation during course, especially in practical exercises (SQL, XQuery)
  • Project Work, Home Exercise
  • Final, oral exam
Methods
  • Lectures on database design, database technology, and web engineering paired with practical exercises on relational database design and SQL
  • Project work: Build a database and web site for a given case study.
Language German
Study material
  • P. Atzeni, S. Ceri, S. Paraboschi, and R. Torlone, Database Systems: Concepts, Languages and Architectures, McGraw Hill, 1999.
  • R. Elmasri and S. Navathe, Fundamentals of Database Systems, 6th Edition, Prentice Hall, 2010.
  • J. Ullman and J. Widom, A First Course in Database Systems, Prentice-Hall, 2007.
  • B. McLaughlin, Java and XML, 3rd Edition, O’Reilly, 2006.
  • M. Young, XML Step by Step, 2nd Edition, Microsoft Press, 2001.
Changing subject? No
On-site course
Maximum number of participants -
Assignment procedure Direct assignment