XML and JSON Recipes for SQL Server: A Problem-Solution Approach

Alex Grinberg

  • 出版商: Apress
  • 出版日期: 2017-12-19
  • 定價: $1,980
  • 售價: 9.0$1,782
  • 語言: 英文
  • 頁數: 289
  • 裝訂: Paperback
  • ISBN: 1484231163
  • ISBN-13: 9781484231166
  • 相關分類: JavaScriptMSSQLSQLXML
  • 立即出貨 (庫存 < 3)

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

商品描述

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved!
 
This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle.
 
Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. 
 
XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you’ll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications.
 
What You Will Learn
  • Build XML and JSON objects in support of automation and data transfer
  • Import and parse XML and JSON from operating system files
  • Build appropriate indexes on XML objects to improve query performance
  • Move data from query result sets into JSON format, and back again
  • Automate the detection of database performance problems by querying and parsing the database’s own execution plans
  • Replace external and manual JSON processes with SQL Server's internal, JSON functionality
Who This Book Is For
 
Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications. 

商品描述(中文翻譯)

快速找到解決使用內建於SQL Server的XML和JSON功能時遇到的數十個常見問題的解決方案。內容以受歡迎的問題解決格式呈現。查找您想解決的問題。閱讀解決方案。直接在您自己的代碼中應用解決方案。問題解決!

本書展示了如何利用XML和JSON共享數據並自動化任務。JSON通常用於在數據庫和前端應用程序之間來回傳遞數據,通常在瀏覽器中運行。本書展示了將查詢結果轉換為JSON格式以及再轉換回來的所有必要知識。還介紹了將數據轉換為XML格式的過程和技術,用於商業智能和其他目的,例如將數據從報表系統轉移到數據倉庫,或在SQL Server和Oracle之間轉移數據等。

Microsoft在SQL Server中廣泛實施了XML,以及許多相關產品。執行計劃以XML格式生成,本書將向您展示如何解析這些計劃並自動檢測性能問題。相對較新的擴展事件功能將跟踪數據寫入XML文件,本書中的示例將幫助您解析這些文件。

XML還在SQL Server的BI工具集中使用,包括在SSIS、SSR和SSAS中。XML在許多配置文件中使用,甚至在DDL觸發器的構建中也使用。閱讀本書,您將深入研究允許您構建和解析XML以及JSON的功能,JSON是XML的特定格式,用於在數據庫和其前端應用程序之間以網頁友好的格式傳輸對象。

您將學到什麼:
- 構建XML和JSON對象以支持自動化和數據傳輸
- 從操作系統文件中導入和解析XML和JSON
- 在XML對象上建立適當的索引以提高查詢性能
- 將查詢結果集中的數據轉換為JSON格式,並再轉換回來
- 通過查詢和解析數據庫自身的執行計劃自動檢測數據庫性能問題
- 使用SQL Server內部的JSON功能替換外部和手動的JSON處理過程

本書適合對在SQL Server數據庫環境中使用XML和JSON進行深入和詳細技能培養的數據庫管理員、.NET開發人員、商業智能開發人員和其他專業人士。網頁開發人員將特別發現本書對將數據庫結果集轉換為可傳輸到前端網頁應用程序的JSON文本的覆蓋範圍非常有用。