Database Technology

Code	11474
Year	1
Semester	S1
ECTS Credits	6
Workload	PL(30H)/T(30H)
Scientific area	Informatics
Entry requirements	Skills on algorithms development and codification. (Skills on) Data modeling and database applications development.
Learning outcomes	The main objectives of this course unit are to consolidate the knowledge acquired during the course unit of databases, namely in terms of Structured Query Language (SQL) and database modeling, as well as to present and explore the technologies related to this particular field of computer science. At the end of this course unit the student should be able to: install and manage several database management systems; model a database from the analysis of the requirements and define it using SQL; structure complex queries in SQL; take advantage of the various technologies by provided by database management systems and use them with ease, understanding their underlying mechanisms; quickly develop a prototype for database applications, including Web applications; interconnect database management systems with applications developed in procedural or object-oriented programming languages.
Syllabus	1. Entity-relationship model and relational model. Database management systems architectures. 2. Data storage. 3. Data organization in files and indexes. 4. Indexes structured as a B+ tree. 5. Hash based indexes. 6. Hypertext Preprocessor (PHP) language and database web applications. 7. Security and authorization in database management systems and in web applications. 8. Transactions processing. 9. Query optimization. 10. Parallel database management systems.
Main Bibliography	Main Bibliography: 1) R. Ramakrishnan and J. Gehrke, Database Management Systems, McGraw-Hill, 3th Edition, 2007. 2) Feliz Gouveia, Fundamentos de Bases de Dados, FCA, 2014. Other References: 1) José Luís Pereira, Tecnologias de Bases de Dados, FCA - Editora de Informática, 3ª Edição. 2) Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Miscer and Victor Isakov, Microsoft SQL Server 2005 - Administrator''s Companion, Microsoft Press, 2007. 3) T. Connoly and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, Pearson, 6th Eition, 2014. 4) G. Simsion, Data Modeling Essentials, Van Nostrand Reinhold, 1994. 5) R. Riordan, Designing Relational Database Systems, Redmond, 2001. 6) J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufmann, 1993. 7) J. Dunham, Database Performance Tunning Handbook, McGraw-Hill,1998. 8) W. Inmon, Building the Data Warehouse, Wiley & Sons, 1996.
Language	Portuguese. Tutorial support is available in English.