Functional Dependency Generation and Applications in Pay-As-You-Go Data Integration Systems

Recently, the opportunity of extracting structured data from the Web has been identified by a number of research projects. One such example is that millions of relational-style HTML tables can be extracted from the Web. Traditional data integration approaches do not scale over such corpora with hundreds of small tables in one domain. To solve this problem, previous work has proposed pay-as-you-go data integration systems to provide, with little up-front cost, base services over loosely-integrated informa- tion. One key component of such systems, which has received little attention to date, is the need for a framework to gauge and improve the quality of the integration. We propose a frame- work based on functional dependencies(FDs). Unlike in tradi- tional database design, where FDs are specified as statements of truth about all possible instances of the database; in web envi- ronment, FDs are not specified over the data tables. Instead, we generate FDs by counting-based algorithms over many data sources, and extend the FDs with probabilities to capture the in- herent uncertainties in them. Given these probabilistic FDs, we show how to solve two problems to improve data and schema qual- ity in a pay-as-you-go system: (1) pinpointing dirty data sources and (2) normalizing large mediated schemas. We describe these techniques and evaluate them over real-world data sets extracted from the Web.