Mobile Database Subset Management for Offline Analysis

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Mobile devices face limitations in processing and memory capacity, making it difficult to handle large data sets and perform real-time data analyses efficiently, especially when connected wirelessly to enterprise databases.

Innovation Solution

A method where a database management system receives requests from mobile devices to transmit subsets of data for local storage, based on user identity and device characteristics, allowing for efficient database operations and updates, and prioritizing data based on usage patterns and connection types.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If large data sets are loaded into mobile device memory, then data analysis capability is improved, but memory capacity and processing ability are exceeded

Engineering Contradiction:

Improvedata analysis capabilityVSAvoidmemory capacity

Core Design Contradiction:

ProductivityVSQuantity of substance

Solution Approach 1:

The patent segments the database into multiple data marts based on subject matter (e.g., customer data mart, product data mart). Each data mart contains only the data relevant to specific analytical purposes, reducing the overall data volume that needs to be loaded into mobile device memory while maintaining data analysis capability.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent extracts only the necessary subset of data from the enterprise database to be loaded onto the mobile device. The data extraction process identifies and retrieves only the relevant data elements needed for specific analytical tasks, leaving the remainder in the centralized database.

Inventive Principle:

Principle #2Taking out (Extraction)

2Speed

If real-time data access is implemented on mobile devices, then decision-making speed is improved, but network dependency and connectivity requirements increase

Engineering Contradiction:

Improvedecision-making speedVSAvoidnetwork connectivity requirements

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

The patent implements preliminary action by pre-loading relevant data subsets from the enterprise database into the mobile device's local storage before the user needs them. This allows the mobile device to perform data analyses offline without requiring real-time network connectivity, while still providing timely decision-making capability.

Inventive Principle:

Principle #10Preliminary action

3Loss of information

If complete data sets are transmitted to mobile devices, then data availability is improved, but data transmission time and network bandwidth consumption increase

Engineering Contradiction:

Improvedata availabilityVSAvoiddata transmission time

Core Design Contradiction:

Loss of informationVSLoss of time

Solution Approach 1:

The patent applies local quality by customizing the data subset for each mobile device based on user-specific factors such as user role, department, analytical needs, and device capabilities. Each user receives a tailored data subset that contains only the information relevant to their specific analytical requirements, optimizing both data availability and transmission efficiency.

Inventive Principle:

Principle #3Local quality

Data Source

PatentUS10394805B2Database management for mobile devices

Publication Date: 2019.08.27 SAP SE

AI summary

Storing a subset of a database on a mobile device. The subset of the database stored on the mobile device being based on privilege information associated with the mobile device and/or a user of the mobile device. One of more mobile applications can access the subset of the database stored on the mobile device when the mobile device is offline and unconnected to a database management system associated with the database. A set of queries can be performed on the subset of the database stored on the mobile device.