Integrating and querying web databases and documents

There exist many interrelated information sources on the Internet that can be categorized into structured (database) and semistructured (documents). A key challenge is to integrate, query and analyze such heterogeneous collections of information. In this paper, we defend the idea of building web metadata repositories using relational databases as the main source and central data management technology of structured data, enriched by the semistructured data surrounding it. Our proposal rests on the assumption that heterogeneous relational databases can be integrated (i.e. entity resolution is assumed to work well) and thus can serve as references for external data. That is, we tackle the problem of integrating information in the deep web, departing from databases. We discuss a prototype system that can integrate and query metadata and related documents, based on relational database technology. Metadata includes database ER model elements like database name, table, and column (entity, at...

• Type: Journal
• Year: 2011
• Where: CIKM
• Authors: Carlos Garcia-Alvarado, Carlos Ordonez
• Keywords: Central Data Management, CIKM 2011, Information Storage And Retrieval, Information Technology, Relational Database Technology