Workload management in data warehouses using Teradata Active System Management architecture

This work is focused on the workload management of data warehouses based on Teradata technologies using Active System Management architecture. Objectives of this work are to characterize and analyze Active System Management architecture and types of rules, used in the workload management of Teradata data warehouses. These objectives have been achieved by a search of available resources and their subsequent analysis. Informations obtained from the analysis were empirically verified on a particular instance of a data warehouse and their synthesis is presented in this work The contributions of this work are in the documentation of technology that is currently not well known and widespread in the Czech Republic. Another contribution is identification of risks, drawbacks and presentation of recommendations in the workload management using Active System Management based on empirical tests. The repeatable implementation procedure based on induction has been proposed in the work. Maturity of the architecture for a production environment is evaluated. The work is hierarchically divided into several chapters that are dedicated to Teradata database technologies, workload management, Active System Management and implementation procedure. The first three chapters are focused on theory, however, they also contain practical informations related to the processed theory. The latter chapter is focused practically, therein is designed a repeatable Active System Management architecture implementation procedure.