PubMed Health⌕ Search
Home/Archive/PubMed

PubMed · 8563295

Querying temporal clinical databases with different time granularities: the GCH-OSQL language.

C Combi·F Pinciroli·M Cavallaro·G Cucchi
View original source ↗Export metadata ↓

Abstract

There is a need for managing temporal clinical information given at different levels of granularity. Different time granularities are also needed in querying clinical databases. In this paper, we describe GCH-OSQL (Granular Clinical History--Object Structured Query Language), an object-oriented temporally-oriented extension of SQL. GCH-OSQL is based on an object-oriented temporal data model. It allows storage of clinical information at different and mixed granularities. GCH-OSQL deals with the valid time of clinical information. GCH-OSQL offers also a graphical user-interface. It guides different end users, from expert to naive, to formulate expressive and correct queries.

Explore related subjects

Computer GraphicsHospital Information SystemsMedical Records Systems, ComputerizedModels, TheoreticalProgramming LanguagesTimeTime FactorsUser-Computer InterfaceJournal ArticleResearch Support, Non-U.S. Gov't

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

C Combi, F Pinciroli, M Cavallaro, G Cucchi. 1995. Querying temporal clinical databases with different time granularities: the GCH-OSQL language.. https://pubmed.ncbi.nlm.nih.gov/8563295/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed2007

[Electronic documentation of injuries of the hand with a semantic network: effective and efficient methods for the documentation of clinical and administrative processes].

BACKGROUND: An efficient medical documentation is mandatory for a trauma-oriented department in the DRG environment. Besides the continuously increasing clinical/administrative demands, the additional documentation for quality assurance, clinical studies, and research requires additional efforts. Standard solutions are only partially effective. Especially in hand surgery there is a high demand for sophisticated clinical documentation, represented by a wide variety of classifications in diagnosis and therapy. The standard documentation tools lack accuracy. The development of a software tool that defines administrative/business processes and simultaneously generates clinical and administrative information was the goal of this project. METHODS AND RESULTS: With a standard medical terminology, an innovative semantic network, and a completely new graphical user interface, it was possible to develop and introduce a software program specifically adjusted for hand surgery. This program facilitated for the first time a single-stage acquisition of clinically relevant scientific data and the simultaneous generation of DRG, quality assurance, and administrative data relevant for the hospital's revenues. CONCLUSIONS: The newly developed software tool is a step forward into a new dimension of medical software, obviating the need for multi/documentation and significantly improving the quality of clinically relevant medical data.

Computer Graphics↗
PubMed2007

Open-source software for radiologists: a primer.

There is a wide variety of free (open-source) software available via the Internet which may be of interest to radiologists. This article will explore the use of open-source software in radiology to help streamline academic workflow and improve general efficiency and effectiveness by highlighting a number of the most useful applications currently available. These include really simple syndication applications, e-mail management, spreadsheet, word processing, database and presentation packages, as well as image and video editing software. How to incorporate this software into radiological practice will also be discussed.

Computer Graphics↗
PubMed2006

UniHI: an entry gate to the human protein interactome.

Systematic mapping of protein-protein interactions has become a central task of functional genomics. To map the human interactome, several strategies have recently been pursued. The generated interaction datasets are valuable resources for scientists in biology and medicine. However, comparison reveals limited overlap between different interaction networks. This divergence obstructs usability, as researchers have to interrogate numerous heterogeneous datasets to identify potential interaction partners for proteins of interest. To facilitate direct access through a single entry gate, we have started to integrate currently available human protein interaction data in an easily accessible online database. It is called UniHI (Unified Human Interactome) and is available at http://www.mdc-berlin.de/unihi. At present, it is based on 10 major interaction maps derived by computational and experimental methods. It includes more than 150,000 distinct interactions between more than 17 000 unique human proteins. UniHI provides researchers with a flexible integrated tool for finding and using comprehensive information about the human interactome.

Computer Graphics↗