Backup Server for In-Memory Database Archiving
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database management systems face challenges in efficiently backing up in-memory databases, as traditional backup solutions are not optimized for zero-disk footprint databases, leading to performance issues and a lack of effective data archiving mechanisms.
Innovation Solution
A system and method are introduced that utilize a Backup Server to perform backup operations for in-memory databases by determining if the database is in-memory and using database server connections during data access, allowing for efficient data archiving and restoration without the need for disk storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional disk-based backup solutions are used for in-memory databases, then data backup functionality is provided, but database performance deteriorates due to disk I/O overhead
Solution Approach 1:
The patent extracts the backup functionality from the main database server by introducing a separate backup server that connects to the in-memory database through database server connections. This separation allows backup operations to occur without interfering with the performance of the primary database operations, as the backup server accesses data through the same in-memory interface without requiring disk I/O during active database operations.
Solution Approach 2:
The backup server acts as an intermediary component between the in-memory database and the backup storage system. It establishes database server connections to access the in-memory database and handles all backup operations, serving as a mediator that enables backup functionality without requiring the primary database server to directly interface with disk-based backup systems.
2Reliability
If disk-based storage is used for data archiving, then data persistence is achieved, but storage overhead and access time increase
Solution Approach 1:
The patent replaces the mechanical disk-based storage system with an in-memory storage mechanism for the database operations. By using database server connections to access data in memory rather than reading from disk, the system eliminates the mechanical I/O bottleneck while maintaining data persistence capabilities through structured backup operations.
3Productivity
If in-memory database operations are performed without disk storage, then database performance is improved, but data backup capability is lost
Solution Approach 1:
The backup server is designed with multi-functionality, serving both as a connection interface to the in-memory database and as a backup storage management system. It can handle multiple backup operations simultaneously and provides comprehensive backup capabilities including full backups, incremental backups, and restoration operations, all while maintaining the in-memory architecture's performance benefits.
Data Source
AI summary
System, method, computer program product embodiments and combinations and sub-combinations thereof for backing up an in-memory database. In an embodiment, a backup server is provided to perform backup operations of a database on behalf of a database server. A determination is made as to whether the database is an in-memory database. Database server connections are utilized during data accesses for the backup operations when the database is an in-memory database.