I am working in an application that requires analytical functions to be performed on the data before displaying it to the user.
The actual data and the 'calculated' analytical data will be stored in a relational database. To reflect the data warehousing concepts, the relational database will be of star schema - comprising of fact and dimension tables.
The persistence layer is in Java concerning the data retrieval, calculations and storage.
I have doubts regarding how the data access is possible in Java reflecting Star Schema ? Will ORM be effective (concerning how the fact and dimension tables are related and the same can be established via entity relationships)? I am concerned about the 'voluminous' entities to be created if the data to be analyzed or retrieved is huge. Or will JDBC be effective performing as many joins as required? Or are there any other possibilities ?
Has anybody worked on a similar design before ? A 'rough idea' would be a good start as well.
Thanks in advance for your help :-)
Your mother is a hamster and your father smells of tiny ads!