{"id":"https://openalex.org/W2188347403","doi":null,"title":"Query Optimization Methods for Improve Query Execution Time using SQL Technologies","display_name":"Query Optimization Methods for Improve Query Execution Time using SQL Technologies","publication_year":2014,"publication_date":"2014-12-29","ids":{"openalex":"https://openalex.org/W2188347403","mag":"2188347403"},"language":"en","primary_location":{"id":"mag:2188347403","doi":null,"is_oa":false,"landing_page_url":"http://www.seekdl.org/upload/files/20150608_115519.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306417975","display_name":"Computer Science and its Applications","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Computer Science and its Applications","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2188347403"],"child_works_count":0,"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/A5023130805","display_name":"Ahmed Khalaf","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ahmed Khalaf","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5080901234","display_name":"Zager Alsaedi","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zager Alsaedi","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":0.505,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.72855717,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":"4","issue":"4","first_page":"62","last_page":"65"},"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.9961000084877014,"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.9961000084877014,"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.0007999999797903001,"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":0.00019999999494757503,"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":1.0},{"id":"https://openalex.org/keywords/query-execution-time","display_name":"query execution time","score":0.9890000224113464},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7409999966621399},{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.5809999704360962},{"id":"https://openalex.org/keywords/join-operations","display_name":"join operations","score":0.8980000019073486},{"id":"https://openalex.org/keywords/aggregation","display_name":"aggregation","score":0.8050000071525574},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.3449999988079071}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.9133806228637695},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9003106355667114},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.8419331312179565},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.7763948440551758},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.6921439170837402},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6902867555618286},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6871627569198608},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.6069000959396362},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.6011159420013428},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5872893333435059},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5703102946281433},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5208219289779663},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.49788355827331543},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.43199318647384644},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4172722101211548},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3787325918674469},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3758084774017334},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.24288156628608704},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20851004123687744},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2188347403","doi":null,"is_oa":false,"landing_page_url":"http://www.seekdl.org/upload/files/20150608_115519.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306417975","display_name":"Computer Science and its Applications","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Computer Science and its Applications","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":1,"referenced_works":["https://openalex.org/W2412047973"],"related_works":["https://openalex.org/W2754095199","https://openalex.org/W2385089576","https://openalex.org/W2948795585","https://openalex.org/W2386472071","https://openalex.org/W2606184805","https://openalex.org/W2037512173","https://openalex.org/W7153567075","https://openalex.org/W7219836194","https://openalex.org/W1993470918","https://openalex.org/W3125756434"],"abstract_inverted_index":{"Generally,":[0],"the":[1,19,26,53,65],"query":[2,27,43,59,69,81,90,97],"optimizer":[3,28],"cannot":[4],"be":[5],"accessed":[6],"directly":[7],"by":[8,18],"users:":[9],"once":[10],"queries":[11],"are":[12,22],"submitted":[13],"to":[14,25,51,55,64,88,95],"database,":[15],"and":[16],"parsed":[17],"parser,":[20],"they":[21],"then":[23],"passed":[24],"where":[29],"optimization":[30,101],"occurs.":[31],"Each":[32],"different":[33,37,84],"way":[34,54],"typically":[35],"requires":[36],"processing":[38],"time.":[39,62],"The":[40],"purpose":[41],"of":[42,68,80,86],"optimization,":[44],"which":[45],"is":[46,50],"an":[47],"automated":[48],"process,":[49],"find":[52],"process":[56],"a":[57,77,82],"given":[58],"in":[60],"minimum":[61],"According":[63],"basic":[66],"operation":[67],"such":[70],"as":[71],"scanning,":[72],"aggregation,":[73],"join.":[74],"we":[75],"present":[76],"four":[78],"type":[79],"cross":[83],"size":[85],"tables":[87],"explain":[89],"performing":[91],"through":[92],"execution":[93,98],"time":[94,99],"improve":[96],"during":[100],".":[102]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}