As part of a larger project evaluating aspects of offender profiling, an initial study was undertaken of the geographic aspects of approximately 300 sexual offences carried out by 79 stranger rapists. The objective was to focus further research on the topic into potentially useful channels, but information thought to be of immediate use to investigating officers was also produced. It was ascert...

In 2012 Seager introduced a new variant of the Cops and Robbers game, in which a cop searches for a moving robber on a graph using distance probes. The robber on his turn can either remain still or move to an adjacent vertex, while the cop on her turn probes any vertex and learns the robber’s distance from the probed vertex. Carraher, Choi, Delcourt, Erickson and West later showed that for any ...

In recent years, the number of digital information storage and retrieval systems has increased immensely. Data warehousing has been found to be an extremely useful technology for integrating such heterogeneous and autonomous information sources. Data within the data warehouse is modelled in the form of a star or snowflake schema which facilitates business analysis in a multidimensional perspect...

The construction of a warehouse using data from DuPont Pharmaceutical’s Clinical Pharmacokinetics Group with the SAS/Warehouse Administrator product is described herein. Data sources incorporated into the pharmacokinetic warehouse existed in multiple formats (Oracle, Excel, SAS data sets, etc) and were represented by numerous individual files, rather then few large files. In most cases, the da...

Running analytical queries directly against the huge raw data volume of a data warehouse results in unacceptable query performance. The solution to this problem is storing materialized views in the warehouse, which pre-aggregate the data and thus avoid raw data access and speed up queries. In this paper, at first the problems concerning the selection of the right pre-aggregations and their util...

We present a technique for automatic expiration of data in a historical data warehouse that preserves answers to a known and fixed set of first-order queries. In addition, we show that for queries with output size bounded by a function of the active data domain size (the number of values that have ever appeared in the warehouse), the size of the portion of the data warehouse history needed to a...

The data warehouse is considered to be the best way to organize transactional data. However, as many researches claim data warehouse should be augmented with external textual information. The objective of this chapter is to examine the requirements for profiling in the data warehouse environment. Profiles created in the data warehouse are then utilized to filter information. The goal of the ske...

DATA WAREHOUSING and Online Analytical Processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Data Warehouse provides an effective way for the analysis and statistic to the mass data and helps to do the decision making. Many commercial products and services are now available and all of the principal database management syste...

Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...