DataWorks Data Modeling allows you to plan and formulate data standards before data modeling, or summarize data standards based on the business conditions during data modeling. You can accumulate the data standards based on your business requirements during data modeling. Constraints are imposed on lookup tables, measurement units, field standards, and naming dictionaries to ensure the consistency of data processing in data modeling and application. This way, data can be produced in a standardized manner and data application and processing costs are reduced.
Scenarios
For example, a registration table and a logon table are created. The registration table contains a member ID column that is specified by the user_id field. The logon table also contains a member ID column that is specified by the userid field. You can create a unified field standard for the member ID columns. For example, you can specify a lookup table for data processing, the attribute requirements for each field (such as the data type, length, and default value of each field), and the measurement unit of data. The field standard can be directly applied to the member ID fields during data modeling. The field standard ensures that all the member ID fields observe the same standard.
For more information about how to create a field standard, see Field standard.