Change Cache Database for Repository Change Visibility

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Client devices lack visibility into changes made to a repository and struggle to organize and search changes effectively, hindering understanding of infrastructure development and modification over time.

Innovation Solution

A change cache database is generated by client devices, which stores and summarizes information from changesets, allowing for searchable and structured analysis of changes made to the repository, including changes made by other users over a specific time span.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If changesets are stored and transmitted to the modeling hub services software, then visibility into repository changes is improved, but memory requirements on client devices increase

Engineering Contradiction:
Improvevisibility into repository changesVSAvoidmemory requirements
Core Design Contradiction:
Loss of informationVSQuantity of substance

Solution Approach 1:

The patent extracts only the essential change information from complete changesets to create change summaries stored in the change cache database. This extraction process retains visibility into repository changes while significantly reducing the memory footprint on client devices by storing only summarized change data rather than complete changeset information.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent implements a disposable changeset approach where complete changesets are transmitted to the modeling hub services software and then discarded from client device memory. Only essential change summaries are retained in the change cache database, allowing client devices to maintain change visibility without long-term storage burdens.

Inventive Principle:
Principle #27Cheap short-living objects (Disposable)

2Loss of information

If changes are organized in a searchable manner, then understanding of infrastructure development is improved, but device complexity increases

Engineering Contradiction:
Improveunderstanding of infrastructure developmentVSAvoidsearchable database structure
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The patent segments change information into structured tables within the change cache database, organizing changes by type, element, author, and timestamp. This segmentation enables efficient searching and analysis of infrastructure development while keeping the database structure manageable through logical division of change data into discrete, queryable components.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The change cache database acts as an intermediary layer between the raw changesets transmitted from client devices and the user's need to understand infrastructure development. This intermediary structure provides searchable access to change information without requiring users to directly navigate complex changeset data, simplifying the user interface while maintaining comprehensive change tracking.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Loss of information

If complete changesets are retained on client devices, then analysis capability is improved, but loss of time for transmission and storage increases

Engineering Contradiction:
Improveanalysis capabilityVSAvoidtransmission and storage time
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The patent extracts essential change information from complete changesets to create summaries stored in the change cache database. This extraction enables clients to perform analysis on change patterns, trends, and impacts without needing to transmit, store, or process complete changeset data, significantly reducing transmission and storage time while preserving analytical capability.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent performs preliminary processing of changesets by generating change summaries before transmission to the modeling hub services software. This preliminary action extracts and stores only the essential information needed for analysis, allowing clients to maintain strong analysis capability while minimizing the time and resources required for changeset transmission and long-term storage.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11226953B2Technique for generating a change cache database utilized to inspect changes made to a repository
Publication Date: 2022.01.18 BENTLEY SYSTEMS INC
  • US11226953B2 patent drawing
  • US11226953B2 patent drawing
  • US11226953B2 patent drawing

AI summary

In one embodiment, techniques are provided for generating a change cache database utilized to inspect changes made to a repository. Specifically, each of a plurality of client devices may maintain and make changes to a local briefcase representing an infrastructure and obtained from the repository. Information associated with each of the changes may be maintained and stored in a changeset at the client device and then transmitted and stored at a modeling hub services software. A change cache database may be generated at a client device based on locally generated changesets and/or received changesets. The change cache database includes a plurality of tables that store summary information from the changesets. The client device that generated and stores the change cache database may search the change cache database to determine what changes have been made to the repository.