JSON Support Implementation in the Yandex Database Query Language

Student: Lapkov Nikita

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Final Grade: 9

Year of Graduation: 2020

In recent years, the document-oriented data model has become increasingly popular. Application developers use JavaScript Object Notation (JSON) to store schemaless data. Ability to store and manipulate JSON values has became an important aspect to consider when selecting a database. In 2017, due to the popular demand from developers, SQL standard was extended with functionality to work with JSON values. Yandex Database (YDB) is a distributed fault-tolerant NewSQL database with strict consistency guarantees and ACID transactions. In this work we have extended YDB’s query language with JSON values manipulation functionality according to the SQL standard. We have implemented JSON_EXISTS, JSON_VALUE and JSON_QUERY functions with full support of the query language for JSON values described in the standard — JsonPath.

Full text (added May 19, 2020)

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