Virtual Table Navigation Attribute Access

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Traditional navigation database systems face inefficiencies in updating and accessing navigation attributes due to the cumbersome nature of managing large numbers of attributes stored across multiple binary large objects (BLOBs), which requires updating or accessing entire BLOBs, leading to performance issues in highly automated driving (HAD), advanced driver assistance systems (ADAS), and autonomous driving systems (ADS).

Innovation Solution

The implementation of a virtual table system that allows for flexible organization and access of navigation attributes using Structured Query Language (SQL) commands, enabling the normalization of data access and storage across various navigation systems, including HAD, ADAS, and ADS, by utilizing metatables to locate attribute locations efficiently within BLOBs.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If navigation attributes are stored in separate BLOBs to avoid loading unnecessary information, then data loading efficiency is improved, but accessing or updating particular attributes becomes cumbersome requiring entire BLOB manipulation

Engineering Contradiction:
Improvedata loading efficiencyVSAvoidattribute access ease
Core Design Contradiction:
ProductivityVSEase of operation

Solution Approach 1:

The patent introduces a virtual table as an intermediary layer between the application and the underlying BLOB storage. The virtual table contains metadata about attribute locations within BLOBs, allowing the system to efficiently locate and access specific attributes without loading entire BLOBs into memory. This mediator enables precise attribute access while maintaining the storage efficiency of separate BLOBs.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments navigation attributes into separate BLOBs stored in relational tables, with each BLOB containing specific attribute groups. The virtual table then segments the access path by providing indexed references to specific BLOB locations, enabling selective loading of only required attributes rather than entire BLOBs, thus resolving the contradiction between storage efficiency and access ease.

Inventive Principle:
Principle #1Segmentation

2Quantity of substance

If hundreds of navigation attributes are stored in a comprehensive database structure, then complete navigation information is available, but system complexity and data management difficulty increase

Engineering Contradiction:
Improvenavigation attributes availableVSAvoiddata management complexity
Core Design Contradiction:
Quantity of substanceVSDevice complexity

Solution Approach 1:

The patent adds a new dimensional layer (virtual table metadata layer) above the traditional relational database structure. This additional dimension provides indexed references and location information without duplicating the actual attribute data, enabling efficient management of hundreds of navigation attributes through a structured metadata framework rather than direct database manipulation.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

3Reliability

If entire BLOBs are loaded into navigation applications to ensure all attributes are accessible, then attribute access completeness is improved, but memory usage and processing overhead increase

Engineering Contradiction:
Improveattribute access completenessVSAvoidmemory usage
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

Solution Approach 1:

The patent extracts only the necessary attribute data from large BLOBs based on virtual table metadata and application needs. Instead of loading entire BLOBs into memory, the system extracts and loads only the specific attributes required for current navigation operations, significantly reducing memory usage while maintaining access completeness for required data.

Inventive Principle:
Principle #2Taking out (Extraction)

Data Source

PatentUS9970769B2Flexible organization of navigation attributes to support hybrid navigation and data streaming
Publication Date: 2018.05.15 HERE GLOBAL BV
  • US9970769B2 patent drawing
  • US9970769B2 patent drawing
  • US9970769B2 patent drawing

AI summary

Methods, apparatuses, and systems are provided which allow for flexible organization of navigation attributes to support hybrid navigation and data streaming. A system may receive a request for geographic data. The system may identify a map attribute from the request. The system may query a metatable with the map attribute for a binary large object entry address, wherein the metatable includes a plurality of binary large object entry addresses. The system may access a navigation database using the binary large object entry address for a binary large object including data for the map attribute. The system may generate a map command including the data for the map attribute.