• Title/Summary/Keyword: ORACLE

Search Result 388, Processing Time 0.04 seconds

Design and Implementation of Storage Manager for Real-Time Compressed Storing of Large Volume Datastream (대용량 데이터스트림 실시간 압축 저장을 위한 저장관리자 설계 및 구현)

  • Lee, Dong-Wook;Baek, Sung-Ha;Kim, Gyoung-Bae;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.11 no.3
    • /
    • pp.31-39
    • /
    • 2009
  • Requirement level regarding processing and managing real-time datastream in an ubiquitous environment is increased. Especially, due to the unbounded, high frequency and real-time characteristics of datastream, development of specialized stroge manager for DSMS is necessary to process such datastream. Existing DSMS, e.g. Coral8, can support datastream processing but it is not scalable and cannot perform well when handling large-volume real-time datastream, e.g. 100 thousand over per second. In the case of Oracle10g, which is generally used in related field, it supports storing and management processing. However, it does not support real-time datastream processing. In this paper, we propose specialized storage manager of DSMS for real-time compressed storing on semiconductor or LCD production facility of Samsung electronics, Hynix and HP. Hynix and HP. This paper describes the proposed system architecture and major components and show better performance of the proposed system compared with similar systems in the experiment section.

  • PDF

Use of Graph Database for the Integration of Heterogeneous Biological Data

  • Yoon, Byoung-Ha;Kim, Seon-Kyu;Kim, Seon-Young
    • Genomics & Informatics
    • /
    • v.15 no.1
    • /
    • pp.19-27
    • /
    • 2017
  • Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join statements. Recently, a new type of database, called the graph-based database, was developed to natively represent various kinds of complex relationships, and it is widely used among computer science communities and IT industries. Here, we demonstrate the feasibility of using a graph-based database for complex biological relationships by comparing the performance between MySQL and Neo4j, one of the most widely used graph databases. We collected various biological data (protein-protein interaction, drug-target, gene-disease, etc.) from several existing sources, removed duplicate and redundant data, and finally constructed a graph database containing 114,550 nodes and 82,674,321 relationships. When we tested the query execution performance of MySQL versus Neo4j, we found that Neo4j outperformed MySQL in all cases. While Neo4j exhibited a very fast response for various queries, MySQL exhibited latent or unfinished responses for complex queries with multiple-join statements. These results show that using graph-based databases, such as Neo4j, is an efficient way to store complex biological relationships. Moreover, querying a graph database in diverse ways has the potential to reveal novel relationships among heterogeneous biological data.

Development of the GIS Based Pre- and Post-Processing Tool for the Visual MODFLOW Groundwater Flow Modeling (Visual MODFLOW 지하수 유동 모델링을 위한 GIS 기반 전ㆍ후처리기 개발)

  • Kim, Man-Kyu
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.6 no.2
    • /
    • pp.65-79
    • /
    • 2003
  • In this study GIS based pre- and post-processing tool for the Visual MODFLOW that is specific software to model groundwater flow is developed. This tool not only makes input data scientifically but also manages input and output data in terms of the groundwater flow analysis. In addition it can storage project products systematically into Oracle database. The most characteristic figure of this processing tool is to provide the module, which automatically or semi automatically develops various grid cell sizes using GIS ArcView and also produces DXF files reflecting various boundary conditions in the modeling zone. In particular, eminences of this research are to create 3 dimensional hydrogeological structures with 2 dimensional GIS ArcView and to conduct pre- and post- processing along with same topology and data format of the MODFLOW.

  • PDF

A Study on Improving the Performance of High Resolution Image Web GIS System (WEB GIS시스템을 통한 고해상도 영상지도의 속도향상을 위한 연구)

  • Jeong, Myeong-Hun;Suh, Yong-Cheol
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.11 no.4
    • /
    • pp.161-171
    • /
    • 2008
  • Nowdays the need of modeling a real world using computers leads to increase the importance of GIS. Moreover, the wide spread of the Internet service has brought about Web GIS Development. Especially, the tuning of Web GIS system has a crucial role in improving the performance of high resolution image Web GIS system. Thus, this study provides a variety of ways to improve the performance of high resolution image Web GIS system. We have tuned IBM AIX operation system, Oracle, ArcSDE in the database level and Tomcat, ArcIMS in the application level. What is more, we propose ways of coding which can have a positive impact on performance. As a result, the proposed methods guarantee high resolution image Web GIS system to improve performance.

  • PDF

Development of Relational Database Management System for Agricultural Non-point Source Pollution Control (관계형 데이터베이스를 이용한 농업비점 자료 관리 시스템 개발)

  • Park, Jihoon;Kang, Moon Seong;Song, Inhong;Hwang, Soon Ho;Song, Jung-Hun;Jun, Sang Min
    • Journal of Korean Society of Rural Planning
    • /
    • v.19 no.4
    • /
    • pp.319-327
    • /
    • 2013
  • The objective of this research was to develop a relational database management system(RDBMS) to collect, manage and analyze data on agricultural non-point source(NPS) pollution. The system consists of the relational database for agricultural NPS data and data process modules. The data process modules were composed of four sub-modules for data input, management, analysis, and output. The data collected from the watershed of the upper Cheongmi stream and Geunsam-Ri were used in this study. The database was constructed using Apache Derby with meteorological, hydrological, water quality, and soil characteristics. Agricultural NPS-Data Management System(ANPS-DMS) was developed using Oracle Java. The system developed in this study can deal with a variety of agricultural NPS data and is expected to provide an appropriate data management tool for agricultural NPS studies.

Prediction of potential habitats and distribution of the marine invasive sea squirt, Herdmania momus

  • Park, Ju-Un;Lee, Taekjun;Kim, Dong Gun;Shin, Sook
    • Korean Journal of Environmental Biology
    • /
    • v.38 no.1
    • /
    • pp.179-188
    • /
    • 2020
  • The influx of marine exotic and alien species is disrupting marine ecosystems and aquaculture. Herdmania momus, reported as an invasive species, is distributed all along the coast of Jeju Island and has been confirmed to be distributed and spread to Busan. The potential habitats and distribution of H. momus were estimated using the maximum entropy (MaxEnt) model, quantum geographic information system (QGIS), and Bio-ocean rasters for analysis of climate and environment(Bio-ORACLE), which can predict the distribution and spread based only on species occurrence data using species distribution model (SDM). Temperature and salinity were selected as environmental variables based on previous literature. Additionally, two different representative concentration pathway (RCP) scenarios (RCP 4.5 and RCP 8.5) were set up to estimate future and potential habitats owing to climate change. The prediction of potential habitats and distribution for H. momus using MaxEnt confirmed maximum temperature as the highest contributor(77.1%), and mean salinity, the lowest (0%). And the potential habitats and distribution of H. momus were the highest on Jeju Island, and no potential habitat or distribution was seen in the Yellow Sea. Different RCP scenarios showed that at RCP 4.5, H. momus would be distributed along the coast of Jeju Island in the year 2050 and that the distribution would expand to parts of the Korea Strait by the year 2100. RCP 8.5, the distribution in 2050 is predicted to be similar to that at RCP 4.5; however, by 2100, the distribution is predicted to expand to parts of the Korea Strait and the East Sea. This study can be utilized as basic data to effectively control the ecological injuries by H. momus by predicting its spread and distribution both at present and in the future.

Development of Database System(DB/SLOPE) for Management of Cut Slope in Highway (고속도로 절토사면 관리를 위한 데이타베이스 프로그램 개발)

  • 유병옥;황영철
    • Tunnel and Underground Space
    • /
    • v.11 no.3
    • /
    • pp.206-216
    • /
    • 2001
  • Many failures in cut slopes occur during and following road construction. Failures are caused, in part, by a lack of understanding of the characteristics of rock mass including its geologic structure. The stability of rock slopes is closely related to factors that include the type of rock, development of geological structures, weathering, characteristics of rock, and the shape of the geologic features. Therefore, it is very important to consider these characteristics of rock mass in the evaluation of rock slope stability. In spite of investigation from many slope failures, these information data were not systematically stored and not efficiently utilized. In this study, a Database system named DB/SLOPE was developed using Oracle for systematic management of cut slopes. The developed database system can be used to estimate of slope stability and to predict of slope failure.

  • PDF

An Efficient Storing Scheme of Real-time Large Data to improve Semiconductor Process Productivities (반도체 공정의 생산성 향상을 위한 실시간 대용량 데이터의 효율적인 저장 기법)

  • Chung, Weon-Il;Kim, Hwan-Koo
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.10 no.11
    • /
    • pp.3207-3212
    • /
    • 2009
  • Automatic semiconductor manufacturing systems are demanded to improve the efficiency of the semiconductor production process. These systems include the functionalities such as the analysis and management schemes for very large real-time data in order to enhance the productivities. So, it requires the efficient storage management system to store very large real-time data. Traditional database management systems(e.g. Oracle, MY-SQL, MS-SQL) are based on disk. However, previous DBMS's have the limitation on the low storing performance. In this paper, we propose a compress-merge storing method of very large real-time data using insert transaction of a block unit. The proposed method shows better processing performances compare to conventional DBMS's. Also compress-merge method makes it possible that it can store large real-time data on low storage cost. Therefore, the proposed method can be applied to an efficient storage management system in the semiconductor production process.

One-round Protocols for Two-Party Authenticated Key Exchange (1-라운드 양자간 키 교환 프로토콜)

  • Jeong, Ik-Rae;Lee, Dong-Hoon
    • Journal of KIISE:Computer Systems and Theory
    • /
    • v.33 no.1_2
    • /
    • pp.110-118
    • /
    • 2006
  • Cryptographic protocol design in a two-party setting has of tel ignored the possibility of simultaneous message transmission by each of the two parties (i.e., using a duplex channel). In particular, most protocols for two-party key exchange have been designed assuming that parties alternate sending their messages (i.e., assuming a bidirectional half-duplex channel). However, by taking advantage of the communication characteristics of the network it may be possible to design protocols with improved latency. This is the focus of the present work. We present three provably-secure protocols for two-party authenticated key exchange (AKE) which require only a single round. Our first, most efficient protocol provides key independence but not forward secrecy. Our second scheme additionally provides forward secrecy but requires some additional computation. Security of these two protocols is analyzed in the random oracle model. Our final protocol provides the same strong security guarantees as our second protocol, but is proven secure in the standard model. This scheme is only slightly less efficient (from a computational perspective) than the previous ones. Our work provides the first provably- secure one-round protocols for two-party AKE which achieve forward secrecy.

An XQuery Processing Engine for Real-Time Sensor Data in Ubiquitous Environments (유비쿼터스 환경에서 실시간 센서 데이터를 위한 XML 질의언어 처리 엔진)

  • Yim, Hyung-Jun;Kim, Jae-Hoon;Lee, Kyu-Chul
    • The Journal of Society for e-Business Studies
    • /
    • v.15 no.4
    • /
    • pp.1-19
    • /
    • 2010
  • Recently, it is necessary to process real time sensor data, which is generated from ubiquitous environments. Data, which are written by XML, are small, but, large volumes of data. Therefore, weneed to use an efficient method for processing a large amount of it. An XQuery has two types for sensor data: one is to get sensor identification and value from sensor data; the other is restructuring for user's convenience. Existing XQuery engines don't have efficient method for batch processing of sensor data. This paper proposed the twig query processing over reverse path summary, and we developed and applied restructuring batch processing method for real time processing of a large amount of sensor data. Finally, we do performance evaluation using XMark and RFID EPC data, and comparison analysis with MonetDB/XQuery and Berkeley DB XML.