Implementation of Wait-Free Database Catalog in ClickHouse

Student: Tokmakov Aleksandr

Supervisor:

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Year of Graduation: 2020

ClickHouse is a column-oriented relational database management system, which is used for real-time analytics by many companies. For synchronization of some DDL-queries, such as CREATE TABLE, DROP TABLE and RENAME TABLE, ClickHouse uses complicated table-level locking mechanism for historical reasons and it has some disadvantages. The main purpose of this work is to implement an alternative approach to DDL queries synchronization and metadata storing. Proposed approach does not require usage of table-level locks and excludes long waiting on execution of mentioned queries. To achieve it new database engine Atomic was implemented in ClickHouse. This engine may replace pre-existing default database engine Ordinary in the future.

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