{"id":"https://openalex.org/W1978220611","doi":"https://doi.org/10.1145/93597.98740","title":"Randomized algorithms for optimizing large join queries","display_name":"Randomized algorithms for optimizing large join queries","publication_year":1990,"publication_date":"1990-05-01","ids":{"openalex":"https://openalex.org/W1978220611","doi":"https://doi.org/10.1145/93597.98740","mag":"1978220611"},"language":"en","primary_location":{"id":"doi:10.1145/93597.98740","doi":"https://doi.org/10.1145/93597.98740","is_oa":false,"landing_page_url":"https://doi.org/10.1145/93597.98740","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1990 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5084870386","display_name":"Yannis Ioannidis","orcid":"https://orcid.org/0000-0002-1705-8247","observed_orcids":["https://orcid.org/0000-0002-1705-8247"]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Y. E. Ioannidis","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, WI","Computer Sciences Dept., University of Wisconsin, Madison, WI#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, WI","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Computer Sciences Dept., University of Wisconsin, Madison, WI#TAB#","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006921720","display_name":"Younkyung Cha Kang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Younkyung Kang","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, WI","Computer Sciences Dept., University of Wisconsin, Madison, WI#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, WI","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Computer Sciences Dept., University of Wisconsin, Madison, WI#TAB#","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":7.8293,"has_fulltext":false,"cited_by_count":320,"citation_normalized_percentile":{"value":0.97304965,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"312","last_page":"321"},"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.9804999828338623,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9804999828338623,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10100","display_name":"Metaheuristic Optimization Algorithms Research","score":0.004699999932199717,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.002099999925121665,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9409999847412109},{"id":"https://openalex.org/keywords/join-queries","display_name":"join queries","score":0.8569999933242798},{"id":"https://openalex.org/keywords/randomized-algorithms","display_name":"randomized algorithms","score":0.8169999718666077},{"id":"https://openalex.org/keywords/simulated-annealing","display_name":"simulated annealing","score":1.0},{"id":"https://openalex.org/keywords/iterative-improvement","display_name":"iterative improvement","score":0.9929999709129333},{"id":"https://openalex.org/keywords/two-phase-optimization","display_name":"two-phase optimization","score":0.7020000219345093},{"id":"https://openalex.org/keywords/combinatorial-optimization","display_name":"combinatorial optimization","score":0.878000020980835}],"concepts":[{"id":"https://openalex.org/C126980161","wikidata":"https://www.wikidata.org/wiki/Q863783","display_name":"Simulated annealing","level":2,"score":0.7740222215652466},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7326919436454773},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6657253503799438},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5732715725898743},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5223425626754761},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5170729756355286},{"id":"https://openalex.org/C2987595161","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Optimization algorithm","level":2,"score":0.45740771293640137},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.42094337940216064},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3421595096588135},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2528057396411896},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17374801635742188},{"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.1145/93597.98740","doi":"https://doi.org/10.1145/93597.98740","is_oa":false,"landing_page_url":"https://doi.org/10.1145/93597.98740","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1990 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W166430344","https://openalex.org/W1694233656","https://openalex.org/W1981925480","https://openalex.org/W2033368934","https://openalex.org/W2058978608","https://openalex.org/W2081579241","https://openalex.org/W2153329411","https://openalex.org/W2167679350","https://openalex.org/W2170918251","https://openalex.org/W2489748212","https://openalex.org/W4230983477","https://openalex.org/W4238121600","https://openalex.org/W4244215662","https://openalex.org/W4245767046"],"related_works":["https://openalex.org/W194587309","https://openalex.org/W2170918251","https://openalex.org/W2113493270","https://openalex.org/W2064174447","https://openalex.org/W2139177491","https://openalex.org/W1537270633","https://openalex.org/W7097901998","https://openalex.org/W2499287539","https://openalex.org/W2153260071","https://openalex.org/W1981925480"],"abstract_inverted_index":{"Query":[0],"optimization":[1,9,45],"for":[2],"relational":[3],"database":[4],"systems":[5],"is":[6,123],"a":[7,69,104,116,124],"combinatorial":[8],"problem,":[10],"which":[11,122],"makes":[12],"exhaustive":[13,36],"search":[14],"unacceptable":[15],"as":[16,24],"the":[17,44,83,86,90,111,140],"query":[18],"size":[19],"grows.":[20],"Randomized":[21],"algorithms,":[22],"such":[23,95],"Simulated":[25,127],"Annealing":[26,128],"(SA)":[27],"and":[28,97,129,149],"Iterative":[29,130],"Improvement":[30],"(II),":[31],"are":[32],"viable":[33],"alternatives":[34],"to":[35,43],"search.":[37],"We":[38,49],"have":[39,50,81,99],"adapted":[40],"these":[41],"algorithms":[42,142],"of":[46,56,85,126,145],"project-select-join":[47],"queries.":[48],"tested":[51],"them":[52],"on":[53],"large":[54],"queries":[55,96],"various":[57],"types":[58],"with":[59,94,106],"different":[60],"databases,":[61],"concluding":[62],"that":[63,101,135],"in":[64,143],"most":[65],"cases":[66],"SA":[67],"identifies":[68],"lower":[70],"cost":[71,87],"access":[72],"plan":[73],"than":[74],"II.":[75],"To":[76],"explain":[77],"this":[78],"result,":[79],"we":[80,98],"studied":[82],"shape":[84],"function":[88],"over":[89],"solution":[91],"space":[92],"associated":[93],"conjectured":[100],"it":[102],"resembles":[103],"'cup'":[105],"relatively":[107],"small":[108],"variations":[109],"at":[110],"bottom.":[112],"This":[113],"has":[114],"inspired":[115],"new":[117],"Two":[118,136],"Phase":[119,137],"Optimization":[120,138],"algorithm,":[121],"combination":[125],"Improvement.":[131],"Experimental":[132],"results":[133],"show":[134],"outperforms":[139],"original":[141],"terms":[144],"both":[146],"output":[147],"quality":[148],"running":[150],"time.":[151]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":10},{"year":2015,"cited_by_count":10},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":12},{"year":2012,"cited_by_count":13}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}