Download PDF
Methods Inf Med 1981; 20(03): 133-141
DOI: 10.1055/s-0038-1635301
Original Article
Schattauer GmbH

A Perinatal Database Management System[*]

EIN DATENBANKSYSTEM ZUR VERWALTUNG PERINATALER DATEN
L. Chik
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
,
J. Sokol
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
,
R. Kooi
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
,
S. Pillay
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
,
J. Hirsch
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
,
I. Zador
1   From the Department of Obstetrics and Gynecology and the Perinatal Clinical Research Center, Cleveland Metropolitan General Hospital, Case Western Reserve University, Cleveland, Ohio
› Author Affiliations
Further Information

Publication History

Publication Date:
15 February 2018 (online)

    Permissions and Reprints

Obstetric services have long recognized the need for ongoing evaluation of their experiences. Manual »departmental statistics« systems sufficed, but with the advent of more sophisticated care, perinatal re-gionalization and increased research activity, the potential usefulness of computer technology became obvious. At Cleveland Metropolitan General Hospital, a laboratory computer based patient information file system was designed and implemented beginning in 1974. Over the succeeding six years, data have been collected and stored for all delivered pregnancies. There are now over 61,000 files for more than 20,000 consecutively delivered patients. The system provides over 40,000 clinical reports per year. However, the use of a file-oriented system has limited our ability to respond to specific research queries. The application of a relational database management system, INGRES, for perinatal information is reported here. Examples of its use for efficiently »answering questions« are presented, as are guidelines for the development and implementation of computer-based perinatal record systems.

In der Geburtshilfe ist die Notwendigkeit einer laufenden Auswertung der klinischen Erfahrungen seit langem erkannt worden. Manuelle statistische Systeme in den Abteilungen genügten zunächst; aber mit dem Aufkommen differenzierterer Versorgung, perinataler Regionalisierung und zunehmender Forschungstätigkeit wurde die potentielle Nützlichkeit der Computertechnik offensichtlich. Im Cleveland Metropolitan General Hospital wurde im Jahre 1974 ein computerunterstütztes Informationssystem für Patientendaten aus dem Laboratorium geplant und implementiert. In den folgenden sechs Jahren wurden Daten über alle Entbindungen gesammelt und gespeichert. Derzeit existieren mehr als 61,000 Krankenbetten für mehr als 20,000 nacheinander entbundene Patientinnen. Das System liefert über 40,000 klinische Berichte pro Jahr. Allerdings hat die Benutzung eines Datei-orientierten Systems unsere Fähigkeit, spezifische Suchanfragen zu beantworten, eingeschränkt.

In der vorliegenden Arbeit wird über die Anwendung eines relationalen Datenbankverwaltungssystems, INGRES, für perinatale Daten berichtet. Es werden Beispiele für seine Verwendung zur gut funktionierenden Beantwortung von Anfragen sowie Richtlinien für die Entwicklung und Implementierung von Compu-ter-unterstützten Berichtssystemen über perinatale Daten beschrieben.

Key-Words:

Perinatal Database - Relational Database - INGRES - Pregnancy Risk

Schlüssel-Wörter:

Perinatale Datenbank - relationale Datenbank - INGRES - Schwangerschaftsrisiko

* Supported in part by NIH USPHS Grants M01-RR00210 and 1P50 HD 11089 and NIAAA Grant AA 03282


 

  • References

  • 1 Chik L. C, Sokol R. J, Rosen M. G, Regula G, Borgstedt A. Computer Interpreted Fetal Monitoring Data: Discriminant Function Analysis of Perinatal Data for the Classification of One Year Neurological Outcome. J. Pediat 90 1977; 985-989.
    CrossrefPubMedSearch in Google Scholar
  • 2 Date C. J. An Introduction to Database Systems. 2nd Edition. Reading, Mass., Menlo Park, Calif., London, Amsterdam, Don Mills, Ontario, Sydney: Addison-Wesley; 1975
    Search in Google Scholar
  • 3 Dixon W. J. BMDP Biomedical Computer Programs. Berkeley and Los Angeles: University of California Press; 1975
    Search in Google Scholar
  • 4 DOS/Batch Handbock: Monitor Version VØ 9 Maynard, Mass: Digital Equipment Corporation; 1974
  • 5 Hobel C. J, Hyvarinen M. A, Okada D. M, Oh W. Prenatal and Intrapartum High Risk Screening. Amer. J. Obstet. Gynecol 1973; 117: 1-9.
    CrossrefPubMedSearch in Google Scholar
  • 6 Jelovsek F, Hammond W. Formal Error Rate in a Computerized Obstetric Medical Record. Meth. Inform. Med 1978; 17: 151-157.
    PubMedSearch in Google Scholar
  • 7 Jennett R. J, Gall D, Waterkotte G. W, Warford H. S. A Computerized Perinatal Data System for a Region. Amer. J. Obstet. Gynecol 1978; 131: 157-163.
    CrossrefPubMedSearch in Google Scholar
  • 8 Komaroff A. L. The Variability and Inaccuracy of Medical Data. Proc. IEEE 1979; 67: 1196-1207.
    CrossrefPubMedSearch in Google Scholar
  • 9 Kooi R. The Optimization of Queries in Relational Database. Ph. D. Dissertation. Cleveland, Ohio: Case Western Reserve University; 1980
    Search in Google Scholar
  • 10 Morgan M, Studney D. R, Barnett G. O, Winickoff R. N. Computerized Concurrent Review of Prenatal Care. Quality Rev. Bull 1978; 4: 33-36.
    PubMedSearch in Google Scholar
  • 11 National Institute of Child Health and Human Development: Concensus Development Conference on Antenatal-Task Force Report on Predictors of Fetal Distress. (U.S. Dept. of HEW (PHS) Office of Research Reporting, March 5-7 1979: III-82-III-84.
  • 12 Rey H. R, James L. S, Van de Wiele R. Optimized Search for Parameters Useful in the Interpretation of Fetal Heart Rate Data. Med. Instrum 1979; 13: 337-343.
    PubMedSearch in Google Scholar
  • 13 Rosen M. G, Sokol R. J, Chik L. C. The Use of Computers in the Labor and Delivery Suite — An Overview. Amer. J. Obstet. Gynecol 1978; 132: 589-594.
    CrossrefPubMedSearch in Google Scholar
  • 14 Sokol R. J, Miller S. I, Reed G. Alcohol Abuse during Pregnancy: An. Epidemiologic Study. Alcoholism: Clin. ex-per. Res 1980; 4: 135-145.
    PubMedSearch in Google Scholar
  • 15 Sokol R. J, Nussbaum R, Chik L. C, Rosen M. G. Computer Diagnosis of Labor Progression: I. Development of an On-Line Interactive Digital Computer Program for the Diagnosis of Normal and Abnormal Cervical Dilatation Patterns. J. reprod. Med 1973; 11: 149-153.
    PubMedSearch in Google Scholar
  • 16 Sokol R. J, Nussbaum R, Chik L. C, Rosen M. G. Computer Diagnosis of Labor Progression: IV. An On-Line Interactive Digital Computer Subroutine for Evaluating Descent of the Fetal Presenting Part during Labor. J. reprod. Med 1974; 13: 177-182.
    PubMedSearch in Google Scholar
  • 17 Sokol R. J, Rosen M. G, Stojkov J, Chik L. C. Clinical Application of High Risk Scoring on an Obstetric Service. Amer. J. Obstet. Gynecol 1977; 128: 652-661.
    CrossrefPubMedSearch in Google Scholar
  • 18 Sokol R. J, Rosen M. G, Stojkov J, Chik L. C. Computer Assisted Antepartum Risk Identification and Intervention: Description and Preliminary Evaluation of Impact. Proc. Third Illinois Conf. Med. Inform. Syst Chicago Ill., November 4-5 1977: 321-325.
    Search in Google Scholar
  • 19 Sokol R. J, Stojkov J, Chik L. C. Maternal — Fetal Risk Assessment: A Clinical Guide to Monitoring. Clin. Obstet. Gynecol 1979; 22: 547-560.
    CrossrefPubMedSearch in Google Scholar
  • 20 Stead W. W, Brame R. G, Hammond W. E, Jelovsek F. R, Estes E. H, Parker R. T. A Computerized Obstetric Medical Record. Obstet. Gynecol 1977; 49: 502-509.
    PubMedSearch in Google Scholar
  • 21 Studney D. R, Adams J. B, Gorbach A, Guenthner S, Morgan M. M, Barnett G. O. A Computerized Prenatal Record. Obstet. Gynecol 1977; 50: 82-87.
    PubMedSearch in Google Scholar
  • 22 System 360 Scientific Subroutine Package (360A-CM-031): Version III Programmer’s Manual White Plains, N.Y.: IBM; 1968
  • 23 Unix Time-Sharing System Bell System Techn. J. 1978; 57: 1897-2312.
    PubMedSearch in Google Scholar
  • 24 Wasserman A. I. Clinical Information and Relational Database Organization. Proc. Second Illinois Conf. Med. Informat. Syst Urbana, Ill., September 24-25 1975: 81-91.
    Search in Google Scholar
  • 25 Woodfill J. Ingres Version 6.2 Reference Manual. (Berkeley, California: University of California at Berkeley 1979. See also Stonebraker, M., Wong, E., Kreps, P.: The Design and Implementation of INGRES. ACM Trans. Database Syst 1 1976; 189-222.
    PubMedSearch in Google Scholar