Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Building a Knowledge Base

SQL Server 2012

A knowledge base in Data Quality Services (DQS) is a repository of knowledge about your data that enables you to understand your data and maintain its integrity. A knowledge base consists of domains, each of which represents the data in a data field. The knowledge base is used by DQS to perform data cleansing and deduplication on a database. To prepare the knowledge base for data cleansing, you can run a computer-assisted analysis of a data sample, and interactively manage values in the domains. DQS enables you to import knowledge, create rules and relationships, change data values directly, and leverage a default database.

You can perform the following operations on a knowledge base:

Create a new knowledge base from scratch, from an existing knowledge base, or from a .dqs data file.

Create a Knowledge Base

Open an existing knowledge base to perform knowledge discovery, domain management, or add a matching policy.

Open a Knowledge Base

Perform management actions on a knowledge base, including opening it, unlocking it, discarding your work on it, renaming it, deleting it, or viewing its properties.

Manage a Knowledge Base

Add knowledge to a knowledge base through knowledge discovery; domain value management; adding a matching policy; importing a knowledge, domain, or values; or using the default knowledge base, DQS Data.

Adding Knowledge to a Knowledge Base

Analyze a data sample for data quality criteria.

Perform Knowledge Discovery

Task Description

Topic

Importing knowledge into, or exporting it from, a knowledge base.

Importing and Exporting Knowledge

Creating a single domain, and adding knowledge to the domain.

Managing a Domain

Creating a composite domain, and adding knowledge to the domain.

Managing a Composite Domain

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.