Dataset - Performance Comparison Oracle, PostgreSQL, and MySQL Database Using JMeter Tools

Published: 16 September 2024| Version 1 | DOI: 10.17632/f6vfr96m2p.1
Contributor:
Raymond Setiawan

Description

In order to compare the performance of various Database Management Systems (DBMS), five primary tables—customer, salesman, category, qty_product, and product—were used to create an extensive test dataset. This data was then stored in two principal tables, transaction_hdr and transaction_dtl, each containing over 100,000 records. The utilization of this large dataset allows for a thorough evaluation of DBMS performance using tools such as JMeter. Tables Used: 1. Customer: Stores information about customers, including customer ID, name, contact details, and address. 2. Salesman: Contains data about sales personnel, including salesman ID, name, contact details, and address. 3. Category_Product: Classifies products into specific categories, including category ID and category type. 4.Qty_Product: Maintains information regarding the quantity of products available, including quantity ID, quantity name, and quantity value. 5. Product: Details information about products, including product ID, product name, category ID, size, quantity ID, stock, and price. By utilizing the above tables, a substantial dataset was generated by populating the transaction_hdr and transaction_dtl tables with over 100,000 records each. The transaction_hdr table includes transaction headers with information such as transaction ID, date, customer ID, salesman ID, and total price. The transaction_dtl table records the details of each transaction, including transaction ID, product ID, product name, category ID, quantity ID, quantity value, quantity, and product price. JMeter was employed to conduct performance testing on the DBMS using this dataset to assess throughput and response time across MySQL, Oracle, and PostgreSQL databases.

Files

Steps to reproduce

1. Create Database and Tables Step: Create a database and the necessary tables to hold the test data. Description: Define the database schema with the appropriate tables, such as customer, salesman, category, qty_product, product, transaction_hdr, and transaction_dtl. 2. Download Data in CSV Format Step: Download the data file in CSV format to be used for testing. Description: Ensure that the CSV file contains the necessary data for the tables that have been created, with the appropriate structure and format. 3. Import Data into Tables Step: Import data from the downloaded CSV file into the tables that have been created. Description: Use tools or SQL commands to load the data from the CSV file into the database. Ensure that the data is correctly imported into the corresponding tables. 4. Conduct Testing Step: Perform performance testing on the DBMS using the imported data. Description: Utilize tools such as JMeter to assess the performance of the DBMS with the imported dataset. Analyze the results to evaluate performance metrics such as throughput and response time.

Institutions

Universitas Multimedia Nusantara - Kampus Tangerang

Categories

Database

Licence