• Journal of KIISE:Databases
• /
• v.32 no.1
• /
• pp.71-85
• /
• 2005

Various researches on moving object modeling, uncertainty processing, and moving object indexing have been tarried out in the field of moving object databases. However. previous location tracking systems cannot efficiently retrieve location data of vehicles, because they manage all location information of vehicles using the conventional database. In this paper, we design the vehicle location management systen that is able to manage and retrieve vehicle locations efficiently in mobile environment. The proposed system consists of a server for managing vehicle locations and mobile clients. The system is able to not only process spatiotemporal queries related to locations of moving vehicles but also Provide moving vehicles' locations which are not stored in the system. The system is also able to manage vehicle location data effectively using a moving object index.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.23 no.6
• /
• pp.645-651
• /
• 2019

At a time when large amounts of data are being poured out, there are many changes in software architecture or data storage patterns because of the nature of the data being written, rather more read-intensive than writing. Accordingly, in this paper, the query model of Command Query Responsibility Segmentation (CQRS) pattern separating the responsibilities of commands and queries is used to implement an efficient high-capacity data lookup system in users' requirements. This paper uses the 2018 temperature, humidity and precipitation data of the Korea Meteorological Administration Open API to store about 2.3 billion data suitable for RDBMS (PostgreSQL) and NoSQL (MongoDB). It also compares and analyzes the performance of systems with CQRS pattern applied from the perspective of the web server (Web Server) implemented and systems without CQRS pattern, the storage structure performance of each database, and the performance corresponding to the data processing characteristics.

• Safety and Health at Work
• /
• v.10 no.3
• /
• pp.265-274
• /
• 2019

Background: Methyl alcohol poisoning in mobile phone-manufacturing factories during 2015-2016 was caused by methyl alcohol use for cleaning in computerized numerical control (CNC) processes. To determine whether there were health complications in other workers involved in similar processes, the Occupational Safety and Health Research Institute conducted a survey. Methods: We established a national active surveillance system by collaborating with the Ministry of Employment and Labor and National Health Insurance Service. Employment and national health insurance data were used. Overall, 12,048 employees of major domestic mobile phone companies and CNC process dispatch workers were surveyed from 2016 to 2017. We investigated methyl alcohol poisoning by using the national health insurance data. Questionnaires were used to investigate diseases due to methyl alcohol poisoning. Results: Overall, 24.9% of dispatched workers were employed in at least five companies, and 23.9% of dispatched workers had missing employment insurance history data. The prevalence of blindness including visual impairment, optic neuritis, visual disturbances, and alcohol toxicity in the study participants was higher than that reported in the national health insurance database (0.02%, 0.07%, 0.23%, and 0.03% versus 0.01%, 0.07%, 0.13%, and 0.01%, respectively, in 2015). Moreover, 430 suspicious workers were identified; 415 of these provided an address and phone number, of whom 48 responded (response rate, 11.6%). Among the 48 workers, 10 had diseases at the time of the survey, of whom 3 workers were believed to have diseases related to methyl alcohol exposure. Conclusion: This study revealed that active surveillance data can be used to assess health problems related to methyl alcohol poisoning in CNC processes and dispatch workers.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.25 no.6
• /
• pp.766-773
• /
• 2021

This paper presents an implementation result and performance evaluation of pavilion management services that does not only provide real-time status of the pavilion in the forest but also prediction services through machine learning. The developed hardware prototype detects whether the pavilion is occupied using a motion detection sensor and then sends it to a cloud database along with location information, date and time, temperature, and humidity data. The real-time usage status of the collected data is provided to the user's mobile application. The performance evaluation confirms that the average response time from the hardware module to the applications was 1.9 seconds. The accuracy was 99%. In addition, we implemented a pavilion availability prediction service that applied a machine learning-based SVM (Support Vector Model) model to collected data and provided it through mobile and web applications.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.26 no.5
• /
• pp.743-754
• /
• 2022

This paper contains the results of the development and performance evaluation of the environmental data monitoring system for the fish farm. For the hardware development, the analogue sensor is used to collect dissolved oxygen, pH, salinity, and temperature of the fish farm water, and the digital sensor is used for collecting ambient temperature, humidity, and location information via a GPS module to be sent to cloud-based Firebase DB. A set of LoRa transmitters and receivers is used as a communication module to upload the collected data. The data stored in Firebase is retrieved as a graph on a web and mobile application to monitor the environmental data changes in real-time. A notification will be delivered if the collected data is outside the determined optimal value. To evaluate the performance of the developed system, a response time from hardware modules to web and mobile applications is ranging from 6.2 to 6.85 seconds, which indicates satisfactory results.

• Journal of Internet Computing and Services
• /
• v.23 no.3
• /
• pp.87-95
• /
• 2022

Recently, with the development of smart technology, in medical information platform, patient's biometric data is measured in real time and accumulated into database, and it is possible to determine the patient's emergency situations. Medical staff can easily access patient information after simple authentication using a mobile terminal. However, in accessing medical information using the mobile terminal, it is necessary to study authentication in consideration of the patient situations and mobile terminal. In this paper, we studied on medical information platforms based on big data processing and edge computing for supporting automatic authentication in emergency situations. The automatic authentication system that we had studied is an authentication system that simultaneously performs user authentication and mobile terminal authentication in emergency situations, and grants upper-level access rights to certified medical staff and mobile terminal. Big data processing and analysis techniques were applied to the proposed platform in order to determine emergency situations in consideration of patient conditions such as high blood pressure and diabetes. To quickly determine the patient's emergency situations, edge computing was placed in front of the medical information server so that the edge computing determine patient's situations instead of the medical information server. The medical information server derived emergency situation decision values using the input patient's information and accumulated biometric data, and transmit them to the edge computing to determine patient-customized emergency situation. In conclusion, the proposed medical information platform considers the patient's conditions and determine quick emergency situations through big data processing and edge computing, and enables rapid authentication in emergency situations through automatic authentication, and protects patient's information by granting access rights according to the patient situations and the role of the medical staff.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2004.04a
• /
• pp.353-359
• /
• 2004

Underground facility DB that is constructed by NGIS project need efficient management methodology, because falling-off in quality was worried by confused of existing management affair and management affair of computerization environment. Through analysis of existing management affair, underground facility DB and management system decide that modification/renewal factor of underground facility DB and subject affair Through modification/renewal factor of underground facility DB, developed underground facility DB management methodology using MMS. Result that apply developed management methodology to subject affair, existing affair environment improved to computerization environment and Could improve underground facilities DB authoritativeness.

• Proceedings of the Korean Information Science Society Conference
• /
• 2004.10b
• /
• pp.73-75
• /
• 2004

최근에 무선 인터넷과 이동 컴퓨팅 기술이 발전하고, 휴대 전화, PDA와 같은 이동 단말기가 보편화됨에 따라 사용자의 위치 정보를 활용하는 위치 기반 서비스(LBS: Location Based Service)가 다양한 분야에서 제공되고 있다. 모바일 환경에서 위치 기반 서비스를 제공하기 위해서는 모바일 장치에서 대용량의 공간 데이타를 신속하게 처리하고 효과적으로 관리하기 위한 공간 MMDBMS(Main Memory Database Management System)가 필요하다. 이에 본 논문에서는 기존의 PC용 MMDBMS인 HSQLDB를 확장하여 모바일 장치에서 공간 데이타를 효율적으로 관리할 수 있는 공간 MMDBMS를 설계 및 구현하였다. 공간 MMDBMS는 OGC의 공간 데이타 모델을 따르며, 공간 데이타 특성에 적합한 압축 기법인 산술 코딩 기법을 제공하고, 모바일 장치에 적합한 MBR 압축 및 해슁 기법을 이용한 공간 인덱스를 지원한다. 그리고, 모바일 장치의 낮은 성능의 프로세서에서 공간 데이타 디스플레이 기능을 제공하고, 모바일 장치와 디스크 기반 GIS인 ZEUS 사이에서 공간 데이타 import/export의 성능 향상을 위한 데이타 캐쉬 기능을 지원한다.

• Journal of The Institute of Information and Telecommunication Facilities Engineering
• /
• v.11 no.1
• /
• pp.23-28
• /
• 2012

In this paper, we proposed and developed a fast and efficient real time face detection and recognition which can be run on embedded system instead of high performance desktop. In the face detection process, we detect a face by finding eye part which is one of the most salient facial features after applying various image processing methods, then in the face recognition, we finally recognize the face by comparing the current face with the prepared face database using a template matching algorithm. Also we optimized the algorithm in our system to be successfully used in the embedded system, and performed the face detection and recognition experiments on the embedded board to verify the performance. The developed method can be applied to automatic door, mobile computing environment and various robot.

• Journal of the Korean Society of Industry Convergence
• /
• v.14 no.4
• /
• pp.135-142
• /
• 2011

Convergence between telecom and broadcasting is today a worldwide phenomenon. Diverse services like VoD, mobile broadcasting, IPTV and interactive services have already made their market debut or are currently being commercialized. Regulatory systems are also being revised to appropriately regulate this new breed of services. We propose the new model of educational broadcasting system using the internet network, it is not different conventional coaxial cable methods. Especially, we design the multicast method of the network using the limited channel and resource, propose the method of intercommunication in the school between the broadcasting system and database system.