WHDemoScript

From LiquidPubWiki

• • • Demo script - warehouse

WELCOME TO THE DEMONSTRATION OF THE EVENT LOG AND DATA WAREHOUSE PROTOTYPES. THOSE PROTOTYPES WERE DEVELOPED IN THE COMPAS PROJECT BY THE UNIVERSITY OF TRENTO, ITALY THE PROTOTYPES ARE LOW LEVEL AND SITUATED IN THE BACKEND SO THEY ARE INTENDED TO BE USED BY TECHNICAL SPECIALISTS

[CHANGE SLIDE!!!]

ON THE PICTURE YOU CAN SEE THE PLACE OF THESE COMPONENTS in the overall architecture of COMPAS

The purpose of the event log is to store all events coming through the eNTERPRISE service bus from different sources SUCH ASE process engine, services

[CHANGE SLIDE]

IT ALSO SEPARATES THE OPERATIVE PART OF THE COMPAS INFRASTRUCTURE HIGHLIGHTED ON THE PICTURE IN RED AND REPRESENTED BY RUNNING PROCESSES

FROM THE ASSESSMENT PART HIGHLIGHTED IN GREEN AND REPRESENTED BY DATA WAREHOUSE ANALYSIS AND REPORTING COMPONENTS

THE DATA ABOUT THE EVENTS COMES THROUGH THE ENTERPRISE EVENT BUS TO THE LOGGING SERVICE WHICH IS SUBSCRIBED TO ALL EVENTS PUBLISHED ON THE ESB.

LOGGING SERVICE can be queries by other components of the COMPAS architecture, for instance, by the ETL component

The data about those events is stored in a database table called Log_Table

[DATABASE]

here you can see events related to the execution of WatchMe PROCESS. wATCHME IS ONE OF THE COMPAS CASE STUDIES AND IT DEALS WITH ADVANCED TELECOM SERVICES

If you want to zoom in, there are also events in the raw format, which is XML

[WAREHOUSE] nOW LET US SEE THE WAREHOUSE

The main goal of the warehouse is to help to compute violations efficiently and to access information about violations, related process data AND SO ON IN ORDER TO INVESTIGATE CAUSES OF NON-COMPLIANCE

[GO TO wh SCHEMA]

here is the schema, the main challenge in designing it was to provide a general schema that can accommodate process and compliance requirements without need to change when we have a new process or requirement

the warehouse is populated via ETL ROUTINES, it contains data about process, activity and service executions, connected with corresponding events from different sources: EventLog, AuditTrail, Logs, and so on

apart from prOcess execution , ACTIVITY EXECUTION AND SERVICE EXECUTION data IN THOSE TABLES, the warehouse contains also the data about compliance, such as compliance requirements, evaluations and violations (show tables!!!)

It is important to mention that the warehouse differs from the repositories of models, fragments, and requirements WHICH YOU CAN FIND IN THE COMPAS ARCHITECTURE IN THE SENSE THAT IT CONTAINS ONLY THE DATA REQUIRED FOR MEASURING COMPLIANCE INDICATORS AND FOR REPORTING

LET US NOW HAVE A LOOK AT THE DATA INSIDE THE WAREHOUSE

[CHANGE TO SQL DEVELOPER]

[SHOW F_ComplianceEvaluation] iN THE TABLE OF COMPLIANCE EVALUATIONS you can see which compliance requirements were or were not violated during the execution of the processes, activities, and services.

from this table we can navigate to the activity, service or process instance tables [SHOW F_BPACTIVITYiNSTANCE ]

[CHANGE TO WH SCHEMA]

let us have a closer look at the table of process instances. Apart from storing information about duration, execution start/end, we also need to store business data. There are two possibilities to do this.

[SHOW F_BPiNSTANCEDATA] THERE IS a generic table CALLED F_BPINSTANCEDATA WHICH ALLOWS for storing information about any type of processes, without the need of modifying the database

[GO TO WATCHME TABLES] Below that table we can see process-specific tables for storing WatchMe process data. Those table were added there with the purpose of improving the performance. SUCH TABLES ARE REQUIRED WHEN YOU NEED TO ACCESS PARTICULAR PARTS OF BUSINESS PROCESS DATA VERY FREQUENTLY SO THAT GENERIC SOLUTION DOES NOT PROVIDE SUFFICIENT PERFORMANCE

[CHANGE TO the SQL Developer]

we can also see those tables in the warehouse: generic tables, and process specific tables

[GO TO SLIDES AND SWITCH TO THE LAST] These WERE the main aspects of the technical solutions for storing compliance and process data in COMPAS.

Thank you for your attention AND PLEASE VISIT OUR PROJECT WEBSITE AT WWW.COMPAS-DASH-ICT-DOT-E-YU. FOR MORE INFORMATION