Inhalt
[ 862GRWIDENK15 ] KV Data Engineering
|
|
|
|
| (*) Leider ist diese Information in Deutsch nicht verfügbar. |
 |
| Workload |
Ausbildungslevel |
Studienfachbereich |
VerantwortlicheR |
Semesterstunden |
Anbietende Uni |
| 1,5 ECTS |
W2 - Weiterbildung 2 |
Wirtschaftsinformatik |
O.Univ-Prof. Dipl.-Ing. Dr. Christian Stary |
2 SSt |
Johannes Kepler Universität Linz |
|
|
|
| Detailinformationen |
| Quellcurriculum |
Universitätslehrgang Aufbaustudium Angewandtes Wissensmanagement (auslaufend) 2015W |
| Ziele |
(*)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
|
| Lehrinhalte |
(*)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
|
| Beurteilungskriterien |
(*)- Cooperation during course, especially in practical exercises (SQL, XQuery)
- Project Work, Home Exercise
- Final, oral exam
|
| Lehrmethoden |
(*)- 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.
|
| Abhaltungssprache |
Deutsch |
| Literatur |
(*)- 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.
|
| Lehrinhalte wechselnd? |
Nein |
|
|
|
| Präsenzlehrveranstaltung |
| Teilungsziffer |
- |
| Zuteilungsverfahren |
Direktzuteilung |
|
|
|
