A look at the state of data storage, management & analysis, from SQL
to NOSQL, “NewSQL” and beyond. I will explain why the core premises of
data management have changed; tell some of the tales of success and failure I have collected on the topic; share some
counterintuitive rules-of-thumb about the sometimes mind-blowing,
sometimes nerve-wrecking reality of life with an alternative
Keeping a busy site going when you don't have a lot of servers or developer resources can be a struggle. Hear what we did at Daily Kos to make the most of what we had to bring MySQL in line, make it quick, and keep the users and the boss happy.
The open source database landscape has never been in more turmoil, and yet the popularity of Postgres continues to grow and grow. Get up to speed on what you need to know to administer the world's most advanced open source database, including installation, configuration, tuning, and how best to use PostgreSQL's community resources; with special focus on Postgres 9 and the upcoming 9.1 release.
The Basho engineering team has been working to make Riak more queryable with the addition of built-in indexing plus a SQL-style query language. In this talk, Rusty describes the usage, benefits, limitations, and evolution of this this functionality, called Secondary Indices. He also covers the challenges and pitfalls of adding indexing to a distributed datastore.
This talk introduces an open-source SQL-based system for continuous or ad-hoc analysis of streaming data built on top of Flume-based data collection for Hadoop.
Attendees will understand how to use a new tool to extend their Hadoop data collection pipeline with real-time streaming analytics.
Writing SQL is has very little in common with writing application code. Refactoring SQL has nothing in common with writing application code. Good object-oriented refactoring techniques frequently cause problems with SQL. This talk covers tried and true methods for refactoring SQL.