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
