Forum: Ruby on Rails OLAP and Models / ActiveRecord etc etc

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
9f4e11fd04ca1e5a56d00ff3531104ed?d=identicon&s=25 Jean Nibee (jeannibee)
on 2007-06-22 04:44
How would you handle reporting on an OLAP database?

I have no issues whatsoever using the Rails ActiveRecord way of doing
things for my OLTP setup, but for OLAP it "seems" (I haven't tried it
yet) to be one heck of a bunch of overhead.

Then again if there's a way to have a series of related tables in a star
schema like customer_dimension -> sales_facts <- time_dimension; and
just execute a query with my aggregate functions / groupings and then
find a Model to map the ResultSet to I'd be home free. Seems to me
straight to the DB could accomplish this easily.

Now to end all this, I am aware of the ActiveWarehouse 'plugin' to
rails.. it's interesting, I'm just curious if people are foregoing
ActiveRecord for OLAP solutions and going straight to the DB.
588ab1c0a5610a7e160a3b101abb91e6?d=identicon&s=25 Michael Latta (Guest)
on 2007-06-22 05:13
(Received via mailing list)
Our app has an OLAP aspect within an OLTP app.  The schema is a
standard star schema.

For many things we use custom SQL to get subqueries for the
aggregates.  For data management we use AR.

This topic is locked and can not be replied to.