A Form System for an Object-Oriented Database System

  • Christine Collet
  • Eric Brunel
Conference paper


This paper describes the interactive system FO2 implemented on top of an object-oriented database system. FO2 uses the form model described in [3] and [8]. The form notion offers a formal and homogeneous approach for describing and manipulating structural, semantic, and interface aspects of new database applications. Data are represented by Abstract Forms. An Abstract Form (called FA) may be viewed as a nonfirst normal form relation to which a set of rules describing the behavior of the FA occurrences is associated. For every FA, FO2 builds Presentations allowing an end-user to get on the screen the forms for querying and updating the occurrences of the FA. FO2 has been implemented with a bootstrap approach and we have forms to define forms. Here we give a general presentation of the FO2 system and a description of the F02 kernel implemented using O2, an object-oriented database system[6].


Complex Object Control Part Presentation Part Attribute Rule Select Operation 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    S. Abiteboul, N.Bidoit, “Non First Normal Form Relations: an algebra allowing data restructuring”. Proceedings of ACM SIGACT-SIGMOD Symposium on Principles of Database System,1984.Google Scholar
  2. [2]
    S. Abiteboul, S. Grumbach, “Bases de données et objets structurés,” TSI, Vol 6, No 5, December 1987.Google Scholar
  3. [3]
    M. Adiba, C. Collet, “Management of complex objects as dynamic form,” 14th VLDB conference, Los Angeles, August 1986.Google Scholar
  4. [4]
    F. Bancilhon, P. Richard, M. Scholl, “Verso: A Relational Backend Database Machine,” Proceedings of International Workshop on Database Machines, San Diego, 1982.Google Scholar
  5. [5]
    F.Bancilhon, S. Koshafian, “A Calculus for Complex Ob-ects,” Proceedings of ACM Symposium on PODS, Boston, March 1986.Google Scholar
  6. [6]
    F. Bancilhon, C. Delobel, P. Kannelakis, “The 02 Book,” Preliminary Version, October 1989.Google Scholar
  7. [7]
    F. Barbic, M. Carli, B. Pernici, G. Bracchi, “A tool for form definition in office information systems specification,” New applications on Databases edited by G. Gardarin. do proceedings of ICOD-2 Conference Workshop, Cambrigde University, September 1983.Google Scholar
  8. [8]
    C. Collet, “Les Formulaires complexes dans les bases de données multimédia,” Thèse de Docteur de l’USTMG, Grenoble, November 1987.Google Scholar
  9. [9]
    C. Collet, “FAKIR, un système pour la définition et la manipulation interactive d’objets complexes,” Colloque sur l’ingénierie des interfaces Homme-Machine, SophiaAntiapolis, May 1989.Google Scholar
  10. [10]
    J. Coutaz, “Interface Homme-Ordinateur,” Thèse de doctorat d’état de l’Université Joseph Fourier, Grenoble, December 1988.Google Scholar
  11. [11]
    A. doucet, C. Lepenant, “Language de quatrième génération et générateurs d’interfaces,” Rapport technique, GIP Altair No 3–87, March 1987.Google Scholar
  12. [12]
    P. Fisher, S.T. Thomas, “Operators on Non-First-NormalForm Relations,” Proceedings of the 7th International Software Application Conference, Chicago 1983.Google Scholar
  13. [13]
    N.H Gehani, “High level form definition in office information systems,” The Computer Journal, Vol 26, No 1, 1983.Google Scholar
  14. [14]
    S. Gibbs, “An Object-Oriented Office Data Model,” Technic al Report CSRG-154, January 1984.Google Scholar
  15. [15]
    M. Green, “A Survey of Three Dialog Models,” ACM Trans. Graphics, July 1986.Google Scholar
  16. [16]
    R.H. Gutting, R. Zicari, D.M. Choy, “An Algebra for structured office documents,” IBM Research Report RJ5559, San Jose, March 1987.Google Scholar
  17. [17]
    H. Hämmäimen, E. Eloranta, J. Alasuvanto, “Distributed Form Management,” ACM Trans. on Information Systems, Vol 8, No 1, January 1990.Google Scholar
  18. [18]
    B. Jaeschke, “Recursive algebra for relations with relation valued attributes,” Lecture notes IBM Europe Institute, Davos, 1984.Google Scholar
  19. [19]
    R. King, M. Novak, “FaceKit: A Database Interface Design Toolkit,” Proc of 15th VLDB Conf., Amsterdam, September 1989.Google Scholar
  20. [20]
    H. Kitagawa, M. Gotoh, S. Misaki, M. Azuma, “Form Document Management System SPECDOC - its Architecture and Implementation,” ACM SIGQA on Office Information System, Toronto, June 84.Google Scholar
  21. [21]
    C. Lécluse, P. Richard, F. Velez, “02, An Object-Oriented Data Model,” Proceedings of the ACM-SIGMOD Conference, Chicago, 1988.Google Scholar
  22. [22]
    C. Lécluse, P. Richard, “The 02 Database Programming Language,” Proceedings of the 15th VLDB Conference, Amsterdam, August 1989.Google Scholar
  23. [23]
    Oracle, “Users manual for SQLForms,” Oracle Corporation, Menlo Park, California, Original issue: October 1987.Google Scholar
  24. [24]
    P. Pistor. F. Andersen “Designing a generalized NF2 model with an SQL-type language interface,” Proceedings of the 12th VLDB Conference, Kyoto, August 1986.Google Scholar
  25. [25]
    D. Plateau, R. Cazalens, B. Poyer, “A customizable abstract I/O server for complex object edition,” Rapport technique GIP Altaïr No 28–89, March 1989.Google Scholar
  26. [26]
    M.A. Roth, H.F. Korth, A. Silberschatz, “Extended Algebra and Calculus for -1NF Relational Databases,” Technical report - Computer Science Dept - University of Texas, Texas, 1985.Google Scholar
  27. [27]
    L.A. Rowe, “”Fill-in-the-form“ programming,” Proceedings of the 11th VLDB Conference, Stockholm, August 1985.Google Scholar
  28. [28]
    H.J. Schek, M.H. Scholl, “The relational model with relation-valued attributes,” Informations Systems Vol 11, No 2, 1986.Google Scholar
  29. [29]
    N.C. Shu, “FORMAL: A Forms-Oriented, Visual-Directed application development System,” IEE Transactions on Software Engineering, 1985.Google Scholar
  30. [30]
    M. Stonebraker, “The Ingres Paper, anatomy of a relational Database system,” IEE Addison-Wesley Publishing Company, 1986.Google Scholar
  31. [31]
    D. Tsichritzis, “Form Management,” Communications ACM, Vol 25, No 7, July 1982.Google Scholar
  32. [32]
    M. Zloof, “Office-By-Example: a business language that unifies data and wordrocessing and electronic mail,” IBM Research Journal, Vol 21, No 3, 1982.Google Scholar

Copyright information

© Springer-Verlag Wien 1991

Authors and Affiliations

  • Christine Collet
    • 1
  • Eric Brunel
    • 1
  1. 1.Laboratoire de Genie Informatique, IMAGGrenobleFrance

Personalised recommendations