Sumários

Introduction to Data Integration

27 setembro 2018, 15:30 • Diogo Ribeiro Ferreira

Data sources. Schema matching. Mediated schema as a set of global views. Schema mappings with SQL union operator and SQL views. Wrappers for data sources. Problems in data matching.

Data Integration: Query Expressions

27 setembro 2018, 14:30 • Helena Galhardas

Query reformulation component of a virtual data integration system:

  • Query expressions in SQL 
  • Query expressions in Datalog - conjunctive queries, Datalog rules, disjunction in Datalog, query unfolding
  • Mapping the mediated schema in terms of the local schema through query expressions 
  • Notions of query equivalence and query containment.

Lab 2

27 setembro 2018, 14:00 • Diogo Ribeiro Ferreira

Lab guide about SQL views and data integration.

Lab 2

27 setembro 2018, 12:30 • Diogo Ribeiro Ferreira

Lab guide about SQL views and data integration.

Guide Labs 1 and 2: SQL Review and SQL Views

25 setembro 2018, 15:30 • João Pedro Lebre Magalhães Pereira

Resolution of the laboratory guides 1 and 2:

  • SQL Review: recalling the syntax of SQL queries
  • SQL Views: how to create and execute SQL views.