Navigation

13E114BP2 - Databases 2

Course specification
Course title Databases 2
Acronym 13E114BP2
Study programme Electrical Engineering and Computing
Module Computer Engineering and Informatics
Type of study bachelor academic studies
Lecturer (for classes)
Lecturer/Associate (for practice)
Lecturer/Associate (for OTC)
ESPB 6.0 Status elective
Condition Databases 1
The goal Extensible Markup Language (XML). Physical Database Design. DB integration.
The outcome Students will be able to use XML, to exploit indexes, views, storage, and other aspects of physical design, and appreciate the need and different possibilities for DB integration.
Contents
URL to the subject page https://teams.microsoft.com/l/team/19%3auRYo_ltOGwX2S1fBhZkdB1ZZIFqgRwmmJrixnAwtOuA1%40thread.tacv2/conversations?groupId=d2b6e64e-693c-4913-9666-c3ceb5700a1f&tenantId=1774ef2e-9c62-478a-8d3a-fd2a495547ba
Contents of lectures Extensible Markup Language (XML). DTD and XML Schemas. XPath. XQuery. Physical Database Design. Indexes. Materialized Views. Partitioning. Multidimensional Clustering. Other methods. DB integration. language-oriented (embedded SQL). driver-oriented (ODBC, JDBC). component-based. SOA integration. Web Services. SOAP. WSDL. UDDI. agent-based
Contents of exercises Design, implement and evaluate object relational DB system, discuss the properties of good DB systems, implement XML queries and select and apply appropriate integration mechanisms.
Literature
  1. Database Systems:The Complete Book, H. Garcia-Molina, J.D.Ulman, J. Widom, Prentice Hall, 2008. (Original title)
  2. Bill Evjen, at all, Professional XML (Programer to Programmer) ISBN-13: 978-0471777779, 2007 (Original title)
  3. Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (The Morgan Kaufmann Series in Data Management Systems) by Sam Lightstone, Toby J. Teorey, and Tom Nadeau (Paperback - Apr 4, 2007) (Original title)
  4. Prabhu C.S.R Object Oriented Database System, Approaches and Architectures, Prentice Hall, 2011. (Original title)
Number of hours per week during the semester/trimester/year
Lectures Exercises OTC Study and Research Other classes
2 2 1
Methods of teaching 30 hours of lectures + 30 hours of supervised problem classes + 15 hours of supervised laboratory classes, midterm tests and project. Approximately 75 hours of personal study and exercise (3 hours per week during semester, and approximately 30 hours of preparation during exam term).
Knowledge score (maximum points 100)
Pre obligations Points Final exam Points
Activites during lectures 0 Test paper 60
Practical lessons 10 Oral examination 0
Projects
Colloquia 20
Seminars 10