• Title/Summary/Keyword: Oracle DBMS

Search Result 58, Processing Time 0.024 seconds

Development of Data Management System for Irrigation Facilities on World Wide Web (웹상에서 농업수리시설물에 대한 자료관리시스템 개발)

  • 고홍석;오동석;최진규;고남영;백영기;박순철
    • Spatial Information Research
    • /
    • v.7 no.1
    • /
    • pp.81-87
    • /
    • 1999
  • This paper describes the development of a data management system which manages the database on World Wide Web(WWW). It is the pa.0 of WISIF(Web-based geographic Information System for Irrigation Facilities) which is a prototype of an information management system for irrigation facilities. This system includes a web serve. and a RDBMS(Relational DataBase Management System). Netscape Enterprise Server 3.0 is used for a web server and for the latter, Oracle DBMS 7.3 for NT is used for a RDBMS. Users can cornet the database through a web browser, such as Netscape Communicator, to insert, update, delete and search data they want

  • PDF

Implementation of Geographic Data Sharing Module on the Various System Environment (이기종 시스템 환경에서의 지리정보 공유를 위한 모듈 구현)

  • Park, Si-Young;Shin, Dong-Bin;Choi, Jin-Young
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2005.11a
    • /
    • pp.499-502
    • /
    • 2005
  • 국가GIS사업 및 관련사업을 통해 다양한 지리정보가 생산되었으며, 다양한 분야의 사용자에 의해 구축 활용되는 지리정보의 특성에 따라 전국에 분포되어 관리되고 있다. 이러한 지리정보가 사장되지 않고 목적에 맞게 효율적으로 활용되기 위해서는 다양한 콘텐츠 확보가 이기종간 공동활용이 선행될 필요가 있다. 따라서 본 연구에서는 서로 다른 시스템 환경에서 지리정보를 연계하여 활용할 수 있도록 카탈로그 모듈, 브로커 모듈, 맵브라우저 모듈, 지리정보등록 모듈 등을 구현하고 Informix, Oracle, GMS, ZEUS 등 여러 가지 조합이 도출될 수 있는 시스템을 대상으로 검증실험을 하였다. 본 연구에서 도출된 모듈을 적용하여 데이터 연계의 제약조건인 DMBS, 공간DBMS 영향을 최소화함으로써 지리정보공유 활성화에 기여할 수 있다.

  • PDF

A Study of Structural Analysis for Space Frame on the World Wide Web (인터넷을 통한 스페이스 프레임 구조 해석에 관한 연구)

  • Suk, Chang-Mok;Nam, Sang-Kwan;Park, Sang-Hoon;Jung, Hwan-Mok;Kwon, Young-Hwan
    • Journal of Korean Association for Spatial Structures
    • /
    • v.1 no.1 s.1
    • /
    • pp.135-142
    • /
    • 2001
  • This paper proposes structural analysis on the World Wide Web to form a part of the architectural design project. It purposes modeling space frames and a structural analysis program on the internet only by inputting basic data for forming a shape in the whole phase of space frame analysis. The analysis data is conducted by Oracle DBMS(DataBase Management System), GUI(Graphic User Internet) by Java Applet and connection with server and database by Java Servlet respectively. The result from modeling and analysis is provided as graphic and text file forms by web browsers. Programs can be executed irrespective of user's OS by using internet and highly-secured system is constructed taking advantage of Java. Of great efficiency is maintaining and recycling data as the whole is dealt by database from the beginning to the end of program.

  • PDF

WebReview : Web-Based Paper Review Support System (WebReview : 웹 기반 논문심사 지원 시스템)

  • Suh, Yong-Moo;Jeon, Geon-Ho
    • Asia pacific journal of information systems
    • /
    • v.8 no.2
    • /
    • pp.19-35
    • /
    • 1998
  • There has been a complaint that current editorial and refereeing system of the traditional journal systems has something to be desired due to long time lag between submission and publication, improper(unfair in some sense, because no communication is allowed between reviewers and authors) review of submitted papers sometimes, and so on. This paper introduces a Web-Based Paper Review Support System, called WebReview, The system helps to reduce the time lag and allows reviewers and authors to communicate anonymously to clarify the research results, if there is any ambiguity. WebReview is implemented in Java, using Oracle as an underlying DBMS, to capture interactions between users and the system.

  • PDF

A Study on The Design of Network and Database Structure of The Integrated System for Power System Operational Planning and Analysis (전력수급계획 및 운용해석 종합시스템을 위한 네트워크 및 데이터베이스구조 설계에 관한 연구)

  • Ahn, Yang-Keun;Park, Si-Woo;Nam, Jae-Hyun
    • Proceedings of the KIEE Conference
    • /
    • 1998.07c
    • /
    • pp.1009-1011
    • /
    • 1998
  • This paper presents a design of network and database structure of the integrated system for power system operational planning and analysis that will be more economical and stable of power system operation. An alias of this system is Highly Integrated Total Energy System(HITES). The Client/server model of HITES is designed as a remote data management model. The input/output-type of application programs and Oracle server is standardized. The separated user-databases from main-database strengthen security of HITES. It is plan to do that tables and relationships are defined by database designs. The connection of application program and DBMS of HITES will be tested through database design and data construction.

  • PDF

Data Modeling Methods for Performance Enhancement (성능 향상을 위한 데이터 모델링 방법)

  • 김수연;이상호;서의호
    • Journal of Intelligence and Information Systems
    • /
    • v.4 no.2
    • /
    • pp.85-102
    • /
    • 1998
  • 현재의 시스템 개발 프로젝트에서 대부분의 기업은 관계형 데이터베이스를 목표 환경으로 채택하고 있지만 설계자들은 기존의 파일 시스템이나 계층형 데이터베이스의 설계 방식을 관계형 데이터베이스 설계 시에도 그대로 적용하려는 경향이 있다. 또한 모델링 시 시스템 특성과는 무관한 업무 중심의 엔티티 관계도를 작성함으로써 구현 시에 모델을 상당 부분 변경하거나 추가해야 하는 오버헤드가 발생하기도 한다. 관계형 데이터베이스의 경우 구조를 어떻게 설계하느냐에 따라 효율의 차이가 크게 나타나므로 성능 향상을 위한 데이터 모델링 기법이 중요한 이슈로 등장하게 되었다. 본 논문에서는 관계형 데이터베이스 성능과 관련하여 이미 연구되고 실험된 내용을 여러 문헌과 자료를 참고하여 조사하였다. 성능 항상을 위한 모델링 기법들을 테이블, 릴레이션쉽, 인덱스 등의 객체별로 분류하여 정리하였고, 조사된 내용 중에서 몇 가지를 선택하여 Oracle DBMS 환경에서 실제로 실험을 실시하였다. 대용량 테이블에 대한 질의를 수행하여 소요되는 시간을 측정하고 그 결과를 분석하였다. 실험을 통해 검증된 결과를 토대로 제안되는 모델링 방법을 제시한다.

  • PDF

The Development of the Drawing Information Management Module for the Technical Document Management System (Technical Document Management System을 위한 도면정보 관리시스템 개발)

  • Yoon, Hee-Chul;Kim, Sun-Ho
    • IE interfaces
    • /
    • v.7 no.3
    • /
    • pp.213-225
    • /
    • 1994
  • For the implementation of CE(Concurrent Engineering), the TDMS(Technical Document Management System) which integrates design and manufacuring information, is required. In this paper a drawing information management system, one of the essential modules for the TDMS has been developed. The system is operated in SUN SPARC II workstations. A CAD software called CIMCAD-2D is used for the storage and management of drawings. Relational DBMS ORACLE is used for the development of information data bases concerned with drawings. As an integration tool, the multi-media software called LINKAGE is used. Various functions for drawings and concerned information have been developed with the internal language CIMSHELL and SQL $^*PLUS$.

  • PDF

Implementation of An Automatic Program Generator for Transforming CASE Data Format into CDIF Format (CASE 자료 형식으로부터 CDIF 형식으로 변환하는 프로그램 자동 생성기의 구현)

  • Bae, Sang-Hyun;Nam, Young-Kwang;Shin, Gyu-Sang
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.12
    • /
    • pp.3840-3847
    • /
    • 2000
  • Electronic Industries Association has set a standard format called CDIF(CASE Data Interchange Format) for exchanging information between CASE tools from 1991. If data used on a CASE tool is represented in CDIF format, then any other CASE tools can use the data by translating CDlF format into their own format. In order to do so, each CASE vendor must provide a translator program from CDIF to its own data format or from its own data to CDIF format. In this thesis, we have implemented a source code generator for translating CASE data format into CDIF format only if they provide how data is stored. This automatic program generator generates CDIF statements using data format used in CASE tools, meta information about stored data and CDIF meta information. In the thesis, the automatic program generator has been implemented with Java and Oracle DBMS with JOBC interface in Sun O/S environment.

  • PDF

A Study on the Extraction and Integration of Learning Object Meta-data using Web Service of Databases (DBMS의 웹서비스를 이용한 학습객체 메타데이터 추출 및 통합에 관한 연구)

  • Choe, Hyun-Jong
    • Journal of The Korean Association of Information Education
    • /
    • v.7 no.2
    • /
    • pp.199-206
    • /
    • 2003
  • XML is becoming a new developing tool of web technology because of its ability of data management and flexibility in data presentation. So it's well researched that the reusability and integration with learning objects such as text, image, sound, video and plug-in programs of web contents in computer education. But the research for storing, extracting and integrating metadata about learning object was needed prior to implementing online learning system to integrate and manage it. Therefore this study propose a new method of using web service of DBMS for extracting learning object's metadata in database server which located in 3-tier system. To evaluate the efficiency of proposed method, The test server and two DBMSs(MS SQL Server 2000 and Oracle 9i) which have 30 metadata was implemented and the response time of it was measured. The response time of it was short, but in order to using this method the additional programming with SAX/DOM was necessary.

  • PDF

An Efficient Storing Scheme of Real-time Large Data to improve Semiconductor Process Productivities (반도체 공정의 생산성 향상을 위한 실시간 대용량 데이터의 효율적인 저장 기법)

  • Chung, Weon-Il;Kim, Hwan-Koo
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.10 no.11
    • /
    • pp.3207-3212
    • /
    • 2009
  • Automatic semiconductor manufacturing systems are demanded to improve the efficiency of the semiconductor production process. These systems include the functionalities such as the analysis and management schemes for very large real-time data in order to enhance the productivities. So, it requires the efficient storage management system to store very large real-time data. Traditional database management systems(e.g. Oracle, MY-SQL, MS-SQL) are based on disk. However, previous DBMS's have the limitation on the low storing performance. In this paper, we propose a compress-merge storing method of very large real-time data using insert transaction of a block unit. The proposed method shows better processing performances compare to conventional DBMS's. Also compress-merge method makes it possible that it can store large real-time data on low storage cost. Therefore, the proposed method can be applied to an efficient storage management system in the semiconductor production process.