VoltDB presents a use-case based overview of what VoltDB is and the types of problems it helps to solve. We’ll also discuss some newer VoltDB features, including the WAN replication beta functionality and command logging (a durable write-ahead log). This will be an interactive presentation and questions from the group …
Think SQL Server is magical? You’re right! However, there’s some sense to the magic, and that’s what I’ll show you in this extremely deep dive session. Through my work in creating OrcaMDF, an open source parser for SQL Server databases, I’ve learned a lot of internal details for the SQL …
What happens when you deconstruct the traditional monolithic database: separating transaction processing, storage and query into independent cooperating services? Coupled with a data model based around atomic facts and awareness of time, you get a significantly different set of capabilities and tradeoffs. This talk with discuss how these ideas play …
Every application that needs to support simultaneous clients (concurrency) should be built using transactions with ACID properties. As the NoSQL databases technology matures, transactions will play an increasingly prominent role. In this article, David Rosenthal and Stephen Pimentel explains that transactions are the simplest and strongest programming model available to …
Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to …
Periodic data warehouse loads and ETL process no longer scale to meet the increasing business needs in the web economy. Todays modern organizations are combining high performance operational NoSQL data stores like MongoDB with traditional business intelligence RDBMS solutions to create a hybrid than solves the business need to have …
