• Journal of KIISE
• /
• v.44 no.1
• /
• pp.1-12
• /
• 2017

The continuously growing internet service requirements has resulted in a multitier system structure consisting of web server and database (DB) server. In this multitier structure, the existing intrusion detection system (IDS) detects known attacks by matching misused traffic patterns or signatures. However, malicious change to the contents at DB server through hypertext transfer protocol (HTTP) requests at the DB server cannot be detected by the IDS at the DB server's end, since the DB server processes structured query language (SQL) without knowing the associated HTTP, while the web server cannot identify the response associated with the attacker's SQL query. To detect these types of attacks, the malicious user is tracked using knowledge on interaction between HTTP request and SQL query. However, this is a practical challenge because system's source code analysis and its application logic needs to be understood completely. In this study, we proposed a scheme to find the HTTP request associated with a given SQL query using only system log files. We first generated an HTTP request-SQL query map from system log files alone. Subsequently, the HTTP request associated with a given SQL query was identified among a set of HTTP requests using this map. Computer simulations indicated that the proposed scheme finds the HTTP request associated with a given SQL query with 94% accuracy.

• Korean Journal of Remote Sensing
• /
• v.34 no.5
• /
• pp.801-810
• /
• 2018

Ship monitoring using satellite synthetic aperture radar (SAR) images consists of ship detection, ship discrimination, and ship classification. A large number of methods have been proposed to improve the detection and discrimination capabilities, while only a few studies exist for ship classification. Thus, many studies for the ship classification are needed to construct ship monitoring system having high performance. Note that constructing database (DB), which contains both SAR images and labels of various ships, is important for research on the ship classification. In the airborne SAR classification, many methods have been developed using moving and stationary target acquisition and recognition (MSTAR) DB. However, there has been no publicly available DB for research on the ship classification using satellite SAR images. Recently, Shanghai Key Laboratory has constructed OpenSARShip DB using both SAR images of various ships generated from Sentinel-1 satellite of European Space Agency (ESA) and automatic identification system (AIS) information. Thus, the applicability of OpenSARShip DB for ship classification should be investigated by using the concepts of airborne SAR classification which have shown high performances. In this study, ship classification using satellite SAR images are conducted by applying the concepts of airborne SAR classification to OpenSARShip DB, and then the applicability of OpenSARShip DB is investigated by analyzing the classification performances.

• Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
• /
• 2002.03b
• /
• pp.153-159
• /
• 2002

This study mainly concentrates on the development of a land information management system to manage the land related information in an effective way for the water-pollutant buffering zone, which was established to sustain better quality of the drinking water over the upper part of the Han river. For developing such system, a procedure was implemented covering user requirement analysis, system design, spatial DB design, and coding. DB linkage with affiliated institutes and cadastral DB updating were proposed as the part of the efforts to enhance the applicability of the system. In addition to that, modularization was adopted for more efficient and cost-effective system development.

• Journal of Information Technology and Architecture
• /
• v.11 no.2
• /
• pp.225-233
• /
• 2014

In this paper an architecture for 3D audio core algorithm evaluation database system. Due to increase of 3D audio system through multimedia device, an evaluation system is required for evaluating the 3D core algorithms for developing 3D audio system. Conventional evaluation systems have some problems. Researchers have to learn usage of evaluation system, in addition it is inefficient to use and search audio sources because audio sources are not indexed in general. To solve these problems, we design the architecture of 3D audio core algorithm evaluation database system enabling to automatically evaluate core algorithms using database management system. Also we define XML metadata scheme for information of saved audio source in database. This approach allows improving efficiency of search audio source and use of audio database.

• Journal of Digital Convergence
• /
• v.11 no.2
• /
• pp.193-203
• /
• 2013

In our thesis we introduce case study for qualifying university graduates system for efficient maintenance. First, we find out factors to make maintenance difficult and present solution for them. Second, we convert system architecture from algorithm-oriented to driving-engine-based, design DB schema, develop algorithms for important components of proposed system, and implement them. Through results of system operation, we show that our system can reduce maintenance cost fairly.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.13 no.4
• /
• pp.1-11
• /
• 2010

This study proposed the method for the SWMM data generation connected with the spatial database and designed the data model in order to display flooding information such as the runoff sewer system, flooding areas and depth. A variety of data, including UIS, documents related to the disasters, and rainfall data are used to generate the attributes for flooding analysis areas. The spatial data is constructed by the ArcSDE and Oracle DB. The prototype system is also developed to display the runoff areas based on the GIS using the ArcGIS ArcObjects and spatial DB. The results will be applied to the flooding analysis based on the SWMM.

• Proceedings of the Acoustical Society of Korea Conference
• /
• 1998.08a
• /
• pp.56-59
• /
• 1998

POW 3848 DB 및 SNR 이 크게 다른 2 종류의 PC168 DB를 대상으로 가변어휘 음성인식 시스템을 이용하여 훈련 및 성능 평가 실험을 수행한 내용에 대해서 기술하고 있다. 실험의 목적은 위의 3종류의 DB를 조합하여 얻은 DB 환경하에서 인식기를 훈련시키면서, DB 의 조합 및 훈련방법에 따른 인식기의 성능과의 상관관계를 도출하고자 하였다. DB 의 조합은 POW DB 와 SNR 이 높은 PC DB , 및 3종류의 DB 모두로 구성하였다. 인식기는 40개의 음소로 구성된 문맥 독립형 SCHMM 모델이며, 각 음소당 3개의 상태로 이루어져 있다. 실험 결과, 대부분의 경우에서 ITERATION이 1.0인 경우에 최고 인식률을 나타내고 있으며, INTERATION 이 3.0 이상인 경우에는 항상 CASE 3의 실험방법이 우세한 결과를 나타내었다. 또한 CASE 1으로 훈련한 경우가 CASE 2 보다는 각각의 실험 DB 에 대해서 대체적으로 좋은 결과를 보였다.

• The Journal of the Korea Contents Association
• /
• v.17 no.4
• /
• pp.478-487
• /
• 2017

In recent years, developed countries have begun to pay attention to female workers through work-family balance in order to solve the problem of low fertility and aging. Korea has been building and running a women leaders database (hereafter, women leaders DB) centered on the female professionals since 2011. In particular, the Incheon women leader DB, which was built by Incheon city in 2009, is a classic example. As of 2015, about 2,735 people are registered in Incheon Women Leaders DB and it is systematically creating the database such as age, education, career years, major, occupation, and certification. However, there are administrative problems such as unspecified definition on professionalism and data trust issues including data entry, and DB personnels are concentrated in specific fields. Also, in the case of certification proving expertise, the utilization problem has been revealed including inclusion of private certification not yet verified. In order to solve these problems, we first need to clarify the concept of women leaders and establish the standard. The second is the improvement of data consistency through DB reorganization, and third is to build a system through continuous and active public relations that is used by both job seekers and recruiters.

• Proceedings of the Korean Institute of IIIuminating and Electrical Installation Engineers Conference
• /
• 2002.11a
• /
• pp.239-242
• /
• 2002

With existing illumination rendering system being used in domestic, internationally developed common programs are taking over the market more than 90%. However, since the programs are established with DB designed to be most suitable for their own products, accuracy in analysis and visualized image are hardly reliable. This raises the necessities of establishing DB for domestic developed products. A method of establishing artificial luminair DB, which was studied on DB establishment in consideration of optical characteristics of domestic products with using RADIANCE program was presented in this study, and it is considered as the program of simulating light movement most accurately among all rendering programs developed so far.

• The Transactions of The Korean Institute of Electrical Engineers
• /
• v.65 no.3
• /
• pp.469-476
• /
• 2016

Relational Database Management Systems have become de facto database model among most developers and users since the inception of Data Science. From IoT devices, sensors, social media and other sources, data is generated in structured, semi-structured and unstructured formats, in huge volumes, thereby the difficulty of data management greatly increases. Organizations that collect large amounts of data are increasingly turning to non relational databases - NoSQL databases. In this paper, through experiments with real field data, we demonstrate that MongoDB, a document-based NoSQL database, is a better alternative for building a Telco Subscriber Data Management System which hitherto is mainly built with Relational Database Management Systems. We compare the existing system in various phases of data flow with our proposed system powered by MongoDB. We show how various workloads at some phases of the existing system were either completely removed or significantly simplified on the new system. Based on experiment results, using MongoDB for managing telco subscriber data turned out to offer performance better than the existing system built with MSSQL Server.