Development of an oral health database for the management of clinical records
Keywords:
Oral health, data modeling, database, clinical records,Abstract
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.Downloads
Published
Issue
Section
License
COPYRIGHT
The submission of originals to Odonto Ciência implies the transfer by the authors of the right for publication. Authors retain copyright and grant the journal right of first publication. If the authors wish to include the same data into another publication, they must cite Odonto Ciência as the site of original publication.
CREATIVE COMMONS LICENSE
As this journal is open access, the articles are allowed free use in scientific and educational applications, with citation of the source.
According to the type of Creative Commons License (CC-BY 4.0) adopted by Odonto Ciência, the user must respect the requirements below.
You are free to:
Share — copy and redistribute the material in any medium or format.
Adapt — remix, transform, and build upon the material for any purpose, even commercially.
However, only under the following terms:
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests Odonto Ciência endorses you or your use.
No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation.
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
For more details on the Creative Commons license, please follow the link in the footer of this website.
