Sumários

NoSQL Databases

25 maio 2018, 09:30 • Bruno Emanuel Da Graça Martins

  • Differences between RDBMSs and NoSQL Databases
  • Properties of NoSQL Systems
  • Typical Applications
    • Web log analysis
    • Social-network graph analysis
    • Querying Wikipedia-like knowledge graphs
  • NoSQL Systems
    • MapReduce
    • Key-value stores and Column stores
    • Document stores
    • Graph database systems

NoSQL Databases

25 maio 2018, 09:30 • Bruno Emanuel Da Graça Martins

  • Differences between RDBMSs and NoSQL Databases
  • Properties of NoSQL Systems
  • Typical Applications
    • Web log analysis
    • Social-network graph analysis
    • Querying Wikipedia-like knowledge graphs
  • NoSQL Systems
    • MapReduce
    • Key-value stores and Column stores
    • Document stores
    • Graph database systems

Not Taught.

25 maio 2018, 08:00 • Diogo Ribeiro Ferreira

The plan for the lab classes is concluded.

Lab 10: Performance Monitoring

22 maio 2018, 12:30 • Diogo Ribeiro Ferreira

Tutorial about performance monitoring with SQL Server using the SQL Profiler tool. Isolating slow-running queries. Generating traces for index tuning.

Distributed Databases

22 maio 2018, 11:00 • Bruno Emanuel Da Graça Martins

  • Distributed DBMS architectures
  • Storing Data in a Distributed DBMS
    • Horizontal Fragmentation
    • Vertical Fragmentation
    • Replication
  • Distributed Catalog Management
  • Distributed Query Processing and Distributed Joins
    • Fetch as Needed
    • Ship to One Site
    • Semijoin
    • Bloomjoin
  • Distributed Query Optimization
  • Updating Distributed Data