• Title/Summary/Keyword: SQL Server

Search Result 210, Processing Time 0.026 seconds

Classroom Power Management System using USN technology (USN을 적용한 강의실 조명 전원 관리 시스템)

  • Ha, Eun-Yong;Hong, Sung-Mo;Lee, Eun-Chul;Choi, Hyun-Jin;Son, Hyuk
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2007.10d
    • /
    • pp.500-504
    • /
    • 2007
  • CPMS(Classroom Power Management System)는 유비쿼터스 센서네트워크 기술을 적용한 층별 강의실 조명 전원을 관리하는 시스템이다. 강의실에는 조도를 센싱하는 모트와 조명 전원을 제어하는 모트가 설치되어 있어, 주기적으로 센서 데이터 및 강의실 전원 상태를 주기적으로 CPMS서버에 보고한다. CPMS 서버는 베이스 모트를 통해 각 강의실의 방의 제어 모트들과 통신하고 전원을 제어하고, 윈도우즈 GUI 소프트웨어를 통해 모트의 상태를 표시하고, 강의실 사용에 대한 스케줄을 입력하여 관리한다. 본 논문에서 CPMS는 모트간의 통신은 IEEE 802.15.4/Zigbee모듈을 사용하여 구현했고 서버소프트웨어는 윈도우즈 시스템을 기반으로 C# 언어와 MS SQL Server로 구현하였다. 본 시스템은 장치들 간의 통신이 모두 무선으로 이루어지므로 설치가 쉽고, 유선 공사에 드는 비용을 절감한 수 있을 뿐 아니라 유선 공사가 난감한 기존 빌딩에서도 구축할 수 있는 장점이 있다.

  • PDF

A Study of PKI-Based E-commerce Security System Design under Java Code Environment (Java Code를 중심으로한 PKI기반 전자상거래 보안시스템 설계)

  • Bang, Kee-Chun;Noh, Si Choon
    • Convergence Security Journal
    • /
    • v.13 no.1
    • /
    • pp.51-57
    • /
    • 2013
  • RSA is the most widely used public key algorithms. Payment via the SSL communications, and user authentication using RSA secure shopping mall that can protect the user's valuable information in the process of building. SSL-based electronic signature technology and encryption protocols for this technology are electronic documents are delivered to the other party through a separate encryption process, the information sender to enter information on a web browser (user) and the recipient (the Web server of the site Manager), except you will not be able to decrypt the contents. Therefore, the information is encrypted during the transfer of electronic documents even if hackers trying to Sniffing because its contents can never understand. Of internet shopping mall in the user authentication 'and' Communications' SSL secure shopping mall built with the goal of the methodology are presented.

Implementation of SIP PC-to-PC VoIP System (SIP 기반 PC-to-PC VoIP 시스템 구현)

  • Choi, Sun-Wan;Sohng, Tae-Il;Kim, Sung-Yeop;Lee, Kyung-Hee;Lee, In-Soon;Kim, Soo-Min;Kim, Sang-Mi;Yiee, Jong-Hwa;Kang, Shin-Ggak
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2001.04a
    • /
    • pp.527-530
    • /
    • 2001
  • 현재 인터넷의 killer application으로 VoIP 서비스를 들고 있으며 ITU-T H.323 기반의 VoIP 시스템은 검증된 기술로 인정받고 있다. 그럼에도 불구하고 대부분의 VoIP 관련기구에서는 차세대 VoIP용 호설정 프로토콜로서 IETF의 SIP를 채택하고 있다. 본 논문에서는 개발한 SIP 기반의 PC-to-PC 인터넷 전화 시스템에 대하여 기술한다. 구현 구성요소는 클라이언트와 서버로 구분된다. 클라이언트인 SIP UA(User Agent)는 MS Windows 98/2000에서 동작하며 Visual C++를 이용하여 구현하였다. 서버는 SIP Redirect Server와 사용자 등록을 위한 SIP Registrar를 Linux 환경에서 C++를 이용하여 구현하였다. SIP Registrar는 DB와 연동이 되며 MySQL 서버를 이용하였다.

  • PDF

Gen-Z memory pool system implementation and performance measurement

  • Kwon, Won-ok;Sok, Song-Woo;Park, Chan-ho;Oh, Myeong-Hoon;Hong, Seokbin
    • ETRI Journal
    • /
    • v.44 no.3
    • /
    • pp.450-461
    • /
    • 2022
  • The Gen-Z protocol is a memory semantic protocol between the memory and CPU used in computer architectures with large memory pools. This study presents the implementation of the Gen-Z hardware system configured using Gen-Z specification 1.0 and reports its performance. A hardware prototype of a DDR4 Gen-Z memory pool with an optimized character, a block device driver, and a file system for the Gen-Z hardware was designed. The Gen-Z IP was targeted to the FPGA, and a 512 GB Gen-Z memory pool was configured on an ×86 server. In the experiments, the latency and throughput of the Gen-Z memory were measured and compared with those of the local memory, SATA SSD, and NVMe using character or block device interfaces. The Gen-Z hardware exhibited superior throughput and latency performance compared with SATA SSD and NVMe at block sizes under 4 kB. The MySQL and File IO benchmark of Gen-Z showed good write performance in all block sizes and threads. Besides, it showed low latency in RocksDB's fillseq dbbench using the ext4 direct access filesystem.

Design and Implementation of a Service Platform that Recommends the Optimal Shortest Distance as a Patrol Route

  • Jo, Yu-min;Jang, Ye-jin;Paik, Jong-ho
    • Journal of Internet Computing and Services
    • /
    • v.23 no.1
    • /
    • pp.1-9
    • /
    • 2022
  • Recently, interest in living safety and crime prevention is increasing. The reality is that most women have anxiety about social safety and ultimately want a safe return to home. As a result of these issues, the Seoul Metropolitan Government and the National Police Agency are implementing various services to alleviate them. However, there are limitations such as that the service can be used only during a limited time or the process of checking whether the patrol is really completed is complicated. Therefore, in this paper, we propose a service platform that overcomes these limitations and suggests the best and shortest patrol route to the police based on the desired patrol location applied by citizens. It is designed based on the MVC pattern, and the functions are divided for each user. It is hoped that the platform will reduce crime rates and allow citizens to ultimately return home with peace of mind. Also we expect that the police will ablet to find places where they did not know about or need to patrol with more attention through the recommended route of the platform, which will be helpful in their task.

Design and Implementation of a Learning Disorder Diagnosis System using Ontology (온톨로지를 이용한 학습 장애 진단시스템 설계 및 구현)

  • 한국정보교육학회
    • Journal of The Korean Association of Information Education
    • /
    • v.9 no.4
    • /
    • pp.571-579
    • /
    • 2005
  • 교수-학습과정에서 학습자가 가지고 있는 학습 장애는 학습 결과에 많은 영향을 미친다. 학습자의 학습 장애를 정확하게 진단하고 이를 고려한 수업 활동이 전개되어야 효과적인 교수-학습 활동이 이루어 질 수 있다. 학습 장애의 특성상 장애 진단과 처방과정에서는 비공개적인 접근이 요구된다. 인터넷 기반의 온라인 학습 장애 진단과 처방시스템은 이와 같은 문제를 해결할 수 있는 유용한 방안 중의 하나가 될 것이다. 하지만 기 구축되어 운영 중인 온라인 기반 학습 장애 관련 사이트들은 학습 장애를 진단해 주고 처방해 주기 보다는 학습 장애 정보를 안내해 주는 정도의 수준에 에 그치고 있다. 단순히 웹문서 형태의 정보제공 체제이거나 텍스트 기반의 지식 전달 체계로 인하여 학습자 개개인의 특성을 고려한 장애 진단에 한계점을 가지고 있다. 학습 장애에 대한 지식을 체계화함과 동시에 일정한 기준에 의해 연관성을 지어 줄 수 있는 의미 분석과 추론 등의 방법에 사용되어지는 온톨로지를 활용하게 되면 기존의 시스템이 가지는 제한점들을 극복할 수 있을 것이다. 이에 본 연구에서는 온라인 상황에서 학습자의 학습 장애를 정확하게 진단하기 위해 온톨로지를 이용하여 학습장애 진단 시스템을 설계하고 구현하였다. 온톨로지의 구축에 사용된 도구는 protege-2000을 사용하였다. 진단시스템 개발 환경으로 학습자의 인터페이스는 Visual C++, 교사의 인터페이스는 Visual Studio.NET을 사용하였으며, DBMS는 Microsoft Office Access와 MS-SQL Server를 사용하였다. 이 연구는 OWL 온톨로지를 사용하여 보다 지능화된 학습 장애 진단시스템을 개발함으로써 실현 가능성을 제안하고 있는 것이 연구의 의의이다.

  • PDF

Acquisition, Processing and Image Generation System for Camera Data Onboard Spacecraft

  • C.V.R Subbaraya Sastry;G.S Narayan Rao;N Ramakrishna;V.K Hariharan
    • International Journal of Computer Science & Network Security
    • /
    • v.23 no.3
    • /
    • pp.94-100
    • /
    • 2023
  • The primary goal of any communication spacecraft is to provide communication in variety of frequency bands based on mission requirements within the Indian mainland. Some of the spacecrafts operating in S-band utilizes a 6m or larger aperture Unfurlable Antenna (UFA for S-band links and provides coverage through five or more S-band spot beams over Indian mainland area. The Unfurlable antenna is larger than the satellite and so the antenna is stowed during launch. Upon reaching the orbit, the antenna is deployed using motors. The deployment status of any deployment mechanism will be monitored and verified by the telemetered values of micro-switch position before the start of deployment, during the deployment and after the completion of the total mechanism. In addition to these micro switches, a camera onboard will be used for capturing still images during primary and secondary deployments of UFA. The proposed checkout system is realized for validating the performance of the onboard camera as part of Integrated Spacecraft Testing (IST) conducted during payload checkout operations. It is designed for acquiring the payload data of onboard camera in real-time, followed by archiving, processing and generation of images in near real-time. This paper presents the architecture, design and implementation features of the acquisition, processing and Image generation system for Camera onboard spacecraft. Subsequently this system can be deployed in missions wherever similar requirement is envisaged.

The Development of On-Line Statistics Program for Radiation Oncology (방사선종양학과 On-line 통계처리프로그램의 개발)

  • Kim Yoon-Jong;Lee Dong-Hoon;Ji Young-Hoon;Lee Dong-Han;Jo Chul-Ku;Kim Mi-Sook;Ru Sung-Rul;Hong Seung-Hong
    • Radiation Oncology Journal
    • /
    • v.19 no.4
    • /
    • pp.369-380
    • /
    • 2001
  • Purpose : By developing on-line statistics program to record the information of radiation oncology to share the information with internet. It is possible to supply basic reference data for administrative plans to improve radiation oncology. Materials and methods : The information of radiation oncology statistics had been collected by paper forms about 52 hospitals in the past. Now, we can input the data by internet web browsers. The statistics program used windows NT 4.0 operation system, Internal Information Server 4.0 (IIS4.0) as a web server and the Microsoft Access MDB. We used Structured Query Language (SQL), Visual Basic, VBScript and JAVAScript to display the statistics according to years and hospitals. Results : This program shows present conditions about man power, research, therapy machines, technics, brachytherapy, clinic statistics, radiation safety management, institution, quality assurance and radioisotopes in radiation oncology department. The database consists of 38 inputs and 6 outputs windows. Statistical output windows can be increased continuously according to user's need. Conclusion : We have developed statistics program to process all of the data in department of radiation oncology for reference information. Users easily could input the data by internet web browsers and share the information.

  • PDF

Implementation of Reporting Tool Supporting OLAP and Data Mining Analysis Using XMLA (XMLA를 사용한 OLAP과 데이타 마이닝 분석이 가능한 리포팅 툴의 구현)

  • Choe, Jee-Woong;Kim, Myung-Ho
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.15 no.3
    • /
    • pp.154-166
    • /
    • 2009
  • Database query and reporting tools, OLAP tools and data mining tools are typical front-end tools in Business Intelligence environment which is able to support gathering, consolidating and analyzing data produced from business operation activities and provide access to the result to enterprise's users. Traditional reporting tools have an advantage of creating sophisticated dynamic reports including SQL query result sets, which look like documents produced by word processors, and publishing the reports to the Web environment, but data source for the tools is limited to RDBMS. On the other hand, OLAP tools and data mining tools have an advantage of providing powerful information analysis functions on each own way, but built-in visualization components for analysis results are limited to tables or some charts. Thus, this paper presents a system that integrates three typical front-end tools to complement one another for BI environment. Traditional reporting tools only have a query editor for generating SQL statements to bring data from RDBMS. However, the reporting tool presented by this paper can extract data also from OLAP and data mining servers, because editors for OLAP and data mining query requests are added into this tool. Traditional systems produce all documents in the server side. This structure enables reporting tools to avoid repetitive process to generate documents, when many clients intend to access the same dynamic document. But, because this system targets that a few users generate documents for data analysis, this tool generates documents at the client side. Therefore, the tool has a processing mechanism to deal with a number of data despite the limited memory capacity of the report viewer in the client side. Also, this reporting tool has data structure for integrating data from three kinds of data sources into one document. Finally, most of traditional front-end tools for BI are dependent on data source architecture from specific vendor. To overcome the problem, this system uses XMLA that is a protocol based on web service to access to data sources for OLAP and data mining services from various vendors.

WBI Design and Implementation for active instruction in high school curriculum information society and computer (능동적인 학습을 위한 고교 정보사회와 컴퓨터 교과의 WBI 설계 및 구현이동)

  • Bae, Seok-Chan;Du, Chang-Won
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2007.06a
    • /
    • pp.895-901
    • /
    • 2007
  • Currently the advancement of the computer and the Internet sees the direction of studying freely to do, it does not receive not to be, the student the environment it will be able to study oneself it is doing the direct help of the teacher and to be possible. Plan and it embodied the high school information society which it follows in 7th curriculum and the WBI of computer subject from the dissertation which it sees. In order to improve the qualify of curriculum ultimately, it endeavored. Territory it analyzes a subject contents first, especially it surveys, foundation it hardens, the actual training semester and pure with studying of self-evaluation do to become accomplished, studying oneself to sleep the possibility of doing own lead studying which is the possibility of studying spontaneously and integrated textbook studying in same tine it does to be with they are composing of the education paradigm the flag for a problem solving ability and an originality accident. In this dissertation used the php, Apache web server and the DBMS used the MySQL. To program member joining, the information society and computer curriculum take a course and test, it questions and, it is composed to data mourge. After taking a course, simultaneously lecturing a paper and online instruction, set up a foundation and quering that gratify one's curiosity thus it will be able to digest a study in once.

  • PDF