American Journal of Computing Research Repository
ISSN (Print): 2377-4606 ISSN (Online): 2377-4266 Website: Editor-in-chief: Vishwa Nath Maurya
Open Access
Journal Browser
American Journal of Computing Research Repository. 2016, 4(1), 7-14
DOI: 10.12691/ajcrr-4-1-2
Open AccessCase Study

A Case for Judicial Data Warehousing and Data Mining in Kenya

Christopher Moturi1, , Rahab Mburu1 and Njeri Ngaruiya1

1School of Computing and Informatics, University of Nairobi, Nairobi, Kenya

Pub. Date: February 04, 2016

Cite this paper:
Christopher Moturi, Rahab Mburu and Njeri Ngaruiya. A Case for Judicial Data Warehousing and Data Mining in Kenya. American Journal of Computing Research Repository. 2016; 4(1):7-14. doi: 10.12691/ajcrr-4-1-2


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.

extract transform and load ETL judicial data mining judicial data warehouse judicial intelligence judicial transformation

Creative CommonsThis work is licensed under a Creative Commons Attribution 4.0 International License. To view a copy of this license, visit


[1]  JTF (2012). The Kenya Judicial Transformation Framework 2012-2016 available at
[2]  Verma, L., Srinivasan, S., Sapra, V. (2014). Integration of rule based and case based reasoning system to support decision making, Proceedings of International Conference on Issues and Challenges in Intelligent Computing Techniques (ICICT),pp106-108.
[3]  Hussain, K.Z., Durairaj, M., Farzana, G.R.J. (2012). Criminal behavior analysis by using data mining techniques, Proceedings of International Conference on Advances in Engineering, Science and Management (ICAESM), pp656- 658.
[4]  Kufandirimbwa, O., & Kuranga, C. (2012). Towards Judicial Data Mining: Arguing for Adoption in the Judicial System. Online Journal of Physical and Environmental Science Research, 1(2), 15-21.
[5]  Singh, R., & Singh, K. (2010). A descriptive classification of causes of data quality problems in data warehousing. International Journal of Computer Science Issues, 7(3), 41-50.
[6]  Thammaboosadee, S., Silparcha, U., (2008). A framework for criminal judicial reasoning system using data mining techniques, Proceedings of the International Conference on Digital Ecosystems and Technologies, DEST 2008. 2nd IEEE, pp 518-523.
[7]  Xie, R., (2008). The Application of Data Mining in Judicial Judgment, Proceedings of the 4th International Conference on on Wireless Communications, Networking and Mobile Computing, WiCOM '08, pp 1-4.
[8]  Annapoorani, V., Vijaya, A., (2013). A prevailing judicial package for clustering and sorting information extraction, International Conference on Pattern Recognition, Informatics and Mobile Engineering (PRIME), pp241-244.
[9]  Ticom, A.A.M, de Souza, B., de Lima, L.P., (2007). Text Mining and Expert Systems Applied in Labor Laws, Seventh International Conference on Intelligent Systems Design and Applications, ISDA 2007, pp788-792.
[10]  Serbena, C. A. (2013). Actual interfaces between Q-Justice and E-Justice in Brazil. Revista de Sociologia e PolĂ­tica, 21(45), 47-56.
[11]  Hamin, Z., Othman, M.B., Mohamad, A.M., (2012). ICT adoption by the Malaysian high courts: Exploring the security risks involved, International Conference onInnovation Management and Technology Research (ICIMTR), pp285-289.
[12]  Ward, B. T., Sipior, J. C., Volonino, L., & Purwin, C. (2011). A United States perspective on electronic discovery rules and electronic evidence. Transforming Government: People, Process and Policy, 5(3), 268-279.
[13]  Zernik, J., (2010). Data Mining of Online Judicial Records of the Networked US Federal Courts, International Journal on Social Media, MMM: Monitoring, Measurement, and Mining, pp 69-83.
[14]  Poonkuzhali, S., Kumar, R. K., & Viswanathan, C. (2015). Law Reckoner for Indian Judiciary: An Android Application for Retrieving Law Information Using Data Mining Methods. In Advanced Computer and Communication Engineering Technology (pp. 585-593). Springer International Publishing.
[15]  Thammaboosadee, S., Watanapa, B., & Charoenkitkarn, N. (2012). A framework of multi-stage classifier for identifying criminal law sentences. Procedia Computer Science, 13, 53-59.
[16]  Bianchi, M., Draoli, M., Gambosi, G., Pazienza, M. T., Scarpato, N., & Stellato, A. (2009). ICT tools for the discovery of semantic relations in legal documents. In Proceedings of the 2nd International Conference on ICT Solutions for Justice (ICT4Justice).
[17]  Albrecht, A., & Naumann, F. (2008). Managing ETL Processes. NTII, 8, 12-15.
[18]  Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., & Skiadopoulos, S. (2005). A generic and customizable framework for the design of ETL scenarios. Information Systems, 30(7), 492-525.
[19]  Simitsis, A., & Vassiliadis, P. (2008). A method for the mapping of conceptual designs to logical blueprints for ETL processes. Decision Support Systems, 45(1), 22-40.
[20]  van den Braak, S., Choenni, S., & Verwer, S. (2013). Combining and analyzing judicial databases. In Discrimination and Privacy in the Information Society (pp. 191-206). Springer Berlin Heidelberg
[21]  Chaudhuri, S. and Dayal, U (1997). An overview of data warehousing and OLAP technology. ACM Sigmond, 26(1) pp 65-74.
[22]  Bernardino, J., & Tereso, M. (2013). Business Intelligence Tools. In Computational Intelligence and Decision Making (pp. 267-276). Springer Netherlands.
[23]  Winn, P.A., (2009). Judicial Information Management in an Electronic Age: Old Standards, New Challenges, The Federal Courts Law Review, Vol 3, Issue 2, pp 135-176.