SQL derivative sensitivity analyser has a a user-facing frontend application that allows to extend models by attaching SQL scripts to its elements. SQL queries are added to tasks and SQL database information added to data objects. SQL information is attached by adding specific labels into the XML code of the model. The editor uses SQL derivative sensitivity analysis tool to perform an analyze on the extended model to combine and present the results. Editor and analysis tool have separate codebases, but they are both required to use the full functionality of the analyser. Communication between the two components is arranged by backend REST service.

SQL derivative sensitivity analyser is accessible through Actions menu (with burger-menu icon) under each model in own and shared models/folders lists of frontend - link “Open in SQL DS editor”.

Adding information to model elements for analysis

Clicking on tasks or data objects opens a menu on the right side of the page (in sidebar). You can add SQL scripts (in a form of stored procedures) to tasks. Database contents and table's norm information can be added to data objects.

Running analysis

Clicking on Analyze button opens a menu entitled Analysis settings on the right side of the page (in sidebar). There you can adjust “Privacy level ε” and “Smoothness level β” parameters. Click on Run analysis button to run analysis - results (entitled Analysis results) appear in the sidebar as well.

More detailed instructions with example queries will be added soon.

The source code of SQL derivative sensitivity editor is available at pleak-sql-derivative-sensitivity-editor and the source code of SQL derivative sensitivity analysis tool at pleak-sql-analysis repositories.