Michael Stonebraker
John Woodfill
Eric Allman
Abstract
In this paper we examine four performance enhancements to a database management system: dynamic compilation, microcoded routines, a special-purpose file system, and a special-purpose operating system. All were examined in the context of the INGRES database management system. Benchmark timings that are included suggest the attractiveness of dynamic compilation and a special-purpose file system. Microcode and a special-purpose operating system are analyzed and appear to be of more limited utility in the INGRES context.
- 1 ASTRAHAN, M.M., BLASGEN, M.W., CHAMBERLIN, D.D., F, SWARAN, K.P., GRAY, J.N., GRIFFITHS, P.P., KING, W.F., LORIE, R.A., MCJONES, P.R., MEHL, J.W., PUTZOLU, G.R., TRAIGER, I.L., WADE, B.W., AND WATSON, V. System R: A relational approach to database management. ACM Trans. Database Syst. 1, 2 (June 1976), 97-137. Google Scholar
Digital Library
- 2 BELL, J.R. Threaded code. Commun. ACM, 16, 6 (June 1973), 370-372. Google ScholarDigital Library
- 3 BLASGEN, M., ET. AL. System R: An architectural update. Res. Rep. RJ2654, IBM Research Division (June 1979.)Google Scholar
- 4 CODASYL DATA BASE TASK GROUP. CODASYL data base task group report (April 1971), ACM, New York.Google Scholar
- 5 DEWAR, R.B.K. Indirect threaded code. Commun. ACM, 18, 6 (June 1975), 330-331. Google ScholarDigital Library
- 6 EPSTEIN, R. AND HAWTHORN, P. Design decisions for the intelligent data base machine. In Proc. 1980 National Computer Conf. (Anaheim, Calif., May 1980), AFIPS Press, Arlington, VA., pp. 19-22.Google Scholar
- 7 EPSTEIN, R., AND STONEBRAKER, M. Analysis of distributed data base processing strategies. In Proc. 6th Int. Conf. Very Large Data Bases (Montreal, Canada, Oct. 1-3), ACM, New York, 1980, pp. 92-101.Google Scholar
- 8 HAWTHORN, P., AND STONEBRAKER, M. Performance analysis of a relational data base management system. In Proc. ACM-SIGMOD 1979 Int. Conf. Management of Data (Boston, Mass., May 30-June 1), ACM, New York, 1979, pp. 1-12. Google ScholarDigital Library
- 9 JoY, W. Comments on the performance of UNIX on the VAX. Unpublished.Google Scholar
- 10 KATZ, R. Compilation in data base systems. In Proc. 1978 National Computer Conf. (New York, New York, June 1978).Google Scholar
- 11 RITCHIE, D. AND THOMPSON, K. The UNIX time-sharing system. Commun. ACM 17, 7 (July 1974), 365-375. Google ScholarDigital Library
- 12 ROWE, L. AND BIRMAN, K. The design of COCANET. In Proc. 4th Berkeley Workshop on Distributed Data Bases and Computer Networks (Berkeley, Calif., Oct. 1979).Google Scholar
- 13 STONEBRAKER, M. Operating system support for database management. Commun. ACM 24, 7 (July 1981), 412-418. Google ScholarDigital Library
- 14 STONEBRAKER, M. Retrospection on a database system. ACM Trans. Database 5, 2 (June 1980), 225-240. Google ScholarDigital Library
- 15 STONEBRAKER, M. MUFFIN: a distributed data base machine. In Proc. 1st Int. Conf. on Distributed Computing (Huntsville, Alabama, Oct. 1979).Google Scholar
- 16 STONEBRAKER, M., WONG, E., KREPS, P. AND HELD, G. The design and implementation of INGRES. ACM Trans. Database Syst. 1, 3 (Sept. I976), 189-222. Google ScholarDigital Library
- 17 The UNIX time-sharing system. Bell Systems Tech. J. 57, 6 (July 1978) (Special Issue).Google Scholar
Index Terms
- Performance enhancements to a relational database system
Recommendations
An Instruction Fetch Unit for a High-Performance Personal Computer
The instruction fetch unit (IFU) of the Dorado personal computer speeds up the emulation of instructions by prefetching, decoding, and preparing later instructions in parallel with the execution of earlier ones. It dispatches the machine's microcoded ...
Performance Evaluation of NoSQL Multi-Model Data Stores in Polyglot Persistence Applications
IDEAS '16: Proceedings of the 20th International Database Engineering & Applications SymposiumNoSQL data store systems have recently been introduced as alternatives to traditional relational database management systems. These data stores systems implement simpler and scalable data models that increase the performance and efficiency of a new kind ...
A performance evaluation of in-memory databases
The popularity of NoSQL databases has increased due to the need of (1) processing vast amount of data faster than the relational database management systems by taking the advantage of highly scalable architecture, (2) flexible (schema-free) data ...
Comments