- Main
- Computers - Databases
- Fuzzy Data Matching with SQL: Enhancing...
Fuzzy Data Matching with SQL: Enhancing Data Quality and Query Performance
Jim Lehmer你有多喜欢这本书?
下载文件的质量如何?
下载该书,以评价其质量
下载文件的质量如何?
If you were handed two different but related sets of data, what tools would you use to find the matches? What if all you had was SQL SELECT access to a database? In this practical book, author Jim Lehmer provides best practices, techniques, and tricks to help you import, clean, match, score, and think about heterogeneous data using SQL.
DBAs, programmers, business analysts, and data scientists will learn how to identify and remove duplicates, parse strings, extract data from XML and JSON, generate SQL using SQL, regularize data and prepare datasets, and apply data quality and ETL approaches for finding the similarities and differences between various expressions of the same data.
Full of real-world techniques, the examples in the book contain working code. You'll learn how to:
• Identity and remove duplicates in two different datasets using SQL
• Regularize data and achieve data quality using SQL
• Extract data from XML and JSON
• Generate SQL using SQL to increase your productivity
• Prepare datasets for import, merging, and better analysis using SQL
• Report results using SQL
• Apply data quality and ETL approaches to finding similarities and differences between various expressions of the same data
DBAs, programmers, business analysts, and data scientists will learn how to identify and remove duplicates, parse strings, extract data from XML and JSON, generate SQL using SQL, regularize data and prepare datasets, and apply data quality and ETL approaches for finding the similarities and differences between various expressions of the same data.
Full of real-world techniques, the examples in the book contain working code. You'll learn how to:
• Identity and remove duplicates in two different datasets using SQL
• Regularize data and achieve data quality using SQL
• Extract data from XML and JSON
• Generate SQL using SQL to increase your productivity
• Prepare datasets for import, merging, and better analysis using SQL
• Report results using SQL
• Apply data quality and ETL approaches to finding similarities and differences between various expressions of the same data
年:
2023
出版:
1
出版社:
O'Reilly Media
语言:
english
页:
285
ISBN 10:
1098152271
ISBN 13:
9781098152277
文件:
PDF, 1.85 MB
您的标签:
IPFS:
CID , CID Blake2b
english, 2023
在1-5分钟内,文件将被发送到您的电子邮件。
该文件将通过电报信使发送给您。 您最多可能需要 1-5 分钟才能收到它。
注意:确保您已将您的帐户链接到 Z-Library Telegram 机器人。
该文件将发送到您的 Kindle 帐户。 您最多可能需要 1-5 分钟才能收到它。
请注意:您需要验证要发送到Kindle的每本书。检查您的邮箱中是否有来自亚马逊Kindle的验证电子邮件。
正在转换
转换为 失败