Composite Shapes Engine for Cross-Datasource Querying

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current methods require customized program code to combine data from multiple datasources, making it difficult for applications to retrieve and process data across different datastores without standardized capabilities.

Innovation Solution

The use of composite shapes that identify multiple datasources and perform queries across them, allowing data to be retrieved and shaped as if it comes from a single datasource, using a composite shapes engine that manages query generation and execution optimizations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If customized program code is used to combine data from multiple datasources, then data retrieval across datasources is achieved, but system complexity and development difficulty increase

Engineering Contradiction:

Improvedata retrieval capabilityVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system segments the complex task of cross-datasource querying into reusable shape templates. Each shape represents a standardized query pattern that can be independently defined and then combined through composition, eliminating the need for custom code for each querying scenario.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent creates universal shape templates that can serve multiple purposes. A single shape definition can be reused across different composite shapes and applications, providing a multi-functional solution that reduces overall system complexity while maintaining versatile data retrieval capabilities.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If customized program code is written for each data combination scenario, then specific data retrieval needs are met, but ease of operation decreases

Engineering Contradiction:

Improvedata combination capabilityVSAvoidoperation simplicity

Core Design Contradiction:

Adaptability or versatilityVSEase of operation

Solution Approach 1:

The system performs preliminary action by pre-defining shape templates with common query patterns and data transformation logic. These templates are prepared in advance and can be easily composed together, eliminating the need for operators to write custom code for each scenario and significantly improving ease of operation.

Inventive Principle:

Principle #10Preliminary action

3Adaptability or versatility

If data is retrieved from multiple datasources separately and then combined, then data from different sources is obtained, but processing time increases

Engineering Contradiction:

Improvecross-datasource accessVSAvoiddata processing time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent merges multiple shape queries into a single composite shape execution. By combining separate data retrieval operations into one coordinated execution, the system reduces processing time while maintaining the ability to access data from multiple datasources simultaneously.

Inventive Principle:

Principle #5Merging (Combining)

Data Source

PatentUS11561974B2Cross-datasource querying using composite shapes

Publication Date: 2023.01.24 ADP INC

AI summary

A system and method of performing a cross-datasource query to provide a cross-datasource query result. A composite shape comprises a composite shape query and a plurality of shape identifiers identifying a plurality of shapes. Each of the plurality of shapes comprises a datasource identifier identifying a datasource and a shape query defining a query to be performed on the datasource. The composite shape is used to perform the composite shape query across the datasources identified in the plurality of shapes to provide the cross-datasource query result.