0

I have a star schema with information/data and I want to write the sql query to pull data from the star schema and then embedd that sql in java application. where can I start from? or are there tutorials that can help me to write java application that can be pulling data from Dimensional Model? Like the way it is MDX Microsoft analysis services?

MoazRub
  • 2,881
  • 2
  • 10
  • 20
Chiko
  • 1
  • 1
  • 3
  • Hello, and welcome to Stack Overflow. Please read "https://stackoverflow.com/help/how-to-ask" - as it stands, this question is a poor fit. It is _very_ broad, asks for resources outside SO, and you could find the answer by a quick Google. – Neville Kuyt Oct 10 '19 at 10:18
  • Is there a way java framework or tutorial to query data from star schema (Dimensional Model) using JAVA and SQL? – Chiko Oct 10 '19 at 10:40

1 Answers1

1

You need to be clear about a few things:

Analysis Services is an OLAP engine. It has preprocessed data stored in it, which is extracted using MDX. The Analysis Services pulls data from transactional database tables, which are organized in a dimensional model.

Now if you want to pull data from dimensional model using Java you can make a view or write custom SQL on the dimensional model and query that to get relevant data. This will be just like querying tables in database. However if you want to query the OLAP engine you use MDX to query. In .net you have adomd for querying in MDX.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
MoazRub
  • 2,881
  • 2
  • 10
  • 20
  • I want to query star schema that is more like ROLAP which is not compiled. – Chiko Oct 10 '19 at 14:12
  • Sure in that case just make some view or write custom quries and use them. Forget that star schema is feeding OLAP – MoazRub Oct 10 '19 at 14:38