{"id":"https://openalex.org/W1903320522","doi":null,"title":"TUNING - t\u00e9cnicas de otimiza\u00e7\u00e3o de banco de dados um estudo comparativo: mysql e postgresql","display_name":"TUNING - t\u00e9cnicas de otimiza\u00e7\u00e3o de banco de dados um estudo comparativo: mysql e postgresql","alternate_titles":[],"publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W1903320522","mag":"1903320522"},"language":"pt","primary_location":{"id":"mag:1903320522","doi":null,"is_oa":false,"landing_page_url":"http://repositorio.furg.br/bitstream/1/1692/1/TUNING.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1903320522"],"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/A5082013799","display_name":"Alessandro Pinto Carneiro","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alessandro Pinto Carneiro","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006507333","display_name":"Juliano Lucas Moreira","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Juliano Lucas Moreira","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5085811692","display_name":"Andr\u00e9 Lu\u00eds Castro de Freitas","orcid":"https://orcid.org/0000-0002-4566-3655","observed_orcids":["https://orcid.org/0000-0002-4566-3655"]},"institutions":[{"id":"https://openalex.org/I126460647","display_name":"Universidade Federal do Rio Grande","ror":"https://ror.org/05hpfkn88","country_code":"BR","type":"education","lineage":["https://openalex.org/I126460647"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Andr\u00e9 Lu\u00eds Castro de Freitas","raw_affiliation_strings":["Universidade  Federal do Rio Grande"],"raw_orcid":"https://orcid.org/0000-0002-4566-3655","affiliations":[{"raw_affiliation_string":"Universidade  Federal do Rio Grande","institution_ids":["https://openalex.org/I126460647"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9932000041007996,"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.9932000041007996,"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.0010000000474974513,"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.0008999999845400453,"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/database-tuning","display_name":"database performance tuning","score":0.9959999918937683},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.9459999799728394},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.9509999752044678},{"id":"https://openalex.org/keywords/query-time","display_name":"query response time","score":0.5479999780654907}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5027298927307129},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4558781683444977},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.43148475885391235},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3722377419471741},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.2542577385902405},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1346552073955536},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:1903320522","doi":null,"is_oa":false,"landing_page_url":"http://repositorio.furg.br/bitstream/1/1692/1/TUNING.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"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":0,"referenced_works":[],"related_works":["https://openalex.org/W2894551928","https://openalex.org/W2618236673","https://openalex.org/W2756042898","https://openalex.org/W7098572750","https://openalex.org/W579960383","https://openalex.org/W2792812151","https://openalex.org/W1602865836","https://openalex.org/W86426951","https://openalex.org/W2739266444","https://openalex.org/W2589808969"],"abstract_inverted_index":{"The":[0],"importance":[1,101],"of":[2,45,61,80,89,100,102],"the":[3,6,10,12,17,29,33,46,59,62,68,71,75,78,81,90],"information":[4],"for":[5,21],"decision":[7],"making":[8],"in":[9,36,64,70,77,105],"organizations,":[11],"increase":[13],"data":[14],"quantity":[15],"and":[16,74,94],"time":[18],"to":[19,32,52],"search":[20],"information,":[22],"they":[23],"have":[24],"been":[25],"demanding":[26],"concern":[27],"with":[28,67,107],"speed":[30],"access":[31],"databases.":[34],"Considering":[35],"this":[37],"way":[38],"Tuning":[39,152],"is":[40,85,96],"evidenced":[41],"as":[42],"a":[43,98,116,140],"process":[44],"database":[47],"systems":[48],"refine,":[49],"aiming":[50],"at":[51],"improve":[53],"his":[54,108],"acting.":[55],"This":[56],"work":[57],"shows":[58],"concepts":[60],"tuning":[63,174],"PostgreSQL,":[65,176],"specifically":[66],"focus":[69],"parameters":[72],"configuration":[73,91],"impact":[76],"modification":[79],"same":[82],"ones.":[83],"It":[84],"made":[86],"an":[87],"analysis":[88],"aspects":[92],"presented":[93],"it":[95],"drawn":[97],"hierarchy":[99],"each":[103],"one":[104],"agreement":[106],"purpose.":[109],"Resumo.":[110],"A":[111],"import\u00e2ncia":[112,206],"da":[113,134],"informacao":[114],"para":[115],"tomada":[117],"de":[118,127,132,142,146,156,160,162,173,183,198,205,207,210],"decisao":[119],"nas":[120],"organizacoes,":[121],"o":[122,130,151,179,187,213],"volume":[123],"cada":[124,208],"vez":[125],"maior":[126],"dados":[128],"e":[129,186,201],"tempo":[131],"busca":[133],"informacao,":[135],"tem":[136],"exigido":[137],"preocupacao":[138],"com":[139,178,212],"velocidade":[141],"acesso":[143],"aos":[144],"bancos":[145],"dados.":[147],"Neste":[148],"contexto,":[149],"evidencia-se":[150],"como":[153],"um":[154,209],"processo":[155],"refino":[157],"dos":[158,191,196],"sistemas":[159],"banco":[161],"dados,":[163],"objetivando":[164],"melhorar":[165],"seu":[166,214],"desempenho.":[167],"Este":[168],"trabalho":[169],"apresenta":[170],"os":[171],"conceitos":[172],"no":[175],"especificamente":[177],"foco":[180],"na":[181,189],"configuracao":[182,199],"seus":[184],"par\u00e2metros":[185],"impacto":[188],"modificacao":[190],"mesmos.":[192],"Faz-se":[193],"uma":[194,203],"analise":[195],"aspectos":[197],"apresentados":[200],"traca-se":[202],"hierarquia":[204],"acordo":[211],"proposito.":[215],"Palavras-Chave.":[216],"Tuning,":[217],"SGBD,":[218],"Postgresql":[219]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1903320522","counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
