• 제목/요약/키워드: Database model

검색결과 2,963건 처리시간 0.026초

도로 교량의 안전관리 네트워크 구축을 위한 계측자료의 객체 데이터베이스 설계 개념 (A design concept on object database of measurement data for building a safety management network of road bridges)

  • 박상일;안현정;김효진;이상호
    • 한국전산구조공학회:학술대회논문집
    • /
    • 한국전산구조공학회 2008년도 정기 학술대회
    • /
    • pp.518-523
    • /
    • 2008
  • In this study, we analyzed applicability of object database, designed the concept model based on object-oriented idea for measurement data management, and applied the design model to object database. The concept model composes three sub models Infrastructure managing information model, Infrastructure measurement data model, and Measurement unit model. The process to expand measurement data of new type was executed easily without changing database schema in object database. The process to expand measurement data of new type was executed easily without changing database schema in object database. Therefore, applicability of new technology to infrastructures for building a safety management network of road bridges could be increased with object database system.

  • PDF

배전운영시스템용 응용 프로그램을 위한 공통 데이터베이스 구축 (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 Fully Distributed Secure Approach using Nondeterministic Encryption for Database Security in Cloud

  • Srinu Banothu;A. Govardhan;Karnam Madhavi
    • International Journal of Computer Science & Network Security
    • /
    • 제24권1호
    • /
    • pp.140-150
    • /
    • 2024
  • Database-as-a-Service is one of the prime services provided by Cloud Computing. It provides data storage and management services to individuals, enterprises and organizations on pay and uses basis. In which any enterprise or organization can outsource its databases to the Cloud Service Provider (CSP) and query the data whenever and wherever required through any devices connected to the internet. The advantage of this service is that enterprises or organizations can reduce the cost of establishing and maintaining infrastructure locally. However, there exist some database security, privacychallenges and query performance issues to access data, to overcome these issues, in our recent research, developed a database security model using a deterministic encryption scheme, which improved query execution performance and database security level.As this model is implemented using a deterministic encryption scheme, it may suffer from chosen plain text attack, to overcome this issue. In this paper, we proposed a new model for cloud database security using nondeterministic encryption, order preserving encryption, homomorphic encryptionand database distribution schemes, andour proposed model supports execution of queries with equality check, range condition and aggregate operations on encrypted cloud database without decryption. This model is more secure with optimal query execution performance.

최소 권한 계정 분리 모델을 이용한 데이터베이스 엑세스 제어 연구 (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.

Effective UML models by using database system

  • Halim, Faisal;Muttaqin, Rizal
    • 한국인공지능학회지
    • /
    • 제1권1호
    • /
    • pp.1-3
    • /
    • 2013
  • This study suggested ways to control UML diagram and to make design of database and to retrieve diagram information by giving questions. The study classified elements of the diagram. For instance, class diagram was made of classes, and class was done of class name and attribute operator. The elements were transformed to be database table having basic key and foreign key information. The ways suggested had advantages of users' sharing of model information and reuse of the model. This study investigated cost saving, time saving and UML model construction by database. We had designed integrated and relation database that could save and manage UML diagram, and suggested retrieval. For instance, we classified class diagram into elements to make tables and kept relation of each element by using not only basic key of relation database but also foreign key information. We made database of modeling depending upon methods to give users convenience.

데이터베이스 품질 평가에 관한 사례 연구 (A Case Study on Database Quality and Quality Factors)

  • 이춘열;박현지
    • Journal of Information Technology Applications and Management
    • /
    • 제11권4호
    • /
    • pp.209-225
    • /
    • 2004
  • This paper presents case studies on database Quality uSing an extended database Quality model developed by Korea Database Promotion Center, which shall be called KDPC2003. The model is applied to evaluate two kinds of databases ; one is an operational database, the other is an information service database. The purpose of this research is two-folded. One is to evaluate database quality and assess current status of database quality management; the other is to assess usefulness of KDPC2003 and to propose ideas for its augmentation. The findings in this study will provide basic facts to test database quality evaluation models.

  • PDF

데이터베이스 기술 분류 표준화 연구 (A Study on the Standardization for the Classification of Database Technologies)

  • 최명규
    • 정보관리연구
    • /
    • 제27권2호
    • /
    • pp.33-64
    • /
    • 1996
  • 본 연구는 데이터베이스 기술분류의 표준시안을 제시하기 위하여 1차년도(1994년) 연구 결과에 대한 관점을 체계화하고 구체화시켜 수정, 보완하는 형식으로 이루어졌다. 분류관점을 정보와 이를 지원하는 시스템 측면으로 크게 나누어, 데이터베이스 일반, 정보유통, 정보검색, 데이터베이스 시스템, 주변 관련주제를 분류기준으로 하는 표준 시안의 모형이 제시되었다.

  • PDF

Optimizing Intrusion Detection Pattern Model for Improving Network-based IDS Detection Efficiency

  • Kim, Jai-Myong;Lee, Kyu-Ho;Kim, Jong-Seob;Kim, Kuinam J.
    • 융합보안논문지
    • /
    • 제1권1호
    • /
    • pp.37-45
    • /
    • 2001
  • In this paper, separated and optimized pattern database model is proposed. In order to improve efficiency of Network-based IDS, pattern database is classified by proper basis. Classification basis is decided by the specific Intrusions validity on specific target. Using this model, IDS searches only valid patterns in pattern database on each captured packets. In result, IDS can reduce system resources for searching pattern database. So, IDS can analyze more packets on the network. In this paper, proper classification basis is proposed and pattern database classified by that basis is formed. And its performance is verified by experimental results.

  • PDF

관계형 데이터베이스에서 응답시간에 제약이 있는 경우 최적 역정규화 방법 (An Optimal Denormalization Method in Relational Database with Response Time Constraint)

  • 장영관
    • 산업경영시스템학회지
    • /
    • 제26권3호
    • /
    • pp.1-9
    • /
    • 2003
  • Databases are central to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies (insert, update, delete anomalies). However, normalized database design does not account for the tradeoffs necessary for performance. In this research, I model a database design method considering denormalization of duplicating attributes in order to reduce frequent join processes. This model considers response time for processing each select, insert, update, delete transaction, and for treating anomalies. A branch and bound method is proposed for this model.

Comparison of Database Models for Developing a Pavement Performance Analysis System

  • Choi Jae-ho
    • 한국건설관리학회논문집
    • /
    • 제5권4호
    • /
    • pp.79-86
    • /
    • 2004
  • One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.