Automatic Notebook-Pipeline Synchronization for Regulatory Auditability

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Regulators do not readily accept outcomes from statistical and machine learning modeling due to the lack of transparency in notebook interfaces, leading to disconnection between business users and data scientists, making collaborative configuration and regulatory oversight challenging.

Innovation Solution

The system enables automatic two-way generation and synchronization of notebook and pipeline interfaces, allowing business users to design business logic declaratively, with notebook code automatically generated, ensuring real-time synchronization and providing a low-code/no-code data science platform.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If notebook interfaces are used for scripting statistical and machine learning models, then data scientists can develop predictive models, but business users become disconnected from the underlying business logic, reducing auditability and regulatory oversight

Engineering Contradiction:
Improvemodel development efficiencyVSAvoidauditability and explainability
Core Design Contradiction:
ProductivityVSLoss of information

Solution Approach 1:

The patent creates a pipeline representation that is a simplified copy or abstraction of the notebook code. The pipeline captures the essential business logic and data flow in a visual, understandable format that business users can review, while the full notebook code remains available for execution. This copying approach maintains auditability without sacrificing development efficiency.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The pipeline serves as an intermediary layer between the notebook code and business users. It translates complex notebook scripts into a visual workflow representation that business users can understand and validate, while still being executable. This intermediary maintains the connection between technical implementation and business logic without requiring business users to directly interact with complex code.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If notebook interfaces are used for development, then flexibility in scripting is improved, but regulatory approval and collaborative configuration become challenging

Engineering Contradiction:
Improvescripting flexibilityVSAvoidcollaborative configuration
Core Design Contradiction:
Adaptability or versatilityVSEase of operation

Solution Approach 1:

The patent segments the development process into two distinct but connected representations: the notebook for flexible scripting and the pipeline for visual configuration. Each serves its specific purpose - the notebook maintains scripting flexibility for data scientists, while the pipeline provides ease of operation for business users through visual drag-and-drop configuration and clear data flow representation.

Inventive Principle:
Principle #1Segmentation

3Productivity

If traditional notebook interfaces are used, then data science capabilities are enabled, but transparency and verification of model logic are reduced

Engineering Contradiction:
Improvedata science capabilityVSAvoidtransparency and verification
Core Design Contradiction:
ProductivityVSDifficulty of detecting and measuring

Solution Approach 1:

The pipeline interface uses visual differentiation (analogous to color changes) to clearly distinguish between different types of operations, data sources, and transformations. Visual cues such as node types, connection styles, and labeling make the data flow and business logic immediately apparent, enabling easy verification and transparency without compromising data science capabilities.

Inventive Principle:
Principle #32Color changes

Data Source

PatentUS12169683B2Automatic two-way generation and synchronization of notebook and pipeline
Publication Date: 2024.12.17 ORACLE FINANCIAL SERVICES SOFTWARE
  • US12169683B2 patent drawing
  • US12169683B2 patent drawing
  • US12169683B2 patent drawing

AI summary

Systems, methods, and other embodiments associated with associated with automatic two-way generation and synchronization of notebook and pipeline are described. In one embodiment, a computer-implemented method includes: identifying a difference between pipeline and notebook representations of application logic, wherein the difference is one of (i) a notebook paragraph without a corresponding pipeline node and (ii) a pipeline node without a corresponding notebook paragraph; synchronizing the pipeline representation and notebook representation by, for the notebook paragraph that does not have a corresponding pipeline node, automatically generating a new pipeline node in the pipeline representation, and for the pipeline node that does not have a corresponding notebook paragraph, automatically generating a new notebook paragraph in the notebook representation; and updating either a pipeline user interface to show the new pipeline node or a notebook user interface to show the new notebook paragraph.