• Title/Summary/Keyword: Database Management Systems

Search Result 1,025, Processing Time 0.032 seconds

A Benchmarking Study for Deriving Data-driven Asset Management Strategy: U.S. Federal Transit Administration (FTA) Case (데이터 기반 노후 철도시설 자산관리 전략 도출을 위한 벤치마킹 연구)

  • Baek, Seungwon;Yoo, Minkyung;Yun, Sungmin
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.41 no.5
    • /
    • pp.591-599
    • /
    • 2021
  • Rail transit agencies in Korea have been struggling to set up a performance-based rail facility maintenance plan because there are no formal definition and decision criteria for aging infrastructure. This study investigates the definition of aging infrastructure through extensive literature review and identifies benchmarking criteria through comparison with rail transit facility management systems in Korea and United States. As results, an aging infrastructure should be defined considering both service age and performance level of a facility. The priority of repair/replacement should be also determined with reasonable criteria based on relationship between service age and performance level. To determine the definition and decision criteria, a practicable classification system for aging rail transit needs to be established in accordance with classification system for performance assessment. Furthermore, a comprehensive database needs to be built including useful life, performance level, and maintenance cost of each component of rail transit. It will allow establishing an efficient budget execution plan for aging infrastructure.

Design and Implementation of Deep Learning Models for Predicting Energy Usage by Device per Household (가구당 기기별 에너지 사용량 예측을 위한 딥러닝 모델의 설계 및 구현)

  • Lee, JuHui;Lee, KangYoon
    • The Journal of Bigdata
    • /
    • v.6 no.1
    • /
    • pp.127-132
    • /
    • 2021
  • Korea is both a resource-poor country and a energy-consuming country. In addition, the use and dependence on electricity is very high, and more than 20% of total energy use is consumed in buildings. As research on deep learning and machine learning is active, research is underway to apply various algorithms to energy efficiency fields, and the introduction of building energy management systems (BEMS) for efficient energy management is increasing. In this paper, we constructed a database based on energy usage by device per household directly collected using smart plugs. We also implement algorithms that effectively analyze and predict the data collected using RNN and LSTM models. In the future, this data can be applied to analysis of power consumption patterns beyond prediction of energy consumption. This can help improve energy efficiency and is expected to help manage effective power usage through prediction of future data.

Sustainable Management of Irrigation Water Withdrawal in Major River Basins by Implementing the Irrigation Module of Community Land Model

  • Manas Ranjan Panda;Yeonjoo Kim
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2023.05a
    • /
    • pp.185-185
    • /
    • 2023
  • Agricultural water demand is considered as the major sector of water withdrawal due to irrigation. The majority part of the global agricultural field depends on various irrigation techniques. Therefore, a timely and sufficient supply of water is the most important requirement for agriculture. Irrigation is implemented in different ways in various land surface models, it can be modeled empirically based on observed irrigation rates or by calculating water supply and demand. Certain models can also calculate the irrigation demand as per the soil water deficit. In these implementations, irrigation is typically applied uniformly over the irrigated land regardless of crop types or irrigation techniques. Whereas, the latest version of Community Land Model (CLM) in the Community Terrestrial Systems Model (CTSM) uses a global distribution map of irrigation with 64 crop functional types (CFTs) to simulate the irrigation water demand. It can estimate irrigation water withdrawal from different sources and the amount or the areas irrigated with different irrigation techniques. Hence, we set up the model for the simulation period of 16 years from 2000 to 2015 to analyze the global irrigation demand at a spatial resolution of 1.9° × 2.5°. The simulated irrigation water demand is evaluated with the available observation data from FAO AQUASTAT database at the country scale. With the evaluated model, this study aims to suggest new sustainable scenarios for the ratios of irrigation water withdrawal, high depending on the withdrawal sources e.g. surface water and groundwater. With such scenarios, the CFT maps are considered as the determining factor for selecting the areas where the crop pattern can be altered for a sustainable irrigation water management depending on the available withdrawal sources. Overall, our study demonstrate that the scenarios for the future sustainable water resources management in terms of irrigation water withdrawal from the both the surface water and groundwater sources may overcome the excessive stress on exploiting the groundwater in major river basins globally.

  • PDF

A Comprehensive Computer Program for Monitor Unit Calculation and Beam Data Management: Independent Verification of Radiation Treatment Planning Systems (방사선치료계획시스템의 독립적 검증을 위한 선량 계산 및 빔데이터 관리 프로그램)

  • Kim, Hee-Jung;Park, Yang-Kyun;Park, Jong-Min;Choi, Chang-Heon;Kim, Jung-In;Lee, Sang-Won;Oh, Heon-Jin;Lim, Chun-Il;Kim, Il-Han;Ye, Sung-Joon
    • Progress in Medical Physics
    • /
    • v.19 no.4
    • /
    • pp.231-240
    • /
    • 2008
  • We developed a user-friendly program to independently verify monitor units (MUs) calculated by radiation treatment planning systems (RTPS), as well as to manage beam database in clinic. The off-axis factor, beam hardening effect, inhomogeneity correction, and the different depth correction were incorporated into the program algorithm to improve the accuracy in calculated MUs. A beam database in the program was supposed to use measured data from routine quality assurance (QA) processes for timely update. To enhance user's convenience, a graphic user interface (GUI) was developed by using Visual Basic for Application. In order to evaluate the accuracy of the program for various treatment conditions, the MU comparisons were made for 213 cases of phantom and for 108 cases of 17 patients treated by 3D conformal radiation therapy. The MUs calculated by the program and calculated by the RTPS showed a fair agreement within ${\pm}3%$ for the phantom and ${\pm}5%$ for the patient, except for the cases of extreme inhomogeneity. By using Visual Basic for Application and Microsoft Excel worksheet interface, the program can automatically generate beam data book for clinical reference and the comparison template for the beam data management. The program developed in this study can be used to verify the accuracy of RTPS for various treatment conditions and thus can be used as a tool of routine RTPS QA, as well as independent MU checks. In addition, its beam database management interface can update beam data periodically and thus can be used to monitor multiple beam databases efficiently.

  • PDF

Establishing and Operating a Test Bench for Assessment of Pesticide Drift by Aerial Application (항공 살포에 의한 농약 비산 측정 및 평가를 위한 시험 농경지 구축 및 운영)

  • Jinseon Park;Se-Yeon Lee;Lak-Yeong Choi;Daniel Kenidh Favour;Se-woon Hong
    • Journal of Bio-Environment Control
    • /
    • v.32 no.4
    • /
    • pp.423-433
    • /
    • 2023
  • As aerial application increasing, with social concerning in pesticide drift rises, so this study attempts to establish a test bench that can repeatedly and continuously evaluate this. To this end, this study first analyze ISO 22866 and ASABE S561.1 among the international standard test methods related to pesticide fugitive evaluation. A test bench was established at the Naju practice field of Chonnam National University in accordance with international standards, and field tests were carried out (ISO 22866, ASABE S561.1) to verify effectiveness. A test bench that established in this study and a pesticide drift recovery protocol by aerial application can improve the experimental environment where field experiments were complex and it was difficult to achieve the same conditions. In addition, it will be possible to construct a database of pesticide drift that takes into account various factors that affect pesticide drift substances, which is expected to improve the reliability of the data, as well as quantitative evaluation of pesticide drift in the air.

The Behavioral Attitude of Financial Firms' Employees on the Customer Information Security in Korea (금융회사의 고객정보보호에 대한 내부직원의 태도 연구)

  • Jung, Woo-Jin;Shin, Yu-Hyung;Lee, Sang-Yong Tom
    • Asia pacific journal of information systems
    • /
    • v.22 no.1
    • /
    • pp.53-77
    • /
    • 2012
  • Financial firms, especially large scaled firms such as KB bank, NH bank, Samsung Card, Hana SK Card, Hyundai Capital, Shinhan Card, etc. should be securely dealing with the personal financial information. Indeed, people have tended to believe that those big financial companies are relatively safer in terms of information security than typical small and medium sized firms in other industries. However, the recent incidents of personal information privacy invasion showed that this may not be true. Financial firms have increased the investment of information protection and security, and they are trying to prevent the information privacy invasion accidents by doing all the necessary efforts. This paper studies how effectively a financial firm will be able to avoid personal financial information privacy invasion that may be deliberately caused by internal staffs. Although there are several literatures relating to information security, to our knowledge, this is the first study to focus on the behavior of internal staffs. The big financial firms are doing variety of information security activities to protect personal information. This study is to confirm what types of such activities actually work well. The primary research model of this paper is based on Theory of Planned Behavior (TPB) that describes the rational choice of human behavior. Also, a variety of activities to protect the personal information of financial firms, especially credit card companies with the most customer information, were modeled by the four-step process Security Action Cycle (SAC) that Straub and Welke (1998) claimed. Through this proposed conceptual research model, we study whether information security activities of each step could suppress personal information abuse. Also, by measuring the morality of internal staffs, we checked whether the act of information privacy invasion caused by internal staff is in fact a serious criminal behavior or just a kind of unethical behavior. In addition, we also checked whether there was the cognition difference of the moral level between internal staffs and the customers. Research subjects were customer call center operators in one of the big credit card company. We have used multiple regression analysis. Our results showed that the punishment of the remedy activities, among the firm's information security activities, had the most obvious effects of preventing the information abuse (or privacy invasion) by internal staff. Somewhat effective tools were the prevention activities that limited the physical accessibility of non-authorities to the system of customers' personal information database. Some examples of the prevention activities are to make the procedure of access rights complex and to enhance security instrument. We also found that 'the unnecessary information searches out of work' as the behavior of information abuse occurred frequently by internal staffs. They perceived these behaviors somewhat minor criminal or just unethical action rather than a serious criminal behavior. Also, there existed the big cognition difference of the moral level between internal staffs and the public (customers). Based on the findings of our research, we should expect that this paper help practically to prevent privacy invasion and to protect personal information properly by raising the effectiveness of information security activities of finance firms. Also, we expect that our suggestions can be utilized to effectively improve personnel management and to cope with internal security threats in the overall information security management system.

  • PDF

Augmented Reality (AR)-Based Sensor Location Recognition and Data Visualization Technique for Structural Health Monitoring (구조물 건전성 모니터링을 위한 증강현실 기반 센서 위치인식 및 데이터시각화 기술)

  • Park, Woong Ki;Lee, Chang Gil;Park, Seung Hee;You, Young Jun;Park, Ki Tae
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.17 no.2
    • /
    • pp.1-9
    • /
    • 2013
  • In recent years, numerous mega-size and complex civil infrastructures have been constructed worldwide. For the more precise construction and maintenance process management of these civil infrastructures, the application of a variety of smart sensor-based structural health monitoring (SHM) systems is required. The efficient management of both sensors and collected databases is also very important. Recently, several kinds of database access technologies using Quick Response (QR) code and Augmented Reality (AR) applications have been developed. These technologies provide software tools incorporated with mobile devices, such as smart phone, tablet PC and smart pad systems, so that databases can be accessed very quickly and easily. In this paper, an AR-based structural health monitoring technique is suggested for sensor management and the efficient access of databases collected from sensor networks that are distributed at target structures. The global positioning system (GPS) in mobile devices simultaneously recognizes the user location and sensor location, and calculates the distance between the two locations. In addition, the processed health monitoring results are sent from a main server to the user's mobile device, via the RSS (really simple syndication) feed format. It can be confirmed that the AR-based structural health monitoring technique is very useful for the real-time construction process management of numerous mega-size and complex civil infrastructures.

Comparison of the Practical Use Condition of e-finance Portal Site between Korea and U.S.A. (한.미간 e-finance 금융포털사이트의 활용실태 비교)

  • Kim Dong-Gyoon;Cha Soon-Kwean
    • Management & Information Systems Review
    • /
    • v.7
    • /
    • pp.21-51
    • /
    • 2001
  • For increasing the competitiveness and efficiency of Korea's finance industry under the new e-finance paradigm, this paper compared the practical use of finance portal site' on service parts and stage between Korea and U.S.A.. The services which can be served from site are banking, mortgage and credit loan, stock, card, retirement tax, PFM(Personal Finance Management), EBPP(Electronic Bill Presentment and Payment) and Account Aggregation and so on. The stage of site can be divided as the information provide stage which only gives information about service parts, on-line transaction stage which real-time transaction is possibile and PFM services provide stage according to development process. As a result, the beginning of finance portal service in Korea was lated about 10years and more than it of U.S.A. So the development stage of domestic portal site is still staying in the first step and the providing services and contents or business model development parts are also in the same stage than U.S.A. Resides, Korea's sites mainly focus on their first service parts even though they recently aim internet finance portal, and provide not real time transaction but finance information. On the other hand, the U.S.A. site support substantially not only various on-line transactions but also distinctive personal services like PFM(Personal Finance Management), EBPP(Electronic Bill Presentment and Payment), Account Aggregation and Trans-account, brokerage, education center, mortgage loan, mutual fund, option, pension fund and IPOs and so on. Thus, the site of Korea need to establish real type of internet finance portal which provides one-stop services on every type of finance to customers in the real time and also require the strategic integration among finance institutions. The next turn, they need to build information system and education center to give best satisfaction to customers and acquire customer information and marker environment changes and need to provide distinctive services to quality customers throughout database from this. Also the site should provide various type of banking services which refereed above like PEM, EBPP and education center etc, and the government of Korea should support the building of IT infrastructure to Physical, legal, systematic, sociocultural, technical and human resource sections. This paper provided the future movement direction of the domestic finance portal through comparison and analysis on the practical use of it between Korea and U.S.A. and also wanted to contribute for developing and reading of Korea finance portal in the new era of the finance paradigm.

  • PDF

A Study on the Improvement of River Management System Based on Riverbed Change Data Management Program for Utilization of Advanced Bathymetry Data (선진화된 하천측량자료 활용 및 관리를 위한 하상변동 자료관리 프로그램 기반의 하도유지관리체계 개선에 관한 연구)

  • Jo, Myung-Hee;Kim, Kyung-Jun;Kim, Hyun-Jung
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.16 no.3
    • /
    • pp.115-125
    • /
    • 2013
  • The systematic management of river is difficult due to various environmental factors such as season and terrain deformation. Especially, river terrain are rapidly changing by natural and anthropogenic factors such as torrential rain during the summer and river development projects. Thus in this conditions, building the advanced river management system is an essential condition to support the ongoing management of survey data and to acquire data regularly through river terrain survey in order to maintain an active river. The need to build an efficient system have been increased through the enhancement and advancement of River Management Geographic Information Systems(RIMGIS). In this study, database design system and Riverbed Change Data Management Program was developed for systematic management of new river terrain survey data and the efficient use of river data dynamic changes. The key features are construction of river survey data, cross and longitudinal section monitoring and analysis of riverbed change data. Maintenance tasks which can be utilized in river-based architecture was constructed. The expected results are to be able to manage river systematically, and utilization of river topographic survey data efficiently for river maintenance work.

The Efficiency Analysis of CRM System in the Hotel Industry Using DEA (DEA를 이용한 호텔 관광 서비스 업계의 CRM 도입 효율성 분석)

  • Kim, Tai-Young;Seol, Kyung-Jin;Kwak, Young-Dai
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.1
    • /
    • pp.91-110
    • /
    • 2011
  • This paper analyzes the cases where the hotels have increased their services and enhanced their work process through IT solutions to cope with computerization globalization. Also the cases have been studies where national hotels use the CRM solution internally to respond effectively to customers requests, increase customer analysis, and build marketing strategies. In particular, this study discusses the introduction of the CRM solutions and CRM sales business and marketing services using a process for utilizing the presumed, CRM by introducing effective DEA(Data Envelopment Analysis). First, the comparison has done regarding the relative efficiency of L Company with the CCR model, then compared L Company's restaurants and facilities' effectiveness through BCC model. L Company reached a conclusion that it is important to precisely create and manage sales data which are the preliminary data for CRM, and for that reason it made it possible to save sales data generated by POS system on each sales performance database. In order to do that, it newly established Oracle POS system and LORIS POS system concerned with restaurants for food and beverage as well as rooms, and made it possible to stably generate and manage sales data and manage. Moreover, it set up a composite database to control comprehensively the results of work processes during a specific period by collecting customer registration information and made it possible to systematically control the information on sales performances. By establishing a system which unifies database and managing it comprehensively, impeccability of data has been greatly enhanced and a problem which generated asymmetric data could be thoroughly solved. Using data accumulated on the comprehensive database, sales data can be analyzed, categorized, classified through data mining engine imbedded in Polaris CRM and the results can be organized on data mart to provide them in the form of CRM application data. By transforming original sales data into forms which are easy to handle and saving them on data mart separately, it enabled acquiring well-organized data with ease when engaging in various marketing operations, holding a morning meeting and working on decision-making. By using summarized data at data mart, it was possible to process marketing operations such as telemarketing, direct mailing, internet marketing service and service product developments for perceived customers; moreover, information on customer perceptions which is one of CRM's end-products could feed back into the comprehensive database. This research was undertaken to find out how effectively CRM has been employed by comparing and analyzing the management performance of each enterprise site and store after introducing CRM to Hotel enterprises using DEA technique. According to the research results, efficiency evaluation for each site was calculated through input and output factors to find out comparative CRM system usage efficiency of L's Company four sites; moreover, with regard to stores, the sizes of workforce and budget application show a huge difference and so does the each store efficiency. Furthermore, by using the DEA technique, it could assess which sites have comparatively high efficiency and which don't by comparing and evaluating hotel enterprises IT project outcomes such as CRM introduction using the CCR model for each site of the related enterprises. By using the BCC model, it could comparatively evaluate the outcome of CRM usage at each store of A site, which is representative of L Company, and as a result, it could figure out which stores maintain high efficiency in using CRM and which don't. It analyzed the cases of CRM introduction at L Company, which is a hotel enterprise, and precisely evaluated them through DEA. L Company analyzed the customer analysis system by introducing CRM and achieved to provide customers identified through client analysis data with one to one tailored services. Moreover, it could come up with a plan to differentiate the service for customers who revisit by assessing customer discernment rate. As tasks to be solved in the future, it is required to do research on the process analysis which can lead to a specific outcome such as increased sales volumes by carrying on test marketing, target marketing using CRM. Furthermore, it is also necessary to do research on efficiency evaluation in accordance with linkages between other IT solutions such as ERP and CRM system.