• Title/Summary/Keyword: SQL server

Search Result 208, Processing Time 0.024 seconds

Achievement of A Three-Tier Based Online Examination System (3-계층 기반의 온라인 시험 체계 구현)

  • Liu, Qiu-Yi;Sohn, Young-Ho
    • Journal of Advanced Navigation Technology
    • /
    • v.13 no.1
    • /
    • pp.68-73
    • /
    • 2009
  • Recently, various services through the Internet are gradually increased and developed. The traditional way of examination has been replacing by the online test as well. The most representative is the IBT TOEFL by the ETS in the US. Besides this, a lot of online tests and some related discussions are very fierce to carry out due to the continuous increase of the number of exam candidates. Taking account of the economic issues compared to the previous test, this online method has a lot of strengths. This paper aims to build an online test system based on the 3- tier browser-server architecture, which is different from the commonly used 2-tier based system. This system was achieved using the Visual Studio.Net 2005 and SQL Server 2000 as development tools, and based on the ASP.NET 2.0 platform, using the ADO.NET and C# language.

  • PDF

Power Manageable IoT Systems Using RF433 Wireless Sensor Network and ARDUINO-YUN Based Gateway (RF433 무선 센서 네트워크와 ARDUINO-YUN 기반의 게이트웨이를 활용한 전력관리 IoT 시스템)

  • Choi, Eun-Seok;Shim, Jae-Ryong;Chang, Sekchin
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.21 no.5
    • /
    • pp.936-944
    • /
    • 2017
  • These days, research has been made for a variety of internet of things (IoT) technologies over industrial fields. The current research trend includes the effective adoption of the IoT technologies. But, most IoT researches assume a relatively complicated structure, which consists of sensor devices, gateway, network server, and application server. Of course, the structure has distinct merits in the aspects of flexibility and expandability. However, the complicated structure causes the system implementation overhead including high-cost implementation, and hinders the practical usage of IoT in the industry areas, which require a small-size network. In this paper, we propose a novel IoT system architecture, which guarantees the small-size network and the low-cost implementation. Also, we implement the infrastructure, which includes the RF433-based sensor network, the ARDUINO-YUN based gateway, and the application server using Apache/PHP/MySQL (APM) package. Finally, we present the effective power management scheme among these components.

리눅스 기반의 인터넷 원격 교육 시스템 개발 -교재 설계 모듈을 중심으로-

  • 성평식;박춘원
    • Proceedings of the Korea Society for Industrial Systems Conference
    • /
    • 2000.11a
    • /
    • pp.635-645
    • /
    • 2000
  • Within a context of rapid technological change and shifting market conditions, the education environment requires new paradigm of education delivery In accordance of such a technological progress, distance education system, which makes the loaming take place at anytime anywhere, overcoming barriers of time, or distance, is emerging as a mainstream of education delivery replacing the convectional one way delivery system from instructor to learners. This Paper aims to introduce the development principle and algorithm about Instructional System Design(ISD) module, a part of a total solution for distance education services. It was developed on Linux, a free Unix-type operating system. Linux supports so various network protocols, sharing the network resources in a smooth way, that it is able to integrate with other operating system very easily, especially with Windows NT or Windows 2000 servers. In terms of quality, it never falls behind the windows products which are commercially available only, It is a right operating system for the such a school environment that is usually limited in budgets. The development environment of the distance education solution to which ISD module belongs is composing of Apache server for web server, Java bean based on components for ISD module, PHP, server-side scripting language, for HTML documents and MySQL for DBMS.

  • PDF

The practical use with online database program of cosmetics' raw materials. (화장품원료 온라인 데이터베이스 구축과 활용)

  • Jeon Sang-hoon;Kim Ju-Duck
    • Journal of the Society of Cosmetic Scientists of Korea
    • /
    • v.29 no.2 s.43
    • /
    • pp.233-250
    • /
    • 2003
  • We often use the KCID(Korean Cosmetic Ingredient Dictionary) and ICID(International Cosmetic Ingredient Dictionary) within cosmetics research and within their export and import. so far, we do not have a database of a cosmetics' raw materials. Because of this, we consume a lot of time to find the raw material data that is needed. This study constructs a cosmetics' raw material database and develops the program to retrieve it. We used a Linux machine as the equipment for this study and we used Apache web server, MySQL database server and PHP as the tools of this study. 11,817 kinds of raw materials data were registered as ICID, 866 kinds of raw materials data were registered as KCID and 28,008 kinds of raw materials data with registered trade name into the database. Also, The database was composed of the database of the association form. The database of the online form could ultimately reduce the task time as soon as it did its purpose. The product of this study can become a good basis of data to reconfigure. In the future, it can become a good database in relation with different databases.

Remote monitoring system of a vinyl house by web and Labview (Labview와 웹을 활용한 비닐하우스 원격감시 시스템)

  • Park, Sang-gug
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2009.05a
    • /
    • pp.725-728
    • /
    • 2009
  • This paper describes remote monitoring system for the various environments of a vinyl house, which was located in rural or outer of urban by use internet web connection system in a long distance office. We have constructed remote monitoring system by use a simple experimental model for the monitoring of various factors which need to operate common vinyl house. The experimental model includes temperature, humidity, smoke and infrared sensors for the measuring and AC 220V light bulb for the controlling in the USN system. Also, we have developed monitoring software by use NI Labview and communicate between PC and sensors through the DAQ-board, USN control board. We use CCD camera and grab board for the real time remote monitoring of wanted image in the house area. The computer server for remote connection is constructed in the local PC with Apache web server, PHP and MySQL ODBC. We construct internet communication system for the monitoring remotely the local environments of a vinyl house system.

  • PDF

Power Efficient IoT (Internet of Things) System using the RF433 Wireless Sensor Network and ARDUINO YUN as the Gateway (RF433 무선 센서 네트워크 및 ARDUINO YUN을 활용한 전력 효율적인 IoT 시스템)

  • Choi, Eun-Seok;Shim, Jae-Ryong;Chang, Sek-Chin
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2016.10a
    • /
    • pp.719-722
    • /
    • 2016
  • These days there have been trying to fuse the various of IoT (Internet of Things) technology over the industrial field. However the complicated IoT System structure comprised of sensor devices, gateway, network server, and application server causes the difficulties to the system implementation and the increment of installation cost, thereby preventing IoT system deployment in the industry fit for small size network environment. In this paper, authors propose a novel IoT system architecture that is useful in the industry field to be implemented by the small size network with low cost. Also, we implement the infrastructure to RF433 wireless sensor network, the gateway on ARDUINO YUN, and the application server using AMP (Apache, PHP, MySQL) package and then present a power efficient management scheme for sensor devices.

  • PDF

DEVELOPMENTS OF ASTRONOMICAL IMAGE ARCHIVING SYSTEM (천문 이미지 디지털 아카이빙 시스템 개발)

  • Sung Hyun-Il;Kim Soon-Wook;Bae Young-Ho;Choi Joon-Young
    • Publications of The Korean Astronomical Society
    • /
    • v.21 no.1
    • /
    • pp.1-9
    • /
    • 2006
  • An archiving system designed to enable documenting database of astronomical images, with functions of search and download, is being developed by Korean Astronomical Data Center(KADC) of Korea Astronomy and Space Science Institute(KASI). The system consists of three PCs for web server, database server, and system management server. The search program for the web environment is operated in the web server. In the management server, several utility program we developed are installed: input program for the database, program for transfer from fits to jpg files, program for data recovery and management, and programs for statistics and connect management. The collected data would be sorted out by the system manager to input into the database. The online input is possible in an observatory where the data is produced. We applied the content management system(CMS) module for the database management. On the basic of CMS module, we set up a management system for the whole life cycle of metadata from creation and collection to storage and deletion of the data. For the search function, we employed a technique to extract indices from the metadata. In addition, MySQL is adopted for DBMS. We currently display about 2,700 and 25,000 photographs for astronomical phenomena and astronomical objects on the data, respectively.

UniWeb 2.0 - A Web-based Client-Server Database Application Development Environment (UniWeb 2.0 - 웹을 이용한 클라이언트-서버 데이타베이스 응용 개발 환경)

  • 김평철
    • The Journal of Information Technology and Database
    • /
    • v.3 no.2
    • /
    • pp.119-132
    • /
    • 1996
  • 웹을 이용한 클라이언트-서버 데이타베이스 시스템은 웹의 서비스 능력과 데이타베이스 시스템의 데이타 관리 기능을 상호 보완적으로 통합함으로써 인터넷과 같은 대규모 환경에서 데이타베이스 업무 환경을 구축하는 데 매우 적합한 것으로 알려져 있다. 데이타베이스 통로는 이러한 통합의 가장 핵심적 구성 요소이다. 본 논문에서는 먼저 클라이언트-서버 데이타베이스 응용을 위한 데이타베이스 통로의 고려사항으로서, 고성능 실행구조, 응용 프로그램 개발 환경, 그리고 상태 및 트랜잭션 관리에 대해 기술하고, 이어서 UniSQL/X용 데이타베이스 통로인 UniWeb 2.0의 설계와 구현에 대하여 소개한다. UniWeb 2.0은 CGI 응용 서버 방식을 채택하여 다양한 플랫폼을 지원하고, 고성능 그리고 확장성을 제공한다. 또한 프로그래머가 HTML 문서에 SQL/X문장이 포함된 Tcl 스크립트를 끼워 넣을 수 있도록 하여 응용 프로그램 개발 생산성을 향상시키고 있다. UniWeb 2.0은 여러 웹 페이지에 걸친 상태 와 트랜잭션을 지원하고 있다.

  • PDF

Design and Implementation of an Application for Internet Banking (인터넷뱅킹을 위한 어플리케이션의 설계 및 구현)

  • 남철기;장길상
    • The Journal of Society for e-Business Studies
    • /
    • v.4 no.2
    • /
    • pp.95-113
    • /
    • 1999
  • Recently, Internet services are rapidly spreading all over the world. Internet will have a great influence on financial market and banking industry. Customers will obtain full banking services over Internet. Thus, Internet banking is an unavoidable choice to strengthen the competitive edge of banks. This paper designs and develops an application for Internet banking services in the existing banks. The implementation of Internet banking requires the construction of website, web pages and links to other related information. Using Oracle DBMS(Database Management System), Oracle Application Server, PL/SQL(Procedural Language/SQL), Java Applet, and Java Script, a prototype for Internet banking is implemented.

  • PDF

Design of Spatial Query Language for GEO Millennium Server TM

  • Zhaohong Liu;Kim, Sung-Hee;Oh, Young-Hwan;Bae, Hae-young
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10a
    • /
    • pp.113-115
    • /
    • 2000
  • A GIS software GEO Millennium SystemTM has been developed to integrated with spatial database that combines conventional and spatially related data. As we known well the standard query language lacks the support of spatial data type and predicate, and can not serve as the query language in the spatial database directly; some extended strategies have been proposed, but some of them need their own storage manager, some introfuce new clause into the SELECT-FROM-WHERE structure, and some is very complex and available to us. So we designed our own query language on the conventional storage manager system. It supports the Spatial Data Type and predicate, and provides the full query capabilities of SQL on the non-spatial part of the database while being tightly integrated with the spatial part, without changing the standard SQL structure.

  • PDF