HyPer – A Hybrid OLTP and OLAP High-Performance DBMS • Hacker News Board

HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#1

Post by uberneo » Wed, Jan 14, 2015, 5:12 PM UTC

HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
hyper-db.com

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#2

Post by polskibus » Wed, Jan 14, 2015, 6:09 PM UTC

Has anyone tried it? Is it an open source or commercial product? Can't find enough information... Can anyone help?

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#3

Post by uberneo » Wed, Jan 14, 2015, 6:11 PM UTC

polskibus wrote: post #2

Has anyone tried it? Is it an open source or commercial product? Can't find enough information... Can anyone help?

check this blog - http://databasearchitects.blogspot.de/2014/05/trying-out-hyp...

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#4

Post by hbrundage » Wed, Jan 14, 2015, 6:13 PM UTC

I couldn't find any information on persistence and crash recovery for this thing... is it able to beat Volt because it doesn't write to disk?

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#5

Post by CurtMonash » Wed, Jan 14, 2015, 6:16 PM UTC

Peter Boncz is involved in some capacity, he told me last time we talked. I believe Peter is the senior academic from the VectorWise project, and second most senior generally in the MonetDB gang after Martin Kersten.

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#6

Post by julienmarie » Wed, Jan 14, 2015, 6:21 PM UTC

Stumbled upon it a few months ago, but nowhere to download it unfortunately. For OLAP needs, the best solution as far as I know right now is still KDB+ ( managed to make some complicated queries with aggregates on 2 millions rows in 46ms on a macboook air with it, quite amazing )... Any alternative you know ?

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#7

Post by uberneo » Wed, Jan 14, 2015, 6:26 PM UTC

julienmarie wrote: post #6

Stumbled upon it a few months ago, but nowhere to download it unfortunately. For OLAP needs, the best solution as far as I know right now is still KDB+ ( managed to make some complicated queries with aggregates on 2 millions rows in 46ms on a macboook air with it, quite amazing )... Any alternative you know ?

KDB+ .. looks to have its own language to query it .. btw you can download hyper-db from http://www.hyper-db.com/downloads/hyperdemo.tar.xz

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#8

Post by uberneo » Wed, Jan 14, 2015, 7:01 PM UTC

Any more In Memory Databases ..which you have tried ?

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#9

Post by liotier » Wed, Jan 14, 2015, 7:28 PM UTC

License ?

Re: HyPer – A Hybrid OLTP and OLAP High-Performance DBMS

#10

Post by muehlbau » Wed, Jan 14, 2015, 7:45 PM UTC

uberneo wrote: post #7

julienmarie wrote: post #6

Stumbled upon it a few months ago, but nowhere to download it unfortunately. For OLAP needs, the best solution as far as I know right now is still KDB+ ( managed to make some complicated queries with aggregates on 2 millions rows in 46ms on a macboook air with it, quite amazing )... Any alternative you know ?

KDB+ .. looks to have its own language to query it .. btw you can download hyper-db from http://www.hyper-db.com/downloads/hyperdemo.tar.xz

Yes, that is our official download link which contains a driver to run transaction benchmarks (specified in our own script language; the tar contains an example for TPC-C) and a psql-like sql tool with which you can load data and query it using SQL-92. An example for TPC-H is also included. You can contact us/me for further questions (muehlbau@in.tum.de).