Development of an oral health database for the management of clinical records

Detalhes bibliográficos
Autor(a) principal: Blomberg, Luciano Costa
Data de Publicação: 2009
Outros Autores: Mota, Eduardo Gonçalves, de Figueiredo, José Antônio Poli, Ruiz, Duncan Dubugras Alcoba
Tipo de documento: Artigo
Idioma: eng
Título da fonte: Revista odonto ciência (Online)
Texto Completo: https://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189
Resumo: Purpose: The aim of this article was to present the conceptual model and development of an oral health database for storage, organization, and recovery of data from dental clinical records of a university dental school. Method: This is a joint project of the Graduate Programs in Dentistry and in Computational Science of the Pontifical Catholic University of Rio Grande do Sul (PUCRS). During a period of three months in 2008, semi-structured interviews were conducted with the dental faculty of five clinical areas of the PUCRS Dental School (FO-PUCRS). Collected data were used to build the database language and architecture. Results: Conceptual, logical, and physical database models were developed, as well as the generation of a script in SQL (Structured Query Language). After generating the script, the tool Oracle SQL Developer (Oracle Corporation, Redwood Shores, CA, USA) was used to import and create the FO-PUCRS OHDB (Oral Health Database) implemented in the Oracle 10 g, a relational database management system (RDBMS). Conclusion: The FO-PUCRS OHDB represents an important advancement towards automating the institutional operational demands and will contribute to organize the clinical and social information of the patient population for administrative, educational, and research purposes.
id PUC_RS-22_89f7c8de35aafbb0343b317a8098cc57
oai_identifier_str oai:ojs.revistaseletronicas.pucrs.br:article/5189
network_acronym_str PUC_RS-22
network_name_str Revista odonto ciência (Online)
repository_id_str
spelling Development of an oral health database for the management of clinical recordsDesenvolvimento de um banco de dados de saúde bucal para administração de registros clínicosOral healthdata modelingdatabaseclinical recordsPurpose: The aim of this article was to present the conceptual model and development of an oral health database for storage, organization, and recovery of data from dental clinical records of a university dental school. Method: This is a joint project of the Graduate Programs in Dentistry and in Computational Science of the Pontifical Catholic University of Rio Grande do Sul (PUCRS). During a period of three months in 2008, semi-structured interviews were conducted with the dental faculty of five clinical areas of the PUCRS Dental School (FO-PUCRS). Collected data were used to build the database language and architecture. Results: Conceptual, logical, and physical database models were developed, as well as the generation of a script in SQL (Structured Query Language). After generating the script, the tool Oracle SQL Developer (Oracle Corporation, Redwood Shores, CA, USA) was used to import and create the FO-PUCRS OHDB (Oral Health Database) implemented in the Oracle 10 g, a relational database management system (RDBMS). Conclusion: The FO-PUCRS OHDB represents an important advancement towards automating the institutional operational demands and will contribute to organize the clinical and social information of the patient population for administrative, educational, and research purposes.Objetivo: Este artigo teve como objetivo documentar o trabalho realizado em conjunto pelos Programas de Pós-Graduação em Odontologia (PPGO), e Ciência da Computação (PPGCC) da Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS), visando à construção de um ambiente de armazenamento, organização e recuperação de dados provenientes de prontuários odontológicos. Método: Durante 3 meses em 2008 foram realizadas entrevistas semiestruturadas com docentes de cinco áreas de atendimento odontológico da Faculdade de Odontologia (FO-PUCRS) para análise e coleta de requisitos. Resultados: Com base nas informações obtidas neste processo, foram desenvolvidas as modelagens conceitual, lógica e física do banco de dados, bem como a geração de um script em SQL (Structured Query Language). Após a geração do script, foi utilizada a ferramenta Oracle SQL Developer (Oracle Corporation, Redwood Shores, CA, USA) para sua importação e criação do BDSB (Banco de Dados em Saúde Bucal) implementado no SGBD (Sistema Gerenciador de Banco de Dados) relacional Oracle 10 g. Conclusão: A construção do BDSB junto ao PPGO-PUCRS representa um importante avanço em direção a automatização das demandas operacionais da organização, mas principalmente a exploração de uma fonte valiosa de conhecimento, rica em informações clínicas e sociais.EDIPUCRS - Editora Universitária da PUCRS2009-07-10info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionPeer-reviewed Articleapplication/pdfhttps://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189Revista Odonto Ciência; Vol. 24 No. 3 (2009); 249 - 253Revista Odonto Ciência; v. 24 n. 3 (2009); 249 - 2531980-65230102-9460reponame:Revista odonto ciência (Online)instname:Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS)instacron:PUC_RSenghttps://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189/4506Blomberg, Luciano CostaMota, Eduardo Gonçalvesde Figueiredo, José Antônio PoliRuiz, Duncan Dubugras Alcobainfo:eu-repo/semantics/openAccess2013-11-11T13:06:25Zoai:ojs.revistaseletronicas.pucrs.br:article/5189Revistahttps://revistaseletronicas.pucrs.br/ojs/index.php/foPRIhttps://revistaseletronicas.pucrs.br/ojs/index.php/fo/oai||odontociencia@pucrs.br1980-65230102-9460opendoar:2013-11-11T13:06:25Revista odonto ciência (Online) - Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS)false
dc.title.none.fl_str_mv Development of an oral health database for the management of clinical records
Desenvolvimento de um banco de dados de saúde bucal para administração de registros clínicos
title Development of an oral health database for the management of clinical records
spellingShingle Development of an oral health database for the management of clinical records
Blomberg, Luciano Costa
Oral health
data modeling
database
clinical records
title_short Development of an oral health database for the management of clinical records
title_full Development of an oral health database for the management of clinical records
title_fullStr Development of an oral health database for the management of clinical records
title_full_unstemmed Development of an oral health database for the management of clinical records
title_sort Development of an oral health database for the management of clinical records
author Blomberg, Luciano Costa
author_facet Blomberg, Luciano Costa
Mota, Eduardo Gonçalves
de Figueiredo, José Antônio Poli
Ruiz, Duncan Dubugras Alcoba
author_role author
author2 Mota, Eduardo Gonçalves
de Figueiredo, José Antônio Poli
Ruiz, Duncan Dubugras Alcoba
author2_role author
author
author
dc.contributor.author.fl_str_mv Blomberg, Luciano Costa
Mota, Eduardo Gonçalves
de Figueiredo, José Antônio Poli
Ruiz, Duncan Dubugras Alcoba
dc.subject.por.fl_str_mv Oral health
data modeling
database
clinical records
topic Oral health
data modeling
database
clinical records
description Purpose: The aim of this article was to present the conceptual model and development of an oral health database for storage, organization, and recovery of data from dental clinical records of a university dental school. Method: This is a joint project of the Graduate Programs in Dentistry and in Computational Science of the Pontifical Catholic University of Rio Grande do Sul (PUCRS). During a period of three months in 2008, semi-structured interviews were conducted with the dental faculty of five clinical areas of the PUCRS Dental School (FO-PUCRS). Collected data were used to build the database language and architecture. Results: Conceptual, logical, and physical database models were developed, as well as the generation of a script in SQL (Structured Query Language). After generating the script, the tool Oracle SQL Developer (Oracle Corporation, Redwood Shores, CA, USA) was used to import and create the FO-PUCRS OHDB (Oral Health Database) implemented in the Oracle 10 g, a relational database management system (RDBMS). Conclusion: The FO-PUCRS OHDB represents an important advancement towards automating the institutional operational demands and will contribute to organize the clinical and social information of the patient population for administrative, educational, and research purposes.
publishDate 2009
dc.date.none.fl_str_mv 2009-07-10
dc.type.driver.fl_str_mv info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
Peer-reviewed Article
format article
status_str publishedVersion
dc.identifier.uri.fl_str_mv https://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189
url https://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189
dc.language.iso.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv https://revistaseletronicas.pucrs.br/ojs/index.php/fo/article/view/5189/4506
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv EDIPUCRS - Editora Universitária da PUCRS
publisher.none.fl_str_mv EDIPUCRS - Editora Universitária da PUCRS
dc.source.none.fl_str_mv Revista Odonto Ciência; Vol. 24 No. 3 (2009); 249 - 253
Revista Odonto Ciência; v. 24 n. 3 (2009); 249 - 253
1980-6523
0102-9460
reponame:Revista odonto ciência (Online)
instname:Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS)
instacron:PUC_RS
instname_str Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS)
instacron_str PUC_RS
institution PUC_RS
reponame_str Revista odonto ciência (Online)
collection Revista odonto ciência (Online)
repository.name.fl_str_mv Revista odonto ciência (Online) - Pontifícia Universidade Católica do Rio Grande do Sul (PUCRS)
repository.mail.fl_str_mv ||odontociencia@pucrs.br
_version_ 1754820874902437888

Registros relacionados