Cover
Vol. 11 No. 1 (2015)

Published: July 31, 2015

Pages: 105-109

Original Article

Design and Develop an Information system for Court Data in the Republic of Iraq by using SSRS Reports with SSAS Cubes

Ayad Mohammed Jabbar 1
1Computer Science Department Shatt Al-Arab University College Basra, Iraq
History
  • Received: May 31, 2015
  • Available Online: July 31, 2015
DOI

https://doi.org/10.37917/ijeee.11.1.11

Abstract

Multidimensional Online analytical processing (MOLAP) technology is considered a good tool to produce meaningful and quality results by using a multidimensional cube. The term “multidimensional cube” is used to refer to the multiple layers of data that are used to show the result. This result is identified by high-level management to increase the Iraqi court work and to improve its quality. The Iraqi court needs an analytical report to make a strategic decision on case date, case type, case state, judge, criminal age, and criminal gender. Currently, MOLAP is known as the best and strongest technique because it provides rapid, dynamic, and multiple analyses of data; presents knowledge from different perspectives; comes up with data in time series intervals; and drills down into multiple levels of data layers to present different types of details. The SQL Server Reporting Service (SSRS) presents analysis reports based on the MOLAP cube. This paper focuses on designing and developing the analysis reports of the court data system of the Republic of Iraq by using SSRS with SQL Server Analysis Service to create the MOLAP cubes.

Keywords

References

  1. J. Gerald M. Muhl, "DEFEATING (IED): ASYMMETRIC THREATS AND CAPABILITY Master, Department of Defense, The U.S. Army War College Philadelphia, 2011.
  2. E. Turban, R. Sharda, D. Delen, and T. Efraim, Decision support and business
  3. A. Mohammed and K.-m. Kue Ruhana, "Graphical Web based tool for Generating Query from star Schema " in Proceedings of the 2rd International Conference on Computing and Informatics, ICOCI09 , Kuala Lumpur , Malaysia,2009.
  4. O. Kufandirimbwa and C. Kuranga, "Towards Judicial Data Mining: Arguing for Adoption in the Judicial System," Online Journal of Physical and Environmental Science Research, vol. 1, pp. 15-21,2012.
  5. S. Harinath and S. R. Quinn, Professional SQL server analysis services 2005 with MDX : John Wiley & Sons, 2006.
  6. R. Jacobsen, S. Misner, and H. Consulting, Microsoft® SQL ServerTM 2005 Analysis Services Step by Step : O'Reilly, 2009.
  7. J. Li and B. Xu, "ETL tool research and warehouse," FSKD '10: Seventh Conference on Fuzzy Systems and Knowledge Discovery , Yantai, Shandong,China:IEEE, 2010, pp. 2567-2569.
  8. J. Tang, K. Cui, Y. Feng, and G. Tong, "The Research & Application of ETL Tool in Business Intelligence Project," in Chengdu,China:IEEE, 2009, pp. 620-623.
  9. M. U. Shaikh, S. U. R. Malik, M. A. Qureshi, and S. Yaqoob, "Intelligent Decision Making Based on Data Mining Using Differential Evolution Algorithms and Framework for ETL Workflow Management," in ICCEA '10: Second Engineering and Applications , Bali
  10. C. Surajit and D. Umeshwar, "An overview of data warehousing and MOLAP technology," SIGMOD Rec., vol. 26, pp. 65-74, 1997.
  11. Z. Hua-long, "Application of MOLAP to the analysis of the curriculum chosen by students," in ASID '08: 2nd International Conference on Anti-counterfeiting, Security and
  12. E. Malinowski and E. Zimányi, "Hierarchies in a multidimensional model: From conceptual modeling to logical representation," Data & Knowledge Engineering, vol. 59, pp. 348-377, 2006.