Distributed and Partitioned Join Index

The overall goal of this internship is to improve the query capacity of the Informatica Data Vault data management system. In particular, better support for join operations, that combine the information of various tables of data warehousing appliactions, will be provided. For that, a specialized join index will be designed, developed and evaluated on standard data warehousing queries. The goal is to partition and distribute the index in order to be efficient in terms of storage requirement, query performance and manageability. The improved join performance within the Data Vault architecture will allow for better query performance scalability and predictability. These are crucial for Informatica to address new use cases and improve its capability to play an important role in the areas of Big Data and Internet data.

Faculty Supervisor:

Dr. Bettina Kemme

Student:

Joseph DSilva

Partner:

Informatica

Discipline:

Computer science

Sector:

Information and communications technologies

University:

McGill University