• Journal of KIISE:Software and Applications
• /
• v.31 no.11
• /
• pp.1505-1518
• /
• 2004

We propose an extremely light DDXMI approach for semi-automated integration of both structurally and semantically heterogeneous distributed XML documents. In the proposed prototype, a DDXMI(Distributed Documents XML Metadata Interface) is defined and a user interface generator is developed. The prototype takes sources' DTDs as inputs and generates a friendly graphical user interface for the application users. The user can easily describe the semantic mapping between the integrated virtual database DTD and sources' DTDs through assigning index numbers and specifying associated function names so that the DDXMI based on the mappings is automatically generated. Quilt is selected as the XML query language which processes user queries according to the DDXMI. It is assumed that the application users know what they want from the different sources, that is, they have their own integrated database schema in their mind, and know the semantics of the involved XML databases. A small-size global DTD and a mid-size global DTB are generated to verify the rluery generation and retrieval results with 3 XML document databases, that is, Master/ph.D thesis, research reports, and journal databases. The system has been developed with JavaCC and Java Servelet.

• Environmental Analysis Health and Toxicology
• /
• v.30
• /
• pp.10.1-10.14
• /
• 2015

Recent cohort studies have relied on exposure prediction models to estimate individual-level air pollution concentrations because individual air pollution measurements are not available for cohort locations. For such prediction models, geographic variables related to pollution sources are important inputs. We demonstrated the computation process of geographic variables mostly recorded in 2010 at regulatory air pollution monitoring sites in South Korea. On the basis of previous studies, we finalized a list of 313 geographic variables related to air pollution sources in eight categories including traffic, demographic characteristics, land use, transportation facilities, physical geography, emissions, vegetation, and altitude. We then obtained data from different sources such as the Statistics Geographic Information Service and Korean Transport Database. After integrating all available data to a single database by matching coordinate systems and converting non-spatial data to spatial data, we computed geographic variables at 294 regulatory monitoring sites in South Korea. The data integration and variable computation were performed by using ArcGIS version 10.2 (ESRI Inc., Redlands, CA, USA). For traffic, we computed the distances to the nearest roads and the sums of road lengths within different sizes of circular buffers. In addition, we calculated the numbers of residents, households, housing buildings, companies, and employees within the buffers. The percentages of areas for different types of land use compared to total areas were calculated within the buffers. For transportation facilities and physical geography, we computed the distances to the closest public transportation depots and the boundary lines. The vegetation index and altitude were estimated at a given location by using satellite data. The summary statistics of geographic variables in Seoul across monitoring sites showed different patterns between urban background and urban roadside sites. This study provided practical knowledge on the computation process of geographic variables in South Korea, which will improve air pollution prediction models and contribute to subsequent health analyses.

• Journal of KIISE:Software and Applications
• /
• v.36 no.4
• /
• pp.306-319
• /
• 2009

A name is a key feature for distinguishing people, but we often fail to discriminate people because an author may have multiple names or multiple authors may share the same name. Such name ambiguity problems affect the performance of document retrieval, web search and database integration. Especially, in bibliography information, a number of errors may be included since there are different authors with the same name or an author name may be misspelled or represented with an abbreviation. For solving these problems, it is necessary to disambiguate the names inputted into the database. In this paper, we propose a method to solve the name ambiguity by using social networks constructed based on the relations between authors. We evaluated the effectiveness of the proposed system based on DBLP data that offer computer science bibliographic information.

• Proceedings of the Korean Society for Bioinformatics Conference
• /
• 2000.11a
• /
• pp.21-22
• /
• 2000

Expressed sequence tags (EFTs) are the partial segments of cDNA produced from 5 or 3 single-pass sequencing of cDNA clones, error-prone and generated in highly redundant sets. Advancement and expansion of Genomics made biologists to generate huge amount of ESTs from variety of organisms-human, microorganisms as well as plants, and the cumulated number of ESTs is over 5.3 million, As the EST data being accumulate more rapidly, it becomes bigger that the needs of the EST analysis tools for extraction of biological meaning from EST data. Among the several needs of EST analyses, the extraction of protein sequence or functional motifs from ESTs are important for the identification of their function in vivo. To accomplish that purpose the precise and accurate identification of the region where the coding sequences (CDSs) is a crucial problem to solve primarily, and it will be helpful to extract and detect of genuine CD5s and protein motifs from EST collections. Although several public tools are available for EST analysis, there is not any one to accomplish the object. Furthermore, they are not targeted to the plant ESTs but human or microorganism. Thus, to correspond the urgent needs of collaborators deals with plant ESTs and to establish the analysis system to be used as general-purpose public software we constructed the pipelined-EST analysis system by integration of public software components. The software we used are as follows - Phred/Cross-match for the quality control and vector screening, NCBI Blast for the similarity searching, ICATools for the EST clustering, Phrap for EST contig assembly, and BLOCKS/Prosite for protein motif searching. The sample data set used for the construction and verification of this system was 1,386 ESTs from human intrathymic T-cells that verified using UniGene and Nr database of NCBI. The approach for the extraction of CDSs from sample data set was carried out by comparison between sample data and protein sequences/motif database, determining matched protein sequences/motifs that agree with our defined parameters, and extracting the regions that shows similarities. In recent future, in addition to these components, it is supposed to be also integrated into our system and served that the software for the peptide mass spectrometry fingerprint analysis, one of the proteomics fields. This pipelined-EST analysis system will extend our knowledge on the plant ESTs and proteins by identification of unknown-genes.

• Journal of Intelligence and Information Systems
• /
• v.17 no.4
• /
• pp.37-58
• /
• 2011

In general, testing DB applications is much more difficult than testing other types of software. The fact that the DB states as much as the input data influence and determine the procedures and results of program testing is one of the decisive reasons for the difficulties. In order to create and maintain proper DB states for testing, it not only takes a lot of time and efforts, but also requires extensive IT expertise and business knowledge. Despite the difficulties, there are not enough research and tools for the needed help. This article reports the result of research on automatic creation and maintenance of DB states for testing DB applications. As its core, this investigation develops an automation tool which collects relevant information from a variety of sources such as log, schema, tables and messages, combines collected information intelligently, and creates pre- and post-Images of database tables proper for application tests. The proposed procedures and tool are expected to be greatly helpful for overcoming inefficiencies and difficulties in not just unit and integration tests but including regression tests. Practically, the tool and procedures proposed in this research allows developers to improve their productivity by reducing time and effort required for creating and maintaining appropriate DB sates, and enhances the quality of DB applications since they are conducive to a wider variety of test cases and support regression tests. Academically, this research deepens our understanding and introduces new approach to testing enterprise systems by analyzing patterns of SQL usages and defining a grammar to express and process the patterns.

• KIISE Transactions on Computing Practices
• /
• v.24 no.2
• /
• pp.59-66
• /
• 2018

In this paper, we propose a system to detect various damage automatically inflicted on road pavement by collecting and analyzing data from acceleration and camera sensors in real time. The proposed system sends the collected images, acceleration signals, and GPS coordinates to the road manager and the database in the remote server, shortly after detecting the damage to the road pavement. Our study makes three key contributions. The proposed system 1) enables road managers to maintain road conditions quickly, accurately, and conveniently; 2) allows road mangers to take care of various kinds of damage to the road pavement at the initial stage; and finally 3) even makes it possible to track the damage, which suggests that the integration of a high-level decision support function becomes affordable. We tested the sensitivity and precision of the proposed system against real-time data obtained from the vehicles driving on the highway at an average speed of 100 km/h. With ten iterations, the proposed system achieved an average sensitivity of 74% and an average precision of 84% in road pavement damage detection, which is comparable with the best competing schemes.

• The Journal of the Korea Contents Association
• /
• v.5 no.5
• /
• pp.43-50
• /
• 2005

POS system that become that is supply net administration and computerization fetters of customer management that become point in istribution network constructed database and use XML-Encryption that is certificate techniques of PKI and standard of security for security that is XML's shortcoming and design distributed processing POS system using XML for data integration by introduction of Ubiquitous concept. This POS system has four advantages. First, Because there is no server, need not to attempt authentication and data transmission every time. Second, can integrate data base by XML and improve portability of program itself. Third, XML data in data transmission because transmit data after encryption data safe .Fourth, After encode whenever process data for data breakup anger of POS system client program and elevation of the processing speed, transmit at because gathering data at data transmission.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.16 no.3
• /
• pp.164-179
• /
• 2013

Ulaanbaatar city, the capital of Mongolia and the center of Mongolian economy, increasingly needs to have a long-term urban planning and a system to impose a tax on land effectively as insufficient development of land and the moving of nomad into urban areas increases during its rapid growth. Therefore, Mongolian government has to prepare a land management system which provides the infrastructure to improve work efficiency and service quality by integrating digitalized data about land and main facilities and sharing data between related departments. This research analyzed the environment to operate the existing land management system and working environment and redesigned database. Furthermore, it integrated all the existing systems, configured service network, and made working environment for land registration, land permission, land payment management to be processed online. With this, it provides the foundation to improve quality of people's life through the preparation of long term urban planning, clean tax administration of real estate, and reconsideration of efficiency about urban infrastructure investment.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.6
• /
• pp.1453-1463
• /
• 1997

This paper proposes service mechanism for realization of Multimedia-On-demand(MOD) and implementation of a real-time MOD service through the interface of WWW environment with ATM at its backbone. As part of this proposal, we have adopted the naive ATM interface and the CM transport module, and have then implemented a WWW-based Multimedia-On-Demand. In this thesis, we have proposed WWW-based user interface using Java. CGI internet programming method. And we have implemented service mechanism through integration of Database with WWW.

• Spatial Information Research
• /
• v.11 no.4
• /
• pp.391-407
• /
• 2003

Recently, a lot of interests are commanding in link practical use of country information and cadastral information for management of efficient country resource and administration of land. As map information, a lot of interests are commanding in construction of synthetic informations system including digital map and cadastral map. In this study, achieves analysis about non-coincidence causes of digital map and cadastral map, and achieve investigation about representative algorithm that is used in conversion of map for correct overlay between two map and opes overlay plan. Also, presented plan that can ready fetters for integration database construction of digital map and cadastral map by achieving study about matching security plan between map and plan elevation of the quality.