Configurable Query Language Operator Dictionary

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing query languages lack the ability to customize operator dictionaries for different users or groups, leading to incompatible operators and data types, which can result in incorrect processing of search queries across diverse user-defined rules.

Innovation Solution

A configurable query language system that generates and verifies operator dictionaries for each user or group, allowing only compatible operators and data types, ensuring accurate processing of search queries by enforcing user-specific rules through a single query engine.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If a single query language is used for all users, then system simplicity is maintained, but user-specific customization and compatibility are lost

Engineering Contradiction:
Improveuser-specific query customizationVSAvoidquery language configuration
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The query language is segmented into user-specific operator dictionaries, where each user or group has their own customized dictionary defining compatible operators and data types. This allows different users to have tailored query languages while the system manages multiple segmented configurations through a unified query engine.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system changes the parameter of operator compatibility by dynamically loading and applying different operator dictionaries based on user identity. Each operator dictionary contains specific parameters defining which operators are compatible with which data types for that user, allowing flexible customization without system-wide changes.

Inventive Principle:
Principle #35Parameter changes

2Reliability

If operator dictionaries are customized for each user, then query accuracy is improved, but system complexity and processing overhead increase

Engineering Contradiction:
Improvequery processing accuracyVSAvoidoperator dictionary management
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

Operator dictionaries are pre-configured and validated before query execution. The system performs preliminary actions by defining user-specific operator dictionaries in advance, establishing compatibility rules between operators and data types before actual query processing occurs, thereby ensuring accuracy without adding runtime complexity.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The operator dictionary serves as an intermediary layer between the user's query intent and the database execution engine. It mediates by translating user-specific operator definitions into a standardized format that the query engine can process, ensuring compatibility and accuracy while shielding the engine from user-specific complexities.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If multiple operator dictionaries are supported, then user diversity is accommodated, but verification and compatibility checking become more difficult

Engineering Contradiction:
Improvemulti-user supportVSAvoidoperator compatibility verification
Core Design Contradiction:
Adaptability or versatilityVSDifficulty of detecting and measuring

Solution Approach 1:

The system implements feedback mechanisms where the query engine verifies operator compatibility against the active user's operator dictionary during query processing. This feedback loop detects compatibility issues by checking whether operators in the query match the allowed operators and data types defined in the user's dictionary, providing immediate verification without manual intervention.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS9460151B2System and methods to configure a query language using an operator dictionary
Publication Date: 2016.10.04 PAYPAL INC
  • US9460151B2 patent drawing
  • US9460151B2 patent drawing
  • US9460151B2 patent drawing

AI summary

Systems and methods to configure a query language using an operator dictionary are described. The system receives, from a first user, a search query to search for document information in a database. The system determines that terms of the search query from the first user are in accordance with dictionary information that corresponds to the first user. The dictionary information includes a first list of compatible query operators. The system applies the search query to the index data structure in the database to identify the document information. The system sends an electronic interface to the first user that includes the document information.