Automated Source Code Review for Transaction Integrity

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Large-scale data stores face inefficiencies due to the complexity of reviewing transaction and datasource configuration source code, which can lead to inconsistent and inefficient deployables, especially when multiple groups with different specialties contribute to different types of source code.

Innovation Solution

A computer-implemented method for automatically reviewing transaction and datasource configuration source code files by checking for compliance with guidelines, including the presence of a transaction manager definition, exception handling, and datasource definitions, and issuing a halt or proceed signal based on compliance.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual source code review is performed by data store managers and IT personnel, then code quality and performance can be ensured, but the review process becomes time-consuming and delays deployment

Engineering Contradiction:
Improvecode qualityVSAvoiddeployment time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs automated self-review of source code using predefined guidelines and rules. The review process does not require external human intervention - the system automatically analyzes code files, checks for compliance with transaction and datasource configuration guidelines, and generates review results, thereby eliminating the time loss associated with manual review while maintaining code quality standards

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The manual mechanical review process by human personnel is replaced with an automated computational system. The system uses computer-implemented methods to parse, analyze, and evaluate source code files against predefined guidelines, substituting human manual inspection with automated computational analysis that is both faster and equally effective at ensuring code quality

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Adaptability or versatility

If multiple groups with different specialties write different types of source code, then code specialization and expertise are utilized, but inconsistencies and inefficiencies arise in deployables

Engineering Contradiction:
Improvecode specializationVSAvoidcode consistency
Core Design Contradiction:
Adaptability or versatilityVSStability of the object's composition

Solution Approach 1:

The review system serves multiple groups and multiple types of source code files (transaction code, datasource configuration code, and combined files) through a single universal platform. The system applies the same comprehensive guidelines to all code types, ensuring consistent review standards across different specialized teams while accommodating the specific requirements of each code type

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

Solution Approach 2:

The system enforces homogeneous review standards and guidelines across all source code files regardless of which group created them. By applying uniform criteria for transaction definitions, datasource configurations, and coding best practices to all code, the system ensures consistency in deployables while preserving the specialized expertise of different development groups

Inventive Principle:
Principle #33Homogeneity

Data Source

PatentUS10592391B1Automated transaction and datasource configuration source code review
Publication Date: 2020.03.17 STATE FARM MUTAL AUTOMOBILE INSURANCE COMPANY
  • US10592391B1 patent drawing
  • US10592391B1 patent drawing
  • US10592391B1 patent drawing

AI summary

A computer-implemented automated review method for transaction and datasource configuration source code files seeking to access a data store comprises the steps of receiving a request to review configuration source code files seeking to access the data store; checking the configuration source code files for a definition of a transaction manager; setting an issue flag if the configuration source code files do not include the definition of the transaction manager; checking the configuration source code files to determine whether a transaction definition is at an outer boundary of a service object or a method; setting the issue flag if the transaction definition does not appear before the start of the service object class or method definition; reviewing the status of the issue flag; issuing a halt signal if the issue flag is set; and issuing a proceed signal if the issue flag is not set.