Use case 1 - JEE, HTML5 and Oracle

Introduction

After moving from Oracle AIP to SQL Analyzer as explained here Transitioning from Oracle Server, at the end of the new scan the following report has been generated: SQLAnalyzerMetricsReport.csv

During transition, Oracle source will not change, the same extraction will now be analyzed by SQL Analyzer. A new UA analysis unit, equivalent of all previous Oracle analysis units, has been added. Dependency between “JEE and the new SQL analysis unit”, and “HTML5 analysis unit and the new SQL analysis unit” has been added at the end.

New dashboard

Now, you can also note the SQL quality rules applied on client code, e.g.:

Numbers

Before After
Nb of modules: 1
Nb of active analysis units: 6
Nb of inactive analysis units: 0
Total nb of analysis units: 6
Nb of saved objects: 98504
Nb of modules: 1
Nb of active analysis units: 4
Nb of inactive analysis units: 0
Total nb of analysis units: 4
Nb of saved objects: 99243

Number of applications with full call graph : 1 (#31461)
Number of relevant objects in repository : 109846
Number of OMG AFP-links in repository : 163976
Number of DF records / TR end points : 2657
Number of transactions : 718
Number of empty transactions : 481
Number of links -> DF records / TR end points : 3502
Number of links -> other objects in full graph : 75413
Number of transaction links generated (sum) : 78915
Number of objects in largest transaction : 699
Number of elements in largest SCC group : 10

Number of applications with full call graph : 1 (#31461)
Number of relevant objects in repository : 101457
Number of OMG AFP-links in repository : 180292
Number of DF records / TR end points : 11119
Number of transactions : 718
Number of empty transactions : 352
Number of links -> DF records / TR end points : 4130
Number of links -> other objects in full graph : 74515
Number of transaction links generated (sum) : 78645
Number of objects in largest transaction : 696
Number of elements in largest SCC group : 10