VIETNAM NATIONAL UNIVERSITY - HO CHI MINH CITY HO CHI MINH UNIVERSITY OF TECHNOLOGY COMPUTER SCIENCE AND ENGINEERING FACULTY GRADUATION THESIS Computer Hardware Analytic for Electronic Commerce Department: Computer science Committee: Computer Science 2 Advisor: Dr. Phan Trong Nhan Reviewer: Assoc. Nguyen Thanh Binh ---o0o--- Students: Ly Gia Bao 1752089 Tran Nguyen Anh Huy 1752244 Tran Anh Thai 1752494 Le Huynh Long Vy 1752637 HO CHI MINH CITY, 12/2021 A萎K"J窺E"SW渦E"IKC"VR0JEO E浦PI"JñC"ZÊ"J浦K"EJ曳"PIJ C"XK烏V"PCO ---------- A瓜e"n壱r"- V詠"fq"- J衣pj"rj¿e VT姶云PI"A萎K"J窺E"DèEJ"MJQC KHOA:KH & KT Máy tính ____ PJK烏O"X影"NW一P"èP"V渦V"PIJK烏R D浦"OðP<HTTT ____________ Ej¿"#<"Ukpj"xk‒p"rjVk"fƒp"vぜ"p {"x q"vtcpi"pjXv"eてc"dVp"vjw{xv"vtình J窺"XÉ"VçP< Lý Gia B違q____________________________ MSSV: 1752089 ______ J窺"XÉ"VçP< Tr亥p"Piw{宇p"Cpj"Jw{ __________________ MSSV: 1752244 ______ J窺"XÉ"VçP< Tr亥p"Cpj"Vjái _________________________ MSSV: 1752494 ______ J窺"XÉ"VçP< Lê Hu pj"Nqpg V悦 _____________________ MSSV: 1752637 ______ NGÀNH: Khoa h丑e"Oáy tính ___________________ N閏R<______________________ 30"A亥w"8隠"nw壱p"ƒp< Computer Hardware Analytics for Electronic Commerce ______________________________ 40"Pjk羽o"x映"*{‒w"e亥w"x隠"p瓜k"fwpi"x "u嘘"nk羽w"dcp"8亥w+< 薑 Surveying and analyzing related systems. 薑 Finding out hardware data sources for analytics.
薑 Proposing core features for the whole system towards recommendation, association rules, personalization, segmentation, and trends of hardware combination. 薑 Identifying main academic problems to be solved. 薑 Researching relevant theory (mainly association rules, prediction, recommendation techniques) and practical approaches for the core features implementation as well as for those issues. 薑Researching in-need technologies.
薑Designing the system with the proposed features and solutions. 薑Developing a system prototype. 薑Implementing and perfect the system. 薑Conducting empirical experiments.
Pi {"ikcq"pjk羽o"x映"nw壱p"ƒp< 23/08/2021 60"Pi {"jq p"vj pj"pjk羽o"x映< 13/12/2021 70"J丑"v‒p"ik違pi"xk‒p"j逢噂pi"f磯p< Rj亥p"j逢噂pi"f磯p< 1) TS. Phan Tr丑pi"Pjân ________________________________________________________ P瓜k"fwpi"x "{‒w"e亥w"NXVP"8«"8逢嬰e"vj»pi"swc"D瓜"o»p0 Ngày 23. tháng 080"p<o"2021 EJ曳"PJK烏O"D浦"OðP IK謂PI"XKçP"J姶閏PI"F郁P"EJëPJ *M#"x "ijk"t "jが"v‒p+ *M#"x "ijk"t "jが"v‒p+ PGS. Tr亥p"Okpj"Swcpi TS.
Phan Tr丑pi"Pjân RJYP"FÉPJ"EJQ"MJQC."Dし"OðP< Pi逢運k"fw{羽v"*ej医o"u挨"d瓜+<________________________ A挨p"x鵜< _______________________________________ Pi {"d違q"x羽< __________________________________ Ak吋o"v鰻pi"m院v< _________________________________ P挨k"n逢w"vt英"nw壱p"ƒp< _____________________________ VT姶云PI"A萎K"J窺E"DèEJ"MJQC E浦PI"JñC"ZÊ"J浦K"EJ曳"PIJ C"XK烏V"PCO KHOA KH & KT MÁY TÍNH A瓜e"n壱r"- V詠"fq"- J衣pj"rj¿e ---------------------------- Ngày 20 tháng 12 p<o 2021 RJK蔭W"EJ遺O"D謂Q"X烏"NXVP *F pj"ejq"pi⇔ぜk"j⇔ずpi"fdp) 30"J丑"x "v‒p"UX< Lý Gia B違q MSSV: 1752089 Ngành (chuyên ngành): Khoa h丑e"Oáy tính J丑"x "v‒p"UX< Tr亥p"Piw{宇p"Cpj"Jw{ MSSV: 1752244 Ngành (chuyên ngành): Khoa h丑e"Oáy tính J丑"x "v‒p"UX< Tr亥p"Cpj"Vjái MSSV: 1752494 Ngành (chuyên ngành): Khoa h丑e"Oáy tính J丑"x "v‒p"UX< Lê Hu pj"Nqpg V悦 MSSV: 1752637 Ngành (chuyên ngành): Khoa h丑e"Oáy tính 40"A隠"v k< Computer Hardware Analytics for Electronic Commerce 50"J丑"v‒p"pi逢運k"j逢噂pi"f磯p: TS. Phan Tr丑pi"Pjân 60"V鰻pi"swƒv"x隠"d違p"vjw{院v"okpj< U嘘"vtcpi< U嘘"ej逢挨pi< U嘘"d違pi"u嘘"nk羽w U嘘"j·pj"x胤< U嘘"v k"nk羽w"vjco"mj違q< Rj亥p"o隠o"v pj"vqƒp< Jk羽p"x壱v"*u違p"rj育o+ 70"V鰻pi"swƒv"x隠"eƒe"d違p"x胤< - U嘘"d違p"x胤< D違p"C3< D違p"C4< Mj鰻"mjƒe< - U嘘"d違p"x胤"x胤"vc{ U嘘"d違p"x胤"vt‒p"oƒ{"v pj< 80"Pj英pi"逢w"8k吋o"ej pj"e栄c"NXVP< - Students developed a system that analyzes computer componentsÓ score bands and recommends the combination of them, especially with their compatibility while there are many choices, to meet the end-usersÓ need. Both auto and manual modes with advanced options are supported. Moreover, the users can customize their options as they wish.
Even when the result is not found, the recommendation module will be automatically triggered. - Students analyzed problem statement as well as its related work and challenges. - Students applied modern technologies such as Django/python compatible with MVC pattern, redis, selenium, scrapy to implement the system and deployed the database on Google Cloud Platform. - Students were very proactive and open to novel knowledge and technology.
90"Pj英pi"vjk院w"u„v"ej pj"e栄c"LVTN: - The evaluation of recommendation and system testing is still limited. - Some features need to improve such as dashboard with more metrics and component choices with further personalization, flexibility, and reliable benchmark scores. A隠"pij鵜<"A逢嬰e"d違q"x羽"Z D鰻"uwpi"vj‒o"8吋"d違q"x羽"¸ Mj»pi"8逢嬰e"d違q"x羽"¸ ;0"5"e¤w"j臼k"UX"rj違k"vt違"n運k"vt逢噂e"J瓜k"8欝pi< 320"Aƒpj"ikƒ"ejwpi"*d茨pi"ej英<"ik臼k."VD+< Very good Ak吋o"<"9.5/10 M#"v‒p"*ijk"t "j丑"v‒p+ Phan Tr丑pi"Pjân Ho Chi Minh City University of Technology SOCIALIST REPUBLIC OF VIETNAM Faculty of Computer Science and Engineering Independence Î Freedom Î Happiness REVIEW OF GRADUATION THESIS HCMC, 28th December 2021 1. Students name: N#"Ikc"D違q"*1752089) Vt亥p"Piw{宇p"Cpj"Jw{"*1752244) Vt亥p"Cpj"Vjƒk"*39746;6+ N‒"Jw pj"Nqpi"X悦"*3974859+ 2.
Major: Computer Science 3. Thesis title: Computer Hardware Analytic for Electronic Commerce 4. Nguyen Thanh Binh, PhD 5. Contents - In this thesis, the authors built a system helping the users to build a computer even if they have no experience, while simultaneously providing an alternative for those who want to pick and choose the components for their own computer.
The tasks in this thesis: + Build a web-server to interact with users. + Build a collection of data from multiple sources. + Build a data storage. + Develop an algorithm that will automatically generate a PC based on the user's requirements.
+ Devgnqr"c"ukorng"tgeqoogpfcvkqp"u{uvgo"dcugf"qp"wugtÓu"kpvgtcevkqpu0 - The authors should explain more system which the authors built. The system has disadvantages for users. - Some spelling errors in the essay. - The author should clarify the advantages of the system which was built compared to existing systems.
General assessment: Marks 8.5/10 Reviewer Nguyen Thanh Binh Ho Chi Minh City, University of Technology Department of Computer Science and Engineer Declaration We guarantee that this research is our own, conducted under the supervision and guid- ance of our Instructor Phan Trong Nhan. The result of our research is legitimate and has not been published in any forms prior to this. All materials used within this research are collected by ourselves, by various sources which are appropriately listed in the references section. In any case of mistake, we will take full responsibility for it.
Graduation Thesis Page 1 /83 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer Acknowledgements We would like to express our deepest gratitude to our advisor Dr. Phan Trong Nhan for the continuous support and guidance during the making of our thesis. Nhan, we would also like to thank all of our faculty lecturers, who have given us valuable and necessary knowledge to accomplish this project. Finally, we wish you health, wealth, and success in your endeavors.
Graduation Thesis Page 2 /83 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer Abstract Nowadays, in the age of technologies, a personal computer (PC) is becoming the most crucial part of our everyday life. However, for people who do not have a solid understanding or familiarity with the area, purchasing or building a proper computer for a person’s needs can be difficult. Therefore, it is an urgent need to research and develop a system that can take care of collecting the components’ data and help the user to build a computer that meets their requirements. In this topic, we are trying to create a system that focuses on helping the users to build a computer even if they have no experience, while simultaneously providing an alternative for those who want to pick and choose the components for their own computer.
The system’s major goals will be to create a computer based on the user’s requirements, collect necessary data, and store it. Furthermore, using the information gathered from user interactions, we will create a simple recommendation system that will identify some of the most popular PCs and have them suggested to users. Graduation Thesis Page 3 /83 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer Content 1 Introduction 10 1. 11 2 Methodologies and Theoretical Background 12 2.1 Manual PC builders .2 Automatic PC generator .3 PC performance calculator .4 Google Cloud platform.
17 3 System Requirement Analysis 18 3.1 Automatic computer builder .2 Manual computer buider .3 Non-Functional requirement .2 Use-case Specification .1 How the system work. 35 Graduation Thesis Page 4 /83 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer 4.2 Detailed information of each entity in the ERD .4 Web server Component .2 Build PC module .a Checking the compatibility between the components 50 4.b Build a PC from the user’s requirements .2 PC Auto Generator Page .3 PC Auto Generator Result Page .4 PC Manual Generator Page .5 Customize PC Set Page .6 View PC Set Details Page .7 Search Product Page .1 Non-functional Testing. 77 Graduation Thesis Page 5 /83 List of Figures 1.1 Budget distribution for gaming PC [3] .1 Use-Case diagram .2 Use-Case diagram .2 General idea of index page and product page .3 The flowchart of crawling .5 Web server general architecture .6 Checking compatibility between the CPU and motherboard .7 Intel CPU generation .8 Workflow for auto building PC .9 How PC scores are calculated [16] .10 Workflow with data from Redis .2 PC Auto Generator Page .3 Expand Advanced options .7 Recommendation when generate fails .8 PC Manual Generator Page .11 PC 1 Details Page .12 Search Product Page .1 Non-functional testing for the auto builder.2 Non-functional testing for the auto builder result page.3 Non-functional testing for the manual builder.4 Functional testing for the auto builder.5 Functional testing for the auto builder (cont.6 Functional testing for the manual builder.7 Functional testing for the recommendation system. 76 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer 7.1 Non-functional testing for navigation and login page.2 Non-functional testing for register page.3 Non-functional testing for detail page and product page.4 Functional testing for login page and register page.5 Functional testing for the auto builder result page.6 Functional testing for detail page and product page.
83 Graduation Thesis Page 7 /83 List of Tables 1 User Login. 22 2 User Login (cont. 24 4 Build PC Automatically. 25 5 Build PC Manually.
26 6 Re-examine Requirements. 27 7 View PC Set’s Details. 28 8 View PC Set’s Details. 29 9 Access Seller Pages.
30 10 Save a Complete PC Set. 45 22 RAM_Usage table. 45 23 SSD_Usage table. 46 24 HDD_Usage table.
46 25 PSU_Usage table. 47 26 Main_comp table. 48 27 Base budget percentage for each component compare to maximum budget. 59 Abbreviation and Acronym Abbreviation Meaning PC Personal computer CPU Central processing unit GPU Graphics processing unit RAM Random-access memory HDD Hard disk drive SSD Solid-state drive PSU Power supply unit Ho Chi Minh City, University of Technology Department of Computer Science and Engineer 1 Introduction 1.1 Problem statement In recent years, with the advancement of technology, a PC now is able to help us with many aspects of life including studying, working, entertaining,etc.
But a PC is not a simple product and not all PCs are the same. In fact, a PC is made up of various components, and the purpose and grade of the computer might vary depending on the components used. For example, a PC used for entertaining purposes, specifically gaming, first prioritizes the budget on the graphics processing unit (GPU), second CPU and memory, other components such as storage and power supply unit (PSU) have lower priority because GPU, CPU and memory will have higher impact on the gaming experience compared to others.1: Budget distribution for gaming PC [3] A PC utilized for working purposes, notably office work, on the other hand, may not even require a GPU, but rather a strong CPU and RAM to provide greater performance when performing office tasks. When compared to the requirement to handle the heavy image processing load when operating a game, office tasks frequently include only dealing with documents and calculations.
Each component of a PC may have many manufacturers and each of them may also have their own specifications that need to be taken into consideration when purchasing. As a result, a system that allows a user to select from a wide range of components and build a PC that meets their needs while staying within budget has shown to be beneficial. Graduation Thesis Page 10 /83 Ho Chi Minh City, University of Technology Department of Computer Science and Engineer 1.2 Goal The main objective of the thesis is to develop a web-based system that can assist the users in the process of building a PC by checking the compatibility and the performance of the components, making sure that it matches the user’s requirements while also providing a tool for those who want to pick and choose their own components. The system will need a way to collect necessary data from multiple websites, specifically from computer hardware websites as well as a storage for those data.
In addition, the thesis will also propose a simple recommendation system that bases on the user’s interactions with the system.3 Scope In the scope of this thesis, we will focus on: • Build a web-server to interact with users.