• 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?

 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!