• Title/Summary/Keyword: DB integration

Search Result 134, Processing Time 0.036 seconds

Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment (엔터프라이즈 환경의 연구비 통합관리 데이터 웨어하우스 개발 프로세스)

  • Choi, Seong-Man;Yoo, Cheol-Jung;Chang, Ok-Bae
    • The KIPS Transactions:PartD
    • /
    • v.11D no.1
    • /
    • pp.183-194
    • /
    • 2004
  • The existing management job of research expenses has been divided into three parts: budget planning, budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step Is requested. And another problem that it is difficult to toil what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integrated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transports, transforms and loads the data. Information integration agent reduces a user's efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user's requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desired analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

Development of National Scale Environmental & Geographical Information System for Supporting Exposure Assessment (노출평가를 위한 전국규모의 환경지리지형정보 시스템 개발)

  • Kim, Jong-Ho;Kim, Mi-Sug;Kwak, Byeong-Kyu;Yoo, Hong-Suk;Shin, Chi-Bum;Yi, Jong-Heop
    • Journal of Korean Society of Environmental Engineers
    • /
    • v.28 no.10
    • /
    • pp.1082-1089
    • /
    • 2006
  • This study describes a methodology to develop a environmental and geographical information system for managing a national scale which is supports the environmental fate modeling. This system was developed via the integration of environmental and geographical information database(DB) and the DB usage software. For the sound environmental management, the DB were constructed by extracting the geometrical figures-such as points, polylines, and/or polygons-based on the geographical information previously developed in Korea. Then it was connected with the environmental information. Based on the Visual Basic Complier, the software can be a useful tool for visualizing the DB, for searching the environmental & geographical information, and supporting the environmental fate modeling.

Development of Web based Integration Inspection Information System for Steam Generator in Nuclear Power Plant (Web 기반의 원전 증기발생기 통합 검사정보시스템 개발)

  • Shin, Jin-Ho;Song, Jae-Ju;Yi, Bong-Jae
    • Proceedings of the KIEE Conference
    • /
    • 2003.07d
    • /
    • pp.2603-2605
    • /
    • 2003
  • 증기발생기(SG : Steam Generator)는 다수의 세관으로 구성되어 원자로에서 발생한 열을 이용하여 발전기 터빈을 구동시키는 원동력인 증기를 생성해 주는 기능을 하는 원자력발전소의 핵심 설비이다. 증기 발생기 세관의 건전성을 확보하기 위해 매주기 계획예방 정비, 즉 가동중검사마다 정기적인 와전류검사를 수행하고, 검사결과에 따라 전열관 보수 등과 같은 제반 조치를 취하고 있다. 현재 검사데이터 DB 구축은 일부 발전소에 개발되어 운영중에 있고, 세관 DB와는 별도로 통계정보만을 관리하는 증기발생기 성능관리시스템이 운영되고 있으며, 또한 각 발전소마다 수질을 계측하여 수화학 성분을 감시하는 수질관리시스템이 운용되고 있다. 이러한 이원화된 DB 및 시스템을 통합하고 연계하여 전 원전의 증기발생기를 종합적으로 관리 할 수 있는 시스템의 필요성이 대두되었다. 따라서 본 논문에서는 현장에 보관되어 있는 모든 세관 검사데이터를 취득하여 대용량 데이터베이스를 설계 및 구축하고 이기종의 분산된 수질관리시스템 DB를 연계하여, 증기발생기의 설계/제작부터 검사결과 Mapping, 추이 분석을 통한 수명평가에 이르는 전 과정을 통합 관리한 수 있는 시스템을 개발하고 그 구현방안을 제시한다.

  • PDF

Access Control Mechanism for CouchDB

  • Ashwaq A., Al-otaibi;Reem M., Alotaibi;Nermin, Hamza
    • International Journal of Computer Science & Network Security
    • /
    • v.22 no.12
    • /
    • pp.107-115
    • /
    • 2022
  • Recently, big data applications need another database different from the Relation database. NoSQL databases are used to save and handle massive amounts of data. NoSQL databases have many advantages over traditional databases like flexibility, efficiently processing data, scalability, and dynamic schemas. Most of the current applications are based on the web, and the size of data is in increasing. NoSQL databases are expected to be used on a more and large scale in the future. However, NoSQL suffers from many security issues, and one of them is access control. Many recent applications need Fine-Grained Access control (FGAC). The integration of the NoSQL databases with FGAC will increase their usability in various fields. It will offer customized data protection levels and enhance security in NoSQL databases. There are different NoSQL database models, and a document-based database is one type of them. In this research, we choose the CouchDB NoSQL document database and develop an access control mechanism that works at a fain-grained level. The proposed mechanism uses role-based access control of CouchDB and restricts read access to work at the document level. The experiment shows that our mechanism effectively works at the document level in CouchDB with good execution time.

Development of Airworthiness Database System with Validation Process for Design Programs of General Aviation Aircraft

  • Lwin, Tun;Lee, Jae Woo;Kim, Sangho;Lee, Hyojin
    • International Journal of Aeronautical and Space Sciences
    • /
    • v.13 no.4
    • /
    • pp.435-445
    • /
    • 2012
  • In this paper, a design process is established by integrating aviation safety requirements for the development of general aviation aircraft. An Airworthiness-Design Integration System, which integrates certification requirements with the entire design/analysis process, is developed and presented. For the proposed system, KAS 23/FAR 23/AC 23/CS 23 certification regulations are analyzed to determine design constraints and system compliance checks and to construct an ER&G (Engineering Requirement and Guide) and a Design-Certification Related Table (DCRT). Furthermore, through building a DB (Data Base), the management of design and certification related resources for developing a FAR 23 class aircraft are made. Certification tools and resources are also efficiently managed by the DB. The connection between the certification requirements and the detailed design process is proposed in this system. Tracking of this proposed method is validated by configuring a USE CASE and a system. The Airworthiness-Design Integration system will be constructed based on the system's design plan, certification system, and usage scenarios.

A Development of Integration System for Distributed Geospatial Data of Homeland (분산환경 국토공간정보의 통합 시스템 구축방안에 관한 연구)

  • Joo, Young-Eun;Choi, Joon-Seok;Lee, Jin-Duk;Han, Seung-Hee
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2010.04a
    • /
    • pp.121-123
    • /
    • 2010
  • Currently different local governments and research institutes have established and using DB for each purposes on the heterogeneous database. Normally physical unification method is used in order to unify this geospatial database, but this takes too much time and resources and require periodic renewal and synchronization. Therefore, this research would like to present a logical integrated unification method based on attribute information of heterogeneous database, and a system design and construction method, in order to subjugate inefficiencies from the physical unification method. Through this a system that could supply user customized geospatial database was established and verified the functionality using the road data of an actual region.

  • PDF

Automatic Recognition of Direction Information in Road Sign Image Using OpenCV (OpenCV를 이용한 도로표지 영상에서의 방향정보 자동인식)

  • Kim, Gihong;Chong, Kyusoo;Youn, Junhee
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.31 no.4
    • /
    • pp.293-300
    • /
    • 2013
  • Road signs are important infrastructures for safe and smooth traffic by providing useful information to drivers. It is necessary to establish road sign DB for managing road signs systematically. To provide such DB, manually detection and recognition from imagery can be done. However, it is time and cost consuming. In this study, we proposed algorithms for automatic recognition of direction information in road sign image. Also we developed algorithm code using OpenCV library, and applied it to road sign image. To automatically detect and recognize direction information, we developed program which is composed of various modules such as image enhancement, image binarization, arrow region extraction, interesting point extraction, and template image matching. As a result, we can confirm the possibility of automatic recognition of direction information in road sign image.

A Study on Advanced Model for GIS Connection and Integration in Local Governments (지자체 GIS 통합.연계 고도화 모델 연구)

  • Kim, Eun-Hyung
    • Spatial Information Research
    • /
    • v.15 no.3
    • /
    • pp.189-202
    • /
    • 2007
  • As applications of GIS technology have grown in local governments, the wider and integrated use of spatial information is demanded more than before. Particularly because 70-80% of administrative information in local governments are related spatial, it becomes a key issue to connect and integrate non-spatial information with spatial information for more advanced use of GIS applications in local governments. The purpose of this study is to establish an advanced Implementation model by analyzing obstacles in existing GIS applications and suggesting implementation strategies. The strategy, as an important part of the model, includes efficient information sharing, establishment of commonly usable GIS Database, architectural improvement for Enterprise GIS in terms of database and system implementation, standardization far the model, and establishment of spatial infrastructure in the local governments. The study concludes that administrative collaboration in a horizontal and vertical perspective has a highest priority for the implementation of the model.

  • PDF

A construction Plan for the integrated information network of sports industry (스포츠산업 통합정보망 구축 방안)

  • Jun, Sunhye;Kang, SeungAe;Kim, Hyuncheol;Kwon, Hyungil;Kang, Sunyoung;Kim, Yeojin;Jeon, Heejun
    • Convergence Security Journal
    • /
    • v.13 no.3
    • /
    • pp.63-69
    • /
    • 2013
  • This research analyze the current status pertaining to the sport industry's information system and information network in Korea to propose integrated information network of sport industry construction measures with the goal of optimizing vertical and horizontal network formation, and knowledge information sharing and dissemination. To construct integrated information network of sport industry, literature examination and meeting of experts to search for measures are utilized. This paper analyze the realities of the sport industry's information system and information network in Korea to propose the following when it comes to the measures to realize sport industry's information integration. First, DB for sport industry relate information that factored in the Ontology is being developed. In other words, it is necessary to design a DB that factors in the Semantic Web. Second, once the DB relate to the sport industry that factored in the Ontology is developed, it is necessary to build RSS/Atom based active network that enables exchange of organic information among them.

Development of Hybrid Spatial Information Model for National Base Map (국가기본도용 Hybrid 공간정보 모델 개발)

  • Hwang, Jin Sang;Yun, Hong Sik;Yoo, Jae Yong;Cho, Seong Hwan;Kang, Seong Chan
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.32 no.4_1
    • /
    • pp.335-341
    • /
    • 2014
  • The main goal of this study is on developing a proper brand-new data of national base map and Data Based(DB) model for new information technology environments. To achieve this goal, we generated a brand-new Hybrid spatial information model which is specialized in the spatio-temporal map structure, the framework map for information integration, and the multiple-layered topology structure. The DB structure was designed to reflect the change of objections by adding a new dimension of 'time' in the spartial information, while the infrastructure was able to connect/converge with other information by giving the unique ID and multi-scale fusion map structure. Furthermore, the topology and multi visualization structure, including indoor and basement information, were designed to overcome limitations of expressing in 2 dimension map. The result from the performance test, which was based on the Hybrid spatial information model, confirms the possibility in advanced national base map and conducted DB model through implementing various information and spatiotemporal connections.