• Title/Summary/Keyword: database systems

Search Result 2,870, Processing Time 0.027 seconds

Design and Implementation of a SQL based Moving Object Query Process System for Controling Transportation Vehicle (물류 차량 관제를 위한 SQL 기반 이동 객체 질의 처리 시스템의 설계 및 구현)

  • Jung, Young-Jin;Ryu, Keun-Ho
    • The KIPS Transactions:PartD
    • /
    • v.12D no.5 s.101
    • /
    • pp.699-708
    • /
    • 2005
  • It becomes easy and generalized to track the cellular phone users and vehicles according to the Progress of wireless telecommunication, the spread of network, and the miniaturization of terminal devices. It has been constantly studied to provide location based services to furnish suitable services depending on the positions of customers. Various vehicle tracking and management systems are developed to utilize and manage the vehicle locations to relieve the congestion of traffic and to smooth transportation. However the designed previous work can not evaluated in real world, because most of previous work is only designed not implemented and it is developed for simple model to handle a point, a line, a polygon object. Therefore, we design a moving object query language and implement a vehicle management system to search the positions and trajectories of vehicles and to analyze the cost of transportation effectively. The designed query language based on a SQL can be utilized to get the trajectories between two specific places, the departure time, the arrival time of vehicles, and the predicted uncertainty positions, etc. In addition, the proposed moving object query language for managing transportation vehicles is useful to analyze the cost of trajectories in a variety of moving object management system containing transportation.

Policy Suggestions for Soil Contamination Prevention and Management of Inactive or Abandoned Metal Mines (휴.폐금속광산지역의 토양오염관리정책의 평가)

  • Park Yong-Ha;Seo Kyung-Won
    • Journal of Soil and Groundwater Environment
    • /
    • v.11 no.3
    • /
    • pp.1-11
    • /
    • 2006
  • Attempts were made to analyze the national policy of soil contamination prevention and management of inactive or abandoned metal (IAM) mines in Korea. This approach focused on legal systems and legislation, remediation technology development, and the arrangement or distribution of budgets pertaining to national policy since the mid 1990's. Prevention of Mining Damage and Recovery Act enacted. Defines the roles, responsibility and budget of the government when recovering mine damages. However, in 2005 there still remains to improve the national policy of soil contamination prevention and management of IAM mines. Analysis of national and industrialized foreign countries including the United States, the United Kingdom, and the Netherlands suggest the following improvements: i) arranging distinct regulations between strict and non-strict liability criteria for potentially responsible parties; limiting innocent and non-strict liability depending on the period of incurred mining activity, ii) enhancing participation of local communities by enforcing law and legislation, iii) establishing a national database system of (potentially) IAM contaminated sites based on the Website-Geographic Information System, iv) carrying out site-specific risk assessments and remediation of IAM contaminated sites, v) preparation and distribution of clean-up fund at mine sites adequately, and vi) technology development for the cleaning of IAM contaminated sites; awarding positive incentives of a legal nature for participants applying newly developed technology in IAM mines.

Efficient Multiple Joins using the Synchronization of Page Execution Time in Limited Processors Environments (한정된 프로세서 환경에서 체이지 실행시간 동기화를 이용한 효율적인 다중 결합)

  • Lee, Kyu-Ock;Weon, Young-Sun;Hong, Man-Pyo
    • Journal of KIISE:Databases
    • /
    • v.28 no.4
    • /
    • pp.732-741
    • /
    • 2001
  • In the relational database systems the join operation is one of the most time-consuming query operations. Many parallel join algorithms have been developed 개 reduce the execution time Multiple hash join algorithm using allocation tree is one of the most efficient ones. However, it may have some delay on the processing each node of allocation tree, which is occurred in tuple-probing phase by the difference between one page reading time of outer relation and the processing time of already read one. This delay problem was solved by using the concept of synchronization of page execution time with we had proposed In this paper the effects of the performance improvements in each node of the allocation tree are extended to the whole allocation tree and the performance evaluation about that is processed. In addition we propose an efficient algorithm for multiple hash joins in limited number of processor environments according to the relationship between the number of input relations in the allocation tree and the number of processors allocated to the tree. Finally. we analyze the performance by building the analytical cost model and verify the validity of it by various performance comparison with previous method.

  • PDF

Development of Simulator for Rockfall and Landslide using Physical Engine (물리엔진을 사용한 낙석 및 산사태 시뮬레이터 개발)

  • Kim, Sung-Ho
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.9
    • /
    • pp.60-67
    • /
    • 2009
  • This paper describes a development of system that enables the user to simulate the rockfall and landslide from slopes using physical engine. Until now, it will not be able to accomplish the virtual experiment of three-dimensional interpretation about slope informations, stability evaluation, the rockfall and landslide simulation, etc., because of absence of three-dimensional simulation systems which relates with slopes. With like that reason, this paper developed a simulator which is identical or similar the rockfall and the landslide where the possibility which will occur or occurred from actuality is high very actual condition from virtual experiment. For a simulator development, this paper uses the physical engine which is mainly used from computer game and animation development etc., And it will be show the process where the rockfall and landslide occurs with simulator. This simulator which sees the process where the rockfall and the landslide occur from three-dimension computer graphics theory and the physical engine, is a system which is the possibility of showing actual feeling. Therefore, the result of this paper is applied in vehicle travelling guidance system and intelligence traffic systematic etc., because of creates visual service and three-dimensional application of the slope information database which is developed in existing, and will be able to forecast the upgrade of user benefit planning and a service.

Effects of the Site-Specific Nitrogen Management on Economic Feasibility and Environmental Sustainability (토양특성(土壤特性)에 따른 질소시용(窒素施用)의 환경(環境) 경제적(經濟的) 효과(效果))

  • Kang, Choong-Kwan;Park, Joo-Sub;Lee, Sang-Yong;Kim, Han-Myeong
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.34 no.1
    • /
    • pp.42-54
    • /
    • 2001
  • The use of nitrogen fertilizer in intensive agricultural production is of major concern due to its role on agricultural productivity and water quality. Crop production inputs on farm are usually applied at a uniform rate across an entire field. However, actual input requirements often vary within fields. The field variations in yield potential, soil moisture, soil N status, and the efficiency of fertilizer use, uniform application of crop production inputs does not allow optimum efficiency or profitability. This occurs because uniform application often results in areas of over- and under-application which may affect water quality and crop yield. This study used biophysical and economic models to assess the economic feasibility and water quality benefits of site specific nitrogen management for 10 soil types and 35 sample fields in Goodwater Creek watershed located near Centralia, Missouri. Results showed that the economic feasibility and water quality benefits of variable rate application were sensitive to the distribution of soil types within a field. Variable rate(VR) application was not uniformly more profitable than uniform rate(UR) application for the four agricultural systems evaluated and the water quality benefits were insubstantial relative to uniform application of N.

  • PDF

The Correlation between Social Media and the Behaviors of the Supreme Court in Korea (소셜미디어와 대법원 판결의 상관 관계에 대한 분석)

  • Heo, Junhong;Seo, Yeeun;Lee, Seoyeong;Lee, Sang-Yong Tom
    • Knowledge Management Research
    • /
    • v.22 no.3
    • /
    • pp.31-53
    • /
    • 2021
  • As a communication channel for individuals, social media is affecting various areas such as business, economy, politics, and society. One of the less-studied areas is the law. Therefore, this study collected various information from social media and analyzed its impacts on the legal decisions, especially the Supreme Court decisions in Korea. This study was conducted by compiling information from Internet news articles and public responses. We found that when the negative reactions from the public got higher, the trial duration until the supreme court making the final decisions became shorter. However, we were not able to find the significant relationship between social media reactions and dismissal of appeal nor annulment. Our study would contribute to the information systems and knowledge management research in a sense that the social analytics is applied to the area of legal decisions, instead of using conventional qualitative study methodology. Our study is also meaningful to the practitioners because that big data analytical business can be applied to the field of law by creating a new database for the emerging legal technology. Finally, law makers can think of a better way to standardize the legal decision process to minimize the reverse effects from social media.

Changes of Time-Distance Accessibility by Year and Day in the Integrated Seoul Metropolitan Public Transportation Network (서울 대도시권 통합 대중 교통망에서 연도별 및 요일별 시간거리 접근도 변화)

  • Park, Jong Soo;Lee, Keumsook
    • Journal of the Economic Geographical Society of Korea
    • /
    • v.21 no.4
    • /
    • pp.335-349
    • /
    • 2018
  • This study analyzes the effect of the changes in traffic environments such as transportation speeds on the time-distance accessibility for the public transportation passengers. To do this, we use passenger transaction databases of the Seoul metropolitan public transportation system: one week for each of the three years (2011, 2013, and 2015). These big data contain the information about time and space on the traffic trajectories of every passenger. In this study, the time-distances of links between subway stations and bus stops of the public transportation system at each time are calculated based on the actual travel time extracted from the traffic-card transaction database. The changes in the time-distance accessibility of the integrated transportation network from the experimental results can be summarized in two aspects. First, the accessibility tends to decline as the year goes by. This is because the transportation network becomes more complicated and then the average moving speed of the vehicles is lowered. Second, the accessibility tends to increase on the weekend in the analysis of accessibility changes by day. This tendency is because the bus speeds on bus routes on the weekend are faster than other days. In order to analyze the accessibility changes, we illustrate graphs of the vehicle speeds and the numbers of passengers by year and day.

Deep Learning Structure Suitable for Embedded System for Flame Detection (불꽃 감지를 위한 임베디드 시스템에 적합한 딥러닝 구조)

  • Ra, Seung-Tak;Lee, Seung-Ho
    • Journal of IKEEE
    • /
    • v.23 no.1
    • /
    • pp.112-119
    • /
    • 2019
  • In this paper, we propose a deep learning structure suitable for embedded system. The flame detection process of the proposed deep learning structure consists of four steps : flame area detection using flame color model, flame image classification using deep learning structure for flame color specialization, $N{\times}N$ cell separation in detected flame area, flame image classification using deep learning structure for flame shape specialization. First, only the color of the flame is extracted from the input image and then labeled to detect the flame area. Second, area of flame detected is the input of a deep learning structure specialized in flame color and is classified as flame image only if the probability of flame class at the output is greater than 75%. Third, divide the detected flame region of the images classified as flame images less than 75% in the preceding section into $N{\times}N$ units. Fourthly, small cells divided into $N{\times}N$ units are inserted into the input of a deep learning structure specialized to the shape of the flame and each cell is judged to be flame proof and classified as flame images if more than 50% of cells are classified as flame images. To verify the effectiveness of the proposed deep learning structure, we experimented with a flame database of ImageNet. Experimental results show that the proposed deep learning structure has an average resource occupancy rate of 29.86% and an 8 second fast flame detection time. The flame detection rate averaged 0.95% lower compared to the existing deep learning structure, but this was the result of light construction of the deep learning structure for application to embedded systems. Therefore, the deep learning structure for flame detection proposed in this paper has been proved suitable for the application of embedded system.

Development of KBIMS Architectural and Structural Element Library and IFC Property Name Conversion Methodology (KBIMS 건축 및 구조 부재 라이브러리 및 IFC 속성명 변환 방법 개발)

  • Kim, Seonwoo;Kim, Sunjung;Kim, Honghyun;Bae, Kiwoo
    • Journal of the Korea Institute of Building Construction
    • /
    • v.20 no.6
    • /
    • pp.505-514
    • /
    • 2020
  • This research introduces the method of developing Korea BIM standard (KBIMS) architectural and structural element library and the methodology of converting KBIMS IFC property names with special characters. Diverse BIM tools are utilizing in project, however BIM library researches lack diversity on BIM tool selection. This research described the method to generate twelve categories and seven hundred and ninety-three elements library containing geometrical and numerical data in CATIA V6. KBIMS has its special property data naming systems which was the challenge inputting to ENOVIA IFC database. Three mapping methods for special naming characters had been developed and the ASCII code method was applied. In addition, the convertor prototype had been developed for searching and replacing the ASCII codes into the original KBIMS IFC property names. The methodology was verified by exporting 2,443 entities without data loss in the sample model conversion test. This research would provide a wider choice of BIM tool selection for applying KBIMS. Furthermore, the research would help on the reduction of data interoperability issues in projects. The developed library would be open to the public, however the continuous update and maintenance would be necessary.

A Self-Service Business Intelligence System for Recommending New Crops (재배 작물 추천을 위한 셀프서비스 비즈니스 인텔리전스 시스템)

  • Kim, Sam-Keun;Kim, Kwang-Chae;Kim, Hyeon-Woo;Jeong, Woo-Jin;Ahn, Jae-Geun
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.22 no.3
    • /
    • pp.527-535
    • /
    • 2021
  • Traditional business intelligence (BI) systems have been used widely as tools for better decision-making on time. On the other hand, building a data warehouse (DW) for the efficient analysis of rapidly growing data is time-consuming and complex. In particular, the ETL (Extract, Transform, and Load) process required to build a data warehouse has become much more complex as the BI platform moves to a cloud environment. Various BI solutions based on the NoSQL database, such as MongoDB, have been proposed to overcome these ETL issues. Decision-makers want easy access to data without the help of IT departments or BI experts. Recently, self-service BI (SSBI) has emerged as a way to solve these BI issues. This paper proposes a self-service BI system with farming data using the MongoDB cloud as DW to support the selection of new crops by return-farmers. The proposed system includes functions to provide insights to decision-makers, including data visualization using MongoDB charts, reporting for advanced data search, and monitoring for real-time data analysis. Decision makers can access data directly in various ways and can analyze data in a self-service method using the functions of the proposed system.