• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.12 no.11
• /
• pp.1999-2004
• /
• 2008

While a lot of comparisons of DBMS performance for processing large scale database are given as results of bench-mark tests, there are few comparisons of DBMS performance for processing small scale database. Therefore, in this study, we compared and analyzed on the performance of commercial DBMS and public DBMS for small scale database. Analysis results show that while Oracle has low performance on the operations of update and insert due to the overhead of rollback for data safely, MySQL and MS-SOL have good performance without additional overhead.

• Journal of the Korea Society of Computer and Information
• /
• v.14 no.1
• /
• pp.35-45
• /
• 2009

According to the widespread use of ontology documents, a management system which store ontology data and process queries is needed for retrieving semantic information efficiently. In this paper I propose a storage schema that stores and retrieves semantic web documents based on RDF/RDFS ontology language developed by W3C in a relational databases. Specially, the proposed storage schema is designed to retrieve efficiently hierarchy information and to increase efficiency of query processing. Also, I describe a mechanism to transform RQL semantic queries to SQL relational queries and build up database using MS-ACCESS and implement in this paper. According to the result of implementation, we can blow that not only data query based on triple model but also query for schema and hierarchy information are transformed simply to SQL.

• Proceedings of the Korean Information Science Society Conference
• /
• 2005.11a
• /
• pp.451-453
• /
• 2005

유비쿼터스 센서네트워크는 저 전력 무선통신, 초소형 마이크로프로세서, Ad-Hoc네트워크, MEMS등 다양한 종류의 센서들과 임베디드 시스템의 기술 발전을 기반으로 모든 사물에 컴퓨팅 능력 및 무선통신 능력을 부여하여 "언제", "어디서나" "어느 것"과도 사물들끼리의 통신이 가능한 환경을 구현하는 것이다. 이러한 무선센서네트워크의 응용 분야는 산업 전반에서 일상생활에 이르기 까지 수많은 분야에 응용되어지며, 군사용. 교통, 환경 감시, 의료분야, 홈 네트워크, 빌딩 제어 등 다양한 분야에 응용될 수 있다. 이에 본 논문에서는 무선 센서네트워크 노드인 MicaZ와 자기센서를 이용하여 자기장을 감지하고, 얻어진 데이터를 MS-SQL 데이터베이스에 저장하고 저장된 데이터를 이용하여 자성체의 이동경로 추적 및 위치제어에 관하여 연구하였다.

• Digital Contents
• /
• no.6 s.133
• /
• pp.84-87
• /
• 2004

서버시스템을 많이 사용하거나 영업을 하는 시스템업체 기업대표들께서는 필자에게 호소하기를“곰은 사용자들이고, 중국인은 MS인 것 같다. 왜냐하면 열심히 노력해 시스템을 개발해서 고객에게 납품하고 서버를 증설하면, 서버 당 사용료를 지불하므로 이익이 전혀 없다”고 한다. 그렇다. MS의 서버OS(운영체제)비용이 시스템 유저당 비용을 지불해야 하므로 하드웨어 판매에서는 전혀 마진이 발생하지 않는다는 것이다. 그리고 전세계 OS시장의 90%가 MS 제품을 사용하다보니 유독 MS의 제품에 대해 해커들의 공격 목표가 되고 있다. 지난해 1월25일 MS-SQL 서버에 대한 바이러스 공격은 SQL을 사용하는 중소기업체에서 사용되는 서버제품이 공격의 대상이었다. 또한 지난해 8월 20일경에 있었던 MS 제품의 윈도2000 이상의 개인용 컴퓨터를 대상으로의 공격한 것을 가지고 온 나라가 핵 공격을 받은 것으로 착각하고 매스컴과 보안업체들은 호기를 맞아 사업이 잘 됐다. 가장 많이 사용되고, 비싼 가격의 시스템일수록 해커들의 공격 대상이 되고 있는 것이다.

• Journal of the Health Care and Life Science
• /
• v.10 no.1
• /
• pp.25-38
• /
• 2022

In this study, a SQL practice model for understanding EMR certification standards and data management practice for healthcare information managers was presented. This study is to practice prescription information management for the functionality of EMR certification standards through the health and medical information management practice program. The data management practice according to the EMR certification criteria consists of medicaiton master management and medicaiton name inquiry, medicaiton prescription inquiry, previous medication prescription inquiry after converting medical care information, examintaion result inquiry when administering medicine, examination prescription records inquiry. Additionally, dietary prescription records, other prescription records, return reason inquiry when administering medicine is stopped are included. Accordingly, using the prescription management database of the MS-ACCESS-based health care information management education system, a SQL statement was written that can inquire the contents of the prescription information management certification standards. In the EMR certification practice, you can understand the certification standards more easily by directly extracting the query items required by the certification standards using SQL and it will be possible to improve the data management and information generation ability to extract data other than the certification standards.

• Proceedings of the Korean Information Science Society Conference
• /
• 2000.10a
• /
• pp.311-313
• /
• 2000

인터넷 E-Business를 위한 ASP를 이용한 웹사이트 구축이 급속도로 증가하는 추세로 대화형 서비스를 제공하기 위해 데이터베이스인 MS SQL Server의 적용이 많아졌다. 따라서 본 연구에서는 웹사이트 구축시 데이터베이스의 성능개선을 위한 임시테이블의 램 활용기법에 대한 효율적인 모델을 제안하고 성능을 평가하였다. 이와 같은 결과로 웹서버의 성능개선에 임시테이블의 램 활용에 대한 기법이 유익하게 활용될 것이다.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.13 no.4
• /
• pp.821-827
• /
• 2009

Currently, with the development of web 2.0 knowledge sharing system became more and more important. In this paper, we proposed and implemented seminar assistant system using database system and knowledge sharing system on public seminar. We recorded speaker's voice and presentation files on our system and user can review past talks on our seminar review systems. Our database system is implemented using MS SQL, and Input/Output Completion Port(IOCP) socket model as our server side network module. Also we used presentation software using Direct Show with MFC and Windows Presentation Foundation(WPF). and our review system is based on WFP programmed with C# language.

• Geophysics and Geophysical Exploration
• /
• v.3 no.1
• /
• pp.25-32
• /
• 2000

The geophysical data management system was developed to meet both the increasing demands of geophysical data in the practical application of civil engineering, underground water survey, and environmental problems and needs for digital archive and quality control of geophysical data. The system for a data manager is developed under Client/Server (C/S) environment. This manager system is characterized by a relational geophysical database system using MS SQL-server, standardization of geophysical data format, the development of C/S interface program for Windows environment, and the development of transfer program module for the searched data. The system developed for a general user under the internet environment is characterized by Web service (URL:http//geophy.kigam.re.kr) and the development of plug-in module to visualize geophysical image data.

• Journal of Korea Water Resources Association
• /
• v.39 no.10 s.171
• /
• pp.855-866
• /
• 2006

In this paper, the Hydrologic Data Management System (HDMS) was developed for the efficient management of hydrologic data. The applicability of the system was demonstrated using the hydrologic data of study watershed located in the southwest from Suwon city MySQL 5.0, relational database management system, and MS Visual Basic 6.0 were used for the development of MS windows based HDMS. The primary components of the HDMS are data search system, data management system, and data analysis system. Data search and management systems provide basic functions for the efficient data search, storage, update and export. Data analysis system enables the users to get the further and diverse hydrologic statistical information from the stored data. Furthermore, the accuracy and quality of hydrologic data was analyzed and evaluated through data analysis system.

• Journal of Korean Academy of Nursing Administration
• /
• v.7 no.3
• /
• pp.425-437
• /
• 2001

This reserch was to develop database software in order to handle a lot of clinical nursing data with nursing diagnoses, related factors, defining characteristics, nursing interventions, nursing activities and nursing outcomes. MS Access2000 and SQL was selected to use a general purpose database logic with an efficiency. MS Visual Basic 6.0 was used to construct the circumstance of Graphic User Interface. The Linkage Database of abdominal surgery patients was constructed from the clinical data and questionnaire. This database system could add related factors, defining characteristics, nursing activities in the database and analyze the statistical results through Access query. In the final stage, end-users satisfaction analysis using 5 points Likert scale was dong with the response of using the database system. The accuracy/trustworthiness of the database system was verified with the highest average scores as 4.42 and also, the efficiency as 4.21, user friendly function as 4.1.