InfiniDB is a column-oriented database engine for MySQL.
Questions tagged [infinidb]
35 questions
0
votes
1 answer
Perform SQL function on single column based on multiple foreign keys
I encounter this problem when trying to work out a dimensional database design. Basicially I haave a fact table (sale_fact) which contains a surrogate key, several foreign keys (pid for product id, cid for country id and date), and sales data. The…
Nemo Bryant
- 3
- 3
0
votes
1 answer
Moving average with InfiniDB
I'm trying to write a query that returns a moving average from a large table (>1M rows).
The table has a column with a date, and and an other column with a numeric value. I need the last 10 days, with the 10 day moving average for every…
netom
- 3,322
- 2
- 21
- 21
0
votes
1 answer
alternatives for aggregating a lot of data fast
i'm using InfiniDB to aggregate a lot of rows (about 100-500 million) down to about less than 5000 groups. (in most querys the 100-500 million rows are filtered, so the aggregation will work on less rows)
It is used as a prototype of a…
RomanKonz
- 1,027
- 1
- 8
- 15
0
votes
3 answers
count duplicate column values in one row
i have a denormalized table, where i have to count the number of same values in other columns.
I'm using the InfiniDB Mysql Storage Engine.
This is my Table:
col1 | col2 | col3
------------------
A | B | B
A | B | C
A | A | A
This…
RomanKonz
- 1,027
- 1
- 8
- 15
0
votes
2 answers
Role-playing dimensions in infiniDB?
Since InfiniDB lacks views how would you get Date Dimension to play the role of "Registration Date" AND "Login Date" AND "Purchase Date" and so on...
(Normally you would create a view of date dimension posing as registration date but going against…
Geuder
- 15
- 1
- 5