Microsoft SQL Server Master Data Services: Difference between revisions

Revision as of 20:17, 23 November 2015

Revision as of 02:20, 24 March 2016

Line 4:

}}

'''Microsoft SQL Server Master Data Services''' is a [[Master Data Management]] (MDM) product from [[Microsoft]], which willthat shipships as a part of the [[Microsoft SQL Server]] database.{{cn|date=January 2015}} Originally code-named '''Bulldog''', Master Data Services (MDS) is the rebrandingSQL ofServer thesolution [[Special:Search/Stratature|Stratature]]for MDMmaster productdata titledmanagement. '''+EDM''',Master whichdata Microsoftmanagement acquired(MDM) inenables Juneyou 2007.<reforganization name="timeline">{{citeto webdiscover |and urldefine =non-transactional http://www.profisee.com/timeline/tabid/248/Default.aspxlists |of titledata, =and Strataturecompile Corporatemaintainable, Timelinereliable |master publisher = Profisee | accessdate = 2012-02-13}}</ref>lists. Master Data Services isfirst architecturallyshipped similarwith toMicrosoft +EDM,SQL withServer increased2008 integrationR2. with other Microsoft applicationsSQL asServer well2016 asincludes somemany newenhancements features.{{cn|date=January 2015}}to Master Data Services, firstsuch shippedas withimproved Microsoftperformance SQLand Serversecurity, 2008and R2.the ability Microsoftto SQLclear Servertransaction 2012logs, improvedcreate the analyticalcustom capabilitiesindexes, addedshare table-basedentity integration,data anbetween add-in for Microsoftdifferent Excelmodels, and integrationsupport withfor othermany-to-many softwarerelationships.<ref>{{cite webFor |more urlinformation, =see http[https://webmsdn.archive.org/web/20070626030519/http://blogs.technetmicrosoft.com/patricgen-us/archivelibrary/2007/09/19/microsoft-master-data-managementff929136.aspx |What's titleNew = Microsoftin Master Data ManagementServices | accessdate = 2007-09-25}}</ref>(MDS)]

==Overview==

In Master Data Services, the model is the highest level container in the structure of your master data. You create a model to manage groups of similar data. A model contains one or more entities, and entities contain members that are the data records. An entity is similar to a table.

Like other MDM products, Master Data Services aims to create a centralized data source and keep it synchronized, and thus reduce redundancies, across the applications which process the data.{{cn|date=January 2015}}

Line 23 ⟶ 25:

Other attributes however, will be of type 'free-form' (most common) or 'file'.

* ''Attribute Groups'' are explicitly defined collections of particular attributes. Say you have an entity "customer" that has 50 attributes &mdash; too much information for many of your users. Attribute groups enable the creation of custom sets of hand-picked attributes that are relevant for specific audiences. (e.g. "customer - delivery details" that would include just their name and last known delivery address). This is very similar to a database view.

* ''Hierarchies'' organiseorganize members into either Derived or Explicit hierarchical structures. Derived hierarchies, as the name suggests, are derived by the MDS engine based on the relationships that exist between attributes. Explicit hierarchies are created by hand using both leaf and consolidated members.

* ''Business Rules'' can be created and applied against model data to ensure that custom business logic is adhered to. In order to be committed into the system data must pass all business rule validations applied to them. e.g. Within the Customer Entity you may want to create a business rule that ensures all members of the 'Country' Attribute contain either the text "USA" or "Canada". The Business Rule once created and ran will then verify all the data is correct before it accepts it into the approved model.

* ''Versions'' provide system owners / administrators with the ability to Open, Lock or Commit a particular version of a model and the data contained within it at a particular point in time. As the content within a model varies, grows or shrinks over time versions provide a way of managing metadata so that subscribing systems can access to the correct content.

Line 31 ⟶ 33:

==External links==

*[httphttps://msdn.microsoft.com/en-us/sqlserverlibrary/ff943581ee633763.aspx Microsoft SQL Server 2008 R22016 Master Data Services]

[[Category:Data management]]