Multi-tenant Database Search Term Analysis

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In multi-tenant database systems, analyzing search terms and user interactions is challenging due to the complexity of managing shared databases and providing effective customer support, as existing methods lack comprehensive tools for understanding user behavior and optimizing search engine performance.

Innovation Solution

The implementation of analytical tools within a multi-tenant database system that generate knowledge base reports and user activity reports, utilizing Custom Report Type objects and tracking systems to aggregate and analyze search data, including keyword usage and voting statistics, to improve search engine performance and customer support.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If comprehensive search term analysis tools are implemented in multi-tenant database systems, then understanding of user behavior and search trends improves, but system complexity and cost of implementation increase

Engineering Contradiction:
Improveuser behavior understandingVSAvoidsystem complexity
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The patent segments the multi-tenant database system into distinct analytical components: search term tracking modules, user interaction analysis modules, and reporting modules. Each component handles specific aspects of search analysis independently, allowing comprehensive user behavior understanding while maintaining manageable system complexity through modular architecture.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces intermediary analytical layers that sit between the core database operations and the search analysis functions. These intermediaries capture search term data and user interactions without interfering with primary database operations, enabling comprehensive analysis while isolating complexity to dedicated analytical components.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Manufacturing precision

If detailed tracking of search terms and user interactions is implemented, then search engine optimization improves, but data processing requirements and operational costs increase

Engineering Contradiction:
Improvesearch optimization precisionVSAvoiddata processing volume
Core Design Contradiction:
Manufacturing precisionVSQuantity of substance

Solution Approach 1:

The patent applies local quality by focusing tracking and analysis resources on specific high-value search terms and user interactions rather than uniformly processing all data. The system identifies and prioritizes critical search patterns, enabling precise search engine optimization while reducing overall data processing volume by concentrating analytical efforts where they provide maximum value.

Inventive Principle:
Principle #3Local quality

3Reliability

If multi-tenant database systems provide comprehensive customer support tools, then customer support quality improves, but system resource requirements and operational complexity increase

Engineering Contradiction:
Improvecustomer support qualityVSAvoidoperational complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent implements universal analytical tools that serve multiple customer support functions simultaneously. The same search term tracking and user interaction analysis infrastructure supports knowledge base optimization, customer behavior understanding, and support workflow improvement, enabling comprehensive customer support quality enhancement while avoiding the need for separate specialized systems for each function.

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

Data Source

PatentUS9223852B2Methods and systems for analyzing search terms in a multi-tenant database system environment
Publication Date: 2015.12.29 SALESFORCE INC
  • US9223852B2 patent drawing
  • US9223852B2 patent drawing
  • US9223852B2 patent drawing

AI summary

Knowledge base is gaining popularity as a customer support tool. Customers search the knowledge base for solutions to their issues. Keywords searched in knowledge base are analyzed and reports are made available for managers and supervisors to understand the trends and requirements of customers. The number of keywords searched can be extremely large in some organizations. In this specification, storing the keywords in a meaningful way in order to generate report for further analysis is discussed. Efficient data storage helps in managing voluminous data and also reducing the amount of memory required to store the data. Any of the above embodiments can be used independently or together with any combination of other embodiments.