DQS_STAGING_DATA database
E937634
DQS_STAGING_DATA database is a Microsoft SQL Server database used by Data Quality Services to temporarily store and process data during data quality operations such as cleansing and matching.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| DQS_STAGING_DATA | 0 |
Statements (44)
| Predicate | Object |
|---|---|
| instanceOf |
Data Quality Services component
ⓘ
Microsoft SQL Server database ⓘ |
| associatedWith |
DQS_MAIN database
ⓘ
DQS_PROJECTS database ⓘ |
| backupStrategy | backed up as part of DQS system databases ⓘ |
| belongsTo | a single SQL Server instance ⓘ |
| canBeAccessedWith | Transact-SQL NERFINISHED ⓘ |
| configuration | created with default schema by DQS installer ⓘ |
| contains |
tables for staging domain values
ⓘ
tables for storing cleansing results ⓘ tables for storing matching results ⓘ |
| createdBy | SQL Server Data Quality Services installation process ⓘ |
| dependsOn |
DQS_MAIN for knowledge base metadata
ⓘ
DQS_PROJECTS for project metadata ⓘ |
| lifecycle | created and maintained for the lifetime of the DQS installation ⓘ |
| maintenanceConsideration |
can be included in regular SQL Server maintenance plans
ⓘ
may grow during large cleansing or matching operations ⓘ |
| managedBy | SQL Server Database Engine NERFINISHED ⓘ |
| namePattern | DQS_STAGING_DATA ⓘ |
| notIntendedFor |
direct end-user querying in production workloads
ⓘ
long-term data storage ⓘ |
| optimizedFor | staging and processing rather than reporting ⓘ |
| partOf | SQL Server Data Quality Services architecture NERFINISHED ⓘ |
| persists | temporary data only for the duration of DQS operations ⓘ |
| relatedTo |
data quality management
ⓘ
master data management workflows ⓘ |
| requires | DQS server configuration ⓘ |
| runsOn | Microsoft SQL Server NERFINISHED ⓘ |
| scope | server-level DQS installation ⓘ |
| securityModel | SQL Server database security model ⓘ |
| stores |
data imported from external sources for DQS processing
ⓘ
intermediate results of cleansing activities ⓘ intermediate results of matching activities ⓘ staging tables for DQS projects ⓘ |
| supports |
batch data quality processing
ⓘ
interactive DQS project execution ⓘ |
| technology | relational database ⓘ |
| usedBy | SQL Server Data Quality Services NERFINISHED ⓘ |
| usedFor |
data cleansing operations
ⓘ
data matching operations ⓘ data profiling support in DQS workflows ⓘ temporary storage of data during data quality operations ⓘ |
| usedIn | on-premises SQL Server deployments ⓘ |
| vendor | Microsoft NERFINISHED ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.