{"id":"https://openalex.org/W4385444221","doi":"https://doi.org/10.1109/idt59031.2023.10194457","title":"Optimization of the SELECT Statement Containing Window Functions","display_name":"Optimization of the SELECT Statement Containing Window Functions","publication_year":2023,"publication_date":"2023-06-22","ids":{"openalex":"https://openalex.org/W4385444221","doi":"https://doi.org/10.1109/idt59031.2023.10194457"},"language":"en","primary_location":{"id":"doi:10.1109/idt59031.2023.10194457","is_oa":false,"landing_page_url":"https://doi.org/10.1109/idt59031.2023.10194457","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 International Conference on Information and Digital Technologies (IDT)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5092783297","display_name":"Martina Hr\u00ednov\u00e1 Durnekov\u00e1","orcid":null},"institutions":[{"id":"https://openalex.org/I4210152232","display_name":"Institute of Informatics of the Slovak Academy of Sciences","ror":"https://ror.org/04jgqpc26","country_code":"SK","type":"facility","lineage":["https://openalex.org/I207624831","https://openalex.org/I4210152232"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Martina Hr\u00ednov\u00e1 Durnekov\u00e1","raw_affiliation_strings":["Science and Informatics University of Žilina,Faculty of Management,Department of Informatics,Žilina,Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Science and Informatics University of Žilina,Faculty of Management,Department of Informatics,Žilina,Slovakia","institution_ids":["https://openalex.org/I4210152232"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050102565","display_name":"Michal Kvet","orcid":"https://orcid.org/0000-0003-3937-7473"},"institutions":[{"id":"https://openalex.org/I4210152232","display_name":"Institute of Informatics of the Slovak Academy of Sciences","ror":"https://ror.org/04jgqpc26","country_code":"SK","type":"facility","lineage":["https://openalex.org/I207624831","https://openalex.org/I4210152232"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Michal Kvet","raw_affiliation_strings":["Science and Informatics University of Žilina,Faculty of Management,Department of Informatics,Žilina,Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Science and Informatics University of Žilina,Faculty of Management,Department of Informatics,Žilina,Slovakia","institution_ids":["https://openalex.org/I4210152232"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210152232"],"apc_list":null,"apc_paid":null,"fwci":0.2417,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.40944236,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.879800021648407,"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.879800021648407,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8287519812583923},{"id":"https://openalex.org/keywords/statement","display_name":"Statement (logic)","score":0.7612954378128052},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6969510316848755},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4989504814147949},{"id":"https://openalex.org/keywords/problem-statement","display_name":"Problem statement","score":0.48323187232017517},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.47541743516921997},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.43534210324287415},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3497578501701355},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.07244086265563965}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8287519812583923},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.7612954378128052},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6969510316848755},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4989504814147949},{"id":"https://openalex.org/C202532154","wikidata":"https://www.wikidata.org/wiki/Q4374193","display_name":"Problem statement","level":2,"score":0.48323187232017517},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.47541743516921997},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.43534210324287415},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3497578501701355},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.07244086265563965},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C539667460","wikidata":"https://www.wikidata.org/wiki/Q2414942","display_name":"Management science","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/idt59031.2023.10194457","is_oa":false,"landing_page_url":"https://doi.org/10.1109/idt59031.2023.10194457","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 International Conference on Information and Digital Technologies (IDT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320335322","display_name":"European Regional Development Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W2169045799","https://openalex.org/W3005462316","https://openalex.org/W3164114326","https://openalex.org/W4226414271","https://openalex.org/W4240999411"],"related_works":["https://openalex.org/W4230021867","https://openalex.org/W2963732072","https://openalex.org/W121796019","https://openalex.org/W4379033598","https://openalex.org/W1995698356","https://openalex.org/W3128689118","https://openalex.org/W2030474123","https://openalex.org/W3194732531","https://openalex.org/W3027176591","https://openalex.org/W4255583600"],"abstract_inverted_index":{"The":[0,47,78],"speed":[1],"of":[2,19,32,50,55,63,74,95,110],"processing":[3],"a":[4,16],"query,":[5],"which":[6,36,68],"contains":[7],"analytical":[8,38,87,100],"functions":[9,39,88,97],"is":[10,81,107],"crucial,":[11],"if":[12],"we":[13,26],"work":[14],"with":[15,60],"huge":[17],"amount":[18],"data":[20,43],"in":[21],"database.":[22,46],"In":[23],"this":[24],"article":[25],"focused":[27],"on":[28],"optimizing":[29],"the":[30,33,45,56,61,64,71,75,82,103,108],"execution":[31,72],"SELECT":[34],"statement,":[35],"uses":[37],"to":[40],"obtain":[41],"additional":[42],"from":[44],"optimization":[48],"consists":[49],"comparing":[51],"five":[52],"different":[53,93],"methods":[54,94],"query":[57],"creation":[58,62],"together":[59],"most":[65],"suitable":[66],"indexes,":[67],"can":[69],"improve":[70],"plan":[73],"given":[76],"query.":[77],"first":[79],"method":[80,106],"classic":[83],"select":[84],"statement":[85],"containing":[86],"directly,":[89],"followed":[90],"by":[91],"three":[92],"user-defined":[96],"that":[98],"include":[99],"functions,":[101],"and":[102],"last":[104],"compared":[105],"use":[109],"materialized":[111],"view.":[112]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}