August 13, 2015 at 10:59 pm
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
August 14, 2015 at 3:25 am
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:
August 14, 2015 at 5:06 am
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.
August 14, 2015 at 5:28 am
I've never used them either and guessed at what I thought was the closest one.
August 14, 2015 at 6:29 am
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
August 14, 2015 at 7:56 am
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.
August 14, 2015 at 8:55 am
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.
August 14, 2015 at 10:39 am
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.
August 14, 2015 at 4:47 pm
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.
August 15, 2015 at 8:55 am
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
August 15, 2015 at 4:17 pm
Looks like admin and performance changes. No fundamental ones.
August 16, 2015 at 11:30 pm
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
August 17, 2015 at 6:01 am
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
August 17, 2015 at 6:02 am
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
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply