Database Meetup with topics like: TiDB, Graph Queries, PostgreSQL

We are happy to announce another Meetup where you can listen talks from three guest speakers.

NOTE: This will be an English speaking event.

WE ARE LOOKING FOR SPEAKERS!
If you have a 20-25 minutes topic what would you like to share please contact us.

PROGRAM:

6:30PM
Gathering

6:45PM
Talks are starting

First talk:
Morgan Tocker
TiDB - Distributed, horizontally scalable, MySQL compatible.

TiDB is an open source distributed scalable hybrid transactional and analytical processing (HTAP) database built by PingCAP. It also speaks the MySQL protocol and uses RocksDB as the underlying storage engine! This talk provides an introduction and overview of TiDB, tailored for those with a strong background in MySQL. I will use MySQL as an example to explain various implementation details of TiDB, and translate terminology to MySQL/InnoDB terms.

Morgan Tocker is a Senior Product and Community Manager at PingCAP, the company behind TiDB. He was previously the Product Manager for the MySQL Server at Oracle.

Second Talk:
Apáti János, (DBV Director of Engineering)

Sharing PostgreSQL Success Stories

We've been using PostgreSQL for the past 15 years. For the last 8 years, it has been the sole database provider for our international market research projects which originate in SPSS. Before that it was our database of choice for building registry systems, web frameworks and for a natural gas distributor's remote data collection system.

Due to the ever growing size of the statistical datasets received in SPSS files, from time to time, our reporting platform needs a major overhaul. Our most recent effort towards this end involves implementing a master-replica system for our overseas clients which will separate data serving from processing and therefore provide them with a faster data service and to service.

We'd like to share with you our most gripping war stories that have come out of our decade-worth of experience with PostgreSQL. Tales on Doctrine, Drupal, arrayed keys, transactions, the Amazon cloud and more.

Third Talk:
Gábor Szárnyas

Mapping Cypher graph queries to SQL In the last decade, the NoSQL movement led to the development of numerous database management system. A typically lesser-known group of these systems is the family of graph databases, which allow users to store and query their data as graphs. This data model is often a better fit to represent strongly interlinked data sets than the traditional relational model, and its conciseness can lead to better performance. That said, relational databases have been developed and optimized for almost 50 years, and it is an open question whether efficient processing of graph data requires specialized databases. New query languages were developed for querying and processing graph data, and offer a more intuitive way to express graph queries than SQL-like languages. The openCypher language is a recent initiative to create a standard graph query language, based on the Cypher query language of Neo4j, arguably the most popular graph database on the market. Meanwhile, most enterprises still store their data in traditional relational databases, which necessitates loading their data to graph databases. This is often impractical or infeasible for production databases. Our goal is to allow using expressive graph query languages and leverage the performance of existing relational databases while avoiding the overhead of transferring the data between different systems. To this end, we developed a transpiler which can transform openCypher graph queries into SQL. This opens up the possiblity of using established relational database systems and also querying legacy relational data as graphs.