Download PDF
Methods Inf Med 1988; 27(04): 177-183
DOI: 10.1055/s-0038-1635533
Original Article
Schattauer GmbH

An Approach to Integrate Collections of Images and Relational Databases

Ein Ansatz zur Integration von Bildern und relationalen Datenbanken
P. J. Jasinski
1)   Technical University of Poznan, Poland
,
H.-P. Meinzer
2)   German Cancer Research Center, Heidelberg, FRG
,
C. O. Köhler
2)   German Cancer Research Center, Heidelberg, FRG
,
B. Sandblad
3)   University Data Center, Uppsala, Sweden
› Author Affiliations
Further Information

Publication History

Publication Date:
16 February 2018 (online)

  PDF Download  Permissions and Reprints

Summary

The structure of computer-processed images is described. This is the basis for presenting a method to integrate traditional database concepts and images which represent a certain class of nonformatted, heterogeneous information. The method presented consists of a special, surrogate Image data type and a design of Image Directory, which associates formatted data, raw digital images stored conceptually in the form of a file of variable length, bit string records, and look-up tables. Beside individual and aggregate-oriented retrieval, some tools supporting more sophisticated analyses of images are also suggested. In order to make the description of solutions clear and truly methodological, a basic notion of the relational database technology and a de facto standard query language (SQL) have been applied. The method presented can be used to build various medical applications where images and/or graphics constitute an important fraction of information.

Die Struktur computerverarbeiteter Bilder wird beschrieben. Das ist die Grundlage für die Darstellung einer Methode zur Integration traditioneller Datenbankkonzepte und Bilder, welche eine bestimmte Klasse nichtformatierter, heterogener Information bilden. Die dargestellte Methode besteht aus einem speziellen Bilddatentyp und einem Plan eines Bildverzeichnisses, welches formatierte Daten, rohe digitale Bilder, begrifflich gespeichert in Form einer Datei variabler Länge, Bitkettensätze und Farbtabellen verbindet. Neben individuell und auf das gesamte Datenmaterial ausgerichtetem Retrieval werden auch einige Werkzeuge zur Unterstützung komplizierterer Bildanalysen vorgeschlagen. Um die Beschreibung von Lösungen klar und wirklich methodisch zu gestalten, wurden eine grundlegende . Vorstellung der relationalen Datenbanktechnologie und eine de facto Standard-SQL-Sprache angewandt. Die dargestellte Methode kann zum Aufbau verschiedener medizinischer Anwendungen benutzt werden, bei denen Bilder und/oder Graphiken einen wichtigen Teil der Information bilden.

Key-Words:

Digital Images - Relational Database - SQL - Image Retrieval

Schlüssel-Wörter:

Digitale Bilder - relationale Datenbank - SQL - Bild-Retrieval
 

  • REFERENCES

  • 1 Alagic S. Relational Database Technology. Heidelberg: Springer Verlag; 1986
    Search in Google Scholar
  • 2 Arvidson B. The Binary Database System Reference Manual. Uppsala: Mimer Information Systems AB; 1986
    Search in Google Scholar
  • 3 Assmann K, Venema R, Hoehne K. H. Software tools for the development of pictorial information systems in medicine – the 1SQL experience. In Hoehne K. H. (Ed.) Pictorial Information Systems in Medicine. Nato ASI Series F, Vol. 19. Heidelberg: Springer Verlag; 1986: 333-355.
    Search in Google Scholar
  • 4 Blaser A. (Ed) Data Base Technique for Pictorial Applications. Heidelberg: Springer Verlag; 1980
    Search in Google Scholar
  • 5 Bole L. (Ed) Natural Language Communication with Pictorial Information Systms. Heidelberg: Springer Verlag; 1984
    Search in Google Scholar
  • 6 Date C. J. An Introduction to Database Systems, Vol. II. Reading Mass: Addison-Wesley; 1983
    Search in Google Scholar
  • 7 Hachimura K. Image query system in clinical environment. In Salamon R, Blum B, Jørgensen M. (Eds.) MEDIN-FO 86, Publ. Comp. Amsterdam: North-Holland; 1986: 629-633.
    Search in Google Scholar
  • 8 Hoehne K. H. (Ed) Pictorial Information Systems in Medicine. NATO ASI Series F, Vol. 19. Heidelberg: Springer Verlag; 1986
    Search in Google Scholar
  • 9 Hessinger P.R. DBMS: Adding value to vanilla. Datamation 1987; 33: 50-54.
    PubMedSearch in Google Scholar
  • 10 Jasinski P. J. Extending relational database facilities to capture images. Heidelberg: DKFZ, MBI Technical Note; Nr. 3/ 1986
    Search in Google Scholar
  • 11 Leavit M. B, Newell J. B. An image filing system for the implementation of image processing algorithms in a research environment. Comput. Biomed. Res 1988; 21: 174-185.
    CrossrefPubMedSearch in Google Scholar
  • 12 Orenstein J. A. Can we meaningfully integrate drawings, text, images and voice with structured data?. In Proc. 4th Int. Conf. on Data Engineering. 603 Long Beach: IEEE Computer Society Press; 1988
    Search in Google Scholar
  • 13 Wada B. T. A. Virtual Memory System for Picture Processing. Comm ACM. 1984; 27: 444-454.
    PubMedSearch in Google Scholar
  • 14 Yost R. A. Can image data be integrated with structured data?. In: Proc. 4th Int. Conf. on Data Engineering. 602 Long Beach: IEEE Computer Society Press; 1988
    Search in Google Scholar