• Title/Summary/Keyword: Design Anomalies

Search Result 61, Processing Time 0.031 seconds

Design Anomalies in the Business Process Modeling (비즈니스 프로세스 모델에서의 설계 이상 현상)

  • Kim, Gun-Woo;Lee, Jeong-Wha;Son, Jin-Hyun
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.14 no.9
    • /
    • pp.850-863
    • /
    • 2008
  • Business Process is a set of interrelated business functions, which are defined by various business process rule and that will lead a company to accomplishing a specific organizational goal. Many business organizations are using process modeling methods for their business process management, but mostly these methods are accomplished by Human-Based activities. These human-based activities cause unexpected design anomalies in modeling phase. If process engine executed without design anomalies detection, that will be lead to huge loss on costs. To ensure that there is no design anomalies in modeling phase and to detect anomalies of predefined actions within modeling tools are important issues in business process management. In this paper, we provide specific types of design anomalies, which can effectively use to detect design anomalies in business process modeling phase.

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.

A Database Design without Storage Constraint Considering Denormalization in Relational Database (관계형 데이터베이스에서 저장용량에 제약이 없는 경우 비 정규화를 고려한 데이터베이스 설계)

  • 장영관;강맹규
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.19 no.37
    • /
    • pp.251-261
    • /
    • 1996
  • Databases are critical to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies(insert, update, and delete anomalies). However normalized database design does not account for the tradeoffs necessary for the performance reason. In this research, we model a database design problem without storage constraint. Given a normalized database design, in this model, we do the denormalization of duplicating columns in order in reduce frequent join processes. In this paper, we consider insert, update, delete, and storage cost, and the anomalies are treated by additional disk I/O cost necessary for each insert, update transaction. We propose a branch and bound method, and show considerable cost reduction.

  • PDF

A database design using denormalization in relational database (관계형 데이터베이스에서 비정규화를 사용한 데이터베이스 설계)

  • 장영관;강맹규
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 1996.04a
    • /
    • pp.172-178
    • /
    • 1996
  • Databases are critical to business information systems, and RDBMS is most widely usded for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized databese design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database desin by denormalization of duplicating attributes in order to reduce frequent join processes. In this model, we consider insert, update, and delete costs. The anomalies are treated by additional disk I/O which is necessary for each insert and update transaction. We propose a branch and bound method for this model, and show considerable cost reduction.

  • PDF

An Optimal Database Design Considering Denormalization in Relational Database (관계형 데이터베이스에서 비정규화를 고려한 최적 데이터베이스 설계)

  • 장영관;강맹규
    • The Journal of Information Technology and Database
    • /
    • v.3 no.1
    • /
    • pp.3-24
    • /
    • 1996
  • Databases are critical to business information systems, and RDBMS is most widely used for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized database design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database design by denormalization of duplicating attributes in order to reduce frequent join processes. In this mood, we consider insert, update, delete, and query costs. The anomaly and data inconsistency are removed by additional disk I/O which is necessary for each update and insert transaction. We propose a branch and bound method for this model, and show considerable cost reduction.

  • PDF

Electrical resistivity tomography survey for prediction of anomaly in mechanized tunneling

  • Lee, Kang-Hyun;Park, Jin-Ho;Park, Jeongjun;Lee, In-Mo;Lee, Seok-Won
    • Geomechanics and Engineering
    • /
    • v.19 no.1
    • /
    • pp.93-104
    • /
    • 2019
  • Anomalies and/or fractured grounds not detected by the surface geophysical and geological survey performed during design stage may cause significant problems during tunnel excavation. Many studies on prediction methods of the ground condition ahead of the tunnel face have been conducted and applied in tunneling construction sites, such as tunnel seismic profiling and probe drilling. However, most such applications have focused on the drill and blast tunneling method. Few studies have been conducted for mechanized tunneling because of the limitation in the available space to perform prediction tests. This study aims to predict the ground condition ahead of the tunnel face in TBM tunneling by using an electrical resistivity tomography survey. It compared the characteristics of each electrode array and performed an investigation on in-situ tunnel boring machine TBM construction site environments. Numerical simulations for each electrode array were performed, to determine the proper electrode array to predict anomalies ahead of the tunnel face. The results showed that the modified dipole-dipole array is, compared to other arrays, the best for predicting the location and condition of an anomaly. As the borehole becomes longer, the measured data increase accordingly. Therefore, longer boreholes allow a more accurate prediction of the location and status of anomalies and complex grounds.

A Case Study on the Design of Tunnel Excavation in Geological Anomalies (터널굴착시 지질이상대 통과방안 설계사례 연구)

  • Yoo, Joung-Hoon;Kim, Yang-Kyun;Chung, Chul-Hwa
    • Tunnel and Underground Space
    • /
    • v.21 no.5
    • /
    • pp.341-348
    • /
    • 2011
  • As a result of the detailed site investigation performed for the design of a 4.3 km long tunnel, geological anomalies of four fault zones and a rock boundary were discovered on the tunnel route. Most of all, it was confirmed that pyrite, which may corrode steel material, is contained inside the geological anomalies, and pressured ground water flows out of the fault fractured zone. To overcome these geological conditions, antisulfur concrete for the concrete lining and anticorrosive swelling rock bolts are designed in the pyrite-containing sections. For the sections where a great amount of groundwater outflows, water blocking methods including grouting are applied according to the result of numerical analyses on the seepage. In addition, since the past earthquakes occurred around Korea have take place mainly near fault zones, seismic analyses were performed based on the Soil-Structure Interaction (SSI) concept and the strength of concrete tunnel lining is designed to be 27 MPa from 24 MPa in order to reinforce the tunnel structure.

An Efficient Database Design Method for Mobile Multimedia Services on Home Network Systems (홈 네트워크 시스템 상에서 모바일 멀티미디어 서비스를 위한 효과적인 데이타베이스 설계 방안)

  • Song, Hye-Ju;Park, Young-Ho;Kim, Jung-Tae;Paik, Eui-Hyun
    • The KIPS Transactions:PartD
    • /
    • v.14D no.6
    • /
    • pp.615-622
    • /
    • 2007
  • Recently, users who want to be provided motile devices, such as PDP, PMP, and IPTV connected wireless internet, with multimedia contents are increasing due to an influence of multimedia contents. In the paper, we propose an efficient database design method for managing mobile multimedia services on home network systems. For this, we build relations using attributes required while providing multimedia services, and then design a database. Specially, we propose a database design method based on normalization theory to eliminate redundancies and update anomalies caused by a non trivial multi valued dependency in relations. In the experiments, we compare and analyze occurrence frequencies of data redundancies and update anomalies through query executions on the relation decomposed into normal forms. The results reveal that our database design is failrly effective.

KOMPSAT-2 Fault and Recovery Management

  • Baek, Myung-Jin;Lee, Na-Young;Keum, Jung-Hoon
    • International Journal of Aeronautical and Space Sciences
    • /
    • v.3 no.2
    • /
    • pp.31-39
    • /
    • 2002
  • In this paper, KOMPSAT-2 on-board fault and ground recovery management design is addressesed in terms of hardware and software components which provide failure detection and spacecraft safing for anomalies which threaten spacecraft survival. It also includes ground real time up-commanding operation to recover the system safely. KOMPSAT-2 spacecraft fault and recovery management is designed such that the subsequent system configuration due to system initialization is initiated and controlled by processors. This paper will show that KOMPSAT-2 has a new design feature of CPU SEU mitigation for the possible upsets in the processor CPUs as a part of on-board fault management design. Recovery management of processor switching has two different ways: gang switching and individual switching. This paper will show that the difficulties of using multiple-processor system can be managed by proper design implementation and flight operation.

Development of Flight Control System and Troubleshooting on Flight Test of a Tilt-Rotor Unmanned Aerial Vehicle

  • Kang, Youngshin;Park, Bum-Jin;Cho, Am;Yoo, Chang-Sun;Koo, Sam-Ok;Tahk, Min-Jea
    • International Journal of Aeronautical and Space Sciences
    • /
    • v.17 no.1
    • /
    • pp.120-131
    • /
    • 2016
  • The full results of troubleshooting process related to the flight control system of a tilt-rotor type UAV in the flight tests are described. Flight tests were conducted in helicopter, conversion, and airplane modes. The vehicle was flown using automatic functions, which include speed-hold, altitude-hold, heading-hold, guidance modes, as well as automatic take-off and landing. Many unexpected problems occurred during the envelope expansion tests which were mostly under those automatic functions. The anomalies in helicopter mode include vortex ring state (VRS), long delay in the automatic take-off, and the initial overshoot in the automatic landing. In contrast, the anomalies in conversion mode are untrimmed AOS oscillation and the calibration errors of the air data sensors. The problems of low damping in rotor speed and roll rate responses are found in airplane mode. Once all of the known problems had been solved, the vehicle in airplane mode gradually reached the maximum design speed of 440km/h at the operation altitude of 3km. This paper also presents a comprehensive detailing of the control systems of the tilt-rotor unmanned air vehicle (UAV).