-
公开(公告)号:US20130311525A1
公开(公告)日:2013-11-21
申请号:US13471670
申请日:2012-05-15
申请人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Peter Gvozdjak , Balendran Mugundan
IPC分类号: G06F17/30
CPC分类号: G06F16/2455 , G06F16/2358
摘要: Systems and methods are described that facilitate idempotent execution of commands generated by a client for execution by a database server. Each command transmitted to the server includes a command ID generated by the client. The server attempts to execute each command and subsequently stores the command ID associated therewith in a repository along with an indication of whether the command executed successfully. When a new command is received by the server, it determines if the command ID associated therewith has already been stored in the repository. If the command ID associated with the new command has not already been stored in the repository, then the server executes the new command. If the command ID associated with the new command has already been stored in the repository and a previously-received command associated with the command ID has been executed successfully, then the server will not execute the new command.
摘要翻译: 描述了促进由客户机生成的用于数据库服务器执行的命令的幂等执行的系统和方法。 发送到服务器的每个命令包括由客户端生成的命令ID。 服务器尝试执行每个命令,随后将与其相关联的命令ID与指示是否成功执行的指示一起存储在存储库中。 当服务器接收到新的命令时,它确定与其相关联的命令ID是否已经存储在存储库中。 如果与新命令相关联的命令ID尚未存储在存储库中,则服务器将执行新命令。 如果与新命令相关联的命令ID已经存储在存储库中,并且与命令ID相关联的先前接收到的命令已成功执行,则服务器将不执行新命令。
-
公开(公告)号:US09239868B2
公开(公告)日:2016-01-19
申请号:US13527384
申请日:2012-06-19
申请人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin J. Mumford , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin J. Mumford , Peter Gvozdjak , Balendran Mugundan
CPC分类号: G06F17/30566 , G06F11/2023 , G06F11/2097 , H04L67/142 , H04L67/146 , H04L67/148 , H04L69/40
摘要: Systems and methods are described that establish and maintain a virtual session between a client and one or more database servers. A database server establishes a first session with a client wherein establishing the virtual session with the client comprises associating a virtual session identifier (ID) with the first session, generates state information in association with the first session, and stores the state information in a repository in association with the virtual session ID. After the first session fails, a same or different database server establishes a second session with the client wherein establishing the second session with the client comprises receiving the virtual session ID from the client, accesses the state information that was stored in the repository in association with the virtual session ID, and associates the state information with the second session.
摘要翻译: 描述了在客户端和一个或多个数据库服务器之间建立和维护虚拟会话的系统和方法。 数据库服务器与客户端建立第一会话,其中与客户端建立虚拟会话包括将虚拟会话标识符(ID)与第一会话相关联,生成与第一会话关联的状态信息,并将状态信息存储在存储库 与虚拟会话ID相关联。 在第一次会话失败之后,相同或不同的数据库服务器与客户端建立第二个会话,其中与客户端建立第二个会话包括从客户端接收虚拟会话ID,与存储在存储库中的状态信息相关联地访问 虚拟会话ID,并将状态信息与第二会话相关联。
-
公开(公告)号:US20130339533A1
公开(公告)日:2013-12-19
申请号:US13527384
申请日:2012-06-19
申请人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin J. Mumford , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin J. Mumford , Peter Gvozdjak , Balendran Mugundan
CPC分类号: G06F17/30566 , G06F11/2023 , G06F11/2097 , H04L67/142 , H04L67/146 , H04L67/148 , H04L69/40
摘要: Systems and methods are described that establish and maintain a virtual session between a client and one or more database servers. A database server establishes a first session with a client wherein establishing the virtual session with the client comprises associating a virtual session identifier (ID) with the first session, generates state information in association with the first session, and stores the state information in a repository in association with the virtual session ID. After the first session fails, a same or different database server establishes a second session with the client wherein establishing the second session with the client comprises receiving the virtual session ID from the client, accesses the state information that was stored in the repository in association with the virtual session ID, and associates the state information with the second session.
摘要翻译: 描述了在客户端和一个或多个数据库服务器之间建立和维护虚拟会话的系统和方法。 数据库服务器与客户端建立第一会话,其中与客户端建立虚拟会话包括将虚拟会话标识符(ID)与第一会话相关联,生成与第一会话关联的状态信息,并将状态信息存储在存储库 与虚拟会话ID相关联。 在第一次会话失败之后,相同或不同的数据库服务器与客户端建立第二个会话,其中与客户端建立第二个会话包括从客户端接收虚拟会话ID,与存储在存储库中的状态信息相关联地访问 虚拟会话ID,并将状态信息与第二会话相关联。
-
公开(公告)号:US10936591B2
公开(公告)日:2021-03-02
申请号:US13471670
申请日:2012-05-15
申请人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew A. Neerincx , Luiz F. Santos , Oleg Ignat , David B. Lomet , Quetzalcoatl Bradley , Raghu Ram , Peter Gvozdjak , Balendran Mugundan
IPC分类号: G06F16/2455 , G06F16/23
摘要: Systems and methods are described that facilitate idempotent execution of commands generated by a client for execution by a database server. Each command transmitted to the server includes a command ID generated by the client. The server attempts to execute each command and subsequently stores the command ID associated therewith in a repository along with an indication of whether the command executed successfully. When a new command is received by the server, it determines if the command ID associated therewith has already been stored in the repository. If the command ID associated with the new command has not already been stored in the repository, then the server executes the new command. If the command ID associated with the new command has already been stored in the repository and a previously-received command associated with the command ID has been executed successfully, then the server will not execute the new command.
-
公开(公告)号:US09251194B2
公开(公告)日:2016-02-02
申请号:US13559337
申请日:2012-07-26
申请人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
CPC分类号: H04L67/32 , G06F11/1402 , G06F17/30348 , G06F17/30864 , G06F2201/80 , H04L67/142 , H04L69/40
摘要: Techniques for recovering from session failures between clients and database servers are described herein. A session may be established between a client and a first database server to handle a database query for the client. A command of the session may be received by the first database server from the client. Data requested by the command may be retrieved. Prior to responding to the command, the data is spooled to a session state stored in a repository of the first database server, and the session state is replicated to one or more additional database servers. The session state stored in the repository of the first database server enables the first database server and client to recover from a failure of the session. The replicated session state enables the additional database server(s) to reestablish the session and respond to the command, instead of the first database server, if the session fails.
摘要翻译: 本文描述了从客户端和数据库服务器之间的会话故障中恢复的技术。 可以在客户端和第一数据库服务器之间建立会话来处理客户端的数据库查询。 会话的命令可以由客户端由第一数据库服务器接收。 可以检索命令请求的数据。 在响应命令之前,将数据假脱机到存储在第一数据库服务器的存储库中的会话状态,并将会话状态复制到一个或多个其他数据库服务器。 存储在第一数据库服务器的存储库中的会话状态使得第一数据库服务器和客户端能够从会话的故障中恢复。 如果会话失败,复制的会话状态使得附加数据库服务器能够重新建立会话并响应命令而不是第一个数据库服务器。
-
公开(公告)号:US20140032491A1
公开(公告)日:2014-01-30
申请号:US13560468
申请日:2012-07-27
申请人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
CPC分类号: G06F17/30345
摘要: Techniques for recovering from session failures between clients and database servers are described herein. A session may be established between a client and a first database server, and a transaction may be opened to process a plurality of database commands. One or more commands associated with the transaction may be received from the client at the database server. Each received command has an associated command identifier. A transaction log stores the command identifier associated with each received command and indicates whether each received command has been successfully executed at the database server. After a session failure, the session is reestablished, and a command identifier for a further command is received from the client. If the command identifier associated with the further command is determined to have been stored in the transaction log, the command does not need to be executed, and the transaction may continue.
摘要翻译: 本文描述了从客户端和数据库服务器之间的会话故障中恢复的技术。 可以在客户端和第一数据库服务器之间建立会话,并且可以打开事务来处理多个数据库命令。 可以从数据库服务器处的客户端接收与事务相关联的一个或多个命令。 每个接收到的命令都具有相关联的命令标识符。 事务日志存储与每个接收到的命令相关联的命令标识符,并且指示每个接收到的命令是否已经在数据库服务器上成功执行。 会话失败后,重新建立会话,并从客户端接收另一个命令的命令标识符。 如果确定与其他命令相关联的命令标识符已经存储在事务日志中,则不需要执行该命令,并且事务可以继续。
-
公开(公告)号:US08898109B2
公开(公告)日:2014-11-25
申请号:US13560468
申请日:2012-07-27
申请人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
发明人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak , Balendran Mugundan
CPC分类号: G06F17/30345
摘要: Techniques for recovering from session failures between clients and database servers are described herein. A session may be established between a client and a first database server, and a transaction may be opened to process a plurality of database commands. One or more commands associated with the transaction may be received from the client at the database server. Each received command has an associated command identifier. A transaction log stores the command identifier associated with each received command and indicates whether each received command has been successfully executed at the database server. After a session failure, the session is reestablished, and a command identifier for a further command is received from the client. If the command identifier associated with the further command is determined to have been stored in the transaction log, the command does not need to be executed, and the transaction may continue.
摘要翻译: 本文描述了从客户端和数据库服务器之间的会话故障中恢复的技术。 可以在客户端和第一数据库服务器之间建立会话,并且可以打开事务来处理多个数据库命令。 可以从数据库服务器处的客户端接收与事务相关联的一个或多个命令。 每个接收到的命令都具有相关联的命令标识符。 事务日志存储与每个接收到的命令相关联的命令标识符,并且指示每个接收到的命令是否已经在数据库服务器上成功执行。 会话失败后,重新建立会话,并从客户端接收另一个命令的命令标识符。 如果确定与其他命令相关联的命令标识符已经存储在事务日志中,则不需要执行该命令,并且事务可以继续。
-
公开(公告)号:US20140032964A1
公开(公告)日:2014-01-30
申请号:US13559337
申请日:2012-07-26
申请人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak
发明人: Matthew Alban Neerincx , Luiz Fernando Federico Dos Santos , Oleg Ignat , David Bruce Lomet , Quetzalcoatl Bradley , Raghu Ram , Chadwin James Mumford , Peter Gvozdjak
CPC分类号: H04L67/32 , G06F11/1402 , G06F17/30348 , G06F17/30864 , G06F2201/80 , H04L67/142 , H04L69/40
摘要: Techniques for recovering from session failures between clients and database servers are described herein. A session may be established between a client and a first database server to handle a database query for the client. A command of the session may be received by the first database server from the client. Data requested by the command may be retrieved. Prior to responding to the command, the data is spooled to a session state stored in a repository of the first database server, and the session state is replicated to one or more additional database servers. The session state stored in the repository of the first database server enables the first database server and client to recover from a failure of the session. The replicated session state enables the additional database server(s) to reestablish the session and respond to the command, instead of the first database server, if the session fails.
摘要翻译: 本文描述了从客户端和数据库服务器之间的会话故障中恢复的技术。 可以在客户端和第一数据库服务器之间建立会话来处理客户端的数据库查询。 会话的命令可以由客户端由第一数据库服务器接收。 可以检索命令请求的数据。 在响应命令之前,将数据假脱机到存储在第一数据库服务器的存储库中的会话状态,并将会话状态复制到一个或多个其他数据库服务器。 存储在第一数据库服务器的存储库中的会话状态使得第一数据库服务器和客户端能够从会话的故障中恢复。 如果会话失败,复制的会话状态使得附加数据库服务器能够重新建立会话并响应命令而不是第一个数据库服务器。
-
公开(公告)号:US08627412B2
公开(公告)日:2014-01-07
申请号:US13086959
申请日:2011-04-14
申请人: Balendran Mugundan , Peter Gvozdjak , Sapna Jeswani , Jimmy Yu Wu , Raghu Ram , Chadwin James Mumford , David Olix
发明人: Balendran Mugundan , Peter Gvozdjak , Sapna Jeswani , Jimmy Yu Wu , Raghu Ram , Chadwin James Mumford , David Olix
IPC分类号: G06F7/04
CPC分类号: G06F11/2005 , G06F11/1443 , G06F2201/80
摘要: A first computer establishes a logical connection to a second computer for requesting and/or receiving data from a database. A logical connection is independent of the underlying physical network connection used to connect to the database. A context identifier is stored by both computers to enable the context of a logical connection to be persisted between switches from one physical network connection to another within the logical connection thus enabling database transfers to be continued on a second physical network connection when a failure in a first physical network connection occurs.
摘要翻译: 第一计算机建立与第二计算机的逻辑连接,用于从数据库请求和/或接收数据。 逻辑连接独立于用于连接到数据库的底层物理网络连接。 两个计算机都存储上下文标识符,以使逻辑连接的上下文能够在逻辑连接中的一个物理网络连接到另一个物理网络连接的交换机之间持久化,从而使得在第二物理网络连接上的数据库传输能够在第二物理网络连接上继续 第一个物理网络连接发生。
-
公开(公告)号:US20120266211A1
公开(公告)日:2012-10-18
申请号:US13086959
申请日:2011-04-14
申请人: Balendran Mugundan , Peter Gvozdjak , Sapna Jeswani , Jimmy Yu Wu , Raghu Ram , Chadwin James Mumford , David Olix
发明人: Balendran Mugundan , Peter Gvozdjak , Sapna Jeswani , Jimmy Yu Wu , Raghu Ram , Chadwin James Mumford , David Olix
CPC分类号: G06F11/2005 , G06F11/1443 , G06F2201/80
摘要: A first computer establishes a logical connection to a second computer for requesting and/or receiving data from a database. A logical connection is independent of the underlying physical network connection used to connect to the database. A context identifier is stored by both computers to enable the context of a logical connection to be persisted between switches from one physical network connection to another within the logical connection thus enabling database transfers to be continued on a second physical network connection when a failure in a first physical network connection occurs.
摘要翻译: 第一计算机建立与第二计算机的逻辑连接,用于从数据库请求和/或接收数据。 逻辑连接独立于用于连接到数据库的底层物理网络连接。 两个计算机都存储上下文标识符,以使逻辑连接的上下文能够在逻辑连接中的一个物理网络连接到另一个物理网络连接的交换机之间持久化,从而使得在第二物理网络连接上的数据库传输能够在第二物理网络连接上继续 第一个物理网络连接发生。
-
-
-
-
-
-
-
-
-