PARTITION LEVEL OPERATION WITH CONCURRENT ACTIVITIES

    公开(公告)号:US20210081395A1

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

    申请号:US17030332

    申请日:2020-09-23

    申请人: SYBASE, INC.

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

    Splitting of a join operation to allow parallelization

    公开(公告)号:US10817514B2

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

    申请号:US15704566

    申请日:2017-09-14

    申请人: SYBASE, INC.

    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.

    Reduce log contention by batching log record transfers to the log

    公开(公告)号:US10817500B2

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

    申请号:US14208958

    申请日:2014-03-13

    摘要: A system for managing database logging, the comprises a processor; and a user task executing in a database server process and executable by the processor, the user task to: receive in a database management system on a database server, a command to manipulate a portion of a database managed by the database management system; obtain a lock on the portion of the database; create a first log record in a first private log cache associated with the user task, the first log record recording a data manipulation to the portion of the database; enqueue the first log record to a queue; and release the lock on the portion of the database after copying the first log record to the queue.

    Range searches for database systems

    公开(公告)号:US10372693B2

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

    申请号:US14869552

    申请日:2015-09-29

    申请人: Sybase, Inc.

    发明人: Peter Bumbulis

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

    Bulk initial download of mobile databases

    公开(公告)号:US10102242B2

    公开(公告)日:2018-10-16

    申请号:US13275589

    申请日:2011-10-18

    IPC分类号: G06F15/16 G06F17/30

    摘要: A system, method, and computer program product are provided for handling bulk initial downloads of databases to mobile devices. Rather than straining the resources of a mobile device to recreate the database locally, a server can construct the database to the mobile device's requirements at the server by impersonating the mobile device. The server can then send the database, compressed and over an encrypted session, to the mobile device. The mobile device can then decrypt and uncompress the pages received, and then encrypt them using a local key for secure storage on a local storage device.

    Cloud-based delivery notifications for messaging systems

    公开(公告)号:US10033682B2

    公开(公告)日:2018-07-24

    申请号:US14587804

    申请日:2014-12-31

    申请人: William Dudley

    发明人: William Dudley

    IPC分类号: G06F15/16 H04L12/58

    摘要: A message identifier collector may collect message identifiers identifying sent messages having been sent by originating devices and identifying received messages of the sent messages that have been received at corresponding recipient devices. A message identifier matcher may match a sent message identifier for a sent message of the sent messages with a received message identifier for a corresponding received message of the received messages at a corresponding recipient device, and a delivery notification generator may send a delivery notification to an originating device of the originating devices that originally sent the sent message, thereby indicating receipt of the message at the corresponding recipient device. A delivery notification network path along which the message identifiers and the delivery notification are sent is different from a message delivery network path along which the message is sent.

    Distributed cache framework
    9.
    发明授权

    公开(公告)号:US09880936B2

    公开(公告)日:2018-01-30

    申请号:US14519971

    申请日:2014-10-21

    摘要: A system includes a database that stores data on one or more memory devices and a business object layer that receives a request for data associated with a user stored on the database. The system includes a first cache that reads and stores the requested data from the database in response to the request from the business object layer, where the first cache is partitioned into different segments and the different segments are stored across multiple different computing devices. The system includes a second cache that reads and stores the requested data from the first cache. The business object layer filters and applies business logic to the data before the second cache reads the requested data from the first cache. The second cache is stored on a single computing device that received the request. The business object layer delivers the requested data from the second cache.