BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Memento EPFL//
BEGIN:VEVENT
SUMMARY:One Size Fits None - (Everything You Learned in Your DBMS Class is
  Wrong)
DTSTART:20130530T151500
DTEND:20130530T161500
DTSTAMP:20260929T043758Z
UID:3bd83ec3ca77f73d72221f9fd43e63848ecbd5b4b634656a20e13957
CATEGORIES:Conferences - Seminars
DESCRIPTION:Prof. Michael Stonebraker\, MIT\nThe traditional wisdom for b
 uilding DBMSs is to:\n1) organize blocks of data on disk\, with a main mem
 ory block cache. \n2) implement an Aries-style write-ahead log.\n3) use r
 ecord level locking.\n4) utilize a multi-threaded architecture.\n5) Use an
  active-passive architecture for replication\n6) use multi-threading\nThis
  traditional wisdom is exemplified in all the major DBMS products\, includ
 ing DB2\, MySQL\, Postgres\, SQL Server\, and Oracle.  In a paper in ICDE
  2005\, we argued that “one size does not fit all” and that a variety 
 of data management solutions should be considered for deployment.  Nine y
 ears later\, we make an even stronger statement\; namely the traditional w
 isdom is all wrong\, and systems architected according to it are not good 
 at anything.\nUnless you squint\, the DBMS market is divided into thirds\,
  namely On-Line Transaction Processing (OLTP)\, data warehousing (DW) and 
 everything else.  The “everything else” market is a mix of No_SQL\, h
 adoop\, graph DBMSs bases\, array DBMSs\, etc.  None of these relate to t
 he traditional wisdom\; hence\, we deal with the other two markets.\nIn th
 e DW market\, it is clear that the world is moving to column stores\, and 
 the only successful vendors will be selling that technology.  We explain 
 the architecture that implements systems column stores like Vertica\, Hana
  and Paraccel.  As will be crystal clear\, column stores have no relation
 ship to the traditional wisdom.\nThen\, we turn to OLTP DBMSs and argue\, 
 using performance numbers\, that a main memory orientation with anti-cachi
 ng of main memory objects when space is exhausted is a far better alternat
 ive than a disk based system with caching.  Similarly\, a transaction log
  dominates a data log\, such as Aries and an active-active architecture fo
 r replication is preferred to an active-passive one.  Lastly\, determinis
 tic concurrency control solutions are similarly dominant\, compared to dyn
 amic locking.  In short\, next generation OLTP systems will be built usin
 g anti-caching\, single-threading\, deterministic execution\, and active-a
 ctive replication.  They will bear little resemblance to today’s tradit
 ional systems.                      \nIn summary\, t
 he traditional wisdom is not a good idea in any application area\, and “
 one size fits none”.  I expect DBMS textbooks\, future DBMS courses and
  the commercial market will quickly reflect this point of view.
LOCATION:BC 420 https://plan.epfl.ch/?room==BC%20420
STATUS:CONFIRMED
END:VEVENT
END:VCALENDAR