| title | Building a Knowledge Base | |
|---|---|---|
| description | Building a Knowledge Base | |
| author | chugugrace | |
| ms.author | chugu | |
| ms.date | 07/31/2012 | |
| ms.service | sql | |
| ms.subservice | data-quality-services | |
| ms.topic | concept-article | |
| ms.custom |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
A knowledge base in [!INCLUDEssDQSnoversion] (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:
| Operation Description | Topic |
|---|---|
| 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 |