Database Table Annotation Processing Engine

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Working with database tables from different sources is challenging due to varying formats and schema, requiring runtime knowledge of the database tables and server engines to write appropriate queries.

Innovation Solution

An annotation processing engine receives instructions to build database tables, determines compatible database server engines, and generates queries in the native language of the engine using annotations that identify common features and operations across different formats, allowing for consistent annotation processing across various database server engines.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If database tables from different sources with varying formats and schemas are worked with simultaneously, then the ability to process diverse database sources is improved, but the complexity of writing appropriate queries increases due to requiring runtime knowledge of different database server engines

Engineering Contradiction:

Improveability to process diverse database sourcesVSAvoidcomplexity of writing appropriate queries

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces an intermediary layer (annotation processing engine) that sits between the user and the diverse database sources. This intermediary automatically processes annotations and generates engine-specific queries, eliminating the need for users to have runtime knowledge of different database server engines while maintaining the ability to work with diverse database formats

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments the query processing functionality into separate annotations for different database server engines. Each annotation contains engine-specific information that is processed independently, allowing the system to handle multiple database formats without increasing user complexity

Inventive Principle:

Principle #1Segmentation

2Reliability

If runtime knowledge of database server engines is required to write appropriate queries, then query accuracy for specific engines is improved, but the ease of operation deteriorates due to the need for specialized knowledge

Engineering Contradiction:

Improvequery accuracy for specific enginesVSAvoidease of writing queries

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The patent performs preliminary action by pre-defining annotations for different database server engines before runtime. These annotations contain all necessary engine-specific information, so when a query is executed, the system automatically selects and applies the appropriate pre-configured annotation, ensuring both accuracy and ease of operation without requiring runtime engine knowledge

Inventive Principle:

Principle #10Preliminary action

3Ease of manufacture

If annotations identifying common features and operations are used across different database formats, then the ease of manufacture of query solutions is improved, but the measurement precision of engine-specific query requirements may deteriorate

Engineering Contradiction:

Improveease of creating query solutionsVSAvoidprecision of engine-specific query requirements

Core Design Contradiction:

Ease of manufactureVSMeasurement precision

Solution Approach 1:

The patent segments annotations into two distinct layers: common annotations that define universal database features and operations, and engine-specific annotations that capture precise engine requirements. This segmentation allows easy creation of query solutions through common annotations while maintaining precision through engine-specific annotations that are automatically applied based on the target database engine

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS11507586B2Database table annotation processing

Publication Date: 2022.11.22 UNIPHORE TECHNOLOGIES INC

AI summary

Systems and techniques are provided for database table annotation processing. An annotation processing engine on a computing device may receive an instruction to build a database table. The annotation processing engine on the computing device may receive annotations made to the database table from a storage of the computing device. The annotations may include labels identifying features of the database table. The annotation processing engine on the computing device may determine a database server engine compatible with the database table. The annotation processing engine on the computing device may generate a query in a native language of the database server engine compatible with the database table based on the instruction to build the database table and the annotations made to the database table. The annotation processing engine on the computing device may send the query in the native language of the database server engine to the database server engine.