Database Accessors for Conditional Compound Field Selection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems lack the capability to effectively conditionally select compound fields from structured objects, resulting in the return of primitive representations instead of data in multiple columns, due to a lack of handling mechanisms.
Innovation Solution
The system generates accessors for compound fields associated with structured objects that satisfy specific conditions, allowing for the conditional selection and retrieval of data elements, including metadata for data types, and outputs these accessors as part of the query results, enabling users to access the data elements.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If the database system returns primitive representations for compound fields, then the system maintains simplicity in handling data, but the user cannot access the actual data elements in multiple columns
Solution Approach 1:
The patent introduces an intermediary mechanism that generates accessors as mediators between the database system and compound fields. These accessors act as bridges that enable users to access compound field data elements without requiring the database system to fundamentally change its handling of compound fields, thus resolving the contradiction between data accessibility and system complexity
Solution Approach 2:
The patent segments the compound field access problem by generating individual accessors for each data element within a compound field. This segmentation allows users to access specific columns (street, city, state, zip) independently while the database system maintains its原有 structure, balancing accessibility needs with system simplicity
2Adaptability or versatility
If the system generates accessors for compound fields dynamically, then users can access compound field data elements, but the system complexity increases due to the need for dynamic accessor generation
Solution Approach 1:
The patent applies preliminary action by pre-generating accessors for compound fields before query execution. The system identifies compound fields in the query result set and generates corresponding accessors in advance, which simplifies the query processing during actual execution and reduces the computational complexity at query time
Solution Approach 2:
The patent implements dynamics by making the accessor generation process adaptive to the specific query and result set. The system dynamically determines which compound fields require accessors based on the query conditions and result structure, allowing the system to handle compound field access flexibly without maintaining fixed complex structures for all possible scenarios
Data Source
AI summary
Embodiments regard conditional selection of compound fields of structured objects. An embodiment of a method for conditionally selecting compound fields from structured objects includes: receiving a query at a database system to select a compound field from any structured object that satisfies a condition; determining by the database system whether a structured object stored in a database satisfies the condition; generating automatically by the database system a plurality of accessors that correspond to a plurality of columns in the compound field associated with the structured object in response to a determination that the structured object satisfies the condition; and providing a result of the query, the result including the plurality of accessors.