CN108475216B - 用于在多租户数据库环境中的连接的高效再利用的系统和方法 - Google Patents

用于在多租户数据库环境中的连接的高效再利用的系统和方法 Download PDF

Info

Publication number
CN108475216B
CN108475216B CN201780005289.8A CN201780005289A CN108475216B CN 108475216 B CN108475216 B CN 108475216B CN 201780005289 A CN201780005289 A CN 201780005289A CN 108475216 B CN108475216 B CN 108475216B
Authority
CN
China
Prior art keywords
connection
wait
pool
connections
request
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201780005289.8A
Other languages
English (en)
Chinese (zh)
Other versions
CN108475216A (zh
Inventor
J·德拉瓦瑞恩
Y·多高夫
V·赫格德
S·弗玛
C·S·K·马赫德哈拉
A·纳玛奇瓦亚姆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Oracle International Corp
Original Assignee
Oracle International Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Oracle International Corp filed Critical Oracle International Corp
Publication of CN108475216A publication Critical patent/CN108475216A/zh
Application granted granted Critical
Publication of CN108475216B publication Critical patent/CN108475216B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24552—Database cache management
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
    • G06F9/5061—Partitioning or combining of resources
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/10—Protocols in which an application is distributed across nodes in the network

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201780005289.8A 2016-08-03 2017-08-03 用于在多租户数据库环境中的连接的高效再利用的系统和方法 Active CN108475216B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US15/227,899 US11120036B2 (en) 2016-08-03 2016-08-03 System and method for efficient repurposing of connections in a multi-tenant database environment
US15/227,899 2016-08-03
PCT/US2017/045288 WO2018027028A1 (en) 2016-08-03 2017-08-03 System and method for efficient repurposing of connections in a multi-tenant database environment

Publications (2)

Publication Number Publication Date
CN108475216A CN108475216A (zh) 2018-08-31
CN108475216B true CN108475216B (zh) 2022-07-22

Family

ID=59626700

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201780005289.8A Active CN108475216B (zh) 2016-08-03 2017-08-03 用于在多租户数据库环境中的连接的高效再利用的系统和方法

Country Status (5)

Country Link
US (1) US11120036B2 (enExample)
EP (1) EP3494474B1 (enExample)
JP (1) JP7075888B2 (enExample)
CN (1) CN108475216B (enExample)
WO (1) WO2018027028A1 (enExample)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11323315B1 (en) * 2017-11-29 2022-05-03 Amazon Technologies, Inc. Automated host management service
US11151150B2 (en) 2019-09-13 2021-10-19 Salesforce.Com, Inc. Adjustable connection pool mechanism
US11636067B2 (en) 2019-10-04 2023-04-25 Salesforce.Com, Inc. Performance measurement mechanism
US11165857B2 (en) 2019-10-23 2021-11-02 Salesforce.Com, Inc. Connection pool anomaly detection mechanism
US11442928B2 (en) * 2019-11-04 2022-09-13 Amazon Technologies, Inc. Multi-tenant provider network database connection management and governance
US12050708B2 (en) * 2022-03-11 2024-07-30 Oracle International Corporation Cardinal method for hierarchical phased secure access to system entities in isolated multi-tenant database for autonomous cloud environments
US11943316B1 (en) * 2022-12-02 2024-03-26 Amazon Technologies, Inc. Database connection multiplexing for prepared statements
US12335163B2 (en) * 2023-11-08 2025-06-17 International Business Machines Corporation Managing a connection pool for cloud-based applications accessing databases

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7032003B1 (en) * 2001-08-13 2006-04-18 Union Gold Holdings, Ltd. Hybrid replication scheme with data and actions for wireless devices
US7207041B2 (en) * 2001-06-28 2007-04-17 Tranzeo Wireless Technologies, Inc. Open platform architecture for shared resource access management
CN101042660A (zh) * 2006-03-23 2007-09-26 松下电器产业株式会社 多任务系统中的任务执行环境切换方法
CN101183377A (zh) * 2007-12-10 2008-05-21 华中科技大学 一种基于消息中间件的高可用性数据库集群
US8015524B1 (en) * 2007-03-23 2011-09-06 Altera Corporation Method and apparatus for performing incremental delay annotation
CN103503416A (zh) * 2011-03-29 2014-01-08 日本电气株式会社 虚拟桌面系统、网络处理设备、管理方法和管理程序
CN103646111A (zh) * 2013-12-25 2014-03-19 普元信息技术股份有限公司 大数据环境下实现实时数据关联的系统及方法
CN105808638A (zh) * 2016-02-23 2016-07-27 平安科技（深圳）有限公司 数据处理方法和系统

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8145759B2 (en) 2002-11-04 2012-03-27 Oracle America, Inc. Dynamically configurable resource pool
US7937493B2 (en) * 2003-08-14 2011-05-03 Oracle International Corporation Connection pool use of runtime load balancing service performance advisories
US7953860B2 (en) * 2003-08-14 2011-05-31 Oracle International Corporation Fast reorganization of connections in response to an event in a clustered computing system
US7657892B2 (en) * 2004-05-20 2010-02-02 Bea Systems, Inc. System and method for application server with self-tuned threading model
GB0519981D0 (en) 2005-09-30 2005-11-09 Ignios Ltd Scheduling in a multicore architecture
US8943181B2 (en) * 2005-11-29 2015-01-27 Ebay Inc. Method and system for reducing connections to a database
US8413156B2 (en) * 2007-04-05 2013-04-02 Ebay, Inc. Method and system for managing resource connections
US8417723B1 (en) * 2008-09-12 2013-04-09 Salesforce.Com, Inc. System, method and computer program product for enabling access to a resource of a multi-tenant on-demand database service utilizing a token
US9251178B2 (en) * 2013-04-26 2016-02-02 Oracle International Corporation System and method for connection labeling for use with connection pools
CN104239365B (zh) * 2013-06-24 2018-09-04 北京新媒传信科技有限公司 一种获取数据库连接池中连接的方法和数据库连接池
US9229996B2 (en) * 2013-12-30 2016-01-05 Microsoft Technology Licensing, Llc Providing consistent tenant experiences for multi-tenant databases
JP6461167B2 (ja) * 2014-01-21 2019-01-30 オラクル・インターナショナル・コーポレイション アプリケーションサーバ、クラウドまたは他の環境においてマルチテナンシをサポートするためのシステムおよび方法
US10353910B2 (en) * 2016-07-15 2019-07-16 Ebay Inc. Preemptive connection pool adjustments

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7207041B2 (en) * 2001-06-28 2007-04-17 Tranzeo Wireless Technologies, Inc. Open platform architecture for shared resource access management
US7032003B1 (en) * 2001-08-13 2006-04-18 Union Gold Holdings, Ltd. Hybrid replication scheme with data and actions for wireless devices
CN101042660A (zh) * 2006-03-23 2007-09-26 松下电器产业株式会社 多任务系统中的任务执行环境切换方法
US8015524B1 (en) * 2007-03-23 2011-09-06 Altera Corporation Method and apparatus for performing incremental delay annotation
CN101183377A (zh) * 2007-12-10 2008-05-21 华中科技大学 一种基于消息中间件的高可用性数据库集群
CN103503416A (zh) * 2011-03-29 2014-01-08 日本电气株式会社 虚拟桌面系统、网络处理设备、管理方法和管理程序
CN103646111A (zh) * 2013-12-25 2014-03-19 普元信息技术股份有限公司 大数据环境下实现实时数据关联的系统及方法
CN105808638A (zh) * 2016-02-23 2016-07-27 平安科技（深圳）有限公司 数据处理方法和系统

Also Published As

Publication number Publication date
JP2019528490A (ja) 2019-10-10
EP3494474B1 (en) 2022-10-26
US20180039678A1 (en) 2018-02-08
JP7075888B2 (ja) 2022-05-26
WO2018027028A1 (en) 2018-02-08
US11120036B2 (en) 2021-09-14
CN108475216A (zh) 2018-08-31
EP3494474A1 (en) 2019-06-12

Similar Documents

Publication Publication Date Title
CN108475216B (zh) 用于在多租户数据库环境中的连接的高效再利用的系统和方法
US10909211B2 (en) System and method for control of maximum connections in a connection pool environment
US11593337B2 (en) Data processing method, device, and a storage medium
CN108475215B (zh) 用于在多租户数据库环境中提供租户的动态重新定位的系统和方法
US10742748B2 (en) System and method for supporting live addition of a tenant in a connection pool environment
US10331499B2 (en) Method, apparatus, and chip for implementing mutually-exclusive operation of multiple threads
US11290540B2 (en) System and method for use of server-side connection pool tagging in a multi-tenant environment
US10700869B2 (en) Access control and security for synchronous input/output links
US10824750B2 (en) System and method for performing connection validation in a multi-tenant environment
US12155621B2 (en) Network address translation between networks
CN115587119A (zh) 一种数据库查询方法、装置、电子设备及存储介质
CN105978744B (zh) 一种资源分配方法、装置及系统
US12058013B2 (en) Techniques for allocating capacity in cloud-computing environments
US11456919B2 (en) Input and output for target device communication
US11435906B2 (en) Method, electronic device and computer program product for storage management
US10164889B1 (en) High throughput flow control
EP3082050A1 (en) Mass data fusion storage method and system
CN117573041A (zh) 一种改进vhost-scsi提升虚拟化存储性能的方法
CN114726657A (zh) 中断管理和数据收发管理的方法、装置及智能网卡
HK1244575B (zh) 凭证数据发放方法、装置及系统

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant