{"id":"https://openalex.org/W2039663585","doi":"https://doi.org/10.1145/2247596.2247627","title":"Skyline-sensitive joins with LR-pruning","display_name":"Skyline-sensitive joins with LR-pruning","publication_year":2012,"publication_date":"2012-03-27","ids":{"openalex":"https://openalex.org/W2039663585","doi":"https://doi.org/10.1145/2247596.2247627","mag":"2039663585"},"language":"en","primary_location":{"id":"doi:10.1145/2247596.2247627","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2247596.2247627","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Extending Database Technology","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/A5089871074","display_name":"Mithila Nagendra","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Mithila Nagendra","raw_affiliation_strings":["Arizona State University, Tempe, AZ"],"affiliations":[{"raw_affiliation_string":"Arizona State University, Tempe, AZ","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003070145","display_name":"K. Sel\u00e7uk Candan","orcid":"https://orcid.org/0000-0003-4977-6646"},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"K. Sel\u00e7uk Candan","raw_affiliation_strings":["Arizona State University, Tempe, AZ"],"affiliations":[{"raw_affiliation_string":"Arizona State University, Tempe, AZ","institution_ids":["https://openalex.org/I55732556"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5089871074"],"corresponding_institution_ids":["https://openalex.org/I55732556"],"apc_list":null,"apc_paid":null,"fwci":2.4773,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.91724051,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"252","last_page":"263"},"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.9898999929428101,"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/T10757","display_name":"Geographic Information Systems Studies","score":0.9850000143051147,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/skyline","display_name":"Skyline","score":0.9674100279808044},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7955017685890198},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7650488615036011},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.725022554397583},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.6010016202926636},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5164304375648499},{"id":"https://openalex.org/keywords/pairwise-comparison","display_name":"Pairwise comparison","score":0.5056836605072021},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.45345211029052734},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.43589353561401367},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4220767617225647},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.41466042399406433},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2727157473564148},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.24270731210708618},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1376338005065918},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1077660322189331}],"concepts":[{"id":"https://openalex.org/C2780757406","wikidata":"https://www.wikidata.org/wiki/Q465837","display_name":"Skyline","level":2,"score":0.9674100279808044},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7955017685890198},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7650488615036011},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.725022554397583},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.6010016202926636},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5164304375648499},{"id":"https://openalex.org/C184898388","wikidata":"https://www.wikidata.org/wiki/Q1435712","display_name":"Pairwise comparison","level":2,"score":0.5056836605072021},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.45345211029052734},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.43589353561401367},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4220767617225647},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.41466042399406433},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2727157473564148},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.24270731210708618},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1376338005065918},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1077660322189331},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","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":2,"locations":[{"id":"doi:10.1145/2247596.2247627","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2247596.2247627","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.366.806","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.366.806","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2012-Berlin/papers/edbt/a29-nagendra.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G315729007","display_name":null,"funder_award_id":"1116394","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W320030039","https://openalex.org/W1518543119","https://openalex.org/W1580944449","https://openalex.org/W1972933272","https://openalex.org/W1988823103","https://openalex.org/W2019565841","https://openalex.org/W2047967858","https://openalex.org/W2049153008","https://openalex.org/W2049864887","https://openalex.org/W2053431631","https://openalex.org/W2069027970","https://openalex.org/W2071489941","https://openalex.org/W2115120098","https://openalex.org/W2116396741","https://openalex.org/W2121612399","https://openalex.org/W2123814071","https://openalex.org/W2134644026","https://openalex.org/W2142154682","https://openalex.org/W2144569695","https://openalex.org/W2145277603","https://openalex.org/W2170188482","https://openalex.org/W2171461156","https://openalex.org/W2221612594","https://openalex.org/W2963354545","https://openalex.org/W6634876484","https://openalex.org/W6681412881"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W650102067","https://openalex.org/W2904625095","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W2030931773","https://openalex.org/W259531752","https://openalex.org/W2016456293","https://openalex.org/W1550806730","https://openalex.org/W2967037545"],"abstract_inverted_index":{"Efficient":[0],"processing":[1],"of":[2,9,40,84,192,205],"skyline":[3,18,44,132,185],"queries":[4,133],"has":[5],"been":[6,59],"an":[7,175],"area":[8],"growing":[10],"interest.":[11],"Most":[12],"existing":[13],"techniques":[14,90],"assume":[15],"that":[16,149,201],"the":[17,38,41,43,62,74,82,88,94,140,151,170,184,193,203,206,210],"query":[19,45],"is":[20,29],"applied":[21],"to":[22,37,50,72,80,92,109,130,158,181],"a":[23,143,190],"single":[24],"data":[25,160],"table.":[26],"Unfortunately,":[27],"this":[28,105],"not":[30],"true":[31],"in":[32,78,154,179],"many":[33],"applications":[34],"where,":[35],"due":[36],"complexity":[39],"schema,":[42],"may":[46],"involve":[47],"attributes":[48],"belonging":[49],"multiple":[51,135],"tables.":[52,136,195],"Recently,":[53],"various":[54],"hybrid":[55],"skyline-join":[56,85,117,212],"algorithms":[57,208],"have":[58],"proposed.":[60],"However,":[61],"current":[63],"proposals":[64],"suffer":[65],"from":[66],"several":[67],"drawbacks:":[68],"they":[69],"often":[70],"need":[71],"scan":[73],"input":[75,194],"tables":[76],"exhaustively":[77],"order":[79,180],"obtain":[81],"set":[83],"results;":[86],"moreover,":[87],"pruning":[89,146],"employed":[91],"eliminate":[93],"tuples":[95],"are":[96],"largely":[97],"based":[98],"on":[99],"expensive":[100],"pairwise":[101,165],"tuple-to-tuple":[102],"comparisons.":[103],"In":[104],"paper,":[106],"we":[107],"aim":[108],"address":[110],"these":[111],"shortcomings":[112],"by":[113,187],"proposing":[114],"two":[115],"novel":[116,144],"algorithms,":[118],"namely":[119],"skyline-sensitive":[120,126],"join":[121,127,152],"(S":[122,128],"2J)":[123],"and":[124],"symmetric":[125],"3J),":[129],"process":[131],"over":[134,209],"Our":[137],"approaches":[138],"compute":[139,183],"results":[141,186,200],"using":[142],"layer/region":[145],"technique":[147],"(LR-pruning)":[148],"prunes":[150],"space":[153],"blocks":[155],"as":[156],"opposed":[157],"individual":[159],"points,":[161],"thereby":[162],"avoiding":[163],"excessive":[164],"point-to-point":[166],"dominance":[167],"checks.":[168],"Furthermore,":[169],"S":[171],"3J":[172],"algorithm":[173],"utilizes":[174],"early":[176],"stopping":[177],"condition":[178],"successfully":[182],"accessing":[188],"only":[189],"subset":[191],"We":[196],"report":[197],"extensive":[198],"experimental":[199],"confirm":[202],"advantages":[204],"proposed":[207],"state-of-the-art":[211],"techniques.":[213]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}