{"repo":"getintogit1/database-tuning","free":true,"listed":false,"github":"https://github.com/getintogit1/database-tuning","clone":"git clone https://github.com/getintogit1/database-tuning.git","description":"Hands-on lab series focused on practical techniques to enhance database performance. Topics include schema design, query optimization, indexing strategies, join tuning, and concurrency control. Inspired by real-world workloads and concepts from database performance literature.","language":"TeX","stars":11,"topics":["database","postgresql","python","sql","sqlite","tuning"],"license":null,"category":"databases-storage","readme_excerpt":"Database Tuning Database Tuning course, based on the book: Database Tuning: Principles, Experiments, and Troubleshooting Techniques by Dennis Shasha & Philippe Bonnet (The Morgan Kaufmann Series in Data Management Systems) This repository contains solutions, experiments, and documentation for 6 lab exercises covering essential techniques for optimizing database performance. --- Mainly Used --- Course Overview The course focuses on practical techniques to improve database performance through schema design, indexing, query formulation, concurrency handling, and tuning strategies. The experiments are based on real-world workloads and performance metrics, inspired by the concepts in the book. --- Lab Structure Lab Topic Description ----- ---------------------------------- ------------- 1 Database Creation & Insertion Schema design and efficient data insertion strategies 2 Query Tuning Analyzing and optimizing SQL queries using execution plans 3 Index Tuning Theory Identifying different indexes to improve performance 4 Index Tuning Practice Clustered / Unclustered BTree, Hash Index 5 Join Tuning Join algorithms, reordering joins, and cost estimation 6 Concurrency Tuning Transactions, isolation levels ---","default_branch":null,"files":null,"tree":[],"storefront":"/r/getintogit1","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/getintogit1/database-tuning/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}