DATABASE METRICS BY TABLES |
Source Name |
Source Type |
Nr Segments |
Nr Lines |
Nr Fields |
Data Types |
Primary Keys |
Log Keys |
Nr Index |
Nr Relations |
Segment Size |
Data Points |
Function Points |
Nr Deficiencies |
LBANGP |
IMSDBD |
1 |
9 |
4 |
2 |
1 |
1 |
1 |
3 |
5000 |
16 |
7 |
3 |
LBANGS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LBBESP |
IMSDBD |
1 |
14 |
7 |
3 |
1 |
2 |
2 |
5 |
5000 |
27 |
10 |
4 |
LBBESS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LBBEST |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
4 |
14 |
7 |
3 |
LBBRII |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
15 |
14 |
7 |
3 |
LBBRIP |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
2500 |
14 |
7 |
4 |
LBGBWP |
IMSDBD |
1 |
15 |
10 |
3 |
1 |
2 |
5 |
5 |
1200 |
36 |
10 |
5 |
LBGBWS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
12 |
14 |
7 |
3 |
LBGBWT |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
16 |
14 |
7 |
3 |
LBHOKI |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
10 |
14 |
7 |
3 |
LBHOKP |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
300 |
14 |
7 |
3 |
LBLOGP |
IMSDBD |
1 |
15 |
8 |
3 |
1 |
2 |
3 |
5 |
5023 |
30 |
10 |
3 |
LBLOGS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
23 |
14 |
7 |
3 |
LBLOGT |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LBSAMP |
IMSDBD |
1 |
12 |
7 |
3 |
1 |
1 |
3 |
3 |
300 |
23 |
7 |
2 |
LBSAMS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
110 |
14 |
7 |
4 |
LBSPAP |
IMSDBD |
1 |
10 |
4 |
2 |
1 |
1 |
1 |
3 |
6100 |
16 |
7 |
3 |
LBSPAS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
30 |
14 |
7 |
3 |
LBST0P |
IMSDBD |
1 |
7 |
2 |
2 |
1 |
0 |
0 |
1 |
4015 |
6 |
7 |
4 |
LBVFGP |
IMSDBD |
1 |
12 |
7 |
3 |
1 |
2 |
2 |
5 |
400 |
27 |
10 |
3 |
LBVFGS |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LBVFGT |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
4 |
14 |
7 |
3 |
LBZB0P |
IMSDBD |
1 |
9 |
4 |
2 |
1 |
1 |
1 |
3 |
500 |
16 |
7 |
2 |
LBZB0S |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
20 |
14 |
7 |
3 |
LEABRP |
IMSDBD |
2 |
12 |
4 |
4 |
2 |
0 |
0 |
2 |
350 |
12 |
7 |
2 |
LEAD1P |
IMSDBD |
2 |
13 |
8 |
3 |
1 |
1 |
1 |
4 |
100 |
22 |
10 |
2 |
LEAD1S |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
13 |
14 |
7 |
3 |
LEAD2I |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
20 |
14 |
7 |
3 |
LEAD2P |
IMSDBD |
1 |
15 |
10 |
3 |
1 |
2 |
4 |
5 |
400 |
34 |
10 |
3 |
LEAD2S |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
20 |
14 |
7 |
3 |
LEANLP |
IMSDBD |
2 |
10 |
4 |
4 |
2 |
0 |
0 |
2 |
250 |
12 |
7 |
2 |
LEAVII |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
10 |
14 |
7 |
3 |
LEAVIP |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
20 |
14 |
7 |
3 |
LEBA1P |
IMSDBD |
1 |
13 |
6 |
3 |
1 |
1 |
2 |
3 |
1000 |
20 |
7 |
3 |
LEBA1S |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
28 |
14 |
7 |
3 |
LEBA2I |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
7 |
14 |
7 |
3 |
LEBA2P |
IMSDBD |
2 |
22 |
16 |
4 |
2 |
3 |
8 |
8 |
50 |
58 |
15 |
3 |
LEBA2S |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
13 |
14 |
7 |
3 |
LEBA2T |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
17 |
14 |
7 |
3 |
LEBA3I |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LEBA3P |
IMSDBD |
1 |
16 |
12 |
3 |
1 |
3 |
6 |
7 |
70 |
46 |
15 |
3 |
LEBA3S |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LEBA3T |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
9 |
14 |
7 |
3 |
LEBERP |
IMSDBD |
1 |
7 |
2 |
2 |
1 |
0 |
0 |
1 |
1000 |
6 |
7 |
4 |
LEBRIP |
IMSDBD |
3 |
14 |
8 |
5 |
3 |
1 |
1 |
5 |
1900 |
28 |
10 |
3 |
LEBRIS |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
14 |
14 |
7 |
3 |
LEBU1P |
IMSDBD |
4 |
24 |
14 |
6 |
3 |
1 |
2 |
6 |
30 |
38 |
15 |
2 |
LEBU1S |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
31 |
14 |
7 |
3 |
LEBUAP |
IMSDBD |
1 |
8 |
2 |
2 |
1 |
0 |
0 |
1 |
5200 |
6 |
7 |
4 |
LEDB1P |
IMSDBD |
1 |
12 |
7 |
2 |
1 |
2 |
3 |
5 |
500 |
29 |
10 |
2 |
LEDB1S |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
20 |
14 |
7 |
3 |
LEDB1T |
IMSDBD |
1 |
7 |
4 |
2 |
1 |
1 |
0 |
3 |
28 |
14 |
7 |
3 |
LEDE2P |
IMSDBD |
2 |
10 |
4 |
4 |
2 |
0 |
0 |
2 |
30 |
12 |
7 |
2 |
LEDE6P |
IMSDBD |
2 |
9 |
4 |
4 |
2 |
0 |
0 |
2 |
100 |
12 |
7 |
2 |
LEDICP |
IMSDBD |
1 |
8 |
2 |
2 |
1 |
0 |
0 |
1 |
100 |
6 |
7 |
3 |
LEDIPI |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
28 |
14 |
7 |
3 |
LEDIPP |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
6000 |
14 |
7 |
4 |
LEDP5P |
IMSDBD |
1 |
8 |
2 |
2 |
1 |
0 |
0 |
1 |
150 |
6 |
7 |
3 |
LEDU10 |
IMSDBD |
1 |
8 |
4 |
1 |
1 |
1 |
0 |
3 |
16 |
14 |
7 |
3 |
LEDU11 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
44 |
14 |
7 |
3 |
LEDU12 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
41 |
14 |
7 |
3 |
LEDU13 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
51 |
14 |
7 |
3 |
LEDU14 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
52 |
14 |
7 |
3 |
LEDU15 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
52 |
14 |
7 |
3 |
LEDU16 |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
51 |
14 |
7 |
3 |
LEDU17 |
IMSDBD |
1 |
8 |
4 |
2 |
0 |
1 |
0 |
3 |
44 |
12 |
7 |
4 |
LEDU18 |
IMSDBD |
1 |
8 |
4 |
2 |
0 |
1 |
0 |
3 |
41 |
12 |
7 |
4 |
LEDU1P |
IMSDBD |
9 |
81 |
45 |
11 |
3 |
9 |
16 |
27 |
130 |
155 |
15 |
3 |
LEEUPI |
IMSDBD |
1 |
8 |
4 |
2 |
1 |
1 |
0 |
3 |
255 |
14 |
7 |
4 |
|
DATABASE QUANTITY METRICS |
Total Number of DB Descriptions (DBDs) | 228 |
Total Number Program Specifications(PSBs) | 0 |
Total Number of DBD/PSB Code Lines | 2370 |
Total Number of DBD/PSB Comment Lines | 6319 |
Total Number of IMS Databases | 228 |
Total Number of IMS Database Segments | 315 |
Total Number of IMS Database Views | 0 |
Total Number of Data Attributes (Fields) | 1271 |
Total Number of Database View Attributes | 0 |
Total Number of different Data Types | 571 |
Total Number of primary Keys | 277 |
Total Number of logical Keys | 260 |
Total Number of DB-Indexes | 218 |
Total Number of DB Relationships | 835 |
Total Number of Database Levels | 3 |
Total Length of all Segments | 170603 |
Total Number of Test Cases required | 2302 |
Total Number of Data-Points | 4451 |
Total Number of Function-Points | 1772 |
Total Number of Deficiencies | 708 |
DATABASE COMPLEXITY METRICS |
Data Complexity | 0.960 |
Access Complexity | 0.312 |
Relational Complexity | 0.726 |
Structural Complexity | 0.040 |
Viewing Complexity | 0.100 |
Storage Complexity | 0.029 |
Average Database Complexity | 0.361 |
DATABASE QUALITY METRICS |
Data Independence | 0.540 |
Data Accessability | 0.374 |
Data Flexibility | 0.040 |
Data Testability | 0.040 |
Data Conformity | 0.701 |
Storage Efficiency | 0.120 |
Average Database Quality | 0.302 |