SQL Server Advanced Data Types: JSON, XML, and Beyond

Peter A. Carter

  • 出版商: Apress
  • 出版日期: 2018-08-24
  • 售價: $1,925
  • 貴賓價: 9.5$1,829
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 1484239008
  • ISBN-13: 9781484239001
  • 相關分類: JavaScriptMSSQLSQLXML
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software.
 
Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. 
 
SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently.
 
The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes.
 
What You'll Learn
  • Understand the implementation of basic data types and why using the correct type is so important
  • Work with XML data through the XML data type
  • Construct XML data from relational result sets
  • Store and manipulate JSON data using the JSON data type
  • Model and analyze spatial data for geographic information systems
  • Define hierarchies and query them efficiently through the HierarchyID type
Who This Book Is For
 
SQL Server developers and application developers who need to store and access complex data structures

商品描述(中文翻譯)

利用 SQL Server 不斷增加的內建現代數據格式支援,以更快速、更便宜的方式提供高級功能。了解 SQL Server 內對於以往需要第三方軟體及相關授權和開發成本的操作和數據轉換的支援不斷增加。通過更好地了解在數據庫引擎內可以做什麼,而無需額外的成本或開發時間投入在外部軟體上,從中受益。

廣泛使用的類型,如 JSON 和 XML,都得到了數據庫引擎的良好支援。同樣適用於層次數據,甚至是時間數據。對這些高級類型的了解對於發揮組織 SQL Server 數據庫投資的全部潛力至關重要。

《SQL Server Advanced Data Types》探索了 SQL Server 內提供的每個複雜數據類型。討論了每個複雜數據類型的常見使用場景,並詳細討論了如何使用每個數據類型。每個章節都對複雜數據進行了解密,並學習如何最有效地使用數據類型。

本書提供了一個實用指南,使用真實世界的例子來演示如何利用每個數據類型。還討論了性能考慮因素,包括實現特殊索引,如 XML 索引和空間索引。

你將學到什麼:
- 了解基本數據類型的實現,以及為什麼使用正確的類型非常重要
- 通過 XML 數據類型處理 XML 數據
- 從關聯結果集構建 XML 數據
- 使用 JSON 數據類型存儲和操作 JSON 數據
- 對地理信息系統進行空間數據建模和分析
- 通過 HierarchyID 類型定義層次結構並高效查詢

本書適合對存儲和訪問複雜數據結構有需求的 SQL Server 開發人員和應用程序開發人員。