{"id":"https://openalex.org/W2806354204","doi":"https://doi.org/10.1007/978-3-319-93803-5_1","title":"Database Performance Tuning and Query Optimization","display_name":"Database Performance Tuning and Query Optimization","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2806354204","doi":"https://doi.org/10.1007/978-3-319-93803-5_1","mag":"2806354204"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-319-93803-5_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-319-93803-5_1","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"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/A5049100140","display_name":"Sadhana J. Kamatkar","orcid":null},"institutions":[{"id":"https://openalex.org/I169877490","display_name":"University of Mumbai","ror":"https://ror.org/032hdk172","country_code":"IN","type":"education","lineage":["https://openalex.org/I169877490"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Sadhana J. Kamatkar","raw_affiliation_strings":["University of Mumbai, Mumbai, India"],"affiliations":[{"raw_affiliation_string":"University of Mumbai, Mumbai, India","institution_ids":["https://openalex.org/I169877490"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064537030","display_name":"Ajit Kamble","orcid":null},"institutions":[{"id":"https://openalex.org/I169877490","display_name":"University of Mumbai","ror":"https://ror.org/032hdk172","country_code":"IN","type":"education","lineage":["https://openalex.org/I169877490"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Ajit Kamble","raw_affiliation_strings":["University of Mumbai, Mumbai, India"],"affiliations":[{"raw_affiliation_string":"University of Mumbai, Mumbai, India","institution_ids":["https://openalex.org/I169877490"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083479770","display_name":"Amelec Viloria","orcid":"https://orcid.org/0000-0003-2673-6350"},"institutions":[{"id":"https://openalex.org/I4210112678","display_name":"University of the Coast","ror":"https://ror.org/01v5nhr20","country_code":"CO","type":"education","lineage":["https://openalex.org/I4210112678"]}],"countries":["CO"],"is_corresponding":false,"raw_author_name":"Amelec Viloria","raw_affiliation_strings":["Universidad de la Costa, Barranquilla, Colombia"],"affiliations":[{"raw_affiliation_string":"Universidad de la Costa, Barranquilla, Colombia","institution_ids":["https://openalex.org/I4210112678"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058045741","display_name":"Lissette Hern\u00e1ndez Fern\u00e1ndez","orcid":"https://orcid.org/0000-0003-0839-6057"},"institutions":[{"id":"https://openalex.org/I4210112678","display_name":"University of the Coast","ror":"https://ror.org/01v5nhr20","country_code":"CO","type":"education","lineage":["https://openalex.org/I4210112678"]}],"countries":["CO"],"is_corresponding":false,"raw_author_name":"Lissette Hern\u00e1ndez-Fernandez","raw_affiliation_strings":["Universidad de la Costa, Barranquilla, Colombia"],"affiliations":[{"raw_affiliation_string":"Universidad de la Costa, Barranquilla, Colombia","institution_ids":["https://openalex.org/I4210112678"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085865038","display_name":"Ernesto Garc\u00eda Cali","orcid":"https://orcid.org/0000-0003-0968-7104"},"institutions":[{"id":"https://openalex.org/I4210112678","display_name":"University of the Coast","ror":"https://ror.org/01v5nhr20","country_code":"CO","type":"education","lineage":["https://openalex.org/I4210112678"]}],"countries":["CO"],"is_corresponding":false,"raw_author_name":"Ernesto Garc\u00eda Cali","raw_affiliation_strings":["Universidad de la Costa, Barranquilla, Colombia"],"affiliations":[{"raw_affiliation_string":"Universidad de la Costa, Barranquilla, Colombia","institution_ids":["https://openalex.org/I4210112678"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5049100140"],"corresponding_institution_ids":["https://openalex.org/I169877490"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":18.9839,"has_fulltext":false,"cited_by_count":49,"citation_normalized_percentile":{"value":0.99584245,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"3","last_page":"11"},"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.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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.9966999888420105,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9735999703407288,"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/computer-science","display_name":"Computer science","score":0.8280614614486694},{"id":"https://openalex.org/keywords/software-deployment","display_name":"Software deployment","score":0.5903009176254272},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5894144773483276},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5874240398406982},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5104590654373169},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.47498005628585815},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4612722396850586},{"id":"https://openalex.org/keywords/performance-improvement","display_name":"Performance improvement","score":0.4141841232776642},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23804420232772827},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.20381614565849304},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.092450350522995},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.08529812097549438}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8280614614486694},{"id":"https://openalex.org/C105339364","wikidata":"https://www.wikidata.org/wiki/Q2297740","display_name":"Software deployment","level":2,"score":0.5903009176254272},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5894144773483276},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5874240398406982},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5104590654373169},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.47498005628585815},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4612722396850586},{"id":"https://openalex.org/C2778915421","wikidata":"https://www.wikidata.org/wiki/Q3643177","display_name":"Performance improvement","level":2,"score":0.4141841232776642},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23804420232772827},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.20381614565849304},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.092450350522995},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.08529812097549438},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/978-3-319-93803-5_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-319-93803-5_1","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:repositorio.cuc.edu.co:11323/1616","is_oa":false,"landing_page_url":"https://hdl.handle.net/11323/1616","pdf_url":null,"source":{"id":"https://openalex.org/S4377196388","display_name":"DSPACE System - Metalibrary (University of the Coast)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210112678","host_organization_name":"University of the Coast","host_organization_lineage":["https://openalex.org/I4210112678"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"http://purl.org/coar/version/c_ab4af688f83e57aa"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.6499999761581421}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1544987692","https://openalex.org/W1556530724","https://openalex.org/W1600880963","https://openalex.org/W2056640031","https://openalex.org/W2060091058","https://openalex.org/W2082383740","https://openalex.org/W2158202508","https://openalex.org/W2171898390","https://openalex.org/W2564489564","https://openalex.org/W2738342198","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W96612179","https://openalex.org/W2770234245","https://openalex.org/W2566006169","https://openalex.org/W2987774938","https://openalex.org/W632915154","https://openalex.org/W4229499248","https://openalex.org/W4378874356","https://openalex.org/W2055733372","https://openalex.org/W2369811061","https://openalex.org/W2356335648"],"abstract_inverted_index":null,"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":22},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}