• Journal of Digital Convergence
• /
• v.13 no.2
• /
• pp.43-50
• /
• 2015

Since the popularity of social network services (SNS) rise, the data produced from them is rapidly increased. The SNS data includes personal propensity or interest and propagates rapidly so there are many requests on analyzing the data for applying the analytic results to various fields. New technologies and services for processing and analyzing big data in the real-time are introduced but it is hard to apply them in a short time and low coast. In this paper, an efficient method to build a tweet analysis system without inducing new technologies or service platforms for handling big data is proposed. The proposed method was verified through building a prototype monitoring system to collect and analyze tweets using the MySQL database and the PHP scripts.

• Annual Conference of KIPS
• /
• 2000.10a
• /
• pp.399-402
• /
• 2000

인터넷 기술의 괄목할만한 발전과 멀티미디어 기술의 급속한 성장에 따라 인터넷은 오락, 교육, 전자상거래 등 많은 분야에 이용되고 있다. 특히 웹 메일 분야는 메일의 전송과 수신을 자유롭게 함으로써 편리한 의사 소통을 통해 향후 산업 구조를 개편하는데 견인차 역할을 할 것이라는 예측이 있다. 본 논문은 웹 메일 시스템에 대한 연구로써, DBMS로 MySQL을 사용해서 데이터베이스를 구축했고, 웹과 DB를 연동시키기 위해 Linux 시스템 상에서 PHP를 이용해서 CGI 프로그램을 작성해서 인터넷 웹 메일 시스템을 설계 구현했다.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2009.05a
• /
• pp.899-902
• /
• 2009

As computer network and wireless technology continue to grow rapidly, a wide range of remote application has been applied to medical field such as remote medical consulting and remote patient monitoring. This research aims to design RF telecommunication-based healthcare application to collect and manage patient's physiological data, and describe the overall procedure of experiment. MySQL database is designed to record patient's physiological data including temperature, blood pressure and heart rate and save information about medical behaviors such as doctor's prescription for patients. Therefore, users approved by healthcare application can query patient's data and collected data can be used to reorganize data for clinical test. As a result, temperature and humidity of patient's room which must be checked frequently can be processed automatically through ubiquitous sensor network. The information entered from mobile phones or web is saved in database, ensuring systematical management through computer. Moreover, patient's family members can easily access hospital data, improving their experience with medical service.

• The KIPS Transactions:PartD
• /
• v.9D no.3
• /
• pp.511-522
• /
• 2002

WBI (Web-Based Instruction), a web-based tool for teaching the students at a long distance, makes possible to Interact between learners and instructors, provides a wide variety of learning materials, has an advantage of overcoming spatial constraints. In this paper, as a model of using the web for education, a web-based education-evaluation system has been designed and implemented. Web-based education-evaluation system has to be equipped with both of the online setting question mode and the upload setting question mode, the former makes questions on web and the latter uploads the setted questions on offline with settling a defeat of the existing systems on setting questions. And the system has to be equipped with the function of analyzing the questions that gives teacher several kinds of analysis information and makes possible to feedback to questions by adjusting the difficulty and revising the questions. In this paper, a system that reflects the above requirements has been designed and implemented with PHP script language and MySQL database system.

• Annual Conference of KIPS
• /
• 2002.11c
• /
• pp.1681-1684
• /
• 2002

최근 XML 이라는 웹 문서 표준이 대두되면서 여러 응용 분야에서 이를 활용하려는 노력이 진행 중이다. 특히 웹 상에서 XML은 기준의 데이터베이스를 대체하여 데이터를 관리하고 조직화하며 또한 자원의 게시를 위해 사용되고 있다. 따라서 데이터베이스에 있는 데이터들을 XML문서로 변환하는 것은 필수불가분의 관계이며 좀더 쉽게 이러한 작업들을 할 수 있는 프로그램이 개발 또는 연구 중이다. 그러나 현재 개발된 XML 문서 변환기는 속성과 요소이름이 데이터베니스의 필드 이름으로 밖에 변환되지 않거나, 보통 테이블 이름이 요소로 각 필드이름이 요소 안의 속성으로 밖에 변환할 수 없다. 또한 MSSQL, MySQL, ACCESS와 같은 관계형 데이터베이스 툴 마다 호환이 되지 않으며 변환기 사용 시 인터페이스가 복잡하여 쉽게 이용할 수 없는 것이 현실이다. 본 논문은 이러한 문제점들을 해결하기 위해 효율적으로 관계형 데이터베이스 시스템에서 XML문서로 자동 변환시켜주는 웹 기반의 변환시스템을 구축하였다. 본 논문에서 제시한 변환 시스템은 데이터베이스 시스템 내의 테이블에 데이터를 입력할 경우 사용자가 원하는 형태의 XML문서로 변환이 가능하기 때문에 XML문서를 작성시 효과적으로 이용될 수 있다.

• Proceedings of the Korean Information Science Society Conference
• /
• 2006.10d
• /
• pp.728-733
• /
• 2006

본 논문은 홈 네트워크 환경에서 무선 센서 네트워크를 이용하여 홈 네트워크 서비스를 제공하는 서비스 모델을 제안한다. 제안된 서비스 모델은 댁내에 고정 센서 노드들을 배치하고 사용자에게 부착 가능한 센서 노드로 무선 센서 네트워크를 구성한다. 홈 서버에는 등록된 사용자 선호도 프로파일과 센서 노드들로부터 수집된 데이터를 데이터베이스로 구축한다. 이 데이터를 상황정보로 분석하여 사용자 개개인의 선호도에 따라 댁내 가전기기들을 자동 설정하고 자동 제어하는 서비스를 제공한다. 제안된 방식은 리눅스 환경에서 MySQL 데이터베이스가 내장된 홈 서버와 TinyOS가 탑재된 센서 노드들을 사용하여 구현하고 서비스를 테스트한다.

• Journal of the Korean Home Economics Association
• /
• v.44 no.4 s.218
• /
• pp.133-144
• /
• 2006

The contemporary period is called "the age of sensibility" in which each individual consumer seeks to have her or his own products. Businesses are in need of design developments with an emphasis on customer sensitivity, and at the same time consumers must understand their own sensitivity to acquire information on designs that suit them. This research established a sensitivity and configuration database on designing men's jackets using the sensitivity engineering approach to clothing design information. The user interface was created on the Internet. Sixty-seven sensitivity terms of vocabulary appropriate for the assessment of men's jacket design were selected, and the different designs were classified into six items and 24 categories. Thirty men's jackets with different designs were produced for sensory testing and the results were analyzed in accordance with general linear I statistics. A sensitivity database was established for each category. My-sql, PHP, Java Script, and Html were used for the configuration database work. The configuration of items/categories, with the most appropriate sensitivity database information assigned to the selected sensitivity vocabulary, was programmed for display on the computer screen. The sensitivity vocabulary of a customer's choice for each factor was selected for the program to run, while the category and product configuration of the men's jacket most suitable for the search was displayed based on the user interface.

• Journal of Digital Convergence
• /
• v.13 no.12
• /
• pp.135-142
• /
• 2015

Appearance and rapid growth of the social network services (SNS) have led to changes in the distribution structure of information. Consumers can obtain various information quickly via the social network services and companies make use of a new advertising channel in them. In order to increase the effect of publicity activities through the social network services, development and application of public relations strategy by evaluating and analyzing the results of the activities is required. In this paper, a method for developing a low cost system to evaluate and analyze the results of public relations through the social networks is proposed. The proposed method was verified through building and running a demo system to collect and analyze data in the Facebook fan pages using MySQL database and PHP script on a Linux server.

• Journal of Information Management
• /
• v.42 no.2
• /
• pp.103-120
• /
• 2011

The astronomical data obtained by observations of celestial objects movements are useful in our daily life. These data - such as 1) sunrise and sunset data, 2) data transformation between lunar calendar and solar calendar, 3) solar eclipse and lunar eclipse data, and 4) sun's altitude and azimuth data - were used to important things in the agricultural society and ancient kingdom. In the modern society, these data have been used continuously for the legal disputes, construction of buildings and the other areas. This is a good example of pure science data using directly in our life. However there are difficulties to public service because all the data were printed as an Almanac. Using MySQL, we constructed web-based service system which makes to use them easily. This database system was made for the quick search using the calculated orbital data of celestial bodies.

• Journal of KIISE
• /
• v.43 no.11
• /
• pp.1216-1222
• /
• 2016

The advent of large-scale web services has resulted in gradual increase in the amount of data used in those services. These big data are managed efficiently by DBMS such as MySQL and MariaDB, which use InnoDB engine as their storage engine, since InnoDB guarantees ACID and is suitable for handling large-scale data. To improve I/O performance, InnoDB caches data and index of its database through a buffer pool. It also supports multiple buffer pools to mitigate lock contentions. However, the multiple buffer pool scheme leads to the additional data consistency overhead. In this paper, we analyze the overhead of the multiple buffer pool scheme. In our experimental results, although multiple buffer pool scheme mitigates the lock contention by up to 46.3%, throughput of DMBS is significantly degraded by up to 50.6% due to increased disk I/O and fsync calls.