International Journal of Internet, Broadcasting and Communication

The Institute of Internet, Broadcasting and Communication (한국인터넷방송통신학회)
권호 표지
DOI QR코드

DOI QR Code

Modeling and Implementation of Public Open Data in NoSQL Database

  • Min, Meekyung (Dept. of Computer Science, Seokyeong University)
  • Received : 2018.06.05
  • Accepted : 2018.06.17
  • Published : 2018.08.31
Download PDF
⟨ Previous Next ⟩

Abstract

In order to utilize various data provided by Korea public open data portal, data should be systematically managed using a database. Since the range of open data is enormous, and the amount of data continues to increase, it is preferable to use a database capable of processing big data in order to analyze and utilize the data. This paper proposes data modeling and implementation method suitable for public data. The target data is subway related data provided by the public open data portal. Schema of the public data related to Seoul metro stations are analyzed and problems of the schema are presented. To solve these problems, this paper proposes a method to normalize and structure the subway data and model it in NoSQL database. In addition, the implementation result is shown by using MongDB which is a document-based database capable of processing big data.

Keywords

References

  1. P. Atzeni, F. Bugiotti, L. Cabibbo, and R. Torlone, "Data modeling in the NoSQL world," Computer Standards & Interfaces, Elsevier, 2016. DOI: https://doi.org/10.1016/j.csi.2016.10.003.
  2. D. Chandra, "BASE Analysis of NoSQL database," Future Generation Computer Systems, Vol. 52, pp. 13-21, Nov. 2015. DOI: https://doi.org/10.101/j.future.2015.05.003.
  3. J. Chang, "An Experimental Evaluation of Box Office Revenue Prediction through Social Bigdata Analysis and Machine Learning," The Journal of The Institute of Internet, Broadcasting and Communication(JIIBC), Vol. 17, No. 3, pp. 167-173, June 2017. DOI: https://doi.org/10.7236/JIIBC.2017.17.3.167.
  4. S. Kim, "A Study on Construction of Crime Prevention System Using Big Data in Korea," The Journal of The Institute of Internet, Broadcasting and Communication(JIIBC), Vol. 17, No. 5, pp. 217-221, Oct. 2017. DOI: https://doi.org/10.7236/JIIBC.2017.17.5.217.
  5. M. Min, "Experiments of Search Query Performance for SQL-Based Open Source Databases," International Journal of Internet, Broadcasting and Communication(IJIBC), Vol. 10, No. 2, pp. 31-38, May 2018. DOI: https://dx.doi.org//10.7236/IJIBC.2018.10.2.6.
  6. P. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison-Wesley Professional, 2012.
  7. Jing Han, Haihong E, Guan Le, and Jian Du, "Survey on NoSQL Database," in Proc. 6th International Conference on Pervasive Computing and Applications, pp. 363-355, Oct.26-28, 2011.
  8. A. Schram and K. Anderson, "MySQL to NoSQL: Data Modeling Challenges in Supporting Scalability," in Proc. 3rd Annual Conference on Systems, Programming, and Applications: Software for Humanity, pp. 191-202, Oct.19-26, 2012. DOI: https://doi.org/10.1145/2384716.2384773.
  9. MongDB. https://www.mongodb.com.
  10. Korea Open Data Portal. https://data.go.kr.