CrossTech DataGrain Analyzer

The main articles are:

• Data mining Data mining
• Data Quality Management

As of December 2024, the DataGrain Analyzer product is no longer provided by Crosstech Solutions Group.

2022: Main functions and tasks to be solved

DataGrain Analyzer is a solution developed by CrossTech Solutions Group. The product is designed to analyze the logical content of databases and tables of various DBMS, identify collisions and inconsistencies in data, field names and types, data storage structure. And to automate reporting on the degree of representativeness and quality of data for management decision-making.

According to information for March 2022, DataGrain Analyzer proposes to solve the following problems:

• Implementation of connectors to various relational and NoSQL DBMS;
• Implementation of analysis logic and logical correspondence: DB-table-field-field content;
• Enrichment of analytics with user reference books and regular expressions;
• Automation of reporting and submission;

Main functions

You can use the DataGrain Analyzer to solve the following queries:

• Statistical analysis by table content, in particular counting the number of fields, their names and type, the number of rows and unique rows in each of the fields;
• View table samples and field values, as well as search for specific values, by applying a filter;
• Semantic and contextual analysis of the content of each of the fields, identification of the semantic domain for each of the fields;
• Creating custom semantic domains by writing regular expressions;
• A wide range of supported data warehouses;
• A huge base of regular expressions and reference books responsible for semantic analysis;
• Support for mechanisms for developing user connectors to DBMS and regular expressions for searching for sensitive data;
• The ability to statically and dynamically mask (obfuscate) data.

What results are provided by DataGrain Analyzer:

• Automation of mechanisms for semantic analysis and content of databases;
• Improving the quality and representativeness of stored data;
• Increase efficiency of business processes using analyzed data;
• Reducing the labor costs of database analysts for manual processing and data analysis;
• Automated reporting.

According to the developers, DataGrain Analyzer replaces the following products:

• Infognito;
• Informatica.