SQL Server 2008 R2 - 主数据服务

在构建数据仓库时，我们必须通过“数据发现”阶段，其中商业智能解决方案的要求映射到实际操作系统，以便我们可以将变换和加载（ETL）提取到数据仓库中。这是一项重大努力，特别是如果您有多个申请团体来竞争。并非所有系统都使用适当和友好的命名约定！通常，我们最终与所有交叉参考信息一起使用大型电子表格，我们继续设计DW并构建逐步填充它所需的ETL流程。好吧，现在有更好的方法 - 主数据服务。Microsoft SQL Server 2008 R2的许多有趣功能之一是主数据服务（或MDS）。此增强功能允许组织创建“主数据集线器”，该组织为企业的众多数据实体和层次结构提供“单一的真相源”。典型的媒体到大型公司具有许多不同的系统，其中一些来自合并或收购，每个都使用自己的数据源。这些数据源可以使用集线器和辐射架构对齐，以将数据实体交叉引用到可用于审计，更改跟踪和整合的中央数据库中。它甚至可以帮助您构建您一直在考虑的数据仓库。 Discovering the data specifications can be time-consuming but when stored centrally and maintained with version control and change tracking, the business can benefit from this understanding of it mission critical data. When building a Data Warehouse, much of this data discovery needs to be performed but instead of recording this information in an isolated spreadsheet, now the information can be recorded in a centralized database for all to access and contribute to. Through Web Applications, individual application groups can be held accountable for “their” data specifications through ownership, allowing all parts of the organization to contribute to the centralized “Master Data”. Ongoing Data Warehouse and Business Intelligence efforts can then benefit with the Master Data being readily available and up-to-date. Master Data Services consists of the following components: • Master Data Services Configuration Manager – used to setup the MDS Database and configure the Web application • Master Data Manager – ASP.NET application used to manage your master data • Master Data Services Web Service – used by developers to extend and customize the functionality of Master Data Services Note that Master Data Services (MDS) is available on only the 64-bit editions of SQL Server 2008 R2 Datacenter, Enterprise and Developer. It is not supported on the 32-bit platform. It requires the .NET Framework 3.5 SP1 or later. For running the Web Applications, IIS is required with ASP.NET and Windows Authentication enabled. If you run into problems with the 64-Bit install of SQL Server see my blog entry: //m.amiribrahem.com/community/node/69817 Here is a good MSDN Blog on installing MDS: http://sqlblog.com/blogs/mds_team/archive/2009/12/10/installing-and-configuring-master-data-services-2008-r2-november-ctp.aspx Good luck! Brian