February 26-28, 2014
Montreal, Canada

Databases Conference

Databases Neo4j comes with enhanced connectivity of data and whiteboard friendly paradigm. It also brings a gremlin in your code : one of the supported graph query language brings a refreshing look at how one can search for data in a vast and interconnect web of data. Gremlin provides an abstract layer that make it easy to express your business logic without fighting with the code. It may even change your mind on object oriented programming.
Databases Pubs and OpenStreetMap are both a hobby. In this talk, I will be explaining
MongoDB's geospatial features to help you (and me) to find the closest pub.
The talk covers how the OpenStreetMap data works, how to store this in MongoDB
and what types of different queries we can run to find the closest pub. We will
be looking at some theory (some scary maths!) and some practical examples.
Databases In this talk I will explain the differences between different types of noSQL databases. I will then progress to illustrate which paradigm shifts are necessary to successfully implement noSQL, using MongoDB as an example.

Covered subjects will be: CAP theorem, schema design, dealing with error
situations and architecture of multi-node set-ups. Everything you need to effectively use MongoDB.
Databases This presentation shows how mongo and hadoop can work together to provide scalable access and analytics. It will show how you can you use mongodb as input for your M/R jobs as well as input for Pig jobs.
Databases Relational databases offer a number of features to protect data integrity and protect against concurrent modification of data. This session will describe how those features work, including table/row locks, MVCC, deadlocks & lock waits, transactions and isolation levels.

Attendees will also get a better understanding of they are expected to be handle database errors in applications. Examples will use MySQL 5.6.
Databases This presentation begins with a basic introduction to MongoDB and how data is organized. It covers several options for interacting with MongoDB and then walks through an example JPA application and then a version for MongoDB. It also explores how MongoDB’s paradigm can affect not only your object model but how you interact with the data as well.
Databases Everyone wants a more organized database with less repetition, right? Quick answer: normalize! Great, but what does this actually mean for the structure of your tables? Which normal form should you use, and what is a normal form? Learn the pros and cons of normalization techniques and find the right balance for your next project.
Databases OrientDB is a NoSQL graph database which also includes a document layer (like MongoDB): it gained a lot of attention, enough to push big companies like Sky and UltraDNS to use it in production: it's written in Java and it's amazingly fast, since it can store up to 150,000 records per second on common hardware; moreover, thanks to being a graphdb, it can manage relationship so fast that, compared to traditional DBs, can be 1000% faster than them.
Databases Most database lovers have heard of memcached for application-level data caching, but many haven't had the opportunity to play with Redis, a powerful in-memory data structure store.

In this presentation, we explore Redis data structure operations through a number of patterns: key-value storage, leaderboards, membership, counters and message queues. To keep things fair, we'll provide relational database versions for comparison as well.
Databases Are your queries slow? Learn how to speed them up through better SQL crafting 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.
Databases We've all heard in recent years about how Key-Value stores cast off the scaling problems of SQL-based solutions and give developers the flexibility to choose in-memory or disk-persistent, single-node or clustered options.

In this talk, we review design and performance of several key-value stores (Riak, LevelDB, and MySQL API), and several techniques such as efficient compression and schema extraction to get the most out of any KV store.

Databases InnoDB became the default storage engine in MySQL 5.5, and continues to improve in MySQL 5.6 (GA) and 5.7.

This talk describes how InnoDB works under the hood, and describes how various features such as MVCC, REDO/UNDO, double write buffer, change buffering and adaptive hash work.

There will be some discussion around configuration, but the main goal of this talk is to give attendees "x-ray vision" when debugging future problems.
Databases PostgreSQL 9.3 was released in September 2013, and as usual brings a lot of new features both for application developers, database administrators and general sysadmins. This session will give an overview of the new features, what they do, and how to use them. Depending on how much is decided at the time, some teasers for the next version will also be included.

Explore all 146 sessions

Montreal 2014 sponsored by