Methods Inf Med 1995; 34(03): 266-271
DOI: 10.1055/s-0038-1634605
Original Article
Schattauer GmbH

Semi-automated Database Design by the End-user

W. d’Hollosy
1   Department of Urology, University Hospital Nijmegen, The Netherlands
,
M. H. F. Walrave
1   Department of Urology, University Hospital Nijmegen, The Netherlands
,
B. Th. Hendriks
1   Department of Urology, University Hospital Nijmegen, The Netherlands
,
F. M. J. Debruyne
1   Department of Urology, University Hospital Nijmegen, The Netherlands
,
H. Wijkstra
1   Department of Urology, University Hospital Nijmegen, The Netherlands
› Author Affiliations
Further Information

Publication History

Publication Date:
16 February 2018 (online)

Abstract:

An information system was developed to manage the data for a large number of research projects simultaneously. The system, called URIS, has facilitated the management of research data in an academic urological department. It enables end-users, who are not necessarily skilled computer scientists, to design their own databases semi-automatically, by supporting data entry screen design and the specification of research items. The system creates the database tables automatically after these activities. The specification of research items is the most important but also most difficult part in this process.

 
  • References

  • 1 Herson J. Personal computer software for clinical trials. In: Rotmensz N. ed. Data Management and Clinical Trials. Amsterdam: Elsevier Science Publ; 1989: 235-46.
  • 2 Date CJ. An Introduction to Database Systems. Vol 1 4th ed. New York: Addison-Wesley; 1986
  • 3 Wiederhold G. Database Design. 2nd ed. Tokyo: McGrew-Hill; 1983
  • 4 Zwetsloot-Schonk JHM. Use a hospital database to determine the characteristics of diagnostic tests. Meth Inform Med 1990; 29: 205-12.
  • 5 Gelber RD, Goldhirsch A. Statistics in clinical trials. In: Rotmensz N. ed. Data Management and Clinical Trials. Amsterdam: Elsevier Science Publ; 1989: 175-204.
  • 6 Koval JJ, Kwarciak LM, Grace MGA, Lockwood BJ. A comprehensive database management system for a variety of clinical trials. Meth Inform Med 1987; 26: 24-30.
  • 7 Choudhury MH, Shah MA, Bojanczyk MT. PC-based research-oriented clinical information system: a case study of Kuwait. Med Inform 1991; 16: 323-29.
  • 8 Morrison LM, Small DR, Glen ES. Computer applications in a urology department. Brit J Urol 1991; 67: 257-62.
  • 9 Mustard RA, Cosolo A, Fisher J, Pike T, Schouten BD, Swanson HT. PC-based system for collection and analysis of physiological data. Comp Biol Med 1990; 20: 65-74.
  • 10 Carter PG, Adams D, Abrams P. Personal computers and urological research. Brit J Urol 1992; 69: 456-9.
  • 11 de la Rosette JJ, Froeling FM, Debruyne FM. Clinical results with microwave thermotherapy of benign prostatic hyperplasia. Eur Urol 1993; 23 (Suppl. 01) 68-71.
  • 12 Witjes WP, van der Meijden PM, Roos EP. et al. BCG-RIVM versus BCG-Tice versus mitomycin-C in superficial bladder cancer. Rationale, design, and interim analysis of the trial of the South-East Co-operative Urological Group, The Netherlands. Prog Clin Biol Res 1992; 378: 59-67.
  • 13 Koldewijn EL, Van Kerrebroeck PEV, Rosier P, Wijkstra H, Debruyne FMJ. Bladder compliance after posterio sacral rhizotomies and anterior sacral root stimulation. J Urol 1994; 15: 955-60.
  • 14 Helms RW, McCanless I. The conflict between relational databases and the hierarchical structure of clinical trial data. Controlled Clinical Trials 1990; 11: 7-11.
  • 15 Goble CA, Glowinski A, Jeffery KG. Semantic constraints in a medical information system. In: Lecture Notes in Computer Science: Advances in Databases 1993; 696: 40-57.
  • 16 Wyatt J, Altman D, Pantin C. et al. Design-a-Trial, a knowledge-based aid for writers of clinical protocols. In: Reichert A, Sadan B, Bengtsson S, Bryant J, Piccolo U. eds. Proceedings Medical Informatics Europe ’93. London: Freund Ltd; 1993: 68-73.