Re:HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
by julienmarie on Wednesday January 14, 2015 @01:21PM
(#8887998)
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
by beagle3 on Wednesday January 14, 2015 @03:27PM
(#8888798)
> KDB+ .. looks to have its own language to query it
And that's a good thing.
You can use sql to query it if you want by starting the query with "s)" in the console, or simply by using the ODBC/JDBC drivers.
But KDB+ embraces order in a way that SQL does not, which means that if you limit yourself to SQL then you miss out on a lot power that KDB gives you.
For example, say you want to select a list of (date,teacher) records ordered by date, and out of these pick out the records in which the teacher is not the same as in the previous date.
In kdb+, it's "select from (select from records by date) where differ teacher" (or just "&~=':teacher[<date]" if you use K notation). What's the SQL equivalent?
Re:HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
by muehlbau on Wednesday January 14, 2015 @02:45PM
(#8888539)
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 ([email protected]).
Re:HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
by muehlbau on Wednesday January 14, 2015 @02:49PM
(#8888559)
In fact we do write a redo log to disk (Set the REDO environment variable, e.g. REDO=$filename bin/driver when running the driver in our example download). VoltDB tries to be fast at highly partitionable workloads and does not provide OLAP-style query support. HyPer aims at bringing OLTP and OLAP together into one system.
Re:HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
by CurtMonash on Wednesday January 14, 2015 @01:16PM
(#8887978)
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.
And that's a good thing.
You can use sql to query it if you want by starting the query with "s)" in the console, or simply by using the ODBC/JDBC drivers.
But KDB+ embraces order in a way that SQL does not, which means that if you limit yourself to SQL then you miss out on a lot power that KDB gives you.
For example, say you want to select a list of (date,teacher) records ordered by date, and out of these pick out the records in which the teacher is not the same as in the previous date.
In kdb+, it's "select from (select from records by date) where differ teacher" (or just "&~=':teacher[<date]" if you use K notation). What's the SQL equivalent?
1) How you have created the web interface as I can't see any php or python bindings.
2) How do you copy the csv data into the memory table
3) Can we use it internally as our company's internal BI database , since no licenses are mentioned in the downloaded link so its not very clear ..
2) Check out hyperdemo/scripts/tpch/load.sql, HyPer uses the same syntax as Postgres, i.e. you run bin/sql, create a customer table and load it with
3) Please contact us http://www.hyper-db.com/#team