The swArchitect client offers Architects a Database Statistics Report that can provide evidence and input to decision making before any refactoring or changes to the meta model are executed.
- An installation of the SystemWeaver Architect client (swArchitect)
Viewing the Report
In the swArchitect client, you can generate this report from either the Metadata tab or the Refactorings tab.
|Note: For large databases, it is recommended that the report is generated only when no or few users are connected to the server, since the generation may affect the response time of the server.|
When the report is finished, it will open in a read-only Description editor:
The report contains three sections as described below. Any types with "0" counts will be highlighted in red, as seen in the above example. Types with "0" counts may be candidates for deletion, unless they are so recent that no one has had the chance to use them.
The Item Types section lists provides statistics on the use of all item types.
The SID of the item type.
The name of the item type.
The number of item instances of the item type. If the type is not used (count is 0), this is indicated by a red background color, and such types can be candidates for deletion, unless they are so recent that no one has had the chance to use them.
|Note: Abstract types are never uses, and will always indicate "0". Therefore, they are not highlighted in red.|
The number of parts which have used items of the type as Def Obj.
A high number indicates a high "effectivity" of the type since every item is used many times. A low number, relative to the Count may indicate that the item type may be better transformed into an attribute instead. Note, however, that some item types are supposed to be "top items" that are never used as parts.
Indicates the total number of nodes owned by the items. Note that all items (apart from Config Items) have at least one node, the top node of the item.
Indicates the ratio between the number of nodes and the number of parts owned by the items.
The maximum depth of the node trees. A high number may indicate the use of a "risky" construct that may yield high number of nodes.
A measurement of the total storage size for the items, including zipped description texts.
A measurement of the mean storage size.
Indicates whether the item type is set as an abstract type.
Indicates whether the item type is deprecated.
The Part Types section provides statistics on the use of all part types.
The SID of the part type.
The name of the part type.
The total number of parts of the type. If the number is 0, the value is highlighted in red.
The total number of nodes created for the parts of the type, for structural parts.
Node Use Count
The total number of times the nodes (for structural parts) are referenced, as node attributes or DefObj/RefObj node
references in parts. A value of 0 is highlighted in red. Such part types may be candidates for refactoring to simple part.
Use Part Name
Indicates whether parts of the type may have part names. If the value is True (i.e., part name may be used), but no part names are actually used (the Part Name Count value), the cell is highlighted in red, and the part type could be a candidate for losing its part name option.
Part Name Count
Total number of part names of the part, for parts where part names are allowed.
Indicates whether the part type is deprecated.
The Attribute Types section lists all Attribute types in the meta model.
The SID of the attribute type.
The name of the attribute type.
The total number of actual attribute values of the type.
A measurement of the total storage size for the attributes.
A measurement of the mean storage size.
Exporting the Report
The report can be saved to file using File > Save As... and selecting an available Save as type option.
Or, the content can be copied (Ctrl+A and Ctrl+C) and pasted into a MS Word document. The table content can then be copied and saved into an MS Excel file.