Database Benchmark: Unterschied zwischen den Versionen
Aus Geoinformation HSR
Stefan (Diskussion | Beiträge) K |
Stefan (Diskussion | Beiträge) K |
||
| Zeile 16: | Zeile 16: | ||
A database performance benchmark hast to consider following different aspects: | A database performance benchmark hast to consider following different aspects: | ||
| − | # | + | # Cold and warm start (beware that in case of warm start chaching will take place!). |
| − | # Equality | + | # Equality and Range Queries. |
| − | # Query- | + | # Query-Result Sets, which respond with one tupel or which respond more than half of the tupels in the dataset. |
# Single User versus Multi-user. | # Single User versus Multi-user. | ||
| − | Software (Scritps) | + | Software (Scritps) for benchmark automation: |
* [http://wiki.hsr.ch/Datenbanken/files/db-benchmark_mott.zip PostgreSQL hstore Benchmark] - Benchmarking in Python by Michel Ott, 2011. | * [http://wiki.hsr.ch/Datenbanken/files/db-benchmark_mott.zip PostgreSQL hstore Benchmark] - Benchmarking in Python by Michel Ott, 2011. | ||
* [http://www.postgresql.org/docs/devel/static/pgbench.html pgbench] - Benchmark tool for PostgreSQL. | * [http://www.postgresql.org/docs/devel/static/pgbench.html pgbench] - Benchmark tool for PostgreSQL. | ||
Version vom 13. Oktober 2013, 20:48 Uhr
See also
- HSR Texas Geo Database Benchmark
- Seminar Database Systems Autumn 2011/2012, Master of Science in Engineering, HSR.
About Database Performance Benchmarking...
Existing DB-Benchmarks:
- TPC-C for OLTP benchmarks.
- TPC-R & TPC-H (formerly TPC-DS) for data warehouse & decision support systems.
- TPC-W benchmark for Web-based systems.
- "The Engineering Database Benchmark".
- Open Source Database Benchmark
- PolePosition open source database benchmark [1]
Guidelines
A database performance benchmark hast to consider following different aspects:
- Cold and warm start (beware that in case of warm start chaching will take place!).
- Equality and Range Queries.
- Query-Result Sets, which respond with one tupel or which respond more than half of the tupels in the dataset.
- Single User versus Multi-user.
Software (Scritps) for benchmark automation:
- PostgreSQL hstore Benchmark - Benchmarking in Python by Michel Ott, 2011.
- pgbench - Benchmark tool for PostgreSQL.
Weblinks
- "The Engineering Database Benchmark", Rick Cattell, PDF.
- Open Source Database Benchmark
- http://www.delicious.com/sfkeller/database+benchmark
