Engineering Record Analytics via Automated View Generation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Customized database tables for engineering records are not recognized by standard analytics applications, requiring manual creation of database views and extensive technical knowledge, making it difficult to generate analytics reports across different systems and processes.
Innovation Solution
A method and system that extract and store engineering record data structures and attributes, combine them with standard data structures, identify attribute classes, and generate views with standardized attribute names, enabling analytics reporting across multiple systems and processes through a data reporting platform.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual creation of database views is used to enable analytics reporting for customized engineering record data, then analytics reporting capability is achieved, but the effort and technical expertise required increases significantly
Solution Approach 1:
The system enables self-service analytics reporting by automatically generating database views from customized engineering record data structures. The analytics application can directly consume the customized data without requiring manual view creation, allowing the system to serve itself and eliminating the need for continuous manual maintenance of database views.
Solution Approach 2:
The patent introduces an intermediary layer that automatically transforms customized engineering record data structures into analytics-ready database views. This intermediary component bridges the gap between customized data structures and analytics applications, handling the complexity of view generation and maintenance automatically rather than requiring manual intervention.
2Ease of operation
If standard analytics applications are used with customized database tables, then analytics reporting is enabled, but the need for in-depth database and SQL knowledge increases
Solution Approach 1:
The system creates automated copies of customized engineering record data in analytics-ready formats. Instead of requiring users to directly query complex customized database tables, the system generates and maintains copy views that replicate the necessary data structures in analytics-friendly formats, eliminating the need for deep SQL knowledge.
Solution Approach 2:
The patent creates a universal interface layer that works with multiple different customized engineering record data structures through a single automated view generation mechanism. This universal approach allows standard analytics applications to access various customized data types without requiring users to learn different SQL queries or database structures for each case.
3Productivity
If automated view generation is implemented, then manual creation effort is reduced, but the system complexity increases
Solution Approach 1:
The patent merges the view generation functionality directly into the existing analytics application infrastructure. By combining the automated view generation logic with the analytics platform's existing data access layers, the system achieves automation without adding significant external complexity. The view generation process is integrated into the workflow that already exists for data access and analytics.
Data Source
AI summary
The embodiments described herein are configured to annotate engineering record (“ER”) data from database tables and their corresponding attributes for analytics tools consumption and to combine the database tables into one consumable entity that can expose a list of attributes to the customer. Attributes may be converted into standardized attributes based on analyzing attribute data types. This data can then be extracted by analytics tools via the common data reporting layer to generate one or more visualizations at a display of at a user's computer system. Such a solution requires far less technical understanding and implementation logic to enable users to focus on analytics rather than view building.