Profiler Object:Introduction
| Profiler Object Navigation |
|---|
| Introduction |
| Licensing |
| Order of Operations |
Melissa Data’s Profiler Object can be used to analyze a table’s data. This analysis provides numerous statistics at varying levels of detail. Using these statistics, you can make educated decisions on your data handling strategies.
The Profiler Object was designed with three profiling modes in mind: Discovery, Monitoring, and Incremental Monitoring.
Discovery
Discovery is the analysis of new data before it is inserted into a Data Warehouse. This analysis is used to ensure that the data is correctly fielded, consistently formatted, standardized, etc. Because it can be very difficult to fix problems once data has been merged into a Data Warehouse, it is critical that issues are detected and eradicated prior to the merge.
Monitoring
Monitoring is the continual analysis of warehoused data in an effort to ensure a consistent quality of data. In systems where records are actively inserted, updated, and deleted, it is nearly impossible to maintain a comprehensive set of business rules that foresee every situation. In addition, in systems that support multiple methods of access (ie, web, desktop, tablet/phone), it can be difficult to ensure that all program code adequately enforces all business rules.
Incremental Monitoring
Incremental Monitoring is the analysis of a record's data before it is inserted into a database. This analysis uses a Result Code system to report record anomalies and inconsistencies to a calling program so that corrective action can be performed before the record is inserted.