Abstract
Junk mail is a major concern of Internet communication. It represents most of the received messages. To filter unsolicited bulk e-mails there is a large amount of human and financial resources and computing resources needed. One way to counter this problem is to maximize the information yield of the obtained unsolicited messages. This article aims to introduce the concept ASOLAP - the use of OLAP to store and analyze metadata of e-mail messages. We propose a conceptual data model and verify its quality. Based on the results, we recommend to use the design of the star schema that represents the potential for quality and efficient solution of the ASOLAP design.
The original version of the book was revised. For detailed information please see Erratum. The erratum to the book is available at 10.1007/978-3-319-57141-6_53
An erratum to this chapter can be found at http://dx.doi.org/10.1007/978-3-319-57141-6_53
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Bellatreche, L., Cuzzocrea, A., Song, I.: Advances in data warehousing and OLAP in the big Data Era. Inf. Syst. 53, 39–40 (2015)
Colliat, G.: OLAP, relational, and multidimensional database systems. ACM Sigmod Rec. 25(3), 64–69 (1996)
Datta, A., Thomas, H.: The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decis. Support Syst. 27(3), 289–301 (1999)
Di Tria, F., Lefons, E., Tangorra, F.: Hybrid methodology for data warehouse conceptual design by UML schemas. Inf. Softw. Technol. 54(4), 360–379 (2012)
Kirubavathi, G., Anitha, R.: Botnet detection via mining of traffic flow characteristics. Comput. Electr. Eng. 50, 91–101 (2016)
Chakraborty, M., Pal, S., Rahul Pramanik, C., Chowdary, R.: Recent developments in social spam detection and combating techniques: a survey. Inf. Process. Manag. 52(6), 1053–1073 (2016)
Peters, M.D., Wieder, B., Sutton, S.G., Wakefield, J.: Business intelligence systems use in performance measurement capabilities: implications for enhanced competitive advantage. Int. J. Account. Inf. Syst. 21, 1–17 (2016)
Gosain, A., Heena: Literature review of data model quality metrics of data warehouse. Procedia Comput. Sci. 48, 236–243 (2015)
Spammer-X, Posluns, J., Sjouwerman, S.: Inside the SPAM Cartel. Syngress, Boston (2004). ISBN: 079-2502668603
Almeida, T.A., Yamakami, A.: Facing the spammers: a very effective approach to avoid junk e-mails. Expert Syst. Appl. 39(7), 6557–6561 (2012)
Vasilenko, A., Ocenasek, V.: Spam as a problem for small agriculture business. Agris Online – Pap. Econ. Inform. 1(8) (2013)
Zhang, X., Li, Y., Kotagiri, R., Lifang, W., Tari, Z., Cheriet, M.: KRNN: k Rare-class Nearest Neighbour classification. Pattern Recogn. 62, 33–44 (2017)
Yevseyeva, I., Basto-Fernandes, V., Ruano-Ordás, D., Méndez, J.R.: Optimising anti-spam filters with evolutionary algorithms. Expert Syst. Appl. 40(10), 4010–4021 (2013)
Meng, Y., Kwok, L.-F.: Adaptive blacklist-based packet filter with a statistic-based approach in network intrusion detection. J. Netw. Comput. Appl. 39, 83–92 (2014)
Acknowledgements
The results and knowledge included herein have been obtained owing to support from the Internal grant agency of the Faculty of Economics and Management, Czech University of Life Sciences in Prague, grant no. 20161019, “Economic value of analytical systems in agriculture”.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Vasilenko, A., Tyrychtr, J. (2017). Towards Data Storage for Online Analytical Antispam System – ASOLAP. In: Silhavy, R., Silhavy, P., Prokopova, Z., Senkerik, R., Kominkova Oplatkova, Z. (eds) Software Engineering Trends and Techniques in Intelligent Systems. CSOC 2017. Advances in Intelligent Systems and Computing, vol 575. Springer, Cham. https://doi.org/10.1007/978-3-319-57141-6_11
Download citation
DOI: https://doi.org/10.1007/978-3-319-57141-6_11
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-57140-9
Online ISBN: 978-3-319-57141-6
eBook Packages: EngineeringEngineering (R0)