• The Journal of the Convergence on Culture Technology
• /
• v.9 no.6
• /
• pp.911-917
• /
• 2023

In today's world, we find ourselves facing energy crises due to factors such as war and climate crises. To prepare for these energy crises, many researchers continue to study systems related to energy monitoring and conservation, such as energy management systems, energy monitoring, and energy conservation. In line with these efforts, nations are making it mandatory for energy-consuming facilities to implement these systems. However, these facilities, limited by space and energy constraints, are exploring ways to improve. This research explores the operation of a data collection system using low-performance embedded devices. In this context, it proves that an optimized version of RocksDB, a Key-Value store, outperforms traditional databases when it comes to time-series data. Furthermore, a comprehensive database evaluation tool was employed to assess various databases, including optimized RocksDB and regular RocksDB. In addition, heterogeneous databases and evaluations are conducted using a UD Benchmark tool to evaluate them. As a result, we were able to see that on devices with low performance, the time required was up to 11 times shorter than that of other databases.

• Journal of Physiology & Pathology in Korean Medicine
• /
• v.26 no.4
• /
• pp.551-556
• /
• 2012

The database for the oriental medicine had been existed in documentation in past times and it has been developed to the database type for random accesses in the information society. However, the aspects of the database are not so diversified and the database for the bio herbal material exists in widened type dictionary style. It is a situation that the database which handles the in-depth raw herbal medicines is not sufficient in its quantity and quality. Korean wild grape is a deciduous plant categorized into the Vitaceae and it was found experimentally that it has various medical effects. It is one of the medical materials with higher potentiality of academic study and commercialization recently because it has a bigger possibility to be applied into diverse industrial fields including the medical product for health, food and beauty. We constituted the cooperative system among the Muju cluster business group for Korean mountain wild grapes, Physiology Laboratory in Kyung Hee University Oriental Medicine and Medical Classics Laboratory in Kyung Hee University Oriental Medicine with a view to focusing on such potentiality and a database for Korean wild grapes was made a touchstone for establishing the in-depth database for the single bio medical materials. First of all, the literatures based on the North East Asia in ancient times had been categorized into the classical literature (Korean literature published by government organization, Korean classical literature, Chinese classical literature and classical literature fro Korean and Chinese oriental medicine) and modern literature (Modern literature for oriental medicine, modern literature for domestic and foreign herbal medicine) to cover the eastern and western research records and writings related to Korean wild grapes and the text-mining work has been performed through the cooperation system with the Medical Classics Laboratory in Kyung Hee University Oriental Medicine. First of all, the data for the experiment and theory for Korean wild grape were collected for the Medline database controlled by the Parliament Library of USA to arrange the domestic and foreign theses with topic for Korean wild grapes and the network hyperlink function and down load function were mounted for self-thesis searching function and active view based on the collected data. The thesis searching function provides various auxiliary functions and the searching is available according to the diverse searching/queries such as the name of sub species of Korean wild grape, the logical intersection index for the active ingredients, efficacy and elements. It was constituted for the researchers who design the Korean wild grape study to design of easier experiment. In addition, the data related to the patents for Korean wild grape which were collected from European Patent Office in response to the commercialization possibility and the system available for searching and view was established in the same viewpoint. Perl was used for the query programming and MS-SQL for database establishment and management in the designing of this database. Currently, the data is available for free use and the address is as follows. http://163.180.41.43:8011/index.html

• Journal of Information Processing Systems
• /
• v.13 no.3
• /
• pp.573-589
• /
• 2017

Cloud computing is an attractive solution that can provide low cost storage and powerful processing capabilities for government agencies or enterprises of small and medium size. Yet the confidentiality of information should be considered by any organization migrating to cloud, which makes the research on relational database system based on encryption schemes to preserve the integrity and confidentiality of data in cloud be an interesting subject. So far there have been various solutions for realizing SQL queries on encrypted data in cloud without decryption in advance, where generally homomorphic encryption algorithm is applied to support queries with aggregate functions or numerical computation. But the existing homomorphic encryption algorithms cannot encrypt floating-point numbers. So in this paper, we present a mechanism to enable the trusted party to encrypt the floating-points by homomorphic encryption algorithm and partial trusty server to perform summation on their ciphertexts without revealing the data itself. In the first step, we encode floating-point numbers to hide the decimal points and the positive or negative signs. Then, the codes of floating-point numbers are encrypted by homomorphic encryption algorithm and stored as sequences in cloud. Finally, we use the data structure of DoubleListTree to implement the aggregate function of SUM and later do some extra processes to accomplish the summation.

• Journal of the Korea Computer Industry Society
• /
• v.8 no.1
• /
• pp.1-8
• /
• 2007

In this paper, teaching object-oriented design in a programming course is a big challenge for instructors. "Objects-first" is a popular strategy for teaching object-oriented programming in the educational settings, by introducing the concepts of objects, classes, and instances before procedural elements of a programming language. Still, this approach emphasizes coding rather than other critical aspects of software development, notably problem-solving and design. We propose a "design-first" approach, which subsumes an objects-first approach into lessons that also introduce object-oriented analysis and design, using elements of UML before implementing any code. We also present video rental store (SRS) that uses the design-first approach to help students of various teaming styles in a software engineering course. It interfaces with an IDE we have chosen specifically to support the design-first approach, and SRS which has been shown to be effective in helping students learn object-oriented programming concepts.

• International Journal of Fuzzy Logic and Intelligent Systems
• /
• v.7 no.4
• /
• pp.274-278
• /
• 2007

As XML becomes the standard of digital data exchange format we need to manage a lot of XML data effectively. Unlike tables in relational model XML documents are not structural. That makes it difficult to store XML documents as tables in relational model. To solve these problems there have been significant researches in relational database systems. There are two kinds of approaches: 1) One way is to decompose XML documents so that elements of XML match fields of relational tables. 2) The other one stores a whole XML document as a field of relational table. In this paper we adopted the second approach to store XML documents because sometimes it is not easy for us to decompose XML documents and in some cases their element order in documents are very meaningful. We suggest an efficient table schema to store only inverted index as tables to retrieve required data from XML data fields of relational tables and shows SQL translations that correspond to XML full-text retrievals. The functionalities of XML retrieval are based on the W3C XQuery which includes full-text retrievals. In this paper we show the superiority of our method by comparing the performances in terms of a response time and a space to store inverted index. Experiments show our approach uses less space and shows faster response times.

• Proceedings of the Korean Society for Emotion and Sensibility Conference
• /
• 2001.05a
• /
• pp.204-209
• /
• 2001

감성 연구의 생리, 심리, 동작 분석 등의 과정에서 발생하는 문서, 데이터, 화상, 그림, 그래픽 등의 자료 공유에 인터넷을 적용하는 것은 매우 유망하다, 본 연구에서는 현재의 인터넷 (또는 인트라넷) 환경을 고려하여 Ultra 2 DB 서버, Sun Solaris (UNIX) OS, UniSql DBMS, Apache Web 서버로 시스템을 구축하였다. 이 시스템을 이용하여 웹기반 감성데이터 베이스 시제품을 구축하여 각종 감성자료를 보급하는 체계를 1차 완료하였으며, 도메인(www.gamsung.or.kr)을 등록하여 서비스를 실시하고 있다. 이 시스템에는 1단계 감성공학기술개발 사업의 35개 연구보고서, 1단계 연구결과로서 생산한 262개 감성지표, 2단계(전반기) 연구사업의 78개 감성지표, 일본의 인간감각계측 및 응용기술개발 중심으로 생산하나 100개 감성지표, 음성데이터, 인체측정데이터, 얼굴표정데이터와 설문데이터 등의 감성데이터와 감성공학 연구자 인력, 국내제조업체 정보, 참고문헌, 감성 정보물 등을 DB화하여 인터넷을 통하여 조회, 검색할 수 있도록 하였다. 뿐만 아니라 현재 진행되고 있는 감성공학기술개발에 대한 각종 정보를 제공하고 있으며 감성공학의 기술 동향에 대해서도 소개하고 있다. 이는 한국인의 감성 연구에 적합한 감성공학 데이터 베이스 시스템 구축의 발판을 마련하였으며, 향후 소비자의 감성을 예측하고, 이를 시스템 설계에 반영할 수 있으므로 인간중심의 제품개발에 큰 기여를 할 것으로 기대된다.

• Journal of Korean Society of Rural Planning
• /
• v.16 no.3
• /
• pp.117-129
• /
• 2010

The purpose of this paper is to develop a web-based information system for rural settlement environment diagnosis which is useful to apply the village based evaluation for new rural development projects. To achieve this purpose, this study performed : 1) analyzing the business process in the field of rural settlement environment diagnosis, 2) designing the data flow diagram and the database based on settlement environment diagnostic indices(SEDI), and 3) developing the system using APM (Apache, PHP, and MySQL) of web-system development environment. The developed system was applied to the study rural villages for testing of efficient and logical working. Users of the system, such as, researchers, decision makers, and rural residents, can input directly the village data to diagnose through a file format of Excel in MS Office. Futhermore, they can analyze the visual results with graphic and graph types, simultaneously. From the results of this study, it showed that the developed system enables decision-makers not only to assist the planning process of the rural village development project, but also to improve the level of information technology in the research and planning field concerning with rural development.

• Journal of the Korea Computer Industry Society
• /
• v.3 no.9
• /
• pp.1245-1250
• /
• 2002

This paper is an intelligence type of remote medical examination system for both on-line and off-line mode to transcend time and space on web where anyone can participate ;on-line consultation among patient, doctor, Korean medical doctor, medical examination in off-line mode, transmission of prescription to the pharmacist designated by patient and preparation of medicine, and semi-eternal storage of medical examination data by storage and check of medical examination data ; and database is composed by using intelligence type of object control which enables effect of treatment for heredity including check and mutual holding of medical examination data among family, fast treatment effect pursuant to situation of past medical examination through control of private disease history, cooperated medical examination among doctors, and so on.

• Journal of Multimedia Information System
• /
• v.2 no.3
• /
• pp.287-294
• /
• 2015

We are living in epoch of information when Internet touches all aspects of our lives. Therefore, it provides a plenty of services each of which benefits people in different ways. Electronic Mail (E-mail), File Transfer Protocol (FTP), Voice/Video Communication, Search Engines are bright examples of Internet services. Between them Social Network Services (SNS) continuously gain its popularity over the past years. Most popular SNSs like Facebook, Weibo and Twitter generate millions of data every minute. Twitter is one of SNS which allows its users post short instant messages. They, 100 million, posted 340 million tweets per day (2012)[1]. Often big amount of data contains lots of noisy data which can be defined as uninteresting and unclassifiable data. However, researchers can take advantage of such huge information in order to analyze and extract meaningful and interesting features. The way to collect SNS data as well as tweets is handled by crawlers. Twitter crawler has recently emerged as a great tool to crawl Twitter data as well as tweets. In this project, we develop Twitter Crawler system which enables us to extract Twitter data. We implemented our system in Java language along with MySQL. We use Twitter4J which is a java library for communicating with Twitter API. The application, first, connects to Twitter API, then retrieves tweets, and stores them into database. We also develop crawling strategies to efficiently extract tweets in terms of time and amount.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2002.11c
• /
• pp.1681-1684
• /
• 2002

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