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.
- Operational data store (ODS)
- Data warehouse detail (DWD)
- Data warehouse summary (DWS)
- Application data service (ADS)
- Dimension (DIM)
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.
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.
For more information about the modeling workspace feature, see Modeling workspace.