• Title/Summary/Keyword: 데이터베이스 관리시스템

Search Result 2,298, Processing Time 0.023 seconds

Development of SaaS cloud infrastructure to monitor conditions of wind turbine gearbox (풍력발전기 증속기 상태를 감시하기 위한 SaaS 클라우드 인프라 개발)

  • Lee, Gwang-Se;Choi, Jungchul;Kang, Seung-Jin;Park, Sail;Lee, Jin-jae
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.19 no.9
    • /
    • pp.316-325
    • /
    • 2018
  • In this paper, to integrate distributed IT resources and manage human resource efficiently as purpose of cost reduction, infrastructure of wind turbine monitoring system have been designed and developed on the basis of SaaS cloud. This infrastructure hierarchize data according to related task and services. Softwares to monitor conditions via the infrastructure are also developed. Softwares are made up of DB design, field measurement, data transmission and monitoring programs. The infrastructure is able to monitor conditions from SCADA data and additional sensors. Total time delay from field measurement to monitoring is defined by modeling of step-wise time delay in condition monitoring algorithms. Since vibration data are acquired by measurements of high resolution, the delay is unavoidable and it is essential information for application of O&M program. Monitoring target is gearbox in wind turbine of MW-class and it is operating for 10 years, which means that accurate monitoring is essential for its efficient O&M in the future. The infrastructure is in operation to deal with the gearbox conditions with high resolution of 50 TB data capacity, annually.

Spatial Variability Analysis of Paddy Rice Yield in Field (필지내 벼 수량의 공간변이 해석)

  • 이충근;우메다미키오;정인규;성제훈;김상철;박우풍;이용범
    • Journal of Biosystems Engineering
    • /
    • v.29 no.3
    • /
    • pp.267-274
    • /
    • 2004
  • Using geo-statistical method, yield data of different fields were analyzed to examine their field variability according to examining year, analysis method. Semivariogram and Kriged maps of geo-statistical analysis were used to examine their spatial dependence within a filed. The results obtained were as follows. 1) Descriptive statistical results of the yield showed that the yield and the difference of yield ranged from 100 to 946kg/10a and from 272 to 653kg/10a, respectively within a field. The coefficient of variation also ranged from 5.9 to 22.4 %. 2) More than 90% of yield data were placed between 350 to 850kg/10a. e results indicated that the gram mass flow sensor should have the measuring range from 0.34 to 0.82kg/s considering the yields when 4 rows head-feeding combine with 0.8 m/s of working speed was utilized. 3) A high spatial dependence was found within paddy field. The Q values ranged from 0.20 to 0.97, and the range of spatial dependence was from 6.9 to 53.3m. From this result, the rational sampling interval for yield investigation was estimated 6.9m. 4) Yields within a field between observation years showed considerable variability even if the field was evenly cultivated and managed. To apply precision agriculture in a paddy field, the field test should be continued to build a solid data-base including meteorological data, blight damage and insect damage.

3-Dimensional Terrain Model of Ruins Distribution Using GIS (GIS를 이용한 유적분포 3차원 지형모델)

  • Kwak, Young-Joo;Kang, In-Joon;Jang, Yong-Gu;Kang, Young-Shin;Kim, Sang-Seok
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.12 no.4 s.31
    • /
    • pp.27-33
    • /
    • 2004
  • Recently, as a part of NGIS project, cultural-assets digital map is produced by cultural properties administration and local autonomous entities. Cultural-assets unified GIS(Geographic Information System) is essential to cultural properties managers md other organizations which are executing land related business for appling it at planning stage. With explosive national land developments, it has been obligated to implement surface survey by the cultural properties protection Art. In this paper, the authors used the district of Sachon city and made 3D terrain model using digital map which is made of 1/5000 stale. Moreover, the authors improved to RDBMS(Relational Database Management System) structure and remodeled the existing DB design in detail, and also tried recovery of past sea level, based on researches about the water level of southern area. By recover past sea level. the shell mound, apart from lever is actually near lever at past, and it make sure its nature. The authors suggested to realize shape and kind of remains which have 3D information of accuracy and actualization from surface-surveying to excavation.

  • PDF

Prioritizing of Civil-BIM DB Construction based on Geo-Spatial Information System (지형공간정보체계 기반의 토목-BIM DB구축 우선순위 선정)

  • Park, Dong Hyun;Kang, In Joon;Jang, Yong Gu;Lee, Byung Gul
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.23 no.1
    • /
    • pp.73-79
    • /
    • 2015
  • Recently, BIM proliferates at high speeds so that BIM planning is trying to be used in various kinds of engineering. However, when using different software during design phase and construction phase, the problem of mutual compatibility is coming out. Even the BIM technology has been used or the practical applicability has been made into result, it would be fair to say that BIM has limitations in the visual level. In this research, it is meaningless to obtain the BIM result as the primary purpose. As the usefulness of it is judged incomplete, we committed to master the trend and problems of terrain spatial information systems and BIM. Furthermore, the plan of building the BIM in the civil field, especially the civil-BIM based on the technology ofterrain spatial information has been presented. It can be judged through this research that the high-capacity DB of BIM occurred during the whole process may cause poor performance of the following stage the structure system which connects the terrain spatial information and civil-BIM. In order to manage the optimal full cycle, the spatial analysis technology of the stages after choosing the DB has been described.

Environmental Equity Analysis of the Accessibility to Public Transportation Services in Daegu City (대구시 대중교통서비스의 접근성에 대한 환경적 형평성 분석)

  • Kim, Ah-Yeon;Jun, Byong-Woon
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.15 no.1
    • /
    • pp.76-86
    • /
    • 2012
  • The purpose of this study is to investigate the environmental equity of the accessibility to public transportation services in the city of Daegu. The 2005 census data as well as bus stop and subway station datasets were integrated for building the GIS database. Public transportation service areas were then identified by a coverage method. Mann Whitney U test was used for statistically comparing the socioeconomic characteristics over different levels of access to the public transportation services. Both Dong-gu, Suseong-gu, Dalseo-gu, and Buk-gu located outside of the city had worse accessibility than others while Jung-gu, Seo-gu, and Nam-gu had better accessibility than others. There appeared no environmental inequity pattern in terms of the percentages of men, women, and teenagers over the city of Daegu whereas there existed some environmental inequity pattern in terms of the percentages of people above the age of 65 and people below poverty line. This environmental inequity pattern would be caused by some factors. Firstly, the lower income class has tended to reside in the declined or blighted areas far away from public transportation facilities since this class can not afford to pay expensive rents and land prices around the main roads with higher accessibility. Many old people belonging to the lower income class also reside in the declined or blighted areas. Secondly, there has been no law to locate bus stops and subway stations considering residents' socioeconomic characteristics and the spatial distribution of public transportation facilities has been not managed systematically by the city government. This research would shed insight on building the public transportation policy to locate bus stops and subway stations and to select the routes of buses and subways considering the spatial distribution of residents' socioeconomic characteristics.

A Study on Construction and Utilization Plan of Underground Spatial Information DB for Earthquake Disaster Prevention (지진방재를 위한 지하공간정보 DB 구축 및 활용 방안 연구)

  • Kim, Soogyeom;Jang, Yonggu;Kim, Changkyu;Kang, Injoon
    • Journal of the Korean GEO-environmental Society
    • /
    • v.14 no.9
    • /
    • pp.49-56
    • /
    • 2013
  • Looking at the changes in the earthquake of 33 years of South Korea, earthquake in the magnitude of 3.0 or stronger have been conducted about nine times a year on average, and the epicenter of the earthquake is moving towards the inland from the coast. As the possibility of earthquakes increase, it is time to require utilization of underground space integrated information for earthquake disaster prevention. But, now the data related to the characterization of the ground and geology in the areas weak against earthquakes is insufficient, so we need to collect new geology and the ground survey data on nationwide scale and have to establish earthquake disaster prevention plans through the joint use of the existing underground space information. In this study, we determined the scope of construction of underground space DB information that is needed for earthquake disaster prevention, presented the construction plan of DB static and dynamic information of underground space. It also suggested the utilization of underground space scheme information for built earthquake disaster prevention. The underground space information for earthquake disaster prevention that was built through determining the scope and constructing, planning the utilization of underground space information is supposed to used as DB of the integrated management system of underground space and steep slopes information for steep slopes and earthquake prevention by Emergency Management Agency.

A Implementation of Electronic Measurement Datum Point Monitoring S/W based on Object-Oriented Modeling for Multi Purpose and High Availability (다목적 및 고활용성을 위한 객체지향 모델링 기반의 전자 측량기준점 모니터링 S/W 구현)

  • Jung, Se-Hoon;Sim, Chun-Bo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.20 no.2
    • /
    • pp.99-112
    • /
    • 2015
  • Datum point for displaying location and altitude of point has being advantage usefully in various measurement parts. However, datum point has been increasing loss cases owing to weather changes and stratum changes and neglecting meaninglessly. In this paper, we design and implement a multi electronic measurement system monitoring software with functions such as include maximize utilization of existing measurement datum system as well as collected various environment data and detection stratum changes of surround area. Proposed software is implemented to support that reusability and extensibility of software using object oriented modeling method. Our software supports a GUI for electronic measurement datum point administrator as well as for web user and mobile user. Our system can support a graph GUI for various data analysis and reposition in realtime to database that measured location information and various sensing information to prevent loss of electronic measurement datum point and to detected stratum changes. In addition, we include a QR code and RFID recognition function. Finally, we suggest performance evaluation result to confirm stratum changes detection and GPS location error rate.

Performance Evaluation of Hash Join Algorithm on Flash Memory SSDs (플래쉬 메모리 SSD 기반 해쉬 조인 알고리즘의 성능 평가)

  • Park, Jang-Woo;Park, Sang-Shin;Lee, Sang-Won;Park, Chan-Ik
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.16 no.11
    • /
    • pp.1031-1040
    • /
    • 2010
  • Hash join is one of the core algorithms in databases management systems. If a hash join cannot complete in one-pass because the available memory is insufficient (i.e., hash table overflow), however, it may incur a few sequential writes and excessive random reads. With harddisk as the tempoary storage for hash joins, the I/O time would be dominated by slow random reads in its probing phase. Meanwhile, flash memory based SSDs (flash SSDs) are becoming popular, and we will witness in the foreseeable future that flash SSDs replace harddisks in enterprise databases. In contrast to harddisk, flash SSD without any mechanical component has fast latency in random reads, and thus it can boost hash join performance. In this paper, we investigate several important and practical issues when flash SSD is used as tempoary storage for hash join. First, we reveal the va patterns of hash join in detail and explain why flash SSD can outperform harddisk by more than an order of magnitude. Second, we present and analyze the impact of cluster size (i.e., va unit in hash join) on performance. Finally, we emperically demonstrate that, while a commerical query optimizer is error-prone in predicting the execution time with harddisk as temporary storage, it can precisely estimate the execution time with flash SSD. In summary, we show that, when used as temporary storage for hash join, flash SSD will provide more reliable cost estimation as well as fast performance.

Classification of BcN Vulnerabilities Based on Extended X.805 (X.805를 확장한 BcN 취약성 분류 체계)

  • Yoon Jong-Lim;Song Young-Ho;Min Byoung-Joon;Lee Tai-Jin
    • The KIPS Transactions:PartC
    • /
    • v.13C no.4 s.107
    • /
    • pp.427-434
    • /
    • 2006
  • Broadband Convergence Network(BcN) is a critical infrastructure to provide wired-and-wireless high-quality multimedia services by converging communication and broadcasting systems, However, there exist possible danger to spread the damage of an intrusion incident within an individual network to the whole network due to the convergence and newly generated threats according to the advent of various services roaming vertically and horizontally. In order to cope with these new threats, we need to analyze the vulnerabilities of BcN in a system architecture aspect and classify them in a systematic way and to make the results to be utilized in preparing proper countermeasures, In this paper, we propose a new classification of vulnerabilities which has been extended from the ITU-T recommendation X.805, which defines the security related architectural elements. This new classification includes system elements to be protected for each service, possible attack strategies, resulting damage and its criticalness, and effective countermeasures. The new classification method is compared with the existing methods of CVE(Common Vulnerabilities and Exposures) and CERT/CC(Computer Emergency Response Team/Coordination Center), and the result of an application to one of typical services, VoIP(Voice over IP) and the development of vulnerability database and its management software tool are presented in the paper. The consequence of the research presented in the paper is expected to contribute to the integration of security knowledge and to the identification of newly required security techniques.

Evolution of Bias-corrected Satellite Rainfall Estimation for Drought Monitoring System in South Korea (한반도지역 가뭄 모니터링 활용을 위한 위성강우 편의보정)

  • Park, Jihoon;Jung, Imgook;Park, Kyungwon
    • Korean Journal of Remote Sensing
    • /
    • v.34 no.6_1
    • /
    • pp.997-1007
    • /
    • 2018
  • Drought monitoring is the important system for disasters by climate change. To perform this, it is necessary to measure the precipitation based on satellite rainfall estimation. The data developed in this study provides two kinds of satellite data (raw satellite data and bias-corrected satellite data). The spatial resolution of satellite data is 10 km and the temporal resolution is 1 day. South Korea was selected as the target area, and the original satellite data was constructed, and the bias-correction method was validated. The raw satellite data was constructed using TRMM TMPA and GPM IMERG products. The GRA-IDW was selected for bias-correction method. The correlation coefficient of 0.775 between 1998 and 2017 is relatively high, and TRMM TMPA and GPM IMERG 10 km daily rainfall correlation coefficients are 0.776 and 0.753, respectively. The BIAS values were found to overestimate the raw satellite data over observed data. By using the technique developed in this study, it is possible to provide reliable drought monitoring to Korean peninsula watershed. It is also a basic data for overseas projects including the un-gaged regions. It is expected that reliable gridded data for end users of drought management.