Database On-Demand Data Retrieval Segmentation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems face inefficiencies and increased resource usage when processing large information requests from users, leading to decreased system performance and availability for other users during data retrieval operations.

Innovation Solution

Implementing an on-demand data retrieval method where the database provides data in page format, allowing users to request and receive only a subset of data at a time, reducing the load on the system and enabling simultaneous access for multiple users.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If the database processes large quantities of information requests from users, then the information can be retrieved, but system resources are considerably consumed and system performance decreases

Engineering Contradiction:

Improveinformation retrievalVSAvoidsystem performance

Core Design Contradiction:

Loss of informationVSProductivity

Solution Approach 1:

The patent segments large information requests into smaller manageable units, allowing the database to process and retrieve information in controlled portions rather than as monolithic blocks, thereby reducing resource consumption while maintaining retrieval capability

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The database implements partial action by processing only the necessary portion of large information requests at any given time, rather than processing the entire request simultaneously, which optimizes resource usage and maintains system performance

Inventive Principle:

Principle #16Partial or excessive action

2Loss of information

If the database processes large information requests, then data can be provided to users, but system downtime increases and availability for other users decreases

Engineering Contradiction:

Improvedata provisionVSAvoidsystem availability

Core Design Contradiction:

Loss of informationVSReliability

Solution Approach 1:

By segmenting large data provision operations into smaller transactions, the database can serve multiple users concurrently with reduced lock times and improved system availability, while still providing complete data to each user across multiple operations

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The database employs periodic action by breaking down continuous large data requests into discrete time-bound operations, allowing other users to access the system in between operations and improving overall system availability

Inventive Principle:

Principle #19Periodic action

3Ease of operation

If the database retrieves large quantities of information, then user requests are fulfilled, but resource usage increases and efficiency decreases

Engineering Contradiction:

Improveuser request fulfillmentVSAvoidresource usage

Core Design Contradiction:

Ease of operationVSUse of energy by moving object

Solution Approach 1:

The database performs partial action by retrieving only the necessary subset of data required to fulfill user requests at each operation, rather than retrieving entire datasets, which reduces resource usage while maintaining ease of operation for users

Inventive Principle:

Principle #16Partial or excessive action

Data Source

PatentUS11403366B2On-demand retrieval of information from databases

Publication Date: 2022.08.02 HEWLETT PACKARD ENTERPRISE DEV LP

AI summary

Methods of providing data to a user including receiving a page request from the user for a database to provide a sub-set of data from a dataset. The method further including sending a publish request from the database to a publisher, publishing the dataset from the publisher to the database, preparing the sub-set of data in the page request in the database, and sending the sub-set of data in the page request to the user.