Multitenant Data Source Configuration via Partition Overrides

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In multitenant application server environments, existing technologies face challenges in efficiently managing and configuring data sources across partitions, leading to administrative overhead and infrastructure costs due to the need for partition-based configuration, runtime monitoring, security, and diagnostics.

Innovation Solution

A system and method that includes an application server environment with multiple partitions and a resource group template, where the data source configuration can be overridden with attributes specific to each partition, enabling the creation of data source objects for database connections, monitoring, and diagnostics.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If traditional application server data sources are modified for cloud multitenant environments, then deployment density and resource efficiency are improved, but configuration complexity and administrative overhead increase

Engineering Contradiction:
Improvedeployment densityVSAvoidconfiguration complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent divides the data source configuration into template-based reusable components that can be selectively applied to different partitions. Each partition can inherit a base template and then override only the specific attributes needed for its database connection, reducing overall configuration complexity while enabling dense multi-tenant deployment.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The data source template serves multiple partitions and tenants universally, providing a single reusable configuration that can be applied across different cloud environments. This universal template approach eliminates the need for separate configuration files for each tenant, improving deployment density while maintaining ease of configuration.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Reliability

If partition-based configuration is implemented for data sources, then tenant isolation and security are improved, but administrative overhead and operational costs increase

Engineering Contradiction:
Improvetenant isolationVSAvoidadministrative overhead
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent pre-configures data source templates with default secure settings and connection parameters before they are needed. When a partition is created, the system automatically applies the appropriate template, eliminating the need for manual configuration of isolation and security settings for each partition, thus reducing administrative overhead while maintaining tenant isolation.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system allows partitions to override specific parameters of the data source template (such as database URL, username, password) while maintaining the same secure infrastructure. This parameter-based customization enables tenant isolation through simple attribute changes rather than complex reconfiguration, reducing operational time and costs.

Inventive Principle:
Principle #35Parameter changes

3Adaptability or versatility

If data source configurations are customized for each partition, then partition-specific database connectivity is improved, but configuration management complexity increases

Engineering Contradiction:
Improvepartition-specific connectivityVSAvoidconfiguration management complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent uses template copying where a base data source configuration template is copied and applied to multiple partitions. Each partition receives a copy of the template with pre-configured secure connection parameters, and can then override only the necessary attributes for its specific database. This copying approach simplifies management by reusing the same template across all partitions rather than maintaining unique configurations.

Inventive Principle:
Principle #26Copying

Data Source

PatentUS9967324B2System and method for providing data sources for use in a multitenant application server environment
Publication Date: 2018.05.08 ORACLE INT CORP
  • US9967324B2 patent drawing
  • US9967324B2 patent drawing
  • US9967324B2 patent drawing

AI summary

In accordance with an embodiment, an application server environment can include a plurality of partitions and a resource group template, which can be referenced by a resource group in one or more of the plurality of partitions. A data source configuration can be defined as part of the resource group template. The data source configuration can be overridden with attributes specific to a particular referencing partition. A data source subsystem can create a data source object in accordance with the overridden data source configuration, for use in creating connections to a database associated with the particular referencing partition, monitoring and diagnosing the data source object.