Microsoft SQL Server Master Data Services: Difference between revisions

Revision as of 17:31, 12 May 2013

Revision as of 16:23, 5 July 2013

Line 14:

Master Data Services also includes certain features not available in the Stratature +EDM product. It gains an [[Web service]] interface to expose the data, as well as an [[API]], which internally uses the exposed web services, exposing the feature set, programmatically, to access and manipulate the data. It also integrates with [[Active Directory]] for authentication purposes. Unlike +EDM, Master Data Services supports [[Unicode]] characters, as well as support multilingual user interfaces.<ref name="roadmap"/>

== Terminology ==

* ''Model'' is the highest level of an MDS instance. It is the primary container for specific groupings of master data. In many ways it is very similar to the idea of a database.

* ''Entities'' are containers created within a model. Entities provide a home for members, and are in many ways analogous to database tables.

* ''Members'' are analogous to the records in a database table (Entity). Members are contained within entities. Each member is made up of two or more attributes.

* ''Attributes'' are analogous to the columns within a database table (Entity). Attributes exist within entities and help describe members (the records within the table). Name and Code attributes are created by default for each entity and serve to describe and uniquely identify leaf members. Attributes can be related to other attributes from other entities which are called '___domain-based' attributes. Other attributes will be of type 'free-form' (most common) or 'file'.

s,<ref>http://searchsqlserver.techtarget.com/definition/database-replication</ref>

* ''computation replication'' if the same computing task is executed many times.

== References ==