{"id":"https://openalex.org/W2139177491","doi":"https://doi.org/10.1109/iscis.2009.5291898","title":"Stableness in large join query optimization","display_name":"Stableness in large join query optimization","publication_year":2009,"publication_date":"2009-09-01","ids":{"openalex":"https://openalex.org/W2139177491","doi":"https://doi.org/10.1109/iscis.2009.5291898","mag":"2139177491"},"language":"en","primary_location":{"id":"doi:10.1109/iscis.2009.5291898","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iscis.2009.5291898","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2009 24th International Symposium on Computer and Information Sciences","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/A5055369191","display_name":"Tarcizio Alexandre Bini","orcid":"https://orcid.org/0000-0002-1320-2387"},"institutions":[{"id":"https://openalex.org/I52418104","display_name":"Universidade Federal do Paran\u00e1","ror":"https://ror.org/05syd6y78","country_code":"BR","type":"education","lineage":["https://openalex.org/I52418104"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Tarcizio Alexandre Bini","raw_affiliation_strings":["Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil"],"affiliations":[{"raw_affiliation_string":"Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","institution_ids":["https://openalex.org/I52418104"]},{"raw_affiliation_string":"Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil","institution_ids":["https://openalex.org/I52418104"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046816647","display_name":"Adriano Lange","orcid":null},"institutions":[{"id":"https://openalex.org/I52418104","display_name":"Universidade Federal do Paran\u00e1","ror":"https://ror.org/05syd6y78","country_code":"BR","type":"education","lineage":["https://openalex.org/I52418104"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Adriano Lange","raw_affiliation_strings":["Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil"],"affiliations":[{"raw_affiliation_string":"Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","institution_ids":["https://openalex.org/I52418104"]},{"raw_affiliation_string":"Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil","institution_ids":["https://openalex.org/I52418104"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004821805","display_name":"Marcos Sfair Suny\u00e9","orcid":"https://orcid.org/0000-0002-2568-5697"},"institutions":[{"id":"https://openalex.org/I52418104","display_name":"Universidade Federal do Paran\u00e1","ror":"https://ror.org/05syd6y78","country_code":"BR","type":"education","lineage":["https://openalex.org/I52418104"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marcos Sfair Sunye","raw_affiliation_strings":["Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil"],"affiliations":[{"raw_affiliation_string":"Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","institution_ids":["https://openalex.org/I52418104"]},{"raw_affiliation_string":"Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil","institution_ids":["https://openalex.org/I52418104"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062054732","display_name":"Fabiano Silva","orcid":"https://orcid.org/0000-0001-5453-6175"},"institutions":[{"id":"https://openalex.org/I52418104","display_name":"Universidade Federal do Paran\u00e1","ror":"https://ror.org/05syd6y78","country_code":"BR","type":"education","lineage":["https://openalex.org/I52418104"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Fabiano Silva","raw_affiliation_strings":["Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil"],"affiliations":[{"raw_affiliation_string":"Departmento de Inform\u00e1tica, Universidade Federal do Paran\u00e1, Curitiba, Parana, Brazil","institution_ids":["https://openalex.org/I52418104"]},{"raw_affiliation_string":"Universidade Federal do Paran\u00e1 Departamento de Inform\u00e1tica Curitiba, PR Brazil","institution_ids":["https://openalex.org/I52418104"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5055369191"],"corresponding_institution_ids":["https://openalex.org/I52418104"],"apc_list":null,"apc_paid":null,"fwci":1.0574,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.77276417,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"6","issue":null,"first_page":"639","last_page":"644"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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":0.9998999834060669,"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.9997000098228455,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9966999888420105,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.8267940282821655},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7179117798805237},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.6482743620872498},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.6202656030654907},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5637370944023132},{"id":"https://openalex.org/keywords/stability","display_name":"Stability (learning theory)","score":0.46456944942474365},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4517374634742737},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4417242705821991},{"id":"https://openalex.org/keywords/randomized-algorithm","display_name":"Randomized algorithm","score":0.4285241365432739},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.42367878556251526},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41635650396347046},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3731876015663147},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.3510535955429077},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.286435067653656},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2060340940952301},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.20060554146766663},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.17125576734542847},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.144089937210083},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.10242649912834167},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.07284572720527649}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8267940282821655},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7179117798805237},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6482743620872498},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.6202656030654907},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5637370944023132},{"id":"https://openalex.org/C112972136","wikidata":"https://www.wikidata.org/wiki/Q7595718","display_name":"Stability (learning theory)","level":2,"score":0.46456944942474365},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4517374634742737},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4417242705821991},{"id":"https://openalex.org/C128669082","wikidata":"https://www.wikidata.org/wiki/Q583461","display_name":"Randomized algorithm","level":2,"score":0.4285241365432739},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42367878556251526},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41635650396347046},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3731876015663147},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3510535955429077},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.286435067653656},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2060340940952301},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20060554146766663},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17125576734542847},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.144089937210083},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.10242649912834167},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.07284572720527649},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/iscis.2009.5291898","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iscis.2009.5291898","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2009 24th International Symposium on Computer and Information Sciences","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W35942542","https://openalex.org/W166430344","https://openalex.org/W304606221","https://openalex.org/W1639032689","https://openalex.org/W1978220611","https://openalex.org/W2027837929","https://openalex.org/W2034409909","https://openalex.org/W2066623874","https://openalex.org/W2079329679","https://openalex.org/W2104318946","https://openalex.org/W2153329411","https://openalex.org/W2167679350","https://openalex.org/W2170918251","https://openalex.org/W2293896416","https://openalex.org/W3023540311","https://openalex.org/W3144326055","https://openalex.org/W4285719527","https://openalex.org/W6606780865"],"related_works":["https://openalex.org/W1560919561","https://openalex.org/W2096359267","https://openalex.org/W2554271401","https://openalex.org/W2889903446","https://openalex.org/W2992414350","https://openalex.org/W3125756434","https://openalex.org/W2150741898","https://openalex.org/W185198413","https://openalex.org/W4381740310","https://openalex.org/W2186703450"],"abstract_inverted_index":{"In":[0,118],"relational":[1],"database":[2],"model,":[3],"the":[4,11,20,31,44,69,75,83,92,95,149],"use":[5,32,45,96],"of":[6,19,23,33,46,71,86,97,103,153],"exhaustive":[7],"search":[8,24,35],"methods":[9],"in":[10,49,55,60,110],"large":[12,133],"join":[13,134],"query":[14,50,77,89,135],"optimization":[15,51,99],"is":[16,30,108],"prohibitive":[17],"because":[18],"exponential":[21],"increase":[22,101],"space.":[25],"An":[26],"alternative":[27],"widely":[28],"discussed":[29],"randomized":[34,47,125],"techniques.":[36],"Several":[37],"previous":[38],"researches":[39],"have":[40],"been":[41],"showed":[42],"that":[43],"sampling":[48],"permits":[52],"to":[53,65,132],"find,":[54],"average,":[56],"near":[57],"optimal":[58],"plans":[59,73],"polynomial":[61],"time.":[62,105],"However,":[63],"due":[64],"their":[66],"random":[67],"components,":[68],"quality":[70,150],"yielded":[72],"for":[74],"same":[76],"may":[78,100],"vary":[79],"a":[80,87,124,128],"lot,":[81],"making":[82],"response":[84,104,113],"time":[85,114],"submitted":[88],"unpredictable.":[90],"On":[91],"other":[93],"hand,":[94],"heuristic":[98,129],"stability":[102,152],"This":[106],"characteristic":[107],"essential":[109],"environments":[111],"where":[112],"must":[115],"be":[116],"predicted.":[117],"this":[119],"paper,":[120],"we":[121,147],"will":[122],"compare":[123],"algorithm":[126,130],"and":[127,146,151],"applied":[131],"optimization.":[136],"We":[137],"used":[138],"an":[139],"open":[140],"source":[141],"DBMS":[142],"as":[143],"experimental":[144],"framework":[145],"compared":[148],"these":[154],"algorithms.":[155]},"counts_by_year":[{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}