Database External Content Storage via Metadata Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems are limited in their ability to store rich text, files, and images due to size constraints, making it difficult to manage and access these types of content within the database system.
Innovation Solution
A method is provided to access content stored outside the database system by receiving content, storing it in a file server, and storing metadata referencing its location in the database, allowing for retrieval and management of the content without storing it within the database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If content is stored directly in the database system, then data integrity and query efficiency are improved, but storage capacity is limited due to size constraints on fields
Solution Approach 1:
The system divides data into two segments: metadata (stored in the database) and content (stored externally in a file system). This segmentation allows the database to maintain its integrity and query efficiency while the file system handles large content storage, thereby increasing overall storage capacity without compromising database performance.
Solution Approach 2:
The patent extracts large content data from the database system and stores it in an external file system, keeping only metadata references in the database. This extraction resolves the storage capacity limitation while maintaining database query efficiency, as the database only needs to manage relatively small metadata records.
2Adaptability or versatility
If metadata referencing external content is stored in the database, then access to large content is enabled, but data security and integrity management become more complex
Solution Approach 1:
The system implements feedback mechanisms where the database maintains metadata that references external content, and the application server coordinates between the database and file system to ensure data integrity. This feedback loop allows the system to track and manage external content references, maintaining reliability despite the distributed storage architecture.
Data Source
AI summary
In accordance with embodiments, there are provided mechanisms and methods for using a database to access content stored outside of the database. These mechanisms and methods for using a database to access content stored outside of the database can enable embodiments to provide a database system which can be used to access content when the content is incapable of being stored in the database system, or is otherwise not stored in the database system. The ability of embodiments to provide access to such data via the database system can improve the usability of the database system.