Polymorphic Lookup Interface for Fast Data Retrieval

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current database systems face inefficiencies in user interface performance due to vast amounts of diverse data and limited, inflexible user interfaces, which hinder the effectiveness of lookup functions in providing timely results to users.

Innovation Solution

The implementation of a polymorphic lookup interface that utilizes an inverted index engine and database management system to efficiently search and retrieve data by maintaining indexes based on words, allowing for fast lookup and prioritization of relevant results, thereby enhancing the user interface's ability to handle diverse data types and improve search functionality.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If current database systems store vast amounts of diverse data, then data capacity and versatility are improved, but lookup efficiency and response time deteriorate

Engineering Contradiction:
Improvedata capacityVSAvoidlookup efficiency
Core Design Contradiction:
Adaptability or versatilityVSSpeed

Solution Approach 1:

The patent segments the large database into multiple data partitions distributed across different nodes. Each partition is independently searchable, allowing parallel query processing. This segmentation enables the system to handle vast amounts of diverse data while maintaining lookup efficiency through distributed query execution and reduced search space per node.

Inventive Principle:
Principle #1Segmentation

2Ease of manufacture

If current user interfaces are designed with fixed structure, then implementation simplicity is improved, but flexibility and scope of functionality deteriorate

Engineering Contradiction:
Improveimplementation simplicityVSAvoidinterface flexibility
Core Design Contradiction:
Ease of manufactureVSAdaptability or versatility

Solution Approach 1:

The patent implements a dynamic user interface that adapts its structure and functionality based on user needs, data types, and context. The interface can dynamically generate custom forms, filters, and display layouts rather than relying on fixed templates. This dynamic approach allows the same interface framework to handle diverse data types and operations while maintaining implementation simplicity through automated interface generation.

Inventive Principle:
Principle #15Dynamics

3Ease of operation

If traditional lookup functions are used in user interfaces, then ease of operation is maintained, but effectiveness and speed of information retrieval deteriorate

Engineering Contradiction:
Improveoperation simplicityVSAvoidinformation retrieval effectiveness
Core Design Contradiction:
Ease of operationVSProductivity

Solution Approach 1:

The patent replaces traditional mechanical lookup mechanisms (sequential scanning, basic indexing) with advanced information retrieval techniques including inverted indexes, full-text search, and relevance ranking algorithms. These substitutions maintain ease of operation for users while dramatically improving retrieval effectiveness and speed by enabling parallel search operations and intelligent result ranking based on query relevance.

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

Data Source

PatentUS10802670B2User interface for polymorphic lookup
Publication Date: 2020.10.13 SALESFORCE INC
  • US10802670B2 patent drawing
  • US10802670B2 patent drawing
  • US10802670B2 patent drawing

AI summary

System, method, and computer product embodiments for proving a graphical user interface (GUI) for a GUI object are described. A computing device provides, within the GUI, a polymorphic lookup interface for retrieving a plurality of entity instances to relate to the GUI object. The computing device provides a plurality of types of entities within the polymorphic lookup interface. A type of entity selected from the plurality of types limits the possible entity instances that may be returned. Through the polymorphic lookup interface, the computing device enables a user to select two or more entity instances to relate to the GUI object. Each of the selected entity instances may be selected from a plurality of possible entity instances that are returned, where each possible entity instance is a same type of entity.