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.

All labels observed (1)

Label Occurrences
DQS_STAGING_DATA database canonical 2

How this entity was disambiguated

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 ⓘ
linked to: T-SQL
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 ⓘ
linked to: SQL Server
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 ⓘ
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 ⓘ
linked to: SQL Server
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 ⓘ
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 ⓘ

How these facts were elicited

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

DQS_MAIN → associatedWith → DQS_STAGING_DATA database ⓘ
SQL Server Data Quality Services → storesKnowledgeIn → DQS_STAGING_DATA database ⓘ