Advanced SearchSearch Tips
A Comparison of Performance Between MSSQL Server and MongoDB for Telco Subscriber Data Management
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
A Comparison of Performance Between MSSQL Server and MongoDB for Telco Subscriber Data Management
Nichie, Aaron; Koo, Heung-Seo;
  PDF(new window)
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.
Subscriber data management;Single view;Big data;NoSQL;JSON;
 Cited by
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.

L. Neal, "Will NoSQL Databases Live Up to Their Promise?", Technology News, IEEE Computer Society, pp. 12-14, Oct. 2010.

A MongoDB White Paper: RDBMS to MongoDB Migration Guide, Considerations and Best Practices, pp. 2-14, Aug. 2015.

W. Ming-Shih Dr. "Current Data Security Issues of NoSQL Databases", Fidelis Cybersecurity, pp. 2-14, Jan. 2014.

P. Enfedaque, From Oracle to MongoDB: A Real Use Case at Telefonica PDI, Oct. 06, 2012. [Online]. Available: fromoracletomongodbv3/1(Downloaded: Nov. 09, 2015)

Telecommunications Datasheet, [Online]. Available: (Downloaded: Oct. 04, 2015)

Subscriber Data Management: Unlocking New Customer Insight with Big Data, A MongoDB White Paper, pp. 2-9, May 2014.

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.

Huawei Technologies Company Ltd: CBS Call Detail Record Reference V100R002C02LG0372_09 Millicom Ghana LTD-Tigo, pp. 17-206, May 31, 2014.

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.