365 221
Full Length Article
Volume 8 , Issue 2, PP: 87-109 , 2020

Title

Online Analytical Processing Operations via Neutrosophic Systems

Authors Names :   A. A. Salama   1 *     M.S.Bondok Henawy   2     Rafif Alhabib   3  

1  Affiliation :  Department of Mathematics and Computer Science, Faculty of Sciences, Port Said University Egypt

    Email :  drsalama44@gmail.com


2  Affiliation :  Department of Mathematics and Computer Science, Faculty of Sciences, Port Said University Egypt

    Email :  Bondok.Henawy12@gmail.com


3  Affiliation :  Department of Mathematical Statistics, Faculty of Science, Albaath University, Homs, Syria

    Email :  rafif.alhabib85@gmail.com



Doi   :  10.5281/zenodo.3902743


Abstract :

 In this paper, a neutrosophic fuzzy data warehouse modelling approach is presented to support the neutrosophic analysis of the publishing house for books which allows integration of neutrosophic concept in dimensions and facts without affecting the core of a crisp data warehouse. Also we describe a method is presented which includes guidelines that can be used to convert a crisp data warehouse into a neutrosophic fuzzy domain. Finally we have presented an OLAP system that implements a neutrosophic multidimensional model to represent imprecision using neutrosophic concept in hierarchies and facts and achieving knowledge discovery from imperfect data. The use of neutrosophic structures and the definition of the OLAP operations (roll-up, drill-down, slice, and dice) enable the model to manage the imprecision of data and hide the complexity of the model and provide the user with a more understandable result.

Keywords :

Fuzzy Sets , Neutrosophic Fuzzy Data Warehouse ,  Neutrosophic Fuzzy Cube , Neutrosophic Fuzzy OLAP Operation.

References :

[1]  Inmon, W. H., Building the Data Warehouse (2nd Edition), New York: Wiley, 1996.

[2]  Lehner,Wolfgang, Datenbanktechologie für Data-Warehouse-System. Dpunkt Verlag, 2003.

[3]  Michael Kaufmann, Application of Fuzzy Classification to a Data Warehouse in E-Health, 2006

[4]  Daniel Fasel, Concept and Implementation of a Fuzzy Data Warehouse , Fribourg, Switzerland 2012 

[5]  L. A. Zadeh. Fuzzy Sets. Information and Control, 8, pp.338-353, 1965.

[6]  Atanassov, K. T. “Intuitionistic Fuzzy Sets”, Fuzzy Sets and Systems, Vol. 20, pp. 87-96, 1986.

[7]   Smarandache, F. "A Unifying Field in Logics. Neutrosophy: Neutrosophic Probability, Set and Logic", Rehoboth: American Research Press, (1991).

[8]   A. A. Salama, F. Smarandache, Neutrosophic Crisp Set Theory, Educational Publisher Columbus / 2015,pp. 181

[9]   Umberto Rivieccio, Neutrosophic Logics:Prospects and Problems,University of Genoa,Department of Philosophy.2007.

[10]       M. Bhowmik,  M.Pal. Intuitionistic neutrosophic set, Journal of Information and Computting Science Vol. 4, No. 2, pp. 142-152, 2009.

[11]                  A. A. Salama, F. Smarandache, M. Eisa, Introduction to Image Processing Via Neutrosophic Techniques,Neutrosophic Sets and Systems, 5, pp.59-64, 2014.

[12]                  A. A.Salama  , S. A. Eisa  M.,Elhafeez, M.M Lotfy., Review of Recommender systems Algorithms Utilized in social Networks based e-learning systems & Neutrosophic System, Neutrosophic Sets and Systems, 8, pp.32 - 41, 2015.

[13]                  H. Elwahsh, M. Gamal,  A. A. Salama, I. M. El-Henawy, Modeling neutrosophic data by self-organizing feature map: MANETs data case study. Procedia computer science, Vol121, pp.152-159, 2017.

[14]      A. A. Salama, M. Eisa, M. M. Abdelmoghny, Neutrosophic Relations Database, International Journal of Information Technology and Intelligent System, 3(2), pp.1-3, 2014.

[15]      A. A. Salama, H. A. El-Ghareeb, A. M. Manie, M. M. Lotfy, Utilizing Neutrosophic Set in Social Network Analysis e-Learning Systems, International Journalof Information Science and Intelligent System, 3(4),pp.61-72,2014. 

[16]      L. A. Zadeh. PRUF – A Meaning Representation Language for Natural Languages. Int. J. Man-Machine Studies, 10, pp.395–460, 1978.

[17]      L. A. Zadeh. The Concept of a Linguistic Variable and its Application to Approximate Reasoning - Part I. Information Science, Vol(8), pp.199–249, 1975.

[18]                  L. A. Zadeh. The Concept of a Linguistic Variable and its Application to Approximate Reasoning - Part II. Information Science, Vol(8), pp.301–357, 1975.

[19]                  L. A. Zadeh. The Concept of a Linguistic Variable and its Application to Approximate Reasoning - Part III. Information Science, Vol(9), pp.43–80, 1975.

[20]                 L. A. Zadeh. The Concept of a Linguistic Variable and its Application to Approximate Reasoning - Part I. Information Science, Vol (8), pp.199–249, 1975.

[21]                 A. A. Salama, M. Eisa, H. ElGhawalby, A. E. Fawzy, A New Approach in Content-Based Image Retrieval Neutrosophic Domain. In Fuzzy Multi-criteria Decision-Making Using Neutrosophic Sets , pp. 361-369, 2019 Springer, Cham.‏

[22]                  F. Smarandache, "A Unifying Field in Logics. Neutrosophy: Neutrosophic Probability, Set and Logic", Rehoboth: American Research Press, 1991.

[23]                 E.F.Codd, , "Providing OLAP On-line Analytical Processing to user-analysts", An IT mandate. Technical report, E.F. Codd and Associates, 1993. 

[24]                 P. Ponniah., "data warehousing fundamentals for it professionals", Published by John Wiley & Sons, Inc., Hoboken, New Jersey, 2010.

[25]                 Michael Kaufmann, Application of Fuzzy Classification to a Data Warehouse in E-Health, 2006

[26]                 E.F.,Codd, OLAP Council. OLAP and OLAP Server Definitions. http://www.olapcouncil.org/research/resrchly.htm, 08, 2010.

[27]                 P. Vassiliadis, "Modeling Multidimensional Databases, Cubes and Cube Operations". In Proceedings of the 10th International Conference on Scientific and Statistical Database Management, pages 53–62. IEEE, 1998.

[28]                  D. Fasel, Concept and Implementation of a Fuzzy Data Warehouse , Fribourg, Switzerland, 2012

[29]                  R. Agrawal, A. Gupta, S. Sarawagi, "Modeling Multidimensional Databases" In Proceedings of the Thirteenth International Conference on Data Engineering, pp. 232–243. IEEE Computer Society, 1997.

[30]                 A. Chakraborty, "A New Score Function of Pentagonal Neutrosophic Number and its Application in Networking Problem", International Journal of Neutrosophic Science,  Volume 1 , Issue 1, pp.40-51 , 2020.

[31]                 A. Chakraborty, "Application of Pentagonal Neutrosophic Number in Shortest Path Problem", International Journal of Neutrosophic Science,  Volume 3 , Issue 1, pp. 21-28 , 2020.

[32]                 M.Al- Tahan, "Some Results on Single Valued Neutrosophic (Weak) Polygroups", International Journal of Neutrosophic Science,   Volume 2 , Issue 1, pp. 38-46 , 2020.

[33]                 S. A. Edalatpanah, "A Direct Model for Triangular Neutrosophic Linear Programming", International Journal of Neutrosophic Science, Volume 1 , Issue 1, pp. 19-28 , 2020.