Automated OODBMS Schema Generation from Textual Requirements

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current methods for developing Object-Oriented Database Management System (OODBMS) schemas from high-level requirements are time-consuming and require technical expertise, involving multiple steps such as analyzing requirements, creating Object Relationship Diagrams, and testing relational DB tables.

Innovation Solution

A system and method that automatically generate an OODBMS schema directly from textual requirements documents using a processor to identify ASCII-based sentences, parse nouns and attributes, and create key-value data structures to map objects and their relationships, eliminating the need for technical expertise.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If automatic generation from plain text requirements is implemented, then productivity and speed are improved, but manufacturing precision and reliability may worsen due to lack of technical expertise validation

Engineering Contradiction:

Improveschema generation speedVSAvoidschema accuracy

Core Design Contradiction:

ProductivityVSManufacturing precision

Solution Approach 1:

The patent introduces an intermediary processing layer between plain text requirements and OODBMS schema generation. This intermediary automatically performs linguistic analysis, entity extraction, and relationship mapping to bridge the gap between natural language and formal database schemas, enabling accurate automatic generation without requiring technical expertise in the input phase

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system enables self-service automatic schema generation where the requirements text itself contains sufficient information for the system to autonomously generate the OODBMS schema. The plain text requirements are processed through automated linguistic analysis and entity recognition to extract all necessary schema definition information without human intervention

Inventive Principle:

Principle #25Self-service

2Manufacturing precision

If manual analysis by skilled technical resources is used, then manufacturing precision and reliability are improved, but productivity and speed deteriorate due to time-consuming processes

Engineering Contradiction:

Improveschema accuracyVSAvoidschema generation speed

Core Design Contradiction:

Manufacturing precisionVSProductivity

Solution Approach 1:

The patent replaces the mechanical manual analysis process with an automated computational system. Instead of skilled technical resources manually analyzing requirements and creating schemas, the system uses automated linguistic analysis, natural language processing, and algorithmic entity extraction to perform the same function much faster while maintaining accuracy

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

3Manufacturing precision

If multiple development steps including ORD creation and table testing are followed, then manufacturing precision is improved, but device complexity and ease of operation worsen

Engineering Contradiction:

Improveschema accuracyVSAvoidprocess complexity

Core Design Contradiction:

Manufacturing precisionVSDevice complexity

Solution Approach 1:

The patent merges multiple separate development steps (requirements analysis, ORD creation, schema generation, and validation) into a single integrated automatic process. The system combines linguistic analysis, entity extraction, relationship mapping, and schema generation into one unified workflow that processes plain text requirements directly into OODBMS schemas without requiring separate manual steps

Inventive Principle:

Principle #5Merging (Combining)

4Manufacturing precision

If multiple development steps including ORD creation and table testing are followed, then manufacturing precision is improved, but ease of operation deteriorates due to requirement of technical expertise

Engineering Contradiction:

Improveschema accuracyVSAvoidease of requirements input

Core Design Contradiction:

Manufacturing precisionVSEase of operation

Solution Approach 1:

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent introduces an intermediary processing layer that automatically handles the transformation from plain text to formal schema. This intermediary performs all necessary technical analysis and validation steps automatically, allowing users to input simple plain text requirements without needing to understand complex database design concepts

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS10963433B2ASCII based instant object oriented schema generation

Publication Date: 2021.03.30 KYNDRYL INC

AI summary

A method, a system and a computer program product for automated ASCII-based object-oriented database schema (OODBS) generation. A parser runs through text sentences of a textual document from a requirements gathering team that includes object-oriented application requirements, and identifies nouns corresponding to an object, and each noun's attributes. An Object-oriented dictionary based ASCII interpreter analyzes the ASCII of the captured requirements. For each identified noun, the system creates first key-value structures mapping each identified object to one or more associated attributes. There is further identified, from the created first key-value structures, any attributes that reference to an identified object, and for each of these identified objects, the system creates second key-value structures mapping, for each attribute identified as a reference, associating a corresponding key where the reference is found as an attribute. An ASCII-based OODB schema is generated based on the first key-values and second key-value structures mappings.