• Title/Summary/Keyword: SQL server

Search Result 208, Processing Time 0.028 seconds

Design and Implement of Self-Directed LMS for SCORM Standard Web-Base Content (SCORM 표준안에 적용된 Web-Base Content의 자기주도형 학습을 지원하기 위한 LMS 설계 및 구현)

  • Kim, Yun-Su;Kim, Seok-Soo;Lee, Jae-Cheol
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2002.11a
    • /
    • pp.247-250
    • /
    • 2002
  • In this paper, We are design & implement to the LMS(Learning Management System) including SCORM standard for effective reusing and management of each digital contents. This system is composed XML based meta-data manager, SQL server and ASP for LMS application, which are the user directed teaming system within effective reusing and management of each digital contents.

  • PDF

Development of a Location Data Management System for Mass Moving Objects (대용량 이동 객체 위치 데이타 관리 시스템의 개발)

  • Kim, Dong-Oh;Ju, Sung-Wan;Jang, In-Sung;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.7 no.1 s.13
    • /
    • pp.63-76
    • /
    • 2005
  • Recently, the wireless positioning techniques and mobile computing techniques were developed with rapidly to use location data of moving objects. Also, the demand for LBS(Location Based Services) which uses location data of moving objects is increasing rapidly. In order to support various LBS, a system that can store and retrieve location data of moving objects efficiently is required necessarily. The more the number of moving objects is numerous and the more periodical sampling of locations is frequent, the more location data of moving objects become very large. Hence the system should be able to efficiently manage mass location data, support various spatio-temporal queries for LBS, and solve the uncertainty problem of moving objects. Therefore, in this paper, we presented a hash technique, a clustering technique and a trajectory search technique to manage location data of moving objects efficiently And, we have developed a Mass Moving Object Location Data Management System, which is a disk-based system, that can store and retrieve location data of mass moving objects efficiently and support the query for spatio-temporal data and the past location data with uncertainty. By analying the performance of the Mass Moving Object Locations Management system and the SQL-Server, we can find that the performance of our system for storing and retrieving location data of moving objects was about 5% and 300% better than the SQL-Server, repectively.

  • PDF

A Study on the Development of IoT Inspection System for Gas Leakage Inspection in Kitchen Gas Range Built-in Method (주방 가스레인지 빌트인 방식에서 가스 누출검사를 위한 IoT 검사 시스템 개발에 관한 연구)

  • Kang, Dae Guk;Choi, Young Gyu
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.15 no.4
    • /
    • pp.283-290
    • /
    • 2022
  • In this study, an IoT inspection system that can be linked with a server was developed using a gas timer and ESP-01 Wi-Fi module installed on a gas valve in the home. The server environment of the gas leak IoT inspection system was installed with APM (Apache, PHP, MySQL) to collect gas pressure data by generation so that leakage checks could be performed. In order to control the gas leak IoT inspection system, the app inventory was used to manage the gas leak check value in real time. In addition, user convenience has been enhanced so that membership management, WiFi settings, and leakage check values can be checked through mobile apps. In order to manage subscribers by region, the user list was checked by logging in in in the administrator mode so that the information on whether or not the leak test was conducted and the results could be provided. In addition, when the user presses the gas leak check button, the pressure is automatically checked, and the measured value is stored in the server, and when a gas leak occurs, the leakage check is performed after alarm and repair so that it can be used if normal. In addition, in order to prevent overlapping membership, membership management can be performed based on MAC addresses.

A Study on Control system design for Automated Cultivation of product (농작물 재배 자동화를 위한 제어시스템 설계에 관한 연구)

  • Cho, Young Seok
    • Journal of Korea Society of Digital Industry and Information Management
    • /
    • v.10 no.1
    • /
    • pp.55-60
    • /
    • 2014
  • Today, there is increasing the elderly population in rural community, and people of returning from the urban to the rural community are demand to be of high value-added agriculture. In this time, there are required to regularization, standardization, automation, for getting of production of high value crops. In this paper, we are study for automation cultivation control system design for produce high-value crops. this system were designed of two parts that one part is measure and control unit, another part is server part for database and server side control. the main controller for measurement and control is used MC9S08AW60, server for Database and server-side control was using MySQL with CentOS. The source code of control program was coding C and compile with GCC. the functions of measurement and control unit are digital input and output each 8channels and can be scan-able of 20 Bit with 2CH/Sec. Analog Output were designed that can be output of 4-20mA or 0-5V on 4channel. The Digital input and output part were designed 8-channel, and using the high speed photo coupler and relays. We showed that system is possible to measure a 20bit data width, 2Ch/sec as 8 channel analog signals.

Intelligence Type Electronic Medical Examination Chart and Data Treatment of Cyber Doctor to Interconnect ASP and SQL (ASP와 SQL을 연동한 사이버닥터의 지능형 전자진료차트와 데이터처리)

  • Kim Seok-Soo
    • Journal of Digital Contents Society
    • /
    • v.4 no.1
    • /
    • pp.57-66
    • /
    • 2003
  • This paper presents the content regarding electronic medical examination chart and data treatment for efficient medical examination and prompt treatment by realizing mutual conversation type remote medical examination system among 3 parties(patient, doctor, pharmacist) on internet base. This is an intelligence type remote medical examination system for both on-line and off-line mode to transcend time and space on the web being participated by anybody, which is cheap type to solve problems in existing remote medical examination system such as high price based on hardware, incompatibility, and so on. By interconnecting ASP and SQL on IIS 4.0 web server, database enables system integration for efficient data processing, on-line consultation between patient and doctor, medical examination on off-line, transmission of medical prescription to pharmacist designated by patient and preparation of medicine, semi-eternal storage of medical examination data owing to storage and search of medical examination data, exact medical examination and prescription using this medical examination data by patient and doctor, and so on.

  • PDF

Implementation of a Multimedia Remote Lecture based on Windows NT (Windows NT 기반 멀티미디어 원격강좌의 구현)

  • 권호열;김현진;김주필
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 1999.10b
    • /
    • pp.688-690
    • /
    • 1999
  • 본 논문에서는 Windows NT 기반아래 구현된 멀티미디어 원격강좌를 구현하였다. Windows NT와 SQL Server는 사용자 인증 및 자원관리를 담당하며, 원격강좌 내의 모든 자료는 널리 쓰이는 HWP 형식자료를 활용할 수 있으며, 문서자료에 음성 및 동영상, URL 링크 등을 지원하는 PDF 형식으로 제공된다. 구현된 원경강좌를 활용한 운영결과와 향후 과제 등이 논의되었다.

  • PDF

ASP 웹 디비의 운영과 실행에 관한 사례연구

  • U, Won-Taek
    • Proceedings of the Korea Association of Information Systems Conference
    • /
    • 2005.12a
    • /
    • pp.443-454
    • /
    • 2005
  • The purpose of this study is to show the operations and implementations of ASP web database which uses open-source web site packages called bighitonline video shop. Some literature reviews have been done to reveal robust theoretical background for this research And also, some basic experiments as Preparatory Processes have also been made by using some softwares such as Windows XP professional, IIS, MS SQL Server and others. The main purpose of these experiments is to show strong theoretical and practical backgrounds. These experimental results in the micro-level showed to be successful to understand the Interrelations of web components and web-site architectures.

  • PDF

Implementation of Gene Information System (유전자 정보시스템 설계 및 구현)

  • Choi, Nak-Joong;Choi, Han Suk;Kim, Dong-Wook
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2018.05a
    • /
    • pp.549-550
    • /
    • 2018
  • We have developed a web server for the high throughput annotation of gene. This system processes entire data sets with an automated pipeline of 13 analytic services, then deposits the data into the MySQL database and transforms it into three kinds of reports: preprocessing, assembling and annotation.

  • PDF

Building an Electronic Approval Module Using Multi-Level Security (다중등급 보안 정책을 적용한 전자결재 모듈의 개발)

  • 김진성;안병혁
    • The Journal of Information Systems
    • /
    • v.11 no.1
    • /
    • pp.175-198
    • /
    • 2002
  • This paper is to develop a security module for electronic approval systems. Electronic documents are created, transmitted and saved in the company's intranet computer network. Transmitting electronic documents, however, brings us a security problem. Communications among various computer systems are exposed to many security threats. Those threats are eavesdropping, repudiation, replay back etc. The main purpose of this paper is to develop a module which provides the security of electronic documents while they are passed from one place to another This paper applies Multi-Level security to the electronic approval system that guarantees security of electronic documents from many threats. Multi-Level security controls the access to the documents by granting security level to subject users and object electronic documents. To prevent possible replay back attacks, this paper also uses one time password to the system. The security module is composed of client program and server one. The module was developed using Microsoft Visual Basic 6.0 and Microsoft SQL Server 7.0. The code uses Richard Bondi's WCCO(Wiley CryptoAPI COM Objects) library functions which enables Visual Basic to access Microsoft CryptoAPI.

  • PDF

A Study on Development of Gamsung Index DB Contents (감성지표 DB 콘텐츠 구축에 관한 연구)

  • 조해성
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2004.05a
    • /
    • pp.535-539
    • /
    • 2004
  • This paper is concerned with structurizing contents of the ergonomic resources and constructing DB of these resources. Through this internet system developed using ultra 2 DB Server, Sun Solaris(UNIX) OS, UniSql DBMS, Apache Web server, the interface (www.gamsung.or.kr), by which ergonomic resources can be provided, has been completed. Information retrieval concerning ergonomic resources produced by the project "Business of Development in Technology of Human Sensibility Ergonomics" is possible. For example, 35 reports and 262 ergonomic characteristics issued from the first step of this project, 255 ergonomic characteristics issued from the second step. In addition, there are also voice data, sound data, expression data, questionnaire data, sensibility data, and information about researchers, manufactories, references.

  • PDF