• Title/Summary/Keyword: database management system

Search Result 2,459, Processing Time 0.028 seconds

Implement of Web-based Remote Monitoring System of Smart Greenhouse (스마트 온실 통합 모니터링 시스템 구축)

  • Dong Eok, Kim;Nou Bog, Park;Sun Jung, Hong;Dong Hyeon, Kang;Young Hoe, Woo;Jong Won, Lee;Yul Kyun, Ahn;Shin Hee, Han
    • Journal of Practical Agriculture & Fisheries Research
    • /
    • v.24 no.4
    • /
    • pp.53-61
    • /
    • 2022
  • Growing agricultural products in greenhouses controlled by creating suitable climatic conditions and root zone of crop has been an important research and application subject. Appropriate environmental conditions in greenhouse are necessary for optimum plant growth improved crop yields. This study aimed to establish web-based remote monitoring system which monitors crops growth environment and status of crop on a real-time basis by applying to greenhouses IT technology connecting greenhouse equipment such as temperature sensors, soil sensors, crop sensors and camera. The measuring items were air temperature, relative humidity, solar radiation, CO2 concentration, EC and pH of nutrient solution, medium temperature, EC of medium, water content of medium, leaf temperature, sap flow, stem diameter, fruit diameter, etc. The developed greenhouse monitoring system was composed of the network system, the data collecting device with sensors, and cameras. Remote monitoring system was implemented in a server/client environment. Information on greenhouse environment and crops is stored in a database. Items on growth and environment is extracted from stored information, could be compared and analyzed. So, A integrated monitoring system for smart greenhouse would be use in application practice and understanding the environment and crop growth for smart greenhouse management. sap flow, stem diameter and pant-water relations

Implementation of Air Pollutant Monitoring System using UAV with Automatic Navigation Flight

  • Shin, Sang-Hoon;Park, Myeong-Chul
    • Journal of the Korea Society of Computer and Information
    • /
    • v.27 no.8
    • /
    • pp.77-84
    • /
    • 2022
  • In this paper, we propose a system for monitoring air pollutants such as fine dust using an unmanned aerial vehicle capable of autonomous navigation. The existing air quality management system used a method of collecting information through a fixed sensor box or through a measurement sensor of a drone using a control device. This has disadvantages in that additional procedures for data collection and transmission must be performed in a limited space and for monitoring. In this paper, to overcome this problem, a GPS module for location information and a PMS7003 module for fine dust measurement are embedded in an unmanned aerial vehicle capable of autonomous navigation through flight information designation, and the collected information is stored in the SD module, and after the flight is completed, press the transmit button. It configures a system of one-stop structure that is stored in a remote database through a smartphone app connected via Bluetooth. In addition, an HTML5-based web monitoring page for real-time monitoring is configured and provided to interested users. The results of this study can be utilized in an environmental monitoring system through an unmanned aerial vehicle, and in the future, various pollutants measuring sensors such as sulfur dioxide and carbon dioxide will be added to develop it into a total environmental control system.

A study on the CRM strategy for medium and small industry of distribution (중소유통업체의 CRM 도입방안에 관한 연구)

  • Kim, Gi-Pyoung
    • Journal of Distribution Science
    • /
    • v.8 no.3
    • /
    • pp.37-47
    • /
    • 2010
  • CRM refers to the operating activities that always maintain and promote good relationship with customers to ultimately maximize the company's profits by understanding the value of customers to meet their demands, establishing a strategy which may maximize the Life Time Value and successfully operating the business by integrating the customer management processes. In our country, many big businesses are introducing CRM initiatively to use it in marketing strategy however, most medium and small sized companies do not understand CRM clearly or they feel difficult to introduce it due to huge investment needed. This study is intended to present CRM promotion strategy and activities plan fit for the medium and small sized companies by analyzing the success factors of the leading companies those have already executed CRM by surveying the precedents to make the distributors out of the industries have close relation with consumers to overcome their weakness in scale and strengthen their competitiveness in such a rapidly changing and fiercely competing market. There are 5 stages to build CRM such as the recognition of the needs of CRM establishment, the establishment of CRM integrated database, the establishment of customer analysis and marketing strategy through data mining, the practical use of customer analysis through data mining and the implementation of response analysis and close loop process. Through the case study of leading companies, CRM is needed in types of businesses where the companies constantly contact their customers. To meet their needs, they assertively analyze their customer information. Through this, they develop their own CRM programs personalized for their customers to provide high quality service products. For customers helping them make profits, the VIP marketing strategy is conducted to keep the customers from breaking their relationships with the companies. Through continuous management, CRM should be executed. In other words, through customer segmentation, the profitability for the customers should be maximized. The maximization of the profitability for the customers is the key to CRM. These are the success factors of the CRM of the distributors in Korea. Firstly, the top management's will power for CS management is needed. Secondly, the culture across the company should be made to respect the customers. Thirdly, specialized customer management and CRM workers should be trained. Fourthly, CRM behaviors should be developed for the whole staff members. Fifthly, CRM should be carried out through systematic cooperation between related departments. To make use of the case study for CRM, the company should understand the customer and establish customer management programs to set the optimal CRM strategy and continuously pursue it according to a long-term plan. For this, according to collected information and customer data, customers should be segmented and the responsive customer system should be designed according to the differentiated strategy according to the class of the customers. In terms of the future CRM, integrated CRM is essential where the customer information gathers together in one place. As the degree of customers' expectation increases a lot, the effective way to meet the customers' expectation should be pursued. As the IT technology improved rapidly, RFID (Radio Frequency Identification) appears. On a real-time basis, information about products and customers is obtained massively in a very short time. A strategy for successful CRM promotion should be improving the organizations in charge of contacting customers, re-planning the customer management processes and establishing the integrated system with the marketing strategy to keep good relation with the customers according to a long-term plan and a proper method suitable to the market conditions and run a company-wide program. In addition, a CRM program should be continuously improved and complemented to meet the company's characteristics. Especially, a strategy for successful CRM for the medium and small sized distributors should be as follows. First, they should change their existing recognition in CRM and keep in-depth care for the customers. Second, they should benchmark the techniques of CRM from the leading companies and find out success points to use. Third, they should seek some methods best suited for their particular conditions by achieving the ideas combining their own strong points with marketing. Fourth, a CRM model should be developed that will promote relationship with individual customers just like the precedents of small sized businesses in Switzerland through small but noticeable events.

  • PDF

Data issue and Improvement Direction for Marine Spatial Planning (해양공간계획 지원을 위한 정보 현안 및 개선 방향 연구)

  • CHANG, Min-Chol;PARK, Byung-Moon;CHOI, Yun-Soo;CHOI, Hee-Jung;KIM, Tae-Hoon;LEE, Bang-Hee
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.21 no.4
    • /
    • pp.175-190
    • /
    • 2018
  • Recently, policy of the marine advanced countries were switched from the preemption using ocean to post-project development. In this study, we suggest improvement and the pending issues when are deducted to the database of the marine spatial information is constructed over the GIS system for the Korean Marine Spatial Planning (KMSP). More than 250 spatial information in the seas of Korea were processed in order of data collection, GIS transformation, data analysis and processing, data grouping, and space mapping. It's process had some problem occurred to error of coordinate system, digitizing process for lack of the spatial information, performed by overlapping for the original marine spatial information, and so on. Moreover, solution is needed to data processing methods excluding personal information which is necessary when produce the spatial data for analysis of the used marine status and minimized method for different between the spatial information based GIS system and the based real information. Therefore, collection and securing system of lacking marine spatial information is enhanced for marine spatial planning. it is necessary to link and expand marine fisheries survey system. It is needed to the marine spatial planning. The marine spatial planning is required to the evaluation index of marine spatial and detailed marine spatial map. In addition, Marine spatial planning is needed to standard guideline and system of quality management. This standard guideline generate to phase for production, processing, analysis, and utilization. Also, the quality management system improve for the information quality of marine spatial information. Finally, we suggest necessity need for the depths study which is considered as opening extension of the marine spatial information and deduction on application model.

Crepe Search System Design using Web Crawling (웹 크롤링 이용한 크레페 검색 시스템 설계)

  • Kim, Hyo-Jong;Han, Kun-Hee;Shin, Seung-Soo
    • Journal of Digital Convergence
    • /
    • v.15 no.11
    • /
    • pp.261-269
    • /
    • 2017
  • The purpose of this paper is to provide a search system using a method of accessing the web in real time without using a database server in order to guarantee the up-to-date information in a single network, rather than using a plurality of bots connected by a wide area network Design. The method of the research is to design and analyze the system which can search the person and keyword quickly and accurately in crepe system. In the crepe server, when the user registers information, the body tag matching conversion process stores all the information as it is, since various styles are applied to each user, such as a font, a font size, and a color. The crepe server does not cause a problem of body tag matching. However, when executing the crepe retrieval system, the style and characteristics of users can not be formalized. This problem can be solved by using the html_img_parser function and the Go language html parser package. By applying queues and multiple threads to a general-purpose web crawler, rather than a web crawler design that targets a specific site, it is possible to utilize a multiplier that quickly and efficiently searches and collects various web sites in various applications.

Development of a new Model and Methodology for the Analysis of the Performance Evaluation of G2B Systems in e-government: EEM (전자정부 G2B 시스템의 성과평가 분석을 위한 새로운 평가 모델 및 방법론 개발)

  • Lim, Gyoo-Gun;Lee, Jae-Kyu;Lee, Dae-Chul
    • Information Systems Review
    • /
    • v.10 no.2
    • /
    • pp.269-289
    • /
    • 2008
  • It is very difficult problem to estimate and evaluate the performance of e-government system which scope and size are large and its effectiveness can not be seen shortly but reveals after several years. It is because the previous offline processes can not be transformed to online ones fully and shortly. For such e-transformation cases, the performance evaluation model should be adjusted and modified gradually as time passes. This paper propose new EEM(E-transformation Evaluation Model) model and methodology to evaluate G2B system that is one of large e-government project. EEM model can derive monetary value of e-transformatized business process areas(online areas). It also estimate the expected effect of offline area that is not yet transformed to online. EEM model consists of standard model, verification model and estimation model with some variables such as evaluation year, evaluation area and data type. By using survey data and database data together it can validate the correctness of the model and derive the effect of the system introduction. This paper also propose EEM evaluation methodology consisting of 5 stages and 10 sub processes to evaluate online and offline effect efficiently. To show the usefulness of this study, we evaluate the performance of Korea G2B system named KONEPS which is famous as a successful e-government case in the world by using the proposed model and methodology. The proposed model and methodology can be applied to different similar areas including e-government projects and large scale information system introduction in private sectors. This study can be also used for establishing appropriate policies about e-government project and informatization issues.

Upper Garment Sizing System for Obese School Boys Based on Somatotype Analysis (학령후기 비만 남아의 체형 분석에 따른 plus-size 남자 아동복 상의 치수 규격 제안)

  • Park, Soon-Jee
    • Journal of the Korean Home Economics Association
    • /
    • v.46 no.9
    • /
    • pp.99-112
    • /
    • 2008
  • The increasing rate of obesity in school aged children has become a conspicuous social phenomenon in Korea. This has been linked to greater economic growth, increasingly westernized dietary habits, and a consumer driven society. Given that obesity can lead to social exclusion or unfavorable attention by other students in a school setting, the design of plus-size garments have become important for effective appearance management skills. This research aimed to establish a somatotype database for obese school boys, aged 10 to 12, in order to develop a sizing system for plus-size upper garments. In order to measure somatotype of average and obese school boys, five categories were recorded; height, obesity, length of trunk, thickness of neck and chest. For obese boys, subcutaneous fat thickness and position of B.P/shoulder point factors were recorded. Obesity factor was subdivided into overall and specific ones, and while the deviation of obese body types was severe compared to the average type. Obese body type showed significantly higher measurements in width, girth, thickness. This is linked to the fact that the frequency ratio of obesity increases with age. Stature and chest were chosen as control dimensions for boys' wear. As crosstabulation of stature(5cm interval) and chest girth(2, 3 and 4cm), and stature(5cm interval)/chest girth(3cm interval) sizing system showed, the most effective cover ratio and adaptability to the data distribution $25{\sim}75$ quartile. Based on the findings, 10 sizes were formulated for average body type, while 18 sizes were formulated for obese type, whose size cover ratios were 48% and 62.9%, respectively. The primary ranges of stature were $145cm{\sim}150cm$, while those of chest girth were $79{\sim}82cm$. Each size was declared as "chest-somatotype{A(average)/O(obesity)-stature". This study proposed a plus-size upper garment sizing systems for obese boys, accompanied with reference measurements for suit, casual wear and underwear. The finding showed that the two systems were totally separate and not overlapping, meaning that plus-size sizing system is essential for obese school boys. The obesity type system had more size and wider range specs.

A Comparative Study on the Object Detection of Deposited Marine Debris (DMD) Using YOLOv5 and YOLOv7 Models (YOLOv5와 YOLOv7 모델을 이용한 해양침적쓰레기 객체탐지 비교평가)

  • Park, Ganghyun;Youn, Youjeong;Kang, Jonggu;Kim, Geunah;Choi, Soyeon;Jang, Seonwoong;Bak, Suho;Gong, Shinwoo;Kwak, Jiwoo;Lee, Yangwon
    • Korean Journal of Remote Sensing
    • /
    • v.38 no.6_2
    • /
    • pp.1643-1652
    • /
    • 2022
  • Deposited Marine Debris(DMD) can negatively affect marine ecosystems, fishery resources, and maritime safety and is mainly detected by sonar sensors, lifting frames, and divers. Considering the limitation of cost and time, recent efforts are being made by integrating underwater images and artificial intelligence (AI). We conducted a comparative study of You Only Look Once Version 5 (YOLOv5) and You Only Look Once Version 7 (YOLOv7) models to detect DMD from underwater images for more accurate and efficient management of DMD. For the detection of the DMD objects such as glass, metal, fish traps, tires, wood, and plastic, the two models showed a performance of over 0.85 in terms of Mean Average Precision (mAP@0.5). A more objective evaluation and an improvement of the models are expected with the construction of an extensive image database.

Suitable clothing recommendation system by size and skin color (의류 사이즈별 및 피부톤에 기반을 둔 의류 추천 시스템)

  • Park, Chang-Young;Lim, Byeong-Chan;Lee, Won-Joon;Lee, Chang-Su;Kim, Min-Su;Lee, Sang-Yong
    • Journal of Digital Convergence
    • /
    • v.20 no.3
    • /
    • pp.407-413
    • /
    • 2022
  • Existing clothing recommendation systems remain at the level of showing appropriate photos when a user selects a type of clothing he or she likes after entering his or her own body size or body size. When a user purchases clothing using such recommendation systems, there are many cases in which it does not fit or does not fit the user's body size. In this study, to solve these problems of existing clothing recommendation systems, a system was implemented in which the user receives not only size but also skin tone and recommends clothing suitable for the user's body size as well as skin tone. In this system, clothing size information obtained through web crawling was periodically stored in a database for eight male tops to recommend clothing, and the entire pixel of the clothing image was analyzed to extract color text values. In order to confirm the performance of this system, a survey was conducted on 100 male college students, and the satisfaction level was 70%. Most of the reasons for not being satisfied are that the recommended clothing is limited, so it is judged that it is necessary to expand the target clothing in the future.

Progress and Land-Use Characteristics of Urban Sprawl in Busan Metropolitan City using Remote Sensing and GIS (원격탐사와 GIS를 이용한 부산광역시 도시화지역의 확산과정과 토지이용 특성에 관한 연구)

  • Park, Ho-Myung;Baek, Tae-Kyung
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.12 no.2
    • /
    • pp.23-33
    • /
    • 2009
  • Satellite image is very usefully practiced to predict and analyze physical expansion and change of city. Physical expansion and change of city is closely related to the use of land, and continuous growth management focused on the use of land is essential for sustainable city growth. In this research, the change of land cover and land-use were analyzed with basic input data from 1985 to 2000 according to artificial satellite. Moreover, the land-use turnover rate was understood and expansion trend of urban sprawl in Busan metropolitan city and land-use characteristics of the expansion area. The results are, first, the area for urban region was expanded continuously but areas for agriculture area, forest area, and water area had different changes due to administrative district reform of Busan by each year. Second, the urbanization area in Busan was increased by 3.8% from $92.5km^2$ in 1985 to $167.5km^2$ in 2000. Third, the result of analysis on land-use turnover rate showed that agriculture area was turned into urbanized area the most, and forest area was followed by. Fourth, the result of analysis on database and overlay of buildings in Busan established in 2001 showed that agriculture area are had type 1 and 2 neighborhood living facilities (45.63%), apartment house in forest area (18.49%), and factory in water area (31.84%) with high ratio.

  • PDF