• 제목/요약/키워드: physical database design

검색결과 121건 처리시간 0.028초

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

  • 안양근;박시우;남재현
    • 대한전기학회:학술대회논문집
    • /
    • 대한전기학회 1998년도 하계학술대회 논문집 C
    • /
    • 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.
    • 정보기술과데이타베이스저널
    • /
    • 제4권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)

  • 황진하;박종회;조대현
    • 한국전산구조공학회:학술대회논문집
    • /
    • 한국전산구조공학회 2004년도 가을 학술발표회 논문집
    • /
    • 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)

  • 옥한석;김갑열;김창환;김상욱;신재호;양재웅
    • 산업기술연구
    • /
    • 제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)

  • 김상욱;김광호
    • 대한전기학회:학술대회논문집
    • /
    • 대한전기학회 1997년도 하계학술대회 논문집 D
    • /
    • 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)

  • 안계현;신동철;이병해
    • 한국전산구조공학회:학술대회논문집
    • /
    • 한국전산구조공학회 1999년도 가을 학술발표회 논문집
    • /
    • 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)

  • 서형수
    • 한국실내디자인학회논문집
    • /
    • 제16권2호
    • /
    • 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)

  • 변상법;이동길;남택우;손승진;이순요
    • 대한인간공학회:학술대회논문집
    • /
    • 대한인간공학회 1997년도 춘계학술대회논문집
    • /
    • 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

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

  • 임종호;김건중;최장흠;최익순;한현규;김태균;전동훈
    • 대한전기학회:학술대회논문집
    • /
    • 대한전기학회 1999년도 하계학술대회 논문집 C
    • /
    • 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)

  • 이종학;박병권
    • 정보처리학회논문지D
    • /
    • 제9D권2호
    • /
    • pp.203-214
    • /
    • 2002
  • 본 연구에서는 공간 데이터베이스 시스템에서 변환기법을 이용한 공간 액세스 구조에 대한 물리적 데이터베이스의 설계기법을 제안한다. 지금까지 공간 액세스 구조에 대한 많은 연구가 수행되어 왔으나 공간의 물리적 데이터베이스 설계의 측면에서의 연구는 수행된 바가 없다. 본 논문에서는 먼저 원공간(original space)에 주어지는 모든 광간 질의가 변환기법에 의한 변환공간에서는 한 가지 형태의 범위 질의로 변환되는 특징이 있음을 보인다. 그리고 변환공간상에서 이 범위 질의가 위치하는 질의 영역의 모양과 데이터 페이지가 위치하는 페이지 영역의 모양 사이의 관련성을 이용하여 질의처리의 성능을 향상시킬 수 있는 공간 액세스 간조의 최적 구성 기법을 제안한다. 또한, 성능평가를 위하여 공간 액세스 구조의 하나인 MBR-MLGF를 이용하여 다양한 질의 패턴과 데이터 분포에 대하여 제안된 설계기법을 적용한 실험 결과를 제시한다. 실험 결과에 의하면, 제안된 기법은 주어진 질의 패턴에 따라 최적의 MBR-MLGF를 구성할 수 있으며, 이차원 원공간에 대하여 변환공간으로 일반화한 사차원 질의 영역의 구간비가 1 : 16 : 256 : 4096인 경우, 기존의 순환 분할 기법에 비해 질의처리의 성능이 다섯배 이상으로 향상된다. 이러한 질의처리 성능의 향상은 제안된 물리적 데이터베이스 설계기법이 매우 유용함을 나타내는 것이다.