DOI QR코드

DOI QR Code

Modeling with Design Patterns in MongoDB for Public Transportation Data

  • 투고 : 2024.10.25
  • 심사 : 2024.11.06
  • 발행 : 2024.11.30

초록

MongoDB, a document-based database, is suitable for distributed management environments of large-scale databases due to its high scalability, performance, and flexibility. Recently, as MongoDB has been widely used as a new database, many studies have been conducted including data modeling for MongoDB and studies on applying MongoDB to various applications. In this paper, we propose a data modeling method for implementing Seoul public transportation data with MongoDB. Seoul public transportation data is public data provided by the Korea Public Data Portal. In this study, we analyze the target data and find design patterns such as polymorphic pattern, subset pattern, computed pattern, and extended reference pattern in the data. Then, we present data modeling with these patterns. We also show examples of implementation of Seoul public transportation database in MongoDB. The proposed modeling method can improve database performance by leveraging the flexibility and scalability that are characteristics of MongoDB.

키워드

참고문헌

  1. E. Plugge, D. Hows, P. Membrey, and T. Hawkins, The Definitive Guide to MongoDB: A complete guide to dealing with Big Data using MongoDB, Apress, 2015.
  2. A. Erraji, A. Maizate, and M. Ouzzif, "An Integral Approach for Complete Migration from a Relational Database to MongoDB," Journal of the Nigerian Society of Physical Sciences, Vol. 5, pp. 1089. DOI: https://doi.org/10.46481/jnsps.2023.1089
  3. L. Rocha, F. Vale, E. Cirilo, D. Barbosa, and F. Mourao, "A framework for migrating relational datasets to NoSQL," Procedia Computer Science, Vol. 51, pp. 2593-2602, 2015. DOI: https://doi.org/10.1016/j.procs.2015.05.367
  4. C. Gyorodi, R. Gyorodi, G. Pecherle, and A. Olah, "A comparative study: MongoDB vs. MySQL," 13th international conference on engineering of modern electric systems (EMES) IEEE, pp. 1-6, June 2015. DOI: https://doi.org/10.1109/EMES.2015.7158433
  5. O. Alotaibi and E. Pardede, "Transformation of schema from relational database (RDB) to NoSQL databases," Data, Vol. 4, No. 4, pp. 148, 2019. DOI: https://doi.org/10.3390/data4040148
  6. P. Atzeni, F. Bugiotti, L. Cabibbo, and R. Torlone, "Data modeling in the NoSQL world," Computer Standards & Interfaces, Vol. 67, 2020. DOI: https://doi.org/10.1016/j.csi.2016.10.003
  7. D. Coupal and K. W. Alger, "Building with Patterns: A Summary," https://www.mongodb.com/blog/post/building-with-patterns-a-summary, April 2019, Updated: Sep 2024.
  8. Korea Public Data Portal. https://data.go.kr
  9. M. Min, "A Data Design for Increasing the Usability of Subway Public Data," International Journal of Internet, Broadcasting and Communication (IJIBC), Vol. 11, No. 4, pp. 18-25, 2019. DOI: http://dx.doi.org/10.7236/IJIBC.2019.11.4.18