Database Click Stream of E-commerce Functional
DOI:
https://doi.org/10.30812/matrik.v21i1.1446Keywords:
E-commerce functional, Click stream, Database life cycleAbstract
The availability of e-commerce functionality that suits for user needs in e-commerce applications will increase the sustainability of application usage and can provide benefits for its users. Many e-commerce applications have been developed, but based on the results of previous research, these e-commerce applications do not pay attention to the availability of functionality and its advantages in the application. A database design to store functional clickstream ecommerce is required to determine the number of features that users are accessing. Database application development is the activity of identifying real-world requirements, analyzing requirements, designing system data and functions, and then implementing operations in the system. The database life cycle method is used to build a database in this study. This research has produced a click stream database that has added functional attributes available in e-commerce, which are accessed by users. The results also show the addition of several tables that will facilitate the management of click stream data functionality from e-commerce applications.
Downloads
Download data is not yet available.
References
[1] N. Al-Qirim, “The adoption of eCommerce communications and applications technologies in small businesses in New Zealand,†Electronic Commerce Research and Applications, vol. 6, pp. 462–473, 2007.
[2] E. Gide, “The Key Strategies for E-commerce Success Service SMEs in China", IEEE hal 229 -234,†in IEEE International Conference on Service Operations and Logistics, and Informatics, 2006, pp. 229–234.
[3] Y. Rianto, E. Aminullah, C. Laksani, D. Prihadyanti, B. Triyono, and L. . Handoko, Peta dan Strategi Adopsi teknologi Informasi di UKM Manufaktur. Jakarta: LIPI Press, 2007.
[4] L.-M. Chang, S.-I. Chang, C.-T. Ho, D. Yen, and M.-C. Chiang, “Effects of IS Characteristics on The E-Business Success Factors for Small-and Medium-Sized Enterprises,†Computers in Human Behavior, vol. 27, pp. 2129–2140, 2011.
[5] E. Turban, Introduction to Electronic Commerce, 2nd ed. New Jersey: Pearson Prentice Hall, 2009.
[6] E. Triandini, A. Djunaidy, and D. Siahaan, “Determining E-commerce Adoption Level by SMEs in Indonesia Based on Customer-Oriented Benefits,†in Internatioal Conference on Information Technology, Computer and Electrical Engineering (ICITACEE2014), Nov. 2014, pp. 281–285.
[7] F. Wahid and L. Iswari, “Information Technology Adoption by Small and Medium Enterprises in Indonesia,†in The National Seminar on Information Technology Application, 2007, pp. 75–79.
[8] E. Triandini, A. Djunaidy, and D. Siahaan, “Development of a conceptual model of E-commerce adoption for SMEs in Indonesia,†in 2013 International Conference on Information Technology and Electrical Engineering (ICITEE), 2013, pp. 93–96.
[9] G. D. Gregory, L. V. Ngo, and M. Karavdic, “Developing e-commerce marketing capabilities and efficiencies for enhanced performance in business-to-business export ventures,†Industrial Marketing Management, vol. 78, pp. 146–157, 2019.
[10] S. Chong, “Success in Electronic Commerce Implementation: A Cross Country Study of small and Medium-Sized Enterprises,†Journal of Enterprise Information Management, vol. 21, no. 5, pp. 468–492, 2008.
[11] J. Bao and X. Sun, “A Conceptual Model of Factors Affecting e-Commerce Adoption by SMEs in China,†in 2010 Fourth International Conference on Management of e-Commerce and e-Government (ICMeCG), Oct. 2010, pp. 172–175.
[12] J. Wiegers, Karl; Beatty, Software Requirements, Third. Microsoft Press, 2013.
[13] D. Siahaan, Requirements Analysis in Software Engineering. Yogyakarta: Andi Offset, 2012.
[14] V. S. Moertini, S. Heriyanto, and C. D. Nugroho, “Requirement Analysis Method of E-commerce Websites Development for Small - Medium Enterprises , Case Study : Indonesia,†International Journal of Software Engineering & Applications (IJSEA), vol. 5, no. 2, pp. 11–28, 2014.
[15] E. Triandini, F. A. Hermawati, and I. K. P. Suniantara, “Hierarchical Clustering For Functionalitites E-commerce Adoption,†Kursor, vol. 10, no. 3, pp. 111–118, 2020.
[16] S.-C. Chu, L. Leung, Y. Hui, and W. Cheung, “Evolution of e-commerce Web sites: A conceptual framework and a longitudinal study,†Information & Management, vol. 44, pp. 154–164, 2007.
[17] L. Chen and Q. Su, “Discovering user’s interest at E-commerce site using clickstream data,†2013 10th International Conference on Service Systems and Service Management - Proceedings of ICSSSM 2013, pp. 124–129, 2013.
[18] Y. Chen and S. Yao, “Sequential Search with Reï¬nement Model and Application with Click-Stream Data.pdf,†Management Science, Articles in Advance, pp. 1–22, 2016.
[19] A. Watt and N. Eng, Database Design - 2nd Edition. Victoria: B.C.: BCcampus, 2014.
[20] G. Wang, X. Zhang, S. Tang, H. Zheng, and B. Y. Zhao, “Unsupervised clickstream clustering for user behavior analysis,†Conference on Human Factors in Computing Systems - Proceedings, pp. 225–236, 2016.
[21] R. Hanamanthrao and S. Thejaswini, “Real-time clickstream data analytics and visualization,†RTEICT 2017 - 2nd IEEE International Conference on Recent Trends in Electronics, Information and Communication Technology, Proceedings, vol. 2018-Janua, pp. 2139–2144, 2017.
[22] M. Scholz, “R package clickstream: Analyzing clickstream data with Markov chains,†Journal of Statistical Software, vol. 74, no. 4, 2016.
[23] C. Lakshminarayan, R. Kosuru, and M. Hsu, “Modeling Complex Clickstream Data by Stochastic Models,†pp. 879–884, 2016.
[24] D. Schellong, J. Kemper, and M. Brettel, “Generating consumer insights from big data clickstream information and the link with transaction-related shopping behavior,†Proceedings of the 25th European Conference on Information Systems, ECIS 2017, vol. 2017.
[25] T. J. Teorey and J. P. Fry, “The Logical Record Access Approach to Database Design,†ACM Comput. Surv., vol. 12, no. 4, 1980.
[26] S. M. Arif, H. Purwoko, T. Barat, and J. Selatan, “Perancangan Basis Data Oracle Standar Operasional Prosedur,†in Seminar Nasional Riset dan Teknologi (SEMNAS RISTEK), 2020, pp. 43–46.
[27] Nofiyani, “Model Basis Data Untuk Mendukung Sistem Administrasi Pelayanan dan Perbaikan Motor,†in Simposium Nasional Ilmiah, 2019, no. November, pp. 367–375.
[28] F. S. Handayani and M. P. Putri, “Desain Database Dan Hypertext Untuk Website Penelusuran Minat Peserta Didik Sebagai Layanan Bimbingan Konseling,†in Seminar Nasional Sains dan Teknologi (SNST) ke-8, 2017, vol. 2, no. 2014, pp. 13–18.
[29] W. S. Prasetya, “Perancangan Model Basis Data Relasional Dengan Metode Database Life Cycle,†in Seminar Nasional Informatika 2015, 2015, pp. 91–98.
[30] A. Watt and N. Eng, Database Design, 2nd ed. Victoria: B.C.: BCcampus, 2014.
[31] T. Huang and J. A. Van Mieghem, “Clickstream data and inventory management: Model and empirical analysis,†Production and Operations Management, vol. 23, no. 3, pp. 333–347, 2014.
[32] S. Bansal, C. Gupta, and A. Sinha, “Clickstream & behavioral analysis with context awareness for e-commercial applications,†2017 10th International Conference on Contemporary Computing, IC3 2017, vol. 2018-Janua, no. August, pp. 1–6, 2018.
[33] Y. S. Kim and B. J. Yum, “Recommender system based on click stream data using association rule mining,†Expert Systems with Applications, vol. 38, no. 10, pp. 13320–13327, 2011.
[2] E. Gide, “The Key Strategies for E-commerce Success Service SMEs in China", IEEE hal 229 -234,†in IEEE International Conference on Service Operations and Logistics, and Informatics, 2006, pp. 229–234.
[3] Y. Rianto, E. Aminullah, C. Laksani, D. Prihadyanti, B. Triyono, and L. . Handoko, Peta dan Strategi Adopsi teknologi Informasi di UKM Manufaktur. Jakarta: LIPI Press, 2007.
[4] L.-M. Chang, S.-I. Chang, C.-T. Ho, D. Yen, and M.-C. Chiang, “Effects of IS Characteristics on The E-Business Success Factors for Small-and Medium-Sized Enterprises,†Computers in Human Behavior, vol. 27, pp. 2129–2140, 2011.
[5] E. Turban, Introduction to Electronic Commerce, 2nd ed. New Jersey: Pearson Prentice Hall, 2009.
[6] E. Triandini, A. Djunaidy, and D. Siahaan, “Determining E-commerce Adoption Level by SMEs in Indonesia Based on Customer-Oriented Benefits,†in Internatioal Conference on Information Technology, Computer and Electrical Engineering (ICITACEE2014), Nov. 2014, pp. 281–285.
[7] F. Wahid and L. Iswari, “Information Technology Adoption by Small and Medium Enterprises in Indonesia,†in The National Seminar on Information Technology Application, 2007, pp. 75–79.
[8] E. Triandini, A. Djunaidy, and D. Siahaan, “Development of a conceptual model of E-commerce adoption for SMEs in Indonesia,†in 2013 International Conference on Information Technology and Electrical Engineering (ICITEE), 2013, pp. 93–96.
[9] G. D. Gregory, L. V. Ngo, and M. Karavdic, “Developing e-commerce marketing capabilities and efficiencies for enhanced performance in business-to-business export ventures,†Industrial Marketing Management, vol. 78, pp. 146–157, 2019.
[10] S. Chong, “Success in Electronic Commerce Implementation: A Cross Country Study of small and Medium-Sized Enterprises,†Journal of Enterprise Information Management, vol. 21, no. 5, pp. 468–492, 2008.
[11] J. Bao and X. Sun, “A Conceptual Model of Factors Affecting e-Commerce Adoption by SMEs in China,†in 2010 Fourth International Conference on Management of e-Commerce and e-Government (ICMeCG), Oct. 2010, pp. 172–175.
[12] J. Wiegers, Karl; Beatty, Software Requirements, Third. Microsoft Press, 2013.
[13] D. Siahaan, Requirements Analysis in Software Engineering. Yogyakarta: Andi Offset, 2012.
[14] V. S. Moertini, S. Heriyanto, and C. D. Nugroho, “Requirement Analysis Method of E-commerce Websites Development for Small - Medium Enterprises , Case Study : Indonesia,†International Journal of Software Engineering & Applications (IJSEA), vol. 5, no. 2, pp. 11–28, 2014.
[15] E. Triandini, F. A. Hermawati, and I. K. P. Suniantara, “Hierarchical Clustering For Functionalitites E-commerce Adoption,†Kursor, vol. 10, no. 3, pp. 111–118, 2020.
[16] S.-C. Chu, L. Leung, Y. Hui, and W. Cheung, “Evolution of e-commerce Web sites: A conceptual framework and a longitudinal study,†Information & Management, vol. 44, pp. 154–164, 2007.
[17] L. Chen and Q. Su, “Discovering user’s interest at E-commerce site using clickstream data,†2013 10th International Conference on Service Systems and Service Management - Proceedings of ICSSSM 2013, pp. 124–129, 2013.
[18] Y. Chen and S. Yao, “Sequential Search with Reï¬nement Model and Application with Click-Stream Data.pdf,†Management Science, Articles in Advance, pp. 1–22, 2016.
[19] A. Watt and N. Eng, Database Design - 2nd Edition. Victoria: B.C.: BCcampus, 2014.
[20] G. Wang, X. Zhang, S. Tang, H. Zheng, and B. Y. Zhao, “Unsupervised clickstream clustering for user behavior analysis,†Conference on Human Factors in Computing Systems - Proceedings, pp. 225–236, 2016.
[21] R. Hanamanthrao and S. Thejaswini, “Real-time clickstream data analytics and visualization,†RTEICT 2017 - 2nd IEEE International Conference on Recent Trends in Electronics, Information and Communication Technology, Proceedings, vol. 2018-Janua, pp. 2139–2144, 2017.
[22] M. Scholz, “R package clickstream: Analyzing clickstream data with Markov chains,†Journal of Statistical Software, vol. 74, no. 4, 2016.
[23] C. Lakshminarayan, R. Kosuru, and M. Hsu, “Modeling Complex Clickstream Data by Stochastic Models,†pp. 879–884, 2016.
[24] D. Schellong, J. Kemper, and M. Brettel, “Generating consumer insights from big data clickstream information and the link with transaction-related shopping behavior,†Proceedings of the 25th European Conference on Information Systems, ECIS 2017, vol. 2017.
[25] T. J. Teorey and J. P. Fry, “The Logical Record Access Approach to Database Design,†ACM Comput. Surv., vol. 12, no. 4, 1980.
[26] S. M. Arif, H. Purwoko, T. Barat, and J. Selatan, “Perancangan Basis Data Oracle Standar Operasional Prosedur,†in Seminar Nasional Riset dan Teknologi (SEMNAS RISTEK), 2020, pp. 43–46.
[27] Nofiyani, “Model Basis Data Untuk Mendukung Sistem Administrasi Pelayanan dan Perbaikan Motor,†in Simposium Nasional Ilmiah, 2019, no. November, pp. 367–375.
[28] F. S. Handayani and M. P. Putri, “Desain Database Dan Hypertext Untuk Website Penelusuran Minat Peserta Didik Sebagai Layanan Bimbingan Konseling,†in Seminar Nasional Sains dan Teknologi (SNST) ke-8, 2017, vol. 2, no. 2014, pp. 13–18.
[29] W. S. Prasetya, “Perancangan Model Basis Data Relasional Dengan Metode Database Life Cycle,†in Seminar Nasional Informatika 2015, 2015, pp. 91–98.
[30] A. Watt and N. Eng, Database Design, 2nd ed. Victoria: B.C.: BCcampus, 2014.
[31] T. Huang and J. A. Van Mieghem, “Clickstream data and inventory management: Model and empirical analysis,†Production and Operations Management, vol. 23, no. 3, pp. 333–347, 2014.
[32] S. Bansal, C. Gupta, and A. Sinha, “Clickstream & behavioral analysis with context awareness for e-commercial applications,†2017 10th International Conference on Contemporary Computing, IC3 2017, vol. 2018-Janua, no. August, pp. 1–6, 2018.
[33] Y. S. Kim and B. J. Yum, “Recommender system based on click stream data using association rule mining,†Expert Systems with Applications, vol. 38, no. 10, pp. 13320–13327, 2011.
Downloads
Published
2021-11-26
Issue
Section
Articles
How to Cite
[1]
E. Triandini, I. G. Suardika, and I. K. Putu Suniantara, “Database Click Stream of E-commerce Functional”, MATRIK, vol. 21, no. 1, pp. 75–86, Nov. 2021, doi: 10.30812/matrik.v21i1.1446.
Similar Articles
- Achmad Lukman, Wahju Tjahjo Saputro, Erni Seniwati, Improving Performance Convolutional Neural Networks Using Modified Pooling Function , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 23 No. 2 (2024)
- Lalu Zazuli Azhar Mardedi, Ariyanto Ariyanto, Analisa Kinerja System Gluster FS pada Proxmox VE untuk Menyediakan High Availability , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Amir Ali, Klasterisasi Data Rekam Medis Pasien Menggunakan Metode K-Means Clustering di Rumah Sakit Anwar Medika Balong Bendo Sidoarjo , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Christofer Satria, Peter Wijaya Sugijanto, Anthony Anggrawan, I Nyoman Yoga Sumadewa, Aprilia Dwi Dayani, Rini Anggriani, Multi-Algorithm Approach to Enhancing Social Assistance Efficiency Through Accurate Poverty Classification , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 1 (2024)
- Ardi Mardiana, Ade Bastian, Ano Tarsono, Dony Susandi, Safari Yonasi, Optimized YOLOv8 Model for Accurate Detection and Quantificationof Mango Flowers , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 3 (2025)
- Darmansah Darmansah, Zulya Suhendro, Sistem Informasi Sekolah Pada Sekolah Dasar Negeri 21 Sungai Geringging Kabupaten Padang Pariaman Berbasis Web , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 2 (2020)
- Muhammad Zaki Wiryawan, Didik Dwi Prasetya, Anik Nur Handayani, Tsukasa Hirashima, Wahyu Styo Pratama, Lalu Ganda Rady Putra, Enhancing Semantic Similarity in Concept Maps Using LargeLanguage Models , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 3 (2025)
- Melati Rosanensi, Improving E-Commerce Effectiveness Using Augmented Reality , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 2 (2020)
- Reo Wicaksono, Didik Dwi Prasetya, Ilham Ari Elbaith Zaeni, Nadindra Dwi Ariyanta, Tsukasa Hirashima, Machine Learning for Open-ended Concept Map Proposition Assessment: Impact of Length on Accuracy , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 25 No. 1 (2025)
- Christopel H. Simanjuntak, Musfiah Musfiah, Muhammad Bahit, Cristovani W. Lohonauman, Stenly B. Dodie, Khamla Nonalinsavath, Middleware Development for Heterogeneous Databases on Multi-Architecture Systems Small Medium Enterprise , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 25 No. 1 (2025)
You may also start an advanced similarity search for this article.
Most read articles by the same author(s)
- Djoko Kuswanto, Athirah Hersyadea Alifah Putri, Ellya Zulaikha, Tedy Apriawan, Yuri Pamungkas, Evi Triandini, Nadya Paramitha Jafari, Thassaporn Chusak, Cranioplasty Training Innovation Using Design Thinking: AugmentedReality and Interchangeability-Based Mannequin Prototype , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 3 (2025)
- Sela Octaviani, Evi Triandini, Dandy Pramana Hostiadi, Evaluating Lecturer Satisfaction on Academic Information System Using Usability and EUCS at Bandung University of Technology , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 25 No. 1 (2025)
.png)
