• Journal of Intelligence and Information Systems
• /
• v.17 no.4
• /
• pp.37-58
• /
• 2011

In general, testing DB applications is much more difficult than testing other types of software. The fact that the DB states as much as the input data influence and determine the procedures and results of program testing is one of the decisive reasons for the difficulties. In order to create and maintain proper DB states for testing, it not only takes a lot of time and efforts, but also requires extensive IT expertise and business knowledge. Despite the difficulties, there are not enough research and tools for the needed help. This article reports the result of research on automatic creation and maintenance of DB states for testing DB applications. As its core, this investigation develops an automation tool which collects relevant information from a variety of sources such as log, schema, tables and messages, combines collected information intelligently, and creates pre- and post-Images of database tables proper for application tests. The proposed procedures and tool are expected to be greatly helpful for overcoming inefficiencies and difficulties in not just unit and integration tests but including regression tests. Practically, the tool and procedures proposed in this research allows developers to improve their productivity by reducing time and effort required for creating and maintaining appropriate DB sates, and enhances the quality of DB applications since they are conducive to a wider variety of test cases and support regression tests. Academically, this research deepens our understanding and introduces new approach to testing enterprise systems by analyzing patterns of SQL usages and defining a grammar to express and process the patterns.

• The Journal of Society for e-Business Studies
• /
• v.25 no.4
• /
• pp.143-154
• /
• 2020

With the increasing trend of making manufacturing system intelligent and autonomous, the introduction of robot-assist automation, like machine tending system for automated operation of CNC machine tools, is being actively carried out at many industrial sites. Most important part of this intelligent system to install machine tending system, is interface programming between the CNC machine tools and the industrial robot. Despite this importance, however, the machine tending system has many setup problems. it is necessary for difficult re-program of both controllers whenever a new CNC machine tool or robot is introduced. And, the helps of external engineers is required even though trivial changes due to the complex structure of the machine tending system. Authors of this paper introduces the integrated system of the interface between heterogeneous CNC machine tools and industrial robots. In addition, the digital twin implemented inside the machine tool controller enable shop-floor operators to change the interface programming easily. To implement this system, an integrated development environment for 1) an intelligent HMI platform that provide standardized interfaces to heterogeneous CNC machine tools and 2) a robot platform developing application software of various robots, was established. For easy un-tact environment, this paper explain the development of 3) a game-engine based web program of controlling and monitoring machine tending system remotely.

• Journal of the Korea Society of Computer and Information
• /
• v.15 no.9
• /
• pp.57-65
• /
• 2010

This paper describes the method of efficient container number recognition in colored container image with number plate at ATC(Automatic Transfer Crane) in container terminal yard. At the Sinseondae terminal gate in Busan, the container number recognition system is installed by "intelligent port-logistics system technology development", that is government research and development project. It is the method that it sets up the tunnel structure inside camera on the gate and it recognizes the container number in order to recognize the export container cargo automatically. However, as the automation equipment is introduced to the container terminal and the unmanned of a task is gradually accomplished, the container number recognition system for the confirmation of the object of work is required at ATC in container terminal yard. Therefore, the container number recognition system fitted for it is necessary for ATC in container terminal yard in which there are many intrusive of the character recognition through image including a sunlight, rain, snow, shadow, and etc. unlike the gate. In this paper, hardware components of the camera, illumination, and sensor lamp were altered and software elements of an algorithm were changed. that is, the difference of the brightness of the surrounding environment, and etc. were regulated for recognize a container number. Through this, a shadow problem, and etc. that it is thickly below hung with the sunlight or the cargo equipment were solved and the recognition time was shortened and the recognition rate was raised.

• Journal of Bio-Environment Control
• /
• v.23 no.1
• /
• pp.26-30
• /
• 2014

Purpose of this study was a development of a sprayer arm auto control system that could be operated according to distance from pear trees for automation of pest control. Auto control system included two parts, hardware and software. First, controller was made with an MCU and relay switches. Two types of ultra-sonic sensors were installed to measure distance from pear trees: one on/off type that detect up to 3 m, and the other continuous type providing 0~5 V output corresponding to distance of 0~3 m. Second, an auto control algorithm was developed to control. Each spraying arm was controlled according to the sensor-based distance from the pear trees. And it could dodge obstacles to protect itself. Max and min signal values were eliminated, when five sensor signals was collected, and then signals were averaged to reduce sensor's noises. According to results of field experiment, auto control test result was better than non auto control test result. Spraying rates were 69.25% (left line) and 98.09% (right line) under non auto control mode, because pear trees were not planted uniformly. But, auto control test's results were 92.66% (left line) and 94.64% (right line). Spraying rate was increased by maintaining distance from tree.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.16 no.7
• /
• pp.2257-2285
• /
• 2022

Cyber-physical systems (CPS) have been growing exponentially due to improved cloud-datacenter infrastructure-as-a-service (CDIaaS). Incremental expandability (scalability), Quality of Service (QoS) performance, and reliability are currently the automation focus on healthy Tier 4 CDIaaS. However, stable QoS is yet to be fully addressed in Cyber-physical data centers (CP-DCS). Also, balanced agility and flexibility for the application workloads need urgent attention. There is a need for a resilient and fault-tolerance scheme in terms of CPS routing service including Pod cluster reliability analytics that meets QoS requirements. Motivated by these concerns, our contributions are fourfold. First, a Distributed Non-Recursive Cloud Model (DNRCM) is proposed to support cyber-physical workloads for remote lab activities. Second, an efficient QoS stability model with Routh-Hurwitz criteria is established. Third, an evaluation of the CDIaaS DCN topology is validated for handling large-scale, traffic workloads. Network Function Virtualization (NFV) with Floodlight SDN controllers was adopted for the implementation of DNRCM with embedded rule-base in Open vSwitch engines. Fourth, QoS evaluation is carried out experimentally. Considering the non-recursive queuing delays with SDN isolation (logical), a lower queuing delay (19.65%) is observed. Without logical isolation, the average queuing delay is 80.34%. Without logical resource isolation, the fault tolerance yields 33.55%, while with logical isolation, it yields 66.44%. In terms of throughput, DNRCM, recursive BCube, and DCell offered 38.30%, 36.37%, and 25.53% respectively. Similarly, the DNRCM had an improved incremental scalability profile of 40.00%, while BCube and Recursive DCell had 33.33%, and 26.67% respectively. In terms of service availability, the DNRCM offered 52.10% compared with recursive BCube and DCell which yielded 34.72% and 13.18% respectively. The average delays obtained for DNRCM, recursive BCube, and DCell are 32.81%, 33.44%, and 33.75% respectively. Finally, workload utilization for DNRCM, recursive BCube, and DCell yielded 50.28%, 27.93%, and 21.79% respectively.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.39 no.10
• /
• pp.979-986
• /
• 2011

In this paper, an embedded program of a flight control system for a small high performance UAV is introduced. The program consists of modules for device management and guidance and control. The device management system handles navigation sensors and mission equipments. The program for the guidance and control system is used to accomplish various kinds of missions and realize automation of flight control. Driver programs embedded in the device management system for operation of sensors and external devices are based on Texas Instrument's DSP/BIOS RTOS(realtime operating system). The on-board programs for the guidance and control system is obtained by using the model-based auto code generation technology.

• Journal of Biosystems Engineering
• /
• v.40 no.1
• /
• pp.35-46
• /
• 2015

Purpose: To present a flexible and accurate autonomous solution for creating any desired row spacing value between the hydroponic gullies in multilayer growing units, and evaluate the capabilities and performance of the relevant automated system through the use of virtual prototyping technique. Methods: To build the virtual prototype of the system, CAD models of its different parts, including an autonomous vehicle and the mechanical mechanisms embedded in the multilayer growing unit, were developed and imported into the RecurDyn simulation software. In order to implement the automated row spacing operation, three spacing modes with different loading cycles and working steps were defined, and the operation of the system was simulated to obtain the target row spacing values specified for each of these modes. Results: Motion profiles related to the horizontal displacement of: 1) the lower and upper sliding bars installed in the cultivation layers, and 2) the hydroponic gullies, during the simulation of the system operation, were generated and analyzed. No deviation from the specified target spacing values was observed at the end of simulations for all spacing modes. Conclusions: The results of the motion analysis obtained by simulating the system operation confirm the effectiveness of the control scheme proposed for automated row spacing of gullies. It was also found that proper sequencing of the loading cycles and the precision of the working strokes of the upper bars are the critical factors for establishing a certain row spacing value. Based on the simulation results, precise control of the back and forth motions of the upper bars is highly necessary for sound operation of the real system.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.14 no.3
• /
• pp.1204-1227
• /
• 2020

The tradeoff between energy conservation and traffic balancing is a dilemma problem in Wireless Sensor Networks (WSNs). By analyzing the intrinsic relationship between cluster properties and long distance transmission energy consumption, we characterize three node sets of the cluster as a theoretical foundation to enhance high performance of WSNs, and propose optimal solutions by introducing rendezvous and Mobile Elements (MEs) to optimize energy consumption for prolonging the lifetime of WSNs. First, we exploit an approximate method based on the transmission distance from the different node to an ME to select suboptimal Rendezvous Point (RP) on the trajectory for ME to collect data. Then, we define data transmission routing sequence and model rendezvous planning for the cluster. In order to achieve optimization of energy consumption, we specifically apply the economic theory called Diminishing Marginal Utility Rule (DMUR) and create the utility function with regard to energy to develop an adaptive energy consumption optimization framework to achieve energy efficiency for data collection. At last, Rendezvous Transmission Algorithm (RTA) is proposed to better tradeoff between energy conservation and traffic balancing. Furthermore, via collaborations among multiple MEs, we design Two-Orbit Back-Propagation Algorithm (TOBPA) which concurrently handles load imbalance phenomenon to improve the efficiency of data collection. The simulation results show that our solutions can improve energy efficiency of the whole network and reduce the energy consumption of sensor nodes, which in turn prolong the lifetime of WSNs.

• Journal of the Earthquake Engineering Society of Korea
• /
• v.27 no.2
• /
• pp.77-82
• /
• 2023

The structural analysis module is an essential part of any integrated structural system. Diverse integrated systems today require, from the analysis module, efficient real-time responses to real-time input such as earthquake signals, extreme weather-related forces, and man-made accidents. An integrated system may also be for the entire life span of a civil structure conceived during the initial conception, developed throughout various design stages, effectively used in construction, and utilized during usage and maintenance. All these integrated systems' essential part is the structural analysis module, which must be automated and computationally efficient so that responses may be almost immediate. The finite element method is often used for structural analysis, and for automation, many effective finite element meshes must be automatically generated for a given analysis. A computationally efficient finite element mesh generation scheme based on the r-h method of mesh refinement using strain deviations from the values at the Gauss points as error estimates from the previous mesh is described. Shape factors are used to sort out overly distorted elements. A standard cantilever beam analyzed by four-node plane stress elements is used as an example to show the effectiveness of the automated algorithm for a time-domain dynamic analysis. Although recent developments in computer hardware and software have made many new applications in integrated structural systems possible, structural analysis still needs to be executed efficiently in real-time. The algorithm applies to diverse integrated systems, including nonlinear analyses and general dynamic problems in earthquake engineering.

• Transactions of the Korean Society of Mechanical Engineers A
• /
• v.39 no.12
• /
• pp.1287-1295
• /
• 2015

Recently, fieldbus communication technologies have been widely deployed for industrial automation because they are profitable in providing easy system integration and management for multiple devices, as well as high-speed communication. It is essential for smart encoders to support fieldbus connectivity, where the device configuration and various types of information related to position are exchanged between an external controller and multiple encoders over the communication link. In this study, we implemented the CiA 406 device profile for smart encoders from the CANopen standards by extending an open-source CANopen standard-compliant framework, called CanFestival. The CiA 406 functionalities implemented in this study were validated on a test-bed consisting of a CANopen master and virtual CANopen encoders with our CiA 406 extension module.