Virtual Table Generator for BLOB Database Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for accessing binary large objects (BLOBs) in databases require multiple database access libraries for different versions, making it cumbersome to test and analyze data differences between versions.
Innovation Solution
A virtual table generator system that creates a virtual table from a BLOB by receiving a query, retrieving the BLOB, and using reflection to generate a table structure accessible via SQL, allowing for easier access across different database versions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If hard-coded virtual tables are created in a loadable SQLite module for each database version, then data access is simplified using SQL, but the system complexity increases as multiple SQLite modules are needed for different database versions
Solution Approach 1:
The patent creates a single universal SQLite module that can access multiple database versions through dynamic virtual table generation. Instead of having separate hard-coded modules for each database version, the system uses one module that dynamically creates virtual tables based on the database schema, allowing it to universally access different database versions without requiring multiple specialized modules.
Solution Approach 2:
The system dynamically generates virtual tables at runtime based on the database schema rather than having static hard-coded tables. The virtual table structure adapts dynamically to match the underlying database schema, allowing the same SQLite module to work with different database versions by generating appropriate virtual tables on demand.
2Adaptability or versatility
If the SQLite module is extended to support new database tables and columns, then compatibility with extended databases is improved, but the modification effort increases
Solution Approach 1:
The system automatically generates virtual tables by reading the database schema itself rather than requiring manual configuration. When a new database version or extended schema is introduced, the system self-adapts by detecting the new tables and columns through schema inspection and automatically creating corresponding virtual table structures, eliminating the need for manual module modifications.
Solution Approach 2:
The system performs preliminary schema inspection and virtual table generation before actual data access operations. By pre-generating the virtual table structure based on the database schema, the system prepares the access path in advance, allowing seamless adaptation to new database versions without requiring subsequent modifications to the SQLite module.
3Reliability
If multiple SQLite modules are maintained for different database versions, then access to each version is optimized, but the time required for testing and analysis increases
Solution Approach 1:
The patent merges the functionality of multiple version-specific SQLite modules into a single unified module. Instead of maintaining separate modules for different database versions, the system combines them into one module that handles all versions through dynamic virtual table generation, reducing the overhead of managing multiple modules and accelerating testing and analysis workflows.
Data Source
AI summary
A method and system for accessing database tables that contain binary large objects (BLOBs) is disclosed. The method includes encapsulating BLOB-based tables with virtual tables, which allows a user to access the content of the BLOBs via SQL. In one example, the virtual table has a generic table structure that consists of columns (e.g., class name, field name, and field value) and information regarding what level of an object hierarchy contains an element. In another example, a user can define the structure of the virtual table by identifying which object attributes to report.