Information systems design: An expert system approach

  • C. Cauvet
  • C. Proix
  • C. Rolland
Expert System Approaches To Databases
Part of the Lecture Notes in Computer Science book series (LNCS, volume 303)


We present in this paper some aspects of an expert design tool so-called OICSI. The scope of OICSI is to generate the IS conceptual schema from a description of the application domain given with a subset of the french natural language. The tool starts, in a first step with an interpretation of natural language descriptions leading to a descriptive network which corresponds to a first version of the conceptual schema. Then in the second step, OICSI uses design rules in order to complete and transform the descriptive network into a normalized network which describes all the elements of the final conceptual schema. The paper focusses on the second step. It presents the representation and validation rules included in the OICSI knowledge based as a formalization of design rules issued from our own practice and experience of Information System design.


Information System Conceptual Schema Structuration Rule Type Knowledge Entity Class 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [ABR 74]
    Jr. Abrial: Data Semantics in Data Management Systems Klimbie and Koffman (eds) North Holland 1974.Google Scholar
  2. [BRA 83]
    R.P. Bragger, A. Dudler, J. Rebsamen, C.A. Zehnder: "GAMBIT: An interactive Database Design Tool for Data Structures, Integrity Constraints and Transactions" in Database Techniques for Professional Workstations, ETH Zurich 1983.Google Scholar
  3. [BRO 82]
    M.L Brodie, E. Silva: Active and Passive Component Modeling: ACM/PCM in IFIP WG8. 1 working conference on "Information systems design methodologies: a comparative review" 1982.Google Scholar
  4. [BRU 75]
    B. Bruce: Case Systems for Natural Language, Artificial Intelligence Nb 6 1975.Google Scholar
  5. [CER 83]
    S. Ceri: "Methodologies and Tools for Database Design" ed, North Holland Publ Co 1983.Google Scholar
  6. [CHE 76]
    P.P. Chen: "The entity Relationship Model — Towards a Unified View of Data" ACM TODS V1, N1, 1976.Google Scholar
  7. [CHO 65]
    Chomsky Aspects of the theory of syntax MIT Press 1965Google Scholar
  8. [COR 79]
    M. Cordier: Connaissances semantiques et pragmatiques en comprehension du langage naturel 2ème congrés AFCET-INRIA Reconnaissance des formes et Intelligence Artificielle, Toulouse 1979.Google Scholar
  9. [DBE 84]
    Data Base Engineering review vol 17 n°4. Special issue on Data design aids methods and environment Dec 84Google Scholar
  10. [FIL 68]
    "Case for case" in Universal theory in linguistic Bach (ed) 1968.Google Scholar
  11. [GAN 79]
    C. Gane T. Sarson: Structured systems analysis Prentice Hall 1979Google Scholar
  12. [GUS 82]
    M.R. Gustafsson, J.A. Bubenko T. Karlsson: "A Declarative Approach to Conceptual Information Processing" in IFIP WG8. 1 Working Conference on "Information Systems Design Methodologies: a comparative review" 1982.Google Scholar
  13. [KAY 1981]
    Kayser: les ATN sémantiques, 3ème Congrés Reconnaissance des formes et Intelligence Artificielle AFCET 1981.Google Scholar
  14. [LIN 87]
    JY Lingat, P. Nobecourt, C. Rolland: Behaviour Management in Data Base applications in Proceedings of VLDB 87 Brigthon UK.Google Scholar
  15. [LUN 82]
    Lundeberg: The ISAC apprach to specification of IS and its application to the organization of an IFIP working conference in IFIP WG8. 1 working conference on "Information systems design methodologies: a comparative review" 1982.Google Scholar
  16. [MYL 80]
    J. Mylopoulos,H. Wong: Some features of the TAXIS model Proc. 6th Int conf. on VLDB 1980. informatiques Masson 1983.Google Scholar
  17. [ROLLAND 82]
    C. Rolland, C. Richard: The Remora methodology fo information systems design and management in IFIP WG8. 1 working conference on "Information systems design methodologies: a comparative review" 1982Google Scholar
  18. [ROL 86]
    C. Rolland, C. Proix: An expert system approach to information system design in Proc. IFIP Congress 86 North Holland 1986.Google Scholar
  19. [ROS 77]
    Dt. Ross, Kl Schaum: Structured systems analysis for requirements definition IEEE Transaction on software engineering 1977Google Scholar
  20. [SMI 77a]
    J.M Smith, C.P. Smith: Database Abstractions: Aggregation. Communications of ACM. June 1977.Google Scholar
  21. [SMI 77b]
    J.M. Smith, C.P. Smith: Database Abstractions: Aggregation and Generalization. ACM TRANSACTIONS on Database Systems. June 1977.Google Scholar
  22. [VER 82]
    G.M.A. Verheijen, J. VAN Bekkum: "NIAM: An Information Analysis Method.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1988

Authors and Affiliations

  • C. Cauvet
    • 1
  • C. Proix
    • 1
  • C. Rolland
    • 1
  1. 1.University of Paris 1Paris Cedex 05France

Personalised recommendations