Framework for data warehouse snowflake schema - JPA?
posted 5 years ago
I have a DB with operational data built with JPA that works just fine. Hooray for JPA!
Now I'm building a data warehouse with historical data. It's designed according to the "snowflake schema", with gazillions of fact records and a few "slowly changing dimension" records. It seems that this can't easily be built using JPA. Or...? Professor Google appears clueless.
Getting a slice of the facts records with some critieria on the dimensions can require an SQL query filling a whole page. Eek! Since I'm spoilt by JPA it feels natural to ask if there's some nice Java framework that is suitable for snowflake schemas. Or am I doomed to the bogs & marshes of JDBC?