Database Object Dynamic Data Capture via Static-Dynamic Field Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems lack the ability to effectively capture and manage dynamic data sets where field requirements fluctuate across different data records, limiting their flexibility in modeling complex data structures.
Innovation Solution
A method and system that separate static and dynamic data fields, storing static data in standard fields and dynamic data in JSON format, allowing for flexible data structures and user-defined dynamic fields, enabling dynamic data capture and storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If standard database fields are used to store data, then data structure is simple and standardized, but the system cannot accommodate dynamic field requirements that fluctuate across different data records
Solution Approach 1:
The patent segments data fields into two distinct categories: static fields stored in traditional database tables and dynamic fields stored in JSON format. This segmentation allows the system to maintain standardized storage for common data while accommodating variable field requirements through the JSON structure, thereby resolving the contradiction between adaptability and structural simplicity.
Solution Approach 2:
The patent creates a composite data structure that combines traditional relational database fields with JSON document fields. This composite approach integrates the strengths of both structures—standardized querying capabilities of relational databases with the flexibility of JSON—enabling the system to handle both static and dynamic field requirements simultaneously.
2Adaptability or versatility
If dynamic fields are added to accommodate varying data requirements, then data modeling flexibility improves, but query complexity and system performance deteriorate
Solution Approach 1:
The patent applies local quality by allowing different parts of the data structure to have different properties. Static fields maintain standardized, optimized query performance, while dynamic fields in JSON provide flexibility where needed. This localized approach ensures that performance optimization is applied where it matters most while maintaining flexibility where required.
Solution Approach 2:
The patent introduces dynamics by allowing the data structure to adapt its form based on requirements. The JSON field can dynamically include or exclude fields based on specific data needs, enabling the system to optimize query performance by only including necessary dynamic fields rather than maintaining a fixed comprehensive structure.
3Productivity
If separate storage for static and dynamic fields is implemented, then data organization and retrieval efficiency improve, but system complexity increases
Solution Approach 1:
The patent implements a universal storage mechanism that handles both static and dynamic fields through a unified interface. The database system provides consistent data access methods regardless of whether the data is stored in traditional fields or JSON format, thereby improving retrieval efficiency without proportionally increasing system complexity.
Data Source
AI summary
A method and system for capturing dynamic data from data fields of a product has been developed. The method includes first collecting a product data set with multiple data fields. Static data fields of the product data set are identified that contain pre-defined standardized data for multiple other data sets. Next, dynamic data fields of the data set are identified. A dynamic data field is created by a user and contains additional data that is unique and applicable only to the product data set. The static data fields and the dynamic data fields are stored separately in a database repository for later recovery.