Multi-tenant Database Formula Field Customization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems become inefficient when changes to formulas are not handled properly, leading to slow query processing due to concurrent changes in calculated values by multiple users.
Innovation Solution
Implementing mechanisms to customize standard formula fields in a multi-tenant database system by allowing users to modify or provide custom formulas for standard database fields, storing the calculated values, and maintaining them over a specified date range to ensure consistent application and reduce on-the-fly calculations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If conventional database systems process queries with calculated values, then data retrieval can be performed, but query processing becomes slow when multiple users concurrently change calculated values
Solution Approach 1:
The system pre-calculates and stores formula results in the database before they are needed for queries. When users concurrently modify calculated values, the system uses versioning and timestamps to manage these changes, ensuring that each user's modifications are processed correctly without causing query slowdowns. This preliminary storage of calculated values eliminates the need for repeated real-time calculations during query processing.
Solution Approach 2:
The patent introduces an intermediary layer between data storage and query processing that manages formula calculations separately. This intermediary handles the complexity of concurrent formula changes by using version control mechanisms and change logs, allowing the main query processing to remain fast while still accurately reflecting the latest calculated values even when multiple users are modifying data simultaneously.
2Measurement precision
If standard formula fields are used in multi-tenant databases, then data can be retrieved, but accurate information retrieval is compromised when formulas are not properly customized
Solution Approach 1:
The system allows different tenants to have customized formula definitions for the same standard database fields. Each tenant can define their own specific calculations for fields like total price or tax amounts, while other tenants continue using the standard formulas. This local customization ensures that each tenant receives accurate information according to their specific business rules, while the overall system maintains the benefit of standardized data structures across all tenants.
Data Source
AI summary
In a method, system, and computer-readable medium having instructions for customizing standard formula fields, at least a portion of a formula is received for a standard database field of a standard database entity in a multi-tenant database and the standard database entity is used by a plurality of tenants, a date range is stored for maintaining at least the portion of the formula, information on one or more variables of the formula is received, a value is calculated for the standard database field with at least the portion of the formula and information on the one or more variables of the formula and one or more database entities depend on the value for the standard database field, and the value is stored for the standard database field.