Download pdf
The application of backend database systems in precision marketing: A case study of Nike official online store
- 1 Communication University of China
* Author to whom correspondence should be addressed.
Abstract
In the era of big data, databases have become a powerful tool for enterprises to gain insight into consumer behavior and market dynamics. However, some enterprises, especially small and medium-sized ones, focus too much on data volume growth while ignoring the importance of data relevance, resulting in unsatisfactory marketing outcomes. Based on this, this paper provides an example of Nike official online store. With the assistance of structured query language (SQL), a backend database system is created under the Oracle11g R2 environment, and its functions are simulated and demonstrated. The system is capable of managing user, product, and order transaction information through basic functions such as adding, querying, modifying, and deleting. In addition, it serves as a foundation for Nike's precision marketing efforts through user profile construction, user behavior analysis, and demand forecasting based on basic statistical methods of counting, proportioning, and sorting.
Keywords
backend database, precision marketing, online shopping, SQL
[1]. Statista.E-commerce worldwide-statistics&facts. Feb 27, 2023.: https://www.statista.com/topics/ 871/online-shopping/#topicOverview
[2]. PracticalEcommerce. Charts:U.S. Retail Ecommerce Sales Q1 2023.May 24, https://www. practicalecommerce.com/charts-u-s-retail-ecommerce-sales-q1-2023
[3]. Li L L, Hu Y Q 2022 J. Science & Technology Economy Market 157-160
[4]. Wang Y J 2015 J. Modern Electronics Technique 38 119-122
[5]. Lee Z J, Su Z Y, Cheng X, et al 2020 J. Artificial Intelligence Evolution 1 1-7
[6]. Wei F, Zhang Q 2018 C. MATEC Web of Conferences 246 03033
[7]. Yang T 2017 J.Voice & Screen World 104
[8]. Desai V, Vidyapeeth B. 2019 J. Inter. J. Trend Sci. Res. Devel. 5 196-200
[9]. Blattberg R C, Kim B D, Neslin S A, et al 2008 Why database marketing? Springer New York 18 13
[10]. Zeng Y M 2022 J. Auto. Appl. 67-70
[11]. Curley C 2000 J.Linux J.2000 17-es
Cite this article
Yan,Y. (2024). The application of backend database systems in precision marketing: A case study of Nike official online store. Applied and Computational Engineering,38,200-209.
Data availability
The datasets used and/or analyzed during the current study will be available from the authors upon reasonable request.
Disclaimer/Publisher's Note
The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of EWA Publishing and/or the editor(s). EWA Publishing and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content.
About volume
Volume title: Proceedings of the 2023 International Conference on Machine Learning and Automation
© 2024 by the author(s). Licensee EWA Publishing, Oxford, UK. This article is an open access article distributed under the terms and
conditions of the Creative Commons Attribution (CC BY) license. Authors who
publish this series agree to the following terms:
1. Authors retain copyright and grant the series right of first publication with the work simultaneously licensed under a Creative Commons
Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this
series.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the series's published
version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial
publication in this series.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and
during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See
Open access policy for details).