Data warehouse architects or model team members can design data layers, business categories, data domains, and business processes on the Data Warehouse Planning page during data modeling in DataWorks. After the design is complete, model designers can create and manage models based on the data layers, business categories, data domains, and business processes.

Date layer

You can design data layers in a data warehouse based on business scenarios, data scenarios, and system scenarios. By default, DataWorks creates the following common layers for you:
  • Operational data store (ODS)
  • Data warehouse detail (DWD)
  • Data warehouse summary (DWS)
  • Application data service (ADS)
  • Dimension (DIM)
You can create data layers based on your business requirements. For more information about how to create a data layer, see Create a data layer.
The following figure shows the default data layers that are provided by DataWorks. After data layers are designed, you can store your data tables at different data layers. Data layers

Business category

If your business is complex and different business categories need to share the same data domain, you can categorize the business to suit your business requirements. This helps you quickly locate data of a specific business during model design and application. For more information about how to create a business category, see Business category.

Data domain and business process

  • Data domain

    A data domain is a high-level data classification standard. It is a collection of business processes that are abstracted, refined, and combined. A data domain is the first data grouping entry for business personnel. It helps business personnel quickly locate the desired business data from large amounts of data.

  • Business process

    A business process is used to describe the process of a business activity, such as add commodities to the shopping cart, place an order, or pay for the order. Business processes have typical application during business effect analysis, such as funnel analysis of commodity purchases. You can break down a commodity purchase into the following business processes: browse commodities, add commodities to the shopping cart, place an order, pay for the order, and confirm the receipt of the commodity. Use the number of orders as a metric for each business process and perform funnel analysis on the metric. For more information about how to create a business process in DataWorks, see Business process.

Modeling workspace

If your data system involves multiple workspaces and you want to use the same data warehouse plan for these workspaces, you can use the modeling workspace feature. This feature allows you to plan data warehouses, perform dimensional modeling, and define metrics for the workspaces in a unified manner.

DataWorks Data Modeling provides the following types of workspaces when you use the modeling workspace feature: model design workspace and data development workspace.

Modeling workspace

For more information about the modeling workspace feature, see Modeling workspace.