• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Framework for data warehouse snowflake schema - JPA?

 
Per Lindberg
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic