Systems and methods for computer assisted database change documentation

Patent metadata

Field	Value
Publication number	US-11537590-B2
Application number	US-201815938825-A
Country	US
Kind code	B2
Filing date	Mar 28, 2018
Priority date	Mar 28, 2017
Publication date	Dec 27, 2022
Grant date	Dec 27, 2022

Abstract

Systems and methods for generating database schema change documents based on a data model and model changes indicated by a user. Information items related to one or more objects defined in the data model are received, and user input regarding changed objects is requested. In embodiments, changes are evaluated against configurable design criteria. One or more human and/or machine readable database schema change documents, and are stored in memory. Design criteria and change documents can vary based on a target database platform in embodiments.

First claim

The invention claimed is:

1. A system for generating database schema change documents based on one or more changes in a data model, the system comprising:
a non-volatile memory;
a data model interpreter configured to receive information items related to one or more objects defined in the data model;
a user interface configured to:
display at least one of the one or more information items to a user,
receive an indication of one or more changed objects from the user, and
receive one or more documentation inputs from the user, each documentation input associated with at least one changed object;

a validator configured to apply at least one rule defined by one or more design criteria to be met by the data model to each of the one or more changed objects and, in response to at least one changed object not satisfying the at least one rule, present a validation region including all changed objects not satisfying the at least one rule for the user to review prior to creation of one or more database schema change documents and prior to implementation of the data model on a target database, the validation region allowing the user to choose between deactivating the one or more design criteria or revising the one or more changed objects such that the at least one rule becomes satisfied; and
a documentation generator configured to, in response to the at least one change object satisfying the at least one rule or the unsatisfied data model criteria being deactivated, create, and store in the memory, the one or more database schema change documents, each database schema change document including one or more change requests, and each change request associated with at least one of the one or more changed objects and including each of the one or more documentation inputs associated with each of the one or more associated changed objects.

2. The system of claim 1 , wherein at least one of the database schema change documents is a human-readable document.

3. The system of claim 1 , wherein at least one of the database schema change documents is a machine-readable document, whereby each of the one or more change requests can be implemented programmatically.

4. The system of claim 1 , wherein the user interface is further configured to receive a platform selection input from a user, the platform selection input relating to one or more database platforms.

5. The system of claim 4 , wherein each of the one or more change requests is generated based on the platform selection input.

6. The system of claim 4 , wherein each of the one or more design criteria is associated with a database platform, and wherein the validator is further configured to evaluate only design criteria that are associated with the one or more database platforms relating to the platform selection input.

7. The system of claim 1 , wherein each of the design criteria is selected from the group consisting of: naming criteria, size criteria, and relationship criteria.

8. The system of claim 1 , wherein the user interface is further configured to display each of the database schema change documents to the user.

9. The system of claim 1 , wherein the data model interpreter is configured to receive the information related to one or more objects defined in the data model programmatically from a modeling tool.

10. A method for generating database schema change documents based on one or more changes in a data model, the method comprising:
receiving one or more information items related to one or more objects defined in the data model;
presenting a user interface and displaying at least one of the one or more information items to a user through the user interface;
receiving an indication of one or more changed objects from the user;
receiving one or more documentation inputs from the user, each documentation input associated with at least one changed object;
applying at least one rule defined by one or more design criteria to be met by the data model to each of the one or more changed objects and, in response to at least one changed object not satisfying the at least one rule, presenting a validation region including all changed objects not satisfying the at least one rule for the user to review prior to creation of one or more database schema change documents and prior to implementation of the data model on a target database, the validation region allowing the user to choose between deactivating the one or more design criteria or revising the one or more changed objects such that the at least one rule becomes satisfied; and
creating, in response to the at least one change object satisfying the at least one rule or the unsatisfied data model criteria being deactivated, one or more database schema change documents, each database schema change document including one or more change requests, and each change request associated with at least one of the one or more changed objects and including each of the one or more documentation inputs associated with each of the one or more associated changed objects; and
storing the database schema changes in a non-volatile memory.

11. The method of claim 10 , wherein at least one of the database schema change documents is a human-readable document.

12. The method of claim 10 , wherein at least one of the database schema change documents is a machine-readable document, whereby each of the one or more change requests can be implemented programmatically.

13. The method of claim 10 , further comprising receiving a platform selection input relating to one or more database platforms from the user.

14. The method of claim 13 , wherein each of the one or more change requests is generated based on the platform selection input.

15. The method of claim 13 , wherein each of the one or more design criteria is associated with a database platform, the method further comprising evaluating only design criteria that are associated with the one or more database platforms relating to the platform selection input.

16. The method of claim 10 , wherein each of the design criteria is selected from the group consisting of: naming criteria, size criteria, and relationship criteria.

17. The method of claim 10 , further comprising displaying each of the database schema change documents to the user.

18. The method of claim 10 , wherein the information related to one or more objects defined in the data model is received programmatically from a modeling tool.

Assignees

• Walmart Apollo Llc

Inventors

• Austin Daniel Bryan
• Spicer Chris

Classifications

• G06F16/212

  with details for data modelling support · CPC title

• G06F16/23

  Updating · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F16/213 Primary

  with details for schema evolution support · CPC title

• G06F16/2358 Primary

  Change logging, detection, and notification (replication G06F16/27) · CPC title