Client-Side Query Transformation for Cross-Platform Mobile Extensions

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing cloud-based database systems face challenges in providing customizable user experiences across different mobile device operating systems, requiring separate solutions for each combination of operating system and application configuration, which increases complexity and overhead.

Innovation Solution

A client-side cross-platform service that integrates with native applications and application extensions, abstracting underlying details to support CRUD operations and GUI displays, enabling offline operation and standardizing interactions across diverse operating systems and configurations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If separate solutions are created for each combination of operating system and application configuration, then compatibility across different mobile devices is improved, but system complexity and development overhead increase

Engineering Contradiction:
Improvecompatibility across different mobile devicesVSAvoidsystem complexity and development overhead
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements a universal data service layer that provides consistent CRUD operations and data access patterns across all mobile devices regardless of operating system or application configuration. This service layer abstracts the underlying platform differences, allowing a single codebase to serve multiple platforms without requiring separate solutions for each OS-app configuration combination.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent introduces a cross-platform service as an intermediary component between the native application and the database system. This service layer mediates all data access operations, transforming platform-specific requirements into standardized database operations. The intermediary handles OS-specific variations internally while presenting a uniform interface to the application, thereby reducing complexity without sacrificing compatibility.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If custom extensions are integrated with the mobile application, then user experience customization is improved, but the layer of complexity between the cloud-based data system and the end user increases

Engineering Contradiction:
Improveuser experience customizationVSAvoidlayer of complexity between cloud-based data system and end user
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the application architecture into distinct layers: the core data service layer handling standardized CRUD operations, and an extension layer for custom functionality. This segmentation allows custom extensions to be added without affecting the core data access patterns. The service layer remains simple and standardized while extensions provide customization, preventing complexity from propagating throughout the entire system.

Inventive Principle:
Principle #1Segmentation

3Speed

If data retrieval and customization operations are performed directly by the mobile application, then operation speed is improved, but consistency across different operating systems deteriorates

Engineering Contradiction:
Improveoperation speedVSAvoidconsistency across different operating systems
Core Design Contradiction:
SpeedVSStability of the object's composition

Solution Approach 1:

The patent changes the operational parameters by implementing a standardized service interface that maintains consistent data access patterns across all platforms. The service layer handles platform-specific optimizations internally while maintaining uniform behavior externally. This allows operations to execute efficiently on each platform while preserving consistency through standardized parameters and protocols at the service layer.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS12353411B2Database systems and client-side query transformation methods
Publication Date: 2025.07.08 SALESFORCE INC
  • US12353411B2 patent drawing
  • US12353411B2 patent drawing
  • US12353411B2 patent drawing

AI summary

Database systems and methods are provided for providing record data to an application extension associated with a native application at a client device. One method involves a cross-platform service receiving, from the native application, a query for record data associated with a record at a database system on behalf of the application extension, determining a data source for retrieving the record data based at least in part on a configuration of the native application, converting the query into a transformed query having a different format associated with the identified data source, retrieving the record data from the identified data source using the transformed query, and providing the record data to the application extension via the native application, wherein the application extension is configurable to generate a component of a graphical user interface display using the record data.