• Title/Summary/Keyword: inventory DB

Search Result 38, Processing Time 0.029 seconds

Post-Harvest Traceability System of Grain (곡물의 수확후 이력관리시스템)

  • Lee, Hyo-Jae;Kim, Oui-Woong;Ahn, Jae-Whan;Han, Jae-Woong;Kim, Hoon
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.11 no.2
    • /
    • pp.161-168
    • /
    • 2018
  • In this study, IT based traceability system which is able to measure weight and moisture content of grain in the post-harvest process of intake, drying, storage and milling was developed in RPC(Rice processing complex). Measured information of weight, moisture content, yield, loss and quality was saved in the DB sever. Simultaneously, lot No. was generated and connecting to quality and traceability information. Also, automatic control system with MMI(Man Machine Interface) and yield and inventory control system(YICS) for grain was developed for the traceability system by applying the TCP/IP communication. In addition, simulation of system was performed for evaluation in RPC.

AN ASSESSMENT SYSTEM OF ECO-FRIENDLINESS OF CONSTRUCTED FACILITY IN THE DESIGN PHASE USING VALUE ENGINEERING

  • Byung-Soo, Kim;Dong-Eun, Lee;Suk-Hyun, Kwon;Min-Kwon, Choe
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.1625-1629
    • /
    • 2009
  • The new paradigm called 'Low Carbon Green Growth' involved in reducing greenhouse gas is on the rise as a critical issue worldwide. The essential of Kyoto protocol issued in 1997 is to achieve the sustainable economic growth environments by converting existing production system to eco-friendly one. The protocol imposes the liability to reduce greenhouse gas to the countries joined to it. The paradigm is directly involved in the energy consumption and environmental pollution caused by construction activities. Value Engineering which are mainly applied in the design phase in practice is a measure to improve the value of a constructed facility by analyzing and/or appraising the functions and costs of it. However, an appropriate method which assesses eco-friendliness of constructed facility has not been propose by researchers. This paper proposes a method which assesses the performance involved in eco-friendliness of constructed facility using Value Engineering (VE) in the design phase. The method estimates the environmental cost relative to the amounts of energy consumption and environmental pollution occurred over the entire project life cycle. The database called "Life Cycle Inventory DB", which stores information about the amounts of environmental pollution, is used. The algorithm which retrieves the amounts of environmental pollutions from the DB and converts them into environmental costs is developed. The algorithm is implemented into a system which quantifies the eco-friendliness of constructed facility in the design phase using VE.

  • PDF

Development of drought inventory map service module for GIS based drought analysis (GIS 기반 가뭄분석을 위한 가뭄인벤토리 지도서비스 모듈 개발)

  • Lee, Sangmin;Shin, Yonghyeon;Yang, Dongmin
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2021.06a
    • /
    • pp.484-484
    • /
    • 2021
  • 본 연구를 통해 개발된 웹기반 가뭄아틀라스에 탑재되는 가뭄인벤토리 지도서비스 모듈은 GIS기반 가뭄상황관리를 위해 일정 수준의 가공이 필요한 다양한 GIS 가뭄분석정보를 제공하여 가뭄 대응 업무 담당자가 공간에 기반한 가뭄분석 업무에 사용함을 주목적으로 해당 서비스 모듈을 개발하였다. 본 연구를 통해 개발된 지도서비스 모듈은 JAVA 언어로 개발되었으며, 오픈소스 기반의 Geosever와 Openlayer를 적용하여 167개 시군을 대상으로 가뭄 관련 분석지도를 제공하는 서비스 모듈이다. 지도 레이어별 가시화를 통한 중첩분석이 가능하며, 사용자 필요 시 해당 분석지도를 다운로드 받을 수 있도록 개발을 진행하였다. 상세 제공 정보로는 가뭄 분석을 위한 면적정보와 통계정보로 이원화하여 서비스를 제공하며, 개별 가뭄인벤토리 지도는 지역별 차트정보와 속성DB 테이블을 같이 지도화면에 표출한다. 주요기능으로는 가뭄인벤토리 지도서비스 창을 활성화하여 사용자가 필요한 가뭄인벤토리 지도를 체크하면 가뭄아틀라스 지도화면에 가시화된다. 체크된 가뭄인벤토리 지도는 테이블정보 표출과 자료 다운로드 기능을 제공한다. 해당 서비스 모듈의 관리 및 사용 방법으로는 가뭄인벤토리 지도데이터를 GIS 데이터셋화하여 Geoserver에 로딩하며, 로딩된 지도데이터는 WMS(web tilemap service) 포맷으로 변환한 뒤, 각각의 분석지도가 가지고 있는 속성DB정보를 고려해 지도 스타일을 적용하였다. 웹 브라우저 표출방법으로는 Openlayer 기반으로 GeoWebCache를 생성해 가뭄인벤토리 지도를 웹기반 가뭄아틀라스 상에 표출한다.

  • PDF

A Study on Identification and Distribution of the Village Wetland Inventory Based on GIS - Focused on Seocheon-gun Province, Chungnam, Korea - (GIS를 기반으로 한 농촌 마을습지 판별 및 분포 특성 연구 - 충남 서천군을 사례로 -)

  • Park, Miok
    • Journal of Wetlands Research
    • /
    • v.20 no.1
    • /
    • pp.20-26
    • /
    • 2018
  • The purpose of this study is to construct a GIS / DB by grasping a small but ecologically valuable village wetland distribution, and to propose conservation management and wise use plan. The study area is Seocheon-gun, a typical farming village. Firstly, based on the digital topographical map (1:5,000), the Arc-GIS tool was used to identify the provisional(draft) village wetlands. In addition, for the management of village wetlands, wetlands with an area of more or less than $625m^2$ each were derived and according to ecological regions study area was classified into urban areas, inland areas and coastal areas. And finally, according to the wetland identifying indicators, the village wetlands were identified as the final village wetlands through indoor and field trips. The results of the study show that there are 570 village wetlands in Seocheon - gun province, which are 74 in urban areas, 220 in inland areas, and 276 in coastal areas. The case study for village wetland identification was conducted in one out of two urban areas (Seocheon - eup), two of four coastal areas (Biin - myeon and Seo - myeon), and three of seven inland areas (Masan - myeon, Hansan - myeon, and Sicho - myeon). The distribution of village wetlands was found mainly to be a village wetland with an area of less than $625m^2$. In addition, compared with inland areas, the discrimination rate of village wetlands in coastal areas and urban areas was relatively low, indicating that inland areas were still less disturbed, and land use in urban areas and coastal areas is changing rapidly. Especially, land with less awareness such as village wetlands is relatively easily damaged, and management strategy is urgent.

A Study on Database System for Hostorical Booking of Korean Railroad (한국철도의 예약실적 데이터베이스 시스템에 관한 연구)

  • Oh, Seog-Moon;Hwang, Jong-Gyu;Hyeon, Seung-Ho;Kim, Yong-Gyu;Lee, Jong-Woo;Kim, Young-Hoon;Hong, Soon-Heum;Park, Jong-Bin
    • Proceedings of the KIEE Conference
    • /
    • 1998.07a
    • /
    • pp.371-374
    • /
    • 1998
  • The construction of the transportation history database system is to serve the scheduling and seat inventory controling. Recently, lots of countries have been faced with the advance era because of the new railway transportation system, like the high speed railway and/or magnetic levitation vehicle system. This can be reasonably translated as those of operators are willing to provide the more various and high quality schedule to the customer. Those operators these ideas make possible to forecast that scheduling process is going to be complicated more and more. The seat inventory control, so to speak Yield Management System(YMS), goes a long way to improve the total passenger revenue at the railway business. The YMS forecasts the number of the last reservation value(DCP# END) and recommends the optimal values on the seat sales. The history database system contains infra-data(ie, train, seat, sales) that will be the foundation of scheduling and seat inventory control application programs. The development of the application programs are reserved to the next step. The database system is installed on the pc platform (IBM compatible), using the DB2(RDBMS). And at next step, the platform and DBMS will be considered whether they can meet the users' requirement or not.

  • PDF

Life Cycle Assessment of Rural Community Buildings Using OpenLCATM DB (OpenLCATM DB를 이용한 농촌 공동체 건축물 전과정평가)

  • Kim, Yongmin;Lee, Byungjoon;Yoon, Seongsoo
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.63 no.3
    • /
    • pp.97-105
    • /
    • 2021
  • Most of the rural development projects for the welfare of residents are mainly new construction and remodeling projects for community buildings such as village halls and senior citizens. However, in the case of the construction industry, it has been studied that 23% of the total carbon dioxide emissions generated in Korea are generated in the building-related sector. (GGIC, 2015) In order to reduce the emission of environmental pollutants resulting from construction of rural community buildings, there is a need to establish a system for rural buildings by predicting the environmental impact. As a result of this study, the emissions of air pollutants from buildings in rural communities were analyzed by dividing into seven stages: material production, construction, operation, maintenance, demolition, recycling, and transportation activities related to disposal. As a result, 12 kg of carbon dioxide (CO), 0.06 kg of carbon monoxide (CO), 0.02 kg of methane (CH), 0.04 kg of nitrogen oxides (NO), 0.02 kg of sulfurous acid gas (SO), and non-methane volatile organics per 1m of buildings in rural communities It was analyzed that 0.02 kg of compound (NMVOC) and 0.00011 kg of nitrous oxide (NO) were released. This study proved that environmentally friendly design is possible with a quantitative methodology for the comparison of operating energy and air pollutant emissions through the design specification change based on the statement of the rural community building. It is considered that it can function as basic data for further research by collecting major structural changes and materials of rural community buildings.

Evaluation of Environmental Economics on Dismantling Projects Using LCI DB (LCI DB를 활용한 해체공사 환경경제성 평가)

  • Kwon, Suk-Hyun;Kim, Kyong-Ju;Kim, Byung-Soo;Kim, Sang-Beom
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • 2008.11a
    • /
    • pp.233-238
    • /
    • 2008
  • Korea has a high volume of exhaust in environmental pollutants compared to her economic size, which results from the increase of the ratio in high energy consuming industries. There arises an issue that efficient energy saving is not achieved in the related projects of the construction, which is one of the high energy consuming industries. In addition, such projects of dismantling old and decrepit buildings are frequent in recent years. Given the situation, to obtain much better effects of energy saving, it is necessary to build basic databases and develop utilization plans on energy consumption volume, exhaust volume of pollutants, and environmental expenses that come from the dismantlement stages out of the life cycle of construction projects. Therefore, this study calculates the exhaust volume of environmental pollutants, converts it into environmental expenses by pollutants, and evaluates the environmental economics on the projects of dismantling buildings, utilizing LCI DB that is suggested by Ministry of Knowledge Economy and Ministry of Environment. For this purpose, related data research, the existing literature study, and on-the-spot field investigation were conducted. Based on the results of analysis on the collected data, the environmental economics of the target building was evaluated.

  • PDF

Railway industry and Life Cycle Assessment(LCA) (철도산업과 전과정평가(LCA))

  • Jeong In-Tae;Yang Yun-Hee;Lee Kun-Mo;Kim Yong-Gi
    • Proceedings of the KSR Conference
    • /
    • 2005.05a
    • /
    • pp.1028-1032
    • /
    • 2005
  • Life cycle assessment(LCA) has been developed from the concept of life cycle thinking. Life cycle thinking implies that everyone in the whole chain of a product's life cycle, from cradle to grave, has a responsibility and a role to play, taking into account all the relevant external effects. LCA is an analytical tool for identifying environmental loads and assessing the environmental impact in the whole chain of a product's life cycle. In Europe and Japan, LCA and ecodesign study for railway industry have been actively carried out recently. However, LCA for railway industry in domestic is still infant. LCA is standardized in International Organization of Standardization(ISO), base on the ISO 14040 standards, 307 life cycle inventory(LCI) database for infrastructure and base materials have been established in total since 1999. Some of LCI database can use in performing LCA for trains and railway infrastructure, but still not enough to derive accurate LCA result. Therefore, railway oriented LCA methodology and LCI DB are needed to be developed.

  • PDF

Hydrographic Survey Data Processing Sl Automatic Inventory Archiving System for Nautical Chart (해도제작을 위한 해양탐사자료의 처리 및 탐사 기록 자동생성 시스템 개발)

  • 박요섭;김학일
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 1999.11a
    • /
    • pp.218-223
    • /
    • 1999
  • 국제 수로 기구(IHO, International Hydrographic Organization)에서는 해도제작을 위한 해양조사의 기준을 마련하고, 전세계적으로 사용되는 해도의 정확도를 표준화하고 있다. IHO에서는 탐사 기술의 발달을 반영하여, 기존의 단 빔 음향 측심기 이외에도 멀티 빔 음향 측심기(Multibeam Echo Sounder)와 사이드 스캔 소나(Side Scan Sonar)를 이용한 해양 탐사 시에 요구되는 정확도와 탐사 자료에 대한 메타 데이터(Metadata)의 작성을 요구하고 있다. 본 논문은 수로 측량에서 얻어진 측량 자료들의 처리절차와 자료관리 기법에 대한 연구이다. IHO 해양탐사 기준에 맞는 탐사 자료 처리와, 메타 데이터를 자동으로 생성하여 측량자료관리 DB구축 및 관리를 주 기능으로 하는 시스템을 설계하고 구현한다. 특히, 본 논문은 해양 탐사 자료 처리 시스템을 개발하기 위하여, 해양 자료 처리 과정을 표준화하고, 국제적 해양 자료의 교환 표준인 MGD77과 호환 가능한 메타 데이터를 자동 생성하며, 1Hz로 수집되는 GPS 측위자료로부터 특징점(Waypoint)을 정의하고, 이를 추출하여 측심선을 벡터화 (Trackline Vectorizing) 하는 알고리즘을 구현한다. 개발된 시스템은 현재 국립 해양조사원의 해양2000호에서 획득된 탐사자료에 적용, 운영되고 있다.

  • PDF

A Study on Constructing Order-Production System through Integrated E-Mail and Database (E-mail과 DB연계를 통한 주문-생산시스템 구축연구)

  • 정한욱;이창호
    • Journal of the Korea Safety Management & Science
    • /
    • v.2 no.2
    • /
    • pp.155-165
    • /
    • 2000
  • Many enterprises are performing the effective database applications with VAN(Value Added Network) or WAN(Web Added Network) . But it is very difficult and expensive. So we suggest low-cost database system within long distance area through personal computers. This system is very powerful for flexibility. It may be estimated it's value highly because they develop the program without high programming skill. This study would be used between company with company and/or between branch with branch, for example, customer claim information, inventory information, product order etc. It is important not importing document but importing data in document. Then end-user can accomplish analysis and decision-making with their own database. It would enhance productivity in many enterprises.

  • PDF