You need to activate javascript for this site.
Menu Conteúdo Rodapé
  1. Home
  2. Courses
  3. Computer Science and Engineering
  4. Database Technology

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.
Teaching Methodologies and Assessment Criteria The contents of this Course Unit are discussed in lecture classes and the practical part of those contents is explored in laboratory classes. Each type of class has two hours of weekly contact. The practical classes have lab guides that students perform in the computers of the lab, which include the usage of several technologies provided by nowadays database management systems, as well as the implementation of database web applications. Moreover, the proposed practical works (individual and group) are designed so that the students develop their technical skills via the development of software applications.

Assessment:
- Practical (10 points): 2 works (4.0 + 4.5) and student participation (1.5)

Frequency:
- Test: 7.5 points
- Theme (2.5 points). Evaluation: 50% teacher, 50% students.

Exam (test): 10 points.
Language Portuguese. Tutorial support is available in English.
Last updated on: 2014-08-07

The cookies used in this website do not collect personal information that helps to identify you. By continuing you agree to the cookie policy.