• Title/Summary/Keyword: SQL-Server

Search Result 208, Processing Time 0.024 seconds

Prototyping of Basic Components in Catalog Services of Geo-spatial Information Linked to PostgreSQL (지형공간정보 카탈로그 서비스 기본요소의 PostgreSQL 연동 시험모델 구현)

  • Han, Sun-Mook;Lee, Ki-Won
    • Korean Journal of Remote Sensing
    • /
    • v.26 no.2
    • /
    • pp.133-142
    • /
    • 2010
  • As diverse web-based geos-spatial services are developed, the values of technologies and standards related to this trend are also emphasized. In this study, a prototype supporting mandatory components in OGC standard catalog service is designed and implemented, linked to PostgreSQL, open source DBMS. As the main features, XML metadata server was built with the helps of XML query functions in PostgreSQL. Given target applications with geo-spatial data sources and contents, this model can be applied, and it can be used for extension in other external web-based service systems or applications, because it supports international standard specifications.

Oracle′s KMS Solution Framework

  • Eok, Choe-Seung
    • Proceedings of the Korea Database Society Conference
    • /
    • 1998.09a
    • /
    • pp.347-364
    • /
    • 1998
  • Oracle's KM Technology ㆍCore Technologies - Oracle Application Server 4.0 JCORBA Cartridge, JTS - Oracle 8.1 JavaVM, Java Stored Procedure, CORBA/ORB, IIOP - ConText Carridge 8.1 - Enterprise Scalability and Performance - Open SQL Query Layer - Fully-Extensible Object Model for custom solutions ㆍNext Plan - Oracle Application Server 4.1 EJB Cartridge(omitted)

  • PDF

Design and Implementation of Light Loaded Web Application Based on .NET (.NET 기반의 저부하형 웹 애플리케이션 설계 및 구현)

  • 최동우;안현식
    • Journal of Korea Multimedia Society
    • /
    • v.7 no.2
    • /
    • pp.272-282
    • /
    • 2004
  • As Web services need to manage lots of information, it is indispensable to reduce server's load and speed up processing time. In this paper, we analyze the loading problems of server and suggest designing methods for light loaded Web applications based on .NET. The proposed methods include using a relative database to produce minimized modules and Stored Procedures to simplify SQL statements for reducing sever's load. Web pages are organized with scripts replacing server language, which improve server's capability by reducing loads. The execution time is also speeded up by organizing Web pages with User Controls. And XML/EDI is used for managing the effective exchange of documents. The proposed methods are implemented as an education management system and shows its effectiveness.

  • PDF

Design and Implementation of School Affairs Management System using PHP on the Internet (인터넷 상에서 PHP를 이용한 학사관리 시스템의 설계 및 구현)

  • Moon, Jin-Yong;Koo, Yong-Wan
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.10
    • /
    • pp.3148-3154
    • /
    • 2000
  • In this paper. the design and implementationof the on-line registration system for the school affairs is described. The environments for the system configurations include a PC server under Linux Iperating System. Apache Web-server, and MySQL as database engine. In addition, PHP, which becomes a popular Internet server-based script language lately, is used to implement a real-time database. In order to avoid overload problems during short-term registration period, which deconstraces the typical surge of traffics, the proposed system is designed to minimize the unnecessary interfacing tasks. On administrator side task, the sytem is designed to have environments by separating the dechcated server that restricts the scope of specific database thasks. In doing so, it become possibal to build an optical system by distributing, balancing the transaction load, maintainimg the security and efficient administrative tasks.

  • PDF

Application Scheme of PostgreSQL-PostGIS Server Engine based on Open Source for GIS Portal Building (GIS 포털 구축을 위한 공개 소스 기반 PostgreSQL-PostGIS 서버 엔진의 응용 설계)

  • Han, Sun-Mook;Lee, Ki-Won
    • Proceedings of the KSRS Conference
    • /
    • 2009.03a
    • /
    • pp.134-138
    • /
    • 2009
  • 최근 GIS 포털에 대한 수요자 요구 사항이 증가하고 있고 기존의 웹 GIS 응용 프로그램 개발 기법과의 연계와 통합이 중요한 연구 주제로 부각되고 있다. 본 연구에서는 공개 소스인 PostgreSQL - PostGIS를 이용하여 GIS 포털 구축을 위한 응용 설계 연구를 수행하였다. PostgreSQL를 데이터베이스 시스템으로 하여 공간 질의 및 분석 기능 등 GIS 기능을 연동시키는 PostGIS는 서버 GIS 엔진으로 점점 활용 가치가 증가하고 있으나 GIS 포털에서 이를 적용한 사례는 현재까지 보고된 바가 거의 없다. 본 응용 설계는 전체 시스템 설계 보다는 주로 포털에서의 인터페이스 부분을 주로 다루고자 하며 시험 구현 프로그램의 라이브러리는 PostGIS의 C Language Interface(LIBPQ)와 OGC library를 이용하여 공간 데이터에 대한 기본 기능을 구현하였다. 본 연구를 통하여 구글, 다음, 네이버 등과 같은 일반 검색 엔진에서 경쟁적으로 제공하는 웹 맵핑 수준에서 위성영상정보와 지도정보 서비스가 보다 체계적으로 웹 GIS 기술과 연계될 수 있는 기반을 마련하고자 한다.

  • PDF

Record keeping system of bugs for software quality assurance

  • Mateen, Ahmed;Zhu, Qingsheng;Afsar, Salman
    • International journal of advanced smart convergence
    • /
    • v.8 no.4
    • /
    • pp.207-213
    • /
    • 2019
  • Assistance for the quality assurance management and developers to provide high quality software products. Using a bug record keeping system is exceptionally important in software progress, and it is followed vastly by majority of software producing companies in modern era. Regular application of a bug record keeping system is very helpful in developing software systems. We developed this system which helps the software testing team to keep a complete record of their testing activities during the software testing, also increases your confidence in the software quality, class and worth. Our proposed system offers trouble-free and effortless approaches to acquire desired information about bug, also produces different kinds of reports like summary reports, detailed reports etc. It gives facility to create, delete and update any project. Our developed application system is designed by using visual c# at front end and sql server 2008 management studio express at back end.

BioSubroutine: an Open Web Server for Bioinformatics Algorithms and Subroutines

  • Lee, Joowon;Kim, Hana;Lee, Wonhye;Chung, Dongil;Bhak, Jong
    • Genomics & Informatics
    • /
    • v.3 no.1
    • /
    • pp.35-38
    • /
    • 2005
  • We present BioSubroutine, an open depository server that automatically categorizes various subroutines frequently used in bioinformatics research. We processed a large bioinformatics subroutine library called Bio.pl that was the first Bioperl subroutine library built in 1995. Over 1000 subroutines were processed automatically and an HTML interface has been created. BioSubroutine can accept new subroutines and algorithms from any such subroutine library, as well as provide interactive user forms. The subroutines are stored in an SQL database for quick searching and accessing. BioSubroutine is an open access project under the BioLicense license scheme.

Implementation of Learning Management System for Philippines (필리핀 학습관리시스템 설계 및 구현)

  • Kim, Byeo-Ri;Yoo, Bo-Ram;Jung, Suk-Yong
    • Journal of the Korea Convergence Society
    • /
    • v.3 no.2
    • /
    • pp.1-5
    • /
    • 2012
  • South Korea is one of major trading partner of Philippines. Many Korean manufacturers and tour companies have branches in the Philippines. Korean companies need to enhance Korean language capabilities for Filipino employee. South Korea has many successive experiences for e-learning. In this paper, we developed Learning Management System (LMS) for Philippines. LMS was implemented in JAVA, ASP and HTML. All lectures are stored in database managed by MS SQL-server.

Design of Web eased Distance Education System using Sever Push technology (푸시기술을 이용한 웹기반 원격강의 시스템 설계에 관한 연구)

  • 이양원
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 1999.11a
    • /
    • pp.340-343
    • /
    • 1999
  • In this paper, we developed the cyber campus which is a internet based virtual education system. This system is designed by using the client/server architecture and server push mechanism. The basic design tool is mini SQL and PERL for design and implementation. Developed system is tested on the site of Honam university(cybercam.honam.ac.kr) and confirmed its performance. This tool will be very useful as a distance education method for every school and educational agency under the internet environment.

  • PDF