View in EDS

O2iJoin: An Efficient Index-Based Algorithm for Overlap Interval Join.

Saved in:
Bibliographic Details
Title: O2iJoin: An Efficient Index-Based Algorithm for Overlap Interval Join.
Authors: Luo, Ji-Zhou1,2 luojizhou@hit.edu.cn, Shi, Sheng-Fei1 shengfei@hit.edu.cn, Yang, Guang1 yg_459478972@qq.com, Wang, Hong-Zhi1 wangzh@hit.edu.cn, Li, Jian-Zhong1 lijzh@hit.edu.cn
Source: Journal of Computer Science & Technology (10009000). Sep2018, Vol. 33 Issue 5, p1023-1038. 16p.
Subjects: Algorithms, Mathematical functions software, XML (Extensible Markup Language), Subroutines (Computer programs)
Abstract: Time intervals are often associated with tuples to represent their valid time in temporal relations, where overlap join is crucial for various kinds of queries. Many existing overlap join algorithms use indices based on tree structures such as quad-tree, B+-tree and interval tree. These algorithms usually have high CPU cost since deep path traversals are unavoidable, which makes them not so competitive as data-partition or plane-sweep based algorithms. This paper proposes an efficient overlap join algorithm based on a new two-layer flat index named as Overlap Interval Inverted Index (i.e., O2i Index). It uses an array to record the end points of intervals and approximates the nesting structures of intervals via two functions in the first layer, and the second layer uses inverted lists to trace all intervals satisfying the approximated nesting structures. With the help of the new index, the join algorithm only visits the must-be-scanned lists and skips all others. Analyses and experiments on both real and synthetic datasets show that the proposed algorithm is as competitive as the state-of-the-art algorithms. [ABSTRACT FROM AUTHOR]
Copyright of Journal of Computer Science & Technology (10009000) is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Database: Engineering Source
FullText Text:
  Availability: 0
Header DbId: egs
DbLabel: Engineering Source
An: 131753653
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 0
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: O2iJoin: An Efficient Index-Based Algorithm for Overlap Interval Join.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Luo%2C+Ji-Zhou%22">Luo, Ji-Zhou</searchLink><relatesTo>1,2</relatesTo><i> luojizhou@hit.edu.cn</i><br /><searchLink fieldCode="AR" term="%22Shi%2C+Sheng-Fei%22">Shi, Sheng-Fei</searchLink><relatesTo>1</relatesTo><i> shengfei@hit.edu.cn</i><br /><searchLink fieldCode="AR" term="%22Yang%2C+Guang%22">Yang, Guang</searchLink><relatesTo>1</relatesTo><i> yg_459478972@qq.com</i><br /><searchLink fieldCode="AR" term="%22Wang%2C+Hong-Zhi%22">Wang, Hong-Zhi</searchLink><relatesTo>1</relatesTo><i> wangzh@hit.edu.cn</i><br /><searchLink fieldCode="AR" term="%22Li%2C+Jian-Zhong%22">Li, Jian-Zhong</searchLink><relatesTo>1</relatesTo><i> lijzh@hit.edu.cn</i>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22Journal+of+Computer+Science+%26+Technology+%2810009000%29%22">Journal of Computer Science & Technology (10009000)</searchLink>. Sep2018, Vol. 33 Issue 5, p1023-1038. 16p.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Algorithms%22">Algorithms</searchLink><br /><searchLink fieldCode="DE" term="%22Mathematical+functions+software%22">Mathematical functions software</searchLink><br /><searchLink fieldCode="DE" term="%22XML+%28Extensible+Markup+Language%29%22">XML (Extensible Markup Language)</searchLink><br /><searchLink fieldCode="DE" term="%22Subroutines+%28Computer+programs%29%22">Subroutines (Computer programs)</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: Time intervals are often associated with tuples to represent their valid time in temporal relations, where overlap join is crucial for various kinds of queries. Many existing overlap join algorithms use indices based on tree structures such as quad-tree, B+-tree and interval tree. These algorithms usually have high CPU cost since deep path traversals are unavoidable, which makes them not so competitive as data-partition or plane-sweep based algorithms. This paper proposes an efficient overlap join algorithm based on a new two-layer flat index named as Overlap Interval Inverted Index (i.e., O2i Index). It uses an array to record the end points of intervals and approximates the nesting structures of intervals via two functions in the first layer, and the second layer uses inverted lists to trace all intervals satisfying the approximated nesting structures. With the help of the new index, the join algorithm only visits the must-be-scanned lists and skips all others. Analyses and experiments on both real and synthetic datasets show that the proposed algorithm is as competitive as the state-of-the-art algorithms. [ABSTRACT FROM AUTHOR]
– Name: AbstractSuppliedCopyright
  Label:
  Group: Ab
  Data: <i>Copyright of Journal of Computer Science & Technology (10009000) is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.)
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=131753653
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.1007/s11390-018-1872-x
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 16
        StartPage: 1023
    Subjects:
      – SubjectFull: Algorithms
        Type: general
      – SubjectFull: Mathematical functions software
        Type: general
      – SubjectFull: XML (Extensible Markup Language)
        Type: general
      – SubjectFull: Subroutines (Computer programs)
        Type: general
    Titles:
      – TitleFull: O2iJoin: An Efficient Index-Based Algorithm for Overlap Interval Join.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Luo, Ji-Zhou
      – PersonEntity:
          Name:
            NameFull: Shi, Sheng-Fei
      – PersonEntity:
          Name:
            NameFull: Yang, Guang
      – PersonEntity:
          Name:
            NameFull: Wang, Hong-Zhi
      – PersonEntity:
          Name:
            NameFull: Li, Jian-Zhong
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 09
              Text: Sep2018
              Type: published
              Y: 2018
          Identifiers:
            – Type: issn-print
              Value: 10009000
          Numbering:
            – Type: volume
              Value: 33
            – Type: issue
              Value: 5
          Titles:
            – TitleFull: Journal of Computer Science & Technology (10009000)
              Type: main
ResultId 1