SQL Server Advanced Data Types: JSON, XML, and Beyond
暫譯: SQL Server 進階資料類型：JSON、XML 與更多

Peter A. Carter

SQL Server Advanced Data Types: JSON, XML, and Beyond
  • 出版商: Apress
  • 出版日期: 2018-08-24
  • 售價: $1,925
  • 貴賓價: 9.5 折 $1,829
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 1484239008
  • ISBN-13: 9781484239001
  • 相關分類: JavaScript、MSSQL、SQL、XML

    • 立即出貨 (庫存=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 高級數據類型》探討了 SQL Server 中提供的每一種複雜數據類型。討論了每種複雜數據類型的常見使用場景，隨後詳細討論如何處理每種數據類型。每一章都揭示了複雜數據的奧秘，您將學會如何最有效地使用這些數據類型。

本書提供了一個實用的指南，幫助讀者處理複雜數據，使用現實世界的例子來演示如何利用每種數據類型。還討論了性能考量，包括實施特殊索引，如 XML 索引和空間索引。

您將學到的內容：
- 理解基本數據類型的實現及為何使用正確的類型如此重要
- 通過 XML 數據類型處理 XML 數據
- 從關聯結果集構建 XML 數據
- 使用 JSON 數據類型存儲和操作 JSON 數據
- 為地理信息系統建模和分析空間數據
- 定義層次結構並通過 HierarchyID 類型高效查詢它們

本書適合對象：
SQL Server 開發人員和需要存儲和訪問複雜數據結構的應用開發人員。

類似商品

最後瀏覽商品 (20)