Hybrid Database Application for Mobile Data Access

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional database systems face inefficiencies when handling high query volumes and concurrent access, particularly on mobile devices, which can lead to slow data retrieval and display, especially when queries are complex.

Innovation Solution

Implementing a hybrid application that stores data locally on mobile devices while seamlessly accessing additional data from a server, using server activation objects to request and display new pages, thereby reducing the computational burden on mobile devices and enhancing data presentation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Speed

If data is accessed remotely from a database system using conventional query methods, then data can be retrieved from the system, but the retrieval speed becomes slow especially when query volume is high or multiple users access concurrently

Engineering Contradiction:

Improvedata retrieval speedVSAvoidsystem efficiency under high query volume

Core Design Contradiction:

SpeedVSProductivity

Solution Approach 1:

The system pre-identifies and pushes data that is likely to be needed to mobile devices before actual access occurs. The server proactively sends data based on predicted user needs, so when users access their devices, the data is already available locally, eliminating query delays.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The invention creates local copies of database data on mobile devices. Instead of repeatedly querying the remote database system, the mobile device stores replicated data locally, allowing instant access without network latency or server processing delays.

Inventive Principle:

Principle #26Copying

2Loss of information

If complex queries are processed by the database system to provide comprehensive data, then complete information is obtained, but the processing time increases significantly

Engineering Contradiction:

Improvecompleteness of dataVSAvoidquery processing time

Core Design Contradiction:

Loss of informationVSLoss of time

Solution Approach 1:

The system segments data into different categories and pushes only relevant segments to mobile devices based on user profiles and predicted needs. This divides the large database into manageable portions, allowing fast local access to frequently needed data while maintaining access to complete data on the server.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

Different quality levels of data are provided based on location and context. Mobile devices receive optimized local copies with sufficient detail for common operations, while the full-quality complete dataset remains on the server for complex operations that require comprehensive information.

Inventive Principle:

Principle #3Local quality

3Speed

If all data is stored locally on mobile devices to enable fast access, then data retrieval is quick, but the device memory requirements and data synchronization complexity increase

Engineering Contradiction:

Improvelocal data access speedVSAvoiddata management and synchronization complexity

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

The system extracts only the essential and frequently accessed data from the complete database and stores it locally on mobile devices. Less critical or rarely accessed data remains on the server, reducing local storage requirements while maintaining fast access to important information.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The server proactively pushes data to mobile devices in advance based on predicted user needs, eliminating the need for complex real-time synchronization protocols. Data is transferred beforehand, simplifying the synchronization mechanism while ensuring local availability.

Inventive Principle:

Principle #10Preliminary action

4Adaptability or versatility

If the database system processes queries for multiple users concurrently, then all users can access the system, but the overall system performance and response time deteriorate

Engineering Contradiction:

Improveconcurrent user access capabilityVSAvoidresponse time under concurrent access

Core Design Contradiction:

Adaptability or versatilityVSSpeed

Solution Approach 1:

The system segments user data and access patterns, allowing each user's mobile device to store and process their own data locally. This isolates user operations, so concurrent access by multiple users does not create server processing bottlenecks, as each user queries their own local copy rather than competing for server resources.

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS9535967B2Method and system for providing efficient and complex database functionality to a mobile device

Publication Date: 2017.01.03 SALESFORCE INC

AI summary

Methods, systems, and apparatus provide efficient and complex database functionality for an electronic device, e.g. a mobile device. These mechanisms and methods for providing efficient and complex database functionality to an electronic device can enable embodiments to provide quick access to certain data using a local application and seamless access within the local application to other data and complex presentation formats that are supplied by a server. The ability of embodiments to provide this hybrid functionality can enable users of the electronic devices to be more productive.