Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Multidimensional database internal representation.


Multidimensional database internal representation.

Author
Message
kiran.mahamkali
kiran.mahamkali
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 82
Hi,
I'm new to SSAS and i'm going thru the concepts of multi dimensional DBs and cube. I just wanted to know how a multidimensionla database is internally represented on disk( as it has FACT and Dimension tables which are relational tables ..i suppose). Aren't they(Multi dim DBs) represented in relational format as tables? And also i wanted to know how a cube is internally represented in SSAS.Is it just a logical representation of multidimensional data or is there any specific data structure to store this? All these questions came up when i'm going thru the basics of SSAS. Any clues or inputs reg the above queries is greatly appreciated.

Thanks
Kiran Mahamkali:-)
kiran.mahamkali
kiran.mahamkali
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 82
Hi,
I would be really grateful if any one answers my question...Gift wat abt u?
Gift Peddie
Gift Peddie
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4924 Visits: 14456
Hey you know I was asleep here in the US at 1 AM so here are the Microsoft samples just use them for dimension modeling because there is a separate site for prediction modeling. So download the Analysis Server samples and work through that samples. You may also need to buy a book and there are a lot of tutorials in the second link.


http://www.codeplex.com/SqlServerSamples#e2e

http://www.databasejournal.com/article.php/1459531

Kind regards,
Gift Peddie
GGKK
GGKK
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 73
Dimensions and fact(s) data are internally represented in terms of flat files, atleast in msas 2000. Should be the same in SSAS2005 ..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search