February 21-23, 2024
Montreal, Canada

Databases Conference

Databases Apache Kafka's an interesting beast. It solves many different data-processing problems by being part queue, part database, and part message bus. But it can be daunting to get started, and like many things, the only real way to understand Kafka is to build something with it. So let's do that!

In this JavaScript live-coding session we'll take our first steps with Kafka, building a system that tracks the London Underground, in real time.
Databases Nobody complains when the database is quick. But when things slow down you try to speed things up by adding an index. Later you try a second index and now things are slower than ever. Indexes can make things faster but you need to know what type of index to use, how to test query performance, and how to maintain them. This session will cover when and how to add an index plus detail how to test their performance.
Databases This talk delves into the present and future of AI in SQL and data analytics. It shows how AI boosts SQL-based analytics for quicker, more precise insights. We'll tackle challenges like data quality, interpretability, and privacy, exploring ongoing research in explainable AI and privacy preservation. Future advances involve automated query optimization, smart data visualization, and integration with emerging database architectures.
Databases In the era of big data and real-time analytics, businesses require powerful database solutions that can handle massive workloads while delivering high-performance query processing. This session aims to introduce participants to the MySQL HeatWave Database Service, a cutting-edge technology offered in Oracle Cloud Infrastructure (OCI) that addresses these requirements.
Join this session to learn about the new features added like Machine Learning.
Databases Commercial monitoring solutions can be complex and costly. Learn to create your own simple, cost-effective, and fast monitoring system with open-source tools like ClickHouse and Grafana. We'll cover key components: data ingestion, querying, and visualization. Through an example system, discover efficient data storage, query construction, and operational dashboard creation. Any developer can do it—join us to learn how!
Databases How can we deal with concurrent transactions in MySQL without compromising data integrity and performance? In this talk, we’ll answer this question by looking at MySQL’s InnoDB storage engine and by exploring aspects such as Multi-Version Concurrency Control (MVCC), read phenomena, and transaction isolation levels. Through live examples, we’ll see how each of these core concepts can help guarantee your data’s integrity in the face of concurrency.
Databases MySQL might be the most popular database on the internet but PostgreSQL is the only top database in the DB Engine Rankings gaining market share. The good news is that if you know MySQL then you have a good base from which to explore PostgreSQL. We will start with a simple installation, account creation, loading data, and some simple queries. Then we will explore the very cool differences and how to exploit them. Expand your skills in this talk!
Databases Large Language Models (LLMs) are powerful. However, they don't have the most up to date information. In this session, Shao Hang He will show you how to feed external data to augment your LLM prompts using Python, LangChain and OpenAI. This includes setting up a Vector Database, converting data to embeddings and making queries. Also, we will go over several examples such as chatting with a PDF and smart search your messages in your email inbox.
Databases The Evolution of a MySQL database, from a single instance to HA with Disaster Recovery.
In this session, we cover the different deployment possibilities of the MySQL architecture depending on the business requirements for the data. We deploy some architectures and see how to evolve to the next one. The attendees will learn how to migrate from single instance to High Availability with Data Recovery across Data Centers with the minimal downtime
Databases Explore real-time analytics challenges with traditional SQL for large datasets. Dive into distributed systems for sub-second responses on petabytes of data. Learn techniques like atomic block inserts, parallelized aggregation, and immutable tables for cost-efficient, stable performance. See them in action with ClickHouse, a leading real-time analytic database. Join us on an exciting journey into fast, big-data analytics.

Explore all 171 sessions

Montreal 2024 sponsored by