{"id":"https://openalex.org/W4385963992","doi":"https://doi.org/10.5937/jpmnt11-44471","title":"OPTIMIZATION OF MYSQL DATABASE","display_name":"OPTIMIZATION OF MYSQL DATABASE","alternate_titles":[],"publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W4385963992","doi":"https://doi.org/10.5937/jpmnt11-44471"},"language":"en","primary_location":{"id":"doi:10.5937/jpmnt11-44471","doi":"https://doi.org/10.5937/jpmnt11-44471","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5937/jpmnt11-44471","pdf_url":"https://aseestant.ceon.rs/index.php/jouproman/article/download/44471/22982","source":{"id":"https://openalex.org/S2764935091","display_name":"Journal of Process Management New Technologies","issn_l":"2334-735X","issn":["2334-735X","2334-7449"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","erih-plus"],"host_organization":"https://openalex.org/P4310321713","host_organization_name":"KD Mapro","host_organization_lineage":["https://openalex.org/P4310321713"],"host_organization_lineage_names":["KD Mapro"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of process management and new technologies","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4385963992"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://aseestant.ceon.rs/index.php/jouproman/article/download/44471/22982","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5092448078","display_name":"Ivan \u0160u\u0161ter","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I152518017","display_name":"University of Nis","ror":"https://ror.org/00965bg92","country_code":"RS","type":"education","lineage":["https://openalex.org/I152518017"]}],"countries":["RS"],"is_corresponding":false,"raw_author_name":"Ivan \u0160u\u0161ter","raw_affiliation_strings":["Faculty of Electronic Engineering, University of Ni\u0161, Ni\u0161, Serbia,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Electronic Engineering, University of Ni\u0161, Ni\u0161, Serbia,","institution_ids":["https://openalex.org/I152518017"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5092448079","display_name":"Tamara Ranisavljevi\u0107","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Tamara Ranisavljevi\u0107","raw_affiliation_strings":["WRPM, Belgrade, Serbia,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"WRPM, Belgrade, Serbia,","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5092448079"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.018,"has_fulltext":true,"cited_by_count":43,"citation_normalized_percentile":{"value":0.96682669,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":92,"max":99},"biblio":{"volume":"11","issue":"1-2","first_page":"141","last_page":"151"},"is_retracted":false,"is_pulled":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/T12127","display_name":"Software System Performance and Reliability","score":0.0005000000237487257,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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"}}],"keywords":[{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.9869999885559082},{"id":"https://openalex.org/keywords/database-tuning","display_name":"database performance tuning","score":0.8849999904632568},{"id":"https://openalex.org/keywords/relational-database-management-systems","display_name":"relational database management systems","score":0.8799999952316284},{"id":"https://openalex.org/keywords/database-architecture","display_name":"database architecture","score":0.7369999885559082},{"id":"https://openalex.org/keywords/physical-programming","display_name":"physical programming","score":0.42100000381469727}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7824526429176331},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.692885160446167},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5808719992637634},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.568701446056366},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.466586172580719},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4267345070838928},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.5937/jpmnt11-44471","doi":"https://doi.org/10.5937/jpmnt11-44471","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5937/jpmnt11-44471","pdf_url":"https://aseestant.ceon.rs/index.php/jouproman/article/download/44471/22982","source":{"id":"https://openalex.org/S2764935091","display_name":"Journal of Process Management New Technologies","issn_l":"2334-735X","issn":["2334-735X","2334-7449"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","erih-plus"],"host_organization":"https://openalex.org/P4310321713","host_organization_name":"KD Mapro","host_organization_lineage":["https://openalex.org/P4310321713"],"host_organization_lineage_names":["KD Mapro"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of process management and new technologies","raw_type":"journal-article"},{"id":"doi:10.5937/jouproman2301141q","doi":"https://doi.org/10.5937/jouproman2301141q","is_oa":true,"landing_page_url":"https://doi.org/10.5937/jouproman2301141q","pdf_url":"https://scindeks-clanci.ceon.rs/data/pdf/2334-735X/2023/2334-735X2301141Q.pdf","source":{"id":"https://openalex.org/S2764935091","display_name":"Journal of Process Management New Technologies","issn_l":"2334-735X","issn":["2334-735X","2334-7449"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","erih-plus"],"host_organization":"https://openalex.org/P4310321713","host_organization_name":"KD Mapro","host_organization_lineage":["https://openalex.org/P4310321713"],"host_organization_lineage_names":["KD Mapro"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Process Management and New Technologies","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:5834a4a0f3f14a90b7816094926d0a69","doi":null,"is_oa":true,"landing_page_url":"https://doaj.org/article/5834a4a0f3f14a90b7816094926d0a69","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Process Management and New Technologies, Vol 11, Iss 1-2 (2023)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.5937/jpmnt11-44471","doi":"https://doi.org/10.5937/jpmnt11-44471","is_oa":true,"landing_page_url":"http://dx.doi.org/10.5937/jpmnt11-44471","pdf_url":"https://aseestant.ceon.rs/index.php/jouproman/article/download/44471/22982","source":{"id":"https://openalex.org/S2764935091","display_name":"Journal of Process Management New Technologies","issn_l":"2334-735X","issn":["2334-735X","2334-7449"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","erih-plus"],"host_organization":"https://openalex.org/P4310321713","host_organization_name":"KD Mapro","host_organization_lineage":["https://openalex.org/P4310321713"],"host_organization_lineage_names":["KD Mapro"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of process management and new technologies","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/W4385963992.pdf","grobid_xml":"https://content.openalex.org/works/W4385963992.grobid-xml"},"referenced_works_count":12,"referenced_works":["https://openalex.org/W1577304934","https://openalex.org/W2112474496","https://openalex.org/W2247228870","https://openalex.org/W2514489076","https://openalex.org/W2603106358","https://openalex.org/W2613206411","https://openalex.org/W2763841525","https://openalex.org/W4284885814","https://openalex.org/W4297990590","https://openalex.org/W4318612139","https://openalex.org/W4377086148","https://openalex.org/W7019706926"],"related_works":["https://openalex.org/W4409917686","https://openalex.org/W7154496775","https://openalex.org/W4392605635","https://openalex.org/W71809808","https://openalex.org/W4383333654","https://openalex.org/W4391128930","https://openalex.org/W2991301471","https://openalex.org/W7218132663","https://openalex.org/W4408249847","https://openalex.org/W4360982861"],"abstract_inverted_index":{"The":[0],"performance":[1],"of":[2,15,28,51,59,83],"MySQL,":[3],"a":[4,13,56],"well-known":[5],"open-source":[6],"relational":[7],"database":[8,40],"management":[9],"system":[10],"used":[11,71],"in":[12,72],"variety":[14],"sectors,":[16],"including":[17],"e-commerce,":[18],"finance,":[19],"and":[20,31,61,69,75,78,86],"healthcare,":[21],"can":[22],"be":[23],"improved":[24],"through":[25],"the":[26,39,48,66,81],"use":[27],"physical":[29,44,49,73],"programming":[30,45,74],"data":[32,35,76],"tuning.":[33],"While":[34],"tuning":[36],"involves":[37,46],"refining":[38],"to":[41],"increase":[42],"efficiency,":[43],"optimizing":[47],"storage":[50],"data.":[52],"This":[53],"article":[54],"gives":[55],"general":[57],"introduction":[58],"MySQL":[60],"its":[62],"architecture,":[63],"looks":[64],"at":[65],"many":[67],"methods":[68],"tools":[70],"tuning,":[77],"talks":[79],"about":[80],"advantages":[82],"these":[84],"techniques":[85],"how":[87],"they":[88],"affect":[89],"MySQL's":[90],"performance.":[91]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4385963992","counts_by_year":[{"year":2026,"cited_by_count":13},{"year":2025,"cited_by_count":17},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2023-08-18T00:00:00"}
