• Title/Summary/Keyword: Database Retrieval

Search Result 741, Processing Time 0.022 seconds

Data-warehouse Prototype for Supporting Master Plan of Renewal Promotion Projects (재정비촉진사업 마스터플랜 지원 데이터웨어하우스 프로토타입)

  • Cho, Dong-Hyun;Koo, Kyo-Jin
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.16 no.9
    • /
    • pp.6376-6384
    • /
    • 2015
  • In practice of urban redevelopment promotion projects, since the decision-making is dependent on the verbal agreements between the participants, planning changes are frequently occur. A master plan can be utilized as an effective feedback and adjusting means for decisions. It is a difficult to establish a master plan quickly and effectively to consider the large number of information. Effective decision support system that can storage and retrieval information items systematically and efficiently necessary when planning master plan is required. In this study, a data-warehouse prototype that supports the master planning at early stage was suggested. A metadata index database was developed by identifying information items of base survey results and master plan cases. Also user interface for information searching was presented. The applicability of the prototype was evaluated by case application. It was found that the prototype allows effective searching of desired information through meta data.

An RDBMS-based Inverted Index Technique for Path Queries Processing on XML Documents with Different Structures (상이한 구조의 XML문서들에서 경로 질의 처리를 위한 RDBMS기반 역 인덱스 기법)

  • 민경섭;김형주
    • Journal of KIISE:Databases
    • /
    • v.30 no.4
    • /
    • pp.420-428
    • /
    • 2003
  • XML is a data-oriented language to represent all types of documents including web documents. By means of the advent of XML-based document generation tools and grow of proprietary XML documents using those tools and translation from legacy data to XML documents at an accelerating pace, we have been gotten a large amount of differently-structured XML documents. Therefore, it is more and more important to retrieve the right documents from the document set. But, previous works on XML have mainly focused on the storage and retrieval methods for a large XML document or XML documents had a same DTD. And, researches that supported the structural difference did not efficiently process path queries on the document set. To resolve the problem, we suggested a new inverted index mechanism using RDBMS and proved it outperformed the previous works. And especially, as it showed the higher efficiency in indirect containment relationship, we argues that the index structure is fit for the differently-structured XML document set.

Implementation of an Information Management System for Nucleotide Sequences based on BSML using Active Trigger Rules (BSML 기반 능동 트리거 규칙을 이용한 염기서열정보관리시스템의 구현)

  • Park Sung Hee;Jung Kwang Su;Ryu Keun Ho
    • Journal of KIISE:Databases
    • /
    • v.32 no.1
    • /
    • pp.24-42
    • /
    • 2005
  • Characteristics of biological data including genome sequences are heterogeneous and various. Although the need of management systems for genome sequencing which should reflect biological characteristics has been raised, most current biological databases provide restricted function as repositories for biological data. Therefore, this paper describes a management system of nucleotide sequences at the level of biological laboratories. It includes format transformation, editing, storing and retrieval for collected nucleotide sequences from public databases, and handles sequence produced by experiments. It uses BSML based on XML as a common format in order to extract data fields and transfer heterogeneous sequence formats. To manage sequences and their changes, version management system for originated DNA is required so as to detect transformed new sequencing appearance and trigger database update. Our experimental results show that applying active trigger rules to manage changes of sequences can automatically store changes of sequences into databases.

Design and Implementation of a Vehicle Management System for Effective Retrieval of Vehicle Locations (효과적인 차량 위치 검색을 위한 차량 관리 시스템의 설계 및 구현)

  • Lee Eung Jae;Oh Jun Seok;Jung Young Jin;Nam Kwang Woo;Lee Bong Gyou;Ryu Keun Ho
    • Journal of KIISE:Databases
    • /
    • v.32 no.1
    • /
    • pp.71-85
    • /
    • 2005
  • Various researches on moving object modeling, uncertainty processing, and moving object indexing have been tarried out in the field of moving object databases. However. previous location tracking systems cannot efficiently retrieve location data of vehicles, because they manage all location information of vehicles using the conventional database. In this paper, we design the vehicle location management systen that is able to manage and retrieve vehicle locations efficiently in mobile environment. The proposed system consists of a server for managing vehicle locations and mobile clients. The system is able to not only process spatiotemporal queries related to locations of moving vehicles but also Provide moving vehicles' locations which are not stored in the system. The system is also able to manage vehicle location data effectively using a moving object index.

Study on a Web-based Testbed for Historical Astronomy Records and Accounts Services

  • Seo, Yoon Kyung;Mihn, Byeong-Hee;Kim, Sang Hyuk;Ahn, Young Sook;Lee, Ki-Won;Choi, Goeun;Ham, Seon Young
    • The Bulletin of The Korean Astronomical Society
    • /
    • v.43 no.2
    • /
    • pp.49.3-50
    • /
    • 2018
  • Korea has kept its records of astronomical phenomena since around 2,000 years ago. However, the contents and scope of relevant service have been limited for researchers who need those records due to lack of complete data collection. In this regard, it is necessary to establish efficient collection and management systems of Korean astronomical records by utilizing an environment that is easily accessible. This study is intended to complete the development of a testbed system that allows researchers to systematically input and validate, in a Web environment, multiple astronomical records among the historical documents until Modern Joseon after the Three Kingdoms Period. Recognition of the pre-translated data and tables in advance is followed by its storage in the database built on the Web. Then, data validation is implemented by providing a retrieval service according to a specific form to only a finite number of researchers who have access authority. This study is targeted at a testbed system that takes around three months to be completely developed. The completed testbed system is expected to allow internal and external researchers of an organization to easily access the service on the Web. This will ensure that the accuracy of the data can be verified mutually and help identify areas of service improvement. The opinions collected regarding service improvement will be reflected in the future system. Eventually, domestic astronomical records will subsequently be able to be utilized internationally through the multilingual service.

  • PDF

An Automated Industry and Occupation Coding System using Deep Learning (딥러닝 기법을 활용한 산업/직업 자동코딩 시스템)

  • Lim, Jungwoo;Moon, Hyeonseok;Lee, Chanhee;Woo, Chankyun;Lim, Heuiseok
    • Journal of the Korea Convergence Society
    • /
    • v.12 no.4
    • /
    • pp.23-30
    • /
    • 2021
  • An Automated Industry and Occupation Coding System assigns statistical classification code to the enormous amount of natural language data collected from people who write about their industry and occupation. Unlike previous studies that applied information retrieval, we propose a system that does not need an index database and gives proper code regardless of the level of classification. Also, we show our model, which utilized KoBERT that achieves high performance in natural language downstream tasks with deep learning, outperforms baseline. Our method achieves 95.65%, 91.51%, and 97.66% in Occupation/Industry Code Classification of Population and Housing Census, and Industry Code Classification of Census on Basic Characteristics of Establishments. Moreover, we also demonstrate future improvements through error analysis in the respect of data and modeling.

An Analysis of Clinical Research Trends on Interventions of Korean Medicine for Ovarian Cysts (난소 낭종의 한의학적 치료에 대한 국내 임상연구 동향 분석)

  • Jeoung-Yoon Choi;Jin-Moo Lee;Chang-Hoon Lee;Jun-Bock Jang;Deok-Sang Hwang
    • The Journal of Korean Obstetrics and Gynecology
    • /
    • v.36 no.3
    • /
    • pp.25-45
    • /
    • 2023
  • Objectives: The purpose of this study is to review the clinical research trends of ovarian cysts and to recognize the efficacy of Korean medicine intervention. Methods: Based on four domestic databases, including Korean studies Information Service System (KISS), Oriental Medicine Advanced Searching Integrated System (OASIS), Korean Medical Database (KMbase) and Research Information Sharing Service (RISS), we analyzed the case reports using Korean medicine intervention, which include acupuncture, moxibustion and herbal medicine. Data retrieval was carried out from May 12th, to 18th, 2022, and a total of 9 papers were included. Results: All papers were published in Korea and they contain seventeen case reports in total. The most frequently used intervention was herbal medicine, especially Gyejibokryeong-hwan-gami (桂枝茯苓丸加味), Guichulpajing-tang-gagam (歸朮破癥湯加減), Guibiondam-tang-gami (歸脾溫膽湯加味). Most cases reported statistically significant results on using Korean-medicine intervention. Also, there was no serious side effect of Korean medicine. Conclusions: In this study, we investigated the efficacy of Korean medicine intervention as an adjuvant therapy for ovarian cyst patients and research trends on ovarian cysts. Further studies are needed to supplement the safety and the evaluation of Korean medicine. However, the results should be taken cautiously as more clinical studies are needed.

Efficient video matching method for illegal video detection (불법 동영상 검출을 위한 효율적인 동영상 정합 방법)

  • Choi, Minseok
    • Journal of Digital Convergence
    • /
    • v.20 no.1
    • /
    • pp.179-184
    • /
    • 2022
  • With the development of information and communication technology, the production and distribution of digital contents is rapidly increasing, and the distribution of illegally copied contents also increases, causing various problems. In order to prevent illegal distribution of contents, a DRM (Digital Rights Management)-based approach can be used, but in a situation where the contents are already copied and distributed, a method of searching and detecting the duplicated contents is required. In this paper, a duplication detection method based on the contents of video content is proposed. The proposed method divides the video into scene units using the visual rhythm extracted from the video, and hierarchically applies the playback time and color feature values of each divided scene to quickly and efficiently detect duplicate videos in a large database. Through experiments, it was shown that the proposed method can reliably detect various replication modifications.

A Study on Constructing a Digital Archive System of the Modern Korean Christian Collections (근대 한국기독교 자료의 디지털 아카이브 시스템 구축에 관한 연구)

  • Yang, Ji-Ann
    • The Journal of the Korea Contents Association
    • /
    • v.22 no.8
    • /
    • pp.681-691
    • /
    • 2022
  • The purpose of this study is to construct a digital archive system by analyzing the collections of the Korean Christian Museum at S University, which has a large number of materials related to Korean Christianity published in the modern period from the time of Korea's enlightenment until liberation. In order to construct a digital archive system, indexes and metadata for the collection are complied according to the pre-defined format. After digitizing the selected collection, a database is built using metadata information, and the actual system is divided into a web standard-based management system and a user service system. Also a content-based search system is constructed, which provides the matching value of retrieval results in units of one character and an automatic search term completion function to enhance user convenience. Therefore, collections in the museum, which are difficult to access the original text, are digitized and provided so that they can be easily used, laying the foundation for the long-term development of humanities contents for improving the accessibility and availability of collections for both researchers and the public.

Audio Fingerprint Extraction Method Using Multi-Level Quantization Scheme (다중 레벨 양자화 기법을 적용한 오디오 핑거프린트 추출 방법)

  • Song Won-Sik;Park Man-Soo;Kim Hoi-Rin
    • The Journal of the Acoustical Society of Korea
    • /
    • v.25 no.4
    • /
    • pp.151-158
    • /
    • 2006
  • In this paper, we proposed a new audio fingerprint extraction method, based on Philips' music retrieval algorithm, which uses the energy difference of neighboring filter-bank and probabilistic characteristics of music. Since Philips method uses too many filter-banks in limited frequency band, it may cause audio fingerprints to be highly sensitive to additive noises and to have too high correlation between neighboring bands. The proposed method improves robustness to noises by reducing the number of filter-banks while it maintains the discriminative power by representing the energy difference of bands with 2 bits where the quantization levels are determined by probabilistic characteristics. The correlation which exists among 4 different levels in 2 bits is not only utilized in similarity measurement. but also in efficient reduction of searching area. Experiments show that the proposed method is not only more robust to various environmental noises (street, department, car, office, and restaurant), but also takes less time for database search than Philips in the case where music is highly degraded.