• 한국측량학회지
• /
• 제40권5호
• /
• pp.393-402
• /
• 2022

지하시설물의 효과적인 데이터의 관리는 인간 삶 측면에서 매우 중요하다. 여기에는 최신성의 정확도 높은 데이터의 입력이 선행되어야 한다. 그래서 효율적인 데이터를 입력을 위한 방법이 중요하다. 본 연구에서는 오픈소스(open source) 소프트웨어를 활용하여 하수 시설물 현장조사 프로그램을 개발함으로써 종이도면을 태블릿PC로 대체할 수 있도록 하였다. 태블릿PC를 활용하여 현장에서 취득하는 도형 및 속성정보를 데이터베이스 서버를 통해 실시간으로 전송하도록 하였으며, PostGIS 쿼리(query)를 개발하여 구조화편집 자동화로 하수 시설물 GIS (Geographic Information System) 데이터베이스 구축에 수작업을 최소화하였다. 또한, 하수 시설물 GIS 데이터베이스 구축 프로그램을 활용하여 데이터베이스 구축을 하였고, 이를 기존방식의 하수 시설물 데이터베이스 구축과 작업공정, 작업시간을 비교·분석한 결과 작업공정이 단순화되었고 작업시간이 단축되었다. 아울러 오픈소스 소프트웨어의 간단한 커스터마이징을 통해 타 분야의 현장조사 및 데이터베이스 구축에 활용할 수 있을 것이다.

• 천문학회보
• /
• 제41권2호
• /
• pp.53.2-53.2
• /
• 2016

We present our experiences with open-source spatio-temporal database systems for managing and analyzing big astronomical data acquired by wide-field time-domain sky surveys. Considering performance, cost, difficulty, and scalability of the database systems, we conduct comparison studies of open-source spatio-temporal databases such as GeoMesa and PostGIS that are already being used for handling big geographical data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical spatio-temporal data. We choose the public VVV (VISTA Variables in the Via Lactea) catalogs of billions measurements for hundreds of millions objects as the test data. We discuss issues of how these spatio-temporal database systems can be adopted in the astronomy community.

• 한국정보통신학회:학술대회논문집
• /
• 한국정보통신학회 2014년도 춘계학술대회
• /
• pp.631-634
• /
• 2014

웹과 클라우드 컴퓨팅 환경 구축시에 필수적으로 사용되는 것이 데이터베이스 시스템이다. 이러한 데이터베이스 시스템에는 오라클과 MS-SQL 등과 같은 상용 프로그램도 있지만, 상용 프로그램에 필적할 성능을 가진 무료 프로그램도 다수 존재한다. 특히, PostgreSQL, MySQL, MariaDB 등은 비용도 들지 않지만, 소스도 공개되어 있어서 다양한 환경에 적용할 수 있다. 본 논문에서는 소스가 공개된 관계형 데이터베이스 관리 시스템의 동향에 대해 알아본다.

• 융합보안논문지
• /
• 제19권2호
• /
• pp.113-121
• /
• 2019

인터넷과 정보통신기술의 발달로 매일 대량의 공개출처정보(Open Source Intelligence, OSINT)가 발생하고 있다. 최근에는 전체 정보의 95%가 공개출처정보에서 나온다고 할 정도로 공개출처의 활용도가 높아졌다. 이러한 공개출처정보는 잘 정제되어 활용된다면 매우 효과적인 고가치 정보로 활용될 수 있다. 일례로 ISVG나 START 프로그램은 테러나 범죄와 관련된 공개출처정보를 수집해 테러리스트 색출이나 범죄예방에 활용해 많은 효과를 거두고 있다. 하지만 사이버공격과 관련된 공개출처정보는 기존의 테러나 범죄와 관련된 공개출처정보와는 달리 공격자, 공격목적, 피해범위 등을 명확히 식별하기 어렵고, 자료 자체가 상대적으로 정형화되지 않았다는 특징이 있다. 이러한 이유 때문에 공개출처정보를 활용해 사이버공격에 대한 데이터베이스(Database, DB)를 구축하고 활용하기 위해서는 기존의 방식과는 전혀 다른 새로운 접근방식이 요구된다. 따라서 본 논문에서는 공개출처정보를 활용해 사이버공격 데이터베이스를 구축하는 방법론을 제시하고 향후 활용방안에 대해 토의하고자 한다.

• 천문학회보
• /
• 제42권2호
• /
• pp.88.3-89
• /
• 2017

We present our experiences with open-source NoSQL database systems in analyzing spatial and temporal astronomical data. We conduct experiments of using Redis in-memory NoSQL database system by modifying and exploiting its support of geohash for astronmical spatial data. Our experiment focuses on performance, cost, difficulty, and scalability of the database system. We also test OpenTSDB as a possible NoSQL database system to process astronomical time-series data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical time-series measurements. We choose our KMTNet data and the public VVV (VISTA Variables in the Via Lactea) catalogs as test data. We discuss issues in using these NoSQL database systems in astronomy.

• 한국BIM학회 논문집
• /
• 제5권2호
• /
• pp.19-25
• /
• 2015

The purpose of this study is to design simple BIM query language for visualizing BIM information as the viewpoint of use-cases by using open source viewer cost-effectively. recently, the studies related to the facility management using BIM are being researched world-widely. In this studies, it's important to develop the BIM query to obtain the needed data from BIM database. To implement it, the trends in related studies were reviewed and the open source-based BIM viewer architecture was analyzed. And then the architecture considering the simple BIM Query Language (sBQL) was designed to represent the geometry and property of the BIM database. Lastly, the system by using the proposed sBQL grammar was developed.

• 대한원격탐사학회지
• /
• 제26권3호
• /
• pp.361-371
• /
• 2010

In recent, interests regarding open source software for geo-spatial processing are increasing. Open source remote sensing (OSRS) is regarded as one of the progressing and advanced fields in remote sensing. Nevertheless, analyses or application cases regarding OSRS are not enough for general uses or references. In this study, three kinds of OSRS software in consideration of international popularity, types of functionalities, and development environments are taken into account: OSSIM, Opticks, and ORFEO Toolbox (OTB). First, functional comparison with respect to these is carried out on the level of the preliminary survey. According to this investigation, OTB is chosen as the most applicable OSRS software in this study. Running on OTB, NIX format importing module and database connecting module are implemented for widely general uses and further application. As for an example case, airborne image of NIX format is used to region growing segmentation algorithm in OTB, and then the results are stored and retrieved in PostGIS database to test implemented modules. Conclusively, local customization and algorithm development using OSRS software are necessary to build on-demand applications from the developers' viewpoint.

• International Journal of Computer Science & Network Security
• /
• 제21권12호
• /
• pp.280-292
• /
• 2021

Enterprise Resource Planning (ERP) is a software that manages and automate the internal processes of an organization. Process speed and quality can be increased, and cost reduced by process automation. Odoo is an open source ERP platform including more than 15000 apps. ERP systems such as Odoo are all-in-one management systems. Odoo can be suitable for small and medium organizations, but duo to efficiency limitations, Odoo is not suitable for the large ones. Furthermore, Odoo can be implemented on both local or public servers in which each has some advantages and disadvantages such as; the speed of internet, synced data or anywhere access. In many cases, there is a persistent need to have more than one synchronized Odoo instance in several physical places. We modified Odoo to support this kind of requirements and improve its efficiency by replacing its standard database with a distributed one, namely CockroachDB.

• International Journal of Internet, Broadcasting and Communication
• /
• 제10권2호
• /
• pp.31-38
• /
• 2018

As the use of open source databases grows, so does need to evaluate, the performance of search queries for these databases. This paper compares the search query performance of SQL-based open source databases with commercial databases through experiments. The targets are MySql, MariaDB, and MS-SQL Server. In this study, the execution time of various types of search queries are measured. Also, search query performance was experimented according to change of index and number of tuples. Experimental results show that SQL-based open source databases have the potential to replace commercial databases when indexes are used and the number of tuples is not very large.

• 품질경영학회지
• /
• 제45권4호
• /
• pp.933-942
• /
• 2017

Purpose: The purpose of this paper is to evaluate the performance quality of the open source DBMSs. Performance quality is defined as processing time for Join queries. Query processing time is measured and compared in the most widely used open source DBMSs and commercial DBMS. Methods: By varying the number of tuples of two relations to be joined, the average processing time(seconds) of a Join query in each DBMS was obtained experimentally. ANOVA and Tukey HSD test were used in order to compare the performance quality of DBMSs. Results: There was a significant difference between the performance qualities of the three DBMSs at all experimental levels where the number of tuples was 100, 1,000, 2,000, 10,000, and 50,000. As a result of the Tukey HSD test, two open source DBMSs (MariaDB, MySQL) were classified in the same group only at the tuple level of 100. The commercial DBMS (MS-SQL Server) belonged to another group. At level of more than 1,000 tuples, all three DBMSs belonged to different groups. Conclusion: Within the open source DBMS group, MariaDB showed the better performance quality except for a small number of tuples. Thus the results show that MariaDB can be the alternative to MySQL which is currently most widely used. Between open source DBMS and commercial DBMS groups, MS-SQL Server always shows the best performance quality, but the less number of tuples, the less the difference.