AssertDBi - Database Integrity Tools for the iSeries

Our flagship product is AssertDBi, world class software that tightly integrates documention and validation of business rules known as assertions. Assertions precisely define relationships between tables (files) at the row and column level.

Assertions have the following attributes

• Quickly created - Create one rule or many rules in mass. Standard assertions can be expressed in 5 or 6 words as these examples illustrate.
  
  

  *FILE	ORDHDR	Refers to	*FILE	CUSMAS	Select OrderHeader rows where the customer number does not exist in CustomerMaster file.
  *FILE	ORDHDR	Expects 1+	*FILE	ORDITM	Select OrderHeader rows where the order number does not exist in OrderItem file.
  *FILE	ORDITM	Owned by	*FILE	ORDHDR	Select OrderItem rows where the order number does not exist in OrderHeader file.

  
  
• Easily tested - Press a key and see the results
• Execute in SELECT, SUMMARY or SAMPLE mode
• Execute in *TRUE, *FALSE, *INCLUDED or *EXCLUDED mode
• *TRUE - List or summarize rows where assertion is true
• *FALSE - List or summarize rows where assertion is false
• *INCLUDED - List or summarize rows that are included in the rule
• *EXCLUDED - List or summarize rows that are excluded from the rule
• Output options
• Immediate ad hoc requests are displayed to screen
• Stores non compliant rows by assertion ID in specified data library
• Summary results of each executed assertion is logged
• Newly added violations are tracked as well as age of violation
• Metrics - Percent of assertion rows that are true, false, included or excluded
• Aggregate metrics at the indivual rule, groups of rules, all rules for database.
• Result is an overall data health index (such as 97.8847%) measured on a daily basis and tracked over time.