SQL queries with PDI - Lab Guide 3

8 outubro 2018, 09:30 • Helena Galhardas

• How to specify and run SQL queries using PDI transformations
• Resolution of Lab Guide 3.

Answering Queries using Views and Source Descriptions

4 outubro 2018, 15:30 • Diogo Ribeiro Ferreira

Formal definition of containment and equivalence. Answering queries using views (query rewriting). Maximally contained rewriting. GAV schema mapping. Reformulation in GAV (query unfolding). LAV schema mapping. Reformulation in LAV (query rewriting). Exercise. 

Schema matching and mapping

4 outubro 2018, 14:30 • Helena Galhardas

• Challenges of schema matching and mapping
• Schema matching system:
• Matchers
• Combining the results of multiple matchers
• Constraint enforcer
• Match selector

Lab 3

4 outubro 2018, 14:00 • Diogo Ribeiro Ferreira

Lab guide and exercise about implementing SQL queries in an ETL tool.

Lab 3

4 outubro 2018, 12:30 • Diogo Ribeiro Ferreira

Lab guide and exercise about implementing SQL queries in an ETL tool.