Fuzzy Data Matching with SQL: Enhancing Data Quality and...

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...
  • سال:
    2023
    ناشر کتب:
    O'Reilly Media
    زبان:
    english
    صفحات:
    282
    ISBN 10:
    1098152271
    ISBN 13:
    9781098152277
    فائل:
    EPUB, 2.07 MB
    IPFS:
    CID , CID Blake2b
    english, 2023
    آن لائن پڑھیں
    میں تبدیلی جاری ہے۔
    میں تبدیلی ناکام ہو گئی۔

    اہم جملے