OLTP and OLAP – Have Your Cake and Eat it Too!

Looks like we’ll be having some more fun at the Percona Live MySQL Conference! In addition to our booth and my colleague Tim’s talk, my lightning talk was accepted. The title is “OLTP and OLAP – Have Your Cake and Eat it Too!” The lightning talks, given in a TBD order, will start Wednesday evening (April 11th) at around 6:30 pm.

Below is the abstract I submitted.

 

OLTP and OLAP – Have Your Cake and Eat it Too!

The real end-game for Big Data is to have transactional and analytic data on the same database. Just imagine the maximum value one could get out of designing analytics as part of operations.

Databases used to be all-serving 40 years ago with one type of indexing structure used ubiquitously. This all worked well with the simple drives and application of the time. As the decades wore on, applications, storage, and database needs evolved. In response, the basic database diverged into all sorts of speciality products (ie, column store, NoSQL, etc…). However, it needn’t be this way.

We’ll walk you through the decades and show the path from single database to pluralism back to single database. All in 5 minutes!

Tags: , , , , , .

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>