{'fraction_non_alphanumeric': 0.012024048096192385, 'fraction_numerical': 0.0, 'mean_word_length': 5.445161290322581, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
The Exploratory Construction of Database Views

An important and rapidly developing area of database application is that of Criminal Intelligence Analysis and similar investigatory work. Criminal Intelligence Analysis is not well supported by existing database technology. The area is characterised by small specialist software houses that develop their products pragmatically by responding to the needs of their user communities. This work could be regarded as a branch of Social Network Analysis, although the field has developed quite independently. In this paper we discuss this important application area, relate it to existing database technology, and suggest how this technology should be extended to provide more appropriate facilities. We describe what we regard as one important new type of facility, what we term the Exploratory Construction of Database Views, and present a demonstrator that we have implemented. We then outline further work and developments that need to be undertaken.