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

Database Technology

Code 12565
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.
Mode of delivery Face-to-face instruction, with theoretical and practical classes.
Work placements Not applicable.
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.
Last updated on: 2020-03-10

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