Natural Language Database Query Platform

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Users, especially non-technical individuals, face difficulties in interfacing with database systems due to unfamiliarity with database syntax and schema, leading to incorrect information retrieval and inefficiencies in accessing data.

Innovation Solution

A natural language processing platform, or chatbot, is implemented within a multi-tenant database system to convert natural language user queries into structured database queries, allowing users to access and manipulate data without needing to know the exact database syntax or schema.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If users directly interface with database systems using traditional methods, then data access capability is achieved, but user complexity and difficulty of operation increase significantly

Engineering Contradiction:
Improveease of database accessVSAvoiddatabase interface complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent introduces a natural language processing interface as an intermediary between users and the database system. This mediator translates user-friendly natural language queries into structured database queries, eliminating the need for users to learn complex database syntax while maintaining full database functionality. The natural language processor acts as a buffer that handles the complexity transformation automatically.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces the mechanical interaction model of traditional database interfaces (requiring knowledge of SQL syntax, table structures, and query construction) with a natural language processing model. Instead of users mechanically constructing queries according to database rules, the system uses NLP to interpret and translate human language into executable database commands, substituting one interaction paradigm for another that is inherently more intuitive.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Ease of operation

If natural language processing is implemented to simplify user interface, then ease of operation improves, but system complexity and processing time increase

Engineering Contradiction:
Improvequery input simplicityVSAvoidnatural language processing system complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The natural language processing system is segmented into distinct functional modules: intent recognition, entity extraction, query construction, and result formatting. Each module handles a specific aspect of the translation process, making the overall complex system manageable and maintainable. This segmentation allows the system to process natural language queries through a series of discrete, well-defined steps rather than a monolithic complex process.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The natural language processing interface is designed as a universal layer that can handle multiple types of database operations (selection, aggregation, filtering, joining) through a single unified mechanism. Rather than requiring separate interfaces for different query types, the system uses one multi-functional NLP processor that adapts to various query requirements, reducing the need for multiple specialized components.

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Speed

If natural language queries are converted to structured database queries, then data access speed improves, but query accuracy may decrease due to ambiguity

Engineering Contradiction:
Improvedata retrieval speedVSAvoidquery interpretation accuracy
Core Design Contradiction:
SpeedVSMeasurement precision

Solution Approach 1:

The system implements feedback mechanisms where the NLP processor provides users with clarifying questions when query ambiguity is detected. Rather than making assumptions that could lead to incorrect results, the system seeks additional information from users to disambiguate their intent. This feedback loop ensures query accuracy while maintaining efficient processing by only requesting clarification when truly necessary.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The system performs preliminary analysis of the natural language query to identify potential ambiguities before executing the database operation. By pre-processing the query to detect ambiguous terms or multiple possible interpretations, the system can prepare appropriate clarification questions in advance, preventing inaccurate query execution while maintaining overall processing efficiency.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11295194B2Natural language platform for database system
Publication Date: 2022.04.05 SALESFORCE INC
  • US11295194B2 patent drawing
  • US11295194B2 patent drawing
  • US11295194B2 patent drawing

AI summary

An artificial intelligence assistant (“chatbot”) operates within a multi-tenant database and allows users to interact with the underlying structured database through a natural language interface without using a standard structured query language or database interface. Users may interact with the chatbot via a chatroom and perform database queries using natural language expressions in the same manner as asking a person to perform the tasks. In addition, the chatbot may check user permissions and security parameters to determine if the user is permitted to access or alter data within the multi-tenant database.