A Scheme for Automation of Telecom Data Processing for Business Application
T. R. Gopalakrishnan Nair, Vithal. J. Sampagar, V. Suma, Ezhilarasan, Maharajan

TL;DR
This paper presents an automated system for processing large volumes of telecom transactional data, utilizing SSIS tools for efficient extraction, transformation, and loading into databases, with tracking for risk mitigation.
Contribution
It introduces a novel automated parsing and data processing scheme for telecom data using SQL Server Integration Services (SSIS), enhancing efficiency and risk management.
Findings
Automated data processing reduces manual effort.
Effective tracking improves risk mitigation.
System handles large-scale telecom data efficiently.
Abstract
As the telecom industry is witnessing a large scale growth, one of the major challenges faced in the domain deals with the analysis and processing of telecom transactional data which are generated in large volumes by embedded system communication controllers having various functions. This paper deals with the analysis of such raw data files which are made up of the sequences of the tokens. It also depicts the method in which the files are parsed for extracting the information leading to the final storage in predefined data base tables. The parser is capable of reading the file in a line structured way and store the tokens into the predefined tables of data bases. The whole process is automated using the SSIS tools available in the SQL server. The log table is maintained in each step of the process which will enable tracking of the file for any risk mitigation. It can extract, transform…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsAdvanced Database Systems and Queries · Embedded Systems and FPGA Design · Software Engineering and Design Patterns
