• International Journal of Internet, Broadcasting and Communication
• /
• v.10 no.3
• /
• pp.51-58
• /
• 2018

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.

• Journal of Korean Society of Archives and Records Management
• /
• v.13 no.2
• /
• pp.149-178
• /
• 2013

Recently many countries have established data platforms to disclose government-owned data that include administrative data-sets and provide free access to the public via Web. This research analyzes the "Socrata" and "CKAN", the most popular representative open data platforms in the world, and reviews functions and their practical cases in operation in several cities of various nations. It also examines the current status of the data-set services in the City of Seoul to provide conceptual bases for management and service of the local governments' data-sets using open data platform. Then it suggests measures that ensure the long-term preservation and management of data-sets as archives for services, which includes the aspects of preparing systems, creating and managing data, providing services, and selecting platforms.

• Knowledge Management Research
• /
• v.20 no.3
• /
• pp.73-89
• /
• 2019

The purpose of this study is to investigate the current state of public Big Data in Seoul and suggest policy directions for the revitalization of Seoul's public Big Data. Big Data is perceived as innovation resources under the era of 4th Industrial revolution and Data economy. Especially, public Big Data serves a significant role in terms of universal access for citizens, startup, and enterprise compared with the private sector. Seoul reorganized a substructure of government's focus on Big Data and established organizations such as Big Data Campus and Urban Data Science Lab. Although the number of public open Data has increased in Seoul, there exists not much Data with characteristics similar to Big Data, such as volume, velocity, and value. In order to present the direction of Big Data policy in Seoul, we investigate the current status of Big Data Campus and Urban Data Science Lab operated by Seoul City. Considering the results of this study, we have proposed several directions that Seoul can use in establishing big data related strategies.

• International Journal of Internet, Broadcasting and Communication
• /
• v.11 no.4
• /
• pp.18-25
• /
• 2019

The public data portal provides various public data created by the government in the form of files and open APIs. In order to increase the usability of public open data, a variety of information should be provided to users and should be convenient to use for users. This requires the structured data design plan of the public data. In this paper, we propose a data design method to improve the usability of the Seoul subway public data. For the study, we first identify some properties of the current subway public data and then classify the data based on these properties. The properties used as classification criteria are stored properties, derived properties, static properties, and dynamic properties. We also analyze the limitations of current data for each property. Based on this analysis, we classify currently used subway public data into code entities, base entities, and history entities and present the improved design of entities according to this classification. In addition, we propose data retrieval functions to increase the utilization of the data. If the data is designed according to the proposed design of this paper, it will be possible to solve the problem of duplication and inconsistency of the data currently used and to implement more structural data. As a result, it can provide more functions for users, which is the basis for increasing usability of subway public data.

• The Journal of the Korean dental association
• /
• v.54 no.8
• /
• pp.613-629
• /
• 2016

This study assayed regional distribution of dental hospital & dental clinics, the number of population & households per one dental hospital & clinic, operation condition & duration. This study used public data that display from 1946 years(the first dental clinic open in republic of korea) to 2016 years. We collected present condition of 21,686 dental hospital and clinics available in public data portal site on 28. Feb.2016. Data were classified by scale, location, permission year, operation duration of dental hospital & clinics and were analyzed using SPSS 20.0 program. Surveyed on Feb. 2016. Best top 10 regions of permission dental clinics are (1) Gangnam-gu, Seoul(1,337), (2) Seongnamsi, Gyeonggi-do(555), (3) Songpa-gu, Seoul(491), (4) Yeongdeungpo-gu, Seoul(472), (5) Suwon-si, Gyeonggi-do(443), (6) Seocho-gu, Seoul(428), (7) Nowon-gu, Seoul(417), (8) Goyang-si, Gyeonggi-do(413), (9) Jung-gu, Seoul(380), (10) Yongin-si, Gyeonggi-do(353). Whereas best top 10 regions of operating dental clinics are (1) Gangnam-gu, Seoul(581), (2) Seongnamsi, Gyeonggi-do(415), (3) Suwon-si, Gyeonggi-do(382), (4) Seocho-gu, Seoul(320), (5) Changwon-si, Gyeongsangnam-do(303), (6) Songpa-gu, Seoul(295) (7) Goyang-si, Gyeonggi-do(290), (8) Bucheon-si and Yongin-si, Gyeonggi-do(262), (9) Jeonju-si, Jeollabuk-do(224). Average population per one dental hospital & clinic by regional local government are 3,120 people. Best five region of population per one dental hospital & clinic are (1) Sejong-si(5,272), (2) Gangwon-do(4,653), (3) Chungcheongbuk-do(4,513), (4) Gyeongsangbuk-do(4,490), (5) Chungcheongnam-do(4,402). Average households per one dental hospital & clinic by regional local government are 1,316 households. Best three region of households per one dental hospital & clinic are (1) Sejong-si(2,126), (2) Gangwon-do(2,057), (3) Gyeongsangbuk-do(1,946). From 1946 to 1986, permission and operating dental hospital and clinics was steadily increasing. On 1986-1990, 1991-1995, permission, operation and closure of dental hospital and clinics increase rapidly. From the 2011-2015 to 2016(present), permission, operation and closure of dental hospital and clinics is decreasing. Average operating duration of closured dental hospital and clinics are 14.054 years. We need to map of dental hospital and clinics for open and operation of one, base on analyzed results. In an era of 30,000 dentist, we should to be concerned about operation of dental clinics in the light of past operating condition.

• Journal of Fashion Business
• /
• v.21 no.1
• /
• pp.124-133
• /
• 2017

This study analyzed consumers' online fashion shopping site usage by site type and analyzed how product information search and product purchase differ. In addition, by comparing and analyzing preference and selection factors of PC and mobile shopping, we tried to provide basic data of effective mobile commerce operation strategy according to expansion of mobile market in fashion industry. We surveyed the use of 6 types of online sites (portal site, open market, general shopping mall, social commerce shopping mall, brand shopping mall and non-brand shopping mall) to understand the usage of mobile shopping site for consumers' fashion products. Consumer survey subjects were 373 college students in their early 20s who had the most mobile shopping experiences. The questionnaire consisted of online fashion site usage items, internet and mobile fashion shopping preference (6 items), internet and mobile shopping choice behavior (10 items), and purchase intention (3 items) .Data were analyzed using SPSS 14.0 program. The high preference of portal sites, open market, social commerce, and non-brand shopping malls in shopping online fashion products is a result of the perceptual changes of major distribution channels and the trends of consumers' value consumption tendency. Therefore, it is necessary for fashion companies to actively cope with fashion product distribution competition with huge shopping sites of current online market by well understanding consumers' preference trends and factors of online sites.

• Healthcare Informatics Research
• /
• v.24 no.4
• /
• pp.253-262
• /
• 2018

Objectives: We reviewed digital epidemiological studies to characterize how researchers are using digital data by topic domain, study purpose, data source, and analytic method. Methods: We reviewed research articles published within the last decade that used digital data to answer epidemiological research questions. Data were abstracted from these articles using a data collection tool that we developed. Finally, we summarized the characteristics of the digital epidemiological studies. Results: We identified six main topic domains: infectious diseases (58.7%), non-communicable diseases (29.4%), mental health and substance use (8.3%), general population behavior (4.6%), environmental, dietary, and lifestyle (4.6%), and vital status (0.9%). We identified four categories for the study purpose: description (22.9%), exploration (34.9%), explanation (27.5%), and prediction and control (14.7%). We identified eight categories for the data sources: web search query (52.3%), social media posts (31.2%), web portal posts (11.9%), webpage access logs (7.3%), images (7.3%), mobile phone network data (1.8%), global positioning system data (1.8%), and others (2.8%). Of these, 50.5% used correlation analyses, 41.3% regression analyses, 25.6% machine learning, and 19.3% descriptive analyses. Conclusions: Digital data collected for non-epidemiological purposes are being used to study health phenomena in a variety of topic domains. Digital epidemiology requires access to large datasets and advanced analytics. Ensuring open access is clearly at odds with the desire to have as little personal data as possible in these large datasets to protect privacy. Establishment of data cooperatives with restricted access may be a solution to this dilemma.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.18 no.3
• /
• pp.78-84
• /
• 2017

Because the 'Internet of Things' and sensor network technology have become a new generation industry competitiveness with a development of Information Communication Technology, each local autonomous entity is trying to adopt a Smart City quickly. This requires an integrated platform inside of a smart city operation center. Established Smart City platform provides various services using CCTV information and ITS transportation information based on a two-dimensional map. The provision of advanced Smart City services will necessitate three-dimensional map information, building and facilities unit information, linked information with public data portal for service to the public. In this paper, the authors reviewed development trends of Smart City integrated platform and proposed mashup methods between BIM/GIS interoperability platform and external open data. BIM/GIS platform can provide spatial information services for indoor and outdoor seamlessly because it was developed based on GIS spatial data with BIM data. The linked external open data are V-World data, Seoul Open Data, and Architectural Data Open. Finally, the authors proposed the direction of development for BIM/GIS integrated platform to provide advanced Smart City services.

• Korean Security Journal
• /
• no.60
• /
• pp.91-111
• /
• 2019

Violent crimes have increased continuously due to the development of urban society and have become a threatening factor against the residential safety of citizens. The prevention of these crimes is always a major topic in human society and one of the fundamental elements of the quality of life and safety of citizens. In recent years, much attention has been paid to environmental design through the Crime Prevention Through Environmental Design (CPTED) as a preventive measure. Currently, South Korea is promoting the openness and utilization of public data, and crime prevention is one of the fields that can utilize public data actively. This approach to crime prevention utilizing public data will be helpful for the proposal of policies from new viewpoints departing from the general utilization measures of CPTED that improve streetlights and closed-circuit television (CCTV) installations, whose limitations have been pointed out as they are only mechanical surveillance. Thus, this study sets the research scope based on the statistics of the status of five criminal offenses by administrative district in recent years provided by the data portal in Seoul City, the capital of South Korea, as the utilization data and concentrates on the analysis. Based on the analysis results, this study proposes a method to utilize classical music as a new policy for regions where the improvements are most needed. The open-source Python analysis program was employed as the main data analysis and visualization method.

• The Journal of the Korean dental association
• /
• v.56 no.12
• /
• pp.658-666
• /
• 2018

This study analyzes 21,686 dental clinic business names from 1946 to February 2016, where official records exist. The results of this study will be used as a historical data of Korean dental clinic and contribute to the decision of dental clinic name. According to the results of analysis, the first official dental clinic used in Korea was 'Chu' in 1946, 'Minsaeng' and 'Chusaeng' in 1958, and "Won" in 1959. In the 1960s, dentists' family names were often used as dental clinics. In the 1970s, dental clinic names were often used as dentists' family name, 'Jung-ang' and 'Seongsin'. In the 1980s, dental clinic name was used more than other names such as 'Seoul', 'Yonsei', 'Hyundai' and 'Sang-a' along with the dentist's family name. In the 1990s, a dental clinic name was used to refer to the words 'Yeonsei', 'Seoul', 'Hyundai', 'Sang-a', 'Isalang', 'Uli', 'Jeil', 'Bubu' used a lot. In the 2000s, Dental Clinic's name began to use english words such as $^{\circ}{\AE}Good$ Morning','White','Prime 'and adjectives such as 'Haengboghan', 'Ipyeonhan'. The characteristic of the dental clinic name in 2010 is the increase of the business name 'UD'. From 1946 to February 2016, the most commonly used dental clinic name was 'Seoul', 'Uri', 'Isarang', 'Yonsei', 'Hyundai', 'Good Morning' 'Jung-ang', 'UD', 'I', 'Miso'.