{"id":"https://openalex.org/W2168406720","doi":"https://doi.org/10.1145/1739041.1739131","title":"PARINDA","display_name":"PARINDA","publication_year":2010,"publication_date":"2010-03-16","ids":{"openalex":"https://openalex.org/W2168406720","doi":"https://doi.org/10.1145/1739041.1739131","mag":"2168406720"},"language":"en","primary_location":{"id":"doi:10.1145/1739041.1739131","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1739041.1739131","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 13th International Conference on Extending Database Technology","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://infoscience.epfl.ch/record/161482/files/maier-EDBT2010.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5052936846","display_name":"Cristina Maier","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Cristina Maier","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110913907","display_name":"Debabrata Dash","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Debabrata Dash","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005113663","display_name":"Ioannis Alagiannis","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Ioannis Alagiannis","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070907021","display_name":"Anastasia Ailamaki","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Anastasia Ailamaki","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041993379","display_name":"Thomas Heinis","orcid":"https://orcid.org/0000-0002-7470-2123"},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Thomas Heinis","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5052936846"],"corresponding_institution_ids":["https://openalex.org/I5124864"],"apc_list":null,"apc_paid":null,"fwci":0.3767,"has_fulltext":true,"cited_by_count":23,"citation_normalized_percentile":{"value":0.68455196,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"701","last_page":"704"},"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.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"}},"topics":[{"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9940999746322632,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9940000176429749,"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/computer-science","display_name":"Computer science","score":0.8689699769020081},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.6158502697944641},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.5864478945732117},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5694306492805481},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.5333659052848816},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.5061399340629578},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.5028509497642517},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49080023169517517},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.46307384967803955},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.41771331429481506},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1342291235923767},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12487608194351196},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12316793203353882}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8689699769020081},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6158502697944641},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.5864478945732117},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5694306492805481},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.5333659052848816},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.5061399340629578},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.5028509497642517},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49080023169517517},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.46307384967803955},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.41771331429481506},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1342291235923767},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12487608194351196},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12316793203353882},{"id":"https://openalex.org/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","level":1,"score":0.0},{"id":"https://openalex.org/C530198007","wikidata":"https://www.wikidata.org/wiki/Q80831","display_name":"Integrated circuit","level":2,"score":0.0},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","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}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1739041.1739131","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1739041.1739131","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 13th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:infoscience.tind.io:161482","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/161482","pdf_url":"https://infoscience.epfl.ch/record/161482/files/maier-EDBT2010.pdf","source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference proceedings"}],"best_oa_location":{"id":"pmh:oai:infoscience.tind.io:161482","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/161482","pdf_url":"https://infoscience.epfl.ch/record/161482/files/maier-EDBT2010.pdf","source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference proceedings"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.5,"id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G1352671934","display_name":"ITR:  Cache-Resident Databases","funder_award_id":"0205544","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2055479483","display_name":"Statistische Analyse umfangreicher Volltexte","funder_award_id":"33686","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G349582178","display_name":"Absorptionscharakteristika verschiedener oraler Rehydrationsl\u00f6sungen im menschlichen D\u00fcnndarm.","funder_award_id":"20554","funder_id":"https://openalex.org/F4320320924","funder_display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung"},{"id":"https://openalex.org/G3535534575","display_name":null,"funder_award_id":"CCR-0205544IIS-0133686IIS-0713409","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"},{"id":"https://openalex.org/G4198845857","display_name":"CAREER: Bridging Databases and Computer Architecture: Optimizing DBMS for Deep Memory Hierarchies","funder_award_id":"0133686","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7936520376","display_name":"III-COR: Staged Database Systems: Maximizing Locality through Service-based Data Management","funder_award_id":"0713409","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G87039048","display_name":null,"funder_award_id":"CCR-0205544IIS-0133686IIS-0713409","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"},{"id":"https://openalex.org/F4320320924","display_name":"Schweizerischer Nationalfonds zur F\u00f6rderung der Wissenschaftlichen Forschung","ror":"https://ror.org/00yjd3n13"},{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"},{"id":"https://openalex.org/F4320338080","display_name":"European Social Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2168406720.pdf","grobid_xml":"https://content.openalex.org/works/W2168406720.grobid-xml"},"referenced_works_count":11,"referenced_works":["https://openalex.org/W1553825122","https://openalex.org/W2002131042","https://openalex.org/W2047085757","https://openalex.org/W2053228377","https://openalex.org/W2103412498","https://openalex.org/W2108883953","https://openalex.org/W2111983929","https://openalex.org/W2125605956","https://openalex.org/W2126643610","https://openalex.org/W2165481122","https://openalex.org/W2168780254"],"related_works":["https://openalex.org/W4387497383","https://openalex.org/W3183948672","https://openalex.org/W3173606202","https://openalex.org/W3110381201","https://openalex.org/W2948807893","https://openalex.org/W2778153218","https://openalex.org/W2758277628","https://openalex.org/W1531601525","https://openalex.org/W3119129187","https://openalex.org/W2163867827"],"abstract_inverted_index":{"One":[0],"of":[1,33,37,63,115,145,197],"the":[2,7,14,31,55,84,88,98,150,193,198,203],"most":[3],"challenging":[4],"tasks":[5],"for":[6,20,58,108,119,134,187],"database":[8,15,99],"administrator":[9],"is":[10,26,113],"to":[11,16,52,86,152,176,179],"physically":[12],"design":[13,25,38,157,174],"attain":[17],"optimal":[18,35,180],"performance":[19],"a":[21,41,59,61,140,143],"given":[22,60],"workload.":[23],"Physical":[24],"hard":[27],"because":[28],"it":[29,183],"requires":[30],"selection":[32],"an":[34,130,135],"set":[36,62,144],"features":[39,158],"from":[40,97],"vast":[42],"search":[43],"space.":[44],"There":[45],"have":[46],"been":[47,185],"many":[48],"commercial":[49,109],"tools":[50,66,104],"available":[51],"automatically":[53],"suggest":[54],"physical":[56,117,132,156,173],"design,":[57],"queries.":[64],"These":[65],"are,":[67],"however,":[68],"based":[69],"on":[70,163,202],"greedy":[71],"heuristic":[72],"pruning,":[73],"which":[74],"reduces":[75],"their":[76,164],"usefulness.":[77],"Furthermore,":[78],"they":[79],"are":[80,92,105],"not":[81],"interactive,":[82],"as":[83],"APIs":[85],"simulate":[87,154],"indexes":[89],"and":[90,95,111,159,195,211],"tables":[91],"product":[93],"specific":[94],"hidden":[96],"administrators.":[100],"Finally,":[101],"all":[102],"these":[103],"built":[106],"specifically":[107],"systems":[110],"there":[112],"lack":[114],"automated":[116],"designers":[118],"open":[120,136,204],"source":[121,137,205],"DBMSs.":[122],"In":[123],"this":[124,147],"demonstration":[125],"we":[126,191],"introduce":[127],"-PARINDA":[128],"-":[129],"interactive":[131],"designer":[133],"DBMS.":[138],"Given":[139],"workload":[141],"containing":[142],"queries,":[146],"tool":[148,199],"allows":[149],"DBA":[151],"efficiently":[153],"various":[155],"get":[160],"immediate":[161],"feedback":[162],"effectiveness.":[165],"It":[166],"also":[167],"incorporates":[168],"recent":[169],"advances":[170],"in":[171],"non-greedy":[172],"techniques":[175],"provide":[177],"close":[178],"suggestions.":[181],"Although":[182],"has":[184],"prototyped":[186],"several":[188],"different":[189],"DBMSs,":[190],"demonstrate":[192],"usefulness":[194],"efficiency":[196],"while":[200],"running":[201],"DBMS---PostgreSQL--using":[206],"large":[207],"real-world":[208],"scientific":[209],"datasets":[210],"query":[212],"workloads.":[213]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2016-06-24T00:00:00"}