• Title/Summary/Keyword: database management system

Search Result 2,458, Processing Time 0.027 seconds

Development of Composite Sensing Technology Using Internet of Things (IoT) for LID Facility Management (LID 시설 관리를 위한 사물인터넷(IoT) 활용 복합 센싱 적용기술 개발)

  • Lee, Seungjae;Jeon, Minsu;Lee, Jungmin;Kim, Lee-Hyung
    • Journal of Wetlands Research
    • /
    • v.22 no.4
    • /
    • pp.312-320
    • /
    • 2020
  • Various LIDs with natural water circulation function are applied to reduce urban environmental problems and environmental impact of development projects. However, excessive Infiltration and evaporation of LID facilities dry the LID internal soil, thus reducing plant and microbial activity and reducing environmental re duction ability. The purpose of this study was to develop a real-time measurement system with complex sensors to derive the management plan of LID facilities. The test of measurable sensors and Internet of Things (IoT) application was conducted in artificial wetlands shaped in acrylic boxes. The applied sensors were intended to be built at a low cost considering the distributed LID and were based on Arduino and Raspberry Pi, which are relatively inexpensive and commercialized. In addition, the goal was to develop complex sensor measurements to analyze the current state o f LID facilities and the effects of maintenance and abnormal weather conditions. Sensors are required to measure wind direction, wind speed, rainfall, carbon dioxide, Micro-dust, temperature and humidity, acidity, and location information in real time. Data collection devices, storage server programs, and operation programs for PC and mobile devices were developed to collect, transmit and check the results of measured data from applied sensors. The measurements obtained through each sensor are passed through the Wifi module to the management server and stored on the database server in real time. Analysis of the four-month measurement result values conducted in this study confirmed the stability and applicability of ICT technology application to LID facilities. Real-time measured values are found to be able to utilize big data to evaluate the functions of LID facilities and derive maintenance measures.

Improvement of the Calculation Standard for Prolongation cost of Domestic Public Construction Project (국내 공공 공사 공기연장 간접비 산정 기준 개선방안 - 국가계약법 및 지방계약법 산정기준의 비교 고찰 -)

  • Jeong, Kichang;Lee, Jaeseob
    • Korean Journal of Construction Engineering and Management
    • /
    • v.17 no.4
    • /
    • pp.95-102
    • /
    • 2016
  • Recently, a research regarding calculation of construction time extension-oriented incidental costs has been intensively suggested in quantitative aspect and recent studies on system improvement has been made continuously. In the case of Domestic Public Construction Works, State Contract Act is applied when the client is government whereas Local Government Contract Act is done when the client is local government, but more meticulous study is required because improvement plan is not proposed even there is a clear demand for improvement of these problems on calculation standard. Thus this study suggested appropriate standard by comparing each the calculation standards followed by 'State Contract Act' and 'Local Government Contract Act', considering the problems accorded, and analyzing field cases. Calculation method of other expenses was differently regulated as the revision of each regulation, and this demonstrates that there is a difference of actual cost from 12.37% to 24.95%. It is shown that less cost of construction time were calculated than actual cost according to a problem of calculation method by State Contract Act as the rate at the time of contract to be applied in other expense rate. This study suggested the rate against incidental cost and the rate of other expense per day against total construction cost as an appropriate rate calculation for other expense based on field database.

A Study of the Plan for Library Operation and Curation Provision as a Community Memory Preservation Center (공동체 기억보존센터로서의 도서관 운영 및 큐레이션 제공 방안 연구)

  • Kwak, Woojung;Noh, Younghee
    • Journal of the Korean BIBLIA Society for library and Information Science
    • /
    • v.31 no.2
    • /
    • pp.53-70
    • /
    • 2020
  • This study was intended to present the need for building the library as a hub of the community memory preservation which provides the collection, sharing, and curation services of the locality specific historical and local data based on the policy task, namely supporting the collection, preservation, and management system of the community's life memory. To this end, the current status of data collection, management, and operation of institutions serving regional-based materials such as cultural centers and regional archives was grasped, and the cases and status of curation services in libraries were investigated and analyzed. The discussion proposed via the results of the study are as follows. First, to the culture center, external demand has been increased from the aspect of social education including festivals, cultural and art event, cultural and art educational business, art activities business of local residents and managerial business is to be carried out, which makes it difficult for the culture center to manage its businesses. Accordingly, it is necessary to collect and preserve regional various data at the pubic libraries playing various roles including provision of informative services, cultural programs and information sharing places to local residents and provision of services to vulnerable social group. As the existing libraries have a plan to collect data systematically, it is considered that those libraries will smoothly operate the data management through cooperation with existing culture centers and various cultural organizations. Second, it appears that a plan will be needed to set up all the data including the ones owned by libraries, local administrative agencies, individuals and other competent agencies in online database so that they are easily available to the public and always available in the libraries because there are a lot of data which cannot be moved to other place and it is actually difficult to concentrate and set up all the data to those libraries.

Periodic Characteristics and Implications of Programs and Policies for Brownfield Management in the U.S.A. (미국 브라운필드 관리 프로그램과 정책의 시기별 특성과 함의)

  • Kim, Eujin Julia;Miller, Patrick
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.43 no.1
    • /
    • pp.96-107
    • /
    • 2015
  • Brownfield sites are beginning to be considered as potentially useful areas for landscape design and planning, with post-industrial areas such as water treatment facilities and military training bases being converted into useful landscapes such as parks and recreation areas. These redevelopments bring broad benefits through revitalizing communities and increasing property values, thus, increasing the demand for comprehensive management and planning policies. This study examines changes in U.S. brownfield policies and programs and, identifies their periodic characteristics over the thirty years since the Superfund program was introduced in 1980. A descriptive and interpretive approach was utilized, focusing specifically on a time sequential analysis of the data gathered from the overview of the Environmental Protection Agency's web-based documents and related literature. The primary changes in and characteristics of programs and policies were analyzed and divided into three periods : environmental protection, remediation and reuse, and comprehensive planning. Four major features were identified: relaxation and readjustment of regulation, diversification of support programs, a mix of top-down and bottom-up approaches, and database system building. The study examines how common brownfield problems such as site identification difficulties and assessment and remediation cost have been dealt with in the regulatory context and has implications for future policies and programs for effective brownfield planning and management in Korea.

The 1:5,000 Forest Soil Map: Current Status and Future Directions (1:5,000 산림입지토양도의 제작과 활용 및 향후 발전 방향)

  • Kwon, Minyoung;Kim, Gaeun;Jeong, Jinhyun;Choi, Changeun;Park, Gwansoo;Kim, Choonsig;Son, Yowhan
    • Journal of Korean Society of Forest Science
    • /
    • v.110 no.4
    • /
    • pp.479-495
    • /
    • 2021
  • To improve on the efficient management of forest resources, it is necessary to create a forest soil map, which represents a comprehensive database of forest lands. Although a 1:25,000 scale forest site map has been used in Korea, the need for a large-scale forest soil map with high precision and information on forest lands that is specialized for individual purposes has been identified. Moreover, to keep pace with the advancement in forest management and transition to a digital society, it is essential to develop a method for constructing new forest soil maps that can diversify its use. Therefore, this paper presented a developmental process and used a 1:5,000 scale forest soil map to propose future directions. National maps showing the soil type, depth, and texture were produced based on the survey and analysis of forest soils, followed by the Forest Land Soil Map (1:5,000) Production Standard Manual. Alternatively, forest soil map data were the basis on which various other maps that can be used to prevent and predict forest disasters and evaluate environmental capacities were developed. Accordingly, ways to provide appropriate information to achieve the national forest plan, secure forestry big data, and accomplish sustainable forest management that corresponds to the national development plan are proposed based on results from the current study.

Research on Malicious code hidden website detection method through WhiteList-based Malicious code Behavior Analysis (WhiteList 기반의 악성코드 행위분석을 통한 악성코드 은닉 웹사이트 탐지 방안 연구)

  • Ha, Jung-Woo;Kim, Huy-Kang;Lim, Jong-In
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.21 no.4
    • /
    • pp.61-75
    • /
    • 2011
  • Recently, there is significant increasing of massive attacks, which try to infect PCs that visit websites containing pre-implanted malicious code. When visiting the websites, these hidden malicious codes can gain monetary profit or can send various cyber attacks such as BOTNET for DDoS attacks, personal information theft and, etc. Also, this kind of malicious activities is continuously increasing, and their evasion techniques become professional and intellectual. So far, the current signature-based detection to detect websites, which contain malicious codes has a limitation to prevent internet users from being exposed to malicious codes. Since, it is impossible to detect with only blacklist when an attacker changes the string in the malicious codes proactively. In this paper, we propose a novel approach that can detect unknown malicious code, which is not well detected by a signature-based detection. Our method can detect new malicious codes even though the codes' signatures are not in the pattern database of Anti-Virus program. Moreover, our method can overcome various obfuscation techniques such as the frequent change of the included redirection URL in the malicious codes. Finally, we confirm that our proposed system shows better detection performance rather than MC-Finder, which adopts pattern matching, Google's crawling based malware site detection, and McAfee.

Development of Basic Research for Establishing the Apple IPM System in Korea: Dr. Lee Soon-Won's Research Case (한국형 사과 병해충종합관리(IPM) 체계 수립을 위한 기초연구의 전개: 이순원 박사의 연구 사례)

  • Ahn, Jeong Joon;Oh, Hyeonseok;Choi, Kyung San;Choi, Kyung-Hee;Do, Yun-Su;Lee, Sun-Young;Lee, Dong-Hyuk
    • Korean journal of applied entomology
    • /
    • v.60 no.1
    • /
    • pp.1-13
    • /
    • 2021
  • The concept of integrated pest management (IPM) first developed in the 1950s, and the concept of economic control via pest management was established in the 1960s. Research on IPM began in the United States and Europe, and IPM studies in Korea started with citrus insects and paddy field pests following the distribution of high-yield varieties of rice. Apple IPM in Korea began with research on pest control using chemical pesticides and pesticides resistant to insect pests, studies on the ecology of insect pests and their natural enemies, and the exploitation of sex pheromones on insect pests. Since the 1990s, IPM research and field projects have been carried out simultaneously for farming households. In the 2000s, the development of pest monitoring and forecasting models centered on mating disturbances, database programs for pests, and networks for sharing information. IPM technology has expanded via the development of unmanned forecasting systems and automation technologies in the 2010s.

An Introduction of Korean Soil Information System (한국 토양정보시스템 소개)

  • Hong, S. Young;Zhang, Yong-Seon;Hyun, Byung-Keun;Sonn, Yeon-Kyu;Kim, Yi-Hyun;Jung, Sug-Jae;Park, Chan-Won;Song, Kwan-Cheol;Jang, Byoung-Choon;Choe, Eun-Young;Lee, Ye-Jin;Ha, Sang-Keun;Kim, Myung-Suk;Lee, Jong-Sik;Jung, Goo-Bok;Ko, Byong-Gu;Kim, Gun-Yeob
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.42 no.1
    • /
    • pp.21-28
    • /
    • 2009
  • Detailed information on soil characteristics is of great importance for the use and conservation of soil resources that are essential for human welfare and ecosystem sustainability. This paper introduces soil inventory of Korea focusing on national soil database establishment, information systems, use, and future direction for natural resources management. Different scales of soil maps surveyed and soil test data collected by RDA (Rural Development Administration) were computerized to construct digital soil maps and database. Soil chemical properties and heavy metal concentrations in agricultural soils including vulnerable agricultural soils were investigated regularly at fixed sampling points. Internet-based information systems for soil and agro-environmental resources were developed based on 'National Soil Survey Projects' for managing soil resources and for providing soil information to the public, and 'Agroenvironmental Change Monitoring Project' to monitor spatial and temporal changes of agricultural environment will be opened soon. Soils data has a great potential of further application in estimation of soil carbon storage, water capacity, and soil loss. Digital mapping of soil and environment using state-of-the-art and emerging technologies with a pedometrics concept will lead to future direction.

Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment (엔터프라이즈 환경의 연구비 통합관리 데이터 웨어하우스 개발 프로세스)

  • Choi, Seong-Man;Yoo, Cheol-Jung;Chang, Ok-Bae
    • The KIPS Transactions:PartD
    • /
    • v.11D no.1
    • /
    • pp.183-194
    • /
    • 2004
  • The existing management job of research expenses has been divided into three parts: budget planning, budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step Is requested. And another problem that it is difficult to toil what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integrated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transports, transforms and loads the data. Information integration agent reduces a user's efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user's requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desired analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

A Digital Library Prototype for Access to Diverse Collections (다양한 장서 접근을 위한 디지털 도서관의 프로토타입 구축)

  • Choi Won-Tae
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.32 no.2
    • /
    • pp.295-307
    • /
    • 1998
  • This article is an overview of the digital library project, indicating what roles Koreas diverse digital collections may play. Our digital library prototype has simple architecture, consisting of digital repositories, filters, indexing and searching, and clients. Digital repositories include various types of materials and databases. The role of filters is to recognize a format of a document collection and mark the structural components of each of its documents. We are using a database management system (ORACLE and ConText) supporting user-defined functions and access methods that allows us to easily incorporate new object analysis, structuring, and indexing technology into a repository. Clients can be considered browsers or viewers designed for different document data types, such as image, audio, video, SGML, PDF, and KORMARC. The combination of navigational tools supports a variety of approaches to identifying collections and browsing or searching for individual items. The search interface was implemented using HTML forms and the World Wide Web's CGI mechanism.

  • PDF