• Title/Summary/Keyword: DB 유지관리

Search Result 188, Processing Time 0.031 seconds

Study Growth Environmental Monitoring and Controlling Platform for Hydroponic (양액재배를 위한 생육환경 모니터링 및 제어 플랫폼에 관한 연구)

  • Yeon, In-won;Lee, Won-cheol
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.41 no.9
    • /
    • pp.1132-1140
    • /
    • 2016
  • According to global trend, despite the overall scale of agricultural industry has been downsized, agriculture accommodating cutting-edge ICT technologies has been proliferated, and various timely-issued relevant researches have been on progress to deploy the future food cultivation. In this paper, we propose an effective nutrient management system with web-based monitoring with functionality of controlling temperature, humidity, pH (hydrogen ion), EC (Electric Conductivity), LED and cooling fan to maintain the hydroponic nurturing environment being optimal. In this paper, in order the arduino hardware and java software are employed to control the nurturing environment automatically in optimal fashion. In proposed system, due to the usage of WiFi router with the socket communication and DB-assisted Web server with proper interfaces, it allows to facilitate the management to keep monitoring and controling overall hydroponic nurturing environment. Since the proposed Web-based management system provides the superior reliability, the short nurturing period and the robustness to the pest by controlling LED emitting color rather than conventional system, so it can be applied and appropriate for in-house vegetable factory overcoming limitation of time and location.

A Numerical Analysis Study on the Influence of the Fire Protection System on Evacuation Safety in Apartment Houses (공동주택 건축물 내 화재방호시스템이 피난안전성에 미치는 영향에 대한 수치해석적 연구)

  • Kim, Hak Kyung;Choi, Doo Chan;Lee, Doo Hee;Hwang, Hyun Soo;Kim, Hee Moon
    • Journal of the Society of Disaster Information
    • /
    • v.18 no.1
    • /
    • pp.38-50
    • /
    • 2022
  • Purpose: The goal of this research is to create a numerical analytic database that may assist fire prevention managers and building officials in prioritizing items that need to be addressed in order to improve evacuation safety performance while working within a constrained budget and time frame. Method: It was carried out utilizing the CFD Tool, a quantitative evaluation approach, to assess evacuation safety. One direct staircase-type apartment houses and one corridor-type apartment were chosen to make it. Result: In the fire compartment category, Apartment A's evacuation time was around 130 percent longer than that of sprinkler facilities. Conclusion: Fire prevention managers and building officials feel that starting with a single level and implementing "dwelling unit separations" will increase evacuation safety, and that maintaining fire compartments and sprinkler systems at all times will be effective. Because of the limited characteristics of smoke propagation in corridor-type apartments compared to direct staircase-type flats, it is thought that fire extinguishing equipment should be addressed.

Development of SaaS cloud infrastructure to monitor conditions of wind turbine gearbox (풍력발전기 증속기 상태를 감시하기 위한 SaaS 클라우드 인프라 개발)

  • Lee, Gwang-Se;Choi, Jungchul;Kang, Seung-Jin;Park, Sail;Lee, Jin-jae
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.19 no.9
    • /
    • pp.316-325
    • /
    • 2018
  • In this paper, to integrate distributed IT resources and manage human resource efficiently as purpose of cost reduction, infrastructure of wind turbine monitoring system have been designed and developed on the basis of SaaS cloud. This infrastructure hierarchize data according to related task and services. Softwares to monitor conditions via the infrastructure are also developed. Softwares are made up of DB design, field measurement, data transmission and monitoring programs. The infrastructure is able to monitor conditions from SCADA data and additional sensors. Total time delay from field measurement to monitoring is defined by modeling of step-wise time delay in condition monitoring algorithms. Since vibration data are acquired by measurements of high resolution, the delay is unavoidable and it is essential information for application of O&M program. Monitoring target is gearbox in wind turbine of MW-class and it is operating for 10 years, which means that accurate monitoring is essential for its efficient O&M in the future. The infrastructure is in operation to deal with the gearbox conditions with high resolution of 50 TB data capacity, annually.

An Enhancing Technique for Scan Performance of a Skip List with MVCC (MVCC 지원 스킵 리스트의 범위 탐색 향상 기법)

  • Kim, Leeju;Lee, Eunji
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.20 no.5
    • /
    • pp.107-112
    • /
    • 2020
  • Recently, unstructured data is rapidly being produced based on web-based services. NoSQL systems and key value stores that process unstructured data as key and value pairs are widely used in various applications. In this paper, a study was conducted on a skip list used for in-memory data management in an LSM-tree based key value store. The skip list used in the key value store is an insertion-based skip list that does not allow overwriting and processes all changes only by inserting. This behavior can support Multi-Version Concurrency Control (MVCC), which can simultaneously process multiple read/write requests through snapshot isolation. However, since duplicate keys exist in the skip list, the performance significantly degrades due to unnecessary node visits during a list traverse. In particular, serious overhead occurs when a range query or scan operation that collectively searches a specific range of data occurs. This paper proposes a newly designed Stride SkipList to reduce this overhead. The stride skip list additionally maintains an indexing pointer for the last node of the same key to avoid unnecessary node visits. The proposed scheme is implemented using RocksDB's in-memory component, and the performance evaluation shows that the performance of SCAN operation improves by up to 350 times compared to the existing skip list for various workloads.

History Database Construction for Digital Map Updating System using As-Built Drawings (준공도면을 이용한 수치지형도 갱신시스템의 이력 DB 설계)

  • Yang, Sung-Chul;Kim, Ki-Rack;Yu, Ki-Yun
    • Spatial Information Research
    • /
    • v.17 no.2
    • /
    • pp.183-189
    • /
    • 2009
  • The modification of digital maps because of creation, extinction, and change of topology can be expressed by change of information. But according to complication of society, topology of digital maps and relation with another objects is more complicated. We carry out partial update using as-built drawings to reflect in digital maps efficiently with maintaining accuracy and update. This supplement a weak point of partial update without field surveying. But unlike creation and extinction of file with information or of entire database, when each object is changed, added problem will come like change of raw data and of updating date. So it is necessary that history data about creation, change and extinction of spatial data and attribute data have to be chosen and managed. In this study, we analyze operations of updating system of digital map using as-built drawings, and suggest the history database system.

  • PDF

An Implementation of Realtime Remote-Monitoring System for Distributed Photovoltaic Power Plants (분산형 태양광 발전 시스템을 위한 실시간 원격 모니터링 시스템 구현)

  • Kim, Chang-Joon;Kim, Jung-Ki;Jang, Kyung-Sik
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.19 no.10
    • /
    • pp.2450-2456
    • /
    • 2015
  • In this paper, we propose a real-time remote monitoring system for distributed solar power generation system. The proposed system consists of PVC, UTC, OTC and monitoring server. PVC collects the operational information from the PV's inverter via serial interface. The sensing data is transmitted to the server by wireless communications and stored in the DB server. The PV's status is monitored via UTC, and the operating of PVC and UTC are managed by OTC. In addition, by providing information about the power generated by PV system and failure diagnosis in real time, the proposed system shows the possibility of reducing the maintenance costs and improved failure recovery time.

Development of the GIS Based Pre- and Post-Processing Tool for the Visual MODFLOW Groundwater Flow Modeling (Visual MODFLOW 지하수 유동 모델링을 위한 GIS 기반 전ㆍ후처리기 개발)

  • Kim, Man-Kyu
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.6 no.2
    • /
    • pp.65-79
    • /
    • 2003
  • In this study GIS based pre- and post-processing tool for the Visual MODFLOW that is specific software to model groundwater flow is developed. This tool not only makes input data scientifically but also manages input and output data in terms of the groundwater flow analysis. In addition it can storage project products systematically into Oracle database. The most characteristic figure of this processing tool is to provide the module, which automatically or semi automatically develops various grid cell sizes using GIS ArcView and also produces DXF files reflecting various boundary conditions in the modeling zone. In particular, eminences of this research are to create 3 dimensional hydrogeological structures with 2 dimensional GIS ArcView and to conduct pre- and post- processing along with same topology and data format of the MODFLOW.

  • PDF

A Study on the Application of Data-Mining Techniques into Effective CRM (Customer Relationship Management) for Internet Businesses (인터넷 비즈니스에서 효과적인 소비자 관계관리(Customer Relationship Management)를 위한 데이터 마이닝 기법의 응용에 대한 연구)

  • Kim, Choong-Young;Chang, Nam-Sik;Kim, Sang-Uk
    • Korean Business Review
    • /
    • v.15
    • /
    • pp.79-97
    • /
    • 2002
  • In this study, an analytical CRM for customer segmentation is exercised by integrating and analyzing the customer profile data and the access data to a particular web site. We believe that effective customer segmentation will be possible with a basis of the understanding of customer characteristics as well as behavior on the web. One of the critical tasks in the web data-mining is concerned with both 'how to collect the data from the web in an efficient manner?' and 'how to integrate the data(mostly in a variety of types) effectively for the analysis?' This study proposes a panel approach as an efficient data collection method in the web. For the customer data analysis, OLAF and a tree-structured algorithm are applied in this study. The results of the analysis with both techniques are compared, confirming the previous work which the two techniques are inter-complementary.

  • PDF

A Systematic Literature Review of Data and Analysis Methods Used in HR Analytics Research (국내 HR Analytics 연구에서 활용한 데이터와 분석방법에 대한 체계적문헌고찰)

  • Chung, Jaesam;Cho, Yein;Yang, Hayeong;Jin, Myunghwa;Park, Hyosung;Lee, Jae Young
    • The Journal of the Korea Contents Association
    • /
    • v.22 no.9
    • /
    • pp.614-627
    • /
    • 2022
  • The purpose of this study was to explore the various data and methods employed by HR analytics studies. The researchers selected 78 KCI-indexed empirical articles on HR analytics and categorized them using the Employee Life Cycle framework. This yielded several important findings. First, employee retention has been the most common subject of extant studies, followed by performance management. Second, HR analytics studies have used a variety of data (structured and unstructured) according to their research questions, and the data sources have ranged from organizations' internal systems to national databases. Third, most domestic HR analytics studies have been descriptive and diagnostic, whereas predictive and prescriptive studies have been rare. These results have important theoretical and practical implications for future HR analytics research.

Analysis of the growth environment and fruiting body quality of Pleurotus eryngii cultivated by Smart Farming (큰느타리(새송이)버섯 스마트팜 재배를 통한 생육환경 분석 및 자실체 품질 특성)

  • Kim, Kil-Ja;Kim, Da-Mi;An, Ho-Sub;Choi, Jin-Kyung;Kim, Seon-Gon
    • Journal of Mushroom
    • /
    • v.17 no.4
    • /
    • pp.211-217
    • /
    • 2019
  • Currently, cultivation of mushrooms using the Information and Communication Technology (ICT)-based smart farming technique is increasing rapidly. The main environmental factors for growth of mushrooms are temperature, humidity, carbon dioxide (CO2), and light. Among all the mentioned factors, currently, only temperature has been maintained under automatic control. However, humidity and ventilation are controlled using a timer, based on technical experience.Therefore, in this study, a Pleurotus eryngii first-generation smart farm model was set up that can automatically control temperature, humidity, and ventilation. After installing the environmental control system and the monitoring device, the environmental condition of the mushroom cultivation room and the growth of the fruiting bodies were studied. The data thus obtained was compared to that obtained using the conventional cultivation method.In farm A, the temperature during the primordia formation stage was about 17℃, and was maintained at approximately 16℃ during the fruiting stage. The humidity was initially maintained at 95%, and the farm was not humidified after the primordia formation stage. There was no sensor for CO2 management, and the system was ventilated as required by observing the shape of the pileus and the stipe. It was observed that, the concentration of CO2 was between 700 and 2,500 ppm during the growth period. The average weight of the mushrooms produced in farm A was 125 g, and the quality was between that of the premium and the first grade.In farm B. The CO2 sensor was in use for measurement purposes only; the system was ventilated as required by observing the shape of the pileus and the stipe. During the growth period, the CO2 concentration was observed to be between 640 and 4,500 ppm. The average weight of the mushrooms produced in farm B was 102 g.These results indicate that the quality of the king oyster mushroom is determined by the environmental conditions, especially by the concentration of CO2. Thus, the data obtained in this study can be used as an optimal smart farm model, where, by improving the environmental control method of farm A, better quality mushrooms were obtained.