test_db is a collection of tools for validating database integrity, benchmarking system throughput, and generating synthetic schemas and datasets. It includes a sample corporate employee database for MySQL, a SQL dataset generator for creating representative records, and an integrity validator that uses checksums and record counts to verify data consistency across different database engines.
The project provides a database performance benchmark consisting of complex queries and stored procedures designed to measure system response times and throughput. These tools simulate real-world workloads through multi-table joins and aggregations.
The toolset covers broad capability areas including database schema simulation, synthetic data generation, and data load testing. It specifically measures data load duration by calculating the elapsed time from the initial table creation to the final update.
