模型 (Master Data Services)Models (Master Data Services)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

模型是 Master Data ServicesMaster Data Services中最高级别的数据组织。Models are the highest level of data organization in Master Data ServicesMaster Data Services. 模型定义了您的主数据管理解决方案中的数据结构。A model defines the structure of data in your master data management solution. 模型包含以下对象:A model contains the following objects:

  • 实体Entities

  • 属性和属性组Attributes and attribute groups

  • 显式层次结构和派生层次结构Explicit and derived hierarchies

  • 集合Collections

模型组织您的主数据的结构。Models organize the structure of your master data. 你的 Master Data ServicesMaster Data Services 实现可能有一个或多个模型,每个模型都会将相似类型的数据组合在一起。Your Master Data ServicesMaster Data Services implementation can have one or many models that each group similar kinds of data. 通常,可通过以下四种方式之一划分主数据:人员、地点、事件或概念。In general, master data can be categorized in one of four ways: people, places, things, or concepts. 例如,可以创建 Product 模型来包含与产品有关的数据,或创建 Customer 模型来包含与客户有关的数据。For example, you can create a Product model to contain product-related data or a Customer model to contain customer-related data.

可以分配用户和组权限来查看和更新模型中的对象。You can assign users and groups permission to view and update objects within the model. 如果您不授予对模型的权限,则它不显示。If you do not give permission to the model, it is not displayed.

您随时都可以创建模型中主数据的副本。At any given time, you can create copies of the master data within a model. 这些副本称为版本。These copies are called versions.

在测试环境中定义一个模型后,可以带或不带相应数据将它从测试环境部署到生产环境。When you have defined a model in a test environment, you can deploy it, with or without the corresponding data, from the test environment to a production environment. 这样就不必在生产环境中重新创建您的模型。This eliminates the need to recreate your models in your production environment.

模型如何与其他对象关联How Models Relate to Other Objects

模型包含实体。A model contains entities. 实体包含属性、显式层次结构和集合。Entities contain attributes, explicit hierarchies, and collections. 属性可以包含在属性组中。Attributes can be contained in attribute groups. 在某一实体用作其他实体的属性时,存在基于域的属性。Domain-based attributes exist when an entity is used as an attribute for another entity.

下图显示模型中对象之间的关系。This image shows the relationships among the objects in a model.

Master Data Services 模型中的对象Objects in a Master Data Services Model

备注

派生层次结构也是模型对象,但它们不显示在图像中。Derived hierarchies are also model objects, but they are not shown in the image. 派生层次结构从在实体之间存在的基于域的属性关系中派生。Derived hierarchies are derived from the domain-based attribute relationships that exist between entities. 有关详细信息,请参阅派生层次结构 (Master Data Services)See Derived Hierarchies (Master Data Services) for more information.

主数据是在模型对象中包含的数据。Master data is the data that is contained in the model objects. Master Data ServicesMaster Data Services中,主数据作为实体中的成员存储。In Master Data ServicesMaster Data Services, master data is stored as members in an entity.

模型对象在 用户界面的 “系统管理” 主数据管理器Master Data Manager 功能区域中维护。Model objects are maintained in the System Administration functional area of the 主数据管理器Master Data Manager user interface.

模型示例Model Example

在下面的示例中,Product 模型中的对象以逻辑方式对与产品相关的数据进行分组。In the following example, the objects in the Product model logically group product-related data.

产品模型主数据示例Product Model Master Data Example

其他常见的模型有:Other common models are:

  • 科目,它可能包含资产负债表科目、损益表科目、统计信息和科目类型等实体。Accounts, which could include entities such as balance sheet accounts, income statement accounts, statistics, and account type.

  • 客户,它可能包含性别、教育、职业和婚姻状况等实体。Customer, which could include entities such as gender, education, occupation, and marital status.

  • 地理信息,它可能包含邮政编码、城市、县、州、省、区域、国家/地区和洲等实体。Geography, which could include entities such as postal codes, cities, counties, states, provinces, regions, territories, countries, and continents.

任务说明Task Description 主题Topic
创建模型来组织您的主数据。Create a model to organize your master data. 创建模型 (Master Data Services)Create a Model (Master Data Services)
更改现有模型的名称。Change the name of an existing model. 编辑模型 (Master Data Services)Edit Model (Master Data Services)
删除现有模型。Delete an existing model. 删除模型 (Master Data Services)Delete a Model (Master Data Services)