13M111SIBP - Software Engineering of Large Databases

Course specification
Course title		Software Engineering of Large Databases
Acronym		13M111SIBP
Study programme		Electrical Engineering and Computing
Module		Software Engineering
Type of study		master academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		asst. MA Tamara Šekularac Obradović, electrical and computer engineer
Lecturer/Associate (for OTC)		asst. MA Tamara Šekularac Obradović, electrical and computer engineer
ESPB		6.0	Status	elective
Condition		Data base management systems
The goal		Understanding the architectures of modern DBMS for large scale databases, different possibilities for their integration and evaluation the different comercial tools
The outcome		Upon successful completion of this course, the student will be able to: • Critically evaluate the different DBMS and their features • Appreciate the need and different possibilities for DB integration • Complete implementation of selected case study from the Experience Repository; • Gain practical experiences on using industry-strength tools.
Contents
Contents of lectures		• DB Taxonomy: DBMS models and architectures; DB aspects (relational, procedural, object-oriented, descriptive (XML), deductive); XML, XPath, XQuery; Persistent objects; DB integrity • DB integration: language-oriented (embedded SQL); driver-oriented (ODBC, JDBC) (architectures, driver types, application scenarios); component-based; SOA integration; Web Services; agent-based
Contents of exercises		• A set of different projects (case studies) organized and supported as an Experience Repository (ER) including case studies from the theoretical parts of the modules • Team work: The student will be organized in teams; The teams select an appropriate project proposal from the ER • Proposal for Case Studies: RDBMS-oriented projects & integration; OODBMS-oriented projects & integration; SOA integration (XML); ER supporting environment; MetricDB • Documentation of the development process
Literature
Bill Evjen, at all, Professional XML (Programer to Programmer) ISBN-13: 978-0471777779, 2007 Web Services: Concepts, Architectures and Applications by Gustavo Alonso, Fabio Casati, Harumi Kuno, and Vijay Machiraju (2010) ISBN 3-540-44008-9 Modern Database Management (10th Edition) by Jeffrey A. Hoffer, V. Ramesh, and Heikki Topi (Hardcover - Jul 29, 2010) 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) Shari Lawrence Pfleeger, Joanne Atlee, Software Engineering: Theory and Practice, 4th edition, Prentice Hall, 2009, ISBN: 0136061699
Number of hours per week during the semester/trimester/year
Lectures	Exercises	OTC	Study and Research	Other classes
2	2	1
Methods of teaching		Instructional methods include classical lectures, class discussions, individual homeworks (small practical projects) and email discussion list.
Knowledge score (maximum points 100)
Pre obligations		Points	Final exam	Points
Activites during lectures		0	Test paper	30
Practical lessons		0	Oral examination	0
Projects
Colloquia		0
Seminars		0