Data Quality Services
E56728
Data Quality Services is a SQL Server component that provides tools for defining, managing, and improving the quality and consistency of data through knowledge-based cleansing and matching.
Statements (53)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server component
→
data quality tool → |
| developedBy |
Microsoft
→
|
| documentationUrl |
https://learn.microsoft.com/sql/data-quality-services/data-quality-services
→
|
| goal |
improve data consistency
→
improve data quality → reduce data duplication → standardize data values → |
| hasComponent |
DQS Client
→
DQS Databases → DQS Server → |
| integratesWith |
Excel via DQS client
→
Master Data Services → SQL Server Integration Services → SQL Server Management Studio → on-premises SQL Server databases → |
| introducedInVersion |
SQL Server 2012
→
|
| partOf |
Microsoft SQL Server
→
|
| providesFunctionality |
data cleansing
→
data correction suggestions → data matching → data profiling → data standardization → domain management → duplicate detection → knowledge-based data quality management → reference data management → survivorship rules → |
| requires |
DQS databases installation
→
SQL Server instance → |
| supportsDeployment |
on-premises
→
|
| supportsFeature |
composite domains
→
data-driven knowledge discovery → domain rules → knowledge base creation → knowledge base management → matching policies → reference data services integration → spelling corrections → synonym management → term-based relations → |
| supportsVersion |
SQL Server 2012
→
SQL Server 2014 → SQL Server 2016 → SQL Server 2017 → SQL Server 2019 → SQL Server 2022 → |
| targetUser |
data quality analysts
→
data stewards → database administrators → |
| usesDatabase |
DQS_MAIN
→
DQS_PROJECTS → DQS_STAGING_DATA → |
Referenced by (1)
| Subject (surface form when different) | Predicate |
|---|---|
|
SQL Server
→
|
supportsFeature |