skip to main content
article
Free Access

Retrospection on a database system

Published:01 June 1980Publication History
Skip Abstract Section

Abstract

This paper describes the implementation history of the INGRES database system. It focuses on mistakes that were made in progress rather than on eventual corrections. Some attention is also given to the role of structured design in a database system implementation and to the problem of supporting nontrivial users. Lastly, miscellaneous impressions of UNIX, the PDP-11, and data models are given.

References

  1. 1 ALLMAN, E., HELD, G., AND STONEBRAKER, M. Embedding a data manipulation language in a general purpose programming language. Proc. ACM SIGPLAN SIGMOD Conf. on Data Abstractions, Salt Lake City, Utah, March I976, pp. 25-35. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2 ASTRAHAN, M.M., ET AL. System R: Relational approach to database management. ACM Trans. Database Syst. 1, 2 (June 1976), 97-137. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 3 BLASGEN, M., AND ESWARAN, K. Storage and access in relational data base systems. IBM Syst. J. (Dec. 1977), 363-377.Google ScholarGoogle Scholar
  4. 4 CHAMBERLIN, D.D., AND BOYCE, R.F. SEQUEL: A structured English query language. Proc. ACM SIGFIDET Workshop on Data Description, Access and Control, Ann Arbor, Mich., May 1974, pp. 249-264. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. 5 CODD, E.F. A database sublanguage founded on the relational calculus. Proc. ACM SIGFIDET Workshop on Data Description, Access and Control, San Diego, Calif., Nov. 1971, pp. 35-68.Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6 EPSTEIN, R., STONEBRAKER, M., AND WONG, E. Query processing in a distributed data base system. Proc. ACM SIGMOD Conf. on Management of Data, Austin, Tex., May 1978, pp. 169- 180. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. 7 ESWARAN, K.P., GRAY, J.N., LORIE, R.A., AND TRAIGER, I.L. The notions of consistency and predicate locks in a database system. Comm. ACM 19, 11 (Nov. 1976), 624-633. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. 8 GRAY, J.N., LORIE, R.A., PUTZOLU, G.R., AND TRAIGER, I.L. Granularity of locks and degrees of consistency in a shared data base. Res. Rep. RJ 1849, IBM Research Lab., San Jose, Calif., July 1976.Google ScholarGoogle Scholar
  9. 9 GRAY, J. Notes on data base operating systems. Res. Rep. RJ 2188, IBM Research Lab., San Jose, Calif., Feb. 1978.Google ScholarGoogle Scholar
  10. 10 GRIFFIT}IS, P.P., AND WADE, B.W. An authorization mechanism for a relational database system. ACM Trans. Database Syst. 1, 3 (Sept. 1976), 242-255. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. 11 HAMMER, M., AND CHAN, I. Index selection in a self adaptive data base system. Proc. ACM SIGMOD Conf. on Management of Data, Washington, D.C., June 1976, pp. 1-8. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. 12 HAWTHORN, P., AND STONEBRAKER, M. Use of technological advances to enhance data base management system performance. Memo No. 79-5, Electronics Res. Lab., U. of California, Berkeley, Calif., Jan. 1979.Google ScholarGoogle Scholar
  13. 13 HELD, G., AND STONEBRAKER, M. B-trees re-examined. Comm. ACM 21, 2 (Feb. 1978), 139-143. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. 14 JOHNSON, S. YACC--yet another compiler-compiler. Comptr. Sci. Tech. Rep. No. 32, Bell Telephone Laboratories, Murray Hill, N. J., July 1975.Google ScholarGoogle Scholar
  15. 15 PRENNER, C., AND ROWE, L. Programming languages for relational data base systems. Proc. Nat. Comptr. Conf., Anaheim, Calif., June 1978, pp. 849-855.Google ScholarGoogle Scholar
  16. 16 RIES, D.R., AND STONEBRAKER, M. Effects of locking granularity in a database management system. ACM Trans. Database Syst. 2, 3 (Sept. 1977), 233-246. Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. 17 RIES, D.R., AND STONEBRAKER, M.R. Locking granularity revisted. A CM Trans. Database Syst. 4, 2 (June 1979), 210-227. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. 18 RITCHIE, D.M., AND THOMPSON, K. The UNIX time-sharing system. Comm. ACM 17, 7 (July i974}, 365-375. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. 19 STONEBRAKER, M.R., AND WONG, E. Access control in a relational data base management system by query modification. Proc. ACM Ann. Conf., San Diego, Calif., Nov. 1974, pp. 180-187. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. 20 STONEBRAKER, M. Implementation of integrity constraints and views by query modification. Proc. ACM SIGMOD Conf. on Management of Data, San Jose, Calif., May 1975, pp. 65-78. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. 21 STONEBRAKER, M., AND RUBINSTEIN, P. The INGRES protection system. Proc. ACM Ann. Conf., Houston, Tex., Nov. 1976, pp. 80-84. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. 22 STONEBRAKER, M., WONG, E., AND KREPS, P. The design and implementation of INGRES. ACM Trans. Database Syst. I, 3 (Sept. 1976), 189-222. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. 23 STONEBRAKER, M. Concurrency control, crash recovery and consistency of multiple copies of data in a distributed data base system. Proc. 3rd Berkeley Workshop on Distributed Data Bases and Computer Networks, San Francisco, Calif., Aug. 1978, pp. 235-258.Google ScholarGoogle Scholar
  24. 24 STO~EBRAKER, M. MUFFIN: A distributed data base machine. Proc. First Int. Conf. on Distributed Computing Systems, Huntsville, Ala., Oct. 1979, pp. 459-469.Google ScholarGoogle Scholar
  25. 25 WONG, E., AI~D ~OUSEFFI, K. Decomposition--a strategy for query processing. ACM Trans. Database Syst. 1, 3 (Sept. 1976), 223-241. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Retrospection on a database system

              Recommendations

              Comments

              Login options

              Check if you have access through your login credentials or your institution to get full access on this article.

              Sign in

              Full Access

              PDF Format

              View or Download as a PDF file.

              PDF

              eReader

              View online with eReader.

              eReader