國立虎尾科技大學 |

PolyBase Revealed = Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	PolyBase Revealed/ by Kevin Feasel.
其他題名:	Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond /
作者:	Feasel, Kevin.
面頁冊數:	XIX, 311 p. 192 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Microsoft and .NET. -
電子資源:	https://doi.org/10.1007/978-1-4842-5461-5
ISBN:	9781484254615

PolyBase Revealed = Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond /
Feasel, Kevin.

PolyBase RevealedData Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond /[electronic resource] :by Kevin Feasel. - 1st ed. 2020. - XIX, 311 p. 192 illus.online resource.

1. Installing and Configuring PolyBase -- 2. Connecting to Azure Blob Storage -- 3. Connecting to Hadoop -- 4. Using Predicate Pushdown to Enhance Query Performance -- 5. Common Hadoop and Blob Storage Integration Errors -- 6. Integrating with SQL Server -- 7. Built-In Integrations: Cosmos DB, Oracle, and More -- 8. Integrating via ODBC -- 9. PolyBase in Azure SQL Data Warehouse -- 10. Examining PolyBase via Dynamic Management Views -- 11. Query Tuning with Statistics and Execution Plans -- 12. PolyBase in Practice.

Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered. PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and more. You will learn how PolyBase can help you reduce storage and other costs by avoiding the need for ETL processes that duplicate data in order to make it accessible from one source. PolyBase makes SQL Server into that one source, and T-SQL is your golden ticket. The book also covers PolyBase scale-out clusters, allowing you to distribute PolyBase queries among several SQL Server instances, thus improving performance. With great flexibility comes great complexity, and this book shows you where to look when queries fail, complete with coverage of internals, troubleshooting techniques, and where to find more information on obscure cross-platform errors. Data virtualization is a key target for Microsoft with SQL Server 2019. This book will help you keep your skills current, remain relevant, and build new business and career opportunities around Microsoft’s product direction. You will: Install and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out cluster Understand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tables Write queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and more Troubleshoot PolyBase queries using SQL Server Dynamic Management Views Tune PolyBase queries using statistics and execution plans Solve common business problems, including "cold storage" of infrequently accessed data and simplifying ETL jobs.

ISBN: 9781484254615

Standard No.: 10.1007/978-1-4842-5461-5doiSubjects--Topical Terms:

1114109
Microsoft and .NET.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

PolyBase Revealed = Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond /
LDR:03750nam a22003975i 4500 001 1019226
003 DE-He213
005 20200703212126.0
007 cr nn 008mamaa
008 210318s2020 xxu| s |||| 0|eng d
020 $a 9781484254615 $9 978-1-4842-5461-5
024 7 $a 10.1007/978-1-4842-5461-5 $2 doi
035 $a 978-1-4842-5461-5
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Feasel, Kevin. $e author. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1314436
245 1 0 $a PolyBase Revealed $h [electronic resource] : $b Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond / $c by Kevin Feasel.
250 $a 1st ed. 2020.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a XIX, 311 p. 192 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 1. Installing and Configuring PolyBase -- 2. Connecting to Azure Blob Storage -- 3. Connecting to Hadoop -- 4. Using Predicate Pushdown to Enhance Query Performance -- 5. Common Hadoop and Blob Storage Integration Errors -- 6. Integrating with SQL Server -- 7. Built-In Integrations: Cosmos DB, Oracle, and More -- 8. Integrating via ODBC -- 9. PolyBase in Azure SQL Data Warehouse -- 10. Examining PolyBase via Dynamic Management Views -- 11. Query Tuning with Statistics and Execution Plans -- 12. PolyBase in Practice.
520 $a Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered. PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and more. You will learn how PolyBase can help you reduce storage and other costs by avoiding the need for ETL processes that duplicate data in order to make it accessible from one source. PolyBase makes SQL Server into that one source, and T-SQL is your golden ticket. The book also covers PolyBase scale-out clusters, allowing you to distribute PolyBase queries among several SQL Server instances, thus improving performance. With great flexibility comes great complexity, and this book shows you where to look when queries fail, complete with coverage of internals, troubleshooting techniques, and where to find more information on obscure cross-platform errors. Data virtualization is a key target for Microsoft with SQL Server 2019. This book will help you keep your skills current, remain relevant, and build new business and career opportunities around Microsoft’s product direction. You will: Install and configure PolyBase as a stand-alone service, or unlock its capabilities with a scale-out cluster Understand how PolyBase interacts with outside data sources while presenting their data as regular SQL Server tables Write queries combining data from SQL Server, Apache Hadoop, Oracle, Cosmos DB, Apache Spark, and more Troubleshoot PolyBase queries using SQL Server Dynamic Management Views Tune PolyBase queries using statistics and execution plans Solve common business problems, including "cold storage" of infrequently accessed data and simplifying ETL jobs.
650 2 4 $a Microsoft and .NET. $3 1114109
650 1 4 $a Database Management. $3 669820
650 0 $a Microsoft .NET Framework. $3 565417
650 0 $a Microsoft software. $3 1253736
650 0 $a Database management. $3 557799
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484254608
776 0 8 $i Printed edition: $z 9781484254622
856 4 0 $u https://doi.org/10.1007/978-1-4842-5461-5
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)