Columnar databases are designed for high performance queries and analytics. This session will cover the differences between row and column databases, and how Infobright's columnar database, built on MySQL, delivers high performance without indexes, data partitioning or other DBA effort. It will also discuss how to migrate from traditional row-based products, and present several case studies.
This tutorial will provide an in-depth tutorial on various forms of NOSQL (NotOnlySQL) datastores (key/value, data structure store, document store and wide column stores) for working with semi- structured data. The data ranges from web logs to social and knowledge graphs to configuration data stores for cloud infrastructures and other domains.
Moore's Law has run its course, yet despite the growing demands placed
on databases, traditional solutions offer little alternative to vertical
scaling. Come learn step-by-step how to use Apache Cassandra to turn a
cluster of inexpensive commodity servers in to a massively scalable
MongoDB (from "humongous") is a high-performance, open source, schema-free document-oriented database.
Like most web applications, memcached and MySQL formed the data foundation beneath Farmville - until mid-2010. As the popularity of that application skyrocketed, a more effective system was needed to sustain FarmVille's 500,000 operations per second. In response, NorthScale, Zynga and NHN developed _membase_ - a distributed, key-value database that is 100% compatible with memcached.
Moderated by: Gabrielle Roth
Get together with other PostgreSQL users & developers!
The PostgreSQL Open Source Databases upcoming release includes several ground-breaking new features that allows database administrators to "take things to the next level". In this tutorial you will learn how to architect and implement PostgreSQL's Warm Standby, Hot Standby, and Streaming replication capabilities.
With support right out of the box, Django is one of the most efficient ways of deploying a PostgreSQL-backed web application. We'll discuss techniques to get maximum efficiency out of PostgreSQL using Django, including schema design tips, Django ORM techniques, transaction management, and extending PostgreSQL.
Moderated by: Ryan Betts
VoltDB is a new, in-memory, distributed, ACID compliant SQL store designed specifically for high-throughput transactional workloads. Curious to learn more? Come hang out with a VoltDB developer. We'll discuss what it's good at, why we made VoltDB, how it works and what use cases VoltDB solves.
The need for database systems that scale efficiently has led to many alternatives to the traditional RDBMS. This talk presents an overview of these new non-relational databases, collectively referred to as "NoSQL," followed by an in-depth examination of SourceForge.net's deployment of MongoDB, an open-source NoSQL database.
Learn how to apply the principals of test-driven development to developing a database schema.
Many people view topics like Map/Reduce and queue systems as advanced concepts that require in-depth knowledge and time consuming software setup. Gearman is changing all that by making this barrier to entry as low as possible with an open source, distributed job queuing system. This session dives into advanced use cases that demonstrate the power and flexibility of distributed architectures.
NoSQL (or NOSQL -- Not Only SQL) is sometimes justly criticized for being too broad a category, but after thirty years of the relational database being the instinctive choice for data storage, publicizing the concept that One Size Does Not Fit All is a Good Thing. This talk will present some axes along which to evaluate database products, applied to some of today's popular NoSQL products.
This workshop will show you how to build a high-performance social network backend based on the open source Neo4j graph database. We will investigate the implementation of a small but working social network backend with simple but powerful APIs to find paths between people and analyze the social graph. Finally, we will show how it outperforms a relational backend by a factor of 1000x or more.