Sumários

Query Expressions and Introduction to Pentaho Data Integration

2 outubro 2018, 15:30 • João Pedro Lebre Magalhães Pereira

  • Resolution of an exercise with query expressions
  • Introduction to Pentaho Data Integration (PDI):
    • Workspace
    • Database Connections
    • Three basic steps: Table Input, Filter Rows, Text file output

Query Expressions and Introduction to Pentaho Data Integration

2 outubro 2018, 14:00 • João Pedro Lebre Magalhães Pereira

  • Resolution of an exercise with query expressions
  • Introduction to Pentaho Data Integration (PDI):
    • Workspace
    • Database Connections
    • Three basic steps: Table Input, Filter Rows, Text file output

Answering Queries using Views and Source Descriptions

1 outubro 2018, 15:30 • Helena Galhardas

  • Answering queries using views:
    • Equivalent rewriting using views
    • Maximally-contained rewriting
  • Source descriptions:
    • Schema mapping languages: 
      • Global-As-View (GAV)
      • Local-as-View (LAV)
      • Advantages and shortcomings

Data Integration - Query Expressions

1 outubro 2018, 15:30 • Diogo Ribeiro Ferreira

Queries and views in logical form. Introduction to Datalog. Data source schemas, mediated schema and schema mapping in Datalog. Query reformulation and unfolding. Redundant and unsatisfiable subgoals. Query containment and equivalence. Exercises.

Query Expressions and Introduction to Pentaho Data Integration

1 outubro 2018, 09:30 • Helena Galhardas

  • Resolution of an exercise with query expressions
  • Introduction to Pentaho Data Integration (PDI):
    • Workspace
    • Database Connections
    • Three basic steps: Table Input, Filter Rows, Text file output