• Title/Summary/Keyword: Database Management Systems

Search Result 1,027, Processing Time 0.031 seconds

Schema Integration Methodology and Toolkit for Heterogeneous and Distributed Geographic Databases

  • Park, Jin-Soo
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.6 no.3
    • /
    • pp.51-64
    • /
    • 2001
  • Schema integration is one of the most difficult issues in the heterogeneous and distributed geographic database systems (GDSs). As the use of spatial information in various application areas becomes increasingly popular, the integration of geographic information has become a crucial task for decision makers. Most existing schema integration techniques described in the database literature, however, do not address the problems of managing heterogeneities among complex objects that contain visual data and/or spatial and temporal information. The difficulties arise not only from the semantic conflicts, but also from the different representations of spatial models. Consequently, it is much more complex to achieve interoperability in the area of geographic databases. This research attempts to provide a solution to such problems. The research reported in this paper describes a schema integration methodology and a prototype toolkit developed to assist in schema integration activities for GDSs.

  • PDF

Design for Automatic Building of a Device Database and Device Identification Algorithm in Power Management System (전력 관리 시스템의 장치 데이터베이스 자동 구축 및 장치 식별 알고리즘 설계)

  • Hong, Sukil;Choi, Kwang-Soon;Hong, Jiman
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.24 no.4
    • /
    • pp.403-411
    • /
    • 2014
  • In this paper, an algorithm of extracting the features of home appliances and automatically building a database to identify home appliances is designed and presented. For the verification, a software library supporting this algorithm is implemented and added to an power management system server, which was already implemented to support real-time monitoring of home appliances' power consumption status and controlling their power. The implemented system consists of a system server and clients, each of which measures the power consumed by a home appliance plugged in it and transmits the information to the server in real-time over a wireless network. Through experiments, it is verified that it is possible to identify any home appliance connected to a specific client.

Proposing a Preferred Parts List and Developing a Search System for Common Parts (우선부품목록 선정방안 제시 및 공용화 검색 시스템 구축)

  • Yoon, Jaebok;Kim, Siok;Moon, Jinkyu;Hong, Sungmin;Lim, Hojung;Kim, Sanghan
    • Journal of Korean Society for Quality Management
    • /
    • v.48 no.4
    • /
    • pp.567-580
    • /
    • 2020
  • Purpose: The purpose of this study is to present a preferred parts list, establish a search tool for common parts, and propose a development plan for parts management. Methods: When selecting the preferred parts list, the weight of the selection of the military parts and the online site of the civilian parts were taken into account. By establishing a database of selected preferred parts list, we have established a system for searching common parts. Results: The results of this study are as follows; In order to establish parts management work in Korea's defense, it is necessary to improve the Defense Acquisition Program Act, Enforcement Decree (Rules), and the Regulations for Defense Acquisition Program Administration. Development of performance indicators for parts management is required, and establishment of procedures and standards for selection of preferred parts lists is required. Considerations for the selection of preferred parts list include whether they are used a lot in civilian products, whether they are used a lot, whether they are certified suppliers, whether they are national and industrial standard products, whether they perform well considering reliability, durability, and quality, and whether they can be supplied continuously. Conclusion: It is necessary to establish policies and systems related to parts management and to establish criteria for selecting preferred parts list for the development of domestic parts management tasks.

An Application of GIS to Water Quality Management (GIS를 이용한 하천수질관리)

  • Yang, Hyung-Jae;Lee, Yoo-Won;Kim, Min
    • Journal of Environmental Impact Assessment
    • /
    • v.3 no.2
    • /
    • pp.25-32
    • /
    • 1994
  • This study was carried out as the Anyang creek water quality management using Geographic Information System (GIS) is the purpose of this pilot project to apply a GIS to environmental management field. Analysis of water quality data has been investigated using GIS with modeling of water quality management for the Anyang creek. The results of this study are summarized as follows: 1. The concentration of Mercury in sediment was increased rapidly nearby A26(Nightsoil Treatment Plant) and maximum was showed at A18 (Imgok bridge). Cadmium was increased rapidly at A35(Chulsan bridge). 2. River water quality management using visible computer system as GIS is effective to make decision for water quality management plan and database of environmental factors should be completed before applying GIS. 3. When water pollution accident is occurred in the river water system, pollutant source can be traced and analysed systematically using GIS to manage pollutants discharged into the river water system.

  • PDF

A Study on Implementation and Design of Web-based Q-Cost Management System : Part 2; Implementation (웹 기반의 품질코스트 관리시스템 구축 : 제2부; 시스템 구축)

  • Kim Yon-Soo;Chung Young-Bae
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.27 no.4
    • /
    • pp.179-186
    • /
    • 2004
  • The purpose of this study is to implement web-based quality cost management system to measure the performance of quality improvement activities in the business firms. Developed WQCMS(Web-based Q-Cost Management System) have ability to collect and analyze quality data generated from various different departments in the inside or outside of the enterprise without any limitations, if end-users are able to access wide area network. It provides the capability to integrate quality information from database and to generate various easy analysis reports to management's needs using built-in analysis tool modules with real-time. The proposed system was developed using Microsoft's .Net technology, ASP.NET and MS-SQL Server 2000. By web-enabling Q-cost management system, the effectiveness of the system management and utilization was realized by easiness of information integration and economical efficiency.

Validation and Verification Process for the Computerized Procedure System in Nuclear Power Plant Control Room (전자식 절차서 시스템의 원전제어적합성 확인 및 검증절차)

  • Cha, Woo-Chang
    • Journal of the Korean Society of Systems Engineering
    • /
    • v.5 no.1
    • /
    • pp.33-41
    • /
    • 2009
  • The analog or partly digital typed interface of main control room in nuclear power plant (NPP) is gradually being replaced to the totally digitalized interface suitable for the digital environment. SKN 3,4 Nuclear Power Plant is currently developed in such a way to employ advanced displays and controls such as computerized procedure system(CPS), large display panel(LDP), and Soft control. According to the developed design process, the main control room (MCR) of the SKN3,4 was aesthetically designed based on a design concept of the health and sustainability and technically evaluated with human factors guidelines, which somehow lack of the confidence on the evaluation for the rapidly changing digital environment. The suitable review guideline for the digitalized interface and the environment was developed such as the guideline for CPS with information displays on VDU. For the guideline development, tremendous guidelines and technical papers related to evaluation issues of digital environment has been collected, analyzed and transformed to electric database forms and then built on database management system, called Design Review Supporting System to retrieve the appropriate issues for the practical usage of evaluators-in-field.

  • PDF

Design and Implementation of e-Logistics System supporting Efficient Moving Objects Trajectory Management (효율적인 차량 궤적 관리를 지원하는 물류관리시스템의 설계 및 구현)

  • Lee, Eung-Jae;Nam, Kwang-Woo;Ryu, Keun-Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.9 no.2
    • /
    • pp.30-41
    • /
    • 2006
  • This paper proposes an e-logistics system supporting efficient vehicle moving trajectory management. Recent advances in wireless communications have given rise to a number of location-based services including logistics vehicle tracking, cellular phone user's location finding, and location-based commerce. Logistics systems typically entail tracking vehicles for purposes of the logistics center knowing the whereabouts of the vehicles and/or consignments. Moreover, storing and managing location trajectory of continuously moving vehicles and consignments is necessary for supporting efficient logistics plan and consignment. The proposed system is able to manage spatial objects in GIS as well as logistic information in the mobile environment. And for the efficiently managing and retrieving of transporting trajectory of logistics, we extend previous moving object indexing method, TB-Tree, to use multi-version framework and evaluate data updating performance. It is able to apply the proposed method to develop mobile contents services based on continuously changing location of moving object in the mobile environment.

  • PDF

Comparative Evaluation of Data Processing Performance between MySQL and Redis (MySQL과 Redis의 데이터 처리 성능 비교 평가)

  • Hyeok Bang;Seo-Hyeon Kim;Sanghoon Jeon
    • Journal of Internet Computing and Services
    • /
    • v.25 no.3
    • /
    • pp.35-41
    • /
    • 2024
  • As online activities have rapidly increased due to recent digital changes and the impact of COVID-19, the importance of large-scale data processing and maintenance is increasing. This study compares the performance of the two main types of databases widely used for data storage and management: Relational Database Management Systems (RDBMS) and Non-Relational Databases (NoSQL). Specifically, we measured and evaluated the execution time of data insertion, query, and deletion functions using MySQL, a representative example of RDBMS, and Redis, a representative example of NoSQL. The experimental results showed that Redis showed performance about 5.84 times faster in data insertion, 6.61 times faster in query, and 12.33 times faster in deletion than MySQL. These results demonstrate that Redis provides superior performance, especially in environments requiring large-scale data processing and maintenance. Therefore, companies and online service providers can choose NoSQL databases such as Redis to ensure more efficient data management solutions. We hope this study will be an essential reference when selecting a database based on data processing performance.

Development of System Requirement Management Database System from User-centered Scenario (사용자 편의를 고려한 시스템 요구사항 관리 데이터베이스 구축)

  • Jin, Moon-Sub;Park, Chan-Young;Choi, Chunho;Chung, Kyung-Ryul
    • Transactions of the KSME C: Technology and Education
    • /
    • v.1 no.2
    • /
    • pp.199-204
    • /
    • 2013
  • In this paper, a new system requirement management tool and its application on the Urban Transit Maglev Project were introduced. In most R&D projects on complexity system such as transportation system, Systems Engineering(SE) activities are included on each project, and SE teams are using commercial computer-based tools to perform the SE activities. Even though SE tools help to manage huge data and documents on engineering efficiently, but well-designed functions of SE tools which support SE activities are not sufficiently used on the whole process of system engineering. In order to computer-based SE tools are to be effectively used on project management, most engineers who takes engineering and coordination roles, at least sub-project managers should be familiar to the tool and could be easily use it, but usability of commercial SE tools are very difficult for normal engineers with no experience on SE activities and SE tools. To overcome this difficulty, we developed a new system requirement management tool considering each user's scenario on using engineering tools. The developed tool could not cover whole SE processes, but designed to perform requirement engineering such as system requirements(SRs) management, specification management, traceability management, SRs' verification activity management and so on. All the entities on SR database are inter-connected by pre-recognized traceabilities, so even non-specialists on SE can easily browse the database and find entities concern, and linked information such as interacted entities, legal or engineering constraints, coordination documents, status of development and verification and so on. Also functions for SR verification tools, TPM(Technical Performance Measure) tools, DB searching tools with traceability, and report generation tools are included on the system.

An SPC-Based Forward-Backward Algorithm for Arrhythmic Beat Detection and Classification

  • Jiang, Bernard C.;Yang, Wen-Hung;Yang, Chi-Yu
    • Industrial Engineering and Management Systems
    • /
    • v.12 no.4
    • /
    • pp.380-388
    • /
    • 2013
  • Large variation in electrocardiogram (ECG) waveforms continues to present challenges in defining R-wave locations in ECG signals. This research presents a procedure to extract the R-wave locations by forward-backward (FB) algorithm and classify the arrhythmic beat conditions by using RR intervals. The FB algorithm shows forward and backward searching rules from QRS onset and eliminates lower-amplitude signals near the baseline using a statistical process control concept. The proposed algorithm was trained the optimal parameters by using MIT-BIH arrhythmia database (MITDB), and it was verified by actual Holter ECG signals from a local hospital. The signals are classified into normal (N) and three arrhythmia beat types including premature ventricular contraction (PVC), ventricular flutter/fibrillation (VF), and second-degree heart block (BII) beat. This work produces 98.54% accuracy in the detection of R-wave location; 98.68% for N beats; 91.17% for PVC beats; and 87.2% for VF beats in the collected Holter ECG signals, and the results are better than what are reported in literature.