Compact Query Code Expansion for Database Efficiency

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems face inefficiencies and bottlenecks when processing queries due to the reliance on full and unedited computer code, which consumes significant storage space and network bandwidth, and often requires translation across different computer architectures, leading to resource overloads and data corruption.

Innovation Solution

The use of compact computer code, which is annotated or compressed, allows for efficient data transfer and processing by decompressing into expanded code upon receipt, utilizing partially-expanded code for reduced resource usage, and parameterizing code to fit multiple computer architectures without full translation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If full and unedited computer code is used for queries, then query processing accuracy is maintained, but storage space and network bandwidth consumption increase significantly

Engineering Contradiction:

Improvequery processing accuracyVSAvoidstorage space and network bandwidth

Core Design Contradiction:

Measurement precisionVSQuantity of substance

Solution Approach 1:

The query code is segmented into essential components and non-essential components. Only the essential components are transmitted and processed, while non-essential components are omitted or compressed. This segmentation allows the system to maintain processing accuracy for critical query elements while significantly reducing the overall data volume transmitted and stored.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent extracts and removes redundant, unnecessary, or non-critical portions of the query code before transmission and processing. By taking out only the essential elements required for accurate query execution, the system reduces storage space and network bandwidth consumption while preserving the core functionality and accuracy of query processing.

Inventive Principle:

Principle #2Taking out (Extraction)

2Quantity of substance

If query code is compressed to reduce data size, then network bandwidth consumption decreases, but computational resources required for decompression and processing increase

Engineering Contradiction:

Improvenetwork bandwidthVSAvoidcomputational resources

Core Design Contradiction:

Quantity of substanceVSUse of energy by moving object

Solution Approach 1:

Instead of fully decompressing and processing the entire query code, the system performs partial action by processing only the essential components that were transmitted. This partial processing approach reduces the computational burden while still achieving the desired query results, balancing the trade-off between compression and processing resources.

Inventive Principle:

Principle #16Partial or excessive action

Solution Approach 2:

The patent introduces an intermediary mechanism that facilitates efficient decompression and processing of the compressed query code. This intermediary layer optimizes the decompression process and selectively processes only the necessary components, reducing the overall computational resources required while maintaining the benefits of compressed data transmission.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Adaptability or versatility

If queries are translated to fit multiple computer architectures, then system compatibility is improved, but processing time and resource consumption increase

Engineering Contradiction:

Improvesystem compatibilityVSAvoidprocessing time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The query code is prepared and structured in advance to be architecture-agnostic or adaptable to multiple architectures without requiring runtime translation. This preliminary action of designing universal query formats reduces the need for time-consuming translation processes when executing queries across different computer architectures, thereby improving processing speed while maintaining compatibility.

Inventive Principle:

Principle #10Preliminary action

4Reliability

If full query code is transmitted over the network, then data integrity is maintained, but network bandwidth consumption and transfer time increase

Engineering Contradiction:

Improvedata integrityVSAvoidnetwork bandwidth

Core Design Contradiction:

ReliabilityVSQuantity of substance

Solution Approach 1:

The patent extracts and transmits only the essential components of the query code that are necessary for maintaining data integrity and achieving query objectives. By removing redundant or non-critical portions before transmission, the system reduces network bandwidth consumption and transfer time while preserving the integrity and functionality of the query data.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

Instead of transmitting the complete query code, the system transmits a partial version containing only the essential elements required for accurate query execution. This partial transmission approach maintains data integrity for the critical components while significantly reducing the overall data volume transmitted over the network, thereby optimizing bandwidth usage and transfer efficiency.

Inventive Principle:

Principle #16Partial or excessive action

Data Source

PatentUS12222955B2Method for automated query language expansion and indexing

Publication Date: 2025.02.11 SISENSE INC

AI summary

In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.