Cross-Object Formula Storage for Database Validation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems restrict access to data using formulas to only the currently accessed object type, limiting users' ability to access additional database contents for validations and calculations.
Innovation Solution
Implementing mechanisms and methods to store formulas with first and second object fields, allowing access to related object types by using a formula with the first object field as an operand and the second object field, enabling cross-object references and calculations across multiple objects.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If formulas are restricted to access only the current object type, then system simplicity is maintained, but data accessibility and user capability are severely limited
Solution Approach 1:
The formula structure is segmented into distinct components: object identifier, field identifier, and operator. This segmentation allows the formula parser to systematically handle cross-object references by first identifying the target object, then accessing its fields, while maintaining clear separation between object-level and field-level operations.
Solution Approach 2:
An object identifier serves as an intermediary element between the current object context and the target object fields. The formula parser uses this intermediary to resolve cross-object references by translating object identifiers into accessible field paths, enabling indirect access to related object data without direct object instantiation.
2Ease of operation
If cross-object formula fields are implemented, then user capability to access additional database contents is improved, but system complexity increases
Solution Approach 1:
The formula parser is designed with universal functionality to handle both current object field references and cross-object field references using the same syntax structure. The parser automatically detects whether a field reference belongs to the current object or requires object identifier resolution, providing a unified interface that simplifies user operation while managing complexity internally.
Solution Approach 2:
The formula evaluation mechanism performs self-service by automatically resolving object identifiers to their corresponding field paths during formula parsing. The system autonomously manages the complexity of cross-object references by implementing built-in resolution logic that translates high-level object identifiers into low-level field access operations without requiring additional user intervention.
3Productivity
If formulas access data from multiple object types, then validation and calculation capabilities are enhanced, but database performance may deteriorate
Solution Approach 1:
Object identifiers and their corresponding field paths are pre-resolved and cached during the formula parsing phase, before actual data access occurs. This preliminary action creates a optimized access plan that identifies all required fields from target objects, allowing the system to efficiently retrieve data in a single operation rather than performing multiple sequential lookups during formula evaluation.
Solution Approach 2:
The system optimizes data access by selectively retrieving only the specific fields required by the formula from target objects, rather than loading entire objects or unnecessary data. This local quality approach ensures that formula evaluations access minimal necessary data, maintaining database performance while enabling cross-object validations and calculations.
Data Source
AI summary
In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.