master-data-services-database.md

title	Master Data Services Database | Microsoft Docs
ms.custom
ms.date	03/01/2017
ms.prod	sql-non-specified
ms.prod_service	mds
ms.service
ms.component	non-specific
ms.reviewer
ms.suite	sql
ms.technology	master-data-services
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	database [Master Data Services], about the database database [Master Data Services]
ms.assetid	5f590cc1-6ec2-4b8c-a598-03de0f6051a0
caps.latest.revision	6
author	leolimsft
ms.author	lle
manager	craigg
ms.workload	Inactive

Master Data Services Database

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]

The database contains all of the information for the [!INCLUDEssMDSshort] system. It is central to a [!INCLUDEssMDSshort] deployment. The [!INCLUDEssMDSshort] database:

• Stores the settings, database objects, and data required by the [!INCLUDEssMDSshort] system.

• Contains staging tables that are used to process data from source systems.

• Provides a schema and database objects to store master data from source systems.

• Supports versioning functionality, including business rule validation and e-mail notifications.

• Provides views for subscribing systems that need to retrieve data from the database.

In This Section

• Leaf Member Staging Table (Master Data Services)

• Consolidated Member Staging Table (Master Data Services)

• Relationship Staging Table (Master Data Services)

• Staging Process Errors (Master Data Services)

See Also

Create a Master Data Services Database
Database Object Security (Master Data Services)
Database Logins, Users, and Roles (Master Data Services)