• DocumentCode
    1468535
  • Title

    Combining Tag and Value Similarity for Data Extraction and Alignment

  • Author

    Su, Weifeng ; Wang, Jiying ; Lochovsky, Frederick H. ; Liu, Yi

  • Author_Institution
    Comput. Sci. & Technol. Program, BNUHKBU United Int. Coll., Zhuhai, China
  • Volume
    24
  • Issue
    7
  • fYear
    2012
  • fDate
    7/1/2012 12:00:00 AM
  • Firstpage
    1186
  • Lastpage
    1200
  • Abstract
    Web databases generate query result pages based on a user´s query. Automatically extracting the data from these query result pages is very important for many applications, such as data integration, which need to cooperate with multiple web databases. We present a novel data extraction and alignment method called CTVS that combines both tag and value similarity. CTVS automatically extracts data from query result pages by first identifying and segmenting the query result records (QRRs) in the query result pages and then aligning the segmented QRRs into a table, in which the data values from the same attribute are put into the same column. Specifically, we propose new techniques to handle the case when the QRRs are not contiguous, which may be due to the presence of auxiliary information, such as a comment, recommendation or advertisement, and for handling any nested structure that may exist in the QRRs. We also design a new record alignment algorithm that aligns the attributes in a record, first pairwise and then holistically, by combining the tag and data value similarity information. Experimental results show that CTVS achieves high precision and outperforms existing state-of-the-art data extraction methods.
  • Keywords
    Internet; data integration; query processing; CTVS; Web databases; automatic data extraction; data alignment; data integration; query result records; record alignment algorithm; tag similarity; value similarity; Data mining; Databases; HTML; Image color analysis; Web sites; Data extraction; automatic wrapper generation; data record alignment; information integration.;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/TKDE.2011.66
  • Filename
    5728815