7 au 9 mars, 2018
Montréal, Canada

Conférence Bases de données

Bases de données How do you mix SQL and NoSQL worlds without starting a messy revolution?

This 100% live coding talk will show you how to add Elasticsearch to your legacy application without changing all your current development habits. Your application will have suddenly have advanced search features, all without the need to write complex SQL code!
Bases de données Apache Cassandra is one of the most renowned NoSQL databases. Although it's often associated with great scalability, improper usage might result in shooting yourself in the foot. In this talk I'll present a set of ideas and guidelines - both for developers and administrators - which will help you to make your project an epic failure.
Bases de données CQRS & event sourcing are very popular topics. However, most blogs and talks focus on the theory or introductions to a framework, not necessarily the challenges of a production deployment.

This session bridges that gap and looks at some of the pitfalls of a real-world deployment. I'll discuss topics like concurrency & scale, refactoring events and updating read models. Attend this talk to learn from my experiences and be better prepared.
Bases de données Does your application use a database, and have you ever changed the database schema? Then you probably know these database migrations can lead to downtime and can be an obstacle to implementing continuous delivery.

In this talk we’ll discuss non-destructive changes, rollbacks, large data sets, useful tools and a few strategies to migrate our data safely, with minimum disruption to production.
Bases de données Wanna transform your documents on the fly before indexing them into elasticsearch? Node ingest is built for you.

The talk will also cover the reindex api, which can be used in combination with ingest pipelines to modify data while reindexing.

Last but not least, I'll tell you how to write your own Ingest processor in Java as a plugin! Our own processor will convert postal addresses from/to geo points.
Bases de données MariaDB ColumnStore is a storage engine optimized for modern analytical workloads released under the GPL license. It is a distributed technology with parallel query processing for greater scalability, and is based on columnar storage for higher efficiency and query performance.

We will cover many of its core features and discuss examples of real-world use cases where it is being used today.
Bases de données MariaDB has been adding lots of cool new features in the latest 10.2 GA release, and this trend continues with the upcoming 10.3 version. We will discuss some of most valuable features for developers.

Learn how to powerfully analyze data with windowing functions and Common Table Expressions. Learn how much easier MariaDB is to use if you are moving from other databases with our new Oracle compatibility features to name but a few…
Bases de données Some things when it comes to working with databases are obvious to everybody. Other things are hidden from everybody. Yet some can be obvious to an experienced DBA, but come as a big surprise to application developers, and these can often be different between different databases.

In this talk I'll go through some of the common mistakes I've seen in applications built against PostgreSQL that made perfect sense, yet were suboptimal or failed.
Bases de données Reactive programming is a great tool for the skilled developer, enabling us to deliver more scalable, resilient, & responsive services...but only if we leverage the reactive model throughout the entire stack!

Using Spring Data & your favorite NoSQL data store, you can exploit the full power of reactive systems, all the way to the metal. The presenter compares reactive support for several DBs, then *live codes* real-world examples.
Bases de données Join us as we expose database design anti-patterns. We'll model a shoe store and show both a simple design with flaws and more flexible alternatives. We'll discuss how to represent trees, and see that the simplest solution is the hardest to query. We'll explore scenarios where a polymorphic relationship looks like a good choice, but isn't (and one where it is). Learn these pitfalls, and save yourself from sloppy querying and poor performance
Bases de données Big Data is everywhere and new tools for it are released almost at the speed of new JavaScript frameworks. During this entry level presentation I will walk though the challenges which Big Data presents, reflect how big is big and introduce currently most fancy and popular (mostly open source) tools.

I'll try to spark off interest in Big Data by showing application areas and by throwing ideas where you can later dive into.
Bases de données Where is the truth in sentences like "ORMs are slow" or "SQL is insecure" ?
We will walk through the reasons that shaped ORM architecture, their potential and limitations.
After this talk you will be in a better position to choose the best fit for you and your next application.
Bases de données Are your queries slow? Learn how to speed them up through better SQL and use of meaningful indexes. You will understand what works well and what doesn't, and will walk away with a checklist for faster databases. Through examples and benchmarks, I will demonstrate how to go from almost a minute of SQL execution to less than a millisecond. I expect that you will all be itching to analyze queries to see how much you can shave off.
Bases de données For more than 45 years, everyone thought the problem was the processing power. For us, it was clear the problem was the B-Tree because the cost of processing a find operation grows as the logarithm of the file size.

This ideology is the opposite of intelligence because while we are growing up, we generate more and more data, but with time, we are not getting slower, in fact, we just become more intelligent!

We reinvented database, come see
Bases de données Everybody is talking about big data, and NoSQL technologies are all the rage these days. But do you really have "big data", or is your database server just slow? In this session you'll learn about the various families of NoSQL data stores, their pros and cons, and which problems each one is designed to solve. You'll get a better understanding of when to use relational vs. NoSQL databases and how to migrate from one to the other.
Bases de données PostgreSQL 10 is out -- with a brand new style of version numbering. But beyond that it of course also comes with a large number of interesting improvements for both developers and DBAs. This talk will outline some of the bigger ones, and how they can be used for better or easier service.

Explorez les 154 présentations

Montréal 2018 sponsored by