Performance enhancements to a relational database system

Authors:
Michael Stonebraker;John Woodfill;Jeff Ranstrom;Marguerite Murphy;Marc Meyer;Eric Allman
Affiliations:
Univ. of California, Berkeley;Univ. of California, Berkeley;Univ. of California, Berkeley;Univ. of California, Berkeley;Univ. of California, Berkeley;Univ. of California, Berkeley
Venue:
ACM Transactions on Database Systems (TODS)
Year:
1983

Citing 8
Cited 7

Retrospection on a database system

ACM Transactions on Database Systems (TODS)
System R: relational approach to database management

ACM Transactions on Database Systems (TODS)
The design and implementation of INGRES

ACM Transactions on Database Systems (TODS)
Operating system support for database management

Communications of the ACM
Indirect threaded code

Communications of the ACM
The UNIX time-sharing system

Communications of the ACM
Threaded code

Communications of the ACM
Performance analysis of a relational data base management system

SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data

Pros and cons of operating system transactions for data base systems

ACM '86 Proceedings of 1986 ACM Fall joint computer conference
An Analytical Method for Estimating and Interpreting Query Time

VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
A study of the impact of direct access I/O on relational database management systems

CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Database services for personal computers linked by a local area network

SIGSMALL '83 Proceedings of the 1983 ACM SIGSMALL symposium on Personal and small computers
An evaluation of buffer management strategies for relational database systems

VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
IBM database 2 performance: design, implementation, and tuning

IBM Systems Journal
Reducing seek overhead with application-directed prefetching

USENIX'09 Proceedings of the 2009 conference on USENIX Annual technical conference

Quantified Score

Hi-index	0.00

Visualization

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.