• Journal of the Society of Cosmetic Scientists of Korea
• /
• v.29 no.2 s.43
• /
• pp.233-250
• /
• 2003

We often use the KCID(Korean Cosmetic Ingredient Dictionary) and ICID(International Cosmetic Ingredient Dictionary) within cosmetics research and within their export and import. so far, we do not have a database of a cosmetics' raw materials. Because of this, we consume a lot of time to find the raw material data that is needed. This study constructs a cosmetics' raw material database and develops the program to retrieve it. We used a Linux machine as the equipment for this study and we used Apache web server, MySQL database server and PHP as the tools of this study. 11,817 kinds of raw materials data were registered as ICID, 866 kinds of raw materials data were registered as KCID and 28,008 kinds of raw materials data with registered trade name into the database. Also, The database was composed of the database of the association form. The database of the online form could ultimately reduce the task time as soon as it did its purpose. The product of this study can become a good basis of data to reconfigure. In the future, it can become a good database in relation with different databases.

• Annual Conference of KIPS
• /
• 2020.11a
• /
• pp.694-697
• /
• 2020

본 논문은 언리얼 엔진에서 제공하는 Dedicated server를 사용하지 않고 자체적으로 제작한 IOCP모델 서버를 구축하고, 이를 언리얼 클라이언트와 MySQL데이터베이스에 연동하여, 완성된 서버의 성능 테스트를 진행한 결과를 보였다.

• Annual Conference of KIPS
• /
• 2024.10a
• /
• pp.492-493
• /
• 2024

빅데이터 시대가 오면서 정형화된 데이터뿐만 아니라 비정형 데이터들도 즐비하게 되었다. 데이터의 많은 비율을 비정형 데이터가 차지하게 됨으로써 관계형 데이터베이스로는 여러 이유로 인해 한계에 봉착하게 되었고 NoSQL 계열의 데이터베이스를 채택하기 시작했다. 본 연구에서는 그래프 데이터베이스는 노드와 관계를 이용하여 데이터를 조회하고 분석한다. 관계형 DB 인 MySQL 과 그래프 DB 인 Neo4j 를 사용하여 CRUD 및 분석 성능을 비교한다.

• Journal of the Korea Society of Computer and Information
• /
• v.11 no.5 s.43
• /
• pp.183-193
• /
• 2006

This paper suggests a service model which uses a wireless sensor network in home network environment. The sensor network consists of fixed sensor nodes and user identification nodes which is attached to each user. With the input information of the user preference profile and the collected data from the sensor nodes, the database is constructed as a context information and analyzed by a home server to provide a service that establishes and controls automatically home appliances according to each user's preference. The proposed service model is implemented and tested on a Linux server with MySQL database and sensor nodes on TinyOS.

• Journal of Digital Convergence
• /
• v.10 no.8
• /
• pp.225-231
• /
• 2012

In this paper, we implement a wireless home monitoring system using physical computing platform with the open source type for house environment management. Sensors for temperature, optics and ultrasonic waves are used for home environment elements detection and control for the home safety. To obtain information related with home and transmit it to RIA Windows server system, XBee wireless communication system is used and the transmitted information is saved in mySQL database for history management. The possibility of prevention against fire disaster of a house situated in a dense buildings area and highly populated environments is suggested by adopting the proposed system.

• Proceedings of the Korean Society of Computer Information Conference
• /
• 2023.07a
• /
• pp.241-244
• /
• 2023

본 연구는 2010년 이후로 다시 활성화가 된 NFC 기술을 이용하여 출석 체크 APP을 개발하고, 아두이노와 MySQL을 통해 데이터베이스를 생성, Node.js를 이용하여 서버를 구축함으로써 출석 체크 과정에서 발생하는 불필요한 시간 사용을 최소화하고 근거리 통신을 통해 확실한 출석 체크를 실현하기 위한 연구이다. 출석 체크시스템에서의 효율성과 정확성은 중요한 요소로서, 이를 위해 NFC 기술을 활용하여 신속하고 정확한 출석 체크를 수행하며, 데이터의 신뢰성과 보안성을 강화한다. 연구를 통해 출석 체크 시스템이 발생하는 인력과 시간의 절약 효과를 확인하고, 효율적인 출석 체크 관리를 위한 혁신적인 해결책을 제시한다. 이러한 연구는 출석 체크 시스템의 개선과 혁신을 이끌며, 다양한 조직이나 교육기관에서 확장될 수 있을 것으로 기대한다.

• Journal of Korea Water Resources Association
• /
• v.39 no.10 s.171
• /
• pp.855-866
• /
• 2006

In this paper, the Hydrologic Data Management System (HDMS) was developed for the efficient management of hydrologic data. The applicability of the system was demonstrated using the hydrologic data of study watershed located in the southwest from Suwon city MySQL 5.0, relational database management system, and MS Visual Basic 6.0 were used for the development of MS windows based HDMS. The primary components of the HDMS are data search system, data management system, and data analysis system. Data search and management systems provide basic functions for the efficient data search, storage, update and export. Data analysis system enables the users to get the further and diverse hydrologic statistical information from the stored data. Furthermore, the accuracy and quality of hydrologic data was analyzed and evaluated through data analysis system.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.26 no.6
• /
• pp.872-880
• /
• 2022

This paper present a design and implementation of a Contents Management System (CMS) to be integrated into a game that uses a Digital Game-based Learning (DGBL) approach for helping tourists learn about tourism spots as a part of the Package Tour Application. In terms of design, this paper shows a system architecture that consists of a database to store the game's content such as tourism spot information, score and question configuration, score history, et cetera, a web application to manage the content and a Rest API to delivers the content to the mobile game. Meanwhile, in terms of implementation, MySQL database and PHP programming language are used. Moreover, a time response performance evaluation is conducted which resulted in between 0.77 s to 1.4 s from CMS to the database. Once successfully integrated with the game, the CMS will allow the game to be played on multiple tours simultaneously, without having to rebuild the game for every package tour group.

• Annual Conference of KIPS
• /
• 2015.10a
• /
• pp.1152-1155
• /
• 2015

네트워크상의 사이버 공격을 막고 원인분석 및 공격지를 찾기 위하여, 네트워크패킷 캡쳐 및 플로우 데이터를 수집 저장하고, 수집된 정보를 고속으로 검색하여 분석하는 것을 필요로 한다. 인터넷의 발달과 네트워크를 이용하는 기기들이 많아짐에 따라 네트워크상에는 1초에 수백만 개의 네트워크 패킷이 이동하고 있다. 이러한 대용량 네트워크 패킷을 고속으로 저장하고 검색하기 위하여, 대용량 저장 및 검색에 가장 적합한 데이터베이스를 이용하는 것이 중요하다. 대용량 네트워크 데이터의 저장에 가장 최적인 데이터베이스를 찾기 위해 이 논문에서는 관계형 데이터베이스(MySQL)와 컬럼기반 데이터 베이스(InfiniFlux), 그리고 Bitmap Index 기반 저장구조(FastBit)를 사용하여 로딩속도와 검색 속도, 그리고 각각의 디스크 사용량을 비교하였다.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.18 no.2
• /
• pp.141-147
• /
• 2018

The group is one of the hobbies and other life groups, and each person in the group directly attends the meeting and works on the topic of the group. In this paper, we implemented voting, announcements, surveys, and suggestions, which are necessary functions for similar groups including group. We also provide web sites based on Apache web server for convenience of Android smartphone applications, OS except Android, Group management can be managed by using the manager's website which can manage the whole group management. It is designed with Apache web server, web communication language PHP, MySQL database, and Android.