Search Query Translation for Structured Data Reports

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current search techniques are not optimized for creating queries for abstract structured datasets, often returning only unstructured data that directly matches a search query, and require specialized user knowledge for data query and report generation, limiting their usability by non-expert users.

Innovation Solution

A method that receives a search query, generates a proposed abstract query, and returns report search results, allowing users to choose between submitting the proposed query or designating an existing report, with a computer-readable storage medium containing executable instructions to facilitate this process.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If current search techniques are used for unstructured datasets, then direct matching is achieved, but the ability to create queries for abstract structured datasets is lost

Engineering Contradiction:
Improvesearch query matching accuracyVSAvoidquery creation capability for structured data
Core Design Contradiction:
Measurement precisionVSAdaptability or versatility

Solution Approach 1:

The patent introduces an intermediary layer between the search query interface and the structured data sources. This intermediary translates natural language search queries into structured query language (such as SQL or SPARQL) that can effectively access and retrieve data from structured datasets, thereby maintaining both direct matching capability and query creation versatility

Inventive Principle:
Principle #24Intermediary (Mediator)

2Measurement precision

If specialized user knowledge is required for data query and report generation, then precise data retrieval is achieved, but usability by non-expert users is limited

Engineering Contradiction:
Improvedata retrieval accuracyVSAvoidusability for non-expert users
Core Design Contradiction:
Measurement precisionVSEase of operation

Solution Approach 1:

The system implements self-service functionality by automatically generating appropriate queries and reports based on user input without requiring manual query construction. The system autonomously handles the translation of user requirements into technical query language and executes the data retrieval process, making complex data operations accessible to non-expert users while maintaining high retrieval accuracy

Inventive Principle:
Principle #25Self-service

3Productivity

If state of the art search techniques return only unstructured data, then direct match results are obtained, but structured data results relevant to search queries cannot be returned

Engineering Contradiction:
Improvesearch result delivery speedVSAvoidstructured data result capability
Core Design Contradiction:
ProductivityVSAdaptability or versatility

Solution Approach 1:

The patent changes the fundamental parameter of data structure in the search results by implementing a dual-mode result delivery system. This system can return both unstructured direct match results and structured query results based on the data source type and user requirements, maintaining fast delivery for simple queries while enabling structured data retrieval for complex queries through automated query generation and execution

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS8204895B2Apparatus and method for receiving a report
Publication Date: 2012.06.19 SAP IRELAND LTD
  • US8204895B2 patent drawing
  • US8204895B2 patent drawing
  • US8204895B2 patent drawing

AI summary

A method of receiving a report includes submitting a search query, receiving a proposed abstract query and report search results, and accepting a choice between submitting the proposed abstract query to generate a report and designating an existing report from the report search results. A report is then received in accordance with the choice.