Global ETD Search

1	Database Tuning using Evolutionary and Search Algorithms Raneblad, Erica January 2023 (has links) Achieving optimal performance of a database can be crucial for many businesses, and tuning its configuration parameters is a necessary step in this process. Many existing tuning methods involve complex machine learning algorithms and require large amounts of historical data from the system being tuned. However, training machine learning models can be problematic if a considerable amount of computational resources and data storage is required. This paper investigates the possibility of using less complex search algorithms or evolutionary algorithms to tune database configuration parameters, and presents a framework that employs Hill Climbing and Particle Swarm Optimization. The performance of the algorithms are tested on a PostgreSQL database using read-only workloads. Particle Swarm Optimization displayed the largest improvement in query response time, improving it by 26.09% compared to using the configuration parameters' default values. Given the improvement shown by Particle Swarm Optimization, evolutionary algorithms may be promising in the field of database tuning. Database tuning Performance optimization Evolutionary algorithms Particle Swarm Optimization Database configuration Hill Climbing Computer Sciences Datavetenskap (datalogi)
2	Utveckling av kompatibilitetsdatabas / Developing of a Compatibility Database Lenells, Erik, Hjärtmyr, Christian January 2011 (has links) This report explains the need to develop a configuration manager that handles transmission equipment which exists in the Swedish Defence telecommunications network. The configuration module will display the configurations and compatibility among the equipment and their software which are all part of the network. Also included in this report are tools, methods and results for the development of a prototype for the configuration manager. The prototype consists fundamentally of a database assisted by a user friendly website. The transmission equipment handles a lot of important transmission of information and is in the hands of a department of SAAB, OFGCA, by orders from the Swedish Defence Materiel Administration (FMV). Within the work included in this order exists a continuous update of both software and hardware which the equipment consists of. Therefore it’s highly important that there is a monitoring of which of the software and hardware is compatible with one another, ensuring that the functions of the system work properly. The consistent updating has resulted in compatibility issues between components and because of this, a need for a configuration manager has arisen. / Den här rapporten uttrycker behovet av att ta fram en konfigurationsmodul för transmissionsutrustningar som ingår i Försvarets telenät (FTN). Konfigurationsmodulen ska mätta ett behov av att kunna se konfigurationerna och kompatibilitet för de utrustningar samt dess programvaror som ingår i telenätet. Rapporten inkluderar även verktyg, metoder och resultat för framtagningen av en prototyp till konfigurationsmodulen. Prototypen består i grunden av en databas med en tillhörande, interaktionsvänlig, hemsida. Transmissionsutrustningarna hanterar en mängd viktig informationsöverföring och en avdelning på Saab, OFGCA, ansvarar för dessa på uppdrag av Försvarets materialverk (FMV). I arbetet som uppdraget innebär pågår en ständig uppdatering av både mjuk- och hårdvara som utrustningarna består av. Det innebär att det är mycket viktigt att det utförs övervakning av vilka mjuk- och hårdvaruversioner som är kompatibla. Detta för att säkerställa att systemets funktioner fungerar korrekt. Den ständiga uppdateringen har medfört kompatibilitetsproblem mellan komponenter och därför har det växt fram ett behov av att ta fram en konfigurationsmodul. configuration manager configuration management configuration compatibility database compatibility compatible database configuration database development database design ASP.NET ASP Visual Studio SQL server konfigurationshanterare konfigurationshantering konfiguration kompatibilitetsdatabas kompatibilitet kompatibel databashantering databasutveckling databasdesign ASP.NET ASP Visual Studio SQL server Engineering and Technology Teknik och teknologier Computer and Information Sciences Data- och informationsvetenskap Computer Sciences Datavetenskap (datalogi) Software Engineering Programvaruteknik
3	Ladění výkonnosti databází / Database Performance Tuning Paulíček, Martin January 2011 (has links) The objective of this thesis was to study problems of an insufficient database processing performance and possibilities how to improve the performance with database configuration file optimizations, more powerful hardware and parallel processing. The master thesis contains a description of relational databases, storage media and different forms of parallelism with its use in database systems. There is a description of the developed software for testing database performance. The program was used for testing several database configuration files, various hardware, different database systems (PostgreSQL, Oracle) and advantages of parallel method "partitioning". Test reports and evaluation results are described at the end of the thesis.

1

Page generated in 0.1289 seconds