{"id":"https://openalex.org/W2604963418","doi":null,"title":"Database Optimization Using Genetic Algorithms for Distributed Databases","display_name":"Database Optimization Using Genetic Algorithms for Distributed Databases","publication_year":2017,"publication_date":"2017-02-03","ids":{"openalex":"https://openalex.org/W2604963418","mag":"2604963418"},"language":"en","primary_location":{"id":"pmh:oai:ojs.ijcjournal.org:article/803","doi":null,"is_oa":true,"landing_page_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","pdf_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","source":{"id":"https://openalex.org/S4306513923","display_name":"International Journal of Computer (IJC)","issn_l":"2307-4523","issn":["2307-4523"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer (IJC); Vol 24, No 1 (2017); 23-27","raw_type":"info:eu-repo/semantics/article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5040059024","display_name":"G. C. A. L. Aponso","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I192365124","display_name":"Sri Lanka Institute of Information Technology","ror":"https://ror.org/00fhk4582","country_code":"LK","type":"education","lineage":["https://openalex.org/I192365124"]}],"countries":["LK"],"is_corresponding":false,"raw_author_name":"G. C. A. L. Aponso","raw_affiliation_strings":["Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka","institution_ids":["https://openalex.org/I192365124"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023749336","display_name":"T. M. T. I. Tennakon","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I192365124","display_name":"Sri Lanka Institute of Information Technology","ror":"https://ror.org/00fhk4582","country_code":"LK","type":"education","lineage":["https://openalex.org/I192365124"]}],"countries":["LK"],"is_corresponding":false,"raw_author_name":"T. M. T. I. Tennakon","raw_affiliation_strings":["Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka","institution_ids":["https://openalex.org/I192365124"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053807158","display_name":"A. M. C. B. Arampath","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I192365124","display_name":"Sri Lanka Institute of Information Technology","ror":"https://ror.org/00fhk4582","country_code":"LK","type":"education","lineage":["https://openalex.org/I192365124"]}],"countries":["LK"],"is_corresponding":false,"raw_author_name":"A. M. C. B. Arampath","raw_affiliation_strings":["Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka","institution_ids":["https://openalex.org/I192365124"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Sithamparanathan Kandeepan","orcid":"https://orcid.org/0000-0002-9388-9173","observed_orcids":["https://orcid.org/0000-0002-9388-9173"]},"institutions":[{"id":"https://openalex.org/I192365124","display_name":"Sri Lanka Institute of Information Technology","ror":"https://ror.org/00fhk4582","country_code":"LK","type":"education","lineage":["https://openalex.org/I192365124"]}],"countries":["LK"],"is_corresponding":false,"raw_author_name":"Sithamparanathan Kandeepan","raw_affiliation_strings":["Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka"],"raw_orcid":"https://orcid.org/0000-0002-9388-9173","affiliations":[{"raw_affiliation_string":"Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka","institution_ids":["https://openalex.org/I192365124"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076891769","display_name":"H. P. K. K. S. Amaratunga","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I192365124","display_name":"Sri Lanka Institute of Information Technology","ror":"https://ror.org/00fhk4582","country_code":"LK","type":"education","lineage":["https://openalex.org/I192365124"]}],"countries":["LK"],"is_corresponding":false,"raw_author_name":"H. P. K. K. S. Amaratunga","raw_affiliation_strings":["Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Graduate Studies and Research, Sri Lanka Institute of Information Technology, Colombo 03, Sri Lanka","institution_ids":["https://openalex.org/I192365124"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I192365124"],"apc_list":null,"apc_paid":null,"fwci":1.3543,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.85010711,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"24","issue":"1","first_page":"23","last_page":"27"},"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.9883000254631042,"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.9883000254631042,"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.0066999997943639755,"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.0005000000237487257,"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.7630000114440918},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.8309999704360962},{"id":"https://openalex.org/keywords/genetic-algorithm","display_name":"genetic algorithm","score":0.9950000047683716},{"id":"https://openalex.org/keywords/query-plan-selection","display_name":"query plan selection","score":0.8349999785423279},{"id":"https://openalex.org/keywords/database-compression","display_name":"database compression","score":0.656000018119812},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.5199999809265137}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8556176424026489},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8458229303359985},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.7568466663360596},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7424271702766418},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.7174661755561829},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6315649747848511},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.630316972732544},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.6100442409515381},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.594114363193512},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5217959880828857},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.49723079800605774},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4752785265445709},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4735870957374573},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.45622381567955017},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.45577195286750793},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.4351983964443207},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4240027070045471},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4134070873260498},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3597961366176605},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.34278056025505066},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13001036643981934}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:ojs.ijcjournal.org:article/803","doi":null,"is_oa":true,"landing_page_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","pdf_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","source":{"id":"https://openalex.org/S4306513923","display_name":"International Journal of Computer (IJC)","issn_l":"2307-4523","issn":["2307-4523"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer (IJC); Vol 24, No 1 (2017); 23-27","raw_type":"info:eu-repo/semantics/article"},{"id":"mag:2604963418","doi":null,"is_oa":true,"landing_page_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/download/803/413","pdf_url":null,"source":{"id":"https://openalex.org/S4306513923","display_name":"International Journal of Computer (IJC)","issn_l":"2307-4523","issn":["2307-4523"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"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 Computer (IJC)","raw_type":null}],"best_oa_location":{"id":"pmh:oai:ojs.ijcjournal.org:article/803","doi":null,"is_oa":true,"landing_page_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","pdf_url":"http://ijcjournal.org/index.php/InternationalJournalOfComputer/article/view/803","source":{"id":"https://openalex.org/S4306513923","display_name":"International Journal of Computer (IJC)","issn_l":"2307-4523","issn":["2307-4523"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Computer (IJC); Vol 24, No 1 (2017); 23-27","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2604963418.pdf","grobid_xml":"https://content.openalex.org/works/W2604963418.grobid-xml"},"referenced_works_count":7,"referenced_works":["https://openalex.org/W1765311349","https://openalex.org/W1971797742","https://openalex.org/W2129475290","https://openalex.org/W2294596984","https://openalex.org/W2373175589","https://openalex.org/W2475828637","https://openalex.org/W2518172527"],"related_works":["https://openalex.org/W2177176476","https://openalex.org/W2549535751","https://openalex.org/W2415410969","https://openalex.org/W2979267680","https://openalex.org/W2129475290","https://openalex.org/W7100016694","https://openalex.org/W7096573197","https://openalex.org/W4206102470","https://openalex.org/W2166373001","https://openalex.org/W2798764406"],"abstract_inverted_index":{"Databases":[0],"can":[1],"store":[2],"a":[3,32,50,86,125,140],"vast":[4],"amount":[5],"of":[6,11,34,43,61,71,103,111,166,171,235],"information":[7],"and":[8,38,81,100,153,190,224,243],"particular":[9,87,105],"sets":[10],"data":[12,44],"are":[13,18,131,192,218,230],"accessed":[14],"via":[15],"queries":[16],"which":[17,41,130],"written":[19],"in":[20,65,175],"specific":[21],"interface":[22],"language":[23,28],"such":[24,94,201,237],"as":[25,95,202,211,238],"structured":[26],"query":[27,73,88,92,113,119,147,163,173,184,215],"(SQL).Database":[29],"optimization":[30,58,74,114,174,226],"is":[31,45,59,75,124,164],"process":[33],"maximizing":[35],"the":[36,62,72,78,109,112,161,167,172,199,214],"speed":[37],"efficiency":[39],"with":[40,149],"kind":[42],"retrieved":[46],"or":[47,157],"simply":[48],"it's":[49],"mechanism":[51,115],"that":[52,137],"reduces":[53],"database":[54,66,122,177,180,208],"systems":[55,68,209],"response":[56,155],"time.Query":[57],"one":[60,165],"major":[63,168],"functionality":[64],"management":[67],"(DBMS).The":[69],"purpose":[70],"to":[76,84,116,143,159,212,221],"determine":[77],"most":[79],"efficient":[80,151],"effective":[82,146],"way":[83],"execute":[85,160,213],"by":[89],"considering":[90],"several":[91,127],"plans":[93,99],"graphical":[96],"plans,":[97],"textual":[98],"etc.":[101],"Execution":[102],"any":[104],"datasets":[106],"depends":[107],"on":[108],"capability":[110],"acquire":[117],"competent":[118],"processing":[120],"approaches.Distributed":[121],"system":[123],"collection":[126],"interrelated":[128],"databases":[129],"spread":[132],"physically":[133],"across":[134],"different":[135],"environments":[136],"communicate":[138],"through":[139],"computer":[141],"network.Inability":[142],"obtain":[144],"an":[145,150],"strategy":[148,205],"accuracy":[152],"minimum":[154],"time":[156],"cost":[158],"given":[162],"key":[169],"issues":[170],"distributed":[176,207],"systems.Further":[178],"inefficient":[179,183],"compression":[181],"methods,":[182],"processing,":[185],"missing":[186],"indexes,":[187],"inexact":[188],"statistics,":[189],"deadlocks":[191],"furthermore":[193],"defects.In":[194],"this":[195],"paper,":[196],"it":[197],"describes":[198],"methodologies":[200],"genetic":[203,228],"algorithm":[204],"for":[206],"so":[210],"plan.Genetic":[216],"algorithms":[217,229],"extensively":[219],"using":[220,231],"solve":[222],"constrained":[223],"unconstrained":[225],"problems.The":[227],"three":[232],"main":[233],"types":[234],"rules":[236],"selection":[239],"rules,":[240,242],"crossover":[241],"mutation":[244],"rules.":[245]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1}],"updated_date":"2026-10-28T10:33:24.094632","created_date":"2017-04-14T00:00:00"}