Geospatial Query Visualization System for Non-Technical Data Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems lack an efficient method for non-technical users to generate complex database queries for accessing and filtering data across multiple databases, particularly within geographic boundaries, leading to difficulties in visualizing data for business or personal decisions.
Innovation Solution
A query visualization system that includes a client workstation, a geospatial database, and an export service application, allowing users to input parameters and geographic boundaries, which are then converted into compatible query parameters to execute database queries and generate visualizations of queried data within the specified boundaries.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a carrier company arbitrarily positions retail stores throughout various locations without considering radio coverage, then store placement flexibility is improved, but customer traffic and profitability deteriorate
Solution Approach 1:
The system performs preliminary analysis of radio coverage data before retail store placement decisions are made. By pre-processing and storing geospatial radio coverage information in a queryable format, the system enables decision-makers to assess coverage conditions at potential store locations in advance, preventing placement in areas with poor coverage and thereby ensuring better customer traffic and profitability from the outset
Solution Approach 2:
The patent introduces an intermediary system that bridges retail store placement decisions and radio coverage data. This intermediary consists of a geospatial database storing pre-processed coverage information and a query tool that translates business questions into database queries, enabling non-technical users to easily access and analyze coverage data for informed location decisions
2Adaptability or versatility
If complex database queries are required to access and filter data across multiple databases, then data access capability is improved, but ease of operation deteriorates
Solution Approach 1:
The patent introduces an intermediary query tool that acts as a mediator between non-technical users and the complex geospatial database. The tool provides a user-friendly interface with pre-configured query options and parameters, automatically translating user selections into complex SQL queries without requiring users to understand the underlying database structure or query syntax
Solution Approach 2:
The system implements self-service functionality by providing automated query generation and execution. The query tool automatically constructs and executes complex database queries based on user-selected parameters, retrieves results, and generates visualizations without requiring manual query writing or technical database knowledge, thereby making sophisticated data access simple and accessible to business users
3Speed
If geospatial data is stored and queried efficiently, then query speed is improved, but system complexity increases
Solution Approach 1:
The system performs preliminary processing of geospatial radio coverage data during the data ingestion phase. The import tool automatically converts various data formats into a standardized geospatial format, pre-calculates and stores coverage boundaries, and organizes data in an optimized database structure. This preliminary action eliminates the need for complex real-time calculations during query execution, thereby achieving fast query speeds without requiring complex query processing logic
Solution Approach 2:
The patent introduces an intermediary import and conversion tool that handles the complexity of geospatial data processing. This tool automatically performs format conversion, data validation, and optimization tasks, transforming raw geospatial data into an optimized storage format suitable for fast querying. By concentrating the complexity in this intermediary data preparation layer, the actual query execution remains simple and fast
Data Source
AI summary
A method comprises receiving a request comprising parameters related to a data query and location information describing a geographic boundary, wherein the parameters indicate one or more types of data queried by a user of the workstation, communicating, by the export service application, with the geospatial database, to determine a format of data stored at the geospatial database, converting, by the export service application, a format of the parameters and the geographic boundary received in the request into query parameters that are formatted to be compatible with the geospatial database based on the format of data stored at the geospatial database, generating, by the export service application, a database query comprising the query parameters, wherein the database query is for retrieving data, from the geospatial database, that matches the parameters received in the request and is associated with a location within the geographic boundary.