Presented by:

15138544 10210421119420599 1841521026585993990 o

Oleg Bartunov

Postgres Professional

Oleg Bartunov, a major PostgreSQL developer, has been involved in PostgreSQL development since 1996 ( he introduced locale support). He is one of the author of the PostgreSQL extendability infrastructure (GiST, GIN, SP-GiST) and several popular non-atomic data types, such as, arrays, full text search, NoSQL (hstore and jsonb). His latest contribution is a new access method RUM, which greatly improves full text search.

Oleg graduated from the Astronomy department of the Physics department at Lomonosov's Moscow State University. During his professional work at Sternberg Astronomical Institute (SAI MSU) he realized he needed a free and powerful open-source database like PostgreSQL (Postgres95 that time). Since then he extensively used PostgreSQL in his scientific work and many other projects. Oleg is an active member of Russian PostgreSQL community, he advocated the adoption of PostgreSQL by astronomical community. One of his scientific projects make use of scalable indexing of multi-terabytes sky catalogues developed for PostgreSQL, which outperforms known techniques used in commercial databases.

His main interests are Informaton Retrieval, Databases Extensibility, Algorithms and Data Structures, Service-Oriented Architecture for Science and XLDB for Science. In spare time he like to play volleyball, running and trekking in Himalaya.

No video of the event yet, sorry!

PostgreSQL is the first relational database which recognized the need of non-atomic data types to support developers of applications from science to Web. Jsonb in Postgres is the attractive feature for modern application developers, who want to work with json documents without sacrificing a strong consistency and ability to use all the power of proven relational technology.

Finally, SQL world has recognized the NoSQL and released the new SQL-2016 standard, which includes specification of SQL/JSON data model and path language, as well as SQL commands for storing, publishing and querying JSON data. I will present the implementation of jsonpath, the path language for querying json in PostgreSQL and development roadmap.

Date:
2019 July 5 10:10 CST
Duration:
40 min
Room:
JINGGE HALL TRACK1 - English Track
Conference:
Beijing 2019
Language:
Track:
English Speaker Track
Difficulty:
Medium