• Title/Summary/Keyword: Database model

Search Result 3,006, Processing Time 0.028 seconds

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

  • Park, Sang-Il;An, Hyun-Jung;Kim, Hoy-Jin;Lee, Sang-Ho
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2008.04a
    • /
    • 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 (배전운영시스템용 응용 프로그램을 위한 공통 데이터베이스 구축)

  • Yun, Sang-Yun;Chu, Chul-Min;Kwan, Seong-Chul;Lee, Hak-Ju
    • The Transactions of The Korean Institute of Electrical Engineers
    • /
    • v.62 no.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
    • /
    • v.24 no.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 (최소 권한 계정 분리 모델을 이용한 데이터베이스 엑세스 제어 연구)

  • Jang, Youngsu
    • Journal of Korea Society of Digital Industry and Information Management
    • /
    • v.15 no.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
    • Korean Journal of Artificial Intelligence
    • /
    • v.1 no.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 (데이터베이스 품질 평가에 관한 사례 연구)

  • Lee Cheen Yeul;Park Hyun Jee
    • Journal of Information Technology Applications and Management
    • /
    • v.11 no.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 (데이터베이스 기술 분류 표준화 연구)

  • Choi, Myung-Kyu
    • Journal of Information Management
    • /
    • v.27 no.2
    • /
    • pp.33-64
    • /
    • 1996
  • The systematic classification of database technologies is being much debated issue currently in the telecommunication and database industry. Such a rapid requirement toward standard classification model will enable many experts to characterize database technologies. The purpose of this study is to obtain a general overview and suggest a draft for the development of standard model associated with classification. This presented model is concentrating on information and database system. This presentation is catalogued by 5 subjects such as : general overview, information distribution, information retrieval systems, database systems, peripheral aspects related to database.

  • 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.
    • Convergence Security Journal
    • /
    • v.1 no.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 (관계형 데이터베이스에서 응답시간에 제약이 있는 경우 최적 역정규화 방법)

  • 장영관
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.26 no.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
    • Korean Journal of Construction Engineering and Management
    • /
    • v.5 no.4 s.20
    • /
    • 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.