• Title/Summary/Keyword: MS-SQL 데이터베이스

Search Result 37, Processing Time 0.025 seconds

Comparison of DBMS Performance for processing Small Scale Database (소용량 데이터베이스 처리를 위한 DBMS의 성능 비교)

  • Jang, Si-Woong
    • 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.

Design of Relational Storage Schema and Query Processing for Semantic Web Documents (시맨틱 웹 문서를 위한 관계형 저장 스키마 설계 및 질의 처리 기법)

  • Lee, Soon-Mi
    • 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.

A Study on Magnetic Movement Route Tracking and Location Control Using MS-SQL in Sensor Network (센서네트워크 상에서 MS-SQL을 활용한 자성체 이동경로 추적 및 위치제어에 관한 연구)

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

  • PDF

공개소프트웨어 활성화 전략- 개발자의 무한한 자유를 위한 공개소프트웨어

  • Choe, Seong
    • 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 이상의 개인용 컴퓨터를 대상으로의 공격한 것을 가지고 온 나라가 핵 공격을 받은 것으로 착각하고 매스컴과 보안업체들은 호기를 맞아 사업이 잘 됐다. 가장 많이 사용되고, 비싼 가격의 시스템일수록 해커들의 공격 대상이 되고 있는 것이다.

  • PDF

A Study on the Practice Model for Prescription Information Management of EMR Certification standard - Focus on Data management using SQL - (처방정보관리를 위한 EMR 인증기준의 실습 모델 연구 - SQL을 이용한 데이터 관리 중심 -)

  • Joon-Young Choi
    • 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.

Using of RAM for Performance Tuning in Web Database Server (웹 데이터베이스 서버 성능개선을 위한 램의 활용)

  • 이원조;이단영;고재진
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10a
    • /
    • pp.311-313
    • /
    • 2000
  • 인터넷 E-Business를 위한 ASP를 이용한 웹사이트 구축이 급속도로 증가하는 추세로 대화형 서비스를 제공하기 위해 데이터베이스인 MS SQL Server의 적용이 많아졌다. 따라서 본 연구에서는 웹사이트 구축시 데이터베이스의 성능개선을 위한 임시테이블의 램 활용기법에 대한 효율적인 모델을 제안하고 성능을 평가하였다. 이와 같은 결과로 웹서버의 성능개선에 임시테이블의 램 활용에 대한 기법이 유익하게 활용될 것이다.

  • PDF

A Seminar Assistant System using IOCP Server Model (IOCP 서버 모델을 이용한 세미나 보조시스템)

  • Ahn, Hyun-Ju;Heo, Da-Jeong;Park, Dong-Gyu;Uh, Yoon
    • 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.

Development of Geophysical Data Management System (물리탐사자료 데이터베이스 시스템 구축 연구)

  • Lee, Tai-Sup;Hwang, Hak-Soo;Sun, Hee-Duck;Koo, Sung-Bon;Song, Yaung-Soo
    • 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.

  • PDF

Development of Hydrologic Data Management System Based on Relational Database (관계형 데이터베이스를 이용한 수문자료 관리시스템 개발)

  • Kim, Hak-Kwan;Park, Seung-Woo;Kim, Sang-Min
    • 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.

Construction of Linkage Database on Nursing Diagnoses, Interventions, Outcomes in Abdominal Surgery Patients (복부수술환자의 간호진단, 간호중재, 간호결과 연계 데이터베이스 구축)

  • Yoo, Hyung-Sook;Chi, Sung-Ai
    • 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.

  • PDF