{"id":"https://openalex.org/W2139725577","doi":"https://doi.org/10.1109/time.2002.1027478","title":"Index based processing of semi-restrictive temporal joins","display_name":"Index based processing of semi-restrictive temporal joins","publication_year":2003,"publication_date":"2003-06-25","ids":{"openalex":"https://openalex.org/W2139725577","doi":"https://doi.org/10.1109/time.2002.1027478","mag":"2139725577"},"language":"en","primary_location":{"id":"doi:10.1109/time.2002.1027478","is_oa":false,"landing_page_url":"https://doi.org/10.1109/time.2002.1027478","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings Ninth International Symposium on Temporal Representation and Reasoning","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101882847","display_name":"Donghui Zhang","orcid":"https://orcid.org/0000-0002-4450-4716"},"institutions":[{"id":"https://openalex.org/I103635307","display_name":"University of California, Riverside","ror":"https://ror.org/03nawhv43","country_code":"US","type":"education","lineage":["https://openalex.org/I103635307"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Donghui Zhang","raw_affiliation_strings":["Computer Science Department, University of California, Riverside, CA, USA","Dept. of Comput. Sci., California, Univ., Riverside, CA, USA"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of California, Riverside, CA, USA","institution_ids":["https://openalex.org/I103635307"]},{"raw_affiliation_string":"Dept. of Comput. Sci., California, Univ., Riverside, CA, USA","institution_ids":["https://openalex.org/I103635307"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000947547","display_name":"Vassilis J. Tsotras","orcid":"https://orcid.org/0000-0001-5462-9451"},"institutions":[{"id":"https://openalex.org/I103635307","display_name":"University of California, Riverside","ror":"https://ror.org/03nawhv43","country_code":"US","type":"education","lineage":["https://openalex.org/I103635307"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"V.J. Tsotras","raw_affiliation_strings":["Computer Science Department, University of California, Riverside, CA, USA","Dept. of Comput. Sci., California, Univ., Riverside, CA, USA"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of California, Riverside, CA, USA","institution_ids":["https://openalex.org/I103635307"]},{"raw_affiliation_string":"Dept. of Comput. Sci., California, Univ., Riverside, CA, USA","institution_ids":["https://openalex.org/I103635307"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5101882847"],"corresponding_institution_ids":["https://openalex.org/I103635307"],"apc_list":null,"apc_paid":null,"fwci":0.5928,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.69873728,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"5","issue":null,"first_page":"70","last_page":"77"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.9165551066398621},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7398399114608765},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.691548228263855},{"id":"https://openalex.org/keywords/intersection","display_name":"Intersection (aeronautics)","score":0.6342300772666931},{"id":"https://openalex.org/keywords/rectangle","display_name":"Rectangle","score":0.6308115124702454},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.5966794490814209},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5001411437988281},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4967091679573059},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4644332826137543},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.44972917437553406},{"id":"https://openalex.org/keywords/interval","display_name":"Interval (graph theory)","score":0.4480552673339844},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.43496188521385193},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4064105153083801},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34595176577568054},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23153600096702576},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12966656684875488},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11429309844970703}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9165551066398621},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7398399114608765},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.691548228263855},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.6342300772666931},{"id":"https://openalex.org/C2781302577","wikidata":"https://www.wikidata.org/wiki/Q209","display_name":"Rectangle","level":2,"score":0.6308115124702454},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.5966794490814209},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5001411437988281},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4967091679573059},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4644332826137543},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.44972917437553406},{"id":"https://openalex.org/C2778067643","wikidata":"https://www.wikidata.org/wiki/Q166507","display_name":"Interval (graph theory)","level":2,"score":0.4480552673339844},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.43496188521385193},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4064105153083801},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34595176577568054},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23153600096702576},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12966656684875488},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11429309844970703},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/time.2002.1027478","is_oa":false,"landing_page_url":"https://doi.org/10.1109/time.2002.1027478","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings Ninth International Symposium on Temporal Representation and Reasoning","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.132.9857","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.132.9857","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.ccs.neu.edu/home/donghui/publications/tempjoin2.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.20.6531","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.20.6531","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucr.edu/~donghui/publications/tempjoin2.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.9.3077","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.9.3077","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucr.edu/~tsotras/time02.ps","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6899999976158142,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W41774791","https://openalex.org/W91532282","https://openalex.org/W1543685746","https://openalex.org/W1554228447","https://openalex.org/W1721621563","https://openalex.org/W1844522501","https://openalex.org/W1975487496","https://openalex.org/W2055385473","https://openalex.org/W2058903936","https://openalex.org/W2102023823","https://openalex.org/W2103465290","https://openalex.org/W2103830868","https://openalex.org/W2111399468","https://openalex.org/W2114270519","https://openalex.org/W2133541526","https://openalex.org/W2142759652","https://openalex.org/W2144402047","https://openalex.org/W2151135734","https://openalex.org/W2152301310","https://openalex.org/W2154322583","https://openalex.org/W2155322254","https://openalex.org/W2159654041","https://openalex.org/W2169057819","https://openalex.org/W2172031037","https://openalex.org/W4236976055","https://openalex.org/W6601735461","https://openalex.org/W6603691434","https://openalex.org/W6632537009","https://openalex.org/W6632827169","https://openalex.org/W6637577753","https://openalex.org/W6675634014","https://openalex.org/W6680373199","https://openalex.org/W6681779468","https://openalex.org/W6685266825"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W650102067","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W1966967794","https://openalex.org/W2172084996"],"abstract_inverted_index":{"Temporal":[0],"joins":[1],"are":[2,61,90,134,163,185],"important":[3],"but":[4],"very":[5],"costly":[6],"operations.":[7],"While":[8],"a":[9,180],"temporal":[10,107,118,220,228],"join":[11,28,129,190,195,244],"can":[12,197,236],"involve":[13],"the":[14,22,27,36,41,53,80,85,93,98,128,131,136,159,171,175,189,239],"whole":[15,37],"time":[16,101],"(and/or":[17],"key)":[18],"domain,":[19],"we":[20,103],"consider":[21],"more":[23],"general":[24],"case":[25],"where":[26],"is":[29,43,109,123,142,191,212,225],"defined":[30],"by":[31,97,227],"some":[32],"time-key":[33,137,160],"rectangle":[34,161],"from":[35],"space":[38],"(i.e.,":[39],"when":[40,78],"user":[42],"interested":[44],"in":[45,174,179],"joining":[46],"portions":[47],"of":[48,209,243],"the-usually":[49],"large-temporal":[50],"data).":[51],"In":[52],"most":[54],"restrictive":[55],"join,":[56,182],"objects":[57,132,157],"(within":[58],"this":[59,168,210],"rectangle)":[60],"joined":[62],"together":[63],"based":[64],"on":[65,74,152],"key":[66,81],"equality":[67,82],"and":[68,111,241],"interval":[69,86],"intersection.":[70],"This":[71],"paper":[72],"concentrates":[73],"semi-restrictive":[75,117,194],"joins,":[76],"i.e.,":[77],"either":[79],"(equi-join)":[83],"or":[84,205],"intersection":[87],"(time-join)":[88],"predicates":[89],"used.":[91],"Given":[92],"large":[94],"relations":[95],"created":[96],"ever":[99],"increasing":[100],"dimension,":[102],"assume":[104],"that":[105,133,213],"each":[106,153],"relation":[108,154],"indexed":[110],"examine":[112],"efficient":[113],"ways":[114],"to":[115,143],"process":[116],"joins.":[119],"Utilizing":[120],"an":[121,145],"index":[122,149],"helpful":[124],"since":[125],"it":[126],"directs":[127],"towards":[130],"within":[135,158],"rectangle.":[138],"A":[139],"straightforward":[140],"approach":[141,169,211],"perform":[144],"unsynchronized":[146],"join.":[147],"An":[148],"selection":[150],"query":[151],"identifies":[155],"all":[156],"which":[162],"then":[164],"joined.":[165],"Although":[166],"simple,":[167],"ignores":[170],"data":[172,221],"distribution":[173],"other":[176],"relation.":[177],"Instead,":[178],"synchronized":[181],"both":[183],"indices":[184,202,215,229],"concurrently":[186],"traversed":[187],"as":[188],"computed.":[192],"Synchronized":[193],"algorithms":[196],"be":[198],"performed":[199],"utilizing":[200],"traditional":[201,214],"like":[203],"B+-trees":[204],"R-trees.":[206],"The":[207],"drawback":[208],"do":[216],"not":[217],"achieve":[218],"good":[219],"clustering.":[222],"Better":[223],"clustering":[224],"achieved":[226],"through":[230],"record":[231,234],"copying.":[232],"Nevertheless,":[233],"copies":[235],"greatly":[237],"affect":[238],"correctness":[240],"effectiveness":[242],"performance.":[245]},"counts_by_year":[{"year":2018,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}