• The Journal of Information Systems
• /
• v.19 no.4
• /
• pp.25-49
• /
• 2010

As companies introduced ERP (Enterprise Resource Planning) systems since the middle of 1990s, the databases of the companies has become centralized and gigantic. The companies are now developing data-mining based applications on those centralized and gigantic databases for knowledge management. Almost of them are using $Pro^*C$/C++, a embedded SQL programming language, and it's because the $Pro^*C$/C++ is independent of platforms and also fast. However, they suffer from difficulties in development and maintenance due to the characteristics of corporate databases which have intrinsically large number of tables and fields. The purpose of this research is to design and implement a methodology which makes it easier to develop and maintain embedded SQL applications based on relational databases. Firstly, this article analyzes the syntax of $Pro^*C$/C++ and addresses the concept of repetition and duplication which causes the difficulties in development and maintenance of corporate information systems. Then, this article suggests a management architecture of source codes and databases in which a preprocessor generates $Pro^*C$/C++ source codes by referring a DB table specification, which would solve the problem of repetition and duplication. Moreover, this article also suggests another architecture of DB administration in which the preprocessor generates DB administration commands by referring the same table specification, which would solve the problem of repetition and duplication again. The preprocessor, named $PrePro^*C$, has been developed under the UNIX command-line prompt environment to preprocess $Pro^*C$/C++ source codes and SQL administration commands, and is under update to be used in another DB interface environment like ODBC and JDBC, too.

• Journal of KIISE:Computing Practices and Letters
• /
• v.14 no.8
• /
• pp.758-762
• /
• 2008

Embedded systems usually utilize Flash Memories with very nice characteristics of non-volatility, low access time, low power and so on. For the multimedia database systems, R-tree is an indexing tree with nice characteristics for multimedia access. MR-tree, which is an upgraded version of R-tree, has shown better performance in searching, inserting and deleting operations than R-tree. Flash memory has sectors and blocks as a unit of read, write and delete operations. Especially, the delete is done on a unit of 512 byte blocks with very large operation time and it is also known that read and write operations on a unit of block matches caching nature of MT-tree. Our research optimizes MR-tree operations in a unit of Flash memory blocks. Such an adjusting leads in better indexing performance in database accesses. With MR-tree on a 512B block units we achieved fast search time of database indexing with low height of MR-tree as well as faster update time of database indexing with the best fit of flash memory blocks. Thus MR-tree with optimized operations shows good characteristics to be a database index schemes on any systems with flash memory.

• Proceedings of the Safety Management and Science Conference
• /
• 2012.04a
• /
• pp.561-571
• /
• 2012

In this study, which is the basis for industrial presses to target small and medium enterprises with production information system is designed. Production information in real time on-site digitizing and transmitting data to a standard PC is to base operations. Personnel management, safety management, production management is to increase the efficiency. Therefore, at low cost is to encourage computerization within the company. These embedded systems and wireless communication module has a database management program installed in order to raise productivity and competitiveness will improve.

• IEMEK Journal of Embedded Systems and Applications
• /
• v.12 no.1
• /
• pp.63-69
• /
• 2017

This paper proposes a new device for a portable braille device using Atmega128 and solenoid magnets. This braille device is composed of three panels, and each panel has six solenoid dots. This device aims to help the disabled people who cannot communicate with others. As an application example, when a disabled people approach a traffic light, it sends a message via Bluetooth to the proposed device letting people recognize a dangerous area. The message converted from the database is based on standard braille chart.

• IEMEK Journal of Embedded Systems and Applications
• /
• v.15 no.5
• /
• pp.205-214
• /
• 2020

With the recent development of hardware and software technology, interest in the development of wearable devices is increasing. In particular, wearable devices require algorithms suitable for low-power and low-capacity embedded devices. Among them, there is an increasing demand for a signal compression algorithm that reduces communication overhead, in order to increase the efficiency of storage and transmission of electrocardiogram (ECG) signals requiring long-time measurement. Because normal beats occupy most of the signal with similar shapes, a high rate of signal compression is possible if normal beats are represented by a template. In this paper, we propose an algorithm for determining the normal beat template using the template cluster and Pearson similarity. Also, the template is expressed effectively as a few vertices through linear approximation algorithm. In experiment of Datum 234 of MIT-BIH arrhythmia database (MIT-BIH ADB) provided by Physionet, a compression ratio was 33.44:1, and an average distribution of root mean square error (RMSE) was 1.55%.

• Journal of the Korean Operations Research and Management Science Society
• /
• v.25 no.3
• /
• pp.91-107
• /
• 2000

The linear programming model is a special form of useful knowledge that is embedded in a database. Since formulating models from scratch requires knowledge-intensive efforts, knowledge-based formulation support systems have been proposed in the Decision Support Systems area. However, they rely on the assumption that sufficient domain knowledge should already be captured as a specific knowledge representation form. Hence, the purpose of this paper is to propose a methodology that finds useful knowledge on building linear programming models from a database. The methodology consists of two parts. The first part is to find s first-cut model based on a data dictionary. To do so, we applied the General Problem Solver(GPS) algorithm. The second part is to discover a second-cut model by applying neural network technique. An illustrative example is described to show the feasibility of the proposed methodology.

• International Journal of Highway Engineering
• /
• v.16 no.4
• /
• pp.97-110
• /
• 2014

PURPOSES: This study is to find the substantial shortcomings embedded in the government policies and practical administrative processes associated with the Korean Transportation Database (KTDB) and to propose preliminary approaches to overcome. METHODS: Administrative and socioeconomic issues on inefficiency in public and private investment and redemption was found from the literature review. Through the interview of sets of experts and practitioners, a set of faultiness embodied in the administrative procedure utilizing and managing KTDB was found and analyzed. RESULTS: This study found the erroneous administrative elements categorized into four groups: faulty socioeconomic data supporting local governors's optimistic will yielded overestimation of future traffic demand; faulty data incidentally introduced in KTDB burdened traffic demand analysis; unavoidable misuse of KTDB worsened the unstability of KTDB; and apathy to manage the KTDB data deviated systematic management. The proposed includes the alteration of the administrative and technical systems to overcome those shortcomings. CONCLUSIONS : Erroneous administrative elements associated with KTDB should be concerned prior to indicating subsequential faultiness in demand analysis.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.20 no.2
• /
• pp.421-426
• /
• 2016

Recent developments in internet technologies has enabled widespread growth of embedded systems like Arduino, Raspberry Pi and other smart home systems. A research in the industrial sector on the utilization of the board has been made. The development needs of the embedded board in a reagent bottle case system has been highlighted. Current reagent Management System has to hold and manage the reagent itself is mostly to save the program using handwritten or machine. In addition, there is a risk to the system during the vulnerable zone administrator to manage the situation of the reagent bottle case can lead to a massive fire. In this paper, reagent bottle case RFID readers and data in real-time is monitored by attaching a sensor management through the database and sends a warning message to the mobile device of the administrator in real time during hazardous situations in the reagent bottle case. This is improve the reliability and efficiency of reagent bottle case.

• Journal of Korea Society of Industrial Information Systems
• /
• v.13 no.5
• /
• pp.98-105
• /
• 2008

Zigbee communication is applied in the many communication system. This paper is the system development contents which applies a zigbee communication. The system which develops from this paper is apply a zigbee communication in order system Does so, Reduced the step of orders from employee or from counter. Because of that, reduced the order number of times which goes wrong and shortened a time. Reasoning is caused by prevented an order delay at busy time. Order and payment are together controlled from inside the program which is developed. The adjust of the present state of sale does not have a necessity. Because that is stored at Database.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2019.05a
• /
• pp.508-509
• /
• 2019

모바일 환경에서 데이터베이스 엔진 사용이 보편화되고 있으며 모바일에 적합한 데이터베이스 엔진 개발과 발표가 뒤따르고 있다. 모바일 데이터베이스는 대부분 플래시 메모리로 구성한 다양한 파일시스템에서 관리된다. 이 논문에서는 대표적인 모바일 데이터베이스인 SQLite3의 파일 시스템별 갱신 성능을 테스트한다. 그래서 각 파일 시스템별 특성을 파악하고 비교하기 위한 시스템을 구현하고 성능 실험을 실시한다. 실험 결과로부터 각 데이터베이스 갱신 패턴에 따른 파일 시스템별 장단점을 분석할 수 있다.