Dynamic Graphical Query Display Mode Selection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems face performance issues when displaying large datasets on maps, leading to memory overload, bandwidth constraints, long wait times, and inability to render features in a timely and memory-efficient manner, especially when dealing with millions of records.
Innovation Solution
The system dynamically selects graphical query result display modes by using a threshold to switch between interactive and non-interactive modes, employing pixel rendering for large result sets, where the server renders features serially and sends compressed images to the client, avoiding full dataset loading and enabling efficient memory use.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If the system loads and renders all query results on the client side, then the display is interactive and flexible, but memory usage increases and rendering time exceeds acceptable limits for large datasets
Solution Approach 1:
The patent extracts only the essential rendering function from the client side and relocates it to the server side. The server renders map features and query results into image formats (PNG, JPEG, GIF) and transmits these pre-rendered images to the client for display. This extraction eliminates the need for the client to load and process large datasets in memory, resolving the contradiction between display interactivity and memory consumption.
Solution Approach 2:
The patent introduces an intermediary rendering process on the server side that converts query results into image formats before transmission. This intermediary step acts as a mediator between the data source and the client display, transforming complex data structures into optimized visual representations that reduce client-side memory requirements while maintaining display quality and interactivity.
2Loss of information
If the system transmits full dataset records from server to client, then data completeness is maintained, but network bandwidth consumption increases and transmission time increases
Solution Approach 1:
The patent creates visual copies of the data in the form of rendered map images instead of transmitting the original data records. The server generates PNG, JPEG, or GIF images that represent the spatial distribution of query results, and transmits these image copies to the client. This copying approach maintains the essential visual information needed for data interpretation while dramatically reducing the network bandwidth required compared to transmitting complete dataset records.
3Manufacturing precision
If the server renders all features simultaneously in memory, then rendering completeness is achieved, but server memory overload occurs and rendering speed decreases
Solution Approach 1:
The patent segments the rendering process into manageable units by processing and rendering map features in batches or streams rather than loading all features simultaneously into memory. The server renders features sequentially or in controlled batches, generating image data that is transmitted to the client progressively. This segmentation approach maintains rendering completeness while preventing server memory overload and improving rendering throughput.
4Measurement precision
If the system uses detailed vector formats for map display, then rendering precision is high, but file size increases and processing time increases
Solution Approach 1:
The patent changes the output format parameter from detailed vector data to raster image formats (PNG, JPEG, GIF). This parameter transformation converts precision-critical vector representations into pixel-based images that are more compact in size and faster to transmit and display. The parameter change maintains sufficient visual precision for map display purposes while dramatically reducing the data size and processing requirements compared to vector formats.
Data Source
AI summary
Systems and methods for displaying graphical database query results on a map by dynamically selecting graphical query result display modes are described. In one example, the system includes a distributed database query system having a remote server and a local client computer. The remote server receives a query request from the client and obtains a threshold number of results for display. If a particular query provides less than the threshold number of results, the system uses a first interactive graphical query result mode utilizing client rendering. If the query provides the threshold number of results or more, the system uses a second non-interactive graphical query result mode utilizing server rendering.