Analytical Charting Automation for Database Data Distortion

Solution Overview

Problem

Conventional database applications require users to have knowledge of charting functions and layout management to create charts, which can lead to data distortion and increased user effort.

Innovation Solution

The system implements analytical charting techniques that automatically determine chart parameters and data series based on user input, allowing for on-the-fly chart creation without the need for users to understand database application functions, thereby simplifying the chart creation process and avoiding data distortion.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If conventional database application charting functions are used, then users can create charts with manual control over chart parameters and data series, but users require extensive knowledge of database application functions and layout management, increasing user effort and complexity

Engineering Contradiction:

Improveease of chart creationVSAvoiduser knowledge requirements

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The system automatically determines chart parameters and data series by analyzing the selected data and user intent, eliminating the need for users to manually specify these parameters. The system serves itself by making intelligent guesses about what the user wants to chart based on the context of the selected data, thereby reducing user effort and knowledge requirements while maintaining chart creation capability

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system performs preliminary analysis of the selected data to pre-determine appropriate chart parameters and data series before the user even requests a chart. By analyzing data types, relationships, and context in advance, the system prepares the chart configuration automatically, so users only need to select data and optionally modify pre-suggested parameters

Inventive Principle:

Principle #10Preliminary action

2Reliability

If conventional charting functions are used with manual data series specification, then users have full control over chart data grouping, but users may inadvertently create charts with distorted data representations due to lack of system intelligence

Engineering Contradiction:

Improvedata accuracy in chartsVSAvoidautomatic chart parameter determination

Core Design Contradiction:

ReliabilityVSExtent of automation

Solution Approach 1:

The system analyzes the selected data and provides feedback by suggesting appropriate chart parameters and data series groupings. This feedback mechanism allows the system to intelligently determine how data should be grouped and displayed, preventing common errors like mixing individual data items with their sums. Users can review and modify these suggestions, ensuring data accuracy while benefiting from system intelligence

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The system acts as an intermediary between the user's data selection and the final chart generation. Instead of directly creating charts from user input, the system introduces an intelligent analysis layer that determines appropriate data grouping and parameter settings, mediating between raw data selection and chart output to ensure accurate data representation

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If users manually specify chart parameters and data series in conventional database applications, then charts can be customized according to user needs, but the chart creation process requires significant user time and effort

Engineering Contradiction:

Improvechart creation speedVSAvoiduser time for chart creation

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system automatically determines chart parameters and data series by analyzing the selected data and user intent, eliminating the need for users to manually specify these parameters. The system serves itself by making intelligent guesses about what the user wants to chart based on the context of the selected data, thereby reducing user effort and knowledge requirements while maintaining chart creation capability

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system performs preliminary analysis of the selected data to pre-determine appropriate chart parameters and data series before the user even requests a chart. By analyzing data types, relationships, and context in advance, the system prepares the chart configuration automatically, so users only need to select data and optionally modify pre-suggested parameters

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS10192331B2Analytical charting

Publication Date: 2019.01.29 APPLE INC

AI summary

Methods, program products, and systems for analytical charting are described. A system implementing analytical charting techniques can receive a selection input from a data view displaying data retrieved from a database table. The system can determine a context of the selection input, a data environment in which the selection input is received, and characteristics of data being selected. Based on the context, the data environment, and the characteristics, the system can generate a chart data grouping that specifies a relationship between data in a chart. The system can automatically specify one or more data series for the chart based on the chart data grouping. The system can generate chart parameters automatically and transparently to the user. The system can provide the system-generated chart parameters for display and allow user modification to the system-generated chart parameters. The system can then generate a chart using the chart parameters.