-
公开(公告)号：US11704216B2
公开(公告)日：2023-07-18
申请号：US16420239
申请日：2019-05-23
CPC分类号： G06F11/302 , G06F11/3409 , G06F11/3452 , G06F16/217 , G06F16/2379 , G06F16/24545
摘要： Each of one or more commit cycles may be associated with a predicted number of updates. A statistics collection time for a database table can be determined by estimating a sum of predicted updates included in one or more commit cycles. Whether the estimated sum of predicted updates is greater than a first threshold may be determined. In addition, a progress point for a first one of the commit cycles can be determined. A time to collect statistics may be selected based on the progress point of the first commit cycle.
-
公开(公告)号：US10558668B2
公开(公告)日：2020-02-11
申请号：US15200072
申请日：2016-07-01
IPC分类号： G06F16/20 , G06F16/2455
摘要： A structured query language (SQL) query is configured to present a selected portion of a result set to a user interface. The selected portion of the result set can be based on an offset criteria appended to the SQL query. The offset criteria determines a location of a first presented instance of the selected portion of the result set. The offset criteria is configured to determine the location of the first presented instance of the selected portion of the result set independent of a number of instances appearing between a first instance of the result set and the first presented instance of the selected portion of the result set.
-
公开(公告)号：US10423642B2
公开(公告)日：2019-09-24
申请号：US14738070
申请日：2015-06-12
摘要： Aggregating database entry modifications for replay of database changes includes: inserting, in a journal modification table, of database entry modifications, where each database entry is associated with a relative record number; and, for each relative record number: aggregating, in the journal modification table, a plurality of the modifications into a single modification.
-
公开(公告)号：US10387283B2
公开(公告)日：2019-08-20
申请号：US14750074
申请日：2015-06-25
摘要： Each of one or more commit cycles may be associated with a predicted number of updates. A statistics collection time for a database table can be determined by estimating a sum of predicted updates included in one or more commit cycles. Whether the estimated sum of predicted updates is greater than a first threshold may be determined. In addition, a progress point for a first one of the commit cycles can be determined. A time to collect statistics may be selected based on the progress point of the first commit cycle.
-
公开(公告)号：US20190102777A1
公开(公告)日：2019-04-04
申请号：US16207744
申请日：2018-12-03
摘要： Systems and methods for providing automatic fork protection including determining that a transaction having fork protection was included in a first block that was appended to a blockchain, that a hash of the first block was validated, that a consensus decision was made by validator nodes approving the first block for addition to the blockchain, that a second block was appended to the blockchain after the first block, that the second block comprises a hash that is not based on the first block, that the first block was on a first fork and the second block was on a second fork, that the blockchain was resolved in favor of the second fork, and that the transaction failed as a result of the blockchain being resolved in favor of the second fork. The method including compensating a party that submitted the failed transaction based on the fork protection.
-
公开(公告)号：US10108664B2
公开(公告)日：2018-10-23
申请号：US14675799
申请日：2015-04-01
摘要： A first database management system (DBMS) running on first computer having a first set of computing resources determines that with respect to the first set of computing resources a first query access plan for executing a query satisfies a set of query optimization criteria. A determination is then made that with respect to a second set of computing resources the first query access plan fails a set of preliminary criteria. In response to this failure determination, a second query access plan for executing the query is generated. Prior to having a second DBMS running on a second computer having the second set of computing resources receive a request to execute the query, a determination is made that with respect to the second set of computing resources the second query access plan satisfies the set query optimization criteria.
-
公开(公告)号：US10083192B2
公开(公告)日：2018-09-25
申请号：US14743059
申请日：2015-06-18
CPC分类号： G06F16/219
摘要： A computer-implemented method for reusing deleted database records includes, receiving, by a database manager executing within a computing device, a first query request to insert, into a database table, a first set of database records. The database manager identifies a first set of entries within a journal log bundle. The database manager also determines, in response to identifying a first set of entries, that there is a third set of deleted database records located on a same page as a second set of database records. The database manager also, in response to determining that there is a third set of deleted database records located on a same page as the second set of database records, inserts into the database table the first set of database records using the third set of deleted database records.
-
公开(公告)号：US20180246930A1
公开(公告)日：2018-08-30
申请号：US15959963
申请日：2018-04-23
IPC分类号： G06F17/30
CPC分类号： G06F16/24542 , G06F16/23 , G06F16/2365
摘要： A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.
-
公开(公告)号：US09984121B2
公开(公告)日：2018-05-29
申请号：US15799487
申请日：2017-10-31
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30345 , G06F17/30371
摘要： A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.
-
公开(公告)号：US09916354B2
公开(公告)日：2018-03-13
申请号：US14734545
申请日：2015-06-09
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30557
摘要： A database management system (DBMS) runs on scalable production system. The DBMS includes a first operating mode, wherein the scalable production system runs on a first set of computing resources, and a second operating mode, wherein the scalable production system runs on a second set of computing resources. The DBMS in the first mode determines that with respect to the first set of resources a first query access plan for executing a query satisfies optimization criteria. A determination is made that with respect to the second set of resources the first plan fails preliminary criteria. In response to this failure determination, a second query access plan for executing the query is generated. Prior to having the DBMS receive a request to execute the query while in the second mode, a determination is made that with respect to the second set of resources the second plan satisfies the optimization criteria.
-
-
-
-
-
-
-
-
-
搜索结果
54 条记录 (耗时 0.032 秒)
