I'm using sqlite's count function to emulate OLAP functionality. Unfortunately count function is not exposed in sqlite, nevertheless it eases the pain of not having analytics functions in sqlite (lead, lag, median etc).
lefteris Alexey Pechnikov wrote: > Hello! > > В сообщении от Monday 24 November 2008 19:16:46 Constantine Vassil написал(а): >> OLAP functionality includes the concept of a sliding *window* that moves >> down >> through the input rows as they are processed. Additional calculations can >> be >> >> performed on the data in the window as it moves, allowing further analysis >> in a >> manner that is more efficient than using semantically equivalent self-join >> queries, or correlated subqueries. >> >> I am thinking this functionality is possible to implement working directly >> with >> the B-Tree. >> >> Does anyone has better ideas? > > I think application-level solutions (R language for example) is better. I'm > using safe tcl > interpreter with custom functions and do send input data row by row to it. > > Best regards, Alexey. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
