Improving Analytical DBMS ClickHouse: Support for Input-Output Formats Parquet and Protobuf

Student: Zhukov Ivan

Supervisor: Ivan Vitalyevich Puzyrevskiy

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Final Grade: 7

Year of Graduation: 2018

ClickHouse is a database management system created by Yandex for generating real-time analytics data reports. Its key factors are ability to process enormous amount of data and very rapid aggregate results gathering. One common way to upload such data into DBMS is to send it other a network in TSV or CSV format. However, several methods of binary data serialization can be used to reduce its size, to increase DBMS performance and to reduce the load on the network. In this study, such different data formats and serialization methods are examined and their support in CilckHouse is implemented.

Full text (added May 21, 2018)

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