Transaction Management in Engineering Databases

  • Ali R. Kutay
  • Charles M. Eastman


The assumptions and procedures of engineering design are fundamentally different from those of business applications and result in quite different needs with regard to database system requirements. One important difference is in the assumptions regarding integrity. In business, it is assumed that a database has complete integrity during all quiescent periods. In engineering design, in contrast, integrity does not exist for a database until design is almost complete. In a previous paper, we developed a revised definition of transaction that explicitly allows partial integrity. A management scheme, called entity state transaction management, was proposed that deals with both the partial ordering of transactions and the contention for shared information resources. The extension of this technique for application to large engineering problems is explored in this paper, with the development of a significant example.


Integrity Constraint Concurrency Control Database State Design Database Piping Network 
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. [1]
    Bernstein, P.A., Shipman, D.W., Wong, W.S. Formal aspects of serializability in database concurrency control. IEEE Trans. Software Eng. SE-5(3), May, 1979.Google Scholar
  2. [2]
    Eastman, C.M.Database Facilities for Engineering Design. Proc. IEEE 69(10), Oct., 1981.Google Scholar
  3. [3]
    Eastman, C.M., Kutay, A.R. Transactions and Concurrency in Engineering Databases.IBS Report, CMU, 1982.Google Scholar
  4. [4]
    Eswaran, K.P., Gray, J.N., Lorie, R.A., Traiger, I.L.The notions of consistency and predicate locks in a shared database system.Communications ACM 19 (2): 624–633, Nov., 1976.MathSciNetMATHGoogle Scholar
  5. [5]
    Kung, H.T., Papadimitriou, C.H. An optimality theory of concurrency control for databases. CMU Tech. Report, June,1979 (last revised Jan. 1982 ).Google Scholar

Copyright information

© Kluwer Academic Publishers 1984

Authors and Affiliations

  • Ali R. Kutay
    • 1
  • Charles M. Eastman
    • 1
  1. 1.Design Research Center and School of Urban and Public AffairsCarnegie-Mellon UniversityPittsburghUSA

Personalised recommendations