T-106.290 Ohjelmoinnin laboratoriotyöt

Subject: RDBMS (3 or 4 cr)

The prerequisite for this project is any course in databases.

Define a representative benchmark for a RDBMS (such as simulating a large multi-site car rental service) with at least ten transaction types. Test alternative database implementations with different transaction loads, varying amount of data and database clients, and varying data access/update patterns.

In a three credit exercize the RDBMS to be benchmarked are:

• PostgreSQL
• MySQL
• SQLite

Present also qualitative information about the databases, such as ease of use, reliability, standard SQL conformance, etc. Investigate whether your benchmark becomes bandwidth/latency -limited if the database clients are on a different machine.

For a four credit exercize, you additionally have to:

• Benchmark at least two commercial RDBMS
• For each database, use a few hours to try out non-standard database-specific tweaks to maximize performance.

Some references

The transaction processing counsil is a good starting point.