公开(公告)号：US20210081395A1

公开(公告)日：2021-03-18

申请号：US17030332

申请日：2020-09-23

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F16/23 ,  G06F16/27 ,  G06F16/176 ,  G06F16/22

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

公开(公告)号：US10803046B2

公开(公告)日：2020-10-13

申请号：US15871819

申请日：2018-01-15

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F16/00 ,  G06F16/23 ,  G06F16/27 ,  G06F16/176 ,  G06F16/22

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

公开(公告)号：US11544246B2

公开(公告)日：2023-01-03

申请号：US17030332

申请日：2020-09-23

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F16/00 ,  G06F16/23 ,  G06F16/27 ,  G06F16/176 ,  G06F16/22

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

公开(公告)号：US20180137159A1

公开(公告)日：2018-05-17

申请号：US15871819

申请日：2018-01-15

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F17/30

CPC分类号： G06F16/2343 ,  G06F16/1774 ,  G06F16/2282 ,  G06F16/2365 ,  G06F16/2379 ,  G06F16/278

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

公开(公告)号：US09740582B2

公开(公告)日：2017-08-22

申请号：US14984567

申请日：2015-12-30

申请人： SYBASE, INC.

发明人： Amarnadh Sai Eluri ,  Nikhil Jamadagni ,  Sarika Iyer

IPC分类号： G06F11/07 ,  G06F11/20 ,  G06F17/30

CPC分类号： G06F11/2033 ,  G06F17/30362 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/805

摘要： In some example embodiments, a method comprises: receiving, by a first node of a plurality of nodes in a distributed database system on a shared disk cluster infrastructure, a transaction request to perform a user database transaction a data item in a user database on a shared disk; acquiring, by the first node, a transaction lock for the data item; storing a lock file for the user database transaction in a lock information database on the shared disk, the lock file comprising lock information for the transaction lock and an indication of a status of the user database transaction, and the lock information comprising an identification of a location of the data item; and storing a transaction record of the user database transaction in the user database on the shared disk subsequent to the storing of the lock file in the lock information database on the shared disk.

公开(公告)号：US20170192863A1

公开(公告)日：2017-07-06

申请号：US14984567

申请日：2015-12-30

申请人： SYBASE, INC.

发明人： Amarnadh Sai Eluri ,  Nikhil Jamadagni ,  Sarika Iyer

IPC分类号： G06F11/20 ,  G06F17/30

CPC分类号： G06F11/2033 ,  G06F17/30362 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/805

摘要： In some example embodiments, a method comprises: receiving, by a first node of a plurality of nodes in a distributed database system on a shared disk cluster infrastructure, a transaction request to perform a user database transaction a data item in a user database on a shared disk; acquiring, by the first node, a transaction lock for the data item; storing a lock file for the user database transaction in a lock information database on the shared disk, the lock file comprising lock information for the transaction lock and an indication of a status of the user database transaction, and the lock information comprising an identification of a location of the data item; and storing a transaction record of the user database transaction in the user database on the shared disk subsequent to the storing of the lock file in the lock information database on the shared disk.

公开(公告)号：US09916341B2

公开(公告)日：2018-03-13

申请号：US15153102

申请日：2016-05-12

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F17/30

CPC分类号： G06F17/30362 ,  G06F17/30171 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30377 ,  G06F17/30584

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

公开(公告)号：US20160364430A1

公开(公告)日：2016-12-15

申请号：US15153102

申请日：2016-05-12

申请人： SYBASE, INC.

发明人： Amit Pathak ,  Paresh Rathod ,  Swati Sharma ,  Nikhil Jamadagni

IPC分类号： G06F17/30

CPC分类号： G06F17/30362 ,  G06F17/30171 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30377 ,  G06F17/30584

摘要： Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.