• Title/Summary/Keyword: Application common database

검색결과 86건 처리시간 0.12초

배전운영시스템용 응용 프로그램을 위한 공통 데이터베이스 구축 (Development of Common Database for the Application Programs of Distribution Management System)

  • 윤상윤;추철민;권성철;이학주
    • 전기학회논문지
    • /
    • 제62권9호
    • /
    • pp.1199-1208
    • /
    • 2013
  • In recent years, the development of application programs for distribution system analysis and control has been essential part for distribution management system (DMS). In this paper, we propose the common database for application programs of distribution management system. The proposed database model has several characteristics as followings. First, the proposed database model is designed for the common use of almost the whole distribution application software. The static equipment model and dynamic type tables are mixed and the parallel table structure is applied. Second, the linked list structure of database are used for the fast processing of applications. The database model includes the hierarchy and non-hierarchy distribution system structure. Third, the reduction method of distribution database is applied. For this, we present the network reduction rules. The basic concept of reduction rules are the electrical unification of successive line section which has not lateral branches and the removal of simple lateral branches which has no devices and other laterals. Proposed database model is tested for the Jeju system of Korea Electric Power Corporation (KEPCO). Through the test, we verified that the proposed database structure can be effectively used to accomplish the distribution system operation.

최소 권한 계정 분리 모델을 이용한 데이터베이스 엑세스 제어 연구 (A Study on Database Access Control using Least-Privilege Account Separation Model)

  • 장영수
    • 디지털산업정보학회논문지
    • /
    • 제15권3호
    • /
    • pp.101-109
    • /
    • 2019
  • In addition to enabling access, database accounts play a protective role by defending the database from external attacks. However, because only a single account is used in the database, the account becomes the subject of vulnerability attacks. This common practice is due to the lack of database support, large numbers of users, and row-based database permissions. Therefore if the logic of the application is wrong or vulnerable, there is a risk of exposing the entire database. In this paper, we propose a Least-Privilege Account Separation Model (LPASM) that serves as an information guardian to protect the database from attacks. We separate database accounts depending on the role of application services. This model can protect the database from malicious attacks and prevent damage caused by privilege escalation by an attacker. We classify the account control policies into four categories and propose detailed roles and operating plans for each account.

한국형 EMS 시스템의 Baseline 계통 해석용 소프트웨어 개발을 위한 데이터 모델링 (Data Modeling for Developing the Baseline Network Analysis Software of Korean EMS System)

  • 윤상윤;조윤성;이욱화;이진;손진만
    • 전기학회논문지
    • /
    • 제58권10호
    • /
    • pp.1842-1848
    • /
    • 2009
  • This paper summarizes a data modeling for developing the baseline network analysis software of the Korean energy management system (EMS). The study is concentrated on the following aspects. First, the data for operating the each application software are extracted. Some of the EMS network application softwares are selected for basis model. Those are based on the logical functions of each software and are not considered the other softwares. Second, the common data are extracted for equipment model and topological structure of power system in Korea. We propose the application common model(ACM) that can be applied whole EMS network application softwares. The ACM model includes the hierarchy and non-hierarchy power system structure, and is connected each other using the direct and indirect link. Proposed database model is tested using the Korea Electric Power Corporation(KEPCO) system. The real time SCADA data are provided for the test. Through the test, we verified that the proposed database structure can be effectively used to accomplish the Korean EMS system.

지리정보 데이터베이스 구축공정 관리방법론 연구 (Study on Process Management Methodology of Geographic Information Database Construction)

  • 최병길;김성수
    • 한국측량학회:학술대회논문집
    • /
    • 한국측량학회 2003년도 추계학술발표회 논문집
    • /
    • pp.257-262
    • /
    • 2003
  • This study is aimed to research the management methodology for the process of GIS database construction. In general, used methodologies are made for the purpose of application program development. And the methodologies reflected GIS characteristics are also applied for GIS software development. But the software methodologies are never introduced to construction of GIS database. In this study, various common methodologies are investigated and analyzed, and the methodology which include the characteristic of GIS database construction process as work steps and detail paths is developed and suggested.

  • PDF

중소기업을 위한 최종 사용자 컴퓨팅 PDM 시스템 개발 (Developing an End-User Computing PDM System for Small and Medium Business)

  • 도남철
    • 대한산업공학회지
    • /
    • 제41권2호
    • /
    • pp.162-172
    • /
    • 2015
  • This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

파라메트릭 모델링을 활용한 BIM 기반 건설신기술 데이터베이스 구축 (BIM-Based New Construction Technology Database Using Parametric Modeling )

  • 김다인;최재현;이진강
    • 한국건축시공학회:학술대회논문집
    • /
    • 한국건축시공학회 2023년도 가을학술발표대회논문집
    • /
    • pp.163-164
    • /
    • 2023
  • The active promotion of construction technology application, aimed at cost reduction, construction time shortening, and performance enhancement during the implementation of Value Engineering (VE) in design, is underway. However, in the process of deriving VE ideas, it is common to simply reuse VE ideas from similar past construction projects, and the application of construction technology is often insufficient. Therefore, in this study, we intend to establish a database linking construction technology information with Building Information Modeling (BIM) models to activate the application of construction technology in the process of deriving VE ideas.

  • PDF

건축구조설계 통합시스템을 위한 건축구조물의 모델링 (Modeling of Building Structure for an Integrated Structural Design)

  • 김치경;홍성묵
    • 한국전산구조공학회:학술대회논문집
    • /
    • 한국전산구조공학회 1993년도 봄 학술발표회논문집
    • /
    • pp.71-78
    • /
    • 1993
  • This study serves as a part for the development of an integrated structural design system. Efficient data management is essential in engineering computer applications where the volume of data is large and the data flow and sharing are required. From a viewpoint of computer application, building structures can be considered to be a mass ofdata. The centralized database(CDB) and database management system frees the application from the details of managing data storage and retrieval while providing a common pool of information. For this, systematic information analysis and modeling have to be preceded. In this paper we described the result of database modeling of building structure.

  • PDF

웹기반 GIS를 이용한 지하시설물 통합 시스템 구축 (The construction of Underground Facility Unification System Using Web Base GIS)

  • 강준묵;강영미;이강원
    • 한국측량학회:학술대회논문집
    • /
    • 한국측량학회 2003년도 추계학술발표회 논문집
    • /
    • pp.287-290
    • /
    • 2003
  • The base composition for a construction information union and application is insufficient, because the existent information driving for the underground facility is separately promoted from management organization. This Study is to analyze a accuracy by converting pre-constructive underground facility database to the unification database of digital map base and improve the accuracy for a field surveying. moreover, These results is to construct the information common system of web base GIS by jointing internet technology.

  • PDF

웹 스트레스 테스트를 통한 전자상거래 아키텍쳐 평가 (E-commerce Architecture Evaluation Through Web Stress Test)

  • 이영환;박종순
    • 경영정보학연구
    • /
    • 제3권2호
    • /
    • pp.277-288
    • /
    • 2001
  • Of critical importance to the success of any e-commerce site are the two factors: rapid application development and quick response time. A three-tier architecture composed of presentation layer, business layer, and data access layer emerges to allow rapid changes in user interface, business logic, and database structures. Too often, such a logical three-tier architecture is considered as requiring a three-tier physical architecture: Web server, application server, and database server running on separate computers. Contrary to the common belief, a Web stress test reveals that the three-tier logical architecture implemented on a two-tier physical platform guarantees a quicker response time due to the reduction in cross-machine communications. This would lead business firms to economize their spending on e-commerce: increasing the number of physical servers to expedite transaction is not necessarily the best solution. Before selecting a particular hardware configuration, a Web stress test needs to be conducted to compare the relative merits of alternative physical architectures. Together with capacity planning, Web stress test emerges as a powerful tool to build robust, yet economical e-commerce sites.

  • PDF

Searchable Encrypted String for Query Support on Different Encrypted Data Types

  • Azizi, Shahrzad;Mohammadpur, Davud
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • 제14권10호
    • /
    • pp.4198-4213
    • /
    • 2020
  • Data encryption, particularly application-level data encryption, is a common solution to protect data confidentiality and deal with security threats. Application-level encryption is a process in which data is encrypted before being sent to the database. However, cryptography transforms data and makes the query difficult to execute. Various studies have been carried out to find ways in order to implement a searchable encrypted database. In the current paper, we provide a new encrypting method and querying on encrypted data (ZSDB) for different data types. It is worth mentioning that the proposed method is based on secret sharing. ZSDB provides data confidentiality by dividing sensitive data into two parts and using the additional server as Dictionary Server. In addition, it supports required operations on various types of data, especially LIKE operator functioning on string data type. ZSDB dedicates the largest volume of execution tasks on queries to the server. Therefore, the data owner only needs to encrypt and decrypt data.