JCL

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:lectures:06

This is an old revision of the document!


LE06: 20/03/2020

Master in Informatics and Computing Engineering
Database and Web Applications Laboratory
Instance: 2019/2020


Lecture #6 :: 20/03/2020

Goals

By the end of this class, the student should be able to:

  • Describe how to implement data business rules using SQL
  • Describe how to maintain consistency of the database in the presence of concurrent accesses
  • Write database user-defined functions

Content

  1. SQL integrity constraints (recap)
    • Key Constraints.
    • Foreign key constraints.
    • Attribute constraints.
    • Tuple constraints.
    • SQL-3 Triggers.
  2. Constraints in PostgreSQL.
  3. Triggers in PostgreSQL.
  4. Transactions and recovery
    • Transactions.
    • ACID properties.
    • Atomicity of transactions.
    • PostgreSQL and Multiversion Concurrency Control.
  5. Database Store procedures
    • User-defined functions in PostgreSQL.

Bibliography

  • R. Ramakrishnan, J. Gehrke. Database Management Systems. McGRAW-Hill International Editions, 3rd Edition, 2003, ISBN=0-07-246563-8
  • The PostgreSQL Global Development Group. PostgreSQL 9.4 Documentation. 13th February 2020. Online in http://www.postgresql.org/docs/9.4/static/, last accessed on March 2020

Materials

Summary

  • Integrity Constraints in SQL, assertions and triggers. Transactions, ACID properties, Concurrency Control. Database stored procedures.1)

LBAW, 2019/20

« Previous | Index | Next »

1)
Implementação de Restrições de integridade em SQL: de chave, referenciais, de domínio, baseadas em atributos e baseadas em tuplos; asserções; gatilhos. Transações, propriedades ACID, controlo de concorrência. Procedimentos na base de dados.
teach/lbaw/lectures/06.1585338365.txt.gz · Last modified: 27/03/2020 19:46 by Correia Lopes