Multi-Dimensional Grid Query Intersection Service
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Businesses face challenges in obtaining useful information from vast data sets, as database administrators need to create multiple queries, and custom programming results in fragile products that are not easily adaptable for different information retrieval, requiring costly and time-consuming development.
Innovation Solution
A client sends search criteria representing multiple dimensions to a service, which performs intersection operations to populate a data structure, allowing quick updating of search criteria and outputting a data grid for user interface manipulation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If custom programming is used to obtain information from data, then the information retrieval is tailored to specific needs, but the product becomes fragile and requires costly and time-consuming development for other information
Solution Approach 1:
The patent creates a universal query system that can retrieve different types of information from the same data source without requiring custom programming for each information type. The system uses a standardized interface and data structures that work across multiple query types and dimensions, making the solution adaptable to various information retrieval needs while maintaining precision through structured query parameters
2Adaptability or versatility
If multiple queries are created by database administrators, then different information can be obtained, but the process requires significant time and effort
Solution Approach 1:
The system performs preliminary actions by pre-defining data structures, query templates, and dimension frameworks that are ready for use. Instead of creating queries from scratch each time, the system provides pre-configured structures that can be quickly populated and executed, significantly reducing the time required to access different information while maintaining flexibility
Solution Approach 2:
The patent segments the query process into distinct, reusable components including dimensions, measures, filters, and data structures. This segmentation allows users to assemble different information retrieval requests by combining predefined components rather than creating entire queries from scratch, reducing time effort while maintaining adaptability
3Adaptability or versatility
If extensive re-development is performed to update search criteria, then new information can be retrieved, but the process becomes costly and time-consuming
Solution Approach 1:
The system implements dynamic search criteria that can be modified and updated without requiring extensive re-development. The architecture allows runtime adjustment of query parameters, dimensions, and filters through a standardized interface, enabling flexible adaptation to new information retrieval needs while avoiding costly development cycles
Solution Approach 2:
The patent uses template copying and reuse mechanisms where successful query structures and data models can be replicated and adapted for new information retrieval requirements. Instead of developing new solutions from scratch, existing query templates and data structures serve as reusable copies that can be modified for different purposes, reducing development costs while maintaining flexibility
Data Source
AI summary
Aspects of the subject matter described herein relate to grid queries. In aspects, a client sends search criteria that represent two or more dimensions to a service. The service obtains results that satisfy the search criteria and performs intersection operations to populate a data grid. The data grid is then returned to the client for output on an output device of the client. The client may provide a user interface that allows quick updating of the search criteria to obtain a new data grid.