Data on the Web in HTML tables is mostly structured, but we usually do not know the structure in advance. Thus, we cannot directly query for data of interest. We propose a solution to this problem for the case of mostly structured data in the form of HTML tables, based on document-independent extraction ontologies. The solution entails elements of table location and table understanding, data integration, and wrapper creation. Table location and understanding allows us to locate the table of interest, recognize attributes and values, pair attributes with values, and form records. Data-integration techniques allow us to match source records with a target schema. Ontologically specified wrappers allow us to extract data from source records into a target schema. Experimental results show that we can successfully map data of interest from source HTML tables with unknown structure to a given target database schema. We can thus "directly" query source data with unknown structure through a known target schema.
College and Department
Physical and Mathematical Sciences; Computer Science
BYU ScholarsArchive Citation
Tao, Cui, "Schema Matching and Data Extraction over HTML Tables" (2003). All Theses and Dissertations. 99.
HTML table, ontology, data extraction, schema matching, document-independent extraction, data-integration techniques