Change search
ReferencesLink to record
Permanent link

Direct link
Database optimization: An investigation of code-based optimization techniques
KTH, School of Computer Science and Communication (CSC).
2014 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

In this report database optimization is investigated with a focus on the area which can be implemented with software rather than hardware.The reason for this specialization is that software optimization is an area that all developers have the resources to implement.To investigate these optimization techniques I have first presented the theory behind different optimization techniques including indices, caching and materialized views. A brief explanation on how these techniques can be implemented in MySQL and PHP is then given. With the help of these theories a set of tests have been designed to see how the different optimization techniques react to different types of queries and datasizes. The results of these tests are then presented with a discussion on how these results coincide with the theories presented and how they can be used to benefit a specific system.

Abstract [sv]

Databasoptimering - En utredning av kodbaseradeoptimeringstekniker. I den här rapporten utreds databasoptimering med en inriktning på området som kan implementeras med mjukvara. Anledningen till denna inriktning är att mjukvaruoptimering är att område som alla utvecklare har resurserna att implementera.För att undersöka dessa optimeringstekniker så har jag först presenterat teorin bakom olika optimeringstekniker så som index, cachning och materialiserade vyer. En kort beskrivning på hur dessa tekniker kan implementeras i MySQL och PHP ges sedan. Med hjälp av dessa teorier så har en mängd tester skapats för att se hur olika optimeringstekniker reagerar på olika databasfrågor och storlekar. Resultatet av dessa tester presenteras sedan tillsammans med en diskussion på hur de sammanhänger med teorierna som presenterades och hur de kan användas i ett specifikt system.

Place, publisher, year, edition, pages
National Category
Computer Science
URN: urn:nbn:se:kth:diva-153754OAI: diva2:753563
Available from: 2014-11-21 Created: 2014-10-08 Last updated: 2014-11-21Bibliographically approved

Open Access in DiVA

fulltext(621 kB)65 downloads
File information
File name FULLTEXT01.pdfFile size 621 kBChecksum SHA-512
Type fulltextMimetype application/pdf

By organisation
School of Computer Science and Communication (CSC)
Computer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 65 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 134 hits
ReferencesLink to record
Permanent link

Direct link