DAI HQC DA NANG TRUONG DAI HQC SU PHAM VONGVILAI THIDSAMAI UNG DUNG CONG NGHE HDP VAO VIEC TOI UU LUU TRU DC LIEU TAI TONG CONG TY MANG LLOI LAO TELECOM, TINH ATTAPEU NU6C CHDCND LAO LUAN VAN TH AC SI CONG NGHE THONG TIN • • • Da Nlng - 2023 DAI HOC DA NANG TRUCJNG DAI HOC SU PHAM VONGVILAI THIDSAMAI CNG DUNG CONG NGHE HDP VAO VIEC TOI ll LUU TRU* DC LIEU TAI TONG CONG TY MANG LUOl LAO TELECOM, TINH ATTAPEU NUOC CHDCND LAO Chuyen nganh: He thong thong tin Ma so: 84.104 • VAN TH AC LUAN • SI CONG NGHE• THONG TIN Ngu’di hurting dan khoa hoc: TS. Nguyen Dinh Lau Da Nang - 2023 1 LOI CAM DOAN Toi xin cam doan day la cong trinh nghien cthi do toi thuc hien duai str hiring dan cua TS. Nguyen Dinh Lau tai bo mon He thong Thong tin, Khoa Cong nghe Thong tin, Taring Dai hoc Su Pham Da Nang. Cac so lieu va ket qua trinh bay trong luan an la (rung thuc, chua duac cong bo boi bat ky tac gid nao hay a bat ky cong trinh nao khac.
lac gia Vongvilai Thidsamai •• 11 LOI CAM ON > r > e Trude tien toi xin gui ldi cam on chan thanh va sau sSc den thay giao, TS. Nguydn Dinh Lau - ngudi da hudng dan, khuyen khich, truyen cam hung, chi bao va tao cho toi nhung dieu ki?n tot nhat tu khi bat dau nghien cuu den khi hoan thanh luan van nay. Toi xin chan thanh cam on cac thay cd giao khoa Cong nghe thong tin, trubng Dai hoc su pham Da NSng, dac biet la cac Thay Co trong Bq mon II? thong Thong tin da tan tinh dao tao, cung cap cho toi nhung kien thuc vo cung quy gia, da tao dieu kien tot nhat cho toi de hoan thanh luan vSn n^y. Dong then toi xin chan thanh cam on cac ban trong ldp K40.HTTT da tao moi ' C * X X c dieu ki?n, giup dd va bo tri thdi gian tot nhat danh cho toi trong suot qua trinh lam luan van.
Cuoi cung, toi xin chan thanh cam on nhung ngudi than trong gia dinh cung toan the ban be da luon giup dd, dong vien toi nhung luc gap phai kho khan trong suot qua trinh hQC tap va nghien cuu. TRANG THONG TIN LUAN VAN THAC SI • • l en de lai: : UNG DUNG • CONG NGHE• HDP VAO VIEC • TOI U U LUU TRU DU LIEU TAI TONG CONG TY MANG LUOl LAO TELECOM, TINH ATTA PE U NUOC CIIDCND LAO Nganh: J le thong thong tin Ho va ten h(?c vien: VONG VI I. Al THIDSAMAI Ngirai hirong dan khoa hoc: IS. NGUYEN DINH LAI J Co so dao tao:Truong Dai hoc Sir phain.
Dai hoc Da Nang. lorn tAt: Cong ngh$ thong tin va vien thong con la mot trong nhirng dieu ki?n chinh quyet dinli sir phat trien cua nen kinh te the gidi. No tac dong sail sAc den each chung la dang song, hoc tap va lain vi$c: den each thirc nha nude giao tiep vdi dan. Nd Cling t$o ra nhirng lhach thirc kinh te.
xa hoi trirdc eac ca nhan. cong dong d moi noi tren trai dal nhAm dat hi$u qua va tinh sang tao cao lion, lat ca chung la dang dung trirdc va can nam bat co hoi nas. Hortonworks Data Platform La mot nen tang phat trien va xay dirng hoan toan md. 11 DP dirge rhiet ke de dap img nhu can xir ly du li£u Idn cua doanh nghi$p.
IIDP la linh hoyt. cung cap kha nang nd rong tuyen tinh. md rong liru trit va tinh loan Iren mot loat cac phirong phap truy cap (access nethods). batch va real-time, search va streaming.
Nd bao gom nipt tap hop loan dien cac kha nAng xir ly dir li$u cho doanh nghiep nhir: governance, integration, security va operation. Ap dung nhtfng cong nghe mdi nay vao viec luu trii va xu ly dir lieu Idn. Trong nganh vien thong thi dir li?u la circ ky Idn. nhal la doi vdi dir lieu lien quan den cuoc ggi.
tin nhan va hanh vi sir dyng dir li$u. Doi vdi nha mang Lao Telecom thi nhirng dCr lieu nay phat sinh khoang 2.5 I B den 3T * __ r irong mot thang. doi vdi nha myng Lao Telecom thi dd lipu nay khoang I.5T den 2TB mot thang. Do Idn cua dir lieu phu tlnioc vao so lirgng time bao cua moi nha mang va cac thong tin lien quan ma tong dai sc ghi nhan lai.
I rong de tai. tir ket qua phan tich so sanh giira giai phap cu va giai phap mdi ta thay ket qua cua giai phAp mdi tot hern. I hdi gian thyc hipn import so li?u vao he thong nhanh horn hAn so vdi giai phap cu. dCr lieu cirdc cua khach hang ngay cang Idn.
moi nam co the tang 20-30%, vi vay neu van ip dyng cong nghe cu va giai phAp cu s6 khong dAp img dirge nhu can thyc te. Vdi cong ngh? mdi va giai phap mdi sc hoan toan cd the dap irng dirge cac yeu cAu nay. cong ngh^ dirge ra ddi de chuyen dung cho cac co sd dil lieu Idn. xir ly dir lieu Idn trong thdi gian thyc.
De tai cd gia trj ve mat ly thuyet. Co the sir dyng de tai nhir la tai li$u tham khao doi vdi sinh vien nganh hp thong thong tin va hieu phirong phap sir dung cong ngh£ HDP de img dyng vao thyc te. Dira ra hgp gdp phan Idn vao vi?c liru trir va xir Iv d& lieu ciia nha mang Lao Telecom. lir khoa: toi iru liru tnr dur lieu; xir ly dfr lieu Idn: cong ngh? HOP: cong ngh^ vien thong: cong igh$ thong tin.
X Xac nhan ciia giao vien hiron an Ngirfri thuc hi{*n de tai IS. V0NGV1LAI THIDSAMAI INFORMATION PACE OF MASTER THESIS Name of thesis: APPLYING HDP TECHNOLOGY TO OPTIMIZE DATA STORAGE AT LAO TELECOM NETWORK COMPANY, ATTAPEU PROVINCE, LAOPDR. Major: Information system Full name of Master student: VONGVILA1 THIDSAMAI Supervisors: PhD. NGUYEN DINH LAU I raining institution: University of Education.
University of Danang Abstract: Information technology and telecommunications are also one of the main conditions determining the development of the global economy. It deeply affects the way we live, learn, and work: the way the state communicates with the people. It also creates economic and social challenges for individuals, businesses, and communities everywhere on the planet to achieve higher efficiency and creativity. All of us are facing and need to seize this opportunity.
Hortonworks Data Platform (HDP) is a fully open development and construction platform designed to meet the needs of enterprise big data processing. HDP is flexible, providing linear scalability, expandable storage and computing across a range of access methods, batch and real-time, search and streaming. It includes a comprehensive set of data processing capabilities for enterprises such is governance, integration, security, and operation. Applying these new technologies to the storage and processing of big data is crucial.
In the telecommunications industry , data is extremely large, especially for data related to calls, messages, and data usage behavior. For Lao Telecom, this data generates about 2.5TB to 3T per month, while for other telecom companies, this data is about 1.51 to 2TB per month. The size of the data depends on the number of subscribers of each telecom company and the related information that the switchboard will record. In the research project, the comparison analysis results between the old solution and the new solution showed that the new solution performs better.
The time it takes to import data into the system is much faster than the old solution. In addition, the customer billing data is increasing every year, possibly by 20-30%. so if the old technology and solution are still applied, they will not meet practical •equirements. With the new technology and solution, these requirements can be completely met.
This technology was developed specifically for large databases and processing big data in real-time. The topic is valuable in terms of theory. It can be used as a reference for students in the field of information systems to understand the method of using HDP technology to apply it in practice. It provides a significant contribution to the storage and processing of data for Lao Telecom.
Keywords: data storage optimization; big data processing: HDP technology: telecommunications technology: information technology. Supervior’s confirmation Student PhD. NGUYEN DINH LAU VONGVILAI THIDSAMAI iii MUC • LUC • Ldl CAM DOAN. Ldl CAM ON.
ii DANH MVC CAC KY HIEU, CHU VIET TAT. v DANH MUC BANG. vi DANH SACH HINH VE. vii MO DAU.
Ly do chon de tai. Muc ticu nghien cuu. Doi tuong va pham vi nghien cuu. Phuong phap nghien cuu.
Y nghia khoa hoc va thuc tien cua de tai. Ket qua du kien. Bo cue • van. DAT VAN DE VE BAI TO AN TINII CUOC DANG DUNG TAI LAO TELECOM.1 Mo hinh, hien trang va nghiep vu cua he thong Lao Billing.1 Giai thieu mo hinh he thong Lao Billing.2 Cac nghiep vu linh cudc.2 Nhung ton tai cua he thong.
PHAN TICH, LUA CHON VA THIET KE GIAI PHAP.1 Mo hinh giai phap cu.1 Mo hinh vat ly he thong Billing hien tai.2 Mo hinh logic he thong Billing hien tai.2 Mo hinh giai phap he thong Billing moi va hoan toan mien phi[ 101.3 Mo hinh giai phap mien phi ket hop co phi.4 So sanh giai phap mien phi hoan toan va giai phap ket hop co phi. 28 CHUONG 3 UNG DUNG CONG NGHE HORTONWORKS DATA PLATFORM 3.1 Horton works Data Platform.2 HDP Data Management.4 HDP Data Access.5 HDP Data Governance and Integration.7 HDP Cluster Operations.8 Trien khai cac tuy chon cua Hadoop.9 Cai dal Hortonworks Sandbox tren windows sir dung Oracle VirtualBox.1 Cai dat tren Windows bang each sir dung Oracle VirtualBox.2 Import tap tin Sandbox: File-> Import Appliance.3 Cira so Import Virtual Appliance xuat hien.4 Import Virtual Applicance.5 Man hinh cai dat thiet bi xuat hien. Ban co the phan bo RAM nhieu hon so vdi » 9 mac dinh de nang cao hieu suat.6 Thiet bi dirge Import.8 Dgi may ao khdi dong len.9 Sir dung trinh duyet tren may chu de mb cac URL hien thi tren giao di?n dieu khien. DANH GIA THUC NGHIEM SO SANH GIAI PHAP CU VA GIAI PIIAP MC5I.1 Mo hinh logic he thong thirc nghiem.2 Phurong phap lay so lieu thirc nghiem.3 Phan tich, so sanh so lieu thirc nghiem gitra hai he thong.
57 KET LU AN, KHUYEN NGHI. 59 DANH MUC TAI LIEU TH AM KHAO.60 • • V DANH MUC CAC KY HIEU, CHU VIET TAT r rw-’ Tii- viet tat TIT goc Giai nghia - Tam dich f KPI Key Performance La chi so danh gia cong vi?c, cong cu do lirong Indicator nharn phan anh hieu qua hoat dong CNTT Cong nghe thong tin CSKH Cham soc khach hang CSDL Co so dir lieu F CDR Call Detail Record Ban ghi chi tiet cuoc goi F F SQL Structured Query Ngon ngu' truy van co cau true Language Switch Bo chuyen mach Load Bo can bang tai Balacing Firewall Tuong lira vi DANH MUC BANG So hieu Ten bang Trang bang 2.1 So sanh tinh nang EBS cua cac nha cung cap dich vu 26 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- f 2.2 So sanh Database cua cac nha cung cap dich vu 27 4.1 Cau hinh may chu 41 4.2 Thong tin co ban moi lan chay 43 --------------------------------------------------------------------------- 7------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 4.