News for hackers. Stuff that matters.

A comment on Peloton – a relational database designed for autonomous operation.

Re:Peloton – a relational database designed for autonomous o... by buremba on Saturday January 21, 2017 @06:10PM (#13452625)
I wonder why they try to support both OLTP and OLAP workloads. Supporting both of these workloads requires too much work (both row and columnar storage types, different algorithms for both storage and querying etc) and they didn't even prove that autonomous systems (which is the main point of the project) can replace the existing databases.
[ Parent | on HN ]
Re:Peloton – a relational database designed for autonomous o... by jarulraj on Sunday January 22, 2017 @11:19AM (#13455782)
Great question! There happens to be an autonomous mechanism for supporting hybrid workloads (OLTP & OLAP). Peloton supports hybrid storage layouts that are automatically and dynamically adapted over time based on the workload patterns. Row and columnar storage types are special cases of hybrid storage layouts.

This is a promising area of ongoing research. If you are curious about this kind of autonomous tuning of storage layout, you might want to check this out [1].

[1] https://www.cs.cmu.edu/~jarulraj/papers/2016.tile.sigmod.pdf

[ Parent | on HN ]
Re:Peloton – a relational database designed for autonomous o... by allyraza on Sunday January 29, 2017 @02:00AM (#13512720)
I guess it is a trend currently with modern MMDB's (MEMSQL,HyperDb etc) have support for both OLTP & OLAP workloads. You can checkout the git repo give it a spin see if it hold up to the claims.
[ Parent | on HN ]
Re:Peloton – a relational database designed for autonomous o... by manigandham on Sunday January 22, 2017 @02:07AM (#13454067)
http://www.memsql.com/ does this today. Fast, distributed, rowstore + columnstore, relational database with mysql protocol.
[ Parent | on HN ]
Re:Peloton – a relational database designed for autonomous o... by buremba on Sunday January 22, 2017 @05:15AM (#13454531)
However Peloton also aims to be an autonomous system. That's a lot for undergrad and grad students so I'm not sure if he wants Peloton to be stable in a near future.
[ Parent | on HN ]
Re:Peloton – a relational database designed for autonomous o... by aerioux on Sunday January 22, 2017 @04:58AM (#13454490)
Also fits in the niche between people who want both possibilities - though the onus is on the authors to show that it actually is just as good
[ Parent | on HN ]