JP7075888B2 - マルチテナント・データベース環境における接続の効率的な転用のためのシステム、コンピュータで実施する方法、コンピュータプログラムおよび装置 - Google Patents

マルチテナント・データベース環境における接続の効率的な転用のためのシステム、コンピュータで実施する方法、コンピュータプログラムおよび装置 Download PDF

Info

Publication number
JP7075888B2
JP7075888B2 JP2018533871A JP2018533871A JP7075888B2 JP 7075888 B2 JP7075888 B2 JP 7075888B2 JP 2018533871 A JP2018533871 A JP 2018533871A JP 2018533871 A JP2018533871 A JP 2018533871A JP 7075888 B2 JP7075888 B2 JP 7075888B2
Authority
JP
Japan
Prior art keywords
connection
pool
double
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
JP2018533871A
Other languages
English (en)
Japanese (ja)
Other versions
JP2019528490A (ja
JP2019528490A5 (enExample
Inventor
ドゥ・ラバルネ，ジャン
ドルゴブ，ユーリ
ヘグド，ビディヤ
バーマ，サウラブ
マヒダラ，チャンドラ・セカール・クリシュナ
ナマチバヤム，アラムバラータナタン
Original Assignee
オラクル・インターナショナル・コーポレイション
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 オラクル・インターナショナル・コーポレイション filed Critical オラクル・インターナショナル・コーポレイション
Publication of JP2019528490A publication Critical patent/JP2019528490A/ja
Publication of JP2019528490A5 publication Critical patent/JP2019528490A5/ja
Application granted granted Critical
Publication of JP7075888B2 publication Critical patent/JP7075888B2/ja
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)
JP2018533871A 2016-08-03 2017-08-03 マルチテナント・データベース環境における接続の効率的な転用のためのシステム、コンピュータで実施する方法、コンピュータプログラムおよび装置 Active JP7075888B2 (ja)

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 (3)

Publication Number Publication Date
JP2019528490A JP2019528490A (ja) 2019-10-10
JP2019528490A5 JP2019528490A5 (enExample) 2020-05-14
JP7075888B2 true JP7075888B2 (ja) 2022-05-26

Family

ID=59626700

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2018533871A Active JP7075888B2 (ja) 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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080250419A1 (en) 2007-04-05 2008-10-09 Ebay Inc. Method and system for managing resource connections
JP2013239199A (ja) 2005-09-30 2013-11-28 Synopsys Inc マルチコアアーキテクチャにおけるスケジューリング
US20140324911A1 (en) 2013-04-26 2014-10-30 Oracle International Corporation Support for cloud-based multi-tenant environments using connection labeling

Family Cites Families (18)

* 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
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
US8943181B2 (en) * 2005-11-29 2015-01-27 Ebay Inc. Method and system for reducing connections to a database
JP2007257257A (ja) * 2006-03-23 2007-10-04 Matsushita Electric Ind Co Ltd マルチタスクシステムにおけるタスク実行環境切替え方法
US8015524B1 (en) * 2007-03-23 2011-09-06 Altera Corporation Method and apparatus for performing incremental delay annotation
CN101183377B (zh) * 2007-12-10 2010-09-08 华中科技大学 一种基于消息中间件的高可用性数据库集群系统
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
US20140019525A1 (en) * 2011-03-29 2014-01-16 Nec Corporation Virtual desktop system, network processing device, and management method and management program thereof
CN104239365B (zh) * 2013-06-24 2018-09-04 北京新媒传信科技有限公司 一种获取数据库连接池中连接的方法和数据库连接池
CN103646111B (zh) * 2013-12-25 2017-02-15 普元信息技术股份有限公司 大数据环境下实现实时数据关联的系统及方法
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 オラクル・インターナショナル・コーポレイション アプリケーションサーバ、クラウドまたは他の環境においてマルチテナンシをサポートするためのシステムおよび方法
CN105808638B (zh) * 2016-02-23 2019-03-29 平安科技（深圳）有限公司 数据处理方法和系统
US10353910B2 (en) * 2016-07-15 2019-07-16 Ebay Inc. Preemptive connection pool adjustments

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2013239199A (ja) 2005-09-30 2013-11-28 Synopsys Inc マルチコアアーキテクチャにおけるスケジューリング
US20080250419A1 (en) 2007-04-05 2008-10-09 Ebay Inc. Method and system for managing resource connections
US20140324911A1 (en) 2013-04-26 2014-10-30 Oracle International Corporation Support for cloud-based multi-tenant environments using connection labeling

Also Published As

Publication number Publication date
JP2019528490A (ja) 2019-10-10
EP3494474B1 (en) 2022-10-26
US20180039678A1 (en) 2018-02-08
CN108475216B (zh) 2022-07-22
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
JP7075888B2 (ja) マルチテナント・データベース環境における接続の効率的な転用のためのシステム、コンピュータで実施する方法、コンピュータプログラムおよび装置
US20230273937A1 (en) Conditional master election in distributed databases
US10909211B2 (en) System and method for control of maximum connections in a connection pool environment
US10191922B2 (en) Determining live migration speed based on workload and performance characteristics
US10963282B2 (en) Computing service with configurable virtualization control levels and accelerated launches
JP7336554B2 (ja) マルチテナント・データベース環境においてテナントの動的再配置を提供するためのシステムおよび方法
JP6675419B2 (ja) シャードされたデータベースへのアクセスをキャッシュおよびシャードトポロジを用いて提供するためのシステムおよび方法
US10742748B2 (en) System and method for supporting live addition of a tenant in a connection pool environment
EP3688598B1 (en) Method for reading data stored in a non-volatile cache using rdma
US11290540B2 (en) System and method for use of server-side connection pool tagging in a multi-tenant environment
US20140089260A1 (en) Workload transitioning in an in-memory data grid
CN101542448B (zh) 多处理器存储区域网中锁定管理器的轮换
US10824750B2 (en) System and method for performing connection validation in a multi-tenant environment
CN118051921A (zh) 本地多租户行表加密
US8677014B2 (en) Fine granularity exchange level load balancing in a multiprocessor storage area network
US10397130B2 (en) Multi-cloud resource reservations
US11943316B1 (en) Database connection multiplexing for prepared statements

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20200401

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20200401

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20210421

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20210721

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20211116

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20211125

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20220420

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20220516

R150 Certificate of patent or registration of utility model

Ref document number: 7075888

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250