Wednesday, January 13, 2010

IBM WebSphere Information Analyzer

IBM WebSphere Information Analyzer evaluates the content and structure of your data for consistency and quality.IBM WebSphere Information Analyzer helps you to assess the quality of your data by identifying inconsistencies, redundancies, and anomalies in your data at the column, table, and cross-table levels. IBM WebSphere Information Analyzer also makes inferences about the best choices regarding data structure.Inferences help you to learn more about the optimal structure of your data and what you can do to improve the quality of your data. In addition, IBM WebSphere Information Analyzer provides a mechanism called Baseline Analysis to help you assess whether a data quality procedure that you implemented has resulted in an improvement in data quality by comparing a prior version of analysis results with the current analysis results for a given data source.
The main functions provided by IBM WebSphere Information Analyzer are:
 Column Analysis
 Primary Key Analysis
 Foreign Key Analysis
 Cross Domain Analysis
 Publish Analysis Results
 Baseline Analysis
 Reports



Meta Data/Domain Integrity
•Column Analysis
•Completeness
•Consistency
•Pattern Consistency
•Translation table creation

Structural Integrity
•Table Analysis
•Key Analysis

Entity Integrity
•Duplicate Analysis
•Targeted Data Accuracy

Relational Integrity
•Cross-Table Analysis
•Redundancy Analysis

DQA process. Those steps are as follows:

Prepare the data for assessment
Select the data sources to be investigated and analyzed.
2. Conduct data discovery
The DA and SME perform the investigation and analyses using tools such as
IBM WebSphere Information Analyzer and IBM WebSphere AuditStage. This
discovery involves checking metadata integrity, structural integrity, entity
integrity, relational integrity, and domain integrity.
3. Document data quality issues and decisions
After all information about data quality is known, you can make and
implement the appropriate data alignment and cleansing decisions.




No comments: