Granular Update Deployment in Multi-Tenant Database Systems

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional database network systems face inefficiencies and incompleteness when migrating data between environments, particularly in updating changes across environments, requiring manual rekeying and developer-centric tools that demand a low-level understanding of components.

Innovation Solution

The implementation of mechanisms and methods for deploying updates between environments of a multi-tenant on-demand database system, allowing for user-friendly, granular, and targeted updates by creating an update in one environment and deploying it to another, using a user interface to specify the update and its deployment, thereby avoiding the need for manual recoding and ensuring only updated components are deployed.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual rekeying or developer-centric tools are used for migrating changes between environments, then the system can maintain control over data migration, but the complexity and expertise required increases significantly

Engineering Contradiction:
Improvecontrol over data migrationVSAvoidcomplexity and expertise required
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The system enables users to create updates through a simplified user interface without requiring manual rekeying or deep technical knowledge. The update creation process automatically captures changes and packages them for deployment to other environments, allowing end-users to perform migrations independently without developer intervention or complex tools.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system introduces an intermediary layer between the user and the complex data migration process. This intermediary automatically detects changes, generates update packages, and handles the deployment process, shielding users from the underlying complexity while maintaining reliable control over data migration between environments.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Ease of manufacture

If conventional data copying techniques are used, then the migration process is simple, but the updates are inefficient and incomplete for changing environments

Engineering Contradiction:
Improvesimplicity of migration processVSAvoidefficiency and completeness of updates
Core Design Contradiction:
Ease of manufactureVSProductivity

Solution Approach 1:

The system performs preliminary detection and packaging of changes before deployment. By automatically identifying what needs to be updated and pre-packaging it in the correct format, the system ensures that updates are both simple to initiate and complete and efficient in their execution, avoiding the incompleteness of conventional copying.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system incorporates feedback mechanisms that track what has been updated and verify the deployment process. This feedback loop ensures completeness by confirming that all necessary changes are successfully applied to the target environment, while the automated packaging maintains simplicity throughout the process.

Inventive Principle:
Principle #23Feedback

3Stability of the object's composition

If updates are deployed to all environments, then consistency across the system is maintained, but unnecessary changes are propagated and system complexity increases

Engineering Contradiction:
Improveconsistency across systemVSAvoidsystem complexity and update scope
Core Design Contradiction:
Stability of the object's compositionVSDevice complexity

Solution Approach 1:

The system segments the deployment process by allowing users to select specific target environments for updates. Instead of automatically propagating to all environments, the update can be directed to particular environments where the changes are relevant, reducing unnecessary propagation while maintaining consistency where needed.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system applies local quality by enabling environment-specific update deployment. Each environment can receive updates selectively based on its specific needs and configuration, allowing different environments to have different levels of update application while maintaining overall system consistency through controlled propagation.

Inventive Principle:
Principle #3Local quality

Data Source

PatentUS10146526B2System, method and computer program product for deploying an update between environments of a multi-tenant on-demand database system
Publication Date: 2018.12.04 SALESFORCE INC
  • US10146526B2 patent drawing
  • US10146526B2 patent drawing
  • US10146526B2 patent drawing

AI summary

In accordance with embodiments, there are provided mechanisms and methods for deploying updates between environments of a multi-tenant on-demand database system. These mechanisms and methods for deploying updates between environments of a multi-tenant on-demand database system can enable embodiments to provide user-friendly, granular, and/or targeted updates between such environments.