Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Building a Knowledge Base

Updated: August 1, 2012

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Community Additions

ADD
Show:
© 2015 Microsoft