Heterogeneous Database Storage System for Structured and Unstructured Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems face performance degradation when handling structured and unstructured data, as they often require either relational databases for structured data and non-relational databases for unstructured data, leading to inefficiencies in data management and storage, especially for large volumes of unstructured data.
Innovation Solution
A heterogeneous database storage system that combines a relational database management system with a non-relational database management system on both magnetic and optical disk storage, allowing structured data to be stored in relational databases and unstructured data in non-relational databases, with a database connector to form integral records, optimizing data integrity and storage capacity.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If all structured and unstructured data are stored in a non-relational database, then data storage flexibility and capacity are improved, but data processing efficiency and query performance deteriorate
Solution Approach 1:
The patent segments data into structured and unstructured components, storing structured data in relational database tables and unstructured data in non-relational database collections. This segmentation allows each data type to be processed by the most appropriate database engine, maintaining query efficiency for structured data while providing flexibility for unstructured data storage.
Solution Approach 2:
The patent merges relational and non-relational database systems into a unified heterogeneous database system with a common query interface. This merging allows the system to leverage the strengths of both database types simultaneously, providing both processing efficiency and storage flexibility through a single integrated platform.
2Reliability
If unstructured data is stored in BLOB fields of relational database, then data integrity is improved, but storage capacity and performance deteriorate when dealing with large volumes of unstructured data
Solution Approach 1:
The patent extracts unstructured data from BLOB fields in the relational database and stores it separately in the non-relational database portion of the heterogeneous system. This extraction maintains the integrity of structured data in relational tables while providing ample storage capacity for large volumes of unstructured data through files and binary data storage in the non-relational component.
3Device complexity
If a single database type is used for both structured and unstructured data, then system complexity is reduced, but data management efficiency and security deteriorate
Solution Approach 1:
The patent creates a universal heterogeneous database system that can handle both structured and unstructured data through a unified interface. This multi-functional system provides different storage and processing optimizations for different data types while presenting a consistent interface to users, thereby improving data management efficiency without significantly increasing perceived system complexity.
Data Source
AI summary
A heterogeneous database storage system based on optical disk includes a magnetic disk storage device and an optical disk storage device connecting, via a data connection, to a server. A relational database management system, a non-relational database management system, a data processor and a database connector are installed on the server. Fields of a record are divided into two parts by the data processor. A part of the fields are in a relational database, and the other part of the fields are in a non-relational database. Fields of the relational database constitute a subrecord of the relational database, and Fields of the non-relational database constitute a subrecord of the non-relational database. The subrecord of the relation database and the corresponding subrecord of the non-relational database form an integral record by the database connector.