Database Click Stream of E-commerce Functional
Keywords:
E-commerce functional, Click stream, Database life cycle
Abstract
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 Refinement 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 Refinement 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.
Published
2021-11-26
How to Cite
Triandini, E., Suardika, I. G., & Putu Suniantara, I. K. (2021). Database Click Stream of E-commerce Functional. MATRIK : Jurnal Manajemen, Teknik Informatika Dan Rekayasa Komputer, 21(1), 75-86. https://doi.org/https://doi.org/10.30812/matrik.v21i1.1446
Issue
Section
Articles
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
.png)
