Skip to main content

Datometry Documentation

About qInsight

Datometry qInsight provides a unique and detailed breakdown of all interactions of analytical application with the data warehouse. During analysis, qInsight parses queries to extract and categorize SQL and database features. The insights provided in the report provide a complete picture of effort and risk associated with a replatforming effort.

qInsight provides unique analyses beyond what database logs or standard tools can reveal. Using qInsight, you can successfully plan and execute replatforming initiatives from existing legacy data warehouses to a modern cloud-based system.

About Workload Analysis

Workload analysis is a key factor in data warehouse replatforming, where an enterprise replaces its data warehouse infrastructure and migrates to a new database architecture or a different system that better supports its evolving data analysis needs, has a better cost profile, and potentially other benefits. Organizations are increasingly moving their data warehouse solutions to the cloud to take advantage of the capabilities and cost-efficiency of cloud data warehouses (CDW).

One of the most challenging tasks in data warehouse replatforming is the migration of existing applications from the on-premise data warehouse to the new CDW. The challenge stems from the fact that enterprise applications, data integration, and reporting systems have thousands to millions of queries that implement the business and data transformation logic. Many of these queries are complex and require non-trivial refactoring and sometimes full rewrites to make them work correctly on the new data warehouse. This requires significant resources to test and verify that the translations are correct and perform well before they can be used in production.

Additionally, the queries often use many different proprietary and legacy features of the on-premise database, some of which may not be supported or have different semantics than those of the CDW to which you want to replatform.

Workload Analysis Using qInsight

qInsight data collection, data analysis, and report generation are automated, and do not require any manual effort for standard reports. This greatly improves the scalability of the data warehouse replatforming assessment process, as turnaround time is much faster than with a manual workload assessment process. Additionally, the assessment does not require an in-depth understanding of the your database's workload or other products.

qInsight lets you:

  • Assess the compatibility of your on-premise database's workload with the target cloud data warehouse.

  • Prioritize migration effort and timing for each application.

  • Collect the necessary data for the assessment without outside assistance.

  • Analyze usage of different database features and profile each application.