Download PDF
Methods Inf Med 1995; 34(04): 328-339
DOI: 10.1055/s-0038-1634607
Original Article

A Graphical Query Generator for Clinical Research Databases

F. Banhart
1   University Eye Hospital Tübingen, Dept. II, Institute of Informatics, Germany
,
H. Klaeren
2   University of Tübingen, Institute of Informatics, Germany
› Author Affiliations
› Further Information
    Permissions and Reprints

Abstract:

Clinical research involves recording, storage and retrieval of disease-related patient data, typically using a database system. In order to facilitate ad hoc queries to clinical databases we have developed a query generator with a graphical interface. The query generator uses an object-oriented data model which is visualized by directed graphs. The main focus of our work was the definition of object-oriented user views to the partly complex data structures of a relational database. Furthermore, we tried to define graphical abstractions for all common types of queries. Thus, even for non-expert database users such as clinicians, it is easy to assemble highly complex queries for a thorough examination of the content of large research databases.

Keywords:

Graphical Query Languages - Object-Oriented Data Models - Database Management Systems - Clinical Research - Medical Information Systems


Publication History

Article published online:
16 February 2018

Schattauer GmbH

 

  • References

  • 1 Zloof MM. Query by example: A database language. IBM Systems Journal 1977; 4: 324-43.
    CrossrefPubMedGoogle Scholar
  • 2 Straube DD, Özsu TM. Queries and query processing in object-oriented database systems. ACM Trans Inform Systems 1990; 8: 387-430.
    CrossrefPubMedGoogle Scholar
  • 3 Bancilhon F, Delobel C, Kanellakis P. eds. Building an Object-Oriented Database System – The Story of O2 . San Mateo: Morgan Kaufmann Publ. Inc.; 1992
    Google Scholar
  • 4 Rogers TR, Cattell RGG. Entity relationship database user interface. In: Stonebraker M. ed. Readings in Database Systems. San Mateo, CA: Morgan Kaufmann Publishers; 1988: 359-68.
    Google Scholar
  • 5 Wu X, Dinkhoff G. InGraph: Graphical interface for a fully object-oriented database system. In: Deaton E, George KM, Berghel H, Hedrick G. eds. Proceedings of the 1993 A CMISIGAPP Symposium on Applied Computing. Indianapolis: ACM Press; 1993: 318-25.
    Google Scholar
  • 6 Elmasri R, Larson JA. A graphical query facility for ER databases. In: Proceedings of the 4th Int. Conference on the Entity Relationship Approach. Chicago Ill: 1985: 236-45.
    Google Scholar
  • 7 Kuntz M, Melchert R. Pasta-3’s graphical query language: direct manipulation, cooperative queries, expressive power. In: Proceedings of the 15th Int. Conference on Very Large Data Bases. Amsterdam: 1989: 97-105.
    Google Scholar
  • 8 Santucci G, Sottile PA. Query by diagram. A visual environment for querying databases. Software – practice and experience 1992; 23 (03) 317-40.
    CrossrefPubMedGoogle Scholar
  • 9 Auddino A, Dennebouy Y, Dupont Y, Fontana E, Spaccapietra S, Tari Z. SUPER – Visual interaction with an object-based ER model. In: Pernul G, Tjoa AM. eds. Entity-Relationship Approach ER ’92. Proc. of the 11th Int. Conf. on the Entity-Relationship Approach. Heidelberg: Springer Verlag; 1992: 340-56.
    Google Scholar
  • 10 Bono G, Ficorilli P. Natural language restatement of queries expressed in a graphical language. In: Pernul G, Tjoa AM. eds. Entity-Relationship Approach ER’92. Proc. ofthe 11th Int. Conf. on the Entity-Relationship Approach. Heidelberg: Springer Verlag; 1992: 357-74.
    Google Scholar
  • 11 Barsalou T. View Objects for Relational Databases. (PhD thesis): Technical Report NO STAN-CS-90-1310 Dept. of Computer Science and Medicine, Stanford University; 1990
    Google Scholar
  • 12 Sujansky W, Zingmond D, Toshiyuki M, Barsalou T. PENGUIN: An intelligent system for modelling and sharing declarative knowledge stored in a relational database. In: Lun KC, Degoulet P, Piemme TE, Rienhoff O. eds. MEDINFO 92. Amsterdam: Elsevier Publ; 1992: 466-71.
    Google Scholar
  • 13 Paredaens J, Peelnan P, Tanca L. G-Log: A declarative graphical query language. In: Proc. of the 2nd Conference on Deductive and Object-Oriented Databases, 1991. Springer Verlag; 1992: 108-28.
    Google Scholar
  • 14 Sockut GH, Burns LM, Malhotra A, Whang K-Y. GRAQULA: A graphical query language for entity-relationship or relational databases. Data & Knowl Engin 1993; 11: 171-202.
    CrossrefPubMedGoogle Scholar
  • 15 Staes F, Vermeir D, Pisanelli DM. Medical data modelling and view definition. In: Barahona P, Veloso M, Bryant J. eds. Medical Informatics Europe: MIE 94. Lisbon: 1994: 396-401.
    Google Scholar
  • 16 Timmers T, Mulligen EM, van den Heuvel F. Integrating clinical databases in a medical workstation using knowledge-based modelling. In: Lun KC, Degoulet P, Piemme TE, Rienhoff O. eds. MEDINFO 92. Amsterdam: Elsevier Publ; 1992: 478-82.
    Google Scholar
  • 17 Markwell DC. Expressing health data enquiries. In: Barahona P, Veloso M, Bryant J. eds. Medical Informatics Europe: MIE 94. Lisbon: 1994: 436-4l.
    Google Scholar
  • 18 Canfield K. Issues in relational database modelling and semantics for healthcare informatics. In: Lun KC, Degoulet P, Piemme TE, Rienhoff O. eds. MEDINFO 92. Amsterdam: Elsevier Publ; 1992: 126-30.
    Google Scholar
  • 19 Hughes JG. Object-oriented databases. Prentice Hall; 1991
    Google Scholar
  • 20 Cattell RGG. Object Data Management. Object-Oriented and Extended Relational Database Systems. Addison Wesley; 1992
    Google Scholar
  • 21 Rowe L. A shared object hierarchy. In: Dittrich KR, Dayal U, Buchmann AP. eds. On Object-Oriented Database Systems. Heidelberg: Springer Verlag; 1991: 171-88.
    Google Scholar
  • 22 Learmont T, Cattell RGG. An Objectoriented interface to a relational database. In: Dittrich KR, Dayal U, Buchmann AP. eds. On Object-Oriented Database Systems. Heidelberg: Springer Verlag; 1991: 157-67.
    Google Scholar
  • 23 Booch G. Object-Oriented Design. Benjamin/Cummings; 1991
    Google Scholar
  • 24 Chen P. The Entity-Relationship Model – towards a unified view of data. In: Mylopoulos J, Brodie M. eds. Readings in Artificial Intelligence and Databases. Morgan Kaufmann Publ; 1989
    CrossrefGoogle Scholar
  • 25 Wiederhold G. Views, objects and databases. In: Dittrich KR, Dayal U, Buchmann AP. eds. On Object-Oriented Database Systems. Heidelberg: Springer Verlag; 1991: 29-43.
    Google Scholar
  • 26 Stonebraker M. Object Management in POSTGRES using procedures. In: Proc Int Workshop on Object-Oriented Database Systems 1986; 66-72.
    PubMedGoogle Scholar
  • 27 Das KM, Musen MA. A temporal query system for protocol-directed decision support. Meth Inform Med 1994; 33: 358-70.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 28 Pinciroli F, Combi C, Pozzi G, Rossi R. MS2/Cardio: Towards a multi-service medical software for cardiolgy. In: Van Bemmel JH, McCray AT. eds. Yearbook of Medical Informatics 93: Sharing Knowledge and Information. Stuttgart: Schattauer; 1993: 206-15.
    Google Scholar
  • 29 Zrenner E, Apfelstedt-Sylla E, Rüther K. Clinical aspects: retinitis pigmentosa. In: Djamgoz MBA, Archer SN, Vallerga S. eds. Neurobiology and Clinical Aspects of the Outer Retina. London: Chapman & Hall; 1995: 446-60.
    Google Scholar
  • 30 Banhart F, Klaeren H, Zrenner E. An object-oriented database front end for clinical research information systems. In: Barahona P, Veloso M, Bryant J. eds. Medical Informatics in Europe: MIE 94. Lisbon: 1994: 506-11.
    Google Scholar
  • 31 Banhart F. Objektorientierte Benutzersichten auf eine relationale Datenbank für ein klinisches Forschungs-Informationssystem und einen graphischen Anfragegenerator. (Ph. D. Thesis). University of Tübingen; 1995
    Google Scholar
  • 32 Annevelink J, Young CY, Tang PC. Heterogeneous database integration in a physician’s workstation. In: Clayton PD. ed. Proc. of the 15th Symposium on Computer Applications in Medical Care (SCAMC). New York: McGraw Hill; 1992: 368-72.
    Google Scholar
  • 33 Boon WM, Duisterhout JS, van Ginneken AM. New functional requirements for electronic medical records. In: Lun KC, Degoulet P, Piemme TE, Rienhoff O. eds. MEDINFO 92. Amsterdam: Elsevier; 1992: 697-702.
    Google Scholar
  • 34 Kanoui H, Joubert M, Favard R. Knowledge-based model and query language to medical database in a hospital information system. In: Barahona P, Veloso M, Bryant J. eds. Medical Informatics in Europe: MIE 94. Lisbon: 1994: 396-401.
    Google Scholar