Skip to main content

NoSQL Database for Storing Historic Records in Monitoring Systems: Selection Process

  • Conference paper
  • First Online:
Intelligent Computing, Information and Control Systems (ICICCS 2019)

Abstract

The storage of historical information consists of the registration of large concentrations of data based on samples of information issued by a given system. Historical databases play a key role in industrial control systems that process and provide the information needed for the tasks of supervision, event records, management, and maintenance in the industrial sector. The purpose of the present research is to analyze the current state of monitoring and control systems, recognizing their advantages and disadvantages, and reaching the state of the art about the selection of a NoSQL database for the recording of time series. The development of the work focused on the comparison of column-oriented storage managers as HBase, Cassandra, and Big Table. After designing and implementing two cases of tests for comparing the behavior of both managers in the scenarios of Intensive Readings and Reading/Writing, it was concluded that both of them present excellent performance for storing historic records.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Rashid, A.M., Albert, I., Cosley, D., Lam, S.K., McNee, S.M., Konstan, J.A., Riedl, J.: Getting to know you: learning new user preferences in recommender systems. In: Proceedings of the 7th International Conference on Intelligent User Interfaces, ACM, pp. 127–134 (2002)

    Google Scholar 

  2. Gómez, S., Zervas, P., Sampson, D.G., Fabregat, R.: Context-aware adaptive and personalized mobile learning delivery supported by UoLmP. J. King Saud Univ. Comput. Inf. Sci. 26(1), 47–61 (2014)

    Google Scholar 

  3. Lops, P., De Gemmis, M., Semeraro, G.: Content-based recommender systems: state of the art and trends. In: Recommender systems handbook. Springer, Boston (2011)

    Google Scholar 

  4. Malik, F., Baharudin, B.: Analysis of distance metrics in content-based image retrieval using statistical quantized histogram texture features in the DCT domain. J. King Saud Univ. Comput. Inf. Sci. 25(2), 207–218 (2013)

    Google Scholar 

  5. Su, X., Khoshgoftaar, T.M.: A survey of collaborative filtering techniques. Adv. Artif. Intell. 4(1), 1–12 (2009)

    Article  Google Scholar 

  6. De Campos, L.M., Fernández-Luna, J.M., Huete, J.F., Rueda-Morales, M.A.: Combining content-based and collaborative recommendations: a hybrid approach based on Bayesian networks. Int. J. Approximate Reasoning 51(7), 785–799 (2010)

    Article  Google Scholar 

  7. Isinkaye, F.O., Folajimi, Y.O., Ojokoh, B.A.: Recommendation systems: principles, methods and evaluation. Egypt. Inform. J. 16(3), 261–273 (2015)

    Article  Google Scholar 

  8. Buder, J., Schwind, C.: Learning with personalized recommender systems: a psychological view. Comput. Hum. Behav. 28(1), 207–216 (2012)

    Article  Google Scholar 

  9. Balaguera, M.I., Vargas, M.C., Lis-Gutierrez, J.P., Viloria, A., Malagón, L.E.: Architecture of an object-oriented modeling framework for human occupation. In: Tan, Y., Shi, Y., Tang, Q. (eds.) Advances in Swarm Intelligence, ICSI 2018, Lecture Notes in Computer Science, vol. 10942. Springer, Cham (2018)

    Google Scholar 

  10. Taneja, A., Arora, A.: Cross domain recommendation using multidimensional tensor factorization. Expert Syst. Appl. 92(1), 304–316 (2018)

    Article  Google Scholar 

  11. Frolov, E., Oseledets, I.: Tensor methods and recommender systems. Wiley Interdisc. Rev. Data Min. Knowl. Discov. 7(3), 1–12 (2017)

    Article  Google Scholar 

  12. Kolda, T.G., Bader, B.W.: Tensor decompositions and applications. SIAM Rev. 51(3), 455–500 (2009)

    Article  MathSciNet  Google Scholar 

  13. Panniello, U., Tuzhilin, A., Gorgoglione, M.: Comparing context-aware recommender systems in terms of accuracy and diversity. User Model. User-Adap. Interact. 24(2), 35–65 (2014)

    Article  Google Scholar 

  14. Rafailidis, D., Kefalas, P., Manolopoulos, Y.: Preference dynamics with multimodal user-item interactions in social media recommendation. Expert Syst. Appl. 74(1), 11–18 (2017)

    Article  Google Scholar 

  15. Karatzoglou, A., Amatriain, X., Baltrunas, L., Oliver, N.: Multiverse recommendation: n-dimensional tensor factorization for context-aware collaborative filtering. In: Proceedings of the fourth ACM conference on Recommender systems, ACM, pp. 79–86 (2010)

    Google Scholar 

  16. Zheng, C., Haihong, E., Song, M., Song, J.: CMPTF: contextual modeling probabilistic tensor factorization for recommender systems. Neurocomputing 205(1), 141–151 (2016)

    Article  Google Scholar 

  17. Hidasi, B., Tikk, D.: Fast ALS-based tensor factorization for context-aware recommendation from implicit feedback. In: Machine Learning and Knowledge Discovery in Databases, pp. 67–82 (2012)

    Chapter  Google Scholar 

  18. Lee, J., Lee, D., Lee, Y.C., Hwang, W.S., Kim, S.W.: Improving the accuracy of top-n recommendation using a preference model. Inf. Sci. 348(1), 290–304 (2016)

    Article  Google Scholar 

  19. Balaguera, M.I., Lis-Gutierrez, J.P., Gaitán-Angulo, M., Viloria, A., Portillo-Medina, R.: An ontological framework for cooperative games. In: Tan, Y., Shi, Y., Tang, Q. (eds.) Advances in Swarm Intelligence, ICSI 2018, Lecture Notes in Computer Science, vol. 10941. Springer, Cham (2018)

    Google Scholar 

  20. Varela Izquierdo, N., Cabrera, H.R., Lopez Carvajal, G., Viloria, A., Gaitán Angulo, M., Henry, M.A.: Methodology for the reduction and integration of data in the performance measurement of industries cement plants. In: Tan, Y., Shi, Y., Tang, Q. (eds.) Data Mining and Big Data, DMBD 2018, Lecture Notes in Computer Science, vol. 10943. Springer, Cham (2018)

    Chapter  Google Scholar 

  21. Hepner, G.F.: Artificial neural network classification using a minimal training set. Comparison to conventional supervised classification. Photogram. Eng. Remote Sens. 56(4), 469–473 (1990)

    Google Scholar 

  22. Agarwal, B., Mittal, N.: Text classification using machine learning methods-a survey. In: Proceedings of the Second International Conference on Soft Computing for Problem Solving (SocProS 2012), 28–30 December 2012, pp. 701–709. Springer, India (2014)

    Google Scholar 

  23. Larrañaga, P., Inza, I., Moujahid, A.: Tema 6. Clasificadores Bayesianos. Departamento de Ciencias de la Computación e Inteligencia Artificial (En línea: http://www.sc.ehu.es/ccwbayes/docencia/mmcc/docs/t6bayesianos.pdf. Acceso: 9 de enero de 2016), Universidad del País Vasco-Euskal Herriko Unibertsitatea, España (1997)

  24. Quinlan, J.R.: C4. 5: Programs for Machine Learning. Elsevier, Burlington (1993)

    Google Scholar 

  25. García, D.A.: Algoritmo de discretización de series de tiempo basado en entropía y su aplicación en datos colposcopicos. Tesis de Maestría en Inteligencia Artificial. Universidad Veracruzana. México. (En línea: http://cdigital.uv.mx/bitstream/123456789/32352/1/garcialopezdaniel.pdf, acceso: 10 de agosto de 2015 (2007)

  26. Corso, C.L.: Alternativa de herramienta libre para la implementación de aprendizaje automático. (En línea: http://www.investigacion.frc.utn.edu.ar/labsis/Publicaciones/congresos_labsis/cynthia/Alternativa_de_herramienta_para_Mineria_Datos_CNEISI_2009.pdf, acceso: 10 de agosto de 2015), Argentina (2009)

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Amelec Viloria .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Viloria, A. et al. (2020). NoSQL Database for Storing Historic Records in Monitoring Systems: Selection Process. In: Pandian, A., Ntalianis, K., Palanisamy, R. (eds) Intelligent Computing, Information and Control Systems. ICICCS 2019. Advances in Intelligent Systems and Computing, vol 1039. Springer, Cham. https://doi.org/10.1007/978-3-030-30465-2_38

Download citation

Publish with us

Policies and ethics