Building a Knowledge Base


Updated: August 1, 2012

Applies To: SQL Server 2016

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 DescriptionTopic
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