Microsoft SQL Server 2012 Master Data Services, 2/e (Paperback)

Tyler Graham

  • 出版商: McGraw-Hill Education
  • 出版日期: 2012-10-30
  • 定價: $1,750
  • 售價: 5.0$875
  • 語言: 英文
  • 頁數: 416
  • 裝訂: Paperback
  • ISBN: 0071797858
  • ISBN-13: 9780071797856
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存 < 4)



Deploy and Maintain an Integrated MDS Architecture

Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012 Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide.

  • Install Microsoft SQL Server 2012 Master Data Services
  • Build custom MDS models and entityspecific staging tables
  • Load and cleanse data from disparate sources
  • Logically group assets into collections and hierarchies
  • Ensure integrity using versioning and business rules
  • Configure security at functional, object, and attribute levels
  • Extend functionality with SOA and Web services
  • Facilitate collaboration using the MDS Excel Add-In
  • Export data to subscribing systems through SQL views


部署和維護整合的 MDS 架構

利用主資料來增加收入並降低行政成本。經過全面修訂以涵蓋最新的 MDS 功能,《Microsoft SQL Server 2012 Master Data Services》第二版展示了如何實施和管理一個以客戶為中心的集中式 MDS 框架。了解如何準確建模業務流程、加載和清理數據、執行業務規則、消除冗余並將數據發布到外部系統。本實用指南還涵蓋了安全性、SOA 和 Web 服務以及舊有數據集成。

  • 安裝 Microsoft SQL Server 2012 Master Data Services

  • 構建自定義的 MDS 模型和實體特定的分段表

  • 從不同來源加載和清理數據

  • 將資產邏輯地分組為集合和層次結構

  • 使用版本控制和業務規則確保數據完整性

  • 在功能、對象和屬性級別配置安全性

  • 通過 SOA 和 Web 服務擴展功能

  • 使用 MDS Excel Add-In 促進協作

  • 通過 SQL 視圖將數據導出到訂閱系統