Metadata Tracking for Pipelined Machine Data Visualization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The rapid increase in machine-generated data creates challenges in searching and analyzing large data sets, often resulting in undesired graphical visualizations due to the type of visualization and data retrieved by search engines.

Innovation Solution

A system that determines and tracks metadata for data tables, allowing users to generate visualizations by executing a pipeline of commands that append or insert columns into the table, with metadata automatically generated for each column based on the actions performed by the commands.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If search engines retrieve data from various data sources, then data retrieval capability is improved, but visualization accuracy deteriorates due to mismatch between data type and visualization type

Engineering Contradiction:
Improvedata retrieval capabilityVSAvoidvisualization accuracy
Core Design Contradiction:
Adaptability or versatilityVSManufacturing precision

Solution Approach 1:

The system performs preliminary actions by automatically generating metadata for each column during the data retrieval process. This metadata includes data type information (numeric, categorical, temporal, etc.) that is prepared in advance before visualization is needed. The metadata generation occurs as part of the pipeline execution, allowing the system to understand the structure and characteristics of the retrieved data before attempting to visualize it.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

Metadata serves as an intermediary between the raw retrieved data and the visualization generation process. The metadata layer translates the structural information about columns into actionable characteristics that guide visualization selection. By introducing this intermediate metadata representation, the system can accurately match data characteristics with appropriate visualization types, resolving the mismatch between diverse data sources and specific visualization requirements.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Quantity of substance

If machine-generated data increases, then data volume is improved, but search and analysis difficulty increases

Engineering Contradiction:
Improvedata volumeVSAvoidsearch and analysis difficulty
Core Design Contradiction:
Quantity of substanceVSDevice complexity

Solution Approach 1:

The system segments the data analysis process into distinct pipeline commands that can be executed sequentially. Each command operates on a specific aspect of the data (filtering, aggregating, transforming), breaking down the complex task of analyzing large machine-generated datasets into manageable steps. This segmentation allows the system to handle large volumes of data through compositional operations rather than monolithic processing.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system changes parameters dynamically during pipeline execution by generating metadata that describes data characteristics. This includes transforming data types, adjusting aggregations, and modifying visualization parameters based on the actual data structure. By adapting parameters to the specific characteristics of the retrieved data, the system can efficiently analyze large datasets without requiring manual configuration for each data type.

Inventive Principle:
Principle #35Parameter changes

3Adaptability or versatility

If automatic metadata generation is implemented, then visualization compatibility is improved, but system complexity increases

Engineering Contradiction:
Improvevisualization compatibilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system performs self-service by automatically generating metadata for columns during pipeline execution without requiring manual intervention. The metadata generation is an autonomous process that occurs as part of normal pipeline operation, where the system inspects its own output and creates appropriate metadata descriptions. This self-service capability enables the system to adapt to any data structure automatically, improving visualization compatibility while keeping the user experience simple.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS9817862B2Associating metadata with results produced by applying a pipelined search command to machine data in timestamped events
Publication Date: 2017.11.14 CISCO TECHNOLOGY INC
  • US9817862B2 patent drawing
  • US9817862B2 patent drawing
  • US9817862B2 patent drawing

AI summary

Embodiments are directed towards determining and tracking metadata for the generation of visualizations of requested data. A user may request data by providing a query that may be employed to search for the requested data. The query may include a plurality of commands, which may be employed in a pipeline to perform the search and to generate a table of the requested data. In some embodiments, each command may be executed to perform an action on a set of data. The execution of a command may generate one or more columns to append and/or insert into the table of requested data. Metadata for each generated column may be determined based on the actions performed by executing the commands. The table of requested data and the column metadata may be employed to generate and display a visualization of at least a portion of the requested data to a user.