• Title/Summary/Keyword: Embedded SQL

Search Result 18, Processing Time 0.027 seconds

The Meaning, Method and Tool to Build the Ewha Music Database (EMDB)

  • Kim, Eun-Ha;Chae, Hyun Kyung
    • International journal of advanced smart convergence
    • /
    • v.9 no.3
    • /
    • pp.239-245
    • /
    • 2020
  • The Ewha Music Database (EMDB) is an online database comprised of primary source materials related to music education from East Asia during the modern era (1880 to 1945) when Korea, Japan, and China were geopolitically and culturally intertwined. We developed the incipit search in EMDB as an embedded tool. This is the first attempt in Korea to implement a unique search function of musical data using alphabets of musical notes. Unlike in traditional search system that uses general literature information search conditions, such as author, title, publisher, year, number of pages, etc., it offers a new way of searching a musical piece/work and sheet music. This study confirms that digital information technology is an important methodology for research of music culture as a field of humanities.

A study on the Internet control and monitoring system using a microprocessor embedded controller (마이크로프로세서를 이용한 인터넷 원격감시제어 시스템에 관한 연구)

  • 서인호;문복산;김경엽;김영일;천행춘;유영호
    • Proceedings of the Korean Society of Marine Engineers Conference
    • /
    • 2000.11a
    • /
    • pp.152-156
    • /
    • 2000
  • Many industrial equipments use RS-232C interface. But Ethernet using CSMA/CD was widly spread recently. This interface is not compatible with RS-232C and requires PC based system. So In this Paper, We decribe a Internet control and monitoring system that control and watch plants without PC. We developed IP controller consisted of microprocessor and NIC and monitoring system using VC++ and SQL database. The protocol used this system is UDP/IP because it is applicable for real time system.

  • PDF

Embedded Spatio-Temporal DBMS for Mobile Devices (모바일 장치를 위한 내장형 시공간 DBMS)

  • Sim, Hee-Joung;Kim, Joung-Joon;Shin, In-Su;Han, Ki-Joon
    • Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
    • /
    • 2008.06a
    • /
    • pp.59-66
    • /
    • 2008
  • 최근 유비쿼터스 컴퓨팅 환경이 발전함에 따라 교통(u-Transport), 복지(u-Care), 문화(u-Fun), 환경(u-Green), 산업(u-Business), 행정(u-Government), 도시(u-City) 뿐만 아니라 사용자의 위치와 다양한 공간 정보를 제공하는 u-GIS가 유비쿼터스 컴퓨팅 환경의 핵심 요소 기술로 대두되고 있다. 이에 본 논문에서는 기존의 PC용 MMDBMS인 HS QLDB를 확장하여 모바일 장치에서 시공간 데이타를 효율적으로 처리 및 관리할 수 있는 내장형 시공간 DBMS를 설계 및 구현하였다. 내장형 시공간 DBMS는 OpenGIS "Simple Features Specification for SQL"에서 명시하는 공간 데이타 타입과 공간 연산자를 확장하여 시공간 데이타 타입과 시공간 연산자를 제공하며, 시공간 데이타 특성들 고려한 산술 연산 코딩 압축 기법을 제공하고, 모바일 저장 장치인 플래쉬 메모리에서 효율적인 시공간 데이타 검색을 위한 시공간 인덱스를 지원한다. 그리고, 내장형 시공간 DBMS와 U-GIS 서버 사이에서 시공간 데이타 수입/수출의 성능 향상을 위한 데이타 캐슁 기능과 DBMS의 안정성을 위한 백업/복구 기능을 지원한다.

  • PDF

The Design of Synchronization Server for Embedded DBMS (내장형 DBMS를 위한 동기화 서버 시스템)

  • 최우영;이경아;염태진;진성일
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2004.04b
    • /
    • pp.127-129
    • /
    • 2004
  • 이동 컴퓨팅이 활성화 되면서 데이터의 관리 및 저장을 위하여 내장형 DBMS의 필요성이 증대되고 있다. 클라이언트에서 운용되는 내장형 DBMS는 서버용 DBMS와 동기화 기능이 필요하다. 본 논문에서는 통신 비용절감과 빠른 동기화를 위하여 SQL로 이루어진 로그 정보로 클라이언트와 서버간의 데이터를 양방향 동기화하며 Mirror Table을 가지는 Mid-tier 구조로 안정성을 유지하는 새로운 동기화 서버 구조를 제안한다. 제안된 동기화 서버는 저장 공간과 안정성이 부족한 내장형 DBMS의 데이터를 일관성과 안정성이 있도록 보장하고 통신비용이 최소화될 수 있도록 함으로써 효율적으로 데이터를 관리할 수 있도록 지원한다.

  • PDF

Design and Implementation of a Data Management System for Mobile Spatio-Temporal Query (모바일 시공간 질의을 위한 데이타 관리 시스템의 설계 및 구현)

  • Lee, Ki-Young;Lim, Myung-Jae;Kim, Joung-Joon;Kim, Kyu-Ho;Kim, Jeong-Lae
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.11 no.1
    • /
    • pp.109-113
    • /
    • 2011
  • Recently, according to the development of ubiquitous computing, the u-GIS which not only used in u-Transport, u-Care, u-Fun, u-Green, u-Business, u-Government, and u-City but also used to provides various spatial information such as the location of user is being the core technology of the ubiquitous computing environment. In this paper, we implemented an mobile spatio-temporal Query Processing Systems for handling the Spatio-Temporal Data in mobile equipment.The mobile spatio-temporal Query Processing Systems provides the spatio-temporal data type and the spatio-temporal operator that is expanded by the spatial data type and the spatial operator from OepenGIS "Simple Feature Specification for SQL". It supports arithmetic coding compression techniques that is considered with a spatio-temporal data specific character. It also provides the function of data cashing for improving the importation and exportation of the spatio-temporal data between a embedded spatio-temporal DBMS and u-GIS server.

Performance Evaluation of I/O Intensive Stress Test in Cluster File System SANiqueTM (집중적인 입출력 스트레스 테스트를 통한 클러스터 파일 시스템 SANiqueTM의 성능평가)

  • Lee, Kyu-Woong
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.14 no.2
    • /
    • pp.415-420
    • /
    • 2010
  • This paper describes the design overview of shared file system $SANique^{TM}$ and analyzes the performance evaluation results of I/O intensive stress test based on various cluster file system architectures. Especially, we illustrate the performance analysis for the comparison results between the $SANique^{TM}$ and the Linux file system EXT3 system that is used to generally in Unix world. In order to perform our evaluation, Oracle 10g database system is operated on the top of cluster file system, and we developed the various kinds of testing tools which are compiled by ESQL/C from Oracle. Three types of architectures are used in this performance evaluation. Those are the cluster file system $SANique^{TM}$, EXT3 and the combined architecture of $SANique^{TM}$ and EXT3. In this paper, we present that the results of $SANique^{TM}$ outperforms other cluster file systems in the overhead for providing the true sharing over the connecting server nodes.

Development of Operating S/W and DBMS for Deep-sea Manganese Nodule Miner (심해저 망간단괴 집광기의 운영 소프트웨어 및 데이터베이스 관리시스템 개발)

  • Park, Soung-Jae;Yeu, Tae-Kyeong;Yoon, Suk-Min;Hong, Sup;Kim, Hyung-Woo;Choi, Jong-Su;Kim, Sang-Bong
    • The Sea:JOURNAL OF THE KOREAN SOCIETY OF OCEANOGRAPHY
    • /
    • v.13 no.3
    • /
    • pp.229-236
    • /
    • 2008
  • The deep-sea miner is the tracked vehicle system which drives on the deep-seabed and gathers a manganese nodules. The miner is operated by remote control in real-time by the station of surface vessel. So operating S/W is a important part of miner remote operating. At present, the test miner has been designed and manufactured for near-shore sea-test. The test miner consists of mechanical parts, and electric-electronic parts. Because those parts should be controled and monitored remotely, operating S/W for control and monitoring is necessary by all means. In this paper, real-time operating S/W for a control and monitoring of the test miner was designed and developed using PXI, embedded controller and LabVIEW. This real-time operating S/W was developed for an efficient test of test miner in a near seabed area. Moreover, database management system(DBMS) was developed too for the data management of test miner monitoring using MS SQL and LabVIEW.

Evaluation of Edge-Based Data Collection System for Key-Value Store Utilizing Time-Series Data Optimization Techniques (시계열 데이터 최적화 기법을 활용한 Key-value store의 엣지 기반 데이터 수집 시스템 평가)

  • Woojin Cho;Hyung-ah Lee;Jae-hoi Gu
    • The Journal of the Convergence on Culture Technology
    • /
    • v.9 no.6
    • /
    • pp.911-917
    • /
    • 2023
  • In today's world, we find ourselves facing energy crises due to factors such as war and climate crises. To prepare for these energy crises, many researchers continue to study systems related to energy monitoring and conservation, such as energy management systems, energy monitoring, and energy conservation. In line with these efforts, nations are making it mandatory for energy-consuming facilities to implement these systems. However, these facilities, limited by space and energy constraints, are exploring ways to improve. This research explores the operation of a data collection system using low-performance embedded devices. In this context, it proves that an optimized version of RocksDB, a Key-Value store, outperforms traditional databases when it comes to time-series data. Furthermore, a comprehensive database evaluation tool was employed to assess various databases, including optimized RocksDB and regular RocksDB. In addition, heterogeneous databases and evaluations are conducted using a UD Benchmark tool to evaluate them. As a result, we were able to see that on devices with low performance, the time required was up to 11 times shorter than that of other databases.