teach:lbaw:202122:lectures:04

Table of Contents

Lecture #4 :: 15/11/2021
- Goals
- Content
- Materials
- Summary

Lecture #4 :: 15/11/2021 §

LBAW · Databases and Web Applications Laboratory, 2021/22
L.EIC · Bachelor in Informatics and Computing Engineering
FEUP and FCUP, U.Porto
— ¶

Goals §

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

Describe the workload of the information system and the performance goals. ¶
Develop the database physical scheme. ¶
Describe possible adjustments to the database to improve performance. ¶
Describe PostgreSQL indexing. ¶
Describe the possible adjustments to the logical schema of the database to improve performance. ¶

Content §

Database Specification ¶
- Indexes | Triggers | User Defined Functions | Transactions | Database Population ¶
PostgreSQL ¶
- Performance Indexes | Full Text Search Indexes ¶
Artefacts ¶
- A6. Indexes, Triggers, Transactions and Database Population ¶

Materials §

Materials presented in class: ¶
- Database Indexes, Triggers and Transactions (A6) (slides) ¶
- André Restivo, Database Indexes (slides) ¶
A6. Indexes, Triggers, Transactions and Database Population ¶

PostgreSQL ¶

Summary §

Database Specification (EBD) Component. ¶
Artefact A6 (Indexes, Triggers, Transactions and Database Population). ¶
Overview of PostgreSQL indexes. ¶

« Previous | Index | Next » ¶

teach/lbaw/202122/lectures/04.txt · Last modified: 2021/11/15 11:41 by ssn