{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,19]],"date-time":"2025-09-19T07:44:41Z","timestamp":1758267881484},"reference-count":25,"publisher":"Association for Computing Machinery (ACM)","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>A large number of web pages contain data structured in the form of \"lists\". Many such lists can be further split into multi-column tables, which can then be used in more semantically meaningful tasks. However, harvesting relational tables from such lists can be a challenging task. The lists are manually generated and hence need not have well defined templates -- they have inconsistent delimiters (if any) and often have missing information.<\/jats:p>\n          <jats:p>\n            We propose a novel technique for extracting tables from lists. The technique is domain-independent and operates in a fully unsupervised manner. We first use multiple sources of information to split individual lines into multiple fields, and then compare the splits\n            <jats:italic>across<\/jats:italic>\n            multiple lines to identify and fix incorrect splits and bad alignments. In particular, we exploit a corpus of HTML tables, also extracted from the Web, to identify likely fields and good alignments. For each extracted table, we compute an extraction score that reflects our confidence in the table's quality.\n          <\/jats:p>\n          <jats:p>We conducted an extensive experimental study using both real web lists and lists derived from tables on the Web. The experiments demonstrate the ability of our technique to extract tables with high accuracy. In addition, we applied our technique on a large sample of about 100,000 lists crawled from the Web. The analysis of the extracted tables have led us to believe that there are likely to be tens of millions of useful and query-able relational tables extractable from lists on the Web.<\/jats:p>","DOI":"10.14778\/1687627.1687749","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1078-1089","source":"Crossref","is-referenced-by-count":59,"title":["Harvesting relational tables from lists on the web"],"prefix":"10.14778","volume":"2","author":[{"given":"Hazem","family":"Elmeleegy","sequence":"first","affiliation":[{"name":"Purdue University"}]},{"given":"Jayant","family":"Madhavan","sequence":"additional","affiliation":[{"name":"Google Inc."}]},{"given":"Alon","family":"Halevy","sequence":"additional","affiliation":[{"name":"Google Inc."}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872799"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2000.839492"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-2836(87)90316-0"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/366573.366611"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375682"},{"key":"e_1_2_1_6_1","volume-title":"EMNLP-CoNLL","author":"Brants T.","year":"2007","unstructured":"T. Brants , A. C. Popat , P. Xu , F. J. Och , and J. Dean . Large Language Models in Machine Translation . In EMNLP-CoNLL , 2007 . T. Brants, A. C. Popat, P. Xu, F. J. Och, and J. Dean. Large Language Models in Machine Translation. In EMNLP-CoNLL, 2007."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453916"},{"key":"e_1_2_1_8_1","volume-title":"WebDB","author":"Cafarella M. J.","year":"2008","unstructured":"M. J. Cafarella , A. Y. Halevy , Y. Zhang , D. Z. Wang , and E. Wu . Uncovering the Relational Web . In WebDB , 2008 . M. J. Cafarella, A. Y. Halevy, Y. Zhang, D. Z. Wang, and E. Wu. Uncovering the Relational Web. In WebDB, 2008."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/371920.372182"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/511446.511477"},{"key":"e_1_2_1_11_1","volume-title":"VLDB","author":"Crescenzi V.","year":"2001","unstructured":"V. Crescenzi , G. Mecca , and P. Merialdo . RoadRunner: Towards Automatic Data Extraction from Large Web Sites . In VLDB , 2001 . V. Crescenzi, G. Mecca, and P. Merialdo. RoadRunner: Towards Automatic Data Extraction from Large Web Sites. In VLDB, 2001."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.sbi.2006.04.004"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/304182.304223"},{"key":"e_1_2_1_14_1","volume-title":"IJCAI","author":"Kushmerick N.","year":"1997","unstructured":"N. Kushmerick , D. S. Weld , and R. Doorenbos . Wrapper Induction for Information Extraction . In IJCAI , 1997 . N. Kushmerick, D. S. Weld, and R. Doorenbos. Wrapper Induction for Information Extraction. In IJCAI, 1997."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007584"},{"key":"e_1_2_1_16_1","unstructured":"List of Indonesian floral emblems. http:\/\/en.wikipedia.org\/wiki\/List_of_Indonesian_floral_emblems.  List of Indonesian floral emblems. http:\/\/en.wikipedia.org\/wiki\/List_of_Indonesian_floral_emblems."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2000.839475"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454163"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10032-007-0052-2"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-2836(70)90057-4"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1517\/14622416.3.1.131"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.5555\/1613715.1613787"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/775152.775179"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1060745.1060761"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1007\/s11280-007-0022-0"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687627.1687749","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:35:10Z","timestamp":1672227310000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687627.1687749"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":25,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687627.1687749"],"URL":"https:\/\/doi.org\/10.14778\/1687627.1687749","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}