Building a general concept of analytical services for analysis of structured data

Atheer Hadi Al-Rammahi, Mohammed Hamzah Abed, Mustafa Jawad Radif


In this paper, “Building a common concept of analytical services for analyzing structured data” was proposed to build an analytical service to provide forecasts, descriptive and comparative data summaries using modern Microsoft technologies. This service will allow users to perform flexible viewing of information, receive arbitrary data slices and perform analytical operations of drill-down, convolution, pass-through distribution, the comparison in time. With the help of data mining, it is possible to detect previously unknown, non-trivial, practically useful and accessible interpretations of knowledge that are necessary for the organization's decision-making. Also, each client can interact with the service and thus monitor the displayed analytical information. In the process of work the following tasks were solved: investigated the subject area; studied materials relating to systems and technologies for their implementation; designed service architecture and applications to configure the service; selected technologies and tools for the implementation of the system; implemented the main frame of the system; modules for interaction with analysis services, data mining (a priori algorithm) and partially a module of neural networks; a report was written and a presentation of the results was prepared; The developed service will be useful to all organizations that are interested in obtaining analytical reports and other previously unknown information on their accumulated data. For example, organizations can analyze the impact of advertising, customer segmentation, search for signs of profitable customers, analyze product preferences, forecast sales volumes, and more.


ANALYSIS OF STRUCTURED DATA, OLAP, Physical Data Model, Database Scheme, Olap-cubes

Full Text:



R. Agrawal, T. Imielinski, A. Swami, "Mining Associations between Sets of Items in Massive Databases". In Proc. of the 1993 ACM-SIGMOD Int’l Conf. on Management of Data, pp. 207-216., 1993.

C. Borgelt et R. Kruse. "Induction of association rules: Apriori implementation". In Proceedings of the 15th Conference on Computational Statistics, Heidelberg, Germany, 2002.

Motoda, G. J. McLachlan, A. Ng, B. Liu, P. S. Yu, Z.-H. Zhou, M. Steinbach, D. J. Hand, and D. Steinberg, "Top 10 algorithms in data mining," Knowledge and Information Systems, vol. 14, no. 1, pp. 1–37, Dec. 2007.

T. Agouti, "Vers une intégration des systèmes d’information géographiques et de l’analyse multicritère pour l’aide à la décision à référence spatiale", thèse de doctorat nationale, Université Cadi Ayyad, Faculté des Sciences Semlalia, Marrakech, 2009.

K. Kimita, T. Tateyama, Y. Shimomura,"Process Simulation Method for Product-Service Systems Design" . Procedia CIRP 3, pp: 489-494, 2012.

A.R. Tan, D. Matzen, T.C. McAloone, S. Evans, "Strategies for designing and developing services for manufacturing firms". CIRP Journal of Manufacturing Science and Technology vol.3, no.2, pp: 90-97. 2010.

J-P Jian-Ping Li, G Thompson, T. Alonso-Rasgado. "Simulation based Reliability Assessment of Services in the Context of Functional Products". Safety and Reliability, vol. 29, no.4, pp:47-78. 2009.

J. Han, J. Wang, G. Dong, J. Pei, and K. Wang, "Cube explorer: online exploration of data cubes". In SIGMOD ‟02: Proceedings of the 2002 ACM SIG MOD international conference on Management of data, pp:626–626, New York, NY, USA, 2002.

T.B. Pedersen and C.S. Jensen. “Multidimensional data modeling for complex data”. In: Data Engineering, 1999. Proceedings., 15th International Conference on. IEEE, pp. 336–345, 1999.

T. Palpanas, N. Koudas, and A.Mendelzon, "Using Data cube Aggregates for Approximate Querying and Deviation Detection". IEEE Transactions on Knowledge and Data Engineering, vol. 17, no. 11, pp:1465–1477, November, 2005.

J. Han. " OLAP Mining: An Integration of OLAP with Data Mining,". In Proceedings of the 7th IFIP Conference on Data Semantics, Leysin, Switzerland, October 1997.

S. Badiozamany, "Microsoft SQL server OLAP solution-A survey,". examensarbete 15 hp, pp. 3-13, 2010.

S. Cheng, "Statistical Approaches to Predictive Modeling in Large Databases". M.Sc. Thesis, Simon Fraser University, Canada, January 1998.

M. Kamber, L. Winstone, W. Gong, S. Cheng, and J. Han, "'Generalization and decision tree induction: Ecient classication in data mining". In Proc. of 1997 Int. Workshop Research Issues on Data Engineering (RIDE'97), pp. 111-120, Birmingham, England, April 1997.

R. Andrews, J. Diederich, A. B. Tickle," A survey and critique of techniques for extracting rules from trained artificial neural networks", Knowledge-Based Systems,vol.- 8,no.-6, pp.378-389,1995.

H. Johan, B. Bart and V. Jan, "Using Rule Extraction to Improve the Comprehensibility of Predictive Models". In Open Access publication from Katholieke Universiteit Leuven, pp.1-56, 2006

M. Mahmood, B. Al-Khateeb, " Review of neural networks and particle swarm optimization contribution in intrusion detection". Periodicals of Engineering and Natural Sciences, Vol. 7, No. 3, pp.1067-1073, September 2019.

K. Bayoude, Y. Ouassit, S. Ardchir and M. Azouazi, " How Machine Learning Potentials are transforming the Practice of Digital Marketing: State of the Art". Periodicals of Engineering and Natural Sciences.Vol. 6, No. 2, pp.373-379, December 2018.

S.Rawan, A.Manal, " Real time data analysis and visualization for the breast cancer disease". Periodicals of Engineering and Natural Sciences. Vol. 7, No. 1, pp.395-40, June 2019.

O.Prokopenko, V. Omelyanenko, T. Ponomarenko, O. Olshanska, " Innovation networks effects simulation models". Periodicals of Engineering and Natural Sciences, Vol. 7, No. 2, pp.752-762. August 2019.

S. Rashid, I. Al_Barazanchi, Z. A. Jaaz, " Clustering algorithms subjected to K-mean and gaussian mixture model on multidimensional data set". Periodicals of Engineering and Natural Sciences. Vol. 7, No. 2, pp.448-457, June 2019.



Copyright (c) 2019 Atheer Hadi Al-Rammahi

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

ISSN: 2303-4521

Digital Object Identifier DOI: 10.21533/pen

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License