MDS Models

  • Comments posted to this topic are about the item MDS Models

  • This was removed by the editor as SPAM

  • 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:

  • 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.

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

  • 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

  • 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.

  • 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.

  • 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.

  • 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.

  • 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

  • Looks like admin and performance changes. No fundamental ones.

  • 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

  • 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

  • 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