Tópicos Avançados de Bases de Dados

Aulas

• 2ª 10h00m-11h30m (sala S3)
• 3ª 9h00m-10h30m (sala S1)

• 3ª 10h30m-12h00m (sala L4)

• Primeiro Trabalho
• Segundo Trabalho

programa detalhado: disponível no sigarra

Slides apresentados na aula.

Apresentações

• PHP
  • 28/2: PHP: Sandra Soares
• Query Evaluation
  • 12/3: An Overview of Query Optimization in Relational Systems: André Pereira e Artur Alves
  • 12/3: Access Path Selection in a Relational Database Management System : Alison Carvalho e João Luís Monteverde
  • 13/3: Randomized Algorithms for Optimizing Large Join Queries : David Martins and Daniel Martins
  • 13/3: Improved Histograms for Selectivity Estimation of Range Predicates : Nuno Loureiro e Pedro Galvão
• Concurrency Control
  • 19/3: Cap 16 do livro "Transaction Management": Arley Pinto e Gabriel de Jesus
  • 19/3: Cap 17 do livro "Concurrency Control": Carlos Rodrigues e Paulo de Sousa
  • 20/3: Cap 18 do livro "Crash Recovery": Hugo Sousa e José Antunes
  • 20/3: The Transaction Concept, Virtues And Limitations: Davide Nabais e Maria Correia
• 26/3 e 27/3: Semana para aulas
• 2/4, 3/4 e 9/4: Férias da Pascoa
• Distributed DBMS
  • 10/4: R* Optimizer Validation and Performance Evaluation for Distributed Queries.: Ana Dias e Pedro Samuel Amaro Coelho
  • 10/4: Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources.: Carlos Pinto Leite Archer e Eder Moreno (FALTARAM)
• Datalog
  • 16/4: 24.1 até até 24.3 do livro, "Deductive Databases": Mafalda Duarte Freitas e Cátia Marlene Martins da Costa
  • 16/4: 24.4 e 24.5 do livro, "Deductive Databases": Cristiano Monteiro Jesus e Sousa e Hélder Feliciano Almeida da Costa
• XML
  • 17/4: Efficiently Publishing Relational Data as XML Documents: Rui Duarte Alves da Costa e Teresa Isabel Almeida da Costa
  • 17/4: Relational Databases for Querying XML Documents: Limitations and Opportunities: João Pedro Torres Trigo de Mesquita e Nuno Emanuel Santos Teixeira
• Spatial DB
  • 23/4: R-Trees: A Dynamic Index Structure for Spatial Searching.: Goncalo dos Santos Martins e José Carlos de Moura Carvalho
  • 23/4: The R*-Tree: An Efficient and Robust Access Method for Points and Rectangles. : João António Duarte da Graca e Susana Filipa Neves Pedro João
  • 24/4: When Is ''Nearest Neighbor'' Meaningful?: Filipe David Costa Martins e Vítor Daniel Peixoto de Sousa
  • 24/4: High-Performance Generalized Search Trees: Gustavo Barbosa Augusto e Ivan Alexandre Coelho Pinto da Silva
• 30/4: Dia de aulas
• 7/5 e 8/5: Semana académica
• Data Warehousing
  • 14/5: Building the data warehouse : André Manuel Teixeira da Rocha Gaspar e Armindo Eugénio de Sousa Pereira
  • 14/5: An overview of data warehousing and OLAP technology : André Valente Rodrigues e Carlos Filipe Ribeiro Ferreira
• Decision Support
  • 15/5: Implementing Data Cubes Efficiently : Americo José Rodrigues Pereira e Kiran Ali
  • 15/5: Discovery-Driven Exploration of OLAP Data Cubes. : Nuno Miguel Santos Marques e Henrique de Oliveira Alves
• 21/5 e 22/5: Aulas convidadas
• NoSQL
  • 28/5: Bigtable: A Distributed Storage System for Structured Data : Lucio Verdial e Nino Rafael da Silva Rocha
  • 28/5: MongoDB : João Pedro Codeco Proenca e Nuno Miguel Fonseca Peralta
• Data Mining
  • 29/5: Fast Algorithms for Mining Association Rules in Large Databases: Filipe André Abreu Goncalves e Pedro Manuel Pereira Rodrigues
  • 29/5: Mining high-speed data streams.: Pedro Miguel Martins Oliveira
atendimento de alunos: Edifício DCC (Gab. 245)


---

Bibliografia

livro adoptado:

• Database Management Systems (3rd Edition) Raghu Ramakrishnan e Johannes Gehrke, 2003.


links interessantes:


• SIGMOD
• VLDB 2011.
• MySQL.
• ORACLE.
• PostgresSQL.
• SQL Server.
• sybase.
• Concurrency Control and Recovery in Database Systems.

---