Business rules are business-centric data expressions that describe the decisions and constructs that define how a business manages information to achieve data quality goals. Business rules are important for:
- continued data management
- data validation
- exceptions handling
- error tracking
For some organizations, business rules assist in demonstrating legal compliance; for others, they help to implement routine business practices and optimize assurances of quality.
Business Rules and Trillium Software
When data is first loaded in the Control Center, certain analyses are run automatically, such as counting the number of data rows, measuring the maximum and minimum row length, and counting the number of duplicated rows. You can use business rules to create and run additional, business- and data-specific tests and tasks against your data at almost any step in the data profiling process, and during many standardizing and transforming processes.
Construct business rules as simple expressions to validate a requirement and filter a List View, or create complex conditional statements to merge and split failing rows and help transform data in a Quality process workflow.
To help manage and organize business rules throughout a data quality process, associate them to a priority and one or more categories. Then use the Business Rules Search Engine to search for business rules using priorities, categories, and other business rule metadata.
There are two types of business rules used to verify and quantify data compliance:
- Entity business rules. Entity business rules (EBRs) are customized rules that you create and apply at the entity level based on ANSI SQL statements, using the functions, attributes and operators provided in Expression Builder windows. Use them with real, dynamic, and library entities. You can customize the scope an EBR by filtering, grouping, and aggregating on the rule results. You can also select the type of index created to help manage failing row drill-down performance.
- Attribute business rules. Attribute business rules (ABRs) are a set of standards applied at the attribute level to test individual attributes. By default, compliance check ABRs are added to all attributes loaded into an entity, and are managed in the Standard library attribute. You can modify the ABR behavior in the Standard attribute to control how these compliance checks are applied to data feeds, and create additional ABRs to satisfy your business requirements.
- More Information
-
Click the links below to find out more about how to use business rules to help assess your data compliance:
Working with all business rules:
- Run a business rule analysis
- Review the results of the analysis
- Edit a business rule
- Delete a business rule
- Using the Expression Builder to create rules
- Associate rules with categories and priorities.
- Search for specific business rules
- Set user security privileges for business rules
Working with Entity Business Rules:
- Create EBRs for an entity
- Apply EBRs before or after data import
- Copy EBRs to another entity
- Using EBR advanced options
You can also add, edit, and view entity business rules using the Discovery Center application. For more information, see Working with the Discovery Center.
Working with Attribute Business Rules:
Working with Library Business Rules: