The Transactions of The Korean Institute of Electrical Engineers (전기학회논문지)

The Korean Institute of Electrical Engineers (대한전기학회)
권호 표지
DOI QR코드

DOI QR Code

A Comparison of Performance Between MSSQL Server and MongoDB for Telco Subscriber Data Management

통신 가입자 데이터 관리를 위한 MSSQL Server와 NoSQL MongoDB의 성능 비교

  • Nichie, Aaron (Dept. of Computer and Information Engineering, Cheong-Ju Univ.) ;
  • Koo, Heung-Seo (Dept. of Computer and Information Engineering, Cheong-Ju Univ.)
  • Received : 2015.12.28
  • Accepted : 2016.02.06
  • Published : 2016.03.01
Download PDF
⟨ Previous Next ⟩

Abstract

Relational Database Management Systems have become de facto database model among most developers and users since the inception of Data Science. From IoT devices, sensors, social media and other sources, data is generated in structured, semi-structured and unstructured formats, in huge volumes, thereby the difficulty of data management greatly increases. Organizations that collect large amounts of data are increasingly turning to non relational databases - NoSQL databases. In this paper, through experiments with real field data, we demonstrate that MongoDB, a document-based NoSQL database, is a better alternative for building a Telco Subscriber Data Management System which hitherto is mainly built with Relational Database Management Systems. We compare the existing system in various phases of data flow with our proposed system powered by MongoDB. We show how various workloads at some phases of the existing system were either completely removed or significantly simplified on the new system. Based on experiment results, using MongoDB for managing telco subscriber data turned out to offer performance better than the existing system built with MSSQL Server.

Keywords

References

  1. S. Nyati, S. Pawar, R. Ingle, "Performance Evaluation of Unstructured NoSQL Data Over Distributed Framework", Advances in Computing, Communications and Informatics (ICACCI), pp. 1623-1627, Oct. 21, 2013.
  2. L. Neal, "Will NoSQL Databases Live Up to Their Promise?", Technology News, IEEE Computer Society, pp. 12-14, Oct. 2010.
  3. A MongoDB White Paper: RDBMS to MongoDB Migration Guide, Considerations and Best Practices, pp. 2-14, Aug. 2015.
  4. W. Ming-Shih Dr. "Current Data Security Issues of NoSQL Databases", Fidelis Cybersecurity, pp. 2-14, Jan. 2014.
  5. P. Enfedaque, From Oracle to MongoDB: A Real Use Case at Telefonica PDI, Oct. 06, 2012. [Online]. Available: www.slideshare.net/pablito56/nosql-lmatters fromoracletomongodbv3/1(Downloaded: Nov. 09, 2015)
  6. Telecommunications Datasheet, [Online]. Available: http://s3.amazonaws.com/info-mongodb-com/MongoDB_Telco_Datasheet.pdf (Downloaded: Oct. 04, 2015)
  7. Subscriber Data Management: Unlocking New Customer Insight with Big Data, A MongoDB White Paper, pp. 2-9, May 2014.
  8. A. Hafiz, O. Lukumon, B. Muhammad, A. Olugbenga, O. Hakeem, A. Saheed, "Bankruptcy Prediction of Construction Businesses: Towards a Big Data Analytics Approach", IEEE Conf. Pub., pp.1-5, Mar. 09, 2015.
  9. Huawei Technologies Company Ltd: CBS Call Detail Record Reference V100R002C02LG0372_09 Millicom Ghana LTD-Tigo, pp. 17-206, May 31, 2014.
  10. L. Tuan Dinh, S. H. Kim, N. Minh Hoang, D. Kim, S. Y. Shin, L. Kyung Eun, R. Da Rosa, "EPC Information Services With NoSQL Datastore for Internet of Things", IEEE Conf. Pub., pp. 47-54, May 08, 2014.