{"id":"https://openalex.org/W2606184805","doi":"https://doi.org/10.5120/ijca2017913490","title":"Query Optimization using Multiple Techniques","display_name":"Query Optimization using Multiple Techniques","publication_year":2017,"publication_date":"2017-04-17","ids":{"openalex":"https://openalex.org/W2606184805","doi":"https://doi.org/10.5120/ijca2017913490","mag":"2606184805"},"language":"en","primary_location":{"id":"doi:10.5120/ijca2017913490","doi":"https://doi.org/10.5120/ijca2017913490","is_oa":true,"landing_page_url":"https://doi.org/10.5120/ijca2017913490","pdf_url":"https://doi.org/10.5120/ijca2017913490","source":{"id":"https://openalex.org/S4210206007","display_name":"International Journal of Computer Applications","issn_l":"0975-8887","issn":["0975-8887"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core"],"host_organization":"https://openalex.org/P4322545532","host_organization_name":"Foundation of Computer Science","host_organization_lineage":["https://openalex.org/P4322545532"],"host_organization_lineage_names":["Foundation of Computer Science"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer Applications","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://doi.org/10.5120/ijca2017913490","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059676842","display_name":"Ajay Wagh","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ajay Wagh","raw_affiliation_strings":["Research","School of Technology Management & Engineering, Sirpur"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Research","institution_ids":[]},{"raw_affiliation_string":"School of Technology Management & Engineering, Sirpur","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017233455","display_name":"Varsha Nemade","orcid":"https://orcid.org/0000-0001-6032-251X","observed_orcids":["https://orcid.org/0000-0001-6032-251X"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Varsha Nemade","raw_affiliation_strings":["School of Technology Management & Engineering, Sirpur"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Technology Management & Engineering, Sirpur","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0157,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.82378518,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":"163","issue":"3","first_page":"30","last_page":"32"},"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.9639000296592712,"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.9639000296592712,"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/T10100","display_name":"Metaheuristic Optimization Algorithms Research","score":0.012600000016391277,"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/T11106","display_name":"Data Management and Algorithms","score":0.0026000000070780516,"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/query-optimization","display_name":"query optimization","score":0.9980000257492065},{"id":"https://openalex.org/keywords/cost-estimation","display_name":"cost estimation","score":0.7229999899864197},{"id":"https://openalex.org/keywords/ant-colony-optimization","display_name":"ant colony optimization","score":0.9210000038146973},{"id":"https://openalex.org/keywords/iterative-improvement","display_name":"iterative improvement","score":0.699999988079071},{"id":"https://openalex.org/keywords/execution-time","display_name":"execution time","score":0.7139999866485596},{"id":"https://openalex.org/keywords/response-time","display_name":"response time","score":0.8069999814033508},{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.4830000102519989}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.91127610206604},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.657450795173645},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4168599545955658}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5120/ijca2017913490","doi":"https://doi.org/10.5120/ijca2017913490","is_oa":true,"landing_page_url":"https://doi.org/10.5120/ijca2017913490","pdf_url":"https://doi.org/10.5120/ijca2017913490","source":{"id":"https://openalex.org/S4210206007","display_name":"International Journal of Computer Applications","issn_l":"0975-8887","issn":["0975-8887"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core"],"host_organization":"https://openalex.org/P4322545532","host_organization_name":"Foundation of Computer Science","host_organization_lineage":["https://openalex.org/P4322545532"],"host_organization_lineage_names":["Foundation of Computer Science"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer Applications","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.5120/ijca2017913490","doi":"https://doi.org/10.5120/ijca2017913490","is_oa":true,"landing_page_url":"https://doi.org/10.5120/ijca2017913490","pdf_url":"https://doi.org/10.5120/ijca2017913490","source":{"id":"https://openalex.org/S4210206007","display_name":"International Journal of Computer Applications","issn_l":"0975-8887","issn":["0975-8887"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core"],"host_organization":"https://openalex.org/P4322545532","host_organization_name":"Foundation of Computer Science","host_organization_lineage":["https://openalex.org/P4322545532"],"host_organization_lineage_names":["Foundation of Computer Science"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer Applications","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2606184805.pdf","grobid_xml":"https://content.openalex.org/works/W2606184805.grobid-xml"},"referenced_works_count":7,"referenced_works":["https://openalex.org/W1576849326","https://openalex.org/W1979356488","https://openalex.org/W2097571405","https://openalex.org/W2332198346","https://openalex.org/W2339303436","https://openalex.org/W2371929047","https://openalex.org/W2554064355"],"related_works":["https://openalex.org/W2948795585","https://openalex.org/W2626202971","https://openalex.org/W2900791740","https://openalex.org/W2505634957","https://openalex.org/W2757503458","https://openalex.org/W4252761266","https://openalex.org/W1865946198","https://openalex.org/W4237752134","https://openalex.org/W2014191184","https://openalex.org/W2188347403"],"abstract_inverted_index":{"Query":[0],"optimization":[1,93,105,109,132],"is":[2,32,46,53,64],"the":[3,8,21,35,38,51,69],"overall":[4],"process":[5,59],"of":[6,12,82,112],"choosing":[7],"most":[9],"efficient":[10],"means":[11],"executing":[13],"a":[14,26,47,65],"SQL":[15,27],"statement.The":[16,28],"optimizer":[17,52],"attempts":[18],"to":[19,55],"generate":[20],"best":[22,29],"execution":[23,30,75,84,114],"plan":[24,31,36],"for":[25,73,80],"defined":[33],"as":[34,86,96],"with":[37],"lowest":[39],"cost":[40,63,77,104,131],"among":[41],"all":[42],"considered":[43],"candidate":[44],"plans.SQL":[45],"nonprocedural":[48],"language,":[49],"so":[50],"free":[54],"merge,":[56],"reorganize,":[57],"and":[58,89,106,116,127],"in":[60],"any":[61],"order.The":[62],"number":[66],"that":[67],"represents":[68],"estimated":[70],"resource":[71],"usage":[72],"an":[74],"plan.The":[76],"computation":[78],"accounts":[79],"factors":[81],"query":[83,92],"such":[85,95],"I/O,":[87],"CPU,":[88],"communication.To":[90],"implement":[91],"methods":[94],"Heuristic":[97,120],"Greedy":[98,121],"based":[99,103,122,130],"optimization,":[100],"Iterative":[101,128],"Improvement":[102,129],"Ant":[107,124],"Colony":[108,125],"algorithms.Show":[110],"Comparison":[111],"cost,":[113],"time":[115,118],"response":[117],"between":[119],"optimization;":[123],"Optimization":[126],"algorithms.":[133]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":3}],"updated_date":"2026-09-06T09:10:53.072986","created_date":"2017-04-28T00:00:00"}