Microsoft SQL Server 2008 R2 Specifications download pdf (Page 163)

Programmability CHAPTER 7 143

■

Microsoft.MasterDataServices.Services Contains a class to provide instances

of the MdsServiceHost class and a class to provide an API for operations related to

business rules

■

Microsoft.MasterDataServices.Services.DataContracts Contains classes to

represent models and model objects

■

Microsoft.MasterDataServices.Services.MessageContracts Contains classes to

represent requests and responses resulting from MDS operations

■

Microsoft.MasterDataServices.Services.ServiceContracts Contains an inter-

face that denes the service contract for MDS operations based on WCF related to

business rules, master data, metadata, and security

NOTE For more information about the MDS class libraries, refer to the “Master Data Ser-

vices Class Library” topic in SQL Server 2008 R2 Books Online at http://msdn.microsoft.com

/en-us/library/ee638492(SQL.105).aspx.

Master Data Services Web Service

MDS includes a Web services API as an option for creating custom applications that integrate

MDS with an organization’s existing applications and processes. This API provides access to

the master data model denitions, as well as to the master data itself. For example, by using

this API, you can completely replace the Master Data Manager Web application.

TIP For a code sample that shows how to use the Web service in a client application,

see the following blog entry by Val Lovicz, Principal Program Manager on the MDS team:

“Getting Started with the Web Services API in SQL Server 2008 R2 Master Data Services,”

at http://sqlblog.com/blogs/mds_team/archive/2010/01/12/getting-started-with-the-web-

services-api-in-sql-server-2008-r2-master-data-services.aspx.

Matching Functions

MDS also provides you with several new Transact-SQL functions that you can use to match

and cleanse data from multiple systems prior to loading it into the staging tables:

■

Mdq.NGrams Outputs a stream of tokens (known as a set of n-grams) in the length

specied by n for use in string comparisons to nd approximate matches between strings

■

Mdq.RegexExtract Finds matches by using a regular expression

■

Mdq.RegexIsMatch Indicates whether the regular expression nds a match by

using a regular expression

1 2 ... 158 159 160 161 162 163 164 165 166 167 168 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 163