Static Data Access via Secondary Storage and Database Synchronization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Web-based applications experience slow data access speeds due to the need to establish connections with databases and additional processing time required for database organization, leading to undesirably long delays in processing transaction requests.

Innovation Solution

Storing static data in a secondary storage system, such as a file defined using a markup language, and synchronizing it with a database server at predetermined intervals, while maintaining the entire data set in the database server for faster access and reduced load on the database server.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Speed

If all data is stored and accessed from the database server, then data consistency and reliability are maintained, but data access speed decreases due to connection establishment and processing overhead

Engineering Contradiction:

Improvedata access speedVSAvoidsystem complexity

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

The patent segments data into two categories: static data and dynamic data. Static data is stored in a file system while dynamic data remains in the database server. This segmentation allows static data to be accessed quickly without database connection overhead, while dynamic data continues to benefit from database management, thus resolving the contradiction between access speed and system complexity.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent introduces an intermediary component (data access object or gateway) that manages connections between the application and both the file system and database server. This intermediary handles connection pooling, data synchronization, and routing requests appropriately, reducing the complexity burden while enabling fast access to static data.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Speed

If static data is stored in a file system for faster access, then data access speed improves, but data consistency and synchronization become more difficult to maintain

Engineering Contradiction:

Improvedata access speedVSAvoiddata consistency

Core Design Contradiction:

SpeedVSReliability

Solution Approach 1:

The patent implements periodic synchronization between the file system and database server. At predetermined intervals, the system synchronizes static data from the file system back to the database server, ensuring consistency is maintained while allowing fast access in between synchronization cycles.

Inventive Principle:

Principle #19Periodic action

Solution Approach 2:

The system incorporates feedback mechanisms where the data access object monitors changes in the database and triggers synchronization operations when needed. This feedback loop ensures that the file system copy remains consistent with the database server, maintaining reliability while enabling fast access speeds.

Inventive Principle:

Principle #23Feedback

Data Source

PatentUS8024380B2Improving data access speed while processing transaction requests from web based applications

Publication Date: 2011.09.20 ORACLE INT CORP

AI summary

Storing static data in a secondary storage and varying data in a database server. The static data can be stored in the database server also. In an embodiment, all the read/write requests related to the static data are sent to the secondary storage. Any updates to the static data are then propagated from the secondary storage to the database server at periodic intervals.