Zmenšení databáze s ohledem na vytížení

Abstract

Master thesis is focused on a relational database subsetting. Theoretical part of this thesis is divided into two main parts. In the first part thesis focuses on SQL Select syntax, which can be used for selecting or getting data from a database. This chapter describes SQL Select parts, its structure and technology and explains what role it plays in theme of this thesis. In the second part thesis familiarizes us with database subsetting and explains it and describes tools, which can solve this kind of problem. In practical part thesis describes application, which was created for dealing with this kind of problem. It explains structure of the application and its functionality and tries to clarify an algorithm, which solves the database subsetting. Final part of the thesis devotes to testing the application and analyzing measured results.