Criminal Justice Enterprise and Scenarios

TO BE SUPPLIED:
The Criminal Justice enterprise is a database enterprise that is based on more complex and realistic scenarios from GJXDM. The details about the enterprise are shown in the UML diagram. The Criminal Justice enterprise consists of SQL scripts to generate relational tables, XML schemas for the relevant XML data sources, and a data generation program. The data generation program is written using C# and LINQ. The program generates comma-separated files, which can be imported into the relational databases and XML files for the XML data sources.

Simple proof-of-concept Criminal Justice Scenario: This is a simple implementation of a small Criminal Justice Scenario that illustrates the various features of the DEPA framework. The example scenario includes data sources stored in Oracle and SQL Server relational databases and XML documents, events, streams, and a LINQ view over a relational and XML source. Research paper illustrating the features of the framework and the details on the proof-of-concept was presented at the VLDB2010 Ph.D. workshop.

Sample hybrid scenarios over Criminal Justice enterprise:
In order to test the working of the different algorithms within the DEPA framework, the research group has focused on designing hybrid scenarios using the Criminal Justice enterprise. These hybrid scenarios consists of queries defined in SQL, LINQ and XQuery over various heterogeneous data sources. These queries are used in the evaluation of the common subexpression detection algorithm and materialized view definition algorithm in a simulated DEPA framework. The sample scenarios also include the deltas which are randomly generated to simulate the changes in the data sources. The delta generation program is written in C# and uses LINQ to communicate with the database. These deltas are streamed within the DEPA environment to the materialized views and the incremental view maintenance algorithm uses these deltas to update the views.