Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Framework for data warehouse snowflake schema - JPA?  RSS feed

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?

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!