Delta Merge Location Data Handling Multiple Coordinate Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database designs face challenges in efficiently storing and processing location data across different coordinate systems, leading to increased storage consumption and reduced performance due to the need for String designation, which limits querying and processing capabilities.
Innovation Solution
A location data processing system (LPS) that configures database columns to store location data across multiple coordinate systems, using a flexible data type configuration that minimizes storage usage and allows for efficient querying and processing, even when the coordinate system is unknown at the time of table creation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If conventional database designs use String designation for location data to handle multiple coordinate systems, then adaptability is improved, but storage consumption increases and performance decreases
Solution Approach 1:
The patent changes the data type parameter from String to a specialized location data type that can represent multiple coordinate systems. This allows the database to store location data efficiently without using String designation, thereby reducing storage consumption while maintaining the ability to handle multiple coordinate systems through parameter transformation and coordinate system metadata.
2Adaptability or versatility
If conventional database designs use String designation for location data, then adaptability is improved, but querying and processing capabilities are reduced
Solution Approach 1:
The patent introduces coordinate system metadata as an intermediary element that stores information about the coordinate system used for location data. This metadata acts as a mediator between the raw location data and the querying/processing operations, enabling efficient queries and processing by providing the necessary coordinate system context without requiring String designation throughout the data structure.
Solution Approach 2:
The patent transforms location data from String representation to a structured location data type with associated metadata. This parameter change enables the database to maintain adaptability for multiple coordinate systems while significantly improving querying and processing capabilities through optimized data structures and indexed metadata fields.
3Adaptability or versatility
If flexible data type configuration is used to store location data across multiple coordinate systems, then adaptability is improved, but device complexity increases
Solution Approach 1:
The patent creates a universal location data type that can store location information from multiple coordinate systems without requiring separate data types for each coordinate system. This multi-functional data type handles various coordinate systems through a unified structure with coordinate system metadata, thereby improving adaptability while actually reducing the apparent complexity compared to managing multiple specialized data types.
Data Source
AI summary
Disclosed herein are various embodiments for performing a delta merge with location data. An embodiment operates by receiving a command to merge a delta storage with an original main storage. A coordinate system corresponding to a plurality of data entries of data in the delta storage is identified. A coordinate system specification, corresponding to one of the identified coordinate system, is added to a metadata of a new version of the main storage. A merge operation is performed between the delta storage and the original main storage, in which the plurality of data entries of the delta storage are copied to a container portion of the new version of the main storage, separate from the metadata. The plurality of data entries of the delta storage are deleted and the original main storage is replaced with the new version of the main storage.