公开(公告)号：US10650026B2

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

申请号：US15720897

申请日：2017-09-29

申请人： SYBASE, INC.

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

IPC分类号： G06F16/00 ,  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.

公开(公告)号：US10540372B2

公开(公告)日：2020-01-21

申请号：US15934755

申请日：2018-03-23

申请人： SYBASE, INC.

发明人： Daniel James Farrar ,  Evguenia Eflov

IPC分类号： G06F16/27 ,  G06F16/21 ,  G06F9/52

摘要： An operator tree is formed for a data processing plan, the operator tree containing a plurality of interconnected nodes and including a grouping of two or more duplicative portions, each of the two or more duplicative portions having identical nodes and structure such that when the operator tree is executed, operators executed in a first duplicative portion using a first thread perform same functions use different data than operators in a second duplicative portion using a second thread. One or more operators in the first portion and one or more operators in the second portion to be synchronized with each other are identified. A synchronization point is created for the identified operators in the first thread and one or more subsequent threads, wherein the synchronization point receives information from each of the identified operators to build an artifact to deliver to one or more operators that depend on the artifact.

公开(公告)号：US20190391885A1

公开(公告)日：2019-12-26

申请号：US16545602

申请日：2019-08-20

申请人： SYBASE, INC.

发明人： Heping Shang ,  Ming-Chen Lo ,  Elena Lora-Gallardo ,  Xia-ge Dai

IPC分类号： G06F11/14 ,  G06F11/16 ,  G06F11/20 ,  G06F16/18 ,  G06F16/23

摘要： A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.

公开(公告)号：US10169093B2

公开(公告)日：2019-01-01

申请号：US15684370

申请日：2017-08-23

申请人： SYBASE, INC.

发明人： Mohammed Abouzour ,  John Smirnios

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

摘要： 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.

公开(公告)号：US20180365277A1

公开(公告)日：2018-12-20

申请号：US16113412

申请日：2018-08-27

申请人： Sybase, Inc.

发明人： Anant Agarwal ,  Steven A. Kirk ,  Blaine French ,  Nandan Marathe ,  Shailesh Mungikar ,  Kaushal Mittal

IPC分类号： G06F17/30

CPC分类号： G06F16/2272 ,  G06F16/2246

摘要： Disclosed herein are methods for retrieving data from a database. An embodiment operates searching for a key in a first index. The method determines that the searching will require a storage access request and issues the storage access request. The method continues searching for the key in a second index.

公开(公告)号：US10133777B2

公开(公告)日：2018-11-20

申请号：US14971742

申请日：2015-12-16

申请人： Sybase, Inc.

发明人： Xiaobin Ma ,  Xun Cheng

IPC分类号： G06F17/00 ,  G06F17/30 ,  G06F8/30 ,  G06F8/41

摘要： Disclosed herein are system, method, and computer program product embodiments for eliminating redundancy when generating intermediate representation code. An embodiment operates by traversing a query execution plan, and for at least one operator in the query execution plan, determining whether the operator is derived from a parent class operator. If it is determined that the operator is derived from the parent class operator, source code for the native access plan is generated using one or more code generator functions corresponding to the parent class operator and/or one or more generator functions specifically corresponding to the child class operator. If it is determined that the operator is not derived from the parent class operator, source code for the native access plan is generated using one or more code generator functions corresponding to the operator.

公开(公告)号：US10114848B2

公开(公告)日：2018-10-30

申请号：US15233575

申请日：2016-08-10

申请人： SYBASE, INC.

发明人： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

IPC分类号： G06F11/00 ,  G06F17/30 ,  G06F11/14 ,  G06F11/16 ,  G06F11/20

摘要： Disclosed in some examples is a method, the method including detecting that an RDMS is recovering from a failure; sending a request for a last committed transaction on a replication component to the replication component; receiving, from the replication component, the last committed transaction which identifies a transaction that was the last committed transaction at a replication component at a time of RDMS failure; determining that a transaction log on the RDMS includes a transaction that had not yet been replicated at the time of RDMS failure which was committed on the transaction log subsequent to the last committed transaction received from the replication component; and based on that determination rolling back the transaction that had not yet been replicated at the time of RDMS failure.

公开(公告)号：US20180196701A1

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

申请号：US15885428

申请日：2018-01-31

申请人： SYBASE, INC.

发明人： Ibrahim Ahmed ,  Palaniappan Gandhi ,  Mark Theiding

IPC分类号： G06F9/50

CPC分类号： G06F9/5033

摘要： In an example embodiment performance is optimized in a complex event stream (CEP) system. Information about a plurality of CEP threads is obtained. Then nearness among the plurality of CEP threads is determined, wherein nearness between a first and a second CEP thread indicates how much interaction is expected to occur between the first and second CEP thread. Based on the determined nearness, the plurality of CEP threads are organized into a plurality of CEP thread groups. Then, each of the plurality of CEP thread groups are assigned to a different processing node, with each processing node having one or more processors and a memory.

公开(公告)号：US20180004810A1

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

申请号：US15704566

申请日：2017-09-14

申请人： SYBASE, INC.

发明人： Xun Cheng ,  Peter Schneider

IPC分类号： G06F17/30

摘要： 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.

公开(公告)号：US20170060948A1

公开(公告)日：2017-03-02

申请号：US14841713

申请日：2015-09-01

申请人： SYBASE, INC

发明人： Xiaobin Ma ,  Xun Cheng ,  Prabhas Kumar Samanta

IPC分类号： G06F17/30

CPC分类号： G06F16/24542 ,  G06F16/2246

摘要： An original query execution plan of a database query is received. The original query execution plan represents a tree of operators. Source code for the original query execution plan is generated by a single traversal of the tree of operators. The generated source code is compiled into native machine code. The native machine code represents a simplified native access plan (SNAP).

摘要翻译： 接收到数据库查询的原始查询执行计划。 原始查询执行计划表示一个运算符树。 原始查询执行计划的源代码由运算符树的单次遍历生成。 生成的源代码被编译成本机代码。 本地机器代码表示简化的本机访问计划（SNAP）。