Creating a basic analysis on a database column
About this task
You can build your analysis from scratch, analyze the content of one or multiple columns and execute the created analyses using the Java or the SQL engine. This type of analysis provides statistics about the values within each column.
When you use the Java engine to run a column analysis, you can view the analyzed data according to parameters you set yourself.
For more information, see Using the Java or the SQL engine.
You can also analyze a set of columns. This type of analysis provides statistics on the values across all the data set (full records).
For more information, see Analyzing tables in databases.
The sequence of creating a basic column analysis involves the following steps:
Procedure
- Defining the columns to be analyzed.
- Setting predefined system indicators or indicators defined by the user for the column(s).
- Adding the patterns against which to define the content, structure and quality of the data.