Virtual Folder Mechanism for Unified File Access in RDBMS
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems lack a unified mechanism to access and manage files across different storage mechanisms, leading to increased resource utilization and security complexities due to the need for multiple access points with varying security policies.
Innovation Solution
The implementation of virtual folders within a file system repository allows files to be logically part of a hierarchical structure while being physically stored outside, enabling unified access and management through a centralized mechanism, using callback functions and virtual resource identifiers.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple storage mechanisms are used to store and access data, then data accessibility and storage flexibility are improved, but resource requirements and security complexity increase
Solution Approach 1:
The patent merges multiple storage mechanisms (file system and database) into a unified storage mechanism where the database server can access both database data and file system data through a single interface. This consolidation reduces security complexity by implementing a single security policy at the database server rather than managing multiple access points with different security requirements.
Solution Approach 2:
The database server is enhanced to provide universal access capabilities, allowing it to serve as a single access point for both database operations and file system operations. This multi-functionality enables the system to access diverse data types through one mechanism, improving adaptability while reducing the need for multiple specialized access points.
2Adaptability or versatility
If multiple access points are implemented for different storage mechanisms, then data accessibility is improved, but resource utilization increases
Solution Approach 1:
The patent combines multiple access points into a single database server access point that handles both database and file system operations. This merger eliminates redundant access infrastructure, reducing resource utilization while maintaining the ability to access diverse data types through the unified interface.
3Adaptability or versatility
If files are physically stored outside the file system repository, then storage flexibility and centralized management are improved, but access complexity increases
Solution Approach 1:
The database server acts as an intermediary between the client and files stored outside the file system repository. It receives file system operation protocol requests, translates them into appropriate database operations, and retrieves files from their external storage locations. This intermediary approach maintains storage flexibility while simplifying access for clients, as they interact with a single unified interface rather than directly managing complex external storage arrangements.
Data Source
AI summary
Techniques are provided for accessing and storing files within a virtual folder. A virtual folder is a folder that is logically a part of a hierarchical folder structure of a file system repository, but the contents of the virtual folder are not physically stored in the file system repository. A client may issue, to an access mechanism, a request to perform a file operation on a file in a virtual folder. The access mechanism, which may be a database server or a component therein, may perform the file operation on the file in the virtual folder as if the file was stored in a particular folder within the hierarchical folder structure implemented by the file system repository. Advantageously, files may be physically stored outside of the file system repository, but still be a part of the hierarchical folder structure implemented by the file system repository.