Keyword Definition Editor for Query Accuracy
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional reporting tools require user expertise and creativity to determine appropriate queries and generate visualizations, as users often submit queries that are not fully understood by the system, leading to unsatisfactory results due to unclear or undefined expressions.
Innovation Solution
A system architecture that allows users to define keywords by suggesting interpretations based on metadata, enabling users to transform user-supplied expressions into compatible query terms, which can be mapped to specific values and persisted for future use, enhancing the metadata of the data set.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If conventional reporting tools are used without keyword definition, then users can submit queries freely, but query accuracy and result relevance deteriorate due to unclear expressions
Solution Approach 1:
The system performs preliminary action by automatically generating keyword suggestions and definitions before the user submits their query. The keyword definition service pre-processes potential keywords, creates definitions based on metadata, and stores them in a knowledge base, so that when users submit queries, accurate keyword matching is already in place, improving query accuracy without requiring users to manually define keywords beforehand
Solution Approach 2:
The keyword definition service acts as an intermediary between the user's natural language query and the system's structured data understanding. It translates user expressions into precise keyword definitions by leveraging metadata from data sources, thereby improving query accuracy while maintaining ease of operation for users
2Measurement precision
If users define keywords manually, then query accuracy improves, but time consumption and operational complexity increase
Solution Approach 1:
The system implements self-service by automatically generating keyword definitions without requiring manual user input. The keyword definition service autonomously extracts information from metadata, creates keyword definitions, and stores them in the knowledge base, thereby improving query accuracy while eliminating the time users would otherwise spend manually defining keywords
Solution Approach 2:
The system replaces the mechanical process of manual keyword definition with an automated computational process. The keyword definition service uses algorithms to analyze metadata, generate keyword suggestions, and create definitions automatically, substituting the manual mechanical action of users with an automated electronic system that improves accuracy without time loss
3Measurement precision
If the system requires expertise in data schema, then query precision improves, but ease of operation deteriorates
Solution Approach 1:
The keyword definition service serves as an intermediary that translates between user-friendly natural language and precise data schema requirements. It automatically maps user expressions to appropriate keywords and definitions based on metadata, thereby achieving query precision without requiring users to have expertise in data schemas
Solution Approach 2:
The system performs self-service by automatically understanding and interpreting data schema information through metadata analysis. The keyword definition service autonomously creates keyword definitions that reflect the underlying data structure, eliminating the need for users to possess schema expertise while maintaining query precision
Data Source
AI summary
A system, method, and computer-readable medium, including receiving a user-supplied expression for which a definition is sought; generating, in response to reception of the user-supplied expression, at least one suggested definition specifying a meaning for the user-supplied expression, the at least one suggested definition being generated based on, at least in part, a knowledge base of metadata associated with a data set; presenting the at least one suggested definition, as at least one keyword, to a user; receiving, in response to the presentation, an indication of one user-selected keyword from the at least one suggested definition; defining the user-selected keyword by at least one value; and persisting the defined user-selected keyword with the at least one value in the knowledge base for the data set.