MDS Models

Question

MDS Models

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
August 13, 2015 at 10:59 pm

#74519

Comments posted to this topic are about the item MDS Models
August 14, 2015 at 1:32 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

sipas Hall of Fame Points: 3828 More actions · Answer 1

Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather than the model, so that the model defines the structure rather than containing the data. Not that I've ever used them so I'm going on what I've read.:ermm:

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 2

sipas (8/14/2015)
Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather than the model, so that the model defines the structure rather than containing the data. Not that I've ever used them so I'm going on what I've read.:ermm:

I agree. I don't see anything on that page about storing values so I thought the 'correct' solution could not be a choice and went with #4.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I've never used them either and guessed at what I thought was the closest one.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

g.britton SSChampion Points: 13863 More actions · Answer 4

tom.w.brannon (8/14/2015)
sipas (8/14/2015)
Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather than the model, so that the model defines the structure rather than containing the data. Not that I've ever used them so I'm going on what I've read.:ermm:
I agree. I don't see anything on that page about storing values so I thought the 'correct' solution could not be a choice and went with #4.

+1. Models do not store values

Gerald Britton, Pluralsight courses

timwell SSCertifiable Points: 5315 More actions · Answer 5

Is MDS implemented as a specialized database using SQL Server?

I suppose the DBA usually is the one who is responsible because it's data.

Just curious. This is the first I have heard of MDS or MDM.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 6

MDS is a separate feature of SQL Server: https://msdn.microsoft.com/en-us/library/ee633763.aspx

My mistake with values. I'll award points back.

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Hmm... Got it wrong but I will check back whether I per chance got it right. 😉

Nonetheless, it forced me to dig into MDS a bit, so kudos and thanks to Steve.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 8

Was little complicated , I mean the options were little complicated to me. But I scored the maximum. 🙂

I think the definition for model would still remained the same in the earlier editions right from its inception. Right, Steve? OR is there any specific changes to SQL 2016?

Thanks.

TomThomson SSC Guru Points: 104773 More actions · Answer 9

SQL-DBA-01 (8/14/2015)
Was little complicated , I mean the options were little complicated to me. But I scored the maximum. 🙂
I think the definition for model would still remained the same in the earlier editions right from its inception. Right, Steve? OR is there any specific changes to SQL 2016?

Well, Steve's explanation refers to the SQLS 2014 BOL page, not the SQLS 2016 version. I looked at the 2016 version to answer the question and that resulted in the right answer, so at least at the level of this question the nature of MDS models appears not to have changed. As you can probably guess from teh fact that I looked a a BoL page to answer this, I've never used MDS or even looked at it enough to know more than almost nothing about it so I can't be sure whether there were changes between 2008 R2 and 2014 - but at this level of abstraction, I imagine there haven't been any - at first sight the product model at the top of the BOL page hasn't changed between 2008R2 and 2016.

From my point of view this was a good QotD because it made me look at something new to find the answer.

Tom

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 10

Looks like admin and performance changes. No fundamental ones.

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Ed Wagner (8/14/2015)
I've never used them either and guessed at what I thought was the closest one.

+ 1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 12

Steve Jones - SSC Editor (8/15/2015)
Looks like admin and performance changes. No fundamental ones.

There are some nice changes, such as:

* sync entities between models

* there is now a "slowly changing dimension type 2"-type view available, so you can get a historical view of your master data

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 13

Easy question (if you have used MDS a lot :-)), thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP