Microsoft SQL Server Master Data Services: Difference between revisions

Revision as of 07:30, 15 June 2017

Revision as of 16:13, 30 October 2017

Line 1:

'''Microsoft SQL Server Master Data Services''' is a [[Master Data Management]] (MDM) product from [[Microsoft]] that ships as a part of the [[Microsoft SQL Server]] relational database management system.<ref>https://msdn.microsoft.com/en-us/library/ms130214.aspx</ref> Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) enablesallows an your organization to discover and define non-transactional lists of data, and compile maintainable, reliable master lists. Master Data Services first shipped with Microsoft SQL Server 2008 R2. Microsoft SQL Server 2016 includes manyintroduced enhancements to Master Data Services, such as improved performance and security, and the ability to clear transaction logs, create custom indexes, share entity data between different models, and support for many-to-many relationships. For more information, see [https://msdn.microsoft.com/en-us/library/ff929136.aspx What's New in Master Data Services (MDS)]

{{multiple issues|

{{Advert|date=March 2011}}

{{Update|inaccurate=yes|date=April 2010}}

}}

'''Microsoft SQL Server Master Data Services''' is a [[Master Data Management]] (MDM) product from [[Microsoft]] that ships as a part of the [[Microsoft SQL Server]] relational database management system.<ref>https://msdn.microsoft.com/en-us/library/ms130214.aspx</ref> Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) enables your organization to discover and define non-transactional lists of data, and compile maintainable, reliable master lists. Master Data Services first shipped with Microsoft SQL Server 2008 R2. Microsoft SQL Server 2016 includes many enhancements to Master Data Services, such as improved performance and security, and the ability to clear transaction logs, create custom indexes, share entity data between different models, and support for many-to-many relationships. For more information, see [https://msdn.microsoft.com/en-us/library/ff929136.aspx What's New in Master Data Services (MDS)]

==Overview==

Line 15 ⟶ 10:

Master Data Services allows the master data to be categorized by hierarchical relationships, such as employee data are a subtype of organization data. Hierarchies are generated by relating data attributes. Data can be automatically categorized using rules, and the categories are introspected programmatically. Master Data Services can also expose the data as [[Microsoft SQL Server]] [[view (database)|views]], which can be pulled by any [[SQL]]-compatible client. It uses a role-based access control system to restrict access to the data. The views are generated dynamically, so they contain the latest data entities in the master hub. It can also push out the data by writing to some external journals. Master Data Services also includes a web-based UI for viewing and managing the data. It uses [[SilverLight]] in the front-end and [[ASP.NET]] in the back-end.{{cn|date=January 2015}}

Master Data Services also includes certain features not available in the Stratature +EDM product.{{fact}} It gains a [[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.{{cn|date=January 2015}}

ThereSQL hasServer been2016 introduced a significant [http://www.faceofit.com/why-is-sql-server-2016-is-faster-than-ever performance increase] in Master Data Services in SQL Server 2016 as well as theover Excelprevious Add-Inversions.<ref>http://www.faceofit.com/why-is-sql-server-2016-is-faster-than-ever</ref>

== Terminology ==

Line 36 ⟶ 31:

==External links==

*[https://msdn.microsoft.com/en-us/library/ee633763.aspx Microsoft SQL Server 2016 Master Data Services]

*[https://msdn.microsoft.com/en-us/library/ff929136.aspx What's New in Master Data Services (MDS)]

[[Category:Data management]]