PAKISTAN JUDICIARY DATA WAREHOUSE (INTEGRATING THE DISTRICT AND SESSION COURT IN KARACHI THROUGH DATA MARTS AND A DATA WEREHOUSE AT THE SINDH HIGH COURT)

Abstract

The objective ofthis project is to stress upon the return on information that can be get by building a Data Warehouse in the~judiciary system of Pakistan. The project takes the proposal on small scale by demonstrating a data warehouse at Sindh high court and managing data marts at the district and session courts in Karachi. The report includes introduction and background on Business Intelligence and processes of Data Warehousing. The report includes phases that the project will go through, techniques used to build a reasonable design for the data warehouse and data marts. The methodology to carry out the project is discussed in the report. The report discusses the data warehouse approach injustice departments all around the world, and current status of web and mobile applications used in judiciary system of Pakistan. The proposal suggests the management of a data warehouse at the Supreme Court of Pakistan being governed by NJAC (National Judiciary Automation Committee) that will integrate data marts at the High Courts in all provinces which would maintain data from the data marts of each district and session’s court. For demonstration of the judiciary data warehouse, we design a data warehouse at the Sindh High Court that would gather data from data marts district and session’s court in the two districts of Karachi South and Karachi East. The report includes project screen shots, schema designs, the process of ETL for this project are also discussed and also includes OLAP reporting attempted in the project. The report also includes challenges faced in different development phases ofthe project. Recommendations for future development and conclusions are also included in the report.