Effective database management has become essential for modern organizations, especially to reduce costs while maintaining optimal performance. This project explores practical strategies to reduce response times, improve resource efficiency and improve data integrity in a database for the chemical management sector. The techniques include normalization, data type optimization, and query optimization using indexes. Tools like EXPLAIN are used to understand the optimizer's logic regarding the selection of scan types and how it can be influenced to make better decisions. MySqlSlap is used for load testing to verify the effects of the changes, such as reduced latency, improved memory management, and improved resource utilization.
| Identifer | oai:union.ndltd.org:UPSALLA1/oai:DiVA.org:hh-53755 |
| Date | January 2024 |
| Creators | Akbary, Rocky |
| Publisher | Högskolan i Halmstad, Akademin för informationsteknologi |
| Source Sets | DiVA Archive at Upsalla University |
| Language | English |
| Detected Language | English |
| Type | Student thesis, info:eu-repo/semantics/bachelorThesis, text |
| Format | application/pdf |
| Rights | info:eu-repo/semantics/openAccess |
Page generated in 0.002 seconds