Online Table Formula Instance Memory Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
As the number of formulas in online tables increases, they consume more memory, leading to webpage crashes due to out-of-memory issues, especially since many formulas are copies of the same type and share similar features, causing inefficient use of memory space.
Innovation Solution
A table processing method that determines a target formula key and creates a formula instance referencing a pre-created object reference pool, which stores correspondence relationships between formula keys and storage objects, reducing memory occupation by reusing instance attributes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If each formula creates a corresponding formula instance in memory, then the formula can be calculated, but the memory space is excessively occupied leading to webpage crashes
Solution Approach 1:
The patent merges multiple formula instances that share common attributes by creating a shared storage object in memory. When a formula is created, the system checks if a storage object with matching attributes already exists. If found, the new formula instance references the existing storage object instead of creating a duplicate, thereby consolidating memory usage and preventing excessive memory occupation that leads to webpage crashes.
Solution Approach 2:
The patent uses reference copying instead of deep copying for formula instances. When a formula instance needs to be created, rather than duplicating all its attributes and data structures, the system creates a lightweight reference to the shared storage object. This allows multiple formula instances to share the same underlying data without duplicating memory consumption, significantly reducing overall memory usage while maintaining full functionality.
2Adaptability or versatility
If many formulas are copied with similar features, then formula functionality is maintained, but memory space usage becomes inefficient
Solution Approach 1:
The patent implements universality by creating a shared storage object that can be referenced by multiple formula instances. The storage object contains the common attributes and data structures that are universally applicable across different formulas. This allows a single storage object to serve multiple purposes and support various formula instances, improving memory space efficiency while maintaining full formula functionality and adaptability.
Solution Approach 2:
The patent employs reference copying to enable efficient formula reuse. Instead of creating independent copies of formula data structures, the system creates lightweight references that point to the shared storage object. This approach maintains formula adaptability and reusability while avoiding redundant memory allocation, as all formula instances that share common features automatically benefit from the shared storage object without additional memory overhead.
Data Source
AI summary
Embodiments of the present application relate to a table processing method, apparatus, device, storage medium and program product. The method comprises: in response to creating a target formula in an online table, determining a target formula key corresponding to the target formula; and creating a formula instance based on the target formula key, wherein a target instance attribute comprised in the formula instance references a target storage object in a pre-created object reference pool, the object reference pool comprises correspondence relationships between formula keys and storage objects, the target storage object is a storage object having a correspondence with the target formula key, and the formula instance is for calculating the target formula. Some instance attributes comprised in the formula instance created in the embodiments of the present disclosure reference storage objects, thereby reducing the occupation of the memory space.