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

Uloženo v:
Podrobná bibliografie
Název: Development of an oral health database for the management of clinical records.
Alternate Title: Desenvolvimento de um banco de dados de saúde bucal para administração de registros clínicos.
Autoři: Blomberg, Luciano Costa1, Mota, Eduardo Gonçalves2 eduardo.mota@pucrs.br, de Figueiredo, José Antônio Poli2, Ruiz, Duncan Dubugras A.1
Zdroj: Revista Odonto Ciencia. 2009, Vol. 24 Issue 3, p249-253. 5p. 1 Color Photograph, 2 Diagrams, 1 Chart.
Témata: Computers in dentistry, Management of medical records, Database design, Dental schools, Data recovery, SQL
Geografický termín: Rio Grande do Sul (Brazil : State), Brazil
Korporace: Oracle Corp. 144709193 ORCL
Abstract (English): 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. [ABSTRACT FROM AUTHOR]
Abstract (Portuguese): 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. [ABSTRACT FROM AUTHOR]
Databáze: Supplemental Index
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://resolver.ebscohost.com/openurl?sid=EBSCO:edo&genre=article&issn=01029460&ISBN=&volume=24&issue=3&date=20090701&spage=249&pages=249-253&title=Revista Odonto Ciencia&atitle=Development%20of%20an%20oral%20health%20database%20for%20the%20management%20of%20clinical%20records.&aulast=Blomberg%2C%20Luciano%20Costa&id=DOI:
    Name: Full Text Finder
    Category: fullText
    Text: Full Text Finder
    Icon: https://imageserver.ebscohost.com/branding/images/FTF.gif
    MouseOverText: Full Text Finder
  – Url: https://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=EBSCO&SrcAuth=EBSCO&DestApp=WOS&ServiceName=TransferToWoS&DestLinkType=GeneralSearchSummary&Func=Links&author=Blomberg%20LC
    Name: ISI
    Category: fullText
    Text: Nájsť tento článok vo Web of Science
    Icon: https://imagesrvr.epnet.com/ls/20docs.gif
    MouseOverText: Nájsť tento článok vo Web of Science
Header DbId: edo
DbLabel: Supplemental Index
An: 47222987
RelevancyScore: 833
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 833.485717773438
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Development of an oral health database for the management of clinical records.
– Name: TitleAlt
  Label: Alternate Title
  Group: TiAlt
  Data: Desenvolvimento de um banco de dados de saúde bucal para administração de registros clínicos.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Blomberg%2C+Luciano+Costa%22">Blomberg, Luciano Costa</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Mota%2C+Eduardo+Gonçalves%22">Mota, Eduardo Gonçalves</searchLink><relatesTo>2</relatesTo><i> eduardo.mota@pucrs.br</i><br /><searchLink fieldCode="AR" term="%22de+Figueiredo%2C+José+Antônio+Poli%22">de Figueiredo, José Antônio Poli</searchLink><relatesTo>2</relatesTo><br /><searchLink fieldCode="AR" term="%22Ruiz%2C+Duncan+Dubugras+A%2E%22">Ruiz, Duncan Dubugras A.</searchLink><relatesTo>1</relatesTo>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22Revista+Odonto+Ciencia%22">Revista Odonto Ciencia</searchLink>. 2009, Vol. 24 Issue 3, p249-253. 5p. 1 Color Photograph, 2 Diagrams, 1 Chart.
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Computers+in+dentistry%22">Computers in dentistry</searchLink><br /><searchLink fieldCode="DE" term="%22Management+of+medical+records%22">Management of medical records</searchLink><br /><searchLink fieldCode="DE" term="%22Database+design%22">Database design</searchLink><br /><searchLink fieldCode="DE" term="%22Dental+schools%22">Dental schools</searchLink><br /><searchLink fieldCode="DE" term="%22Data+recovery%22">Data recovery</searchLink><br /><searchLink fieldCode="DE" term="%22SQL%22">SQL</searchLink>
– Name: SubjectGeographic
  Label: Geographic Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Rio+Grande+do+Sul+%28Brazil+%3A+State%29%22">Rio Grande do Sul (Brazil : State)</searchLink><br /><searchLink fieldCode="DE" term="%22Brazil%22">Brazil</searchLink>
– Name: SubjectCompany
  Label: Company/Entity
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Oracle+Corp%2E%22">Oracle Corp.</searchLink> <searchLink fieldCode="DN" term="%22144709193%22">144709193</searchLink> <searchLink fieldCode="TK" term="%22ORCL%22">ORCL</searchLink>
– Name: Abstract
  Label: Abstract (English)
  Group: Ab
  Data: 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. [ABSTRACT FROM AUTHOR]
– Name: Abstract
  Label: Abstract (Portuguese)
  Group: Ab
  Data: 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. [ABSTRACT FROM AUTHOR]
PLink https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edo&AN=47222987
RecordInfo BibRecord:
  BibEntity:
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 5
        StartPage: 249
    Subjects:
      – SubjectFull: Rio Grande do Sul (Brazil : State)
        Type: general
      – SubjectFull: Brazil
        Type: general
      – SubjectFull: Oracle Corp.
        Type: general
      – SubjectFull: Computers in dentistry
        Type: general
      – SubjectFull: Management of medical records
        Type: general
      – SubjectFull: Database design
        Type: general
      – SubjectFull: Dental schools
        Type: general
      – SubjectFull: Data recovery
        Type: general
      – SubjectFull: SQL
        Type: general
    Titles:
      – TitleFull: Development of an oral health database for the management of clinical records.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Blomberg, Luciano Costa
      – PersonEntity:
          Name:
            NameFull: Mota, Eduardo Gonçalves
      – PersonEntity:
          Name:
            NameFull: de Figueiredo, José Antônio Poli
      – PersonEntity:
          Name:
            NameFull: Ruiz, Duncan Dubugras A.
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 07
              Text: 2009
              Type: published
              Y: 2009
          Identifiers:
            – Type: issn-print
              Value: 01029460
          Numbering:
            – Type: volume
              Value: 24
            – Type: issue
              Value: 3
          Titles:
            – TitleFull: Revista Odonto Ciencia
              Type: main
ResultId 1