Field-Value Search Drill Down for Dynamic Data Analysis

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data analysts face challenges in identifying valuable correlations within large volumes of heterogeneous performance data, particularly due to the unstructured nature of the data and the difficulty in applying semantic meaning, which hampers the ability to derive strategic insights.

Innovation Solution

The implementation of an event-based system like SPLUNKĀ® ENTERPRISE, which uses a late-binding schema to store and process performance data, allowing for flexible extraction of field values and enabling users to refine extraction rules during search time, along with features like field-value search drill down that allow users to interactively manage search criteria.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If data is stored in unstructured format at ingestion time, then storage efficiency is improved, but the ability to extract meaningful correlations and patterns is worsened

Engineering Contradiction:
Improvedata storage capacityVSAvoidsemantic meaning
Core Design Contradiction:
Quantity of substanceVSLoss of information

Solution Approach 1:

The system performs preliminary data ingestion and storage in an efficient format without requiring complete schema definition upfront. The late-binding schema allows field extraction rules to be defined and applied later during search time, enabling the system to preserve raw data while gaining analytical capabilities when needed.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The schema binding is made dynamic rather than static. Field extraction rules are not fixed at ingestion time but can be defined, modified, and applied dynamically during search operations. This allows the system to adapt to different analysis requirements without reprocessing the original data.

Inventive Principle:
Principle #15Dynamics

2Productivity

If all field extraction rules are defined at ingestion time, then data processing efficiency is improved, but flexibility in refining extraction rules is worsened

Engineering Contradiction:
Improvedata processing speedVSAvoidextraction rule flexibility
Core Design Contradiction:
ProductivityVSAdaptability or versatility

Solution Approach 1:

The system transitions from static schema definition to dynamic schema binding. Extraction rules are established at search time rather than ingestion time, allowing users to refine and adjust rules based on actual analysis needs while maintaining efficient data processing through the pre-ingested raw data.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

Raw data is ingested and stored in advance without complete processing. The system performs the data acquisition preliminary action efficiently, then applies extraction rules dynamically during search operations, combining speed with flexibility.

Inventive Principle:
Principle #10Preliminary action

3Measurement precision

If users manually construct search commands for complex correlations, then search precision is improved, but ease of operation is worsened

Engineering Contradiction:
Improvesearch accuracyVSAvoiduser effort
Core Design Contradiction:
Measurement precisionVSEase of operation

Solution Approach 1:

The system provides self-service capabilities through automatic field extraction and search command generation. When users specify search criteria, the system automatically extracts relevant fields and constructs appropriate search commands, reducing manual effort while maintaining precise search results through the structured extraction process.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The late-binding schema acts as an intermediary between user intent and data retrieval. It automatically translates user-specified criteria into structured search commands by applying extraction rules, serving as a mediator that reduces manual work while preserving search precision.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS11868158B1Generating search commands based on selected search options
Publication Date: 2024.01.09 CISCO TECHNOLOGY INC
  • US11868158B1 patent drawing
  • US11868158B1 patent drawing
  • US11868158B1 patent drawing

AI summary

In embodiments of field value search drill down, a search system exposes a search interface that displays one or more events returned as a search result set. A field-value pair can be emphasized in the field-value pairs of an event displayed in the search interface, and a menu is displayed with search options that are selectable to operate on the emphasized field-value pair of the event. The menu includes the search options to add search criteria of the emphasized field-value pair to a search command in a search bar of the search interface, exclude the search criteria of the emphasized field-value pair from a search, or create a new data search based on the emphasized field-value pair. A selection of one of the search options in the menu can be received, and the search command in the search bar is updated based on the search option that is selected.