Center |
School of Engineering |
Departament |
Computer Science |
Lecturers in charge |
Sin datos cargados |
Met. Docent |
Classes and lab assignments |
Met. Avaluació |
Final exam with questions and problems with a weight of 75% of the mark; the other 25% will be obtained from the mark of lab assignments (mandatory) and practice. |
Bibliografia |
Sistemas de Bases de Datos Ramez A. Elmasri, Shamkant B. Navathe Pearson Educación, 2002 (o edición anterior) LocBiblio: CI 681.3 ELM Introducción a los sistemas de Bases de Datos C. J. Date Pearson Educación, 2001 LocBiblio: CI 681.3.06 DAT Fundamentos de Bases de Datos Abraham Silberschatz, Henry F. Korth, S. Sudarshan McGraw Hill, 2000 LocBiblio: CI 681.3 SIL Database management systems Raghu Ramakrishnan, Johannes Gehrke McGraw Hill, 2003 LocBiblio: CI 681.3.06 RAM |
Continguts |
(Items are more detailed each academic year) 1. Introduction to Database Management Systems. 2. Database application development and data-intensive Internet applications 3. Transaction management 4. Concurrency control techniques 5. Database recovery techniques 6. Security and authorization in databases 7. Query evaluation and optimization 8. DBMS case of study: Oracle 9. Active databases 10. Distributed databases LAB ASSIGNMENTS - Accessing DB with CGI. Embedded SQL - Oracle triggers. PL-SQL. Active databases. - Accessing DB with Java JDBC |
Objetius |
This subject covers the fundamentals of database management systems design, providing the principles and practice of database management systems architecture, functionalities and algorithms used, and also emphasizing how database systems are used in developing data-intensive applications. It also introduces active and distributed databases. |
URL de Fitxa |