Auto-Query Construction for In-Database Predictive Analytics
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing information handling systems face challenges in performing complex in-database predictive analytics due to the need for specific software development for each database platform, making it difficult to construct queries and requiring advanced skills, especially when dealing with large data volumes and distributed computations.
Innovation Solution
An auto-query construction system that generates dynamic SQL instructions through a user-friendly interface, allowing users to select decision variables and parameters, which are then transformed into database statements, enabling in-database predictive modeling without requiring database knowledge and supporting various database platforms.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If specific software is developed for each database platform to perform complex in-database computations, then the computations can be performed efficiently in-database, but the system complexity increases and portability across different database platforms is lost
Solution Approach 1:
The patent implements a universal query construction system that can generate database statements for multiple different database platforms (SQL Server, Teradata, Oracle, Hadoop) using a single interface. The system translates user-friendly query specifications into platform-specific SQL or distributed query statements, eliminating the need to develop separate software for each database platform while maintaining computation efficiency.
2Productivity
If specific code is developed for Hadoop distributed storage framework, then distributed in-database computations can be performed, but the code cannot be easily applied to other database platforms
Solution Approach 1:
The patent introduces an intermediary query construction system that acts as a mediator between the user and different database platforms. The system translates high-level query specifications into platform-specific distributed query statements, enabling the same user interface to generate code for Hadoop, SQL Server, Teradata, and other platforms without requiring separate development efforts for each platform.
3Manufacturing precision
If manual SQL code construction is required for in-database predictive analytics, then precise database operations can be achieved, but the ease of operation decreases and advanced skills are required
Solution Approach 1:
The patent implements a self-service query construction interface where users can specify predictive analytics operations using familiar database terminology without needing to write actual SQL code. The system automatically generates the precise SQL or distributed query statements needed, allowing users to achieve accurate database operations while maintaining ease of operation through a user-friendly interface.
Data Source
AI summary
A system, method, and computer-readable medium for performing an auto-query construction operation for use with a distributed analytics operation. More specifically, in certain embodiments, the auto-query construction operation provides automatically generates SQL code instructions via an auto-query construction user interface (UI) settings in a computational system, such as the Dell Statistica computational system. The auto-query construction operation allows a user to interact with a common interface to provide query information including decision variables, parameters of an analysis and convergence criteria. The query information provided via the UI is automatically transformed to database queries and subsequent computation system operations. Thus, the user experience remains intact whether the analytics is performed in database or within the computation system.