SQLLite Analytics with IcCube

For a lot of prototyping and proof of concepts, I tend to use either one of MongoDB or SQLite. Those two prove to be the least resistent path of effort to get ideas out, and communicating with customers. I recently got involved into building an access framework where users can access a set of hosts through our system. One of the requirements was to create a bunch of Excel reports to the customer, like Successful access, Failed Access, etc … based on what data the system was logging into that small sqlite database.

Export once per month is fine, but to make pro-active decision, but in this scenario, where access is being monitoed, one really need to look at data in real time and act on it as soon as possible. It was time to put IcCube just where it fits best: Real Time analytics on any kind of dataset it has access to.

cron job

http://www.quartz-scheduler.org/documentation/quartz-2.3.0/tutorials/tutorial-lesson-06.html

https://stackoverflow.com/questions/9096035/quartz-scheduler-for-java-how-to-run-job-every-5-minutes