Constructing IDL Views on Relational Databases

  • Kim Jungfer
  • Ulf Leser
  • Patricia Rodriguez-Tomé
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1626)


Data collections are distributed at many different sites and stored in numerous different database management systems. The industry standard CORBA can help to alleviate the technical problems of distribution and diverging data formats. In a CORBA environment, data structures can be represented using the Interface Definition Language IDL. Manually coding a server, which implements the IDL through calls to the underlying database, is tedious. On the other hand, it is in general impossible to automatically generate the CORBA server because the IDL is not only determined by the schema of the database but also by other factors such as performance requirements. We therefore have developed a method for the semi-automatic generation of CORBA wrappers for relational databases. A declarative language is presented, which is used to describe the mapping between relations and IDL constructs. Using a set of such mapping rules, a CORBA server is generated together with the IDL. Additionally, the server is equipped with a query language based on the IDL. We have implemented a prototype of the system.


Relational Database Query Language Object Reference Relational Schema Mapping Definition 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Barillot E., Leser U., et al.: A proposal for a standard CORBA interface for genome maps. Bioinfomatics, 15. Oxford University Press. (1999) 157–169CrossRefGoogle Scholar
  2. 2.
    Chen I.M.A., Kosky A.S., et al.: Advanced Query Mechanisms for Biological Databases. Proc. of the 6th Int. Conf. on Intelligent Systems for Molecular Biology (ISMB), Montreal, Canada. AAAI Press, Menlo Park (1998)Google Scholar
  3. 3.
    Dogac A., Dengi C., et al.: A Multidatabase System Implementation on CORBA. 6th Int. Workshop on Research Issues in Data Engineering: Nontraditional Database Systems, New Orleans, Louisiana (1996)Google Scholar
  4. 4.
    Etzold T., Ulyanov A., Argos P.: SRS: Information Retrieval System for Molecular Biology Data Banks. Methods in Enzymology, Vol. 266. Academic Press (1996) 114–128CrossRefGoogle Scholar
  5. 5.
    Fahl G., and Risch T.: Query Processing over Object Views of Relational Data. The VLDB Journal 6(4). Springer-Verlag (1997) 261–281CrossRefGoogle Scholar
  6. 6.
    Hohenstein U.: Using Semantic Enrichment to Achieve Interoperability of Relational and ODMG Databases. International Hong Kong Computer Society Database Workshop (1996) 210–232Google Scholar
  7. 7.
    Jungfer K., and Rodriguez-Tomé P.: Mapplet: A corba-based genome map viewer. Bioinformatics, 14(8). Oxford University Press (1998) 734–738CrossRefGoogle Scholar
  8. 8.
    Leser U., Tai S., Busse S.: Design Issues of Database Access in a CORBA Environment. Workshop on Integration of Heterogeneous Software Systems, Magdeburg, Germany (1998)Google Scholar
  9. 9.
    Leser U., Wagner R., et al.: IXDB, an X Chromosome Integrated Database. Nucleic Acids Research., 26(1). Oxford University Press (1998) 108–111CrossRefGoogle Scholar
  10. 10.
    Object Management Group: The Common Object Request Broker: Architecture and Specification. John Wiley & Sons, New York (1995)Google Scholar
  11. 11.
    Object Management Group: CORBAServices: Common Object Service Specification: Query Service Specification. (1997)
  12. 12.
    Papazoglou M., Tari Z., and Russell N.: Object-Oriented Technology for Interschema and Language Mappings. Object-Oriented Multidatabase Systems: A Solution for Advanced Applications, Bukhres O.A., Elmagarmid A.K. (eds.) Prentice Hall, New Jersey (1996) 203–250Google Scholar
  13. 13.
    Qian X., and Raschid L.: Query Interoperation among object-oriented and relational databases. 11th Int. Conference on Data Engineering, Tapei, Taiwan. IEEE Computer Soc. Press (1995)Google Scholar
  14. 14.
    Rodriguez-Tomé P., Helgesen C., Lijnzaad P., and Jungfer K.: A CORBA server for the Radiation Hybrid Database. Proc. of the 5th Int. Conf. on Intelligent Systems in Molecular Biology (ISMB). AAAI Press (1997) 250–253Google Scholar
  15. 15.
    Schuler G.D., Epstein J.A., et al.: Entrez: Molecular Biology Databases and Retrieval System. Methods in Enzymology, Vol. 266. Academic Press (1996) 141–162CrossRefGoogle Scholar
  16. 16.
    Siegel J.: CORBA Fundamentals and Programming, John Wiley & Sons (1996)Google Scholar
  17. 17.
    Stoesser G., Moseley M.A., et al.: The EMBL Nucleotide Sequence Database. Nucleic Acids Research, 26(1). Oxford University Press (1998) 8–15CrossRefGoogle Scholar
  18. 18.
    Tari Z., Stokes J.: Designing the Reengineering Service for the DOK Federated Database System. Proc. of the IEEE Int. Conf. On Data Engineering (ICDE’97), Birmingham (1997) 465–475Google Scholar
  19. 19.
    Wells D. L., and Thompson C. W.: Evaluation of the Object Query Service Submissions to the Object Management Group. IEEE Quarterly Bulletin on Data Engineering, 17(4). (1994) 36–45Google Scholar
  20. 20.
    Wiederhold G.: Views, Objects and Databases. IEEE Computer, Vol. 19(12). (1986) 37–44Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Kim Jungfer
    • 1
  • Ulf Leser
    • 1
  • Patricia Rodriguez-Tomé
    • 1
  1. 1.The European Bioinformatics InstituteEMBL OutstationUK

Personalised recommendations