{"id":"https://openalex.org/W2304023722","doi":null,"title":"Exploring Query Optimization Techniques in Relational Databases","display_name":"Exploring Query Optimization Techniques in Relational Databases","publication_year":2013,"publication_date":"2013-06-01","ids":{"openalex":"https://openalex.org/W2304023722","mag":"2304023722"},"language":"en","primary_location":{"id":"mag:2304023722","doi":null,"is_oa":false,"landing_page_url":"https://www.earticle.net/Article/A207886","pdf_url":null,"source":{"id":"https://openalex.org/S2764680519","display_name":"International Journal of Database Theory and Application","issn_l":"2005-4270","issn":["2005-4270","2207-9688"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","poland-20"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Database Theory and Application","raw_type":null},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5087668329","display_name":"M. N. A. Khan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"M. N. A. Khan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5087668329","display_name":"M. N. A. Khan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"M. N. A. Khan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.1671,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.97102502,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"6","issue":"3","first_page":"11","last_page":"20"},"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.9984999895095825,"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.9984999895095825,"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/T11106","display_name":"Data Management and Algorithms","score":0.00039999998989515007,"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/T12292","display_name":"Graph Theory and Algorithms","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.9990000128746033},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.9990000128746033},{"id":"https://openalex.org/keywords/sql-query-performance","display_name":"SQL query performance","score":0.7459999918937683},{"id":"https://openalex.org/keywords/query-plan","display_name":"query plan","score":0.718999981880188},{"id":"https://openalex.org/keywords/cost-based-optimization","display_name":"cost-based optimization","score":0.6919999718666077},{"id":"https://openalex.org/keywords/response-time","display_name":"response time","score":0.7670000195503235},{"id":"https://openalex.org/keywords/throughput","display_name":"throughput","score":0.9599999785423279},{"id":"https://openalex.org/keywords/indexing","display_name":"indexing","score":0.5899999737739563},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.7820000052452087},{"id":"https://openalex.org/keywords/centralized-database","display_name":"centralized database","score":0.8500000238418579}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9007205963134766},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8535345196723938},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.7065302133560181},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6764606237411499},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6223100423812866},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5964356660842896},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5678448677062988},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5581741333007812},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5126573443412781},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5052605271339417},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.47899338603019714},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.47783565521240234},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4557260572910309},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.42407259345054626},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.42075788974761963},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.41022825241088867},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3968120813369751},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.313924640417099},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1502075493335724}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2304023722","doi":null,"is_oa":false,"landing_page_url":"https://www.earticle.net/Article/A207886","pdf_url":null,"source":{"id":"https://openalex.org/S2764680519","display_name":"International Journal of Database Theory and Application","issn_l":"2005-4270","issn":["2005-4270","2207-9688"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","poland-20"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Database Theory and Application","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1581289570","https://openalex.org/W1963638780","https://openalex.org/W1991271936","https://openalex.org/W2040428289","https://openalex.org/W2047004292","https://openalex.org/W2051497142","https://openalex.org/W2066679214","https://openalex.org/W2109464129","https://openalex.org/W2133232294","https://openalex.org/W2133475758","https://openalex.org/W2140646908","https://openalex.org/W2147230434","https://openalex.org/W2149516580","https://openalex.org/W2168410847","https://openalex.org/W2292070951","https://openalex.org/W2293896416","https://openalex.org/W2547426886","https://openalex.org/W2611876927"],"related_works":["https://openalex.org/W2112562869","https://openalex.org/W7153567075","https://openalex.org/W2385089576","https://openalex.org/W2372649518","https://openalex.org/W4407556570","https://openalex.org/W7166676045","https://openalex.org/W7161767054","https://openalex.org/W6968012162","https://openalex.org/W2391294943","https://openalex.org/W3003282352"],"abstract_inverted_index":{"In":[0],"the":[1,9,17,25,53,59,168,178,187,192,195,199,217,233],"modern":[2],"era,":[3],"digital":[4],"data":[5,43,94,145],"is":[6,52,61,81,207],"considered":[7],"as":[8],"more":[10,20],"valuable":[11],"asset":[12],"of":[13,70,76,93,107,128,167,186,194,204,220,247],"an":[14,116,174],"organization,":[15],"and":[16,27,47,65,73,103,130,144,198,213,229,239],"organizations":[18],"assign":[19],"significance":[21],"to":[22,41,83,152,172,208],"it":[23],"than":[24],"software":[26],"hardware":[28],"assets.":[29],"Database":[30,89],"systems":[31],"are":[32],"computer-based":[33],"record":[34],"keeping":[35],"systems,":[36],"which":[37,57],"have":[38],"been":[39],"developed":[40],"store":[42],"for":[44,236],"efficient":[45,175,218],"retrieval":[46],"processing.":[48],"One":[49],"particular":[50],"approach":[51],"relational":[54],"databases":[55],"in":[56,63,67,141,164,232],"all":[58],"information":[60,97],"stored":[62],"rows":[64],"columns":[66],"a":[68,74,111,184],"series":[69],"interconnected":[71],"tables,":[72],"snippet":[75],"structured":[77],"code":[78],"called":[79],"query":[80,109,148,176,180,188,205,226],"used":[82],"interact":[84],"with":[85],"these":[86,248],"database":[87,113],"tables.":[88],"management":[90],"involves":[91],"indexing":[92],"by":[95,132,162,182,250],"tagging":[96],"based":[98,190],"on":[99,191],"some":[100],"common":[101],"factors":[102],"corresponding":[104],"criteria.":[105],"Performance":[106],"SQL":[108,170],"against":[110],"production":[112],"eventually":[114],"becomes":[115,150],"issue":[117],"sooner":[118],"or":[119],"later.":[120],"The":[121,202,242],"time-intensive":[122],"queries":[123],"not":[124],"only":[125],"degrade":[126],"performance":[127,154],"servers":[129],"applications":[131],"consuming":[133],"substantial":[134],"system":[135],"resources,":[136],"but":[137],"can":[138],"also":[139,244],"result":[140],"table":[142],"locking":[143],"corruption.":[146],"Therefore,":[147],"optimization":[149,157,206,227],"necessary":[151],"prevent":[153],"degradation.":[155],"Query":[156],"primarily":[158],"means":[159],"selection,":[160],"followed":[161],"sequencing":[163],"specific":[165],"order,":[166],"different":[169,225],"clauses":[171],"formulate":[173],"from":[177],"multiple":[179],"plans":[181,189],"drawing":[183],"comparison":[185],"cost":[193],"resources":[196],"involved":[197],"response":[200,211],"time.":[201],"objective":[203],"provide":[209],"minimum":[210],"time":[212],"maximum":[214],"throughput":[215],"(i.e.,":[216],"use":[219],"resources).":[221],"This":[222],"paper":[223,243],"reviews":[224],"techniques":[228,249],"approaches":[230],"discussed":[231],"contemporary":[234],"literature":[235],"both":[237],"centralized":[238],"distributed":[240],"databases.":[241],"highlights":[245],"merits":[246],"critically":[251],"analyzing":[252],"them.":[253]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":2}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}