Colin J Florendo, 52Marlboro, MA

2013011, May 9, 2013

Nov 8, 2011

13/291157

Colin Joseph FLORENDO - Marlborough MA, US

Sybase, Inc. - Dublin CA

G06F 12/02

711171, 711E12002

System, method, computer program product embodiments and combinations and sub-combinations thereof for temporary storage management in a shared disk database cluster are provided. Included is the reserving of units on-demand and of variable size from shared temporary storage space in the SDC. The utilization of the reserved units of the shared temporary storage space is tracked, and the shared temporary storage space is administered based on the tracking.

2013011, May 9, 2013

Dec 2, 2011

13/309603

Surendra Kumar VISHNOI - Jodhpur Rajasthan, IN
Colin FLORENDO - Marlborough MA, US

Sybase, Inc. - Dublin CA

G06F 17/30

707770, 707E17007, 707E17032, 707E17014

System, method, computer program product embodiments and combinations and sub-combinations thereof for snapshot isolation support for distributed query processing in a shared disk database cluster are provided. The embodiments include the forming of object identification data in a leader node of query execution in the shared disk database cluster. At least one fragment of the query execution is distributed to at least one worker node in the shared disk database cluster, and the object identification data is utilized for multiversion concurrency control during query execution by the leader node and at least one worker node.

2022020, Jun 30, 2022

Mar 21, 2022

17/699747

- Walldorf, DE
Colin FLORENDO - Marlborough MA, US
Robert SCHULZE - Walldorf, DE
Zheng-wei SHE - Shanghai, CN
Yanhong WANG - Dublin CA, US
Amarnadh Sai ELURI - Mountain House CA, US

G06F 16/21
G06F 16/22
G06N 5/04

System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

2023001, Jan 12, 2023

Sep 14, 2022

17/944610

- Walldorf, DE
Simhachala Sasikanth Gottapu - Dublin NC, US
Sarika Iyer - San Ramon CA, US
Prasanta Ghosh - San Ramon CA, US
Colin Florendo - Marlborough MA, US

G06F 3/06

Disclosed herein are system, method, and computer program product embodiments for adaptive caching for hybrid columnar databases with heterogeneous page sizes. An embodiment operates by scanning one or more pools comprising one or more pages of the same size in a buffer cache. The embodiment determines an increment of a reuse rate for the pools in the buffer cache within a time interval. The embodiment determines a cumulative reuse rate that is the sum of the increments of the reuse rate over several time intervals. The embodiment determines a gliding average reuse rate of the cumulative reuse rate over several time intervals. The embodiment compares the average reuse rates of the plurality of the pools to a threshold to dynamically determine whether a pool should reuse memory from the existing pages of the same pool or rebalance memory from one or more victim pools.

2021032, Oct 21, 2021

Apr 16, 2020

16/850310

- Walldorf, DE
Adrian DRAGUSANU - North Vancouver, CA
Anup GHATAGE - Dublin CA, US
Colin FLORENDO - Marlborough MA, US
Mihnea ANDREI - Walldorf, DE
Randall HAMMON - Walnut Creek CA, US
Sarika IYER - San Ramon CA, US
Simhachala Sasikanth GOTTAPU - Dublin CA, US
Yanhong WANG - Dublin CA, US

G06F 12/0862
G06F 12/0882
G06F 16/22
G06F 16/24

Disclosed herein are system, method, and computer program product embodiments for performing fair prefetching. An embodiment operates by splitting a data vector into a first subrange and a second subrange. The embodiment performs a first chance prefetch operation on the first subrange based on a fixed number of pages, thereby loading a set of pages of the first subrange into a main memory. The embodiment performs the first chance prefetch operation on the second subrange based on the fixed number of pages, thereby loading a first set of pages of the second subrange into the main memory. The embodiment performs a second chance prefetch operation on the second subrange based on the performing the first chance prefetch operation on the second subrange, thereby loading a second set of pages of the second subrange into the main memory. The embodiment then executes the query.

2021028, Sep 16, 2021

Mar 12, 2020

16/816511

- Walldorf, DE
Colin Florendo - Marlborough MA, US
Robert Schulze - Walldorf, DE
Zheng-wei She - Shanghai, CN
Yanhong Wang - Dublin CA, US
Amarnadh Sai Eluri - Mountain House CA, US

G06F 16/21
G06F 16/22
G06N 5/04

System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

2020038, Dec 10, 2020

Apr 24, 2020

16/858344

- Walldorf, DE
Colin FLORENDO - Marlborough MA, US
Amit PATHAK - Pune, IN

G06F 3/06

Disclosed herein are system, method, and computer program product embodiments for storing an object onto a first or second page. An embodiment operates by receiving the object and determining that the first page has sufficient unused space for storing at least one byte of the object. Thereafter, a data block of the object is created to comprise at least one byte of the object. The data block is then stored on the first page or the second page, and a location of the object's first data block is recorded. Thereafter, a pointer corresponding to the location of the object's first data block for loading the object is provided.

2020038, Dec 10, 2020

Apr 30, 2020

16/863860

- Walldorf, DE
Colin FLORENDO - Marlborough MA, US
Pushkar KHADILKAR - Pune, IN
Robert SCHULZE - Walldorf, DE

G06F 12/0875
G06F 16/2455

System, method, and various embodiments for providing a hybrid data storage and load system are described herein. An embodiment operates by receiving a lookup request for a row identifier (ROWID) of a row of a table of a database, wherein the lookup request identifies a row position of the ROWID. A page corresponding to the row position is identified from an address vector stored in memory storage. The identified page is loaded from the disk storage to the memory storage. The row position is identified within the page from the memory storage. The ROWID stored in the row position is identified within the page. The ROWID is returned responsive to the lookup request.