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

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

• Journal of the Korean Association of Geographic Information Studies
• /
• v.25 no.4
• /
• pp.163-180
• /
• 2022

Real estate data can be big data. Because the amount of real estate data is growing rapidly and real estate data interacts with various fields such as the economy, law, and crowd psychology, yet is structured with complex data layers. The existing Relational Database tends to show difficulty in handling various relationships for managing real estate big data, because it has a fixed schema and is only vertically extendable. In order to improve such limitations, this study constructs the real estate data in a Graph Database and verifies its usefulness. For the research method, we modeled various real estate data on MySQL, one of the most widely used Relational Databases, and Neo4j, one of the most widely used Graph Databases. Then, we collected real estate questions used in real life and selected 9 different questions to compare the query times on each Database. As a result, Neo4j showed constant performance even in queries with multiple JOIN statements with inferences to various relationships, whereas MySQL showed a rapid increase in its performance. According to this result, we have found out that a Graph Database such as Neo4j is more efficient for real estate big data with various relationships. We expect to use the real estate Graph Database in predicting real estate price factors and inquiring AI speakers for real estate.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.10 no.11
• /
• pp.3207-3212
• /
• 2009

Automatic semiconductor manufacturing systems are demanded to improve the efficiency of the semiconductor production process. These systems include the functionalities such as the analysis and management schemes for very large real-time data in order to enhance the productivities. So, it requires the efficient storage management system to store very large real-time data. Traditional database management systems(e.g. Oracle, MY-SQL, MS-SQL) are based on disk. However, previous DBMS's have the limitation on the low storing performance. In this paper, we propose a compress-merge storing method of very large real-time data using insert transaction of a block unit. The proposed method shows better processing performances compare to conventional DBMS's. Also compress-merge method makes it possible that it can store large real-time data on low storage cost. Therefore, the proposed method can be applied to an efficient storage management system in the semiconductor production process.

• Journal of Digital Convergence
• /
• v.12 no.8
• /
• pp.235-242
• /
• 2014

Internet telephony is an Internet service which supports voice telephone using VoIP technology on the IP-based Internet. It has some advantages in that voice telephone services can be accompanied with multimedia services such as video communication and messaging services. In this paper we suggested an Asterisk-based Internet telephony system which can be easily scalable. Most current systems use text files to manage their configuration: SIP users, dialplans, IVR service and etc. But we designed the management system which introduces database tables for efficiency and scalability. It also supports web-based functions developed by using Asterisk, Apache, MySQL, jQuery, PHP and open source softwares.

• 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.

• KIPS Transactions on Software and Data Engineering
• /
• v.4 no.9
• /
• pp.371-376
• /
• 2015

The Internet of Things (IoT) significantly increases the amount of data. Database compression is important for big data because it can reduce costs for storage systems and save I/O bandwidth. However, it could show low performance for write-intensive workloads such as OLTP due to the updates of compressed pages. In this paper, we present practical guidelines for the performance improvement of database compression. Especially, we propose the SELECTIVE strategy, which compresses only tables whose space savings are close to the expected space savings calculated by the compressed page size. Experimental results using the TPC-C benchmark and MySQL show that the strategy can achieve 1.1 times better performance than the uncompressed counterpart with 17.3% space savings.

• Journal of Advanced Navigation Technology
• /
• v.20 no.1
• /
• pp.72-78
• /
• 2016

MD-5 has been the hash algorithm to encrypt the user's password on Linux from the beginning. Recently the more reliable password management was demanded and SHA-512 algorithm became the hash algorithm on the recent Enterprise Linux which is more reliable than MD-5. This paper researching the characteristics of the hashing and encryption algorithms and find out about Linux User information management. Based on this analysis, and analysis of the security of the hashing algorithm is applied to the user password. In addition, analyzes the cases used hash algorithm applied to the validation of Open Source Software file, such as Apache, PHP, MySQL. Finally, by analyzing the security tool John The Ripper this paper suggests the enhanced security with the administrative management of passwords.

• Journal of Internet of Things and Convergence
• /
• v.2 no.3
• /
• pp.17-24
• /
• 2016

In this paper, we developed web based Plossom system, an efficient and convenient project management system. The development of Plossom consists of a web page using HTML and Bootstrap framework, and the logic is built using the algorithm suitable for web page by using JQuery. Additionally, Plossom is implemented to support interoperability with external system by using Spring's Thymeleaf and MySQL efficiently. The Plossom system developed in this study is expected to be very useful in the development process of IOT and ICT related projects.

• 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.

• The Journal of Korean Association of Computer Education
• /
• v.4 no.1
• /
• pp.87-97
• /
• 2001

With coming information society and universal use of internet, we have been concerned about the educational utilization of the internet. Recognizing the growing need for the use of the internet in education, there are many research of WBI According to behaviorism learning theory, learning effects are extremely improved when immediate feedback is offered to learner. In this paper, we designed and implemented feedback BBS that offers immediately reponses to learner. The feedback BBS was implemented using PHP and MySQL. And we evaluated implemented feedback BBS by questionnaire.