{"id":"https://openalex.org/W2140422321","doi":"https://doi.org/10.1109/icde.2002.994699","title":"Sequenced subset operators: definition and implementation","display_name":"Sequenced subset operators: definition and implementation","publication_year":2003,"publication_date":"2003-06-25","ids":{"openalex":"https://openalex.org/W2140422321","doi":"https://doi.org/10.1109/icde.2002.994699","mag":"2140422321"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2002.994699","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2002.994699","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 18th International Conference on Data Engineering","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/A5017313006","display_name":"JACK H. DUNN","orcid":null},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"J. Dunn","raw_affiliation_strings":["Department of Computer Science, University of Arizona Tucson, Tucson, USA","[Dept. of Comput. Sci., Arizona Univ., Tucson, AZ, USA]"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Arizona Tucson, Tucson, USA","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"[Dept. of Comput. Sci., Arizona Univ., Tucson, AZ, USA]","institution_ids":["https://openalex.org/I138006243"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057364340","display_name":"Sean Davey","orcid":"https://orcid.org/0000-0003-3710-0278"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"S. Davey","raw_affiliation_strings":["Department of Computer Science, University of Arizona Tucson, Tucson, USA","The University of Arizona,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Arizona Tucson, Tucson, USA","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"The University of Arizona,","institution_ids":["https://openalex.org/I138006243"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029312970","display_name":"Anne Descour","orcid":null},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"A. Descour","raw_affiliation_strings":["Department of Computer Science, University of Arizona Tucson, Tucson, USA","The University of Arizona,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Arizona Tucson, Tucson, USA","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"The University of Arizona,","institution_ids":["https://openalex.org/I138006243"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058823251","display_name":"Richard T. Snodgrass","orcid":"https://orcid.org/0000-0003-4703-7460"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"R.T. Snodgrass","raw_affiliation_strings":["Department of Computer Science, University of Arizona Tucson, Tucson, USA","The University of Arizona,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Arizona Tucson, Tucson, USA","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"The University of Arizona,","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5017313006"],"corresponding_institution_ids":["https://openalex.org/I138006243"],"apc_list":null,"apc_paid":null,"fwci":0.2483,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.66693585,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"tr 62","issue":null,"first_page":"81","last_page":"92"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9897000193595886,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.7694905400276184},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.752627968788147},{"id":"https://openalex.org/keywords/intersection","display_name":"Intersection (aeronautics)","score":0.7522667646408081},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6767899394035339},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6611058712005615},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.5771074295043945},{"id":"https://openalex.org/keywords/fragment","display_name":"Fragment (logic)","score":0.5286408066749573},{"id":"https://openalex.org/keywords/argument","display_name":"Argument (complex analysis)","score":0.524928629398346},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.46679410338401794},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4100801348686218},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30134516954421997},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2736331820487976},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2639922499656677},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23312193155288696}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7694905400276184},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.752627968788147},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.7522667646408081},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6767899394035339},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6611058712005615},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.5771074295043945},{"id":"https://openalex.org/C2776235265","wikidata":"https://www.wikidata.org/wiki/Q18392052","display_name":"Fragment (logic)","level":2,"score":0.5286408066749573},{"id":"https://openalex.org/C98184364","wikidata":"https://www.wikidata.org/wiki/Q1780131","display_name":"Argument (complex analysis)","level":2,"score":0.524928629398346},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.46679410338401794},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4100801348686218},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30134516954421997},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2736331820487976},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2639922499656677},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23312193155288696},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","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/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.2002.994699","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2002.994699","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings 18th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.129.2595","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.129.2595","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.arizona.edu/~rts/pubs/ICDE02.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4300000071525574,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W136079928","https://openalex.org/W1485737125","https://openalex.org/W1504193486","https://openalex.org/W1531918044","https://openalex.org/W1549387132","https://openalex.org/W1554917839","https://openalex.org/W1556801821","https://openalex.org/W1589223644","https://openalex.org/W1592371320","https://openalex.org/W1735558737","https://openalex.org/W1986739594","https://openalex.org/W2000616942","https://openalex.org/W2015372451","https://openalex.org/W2019485818","https://openalex.org/W2067481201","https://openalex.org/W2098372784","https://openalex.org/W2102023823","https://openalex.org/W2158237121","https://openalex.org/W2161484642","https://openalex.org/W6605629383","https://openalex.org/W6635576446","https://openalex.org/W6655213885"],"related_works":["https://openalex.org/W2488852078","https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W1966967794","https://openalex.org/W650102067","https://openalex.org/W2397450670"],"abstract_inverted_index":{"Difference,":[0],"intersection,":[1],"semi":[2],"join":[3],"and":[4,34,39,43,48,66,141,156,184],"anti-semi-join":[5],"may":[6],"be":[7,175],"considered":[8],"binary":[9],"subset":[10,18,77],"operators,":[11],"in":[12,54,82,90,118,125,148,153,177],"that":[13,126,171,186],"they":[14,58,127,187],"all":[15],"return":[16],"a":[17,102,119,193],"of":[19,52],"their":[20,149],"left-hand":[21,131],"argument.":[22],"These":[23,93,121],"operators":[24,116,122,165],"are":[25,59,84,96,123,188],"useful":[26],"for":[27,86,162],"implementing":[28,87,163],"SQL's":[29,63],"EXCEPT,":[30],"INTERSECT,":[31],"NOT":[32,35,107],"IN":[33],"EXISTS,":[36],"distributed":[37],"queries":[38],"referential":[40],"integrity.":[41],"Difference-all":[42],"intersection-all":[44],"operate":[45],"on":[46],"multi-sets":[47],"track":[49],"the":[50,76,130,138,168],"number":[51],"duplicates":[53],"both":[55],"argument":[56],"relations;":[57],"used":[60],"to":[61,113],"implement":[62,114],"EXCEPT":[64],"ALL":[65],"INTERSECT":[67],"ALL.":[68],"Their":[69],"temporally":[70],"sequenced":[71],"analogues,":[72],"which":[73],"effectively":[74],"apply":[75],"operator":[78],"at":[79,100],"each":[80],"point":[81],"time,":[83],"needed":[85],"these":[88,115,164,182],"constructs":[89],"temporal":[91,154],"databases.":[92],"SQL":[94],"expressions":[95],"complex;":[97],"most":[98],"necessitate":[99],"least":[101],"three-way":[103],"join,":[104],"with":[105],"nested":[106],"EXISTS":[108],"clauses.":[109],"We":[110,158,180],"consider":[111],"how":[112],"directly":[117],"DBMS.":[120],"interesting":[124],"can":[128],"fragment":[129],"validity":[132],"periods":[133],"(sequenced":[134],"difference-all":[135],"also":[136],"fragments":[137,172],"right-hand":[139],"periods)":[140],"thus":[142],"introduce":[143,159],"memory":[144],"complications":[145],"found":[146],"neither":[147],"non-temporal":[150],"counterparts":[151],"nor":[152],"joins":[155],"semijoins.":[157],"novel":[160],"algorithms":[161,183],"by":[166],"ordering":[167],"computation":[169],"so":[170],"need":[173],"not":[174],"retained":[176],"main":[178],"memory.":[179],"evaluate":[181],"demonstrate":[185],"no":[189],"more":[190],"expensive":[191],"than":[192],"single":[194],"conventional":[195],"join.":[196]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}