Abstract
The objective of this research was to develop an indexed database on electrical appliances marketed in the city of Ibarra, Ecuador, using web scraping in order to optimize the search time of consumers for these products. It is an applied research, where the survey technique was applied to determine the marketers and the products to be considered. The results of the survey led to directing the study in the marketers Todohogar, Almacenes Japon and La Ganga and to the products: televisions, kitchens and refrigerators. The web scraping process contemplated three phases: search and inspection of the web page, data extraction and cleaning and transformation and storage of final data, for which the Python program and the Request and Beautiful Soup libraries were used. The Data Access Object (DAO) design pattern was used to separate the logic layer from data access, and the connection to the MySQL database was defined with the Python programming language using the mysql.connector library. For the automatic and indexed storage of the data extracted and refined from the pages of the marketers, some databases called product table, characteristic table, brand table were built. As a result, there is a web page that makes use of the web scraping program developed to show the user the summarized and updated information of the three products offered by each of the marketers analyzed.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Cauna Huanca, G.J.: Indexación de sitios web para optimizar la búsqueda de paquetes turÃsticos de la región de Puno basado en Web Scraping. Universidad Nacional del Altiplano (2021). http://repositorio.unap.edu.pe/handle/UNAP/16821
Uzun, E.: A novel web scraping approach using the additional information. IEEE Access 8(1), 61726–61740 (2020). https://doi.org/10.1109/ACCESS.2020.2984503
Matta, P., Sharma, N., Sharma, D., Pant, B. and Sharma, S.: Web scraping: applications and scraping tools. Int. J. Adv. Trends Comput. Sci. Eng. 9(5) (2020). https://doi.org/10.30534/ijatcse/2020/185952020
Khder, M: Web scraping or web crawling: state of art, techniques, approaches and application. Int. J. Adv. Soft Comput. Appl. 13, 145–168 (2021). https://doi.org/10.15849/IJASCA.211128.11
Valle, G.: Aplicación de técnicas de web scraping y procesamiento del lenguaje natural para la extracción y evaluación de información de una página web de empleo. (2021). https://repositorio.comillas.edu/xmlui/bitstream/handle/11531/55160/TFM%20-%20Valle%20Gutierrez%20Guillermo.pdf?sequence=1
Persson, E.: Evaluating Tools and Techniques for Web Scraping. Dissertation (2019). https://www.diva-portal.org/smash/get/diva2:1415998/FULLTEXT01.p
Lin, C.F., Yang, S.C.: Taiwan stock tape reading periodically using web scraping technology with GUI. Appl. Syst. Innov. 5(1), 28 (2022). https://doi.org/10.3390/asi5010028
Cárdenas Rubio, J.A., Chaux Guzmán, F.J., Otero, J.: Una base de datos de precios y caracterÃsticas de vivienda en Colombia con información de Internet. Revista de EconomÃa del Rosario 22(1), 25 (2019). https://doi.org/10.12804/revistas.urosario.edu.co/economia/a.7768
Manrique Andrade, S.R., Sanchez Rubio, C.J.: Compras eficientes—supermercados. Universidad de Lima (2019) https://hdl.handle.net/20.500.12724/12357
Sanabria De Luque, J.J.: Sector privado y libre competencia: implicaciones jurÃdicas del web scraping. Universidad Externado de Colombia (2021). https://bdigital.uexternado.edu.co/handle/001/4246
Todohogar: Todohogar.com. https://www.todohogar.com/
Almacenes Japón: Almacenesjapon.com. https://almacenesjapon.com/
Almacenes La Ganga: Almaceneslaganga.com. https://www.almaceneslaganga.com/pedidos-en-linea/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Albuja, D., Guerra, L., Rivero, D., Quishpe, S. (2023). Optimizing Marketing Through Web Scraping. In: Reis, J.L., Peter, M.K., Varela González, J.A., Bogdanović, Z. (eds) Marketing and Smart Technologies. Smart Innovation, Systems and Technologies, vol 337. Springer, Singapore. https://doi.org/10.1007/978-981-19-9099-1_51
Download citation
DOI: https://doi.org/10.1007/978-981-19-9099-1_51
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-19-9098-4
Online ISBN: 978-981-19-9099-1
eBook Packages: EngineeringEngineering (R0)