Dynamic Table Creation for Electronic Form Data Storage
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data storage systems require pre-defined table and field mapping for electronic forms, limiting flexibility and compatibility with different storage formats and locations, and necessitating administrator dependence on final storage destinations.
Innovation Solution
A method and system that dynamically create or modify tables and field types in a storage location based on the data types received from electronic forms, using a form inspection unit and storage modification unit to identify and adapt to the appropriate storage format, allowing data to be stored in various formats and locations without prior configuration.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If pre-defined table and field mapping is used for data storage, then data storage structure is stable and reliable, but flexibility and compatibility with different storage formats and locations are limited
Solution Approach 1:
The patent implements dynamic table creation and modification capabilities that allow the storage system to automatically adapt its structure based on incoming data types. The system transitions from static pre-defined mappings to dynamic structure generation, enabling flexible accommodation of different storage formats and locations without requiring administrator reconfiguration for each destination.
Solution Approach 2:
The system performs self-configuration by automatically creating appropriate table structures and field mappings based on the data being stored. Instead of requiring administrators to manually configure storage destinations, the system autonomously inspects incoming data forms and generates the necessary storage structure, eliminating administrator dependence on storage destination configuration.
2Productivity
If pre-configured storage locations are used, then data storage is reliable and consistent, but real-time changes during data collection are not allowed
Solution Approach 1:
The patent enables dynamic modification of storage locations and table structures during the data collection process. The system can add, modify, or remove storage destinations and their corresponding table structures in real-time based on changing requirements, while maintaining data consistency through structured modification processes that preserve existing data integrity.
3Adaptability or versatility
If fixed field types are defined in advance, then data storage structure is stable, but compatibility with different data types is limited
Solution Approach 1:
The system automatically inspects incoming data forms to identify data types and dynamically creates corresponding field types and table structures. This self-service approach eliminates the need for pre-configuration of field types for all possible data scenarios, allowing the system to adapt to different data types automatically while reducing configuration complexity.
Solution Approach 2:
The patent implements a universal storage system that can handle multiple data types through a single dynamic configuration mechanism. The system creates appropriate field types and table structures based on the specific data being stored, making the storage system universally compatible with various data types without requiring separate configurations for each type.
Data Source
AI summary
Methods, systems, and apparatus for dynamically creating tables to store received data. A form that includes data of one or more data types is received. Each of the data types is associated with a corresponding field type. The data types in the form are identified, and a storage location configured to store data of the field-type is accessed. Field types in the storage location are compared with those of the received data, and on determining that a portion of the data is of a data type that the storage location is not configured to store, the storage location is modified to store that portion of the data.