{"id":"https://openalex.org/W4404181043","doi":"https://doi.org/10.14778/3685800.3685860","title":"Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches","display_name":"Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches","publication_year":2024,"publication_date":"2024-08-01","ids":{"openalex":"https://openalex.org/W4404181043","doi":"https://doi.org/10.14778/3685800.3685860"},"language":"en","primary_location":{"id":"doi:10.14778/3685800.3685860","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685860","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5015915659","display_name":"Stefan Halfpap","orcid":"https://orcid.org/0009-0009-3989-261X"},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stefan Halfpap","raw_affiliation_strings":["BIFOLD, TU Berlin, Berlin, Germany"],"affiliations":[{"raw_affiliation_string":"BIFOLD, TU Berlin, Berlin, Germany","institution_ids":["https://openalex.org/I4577782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049531239","display_name":"Jan Kossmann","orcid":"https://orcid.org/0000-0003-1832-7282"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jan Kossmann","raw_affiliation_strings":["Snowflake Inc., Berlin, Germany"],"affiliations":[{"raw_affiliation_string":"Snowflake Inc., Berlin, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040299204","display_name":"Rainer Schl\u00f6\u00dfer","orcid":"https://orcid.org/0000-0002-6627-4026"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Rainer Schlosser","raw_affiliation_strings":["Hasso Plattner Institute, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002413906","display_name":"Volker Markl","orcid":"https://orcid.org/0009-0009-0964-026X"},"institutions":[{"id":"https://openalex.org/I4577782","display_name":"Technische Universit\u00e4t Berlin","ror":"https://ror.org/03v4gjf40","country_code":"DE","type":"education","lineage":["https://openalex.org/I4577782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Volker Markl","raw_affiliation_strings":["BIFOLD, TU Berlin, DFKI, Berlin, Germany"],"affiliations":[{"raw_affiliation_string":"BIFOLD, TU Berlin, DFKI, Berlin, Germany","institution_ids":["https://openalex.org/I4577782"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5015915659"],"corresponding_institution_ids":["https://openalex.org/I4577782"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.22493259,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"17","issue":"12","first_page":"4301","last_page":"4304"},"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.9990000128746033,"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.9990000128746033,"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.9983999729156494,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9901000261306763,"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/selection","display_name":"Selection (genetic algorithm)","score":0.639387845993042},{"id":"https://openalex.org/keywords/magic","display_name":"MAGIC (telescope)","score":0.6301454305648804},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.5977926850318909},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5185097455978394},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47429922223091125},{"id":"https://openalex.org/keywords/index-selection","display_name":"Index selection","score":0.42792659997940063},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36059239506721497},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2060208022594452},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2005440890789032},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.12871721386909485}],"concepts":[{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.639387845993042},{"id":"https://openalex.org/C2777704519","wikidata":"https://www.wikidata.org/wiki/Q45732","display_name":"MAGIC (telescope)","level":2,"score":0.6301454305648804},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.5977926850318909},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5185097455978394},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47429922223091125},{"id":"https://openalex.org/C2778360486","wikidata":"https://www.wikidata.org/wiki/Q6019110","display_name":"Index selection","level":3,"score":0.42792659997940063},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36059239506721497},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2060208022594452},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2005440890789032},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.12871721386909485},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3685800.3685860","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685860","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W2098443134","https://openalex.org/W2108883953","https://openalex.org/W2145466803","https://openalex.org/W2168503413","https://openalex.org/W2950480046","https://openalex.org/W3046765570","https://openalex.org/W3095166039","https://openalex.org/W4384521416","https://openalex.org/W4387848814"],"related_works":["https://openalex.org/W4319737419","https://openalex.org/W2019700946","https://openalex.org/W198668851","https://openalex.org/W2351656888","https://openalex.org/W4206361680","https://openalex.org/W3014907007","https://openalex.org/W2778305812","https://openalex.org/W1980273533","https://openalex.org/W94953919","https://openalex.org/W2041068459"],"abstract_inverted_index":{"Indexes":[0],"are":[1,115],"important":[2],"data":[3],"structures":[4],"for":[5,13,76,93,103,117],"database":[6,72,108],"tuning.":[7],"However,":[8],"finding":[9],"the":[10,32,45,66,106,132,145,150,155],"best":[11],"indexes":[12,75,114],"a":[14],"given":[15],"workload":[16],"is":[17,52,128],"challenging.":[18],"In":[19,147],"this":[20,148],"demonstration,":[21],"we":[22,99],"present":[23,100],"our":[24],"extensible":[25],"open-source":[26],"index":[27,59,84,95,134,160,165],"selection":[28,60,85,96,166],"evaluation":[29],"platform":[30,39,67,80],"and":[31,48,73,120,143,162],"corresponding":[33],"interactive":[34],"result":[35],"analysis":[36],"tool.":[37],"The":[38],"provides":[40],"an":[41,101,141],"automatic":[42],"setup":[43],"of":[44,157],"database,":[46],"workload,":[47],"cost":[49],"evaluation,":[50],"which":[51,87,113,118],"otherwise":[53],"often":[54],"tedious":[55],"work":[56],"when":[57],"evaluating":[58],"approaches.":[61,167],"Users":[62],"can":[63,88,111],"also":[64],"connect":[65],"to":[68,130,153],"their":[69,121],"own":[70],"existing":[71],"evaluate":[74],"custom":[77],"workloads.":[78],"Our":[79],"comprises":[81],"multiple":[82],"state-of-the-art":[83],"approaches,":[86],"be":[89],"used":[90,116],"as":[91],"baselines":[92],"new":[94,164],"proposals.":[97],"Further,":[98],"application":[102,151],"thoroughly":[104],"analyzing":[105],"selected":[107],"indexes.":[109],"One":[110],"observe":[112,144],"queries":[119],"effect":[122],"on":[123],"processing":[124],"costs.":[125],"Also,":[126],"it":[127],"possible":[129],"adapt":[131],"resulting":[133],"selections":[135],"(i.e.,":[136],"add,":[137],"remove,":[138],"or":[139],"change":[140],"index)":[142],"impact.":[146],"process,":[149],"helps":[152],"understand":[154],"effects":[156],"indexes,":[158],"improve":[159],"selections,":[161],"craft":[163]},"counts_by_year":[],"updated_date":"2025-12-23T23:11:35.936235","created_date":"2025-10-10T00:00:00"}