Automated Data Binding to Compound Control Properties

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing systems face challenges in allowing non-programmers to intuitively bind complex data to complex controls within recalculation user interfaces, such as spreadsheet documents, without requiring in-depth knowledge of coding or familiarity with control properties and data sources.

Innovation Solution

The automated binding of a data source to a compound control is facilitated by identifying the properties of the compound control and associating a particular data source with it, using information about both to determine suitable fields for binding, and considering the nature of declarative transformations for binding options.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If automated binding is implemented to enable non-programmers to bind data sources to controls, then ease of operation is improved, but device complexity increases due to the need for automatic identification and matching mechanisms

Engineering Contradiction:
Improveease of binding data source to controlVSAvoidcomplexity of binding mechanism
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The system performs automatic binding without requiring user intervention in the matching process. The computing device automatically identifies properties of the compound control, associates data sources, determines suitable fields, and establishes bindings based on predefined criteria and transformation rules, allowing the system to serve itself in the binding process.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system pre-establishes transformation rules, property associations, and field mappings before the actual binding operation. By preparing the transformation framework and data source associations in advance, the system enables automated binding to occur smoothly when needed, without requiring complex real-time decision-making.

Inventive Principle:
Principle #10Preliminary action

2Adaptability or versatility

If automated binding with transformation consideration is implemented, then adaptability is improved by considering transformation nature, but difficulty of detecting and measuring increases due to need to analyze transformation properties

Engineering Contradiction:
Improveadaptability of binding to transformation natureVSAvoiddifficulty of analyzing transformation properties
Core Design Contradiction:
Adaptability or versatilityVSDifficulty of detecting and measuring

Solution Approach 1:

The system uses transformation rules as intermediaries between data sources and controls. These rules act as a mediating layer that translates data from various formats and structures into the required control input formats, enabling adaptable binding without requiring direct complex analysis of each data source-control pair.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system changes parameters such as data format, structure, and type through transformations to make data sources compatible with controls. By modifying data parameters rather than analyzing all possible compatibility scenarios, the system achieves adaptability while avoiding the complexity of comprehensive detection and measurement.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS10055396B2Binding of data source to compound control
Publication Date: 2018.08.21 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10055396B2 patent drawing
  • US10055396B2 patent drawing
  • US10055396B2 patent drawing

AI summary

The automated binding of a data source to a compound control. The properties of the compound control are identified. Furthermore, a particular data source is associated with the compound control. For each of one or more of the properties of the compound control, information regarding the compound control and the data source are used to identify a set of one or more fields of the particular data source that may be bound to the corresponding property of the compound control. If the corresponding property of the compound control has bound thereto an output parameter of a declarative transformation, the nature of the transformation may also be taken into consideration when identifying the set of one or more fields that may be used in order to bind to the corresponding property of the compound control.