Dual Database System for Embedded Multimedia Scanning
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing multimedia service databases on embedded devices face issues with data reliability and scanning efficiency, as they require frequent re-scanning and re-creation upon power-off, leading to user experience degradation and potential data loss.
Innovation Solution
Implementing a dual-database system using a RAM-DB for high-speed data processing and a BAK-DB for backup, ensuring data persistence and reliability by periodically backing up data and resuming scans from the BAK-DB in case of interruptions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If a memory file system is used to store the media service database, then the database can be easily created and managed, but the database is lost when the device is powered off, requiring re-creation and re-scanning
Solution Approach 1:
The patent creates a backup database (BAK-DB) that copies the structure and data of the main media service database. This backup is stored in external storage and persists across power cycles, allowing the system to restore database data without re-scanning files after device restart.
2Reliability
If the media service database is re-created after power-off, then data persistence is maintained, but scanning time increases significantly, affecting user experience
Solution Approach 1:
The system performs preliminary actions by maintaining a backup database that contains directory information extracted in advance. When the device restarts, the system restores from the backup rather than performing complete re-scanning, significantly reducing the time required to make multimedia files available for playback.
Solution Approach 2:
The patent discards the need for complete re-scanning by recovering directory information from the backup database. This allows the system to retain valuable scanning results across power cycles while avoiding the time-consuming re-extraction of directory information from multimedia files.
3Reliability
If external storage device is used to store media database, then data persistence is improved, but read-and-write performance deteriorates, affecting service response speed
Solution Approach 1:
The patent segments the database into two parts: a main database stored in external storage for persistence and a backup database that serves as a recovery mechanism. This segmentation allows the system to maintain data persistence while using the backup for rapid restoration without requiring high-speed read-and-write operations from external storage during normal operation.
4Use of energy by moving object
If the scanning process is interrupted, then power consumption is reduced, but data integrity may be compromised, causing program exceptions
Solution Approach 1:
The patent implements beforehand cushioning by creating a backup database that cushions against the risks of scanning interruptions. If the scanning process is interrupted or the device is powered off during scanning, the backup database ensures that directory information is not lost, preventing program exceptions and maintaining data integrity without requiring continuous scanning operations.
Data Source
AI summary
The present invention discloses a method and a device for inputting data in a multimedia service database on an embedded device. The method includes: when multimedia file scanning is performed, storing generated directory information of a multimedia file in a random access memory database (RAM-DB), and performing a RAM-DB to backup database (BAK-DB) data backup operation in a scanning process; and if an interruption occurs in the scanning process, and when the scanning continues after the scanning interruption ends, copying data in the BAK-DB to the RAM-DB, and continuing to scan, according to existing data in the RAM-DB, a multimedia file that is not scanned. In the present invention, two database files RAM-DB and BAK-DB are configured in a multimedia service system.