How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services

This Blog Post is meant to share how I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services (DQS) – In my mind, Knowledge Base (KB) captures:

1. WHAT needs cleaning

2. HOW to clean what needs cleaning.

Let’s dive a little deeper, In DQS – a Knowledge Base let’s you do three things: Knowledge Discovery, Domain Management & Matching Policy.

1. Knowledge Discovery:

This activity helps you find “WHAT” needs cleaning. DQS has inbuilt algorithms that helps in analyzing errors, inconsistencies and data quality issues in the sample data-set.

2. Domain management:

This activity helps in defining the rules that will be applied to create “HOW” to clean the data.

3. Matching Policy:

This activity helps in identifying “WHAT” needs to be De-Duplicated (De-Dup) and then it goes about helping create the “HOW” to De-DUP the data.

Conclusion:

In this short blog post, I shared how I think of what is Knowledge Base in SQL Server 2012 Data Quality Services. And here’s the official resource if you want to continue learning: DQS Knowledge Bases and Domains

15 thoughts on “How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services

  1. Pingback: How to Delete a Knowledge Base in SQL Server 2012 Data Quality Services? | Paras Doshi – Blog

  2. Pingback: Things I shared on Social Media Networks during Oct 11 – Oct 18 | Paras Doshi – Blog

  3. Pingback: Where’s my SQL Server Master Data Manager Web UI? | Paras Doshi – Blog

  4. Pingback: SQL Server Data Quality Services: How to test Domain Rules in the DQS client. | Paras Doshi – Blog

  5. Pingback: How to Solve: SQL Server 2012 Data Quality Services Does not allow you to export the cleansing or matching results to an Excel file if you are using 64-bit version of Excel | Paras Doshi – Blog

  6. Pingback: Resource: Learn to build an Enterprise Information Management system using Data Quality Services, Master Data Services and SQL Server Integration Services | Paras Doshi – Blog

  7. Pingback: what are the end – to – end processes for developers to build out a Master Data Services 2012 solution? | Paras Doshi – Blog

  8. Pingback: Things I shared on Social Media Networks during Oct 19 – Nov 11 | Paras Doshi – Blog

  9. Pingback: Data Quality Servies: What does a locked Knowledge Base indicate? | Paras Doshi – Blog

  10. Pingback: How to standardize data using Data Quality Services? | Paras Doshi – Blog

  11. Pingback: How to detect unrealistic or invalid values using Data Quality Services? | Paras Doshi – Blog

  12. Pingback: Difference between Term based relations and Domain values in SQL server 2012 Data Quality Services | Paras Doshi – Blog

  13. Pingback: How to clean address records using third-party reference data-sets in Data Quality Services? | Paras Doshi – Blog

  14. Pingback: How to clean records using Regular Expressions in Data Quality Services? | Paras Doshi – Blog

  15. Pingback: SQL Server 2012 Data Quality Services Term based Relation’s in action! | Paras Doshi – Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s