Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / October 2005

Tip: Looking for answers? Try searching our database.

What is UDM (SSAS 2005)?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Raghu - 26 Oct 2005 19:11 GMT
I've read through several articles and on-line help, but still can't
visualize what a UDM is. Here are my thoughts. Please bear with me if I sound
like a novice (I am).

Is it the analysis services database in SQL2005?  Is it something else?
Assuming it is analysis services database, I am confused when I see in
several books online docs where they compare UDM Vs. Traditional OLAP. What
is traditional OLAP then?

I read that UDM provides Heterogenous data sources, Proactive caching,  
advanced analytics like simultaneous executions etc. Weren't all these
present in AS 2000 to varying degrees?
Ex: AS 2000 provided connection to heterogenous data sources too. It allowed
HOLAP and let users store aggregations based on disk sapce constraints etc.
Isn't proactive caching just taking it to the next level  by providing higher
granularity in specifying what can be cached and what cannot?
Advanced analytics are something that is a an improvement in calculations.

Me and my collegues were discussing these, and one of things that was
mentioned is that UDM is an analysis services database with the Storage mode
switched to ROLAP. I now see only two choices for storage - MOLAP and ROLAP.
ROLAP was supported in AS 2000 as well.  I assume Proactive caching is the
replacement for HOLAP in AS 2005. Is UDM a regular analysis services database
with storage mode set to ROLAP?

These prompt me to ask - Is there a real distinction between an analysis
services database with cubes,  dimensions etc. and UDM, or are they one and
the same? Does it physically amount to something or is it a conceptual name
for for a group of some of the techniques? or is it probably a marketing hpye
or buzzword? (not that I see anything wrong with that)

What bothers me is that this UDM usage is ubiquitous in the books online
without any clear description of what it is and what it brings new comapred
to AS 2000 (I can't claim to ahve checked the entire BOL, so my statements
are restricted to my searches in BOL)? Are there any docs that can shed some
light on this?

Any thoughts and suggestions to help improve my understanding (and hopefully
others) is greatly appreciated.

Thanks
Pablo Mugica - 29 Oct 2005 00:36 GMT
This is a good question.
UDM is a concept, a way of build a cross enterprise data model for our
decision support systems. And this concept is now achievable because of the
new features in SSAS.
IMHO

Very useful link:
http://www.microsoft.com/technet/prodtechnol/sql/2005/solvngbp.mspx

Pablo S. Mugica
MCDBA, MCSA

> I've read through several articles and on-line help, but still can't
> visualize what a UDM is. Here are my thoughts. Please bear with me if I
[quoted text clipped - 51 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.