• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Star/Snowflake schema implementation as a Java Persistence Layer

Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,

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!
the value of filler advertising in 2021
    Bookmark Topic Watch Topic
  • New Topic