• Title/Summary/Keyword: database systems

Search Result 2,870, Processing Time 0.034 seconds

Spatial Filtering Techniques for Geospatial AR Applications in R-tree (R-tree에서 GeoSpatial AR 응용을 위한 공간필터링 기법)

  • Park, Jang-Yoo;Lee, Seong-Ho;Nam, Kwang-Woo
    • Spatial Information Research
    • /
    • v.19 no.1
    • /
    • pp.117-126
    • /
    • 2011
  • Recently, AR applications provide location-based spatial information by GPS. Also, the spatial information is displayed by the angle of the camera. So far, traditional spatial indexes in spatial database field retrieve and filter spatial information by the minimum bounding rectangle (MBR) algorithm.(ex. R-tree) MBR strategy is a useful technique in the geographic information systems and location based services. But MBR technique doesn't reflect the characteristics of spatial queries in AR. Spatial queries of AR applications have high possibility of the dead space area between MBRs of non-leaf node and query area. We propose triangle node filtering algorithm that improved efficiency of spatial retrieval used the triangle node filtering techniques by exclusion the dead space. In this paper, the proposed algorithm has been implemented on PostgreSQL/PostGIS. Experimental results show the spatial retrieval that using the proposed algorithm better performance than the spatial retrieval that of the minimum bounding rectangle algorithm.

Extrapolation of extreme traffic load effects on bridges based on long-term SHM data

  • Xia, Y.X.;Ni, Y.Q.
    • Smart Structures and Systems
    • /
    • v.17 no.6
    • /
    • pp.995-1015
    • /
    • 2016
  • In the design and condition assessment of bridges, it is usually necessary to take into consideration the extreme conditions which are not expected to occur within a short time period and thus require an extrapolation from observations of limited duration. Long-term structural health monitoring (SHM) provides a rich database to evaluate the extreme conditions. This paper focuses on the extrapolation of extreme traffic load effects on bridges using long-term monitoring data of structural strain. The suspension Tsing Ma Bridge (TMB), which carries both highway and railway traffic and is instrumented with a long-term SHM system, is taken as a testbed for the present study. Two popular extreme value extrapolation methods: the block maxima approach and the peaks-over-threshold approach, are employed to extrapolate the extreme stresses induced by highway traffic and railway traffic, respectively. Characteristic values of the extreme stresses with a return period of 120 years (the design life of the bridge) obtained by the two methods are compared. It is found that the extrapolated extreme stresses are robust to the extrapolation technique. It may owe to the richness and good quality of the long-term strain data acquired. These characteristic extremes are also compared with the design values and found to be much smaller than the design values, indicating conservative design values of traffic loading and a safe traffic-loading condition of the bridge. The results of this study can be used as a reference for the design and condition assessment of similar bridges carrying heavy traffic, analogous to the TMB.

Development and implementation of statistical prediction procedure for field penetration index using ridge regression with best subset selection (최상부분집합이 고려된 능형회귀를 적용한 현장관입지수에 대한 통계적 예측기법 개발 및 적용)

  • Lee, Hang-Lo;Song, Ki-Il;Kim, Kyoung Yul
    • Journal of Korean Tunnelling and Underground Space Association
    • /
    • v.19 no.6
    • /
    • pp.857-870
    • /
    • 2017
  • The use of shield TBM is gradually increasing due to the urbanization of social infrastructures. Reliable estimation of advance rate is very important for accurate construction period and cost. For this purpose, it is required to develop the prediction model of advance rate that can consider the ground properties reasonably. Based on the database collected from field, statistical prediction procedure for field penetration index (FPI) was modularized in this study to calculate penetration rate of shield TBM. As output parameter, FPI was selected and various systems were included in this module such as, procedure of eliminating abnormal dataset, preprocessing of dataset and ridge regression with best subset selection. And it was finally validated by using field dataset.

Structural model updating of the Gageocho Ocean Research Station using mass reallocation method

  • Kim, Byungmo;Yi, Jin-Hak
    • Smart Structures and Systems
    • /
    • v.26 no.3
    • /
    • pp.291-309
    • /
    • 2020
  • To study oceanic and meteorological problems related to climate change, Korea has been operating several ocean research stations (ORSs). In 2011, the Gageocho ORS was attacked by Typhoon Muifa, and its structural members and several observation devices were severely damaged. After this event, the Gageocho ORS was rehabilitated with 5 m height to account for 100-yr extreme wave height, and the vibration measurement system was equipped to monitor the structural vibrational characteristics including natural frequencies and modal damping ratios. In this study, a mass reallocation method is presented for structural model updating of the Gageocho ORS based on the experimentally identified natural frequencies. A preliminary finite element (FE) model was constructed based on design drawings, and several of the candidate baseline FE models were manually built, taking into account the different structural conditions such as corroded thickness. Among these candidate baseline FE models, the most reasonable baseline FE model was selected by comparing the differences between the identified and calculated natural frequencies; the most suitable baseline FE model was updated based on the identified modal properties, and by using the pattern search method, which is one of direct search optimization methods. The mass reallocation method is newly proposed as a means to determine the equivalent mass quantities along the height and in a floor. It was found that the natural frequencies calculated based on the updated FE model was very close to the identified natural frequencies. In conclusion, it is expected that these results, which were obtained by updating a baseline FE model, can be useful for establishing the reference database for jacket-type offshore structures, and assessing the structural integrity of the Gageocho ORS.

A three-step sentence searching method for implementing a chatting system (채팅 시스템 구현을 위한 3단계 문장 검색 방법)

  • Jeon, Won-Pyo;Song, Yoeng-Kil;Kim, Hark-Soo
    • Journal of Advanced Marine Engineering and Technology
    • /
    • v.37 no.2
    • /
    • pp.205-212
    • /
    • 2013
  • The previous chatting systems have generally used methods based on lexical agreement between users' input sentences and target sentences in a database. However, these methods often raise well-known lexical disagreement problems. To resolve some of lexical disagreement problems, we propose a three-step sentence searching method that is sequentially applied when the previous step is failed. The first step is to compare common keyword sequences between users' inputs and target sentences in the lexical level. The second step is to compare sentence types and semantic markers between users' input and target sentences in the semantic level. The last step is to match users's inputs against predefined lexico-syntactic patterns. In the experiments, the proposed method showed better response precision and user satisfaction rate than simple keyword matching methods.

The development of a ship's network monitoring system using SNMP based on standard IEC 61162-460

  • Wu, Zu-Xin;Rind, Sobia;Yu, Yung-Ho;Cho, Seok-Je
    • Journal of Advanced Marine Engineering and Technology
    • /
    • v.40 no.10
    • /
    • pp.906-915
    • /
    • 2016
  • In this study, a network monitoring system, including a secure 460-Network and a 460-Gateway, is designed and developed according with the requirements of the IEC (International Electro-Technical Commission) 61162-460 network standard for the safety and security of networks on board ships. At present, internal or external unauthorized access to or malicious attack on a ship's on board systems are possible threats to the safe operation of a ship's network. To secure the ship's network, a 460-Network was designed and implemented by using a 460-Switch, 460-Nodes, and a 460-Gateway that contains firewalls and a DMZ (Demilitarized Zone) with various application servers. In addition, a 460-firewall was used to block all traffic from unauthorized networks. 460-NMS (Network Monitoring System) is a network-monitoring software application that was developed by using an simple network management protocol (SNMP) SharpNet library with the .Net 4.5 framework and a backhand SQLite database management system, which is used to manage network information. 460-NMS receives network information from a 460-Switch by utilizing SNMP, SNMP Trap, and Syslog. 460-NMS monitors the 460-Network load, traffic flow, current network status, network failure, and unknown devices connected to the network. It notifies the network administrator via alarms, notifications, or warnings in case any network problem occurs. Once developed, 460-NMS was tested both in a laboratory environment and for a real ship network that had been installed by the manufacturer and was confirmed to comply with the IEC 61162-460 requirements. Network safety and security issues onboard ships could be solved by designing a secure 460-Network along with a 460-Gateway and by constantly monitoring the 460-Network according to the requirements of the IEC 61162-460 network standard.

Development of a Generic-YWBS for Engineering Integrated Management of Sailing Yacht (세일링 요트 엔지니어링 통합 관리를 위한 Generic-YWBS 개발)

  • Lee, Dong Kun;Nam, Seung Hoon;Jeong, Yong-Kuk;Shin, Jong-Gye
    • Journal of the Society of Naval Architects of Korea
    • /
    • v.51 no.1
    • /
    • pp.16-25
    • /
    • 2014
  • To develop a sailing yacht successfully, systematic engineering information is required including technologies from various companies and know-how about sailing yacht. The engineering information about sailing yacht has a complex and extensive structure. Therefore, a robust and high-level of management system is needed to manage the information. In this paper, we design and propose Generic-YWBS (Generic-Yacht Work Breakdown Structure), a work breakdown structure for sailing yachts. The Generic-YWBS is aimed at constructing sailing yachts and contains contents about product- and process-oriented information of sailing yachts. In addition, the Generic-YWBS plays an important role in managing the engineering information as a basic schema of database and system architecture. The Generic-YWBS is derived from fundamental WBS design processes and various rules about sailing yachts, for example, ISAF (International Sailing Federation) equipment rule and IRC rating rule, and a generic structure concept is applied for flexibility. The Generic-YWBS is applicable for various purposes. We designed a detailed code system in order to apply the Generic-YWBS to contents management system. The series of activities are realized through a web-based RIA(Rich Internet Application) program. This program manages the YWBS structure in an XML schema, and the Generic-YWBS management application offers a customizing function to be adapted in the field.

Content-based Rotation Invariant Retrieval of Trademarks (내용기반 회전불변 상표검색)

  • Park, Jin-Geun;Jo, Sang-Hyeon;Choe, Heung-Mun
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.39 no.1
    • /
    • pp.60-66
    • /
    • 2002
  • In this paper, an efficient content-based rotation-invariant retrieval of the trademarks is proposed using the edge-direction histogram for a principal symmetry axis and the moment invariants. Rotation invariant retrieval of trademarks is difficult for the conventional retrieval systems because their feature vectors are not rotation-invariant. In this paper, to obtain rotation invariant feature vectors, in addition to invariant moments, the edge-direction histogram for a principal symmetry axis is introduced and is used to solve the bin shift problem of the histogram resulted from the rotated trademark. Performance evaluation has been carried out for a database of 300 kinds of trademarks including 20 kinds of typical trademarks which are reported to be difficult to retrieve when rotated, and the proposed scheme is proved to retrieve trademarks more efficiently, especially for the rotated trademarks, than the conventional methods.

ICT and the Changing Nature of Work: Work Fragmentation (ICT와 업무의 변화 - 일의 파편화 관점에서 -)

  • Lee, Seyoon;Park, Jun-Gi;Lee, Jungwoo
    • Informatization Policy
    • /
    • v.21 no.1
    • /
    • pp.35-56
    • /
    • 2014
  • Information and communication technologies(ICT) allow and force people to work anywhere, anytime using remote databases and application systems available in real-time twenty four hours a day and seven days a week. With the real time nature of ICT, individual work is becoming more and more fragmented. Instead of working on a similar task repeatedly, individuals are required to respond to e-mails and inquiries through social networks, work on planning documents, work on presentation documents, work on spreadsheets, input necessary data on company databases, generate necessary reports from the database, run teleconference, etc., all maybe in a day's work. Work fragmentation may impact negatively on productivity as the flow is interrupted, but it may increase the productivity by allowing people to handle multiple tasks in a shorter time period. This study explores the types of work fragmentation and their characteristics. An online survey was administered to collect data about work fragmentation and work characteristics including autonomy, complexity, flexibility, usage of ICT, etc. 300 cases were used in the analysis. Analysis of k-mean cluster indicated four different types of work fragmentation: concentrated, temporally distributed, spatially distributed, and fully fragmented.

A Study on Model for the Evaluation of Customer Composition in Internet Shopping Malls (인터넷 쇼핑몰의 고객구성 평가 모델에 관한 연구)

  • Park, Kwang-Ho;Han, Dong-Seok;Kim, Hak-So;Baek, Dong-Hyun
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.29 no.2
    • /
    • pp.83-91
    • /
    • 2006
  • Internet shopping mall has become a huge distribution channel with dramatic growth in recent years. The number of consumers has exponentially increased as the scale of shopping mall has been large so that shopping malls with thousands or millions of consumers become a general case. However, it is essential to evaluate whether current assortment of consumers is proper or not in the strategic aspect in order to operate Internet shopping mall effectively and gain profits. That is, it is important to evaluate whether consumer strategy of corporation is proper or not from the corporation. Despite this business importance, consumer assortment has not been evaluated well and related study is not sufficient. This study supposes a framework for consumer assortment evaluation, which evaluates whether consumer assortment of Internet shopping mall is proper or not. In the framework for consumer assortment evaluation, analysis data based on order data and consumer data in database is made. Then, four factors, consumer maintenance rate, consumer profitability, consumer securing rate and consumer conversion are setup, and 22 measurement indexes are drawn. Finally, a consumer assortment evaluation score card is made by integrating them. This study has applied a supposed framework to a domestic typical community based shopping mall, and it is expected that the evaluation result will be used as informant strategic information to operate the shopping mall effectively.