...
首页> 外文期刊>International Journal on Communications Antenna and Propagation >Data warehouse development for customer WIFI access service at a telecommunication company
【24h】

Data warehouse development for customer WIFI access service at a telecommunication company

机译:电信公司为客户WIFI接入服务开发数据仓库

获取原文
获取原文并翻译 | 示例
           

摘要

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.
机译:作为印度尼西亚电信和宽带业务的主要上市公司,PT XYZ一直试图确保提供足够的wifi接入服务,以满足宽带消费者的需求。此wifi服务称为wifi-id,它通过与其他网络提供商合作使用Authentication,Authorization,Accounting(AAA)服务器。这项研究基于PT的需求。 XYZ可以在需要时(尤其是在PT时)快速呈现报告或数据。 XYZ需要将每月客户的总使用量与业务合作伙伴进行核对,以便进行计费收益共享合作伙伴关系。出现问题是因为代表宽带用户使用的CDR脚本(称为数据记录)仅以CSV文件的形式存储。这使得很难报告PT所需的客户访问权限。 XYZ。建议的解决方案是将现有数据移动到数据仓库中结构更清晰的存储中。数据仓库开发是通过Kimball和Ross设计的九步方法完成的。此外,可以使用OLAP分析数据,从而以可视形式(例如报表或仪表板)呈现数据。有了这个解决方案,PT。 XYZ可以相对更快地处理和呈现报告。此外,PT。 XYZ也将从信息形式存储的数据中获得更多收益。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号