US 12,443,640 B1
Database document visualization and manipulation engine apparatuses, methods, systems and media
Ido Pesok, Irvine, CA (US); Sarah Walker, Palo Alto, CA (US); and Justin Ito, Lynden, WA (US)
Assigned to Sequoia Port Inc, Irvine, CA (US)
Filed by Sequoia Port, Inc, Irvine, CA (US)
Filed on Aug. 14, 2023, as Appl. No. 18/449,247.
Claims priority of provisional application 63/400,739, filed on Aug. 24, 2022.
Int. Cl. G06F 7/00 (2006.01); G06F 3/04815 (2022.01); G06F 3/04845 (2022.01); G06F 3/0486 (2013.01); G06F 16/31 (2019.01); G06F 16/34 (2019.01)
CPC G06F 16/34 (2019.01) [G06F 3/04815 (2013.01); G06F 3/04845 (2013.01); G06F 3/0486 (2013.01); G06F 16/316 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A database document visualization and manipulation apparatus, comprising:
at least one memory;
at least one processor in communication with the at least one memory, the at least one processor configured to execute processing instructions stored in the at least one memory, in which the at least one processor executes processor-executable instructions to:
obtain, via the at least one processor, a user interaction command via an interface interaction mechanism associated with a viewer interface element having a set height bound, in which the viewer interface element is structured to display page data associated with a buffered subset of page nodes that fit within the set height bound from a virtual pixel space comprising the buffered subset of page nodes and a not buffered subset of page nodes, in which the virtual pixel space is defined by a virtual pixel space data structure comprising pixel range data for a set of page nodes that satisfy filter parameters of a view;
determine, via the at least one processor, a virtual scroll space position associated with the interface interaction mechanism resulting from the user interaction command;
query, via the at least one processor, the virtual pixel space data structure to determine a virtual pixel space position corresponding to the virtual scroll space position, in which the virtual pixel space data structure specifies a pixel range associated with each page node in the set of page nodes;
determine, via the at least one processor, that the virtual pixel space position indicates that a buffer update threshold associated with the viewer interface element has been exceeded;
query, via the at least one processor, the virtual pixel space data structure to determine a subset from the set of page nodes to utilize as the buffered subset of page nodes based on a combination of: the virtual pixel space position, pixel ranges associated with page nodes in the set of page nodes, and the set height bound associated with the viewer interface element; and
load, via the at least one processor, page data corresponding to the buffered subset of page nodes into the viewer interface element.