Use case 4 - 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 be now 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 SQL quality rules applied on client code, e.g.:

Numbers

Before After
Nb of modules: 1
Nb of active analysis units: 54
Nb of inactive analysis units: 0
Total nb of analysis units: 54
Nb of saved objects: 104648
Nb of modules: 1
Nb of active analysis units: 51
Nb of inactive analysis units: 0
Total nb of analysis units: 51
Nb of saved objects: 103291

Number of applications with full call graph: 1 (#32602)
Number of relevant objects in repository: 103346
Number of OMG AFP-links in repository: 303487
Number of DF records/TR end points: 3240
Number of transactions: 1274
Number of empty transactions: 350
Number of links -> DF records/TR end points: 32698
Number of links -> other objects in full graph: 178998
Number of transaction links generated (sum): 211696
Number of objects in largest transaction: 5011
Number of elements in largest SCC group: 8

Number of applications with full call graph: 1 (#32602)
Number of relevant objects in repository: 99513
Number of OMG AFP-links in repository: 304088
Number of DF records/TR end points: 3381
Number of transactions : 1274
Number of empty transactions: 344
Number of links -> DF records/TR end points: 39353
Number of links -> other objects in full graph: 203867
Number of transaction links generated (sum): 243220
Number of objects in largest transaction: 4877
Number of elements in largest SCC group: 8