Information Analyzer

What Does Information Analyzer Mean?

Information Analyzer is an IBM product and a tool widely used for data profiling. Information Analyzer helps in understanding data structure, format, relationships and quality monitoring.

Information Analyzer is also referred to as WebSphere Information Analyzer.

Advertisements

Techopedia Explains Information Analyzer

Information Analyzer has extensive data profiling capabilities. It is available with a user interface that includes a set of controls designed for integrating development work flow. The four major data profiling functions within Information Analyzer are:

  • Column Analysis: Generates a full-frequency distribution and examines column values to infer properties and definitions such as statistical measures and domain values.
  • Primary Key Analysis: Identifies candidate keys for one or more tables and aids in testing column combinations or columns to determine whether the candidate is suitable for forming a primary key
  • Foreign Key Analysis: Examines the relationships and contents across tables, thereby identifying foreign key and referential check integrity.
  • Cross-Domain Analysis: Identifies overlap in values between columns and redundancy of data between tables.

Advertisements

Related Terms

Latest Data Management Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…