.JPG)
.heic){kind=link}
Fuzzy data matching with SQL : enhancing data quality and query performance /
Lehmer, Jim,
Fuzzy data matching with SQL : enhancing data quality and query performance / Jim Lehmer. - First edition. - xxv, 254 pages : illustrations ; 24 cm
Includes bibliographical references and index.
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.
1098152271 9781098152277
2024441102
Data sets.
Data editing.
Statistical matching.
SQL (Computer program language)
Jeux de données.
Édition (Informatique)
Appariement (Statistique)
SQL (Langage de programmation)
QA76.73.S67 / L44 2023
005
Fuzzy data matching with SQL : enhancing data quality and query performance / Jim Lehmer. - First edition. - xxv, 254 pages : illustrations ; 24 cm
Includes bibliographical references and index.
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.
1098152271 9781098152277
2024441102
Data sets.
Data editing.
Statistical matching.
SQL (Computer program language)
Jeux de données.
Édition (Informatique)
Appariement (Statistique)
SQL (Langage de programmation)
QA76.73.S67 / L44 2023
005