CrossTech DataGrain Analyzer

Main articles:

• Data mining Intelligent data analysis
• Data Quality Management

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

2022: Key Functions and Objectives

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;
• Enriching analytics with user guides and regular expressions;
• Automate reporting and reporting;

Basic functions

DataGrain Analyzer can be used 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 field;
• View table samples and field values, and find specific values by overlaying a filter;
• Semantic and contextual analysis of the content of each of the fields, identification of the semantic domain for each of the fields;
• Create 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 the development of custom DBMS connectors and regular expressions for sensitive data retrieval;
• Possibility of static and dynamic masking (obfuscation). data

What are the results of DataGrain Analyzer:

• Automation of mechanisms for semantic analysis and content of databases;
• Improving the quality and representativeness of stored data;
• Improve the efficiency of business processes using analyzed data;
• Reduction of work costs of DB analysts for manual processing and analysis of data;
• Automated reporting.

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

• Infognito;
• Informatica.