About Business Rules - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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.
Note: EBRs and ABRs can be stored as library objects in the Business Rules Library. To use a business rule in a Quality process, the rule must first be promoted to the Library.