master-data-services-database.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Master Data Services Database	The Master Data Services database contains all of the information for the Master Data Services system and is central to a Master Data Services deployment.	CordeliaGrey	jiwang6	03/01/2017	sql	master-data-services	conceptual	database [Master Data Services], about the database database [Master Data Services]

Master Data Services Database

[!INCLUDE SQL Server - Windows only ASDBMI]

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)