• Title/Summary/Keyword: physical database design

Search Result 122, Processing Time 0.025 seconds

A Study on The Database Design and Construction of Power System Operational Planning System (전력수급계획시스템 데이터베이스 설계 및 구축에 관한 연구)

  • Ahn, Yang-Keun;Park, Si-Woo;Nam, Jae-Hyun
    • Proceedings of the KIEE Conference
    • /
    • 1998.07c
    • /
    • pp.1012-1014
    • /
    • 1998
  • This paper presents a database design for power system operational planning system 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 the integrated system is Highly Integrated Total Energy System(HITES). We first describe the requirements for the Power System Planning System of HTES. Database design is processed in two phases(conceptual design and physical design), and CDM(Conceptual Data Model) and PDM(Physical Data Model) are generated by Powerdesigner(CASE tool for database design). In the future, the constructed database needs to be tested and tuning.

  • PDF

Incentive-Compatible Priority Pricing and Transfer Analysis in Database Services

  • Kim, Yong J.
    • The Journal of Information Technology and Database
    • /
    • v.4 no.2
    • /
    • pp.21-32
    • /
    • 1998
  • A primary concern of physical database design has been efficient retrieval and update of a record because predictable performance of a DBMS is indispensable to time-critical missions. To maintain such phenomenal performance, database manages often spends more than or as much as the goal of an organization can warrant. The motivation of this research stems from the fact that even predictable performance of a physical database can be hampered by stochastic query processing time, physical configurations of a database, and random arrival processes of queries. They all together affect the overall performance of a DBMS. In particular, if there are queuing delays due to limited capacity or during on-peak congestion, this paper suggest to prioritize database services. A surprising finding of this paper is that such a transition from a non-priority system to a corresponding priority-based system can be Pareto-improving in the sense that no users in the system will be worse off after the transition. Thus prioritizing database services can be a viable option for efficient database management.

  • PDF

The Database Design for the Management of Bridge Measurement Information (교량 계측 정보 관리를 위한 데이터베이스 설계)

  • 황진하;박종회;조대현
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2004.10a
    • /
    • pp.126-132
    • /
    • 2004
  • The database design for the management of bridge measurement information is presented in this paper. To express the associated data generated during the whole process of ambient measurement efficiently, requirements analysis for database construction is performed. And to define objects and organize schema conceptual and logical design are performed, which convert data model into logical schema. Finally, physical design is performed using DDL(data defined language). This database is based on the object-relational data modeling approach that has rich expressive power and good reusability in comparison with the traditional entity-relational modeling.

  • PDF

Three-Phase Database Design for a Geographic Information System (지리(地理) 정보(情報) 시스템을 위한 삼단계(三段階) 데이터베이스 설계(設計))

  • Ock, Han-Suk;Kim, Gap-Youl;Kim, Chang-Hwan;Kim, Sang-Wook;Shin, Jae-Ho;Yang, Jae-Ung
    • Journal of Industrial Technology
    • /
    • v.18
    • /
    • pp.343-353
    • /
    • 1998
  • Effective design of a database is essential for operating application systems efficiently. This paper discusses database design for a geographic information system. This goals of database design are multiple: to satisfy the information content requirements of the specified users and applications; to provide a natural and easy-to-understand structuring of the information; and to support processing requirements and any performance objectives such as response time, processing time, and storage space. Database design is a very complex process and is decomposed in three phases: conceptual, logical, and physical design. In this paper, we first collect and analyze the requirements for a geographic information system. We also perform database design for these requirements through the three design phases systematically. Our results would contribute to the effective construction of a database for a geographic information system.

  • PDF

Database Design for the Automatic Distribution System (배전 자동화 시스템을 위한 데이타베이스 설계)

  • Kim, Sang-Wook;Kim, Kwang-Ho
    • Proceedings of the KIEE Conference
    • /
    • 1997.07c
    • /
    • pp.754-757
    • /
    • 1997
  • Effective design of a database is essential for operating application systems efficiently. This Paper discusses database design for the automatic distribution system. Database design is a complex Process for specifying the structure of information and is decomposed in three Phases: conceptual, logical, and Physical design. In this paper, we first collect and analyze the requirements for the automatic distribution system, our target application. We also perform database design for these requirements through three design Phases. We believe that our results would contribute to the effective construction of a database for the automatic distribution system.

  • PDF

A Study On Product Data Model for Central Database in an Integrated System for Structural Design of Building (구조설계 통합 시스템에서 중앙 데이터베이스를 위한 데이터 모델에 관한 연구)

  • 안계현;신동철;이병해
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 1999.10a
    • /
    • pp.444-451
    • /
    • 1999
  • The purpose of this study is to Propose data models for central database in integrated system for structural design building. In order to efficiently express data related to structure, I analyzed the structure design process and classified data considering design step. 1 used an object-oriented modeling methodology for logical data model and relational modeling for physical data model. Based on this model, we will develop an integration system with several applications for structure design. Each application will communicate through the central database.

  • PDF

Design of an Effective Human Sensibility Ergonomic Interior Design Analysis Tool (효율적인 감성공학적 인테리어 디자인 분석 도구의 설계)

  • Seo, Hyung-Soo
    • Korean Institute of Interior Design Journal
    • /
    • v.16 no.2 s.61
    • /
    • pp.314-321
    • /
    • 2007
  • The statistical method of human sensibility ergonomics is widely used for analyzing interior design because it has standard processes and it can help to get quantifiable results. However applying this method demands repeated intense work and great time and effort is required. In this study, a tool applying Web and virtual reality techniques for statistical human sensibility ergonomic interior design analysis is proposed and the key parts of the tool including database and interface are implemented. The database contains the sensibility adjective table and the physical interior design factor table for analyzing the relationship between human sense and physical design factors. Interface of the tool is implemented using Web technologies, so testers can evaluate interior design samples via standard Web browsers. The 3D control which is an important component of the interface is also implemented. Employing the suggested tool can reduce effort and time for evaluating human sense in Interior design field.

A Study on Implementation of Human Sensibility Ergonomics for Product Development (감성공학적 제품개발 시스템 구현에 관한 연구)

  • 변상법;이동길;남택우;손승진;이순요
    • Proceedings of the ESK Conference
    • /
    • 1997.04a
    • /
    • pp.196-199
    • /
    • 1997
  • This paper describes the implementation process of Virtual Modeling system for a customer-oriented product. The human sense is measured and analyzed by physical design factors and can be applied also for the product design. The first step implementing virtual modeling is to make a human sensibility("Kansei") database. Human sensibility database is constructed with the relational data of Kansei words and design factors. The next step is extraction the design information from the human sensibility database by fuzzy inference algorithm. This design information is used for the input data for the graphic database. Virtual implementation software compounds 3D shape of product. The final product can be modified according to the customer's requirement.quirement.

  • PDF

A Study of Database Design and Construction for Voltage Security On-line Monitoring System(VSECOMs) (전압안전성 온라인 감시시스템의 DB 설계 및 구축에 관한 연구)

  • Rhim, C.H.;Kim, K.J.;Choi, J.H.;Choi, I.S.;Han, H.G.;Kim, T.G.;Jeon, D. H.
    • Proceedings of the KIEE Conference
    • /
    • 1999.07c
    • /
    • pp.1253-1255
    • /
    • 1999
  • This paper presents database design and construction for VSECOMs (Voltage Security On-line Monitoring System). The database design has steps of requirements collection and analysis, conceptual design, logical design, and physical design. For interconnection between New EMS and VSECOMs to get the needed data, Snapshots in ORACLE are proposed. It proved the proposal to be compatible through the case study.

  • PDF

A Physical Database Design Method for Access Structures of Spatial Database Systems (공간 데이터베이스 시스템을 위한 액세스 구조의 물리적 데이터베이스 설계 기법)

  • Lee, Jong-Hak;Park, Byeong-Gwon
    • The KIPS Transactions:PartD
    • /
    • v.9D no.2
    • /
    • pp.203-214
    • /
    • 2002
  • This paper presents a physical database design methodology for spatial access structures using transformation techniques in spatial database systems. Recently, many spatial access structures have been proposed in the literature. However, there has been no effort for their physical database design. We first show that most spatial queries in the original space are transformed into one type of range queries in the transform space, and then propose a method for finding the optimal configuration of spatial access structures by using the relationship between the shapes of query regions, that are correspond to the range queries, and page regions, that are correspond to data pages, in the transform space. For performance evaluation, we perform extensive experiments with the MBR-MLGF, a spatial access structure using transformation techniques, using various types of queries and data distributions. The results indicate that our proposed method builds optimal MBR-MLGF according to the query types. When the interval ratio of a transformed four-dimensional query region is 1 : 16 : 256 : 4096, the performance of the proposed method is enhanced by as much as five times over that of the conventional cyclic splitting method. The result confirms that the proposed physical database design methodology is useful in a practical way.