公开(公告)号：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.

公开(公告)号：US10817514B2

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

申请号：US15704566

申请日：2017-09-14

申请人： SYBASE, INC.

发明人： Xun Cheng ,  Peter Schneider

IPC分类号： G06F16/00 ,  G06F16/2453

摘要： A system and method for processing a database query is described. In response to detection that a database query involves a star or snowflake join operation, a join operator in a preliminary query plan can be split into a build operator and a probe operator. The probe operator can be placed in a final query plan in the same place as the join operator in the preliminary query plan, while the build operator can be placed beneath the probe operator in the final query plan, between an exchange operator and the exchange operator's child from the preliminary query plan.

公开(公告)号：US10372693B2

公开(公告)日：2019-08-06

申请号：US14869552

申请日：2015-09-29

申请人： Sybase, Inc.

发明人： Peter Bumbulis

IPC分类号： G06F17/30 ,  G06F16/22 ,  G06F16/245

摘要： Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a query for a set of records in a database system having values in a field of a table that fall within a range of values. The program also determines a number of bits used to represent the values in the field of the table. The program further determines a set of operations to perform on the values in the field of the table based on the determined number of bits. The program also performs the determined set of operations on the values in the field of the table in order to identify the set of records in the database.

公开(公告)号：US09990510B2

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

申请号：US14789907

申请日：2015-07-01

申请人： Sybase, Inc.

发明人： Peter Bumbulis

IPC分类号： G06F17/30 ,  G06F21/62 ,  G06F12/0802

CPC分类号： G06F21/6218 ,  G06F12/0802 ,  G06F17/30289 ,  G06F2212/603

摘要： A plurality of reserve and commit log operations are initiated in a database system. Thereafter, at least a portion of the database operations are logged in a log such that transient data structures are kept in-memory of the database system and persistent data structures are kept in byte-addressable memory. Next, each of one or more clients concurrently accessing the log are registered to enable such clients to access the log.

公开(公告)号：US20180025068A1

公开(公告)日：2018-01-25

申请号：US15720897

申请日：2017-09-29

申请人： SYBASE, INC.

发明人： Christopher H. Rank ,  Rene Quakkelaar ,  Elena Lora-Gallardo

IPC分类号： G06F17/30

CPC分类号： G06F16/275 ,  G06F16/27

摘要： Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.

公开(公告)号：US20170351550A1

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

申请号：US15684370

申请日：2017-08-23

申请人： Sybase, Inc.

发明人： Mohammed Abouzour ,  John Smirnios

IPC分类号： G06F9/50 ,  G06F9/48

CPC分类号： G06F9/5044 ,  G06F9/4843 ,  G06F9/5033 ,  G06F9/5066 ,  Y02D10/22 ,  Y02D10/36

摘要： In an example embodiment, a method of operating a task scheduler for one or more processors is provided. A topology of one or more processors is obtained, the topology indicating a plurality of execution units and physical resources associated with each of the plurality of execution units. A task to be performed by the one or more processors is received. Then a plurality of available execution units from the plurality of execution units is identified. An optimal execution unit is then determined, from the plurality of execution units, to which to assign the task, based on the topology. The task is then assigned to the optimal execution unit, after which the task is sent to the optimal execution unit for execution.

公开(公告)号：US09836505B2

公开(公告)日：2017-12-05

申请号：US14210153

申请日：2014-03-13

申请人： SYBASE, INC.

发明人： Xun Cheng ,  Peter Schneider

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30979

摘要： A system and method for processing a database query is described. The method can, in response to detection that a database query involves a star or snowflake join operation, determine a selectivity ratio for each of a plurality of dimension tables. The selectivity ratio having a lower value can correspond to a more restrictive dimension table. Thereafter, a table ordering can be created beginning with a fact table and continuing with each of the dimension tables in ascending order of their corresponding selectivity ratios. Then a query plan involving join operations between successive tables in the table ordering can be created.

公开(公告)号：US09788205B2

公开(公告)日：2017-10-10

申请号：US15079363

申请日：2016-03-24

申请人： Sybase, Inc.

发明人： Dilip Sarmah ,  Kyle Warner Erickson ,  Rajat Mounendrababu Gadagkar

IPC分类号： H04L29/06 ,  H04W12/06 ,  H04L9/28 ,  H04W4/14

CPC分类号： H04W12/06 ,  H04L9/3213 ,  H04L63/083 ,  H04L2209/80 ,  H04W4/14

摘要： As individuals increasingly engage in different types of transactions they face a growing threat from, possibly among other things, identity theft, financial fraud, information misuse, etc. and the serious consequences or repercussions of same. Leveraging the ubiquitous nature of wireless devices and the popularity of (Short Message Service, Multimedia Message Service, etc.) messaging, an infrastructure that enhances the security of the different types of transactions within which a wireless device user may participate through a Second Factor Authentication facility. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

公开(公告)号：US09753780B2

公开(公告)日：2017-09-05

申请号：US14793234

申请日：2015-07-07

申请人： SYBASE, INC.

发明人： Mohammed Abouzour ,  John Smirnios

IPC分类号： G06F9/46 ,  G06F9/50 ,  G06F9/48

CPC分类号： G06F9/5044 ,  G06F9/4843 ,  G06F9/5033 ,  G06F9/5066

摘要： In an example embodiment, a method of operating a task scheduler for one or more processors is provided. A topology of one or more processors is obtained, the topology indicating a plurality of execution units and physical resources associated with each of the plurality of execution units. A task to be performed by the one or more processors is received. Then a plurality of available execution units from the plurality of execution units is identified. An optimal execution unit is then determined, from the plurality of execution units, to which to assign the task, based on the topology. The task is then assigned to the optimal execution unit, after which the task is sent to the optimal execution unit for execution.

公开(公告)号：US20170177303A1

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

申请号：US14971695

申请日：2015-12-16

申请人： SYBASE, INC.

发明人： XIAOBIN MA ,  XUN CHENG

IPC分类号： G06F9/44 ,  G06F9/45

CPC分类号： G06F8/30 ,  G06F8/41 ,  G06F9/449 ,  G06F9/4552

摘要： Disclosed herein are system, method, and computer program product embodiments for generating a native access plan from a query execution plan for dynamic entity calling. An embodiment operates by receiving the query execution plan comprising at least one call to an entity, the entity being implemented by a plurality of classes, and generating source code of a native access plan that implements the query execution plan. The source code of the native access plan includes instructions to translate a run-time call to the entity to a call to a corresponding implementation of the entity based on an identifier of the called implementation of the entity.