Database Click Stream of E-commerce Functional

  • Evi Triandini
  • I Gede Suardika Institut Teknologi dan Bisnis STIKOM Bali
  • I Ketut Putu Suniantara Institut Teknologi dan Bisnis STIKOM Bali
Keywords: E-commerce functional, Click stream, Database life cycle


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.


Download data is not yet available.


[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.
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.