Teradata DBMS-oriented SQL Scripts Optimizing Preprocessor

Student: Sudina Anastasiia

Educational Programme: Software Engineering (Bachelor)

Final Grade: 8

Year of Graduation: 2016

This graduation project’s purpose is to develop a Teradata DBMS-oriented SQL scripts optimizing preprocessor. As Data Warehouses get more complex and comprehensive, the lack of storage space and CPU resources becomes a major problem. This work’s main objective is to identify how to optimize ETL processes for Teradata DBMS and develop a software tool that could fix or notify a developer about typical SQL scripts’ problems like poor primary index choice, repetitive code and unnecessary joins or selection of table columns that are not used in the creation of final tables. The paper contains 35 pages, 3 chapters, 6 illustrations, 5 tables, 10 bibliography items, 5 appendices. Keywords: Teradata DBMS, SQL-scripts optimization, ETL

Full text (added May 30, 2016)

Student Theses at HSE must be completed in accordance with the University Rules and regulations specified by each educational programme.

Summaries of all theses must be published and made freely available on the HSE website.

The full text of a thesis can be published in open access on the HSE website only if the authoring student (copyright holder) agrees, or, if the thesis was written by a team of students, if all the co-authors (copyright holders) agree. After a thesis is published on the HSE website, it obtains the status of an online publication.

Student theses are objects of copyright and their use is subject to limitations in accordance with the Russian Federation’s law on intellectual property.

In the event that a thesis is quoted or otherwise used, reference to the author’s name and the source of quotation is required.

Search all student theses