• Title/Summary/Keyword: DB system

Search Result 2,135, Processing Time 0.024 seconds

Design and Implementation of a Spatial Sensor Database System for the USN Environment (USN 환경을 위한 공간 센서 데이타베이스 시스템의 설계 및 구현)

  • Shin, In-Su;Liu, Lei;Kim, Joung-Joon;Chang, Tae-Soo;Han, Ki-Joon
    • Spatial Information Research
    • /
    • v.20 no.1
    • /
    • pp.59-69
    • /
    • 2012
  • For the USN(Ubiquitous Sensor Network) environment which generally uses spatial sensor data as well as aspatial sensor data, a sensor database system to manage these sensor data is essential. In this reason, some sensor database systems such as TinyDB, Cougar are being developed by many researchers. However, since most of them do not support spatial data types and spatial operators to manage spatial sensor data, they have difficulty in processing spatial sensor data. Therefore, this paper developed a spatial sensor database system by extending TinyDB. Especially, the system supports spatial data types and spatial operators to TinyDB in order to manage spatial sensor data efficiently and provides the memory management function and the filtering function to reduce the system overload caused by sensor data streams. Lastly, we compared the processing time, accuracy, and memory usage of the spatial sensor database system with those of TinyDB and proved its superiority through the performance evaluation.

An Implementation of DB Query Collecting and Analyzer Using Packet Interceptor (패킷 인터셉터를 이용한 DB 쿼리 수집 및 분석기 구현)

  • Lim, Jae-Deok;Lim, Sung-Han;Baek, Nam-Chul
    • The Journal of The Korea Institute of Intelligent Transport Systems
    • /
    • v.7 no.4
    • /
    • pp.97-106
    • /
    • 2008
  • This proposed system is a part of internal control system that national highway need to support their ITS information audit. This paper explains the design and implementation of a packet interceptor and a DB query analyzer. The packet interceptor sniffs users' query packets, and then the DB query analyzer parses the SQL queries and stores the users' DB access information such as SQL queries, access data and changing data. The information may be used as the evidences on internal control of users and users' accesses.

  • PDF

Low-cost Authentication Protocol Using Pre-synchronized Search Information in RFID System (검색 정보 사전 동기화를 이용한 저비용 RFID 인증 방식)

  • Ha, Jae-Cheol;Park, Jea-Hoon;Ha, Jung-Hoon;Kim, Hwan-Koo;Moon, Sang-Jae
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.18 no.1
    • /
    • pp.77-87
    • /
    • 2008
  • Recently, many hash-based authentication protocols were presented to guarantee mutual authentication between tag and DB in RFID system. To be suitable for distributed DB environment, one generally uses fixed constant value as a tag ID. However, some existing protocols have security flaws or heavy computational loads in DB in order to search a tag ID. We propose a secure authentication protocol which is suitable for distributed DB environment by using unchangeable tag ID. The storage method of pre-synchronized information in DB at previous session is core idea of our proposal which gives low-cost ID search of DB at next session. In normal synchronization state, our protocol only requires 3 hash operations in tag and DB respectively.

A Study on Management Methodology of Local Government Underground Facility Database Using Mobile Mapping System I (MMS를 활용한 지자체 지하시설물 DB의 유지관리 방법론 연구 I)

  • Ryu, Ji-Ho;Yong, Min;Kim, Tai-Yohb;Lee, Hyun-Jik
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2004.04a
    • /
    • pp.353-359
    • /
    • 2004
  • Underground facility DB that is constructed by NGIS project need efficient management methodology, because falling-off in quality was worried by confused of existing management affair and management affair of computerization environment. Through analysis of existing management affair, underground facility DB and management system decide that modification/renewal factor of underground facility DB and subject affair Through modification/renewal factor of underground facility DB, developed underground facility DB management methodology using MMS. Result that apply developed management methodology to subject affair, existing affair environment improved to computerization environment and Could improve underground facilities DB authoritativeness.

  • PDF

A Study Of DB System For Seoul Bike Road (서울시 자전거 도로 DB 시스템에 대한 연구)

  • Bak, Yurim;Lee, A-Rang;Lee, Jeonghwa
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2016.04a
    • /
    • pp.607-610
    • /
    • 2016
  • 최근 자전거 이용인구가 급격하게 증가함에 따라 자전거 교통사고 역시 증가하고 있다. 이에 DB를 통해 이용자에게 알맞은 자전거 도로에 대한 정보를 제공하여 자전거 도로를 활성화하고자 다음과 같은 프로젝트를 진행하게 되었다. 서울시를 중심으로 사용자의 지역, 선호하는 길이, 난이도에 따른 DB를 제공하여 알맞은 자전거 도로를 선택하도록 하였으며, 기업에게는 자전거 이용자의 DB를 제공하여 마케팅에 활용할 수 있도록 하였다.

A Design and Implementation of DB System for Providing Comprehensive Information Retrieval Service about Social Economic Information

  • Lee, Cheol-won;Jeon, Heung Seok;Noh, Younghee
    • Journal of the Korea Society of Computer and Information
    • /
    • v.22 no.5
    • /
    • pp.73-79
    • /
    • 2017
  • In this paper, we propose a design and implementation of a DB system for providing comprehensive information retrieval service about social economic information. We classify social economic organizations into 6 major categories and 35 small categories. The DB contains 25,938 social economic organizations in total. The DB system provides simple and intuitive interface for searching information such as keyword search, category search and initial search. Fully loaded time of webpage of implemented DB system achieved 2.3s by Vancouver, Canada Server.

A Study on Real-time Quality Evaluation Method of Bibliographic Database (실시간 서지데이터베이스 평가방법에 관한 연구)

  • 노경란;권오진;유현종;문영호;홍성화
    • The Journal of the Korea Contents Association
    • /
    • v.2 no.4
    • /
    • pp.76-84
    • /
    • 2002
  • The conventional database evaluation method is carried out by the way in which the person in charge of each specialty database(DB manager) composes the evaluation sheets for corretionㆍrevision on the already-constructed database in a manual method and carries out the measurement and re-education of DB workers based upon it. As a result, that way consumes much time on career information and measurement works about DB workers, causing low time and cost efficiency and lack of systematic management of DB workers, resulting in becoming the hindrance factor of databases quality improvement. This research provides on-line, red-time results of measurements about the efficiency of DB production and DB workers by combining the static measurement with dynamic measurement by DB manager, both of which utilize the System. Therefore, the DB manager can contribute to the improvement of DB quality by determining the continuation of DB production by DB workers or carrying out the re-education of DB workers without being affected by time or spacial constraints.

  • PDF

A Prototype of the Map Viewer based Spatial DB for the Integrated Urban Flooded Area Management System (도시침수 통합관리 시스템 구축을 위한 공간DB기반 Map Viewer 프로토타입 설계)

  • Kim, Ki-Uk;Seo, Tae-Woong;Kim, Chang-Soo
    • 한국방재학회:학술대회논문집
    • /
    • 2008.02a
    • /
    • pp.339-342
    • /
    • 2008
  • Recently the life and property damage caused by urban inundation have increased. In order to prevent the damage by inundation the researches for displaying the flooded areas through integrating SWMM and GIS have been progressed. However most of flood analysis systems only have used the GIS to display the flooded areas, and don't provide the integration disaster information to prevent the inundation. In this paper, we design a prototype for the Map Viewer based Spatial DB for the integrated urban floooded area management system. And we implement the spatial DB conversion module.

  • PDF

Design and Implementation of Sensor Information Management System based on Celery-MongoDB (Celery-MongoDB 를 활용한 센서정보 관리시스템 설계 및 구현)

  • Kang, Yun-Hee
    • Journal of Platform Technology
    • /
    • v.9 no.2
    • /
    • pp.3-9
    • /
    • 2021
  • The management of sensor information requires the functions for registering, modifying and deleting rapidly sensor information about various many sensors. In this research, Celery and MongoDB are used for developing a sensory data management system. Celery supplies a queue structure based on asynchronous communication in Python. Celery is a distributed simple job-queue but reliable distributed system suitable for processing large message. MongoDB is a NoSQL database that is capable of managing various informal information. In this experiment, we have checked that variety of sensor information can be processed with this system in a IoT environment. To improve the performance for handling a message with sensory data, this system will be deployed in the edge of a cloud infrastructure.

Cloud-Oriented XML Metadata Generation between Heterogeneous Navigation Systems for Unknown Roads (클라우드 환경에서 이기종 네비게이션간의 새로운 도로 정보 업데이트를 위한 XML 메타 데이터 생성)

  • Lee, Seung-Gwan;Choi, Jin-Hyuk
    • The Journal of the Korea Contents Association
    • /
    • v.11 no.4
    • /
    • pp.83-91
    • /
    • 2011
  • The roadmap DB update for unknown roads is a very important factor for car navigation systems. In this paper, we propose a cloud computing based roadmap generation method for use between heterogeneous navigation system for unknown roads. While the drivers drive on unknown roads, the proposed method extracts the road attribute information, and then generates the metadata in an XML format that is available for the heterogeneous navigation systems in a cloud environment. The metadata is proposed to be used as a replacement for conventional proprietary roadmap formats which used by roadmap providers, which is efficient for heterogeneous navigation system providers in a cloud computing environment. Then, this metadata is provided to the roadmap DB providers through the cloud computing interfaces. With the proposed method, the roadmap DB providers update the own roadmap DB for navigation systems in real time. Therefore, the proposed method can reduce the costs of an actual traveling test and the maintenance for the roadmap DB provides. Thus, the cloud-oriented road map generation method can more efficiently update the unknown road information.