HyPer – A Hybrid OLTP and OLAP High-Performance DBMS
hyper-db.com
hyper-db.com
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
copy customer from '../tpch/customer.csv' delimiter ',';
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?