-
公开(公告)号：US09189502B2
公开(公告)日：2015-11-17
申请号：US13630582
申请日：2012-09-28
发明人： Vsevolod Panteleenko , Yunrui Li , Jonghyun Lee , Margaret M. Susairaj , William H. Bridge, Jr. , Vinay Srihari
IPC分类号： G06F17/30
CPC分类号： G06F17/303
摘要： Techniques for moving data files without interrupting access are described. A first process moves a database file from a first location to a second location while the database file is accessible to one or more other processes for read or write operations. According to one technique, the first process communicates a move status and a copy range into the database file to one or more database server instances executing the one or more other processes. The one or more other processes then perform input/output (IO) operations on the database file based at least in part on the move status and the copy range communicated by the first process.
摘要翻译： 描述了在不中断访问的情况下移动数据文件的技术。 第一个进程将数据库文件从第一个位置移动到第二个位置，而数据库文件可被一个或多个其他进程访问以进行读取或写入操作。 根据一种技术，第一过程将移动状态和复制范围传达到数据库文件中，以执行一个或多个其他进程的一个或多个数据库服务器实例。 所述一个或多个其他进程至少部分地基于由第一进程传送的移动状态和复制范围对数据库文件执行输入/输出（IO）操作。
-
2.发明申请公开(公告)号：US20160019121A1
公开(公告)日：2016-01-21
申请号：US14337077
申请日：2014-07-21
IPC分类号： G06F11/14
CPC分类号： G06F11/1469 , G06F3/06 , G06F11/1471 , G06F11/2094 , G06F2201/835 , G06F2201/84
摘要： Techniques for processing changes in a cluster database system are provided. A first instance in the cluster transfers a data block to a second instance in the cluster before a redo record that stores one or more changes that the first instance made to the data block is durably stored. The first instance also transfers, to the second instance, a block change timestamp that indicates when a redo record for the one or more changes was generated by the first instance. The first instance also separately sends, to the second instance, a last store timestamp that indicates when the last redo record that was durably stored was generated by the first instance. The block change timestamp and the last store timestamp are used by the second instance when creating redo records for changes (made by the second instance) that depend on the redo record generated by the first instance.
摘要翻译： 提供了一种用于处理群集数据库系统中的更改的技术。 集群中的第一个实例将数据块传输到集群中的第二个实例，然后将存储一个或多个更改的重做记录保存在数据块中的第一个实例可持续存储。 第一个实例还将一个块更改时间戳传送到第二个实例，该时间戳指示一个或多个更改的重做记录何时由第一个实例生成。 第一个实例还分别向第二个实例发送一个最后一个存储时间戳，它指示何时被第一个实例生成的持久存储的最后一个重做记录。 当创建依赖于第一个实例生成的重做记录的更改（由第二个实例创建）的重做记录时，块更改时间戳和最后一个存储时间戳由第二个实例使用。
-
3.发明公开公开(公告)号：US20240045857A1
公开(公告)日：2024-02-08
申请号：US17880433
申请日：2022-08-03
CPC分类号： G06F16/2379 , G06F16/2358 , G06F9/466
摘要： In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.
-
4.发明授权公开(公告)号：US09563521B2
公开(公告)日：2017-02-07
申请号：US14337077
申请日：2014-07-21
CPC分类号： G06F11/1469 , G06F3/06 , G06F11/1471 , G06F11/2094 , G06F2201/835 , G06F2201/84
摘要： Techniques for processing changes in a cluster database system are provided. A first instance in the cluster transfers a data block to a second instance in the cluster before a redo record that stores one or more changes that the first instance made to the data block is durably stored. The first instance also transfers, to the second instance, a block change timestamp that indicates when a redo record for the one or more changes was generated by the first instance. The first instance also separately sends, to the second instance, a last store timestamp that indicates when the last redo record that was durably stored was generated by the first instance. The block change timestamp and the last store timestamp are used by the second instance when creating redo records for changes (made by the second instance) that depend on the redo record generated by the first instance.
摘要翻译： 提供了一种用于处理群集数据库系统中的更改的技术。 集群中的第一个实例将数据块传输到集群中的第二个实例，然后将存储一个或多个更改的重做记录保存在数据块中的第一个实例可持续存储。 第一个实例还将一个块更改时间戳传送到第二个实例，该时间戳指示一个或多个更改的重做记录何时由第一个实例生成。 第一个实例还分别向第二个实例发送一个最后一个存储时间戳，它指示何时被第一个实例生成的持久存储的最后一个重做记录。 当创建依赖于第一个实例生成的重做记录的更改（由第二个实例创建）的重做记录时，块更改时间戳和最后一个存储时间戳由第二个实例使用。
-
5.发明授权公开(公告)号：US12086132B2
公开(公告)日：2024-09-10
申请号：US17880433
申请日：2022-08-03
CPC分类号： G06F16/2379 , G06F9/466 , G06F16/2358
摘要： In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.
-
6.发明公开公开(公告)号：US20240045613A1
公开(公告)日：2024-02-08
申请号：US17880438
申请日：2022-08-03
IPC分类号： G06F3/06
CPC分类号： G06F3/0656 , G06F3/0604 , G06F3/0679
摘要： In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.
-
7.发明公开公开(公告)号：US20240045591A1
公开(公告)日：2024-02-08
申请号：US17880446
申请日：2022-08-03
IPC分类号： G06F3/06
CPC分类号： G06F3/061 , G06F3/0646 , G06F3/0683
摘要： In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.
-
-
-
-
-
-
搜索结果
7 条记录 (耗时 0.017 秒)
