Corpus ID: 1822183

Benchmarking Database Systems A Systematic Approach

@inproceedings{Bitton1983BenchmarkingDS,
  title={Benchmarking Database Systems A Systematic Approach},
  author={D. Bitton and D. DeWitt and C. Turbyfill},
  booktitle={VLDB},
  year={1983}
}
This paper describes a customized database and a comprehensive set of queries that can be used for systematic benchmarking of relational database systems. [...] Key Method We have used this database to perform a comparative evaluation of the database machine DIRECT, the "university" and "commercial" versions of the INGRES database system, the relational database system ORACLE, and the IDM 500 database machine. We present a subset of our measurements (for the single user case only), that constitute a preliminary…Expand
A methodology for database system performance evaluation
TLDR
It is demonstrated that only four basic query types are needed to construct a benchmark that will evaluate the performance of a system under a wide variety of workloads. Expand
A methodology for benchmarking distributed database management systems
  • C. Orji
  • Computer Science
  • [1991] Proceedings. Seventh International Conference on Data Engineering
  • 1991
TLDR
It is demonstrated that the performance characteristics of any distributed database management system can be captured by running queries based on eight query types that capture the query performance characteristics in the network. Expand
An Integrated Benchmark Suite for Database Systems
TLDR
An integrated benchmark suite for database systems, SIMS, which offers generic benchmarks and custom benchmarks to users in a unified interface, seems to be comprehensive in terms of simulating a real world situation. Expand
Benchmarking simple database operations
TLDR
A number of factors that make an order of magnitude improvement in benchmark performance caching the entire database in main memory, avoiding query optimization overhead, using physical links for prejoins, and using an alternative to the generally-accepted database “server” architecture on distributed networks are discussed. Expand
A performance comparison of object and relational databases using the Sun Benchmark
TLDR
The Sun Benchmark is utilized as a means for assessing the performance of an object database and comparing it with existing relational systems, and the results offer strong evidence that object databases are capable of performing as well as, or better than, existing relational database systems. Expand
A Performance Comparison of Object and Relational Databases Using the Sun Benchmark
TLDR
The Sun Benchmark is utilized as a means for assessing the performance of an object database and comparing it with existing relational systems, and the results offer strong evidence that object databases are capable of performing as well as, or better than, existing relational database systems. Expand
Analysis of Database System Architectures Using Benchmarks
TLDR
A comprehensive benchmark study comparing the performance of database systems on a conventional computer system and a database machine shows the database machine architecture to have superior performance in most cases. Expand
A Single User Evaluation of the Gamma Database Machine
TLDR
This paper presents the results of an initial performance evaluation of the Gamma database machine based on an expanded version of the single-user Wisconsin benchmark, and analyzes and interpret the results based on understanding of the system hardware and software. Expand
A view of database system performance measures
  • J. Gray
  • Computer Science
  • SIGMETRICS '87
  • 1987
TLDR
The Wisconsin and SCAN benchmarks heavily penalize a system which is slow to read the next record in a file, and a system with poor performance on these benchmarks can be analyzed as follows. Expand
The performance of SQL queries to an X.500 directory system
TLDR
This work describes a prototype system that allows users to view the information in a directory as relations, and to query the view using SQL, and an analysis of the performance of the system is presented and possible optimizations are discussed. Expand
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 29 REFERENCES
A PERFORMANCE EVALUATION OF DATABASE MACHINE ARCHITECTURES
TLDR
It is demonstrated that no one type of database machine is best for executing all types of queries and that for several classes of queries certain database machine designs which have been proposed are actually slower than a DBMS on a conventional processor. Expand
A Performance Evaluation of Data Base Machine Architectures (Invited Paper)
TLDR
It is demonstrated that no one type of database machine is best for executing all types of queries and for several classes of queries certain database machine designs which have been proposed are actually slower than a DBMS on a conventional processor. Expand
Performance Analysis of Alternative Database Machine Architectures
TLDR
It is demonstrated that no one database machine is best for executing all types of queries and it is shown that for one class of queries the degree of performance improvement achieved does not warrant use of a database machine. Expand
Implementation of the Database Machine Direct
TLDR
The structure of the DIRECT software is described, which includes software on host computers that interfaces with the database machine; software on the back-end controller of DIRECT; and software executed by the query processors. Expand
Concepts and capabilities of a database computer\
TLDR
The concepts and capabilities of a database computer (DBC) are given and the proposed design is one of the first to describe a complete data-secure computer capable of handling large databases. Expand
High Performance Hardware for Database Systems
TLDR
The work is founded on a comprehensive database model which provides various user languages and supports different "views" of the data and a special-purpose processor is described which can directly perform the relational primitive operations. Expand
Direct—A Multiprocessor Organization for Supporting Relational Database Management Systems
The design of DIRECT, a multiprocessor organization for supporting relational database management systems is presented. DIRECT has a multiple-instruction multiple-data stream (MIMD) architecture. ItExpand
Retrospection on a database system
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 toExpand
Duplicate record elimination in large data files
The issue of duplicate elimination for large data files in which many occurrences of the same record may appear is addressed. A comprehensive cost analysis of the duplicate elimination operation isExpand
Design decisions for the intelligent database machine
TLDR
It is contention that the designers of a database machine must choose a focus for their machine which strongly influences other design decisions, and the reasons for this choice are presented. Expand
...
1
2
3
...