A Case for Judicial Data Warehousing and Data Mining in Kenya

Abstract

This aim of this study was to demonstrate how the Extract, Transform and Load (ETL) process can be utilized to assist the Kenyan Judiciary address challenges of data integration in its operational systems and hence provide better mechanisms for extracting data to allow easier reporting and generating judicial intelligence. The research determined the common data sources and operational systems, demonstrated, using case returns data, how the ETL process can be used to migrate data from sources to a data warehouse, proposed a framework for an ETL environment, and developed guidelines for creating a data warehouse for the Kenya Judiciary. This is in line with the Kenya Judiciary Transformation Framework that seeks to harness Information and Communications Technology as an enabler in the justice system in order to achieve expeditious delivery of justice. The practical implication of this work is the better preparation of judiciaries with limited adoption and utilization of ICT in laying the groundwork for judicial knowledge discovery.