Open Access Open Access  Restricted Access Subscription or Fee Access

Data Warehouse Development for Customer WIFI Access Service at a Telecommunication Company


(*) Corresponding author


Authors' affiliations


DOI: https://doi.org/10.15866/irecap.v7i2.11736

Abstract


As the main public company in telecommunication and broadband business in Indonesia, PT XYZ has always tried to ensure adequate wifi access service to meet the needs of broadband consumers. This wifi service, called wifi-id, uses an Authentication, Authorization, Accounting (AAA) server by collaborating with the other network providers. This study was based on the need of PT. XYZ to present reports or data quickly when needed, especially when PT. XYZ needs to reconcile the total monthly customer usage with business partners in order to do billing revenue sharing partnership. The problem arises because the script of CDR (called data record), which represents the use of broadband consumers, is stored in the form of CSV file only. It makes it difficult to make a report of customer access which is needed by PT. XYZ. The suggested solution is to move the existing data into a more structured storage in data warehouse. Data warehouse development was done through a nine-step methodology designed by Kimball and Ross. Furthermore, the data can be analyzed using OLAP to present the data in a visual form such as report or dashboard. With this solution, PT. XYZ can process and present the report relatively faster. Additionally, PT. XYZ will also get more benefit from the data stored in the form of information.
Copyright © 2017 Praise Worthy Prize - All rights reserved.

Keywords


Data Warehouse; Radius Protocol; OLAP Analysis; Radius Server; Authentication Authorization Accounting; WIFI

Full Text:

PDF


References


M. Agung and A. I. Kistijantoro, “High performance CDR processing with MapReduce,” in Telecommunication Systems Services and Applications (TSSA), 2015 9th International Conference on, 2015, pp. 1–6.
http://dx.doi.org/10.1109/tssa.2015.7440424

C. E. Atay and G. Alp, “Modeling and Querying Multidimensional Bitemporal Data Warehouses,” Int. J. Comput. Commun. Eng., vol. 5, no. 2, p. 110, 2016.
http://dx.doi.org/10.17706/ijcce.2016.5.2.110-119

D. Moriya and G. Gosawi, “A Roadmap: Designing and Construction of Data Warehouse,” Bin. J. Data Min. Netw., vol. 5, no. 1, pp. 22–25, 2015.
http://dx.doi.org/10.1007/978-3-540-74405-4_7

S. H. A. Aloush, “The Role of Data Warehouse in Decreasing the Time of Decision Taking,” Aust. J. Basic Appl. Sci., vol. 9, no. 5, pp. 216–219, 2015.
http://dx.doi.org/10.1007/978-3-322-99372-4_7

Ć. Dragana, D. Be, and N. Gospi, “A Call Detail Records Data Mart: Data Modelling and OLAP Analysis Data Modelling: the Conceptual , Logical and Physical,” Comput. Sci. Inf. Syst., vol. 6, no. 2, pp. 87–110, 2009.
http://dx.doi.org/10.2298/csis0902087c

R. Kimball, M. Ross, B. Becker, W. Thornthwaite, and J. Mundy, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection. John Wiley & Sons, 2015.
http://dx.doi.org/10.1002/9781119228912

N. Shaik, W. Ullah, and G. Pradeepni, “OLAP Mining Rules: Association of OLAP with Data Mining,” Am. J. Eng. Res., vol. 5, no. 2, pp. 237–240, 2016.
http://dx.doi.org/10.1007/978-0-387-35300-5_1

M. Sethi, “Data Warehousing and OLAP Technology,” Int. J. Eng. Res. Appl., vol. 2, no. 2, pp. 955–960, 2012.
http://dx.doi.org/10.1145/2390045

A. S. Sinaga and A. S. Girsang, “University Accreditation using Data Warehouse,” in Journal of Physics: Conference Series, 2017, vol. 801, no. 1, p. 12030.
http://dx.doi.org/10.1088/1742-6596/801/1/012030

F. Jian and N. Tian-zhu, “Design, Extension and Implementation of RADIUS Client,” Int. J. Futur. Gener. Commun. Netw., vol. 9, no. 5, pp. 181–188, 2016.
http://dx.doi.org/10.14257/ijfgcn.2016.9.5.18

R. Kimball, M. Ross, and others, “The data warehouse toolkit: the complete guide to dimensional modelling,” Nachdr.]. New York Wiley, pp. 1–447, 2002.
http://dx.doi.org/10.1145/945721.945741

K. Kakish and T. A. Kraft, “ETL evolution for real-time data warehousing,” in Proceedings of the Conference on Information Systems Applied Research ISSN, 2012, vol. 2167, p. 1508.
http://dx.doi.org/10.1007/978-0-387-87431-9_2

M. Arif, “A Survey on Data Warehouse Constructions, Processes and Architectures,” Int. J. u-and e-Service, Sci. Technol., vol. 8, no. 4, pp. 9–16, 2015.
http://dx.doi.org/10.14257/ijunesst.2015.8.4.02

S. H. A. El-Sappagh, A. M. A. Hendawi, and A. H. El Bastawissy, “A proposed model for data warehouse ETL processes,” J. King Saud Univ. Inf. Sci., vol. 23, no. 2, pp. 91–104, 2011.
http://dx.doi.org/10.1016/j.jksuci.2011.05.005

R. Kimball and J. Caserta, The Data Warehouse? ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. John Wiley & Sons, 2011.
http://dx.doi.org/10.1145/945721.945741

R. J. Salaki, J. Waworuntu, and I. Tangkawarow, “Extract transformation loading from OLTP to OLAP data using pentaho data integration,” in IOP Conference Series: Materials Science and Engineering, 2016, vol. 128, no. 1, p. 12020.
http://dx.doi.org/10.1088/1757-899x/128/1/012020

R. Kimball and M. Ross, The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons, 2013.
http://dx.doi.org/10.1145/945721.945741

S. S. Husain, A. Kalinin, A. Truong, and I. D. Dinov, “SOCR Data dashboard: an integrated big data archive mashing medicare, labor, census and econometric information,” J. big data, vol. 2, no. 1, p. 13, 2015.
http://dx.doi.org/10.1186/s40537-015-0018-z

Z. Zhao, S.-L. Shaw, Y. Xu, F. Lu, J. Chen, and L. Yin, “Understanding the bias of call detail records in human mobility research,” Int. J. Geogr. Inf. Sci., vol. 30, no. 9, pp. 1738–1762, 2016.
http://dx.doi.org/10.1080/13658816.2015.1137298

L. I. A. Monica and others, “Customer Data Analysis Model using Business Intelligence Tools in Telecommunication Companies,” Database Syst. J. BOARD, p. 39, 2015.
http://dx.doi.org/10.1002/9781119183570.ch1

Nabri, H., Ouazar, D., Hasnaoui, M., Spatial Data Warehouse Modeling at the Watershed Scale. Part 1: Design Aspects, (2015) International Journal on Information Technology (IREIT), 3 (4), pp. 124-130.

Madraky, A., Othman, Z., Hamdan, A., Hair-Oriented Data Model for Spatio-Temporal Data Mining, (2015) International Review on Computers and Software (IRECOS), 10 (1), pp. 90-101.
http://dx.doi.org/10.15866/irecos.v10i1.5198

Darmawan, D., Fernando, C., Gunawan, A., Ivandi, J., Data Warehouse Development Based on Cloud Computing Using IBM Informix and IBM Cognos for Multifinance Industry, (2016) International Review on Computers and Software (IRECOS), 11 (9), pp. 804-815.
http://dx.doi.org/10.15866/irecos.v11i9.10070


Refbacks

  • There are currently no refbacks.



Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize