专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US09569472B2 System and method for providing a second level connection cache for use with a database environment 有权
标题翻译：用于提供与数据库环境一起使用的第二级连接缓存的系统和方法
公开(公告)号：US09569472B2
公开(公告)日：2017-02-14
申请号：US14253580
申请日：2014-04-15
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Vidya Hegde , Jean de Lavarene , Pankaj Chand , Douglas Surber , Tong Zhou
IPC分类号： G06F12/08 , G06F17/30
CPC分类号： G06F17/303 , G06F12/0813 , G06F12/0815 , G06F12/0868 , G06F17/30345 , G06F17/30902 , G06F2212/465
摘要： Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.
摘要翻译：这里描述了一种用于提供与数据库环境一起使用的2级连接高速缓存的系统和方法。根据实施例，使用第二级别或级别2（L2）连接高速缓存来缓存与数据库一起使用的非会话连接。当请求连接时，可以从高速缓存检索无会话连接（NSC），并附加数据库会话。稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

2. 发明申请

US20160321304A9 RECOVERING STATEFUL READ-ONLY DATABASE SESSIONS 审中-公开
公开(公告)号：US20160321304A9
公开(公告)日：2016-11-03
申请号：US13936061
申请日：2013-07-05
申请人： Oracle International Corporation
发明人： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30371
摘要： A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable due to a planned or unplanned recoverable error. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state, which was exposed to the client from the previous database session, on the new database session. The process masks the outage from the application.

3. 发明授权

US09251178B2 System and method for connection labeling for use with connection pools 有权
标题翻译：用于连接池的连接标签的系统和方法
公开(公告)号：US09251178B2
公开(公告)日：2016-02-02
申请号：US13912086
申请日：2013-06-06
申请人： Oracle International Corporation
发明人： Jean de Lavarene , Tong Zhou , Douglas Surber , Stephen Felts , David Merrill
IPC分类号： G06F17/30 , G06F9/50
CPC分类号： G06F17/30289 , G06F9/5011 , G06F17/30943 , G06F2209/5011
摘要： A system and method for connection labeling for use with connection pools. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and avoids using those high-cost connections to serve requests when the total number of connections is below a particular threshold value.
摘要翻译：用于连接池的连接标签的系统和方法。根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及标识为高成本连接的连接标识的连接池逻辑，并且当连接总数低于特定阈值时，避免使用这些高成本连接来提供请求。

4. 发明申请

US20140379756A1 SYSTEM AND METHOD FOR TRANSPARENT MULTI KEY-VALUE WEIGHTED ATTRIBUTED CONNECTION USING UNI-TAG CONNECTION POOLS 有权
标题翻译：使用非标签连接池进行透明多重键加权归属连接的系统和方法
公开(公告)号：US20140379756A1
公开(公告)日：2014-12-25
申请号：US14202348
申请日：2014-03-10
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Ashok Shivarudraiah , Jean De Lavarene , Tong Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/3056
摘要： A system and method for transparent multi key-value weighted attributed connection using uni-tag connection pools. In accordance with an embodiment, a connection pool enables labeling of connections that software applications can use to access a database. A connection pool associated with a database enables tagging of connection pools at the database and allows applications to selectively obtain connections based on tags. A request is received from an application to query data from the database using a labeled connection or low-cost alternative. If a low-cost connection is found, but requires configuration, the system returns unmatched labels for use by the application in configuring its environment to use the connection. The system can also generate a tag for the connection. Upon subsequent release of the database session, the tag can be made available for subsequent use of the tag, or a tagged connection, by the same or by other applications.
摘要翻译：一种使用单标签连接池进行透明多键值加权归属连接的系统和方法。根据一个实施例，连接池可以标记软件应用程序可以用来访问数据库的连接。与数据库关联的连接池可以标记数据库中的连接池，并允许应用程序根据标签选择性地获取连接。从应用程序接收到使用标记的连接或低成本替代方案从数据库查询数据的请求。如果找到低成本连接但需要配置，则系统返回不匹配的标签，供应用程序在配置其环境以使用连接时使用。系统还可以生成连接的标签。在随后的数据库会话释放之后，可以使标签可用于随后使用标签或标记的连接，由相同或其他应用程序使用。

5. 发明授权

US10942907B2 Safe release of database sessions for planned maintenance operations 有权
公开(公告)号：US10942907B2
公开(公告)日：2021-03-09
申请号：US15803644
申请日：2017-11-03
申请人： Oracle International Corporation
发明人： Carol L. Colrain , Kevin S. Neel , Douglas N. Surber , Tong Zhou , Nancy R. Ikeda , Jean De Lavarene , Rohan Ankalikar
IPC分类号： G06F16/27 , G06F16/21 , H04L29/08
摘要： Techniques are described for closing one or more connections with a database management system (DBMS) as part of a planned operation such as maintenance and load balancing. In an embodiment, a request is received for a planned operation of a database server of a DBMS that requires releasing and migrating database sessions. Over a database connection with the database server, the DBMS or a Client-Driver on the client system that interfaces with the DBMS, may receive request(s) from the client system. Based on the request(s), a safe point, for the database connection with the database server, at which the database connection of the client system with the database server can be closed without affecting the success of execution of next one or more command that the client system intended to request the DBMS to execute on the database server, is determined. In an embodiment, in response to the request(s), the DBMS and/or Client-Driver, while the connection is valid, provide to the client system an invalid status for a connection test request. Such a response may cause the client system to use a different database connection to connect with the DBMS. After returning the response to the client system, the DBMS and/or Client-Driver causes the database session with the DBMS to close. In an embodiment, for database sessions to be released, the DBMS identifies a safe point in a database session by a detected request boundary or where the session states are determined to be recoverable or the failover is determined to be expected to succeed. At such a safe point, all database session states are known, and failing the session over to another database instance offering the requested service can be performed safely and transparent to applications.

6. 发明授权

US09779116B2 Recovering stateful read-only database sessions 有权
公开(公告)号：US09779116B2
公开(公告)日：2017-10-03
申请号：US13936061
申请日：2013-07-05
申请人： Oracle International Corporation
发明人： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda , Paul Parkinson
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30371
摘要： A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable due to a planned or unplanned recoverable error. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state, which was exposed to the client from the previous database session, on the new database session. The process masks the outage from the application.

7. 发明申请

US20160306832A1 SYSTEM AND METHOD FOR PROVIDING ACCESS TO A SHARDED DATABASE USING A CACHE AND A SHARD TECHNOLOGY 审中-公开
标题翻译：使用高速缓存和削减技术提供访问受保护数据库的系统和方法
公开(公告)号：US20160306832A1
公开(公告)日：2016-10-20
申请号：US15133979
申请日：2016-04-20
申请人： Oracle International Corporation
发明人： Vidya Hegde , Jean de Lavarene , Douglas Surber , Mark Dilman , Leonid Novak , Wei Ming Hu , Ashok Shivarudraiah , Tong Zhou , Ilya Taranov
IPC分类号： G06F17/30
摘要： In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.
摘要翻译：根据实施例，该系统使得能够使用高速缓存和分片拓扑来访问分片数据库。连接到分片数据库的分片识别客户端应用程序可以使用连接池（例如，通用连接池，UCP）来存储或访问到共享池内的分片数据库的不同碎片或块的连接。当创建新连接时，可以在数据库驱动程序层构建分片拓扑图层，数据库驱动程序层可以将分片键范围学习并缓存到分片的位置。分片拓扑层使来自客户端应用程序的后续连接请求能够使用快速键路径访问适当的分片或块。

8. 发明申请

US20150326673A1 TRANSACTIONAL AND NON-TRANSACTIONAL DATA FOR MAINTAINING SESSION STATE 有权
标题翻译：用于维护会议状态的交易和非交易数据
公开(公告)号：US20150326673A1
公开(公告)日：2015-11-12
申请号：US14748451
申请日：2015-06-24
申请人： Oracle International Corporation
发明人： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
IPC分类号： H04L29/08 , H04L29/06
CPC分类号： H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
摘要： Transactional and non-transactional data for maintaining session state is described. In a session, a server instance receives, from a client, a request to execute transactional commands and non-transactional commands. The server instance sends at least one first directive executable at the client to store, in a first set of information, one or more first items representing one or more particular transactional commands that are open but not yet committed. The first set of information is maintained separately from a second set of information including one or more second items representing one or more particular non-transactional commands that have been processed. Based on committing one or more particular transactional commands, the server instance sends at least one second directive executable at the client to purge, from the first set of information, the one or more first items without purging, from the second set of information, the one or more second items.
摘要翻译：描述用于维护会话状态的事务和非事务性数据。在会话中，服务器实例从客户端接收执行事务命令和非事务命令的请求。服务器实例在客户端处发送至少一个第一指令可执行文件，以在第一组信息中存储一个或多个表示一个或多个已经开放但尚未提交的特定事务命令的第一项。第一组信息与第二组信息分开维护，包括表示一个或多个已处理的特定非事务性命令的一个或多个第二项。基于提交一个或多个特定事务命令，服务器实例在客户端发送至少一个第二指令可执行文件，从第一组信息中清除一个或多个第一项目，而不从第二组信息中清除一个或多个第二个项目。

9. 发明申请

US20150324354A1 SYSTEM AND METHOD FOR PLANNED MIGRATION OF SERVICE CONNECTIONS 有权
标题翻译：计划迁移服务连接的系统和方法
公开(公告)号：US20150324354A1
公开(公告)日：2015-11-12
申请号：US14273192
申请日：2014-05-08
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Nicolas Michael , Jean De Lavarene , Tong Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/303 , G06F12/0813 , G06F12/0815 , G06F12/0868 , G06F17/30345 , G06F17/30902 , G06F2212/465
摘要： A system and method for a planned migration of service connections from a first database instance to a second database instance in a clustered database. In accordance with an embodiment, a data source and connection pool enable access by a software application to a service on the first database instance. The data source is associated with a parameter specifying a delay-for-planned-draining, and a parameter specifying a planned-draining-period, which are used to rebalance connections when relocating a service. When a service is stopped on the first database instance, the connection pool receives a “service down” event from a notification service, and maintains the connections up to a time corresponding to the delay-for-planned-draining. When a “service up” event is received, the connection pool spreads migration of the connections from the first to second database instance over the planned-draining-period.
摘要翻译：一种用于计划将服务连接从第一数据库实例迁移到群集数据库中的第二数据库实例的系统和方法。根据实施例，数据源和连接池使软件应用程序能够访问第一数据库实例上的服务。数据源与指定计划排水延迟的参数相关联，以及指定计划排水期的参数，用于在重新定位服务时重新平衡连接。当在第一数据库实例上停止服务时，连接池从通知服务接收到“服务关闭”事件，并将连接维持到与计划排水延迟相对应的时间。当接收到“服务启动”事件时，连接池将连接从第一个数据库实例迁移到第二个数据库实例在计划排放期间。

10. 发明申请

US20140229531A1 TRANSACTIONAL AND NON-TRANSACTIONAL DATA FOR MAINTAINING SESSION STATE 有权
标题翻译：用于维护会议状态的交易和非交易数据
公开(公告)号：US20140229531A1
公开(公告)日：2014-08-14
申请号：US14231347
申请日：2014-03-31
申请人： Oracle International Corporation
发明人： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
IPC分类号： H04L29/06
CPC分类号： H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
摘要： Transactional and non-transactional data for maintaining session state is described. In a session, a server instance receives, from a client, a request to execute transactional commands and non-transactional commands. The server instance sends at least one first directive executable at the client to store, in a first set of information, one or more first items representing one or more particular transactional commands that are open but not yet committed. The first set of information is maintained separately from a second set of information including one or more second items representing one or more particular non-transactional commands that have been processed. Based on committing one or more particular transactional commands, the server instance sends at least one second directive executable at the client to purge, from the first set of information, the one or more first items without purging, from the second set of information, the one or more second items.
摘要翻译：描述用于维护会话状态的事务和非事务性数据。在会话中，服务器实例从客户端接收执行事务命令和非事务命令的请求。服务器实例在客户端处发送至少一个第一指令可执行文件，以在第一组信息中存储一个或多个表示一个或多个已经开放但尚未提交的特定事务命令的第一项。第一组信息与第二组信息分开维护，包括表示一个或多个已处理的特定非事务性命令的一个或多个第二项。基于提交一个或多个特定事务命令，服务器实例在客户端发送至少一个第二指令可执行文件，从第一组信息中清除一个或多个第一项目，而不从第二组信息中清除一个或多个第二个项目。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式