Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Retrieval from a large, integrated HIS-database through formal descriptions and SQL

M P Hooymans1, H Liefkes, J A Schipper

  • 1BAZIS Foundation, Leiden, The Netherlands.

Medinfo. MEDINFO
|January 1, 1995
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Security in Medical Information Systems.

Yearbook of medical informatics·2016
Same author

Access to medical databases; theory and practice.

Methods of information in medicine·2011
Same author

[Chemical pneumonia following ingestion of lamp oil].

Nederlands tijdschrift voor geneeskunde·2007
Same author

The need to know the history of the use of digital patient data, in particular the EHR.

International journal of medical informatics·2006
Same author

[Wheezing and cough related to congenital airway abnormalities in young infants].

Nederlands tijdschrift voor geneeskunde·2006
Same author

[Anaemia in two infants due to fetomaternal transfusion].

Nederlands tijdschrift voor geneeskunde·2005

This study demonstrates how to improve data retrieval and administration in Hospital Information Systems (HIS) using SQL and a Data Dictionary and Directory System (DD/DS). Effective data management relies on integrated systems and robust retrieval functions.

Area of Science:

  • Health Informatics
  • Database Management
  • Information Systems

Background:

  • Large-scale Hospital Information Systems (HIS) often face challenges in data retrieval and administration.
  • Existing systems may lack comprehensive facilities for non-routine data access.
  • The integration of formal data descriptions is crucial for efficient information management.

Purpose of the Study:

  • To outline the implementation of advanced data retrieval and administration capabilities within an existing HIS.
  • To demonstrate the utility of SQL as a query language for complex data access.
  • To highlight the importance of a robust Data Dictionary and Directory System (DD/DS) in conjunction with HIS.

Main Methods:

  • Utilizing SQL (Structured Query Language) for database querying.

Related Experiment Videos

  • Leveraging a comprehensive Data Dictionary and Directory System (DD/DS) for formal data descriptions.
  • Integrating these components within a large, existing Hospital Information System (HIS).

    • Main Results:

    • Successful realization of rich retrieval facilities for enhanced data access.
    • Implementation of comprehensive data administration capabilities.
    • Demonstration of SQL's effectiveness in facilitating complex database communication.

    Conclusions:

    • The approach to enhancing database access is paramount, surpassing mere technological implementation.
    • A synergistic combination of a large integrated HIS, a complete DD/DS, and strong retrieval functions maximizes benefits.
    • Effective data management and retrieval are critical for optimizing HIS functionality.