Evaluating a database design and modifications thereto

摘要

Embodiments include method, systems and computer program products for evaluating a database design. Aspects include receiving a first database definition for a first database comprising multiple database object definitions; receiving database design rules; calculating object scores representing a compliance between the database object definitions with the database design rules; calculating a first database score based on the object scores; receiving a second database definition for a proposed modification to the first database, wherein the second database definition includes modified database object definitions; calculating object scores representing a compliance between the modified database object definitions of the second database definition with the one or more database design rules; calculating a second database score based on the object scores; displaying the first and second database score; displaying a cause of a difference between the first and second database scores; and receiving an indication of whether to implement the second database definition.

主权项

1. A computer-implemented method for evaluating database designs comprising:
receiving, by a processing device, a first database definition representing a first database, wherein the first database definition comprises one or more database object definitions; receiving one or more database design rules; calculating object scores representing a compliance between each of the one or more database object definitions of the first database definition with the one or more database design rules; calculating a first database score based on the object scores corresponding to the first database definition; receiving, by the processing device, a second database definition representing a proposed modification to the first database, wherein the second database definition includes one or more modified database object definitions; calculating object scores representing a compliance between each of the one or more modified database object definitions of the second database definition with the one or more database design rules; calculating a second database score based on the object scores corresponding to the second database definition; displaying, to a user, the first database score and the second database score; displaying a cause of a difference between the first database score and the second database score; and receiving, from the user, an indication of whether to implement the second database definition.