Integrating Unstructured Data into Relational Databases

In this paper we present a system for automatically integrating unstructured text into a multi-relational database using state-of-the-art statistical models for structure extraction and matching. We show how to extend current highperforming models, Conditional Random Fields and their semi-markov counterparts, to effectively exploit a variety of recognition clues available in a database of entities, thereby significantly reducing the dependence on manually labeled training data. Our system is designed to load unstructured records into columns spread across multiple tables in the database while resolving the relationship of the extracted text with existing column values, and preserving the cardinality and link constraints of the database. We show how to combine the inference algorithms of statistical models with the database imposed constraints for optimal data integration.

• Type: Conference
• Year: 2006
• Where: ICDE
• Authors: Imran R. Mansuri, Sunita Sarawagi
• Keywords: Database, Database Imposed Constraints, ICDE 2006, State-of-the-art Statistical Models, Unstructured Text