-
公开(公告)号: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.
-
公开(公告)号:US10817500B2
公开(公告)日:2020-10-27
申请号:US14208958
申请日:2014-03-13
申请人: Fei Zhou , Sarika Iyer , Graham Ivey
发明人: Fei Zhou , Sarika Iyer , Graham Ivey
IPC分类号: G06F16/23 , G06F16/21 , G06F16/2455 , G06F16/24
摘要: 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.
-
公开(公告)号: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.
-
公开(公告)号:US10102242B2
公开(公告)日:2018-10-16
申请号:US13275589
申请日:2011-10-18
申请人: Evan Ireland , Brett Donahue , Guo-ping Zhang , Xiong He
发明人: Evan Ireland , Brett Donahue , Guo-ping Zhang , Xiong He
摘要: 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.
-
公开(公告)号:US10033682B2
公开(公告)日:2018-07-24
申请号:US14587804
申请日:2014-12-31
申请人: William Dudley
发明人: William Dudley
摘要: 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.
-
公开(公告)号:US09996427B2
公开(公告)日:2018-06-12
申请号:US13063432
申请日:2010-12-20
CPC分类号: G06F11/1458 , G06F11/1464 , G06F11/1466 , G06F17/30362 , G06F17/30575 , G06F17/30584 , G06F2201/80 , G06F2201/82
摘要: The capability to perform data backup and restore within a distributed database system environment is provided. The embodiments includes initiating a backup operation of a database distributed across a plurality of nodes, and coordinating synchronization of the backup operation within and among the plurality of nodes for parallel, local data dumping with transactional consistency to a single point in time.
-
公开(公告)号: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.
-
公开(公告)号:US09880936B2
公开(公告)日:2018-01-30
申请号:US14519971
申请日:2014-10-21
IPC分类号: G06F12/08 , G06F17/30 , G06Q10/06 , G06F12/084
CPC分类号: G06F12/084 , G06F17/30477 , G06F17/3048 , G06F2212/163 , G06F2212/284 , G06Q10/067
摘要: 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.
-
公开(公告)号:US09843635B2
公开(公告)日:2017-12-12
申请号:US14569639
申请日:2014-12-13
申请人: Keshav Gupta , Hemanth Basrur
发明人: Keshav Gupta , Hemanth Basrur
摘要: Various embodiments of systems and methods for replicating data included in a portable electronic device to a new portable electronic device are described herein. Initially a copy of data, including an application, stored in the portable electronic device is generated. Next a determination is made whether the application is included in an application distribution platform corresponding to an operating system of the new portable electronic device. Finally based on the determination, the application is downloaded from the application distribution platform to the new portable electronic device.
-
-
-
-
-
-
-
-
-