管理域Managing a Domain

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

本主题介绍如何在 “数据库引擎服务”Data Quality Services (DQS) 中使用域。This topic describes the use of domains in “数据库引擎服务”Data Quality Services (DQS). 域包含要分析的数据源的特定字段中数据的语义表示。A domain contains a semantic representation of the data in a specific field in the data source that is to be analyzed. 域是您为数据源创建的知识库的一部分,并且,通过分析样本数据源或导入数据而逐步建立的知识将添加到在该知识库中定义的域。A domain is part of the knowledge base that you create for a data source, and the knowledge that you build up by analyzing a sample data source, or importing data, is added to the domains defined in the knowledge base. 这些域中的知识随后用于在数据质量项目中执行清除和匹配。The knowledge in those domains is later used to perform cleansing and matching in a data quality project. 域是 Data Quality Services 中所有活动的核心。Domains are at the core of all activities in Data Quality Services.

域映射到数据源字段,并在知识发现、域管理和匹配活动中进行填充。A domain is mapped to a data source field, and is populated in the knowledge discovery, domain management, and matching activities. 如何从数据源加载数据以及如何在报表中输出数据是在域属性中定义的。How you load data from the data source and output data in a report is defined in domain properties. 当您使用引用数据提供程序清理数据时,您会将引用数据服务附加到单一域或复合域。When you use a reference data provider to cleanse data, you attach a reference data service to a single or composite domain. 创建要应用于域中数据的规则,并且可以为域创建基于字词的关系。You create rules to be applied to your data in a domain, and you can create term-based relations for a domain. 您可以查看并更正域中的数据。You can view and correct data in the domain.

还可以创建复合域,该域包含两个或更多单一域,而每个单一域包含有关共用数据的知识。You can also create a composite domain that is comprised of two or more individual domains that each contains knowledge about common data. 有关详细信息,请参阅管理复合域For more information, see Managing a Composite Domain.

域属性Domain Properties

当您创建域时,您具有以下有关如何从源数据填充域以及如何输出域值的选项。When you create a domain, you have the following options for how to populate the domain from the source data and how to output the domain values. 有关详细信息,请参阅设置域属性For more information, see Set Domain Properties.

  • 选择您用来填充域的数据的类型。Select the type of the data that you populate the domain with. 有关每个域数据类型的支持的数据类型的信息,请参阅 DQS 域支持的 SQL Server 和 SSIS 数据类型For information about data types supported for each domain data type, see Supported SQL Server and SSIS Data Types for DQS Domains.

  • 指定仅从域中输出前导值,而不输出它们的同义词。Specify that only leading values, not their synonyms, will be output from the domain.

  • 指定使用特定的格式输出域值,具体取决于数据类型。Specify that domain values be output in a certain format, depending on the data type.

  • 如果数据类型为字符串,则可以通过在将该字符串从数据源加载到域时删除特殊字符来规范化该字符串。If the data type is a string, you can normalize the string by removing special characters when the string is loaded from the data source into the domain.

  • 如果数据类型为字符串,您可以运行 DQS 拼写检查器检查字符串值的语法、拼写和句子结构,并在 “域管理”“域值” 页中指示可能存在的错误。If the data type is a string, you can run the DQS Speller to check the syntax, spelling, and sentence structure of the string, and indicate any potential errors in the Domain Values page of Domain Management. 这包括指定运行拼写检查器的语言。This includes specifying the language that the Speller will run in.

  • 如果数据类型是字符串,当您知道字符串中不会出现语法错误时,您可以指定 DQS 不标识语法错误。If the data type is a string, you can specify that DQS not identify syntax errors when you know that syntax errors will not occur in strings.

本节内容In This Section

通过使用域,您可以执行以下操作:Using a domain enables you to do the following:

操作说明Operation Description 主题Topic
为具有特定数据类型的数据字段创建语义表示,指定如何填充域以及如何设置域的输出格式Create a semantic representation for a data field with a specific data type, specify how the domain is populated, and format the output of the domain 创建域Create a Domain
将某个域链接到另一个域,使其能够共享相同的设置和值Link a domain to another domain, enabling it to share the same settings and values 创建链接域Create a Linked Domain
将引用数据服务附加到单一域或复合域Attach a reference data service to a single or composite domain 将域或复合域附加到引用数据Attach Domain or Composite Domain to Reference Data
更改或增加知识库中的值Change or augment the values in a knowledge base 更改域值Change Domain Values
使用验证和标准化规则Use validation and standardization rules 创建域规则Create a Domain Rule
使用关系更正作为域中值的一部分的字词Use relations to correct a term that is part of a value in a domain 创建基于字词的关系Create Term-Based Relations
完成、关闭或取消域管理活动Complete, close, or cancel the domain management activity 结束域管理活动End the Domain Management Activity
任务说明Task Description 主题Topic
通过运行知识发现并以交互方式管理知识来生成知识库Building a knowledge base by running knowledge discovery and interactively managing knowledge 生成知识库Building a Knowledge Base
将知识导入知识库,或从知识库中导出知识。Importing knowledge into, or exporting it from, a knowledge base. 导入和导出知识Importing and Exporting Knowledge
创建一个复合域,并将知识添加到该域中。Creating a composite domain, and adding knowledge to the domain. 管理复合域Managing a Composite Domain