• Title/Summary/Keyword: Integrity Constraints

Search Result 70, Processing Time 0.018 seconds

Performance Evaluation On Parallel View Consistency Maintenance Using Referential Integrity Constraints in Data Warehouse Environment (데이터 웨어하우스에서 참조 무결성 제약 조건을 이용한 병렬 뷰 일관성 관리 기법의 성능 평가)

  • 이병숙;김진호
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2002.10c
    • /
    • pp.193-195
    • /
    • 2002
  • 데이터 웨어하우스는 효과적인 질의와 분석을 위해 물리적으로 여러 사이트에 분산된 소스 데이터로부터 통합된 정보를 추출하여 저장한 데이터 저장소로써, 실체 뷰의 집합으로 구성된다. 따라서 데이터 소스에 변경 사항이 발생하면 데이터 웨어하우스와 일관성을 유지하기 위해 실체 뷰에도 변경 사항을 반영하는 뷰 관리가 필요하다. 동시에 변경되는 여러 데이터 소스와 뷰의 상태 사이에 일관성을 보장하기 위해서는 각 소스의 변경 사항을 순서대로 뷰에 반영해야 한다. 이때 각 소스의 변경 사항을 뷰 정의와 관련된 다른 소스들과 조인을 수행해야 하는 등 뷰 갱신을 위해 많은 비용이 소요된다. PSWEEP/RI 기법은 이러한 뷰 갱신 비용을 줄이는 방법으로 뷰의 일관성을 보장하기 위해 수행해야 하는 서브질의를 참조 무결성 제약조건의 특성을 이용하여 병렬로 처리하는 방법이다. 본 논문에서는 PSWEEP/RI기법의 성능을 평가하기 위하여 이 방법의 비용 모델을 분석적으로 제시하였으며, 이 모델을 기반으로 다른 기존의 방법(SWEEP)과 성능을 비교 분석하여, PSWEEP/RI 기법이 다른 기존의 방법(SWEEP)보다 여러 소스 릴레이션의 조인으로 구성된 실체 뷰를 갱신하는 시간을 크게 단축하여 효율적으로 뷰를 관리하며, 소스의 증가에 따른 뷰 갱신 시간의 증가를 줄일 수 있음을 보였다.

  • PDF

Study of Boiler Tube Micro Crack Detection Ability by Metal Magnetic Memory (금속 자기기억법 활용 보일러 튜브의 미소 결함 검출력 연구)

  • Jungseok, Seo;Joohong, Myong;Jiye, Bang;Gyejo, Jung
    • KEPCO Journal on Electric Power and Energy
    • /
    • v.8 no.2
    • /
    • pp.93-96
    • /
    • 2022
  • The boiler tubes of thermal power plants are exposed to harsh environment of high temperature and high pressure, and the deterioration state of materials rapidly increases. In particular, parent material and welds of the materials used are subjected to a temperature change and various constraints, resulting in deformation and its growth, resulting in frequent leakage accidents caused by tube failure. The power plant checks the integrity of boiler tubes through non-destructive testing as it may act as huge costs loss and limitation of power supply during power station shutdown period due to boiler tube leakage. However, the current non-destructive testing is extremely limited in the field to detect micro cracks. In this study, the ability of metal magnetic memory technique to detect flaws of size that are difficult to inspect by the visual or general non-destructive methods was verified in the early stage of their occurrence.

Relational Data Extraction and Transformation: A Study to Enhance Information Systems Performance

  • Forat Falih, Hasan;Muhamad Shahbani Abu, Bakar
    • Journal of information and communication convergence engineering
    • /
    • v.20 no.4
    • /
    • pp.265-272
    • /
    • 2022
  • The most effective method to improve information system capabilities is to enable instant access to several relational database sources and transform data with a logical structure into multiple target relational databases. There are numerous data transformation tools available; however, they typically contain fixed procedures that cannot be changed by the user, making it impossible to fulfill the near-real-time data transformation requirements. Furthermore, some tools cannot build object references or alter attribute constraints. There are various situations in which tool changes in data type cause conflicts and difficulties with data quality while transforming between the two systems. The R-programming language was extensively used throughout this study, and several different relational database structures were utilized to complete the proposed study. Experiments showed that the developed study can improve the performance of information systems by interacting with and exchanging data with various relational databases. The study addresses data quality issues, particularly the completeness and integrity dimensions of the data transformation processes.

Optimization of Machining Process Using an Adaptive Modeling and Genetic Algorithms(1) -Simulation Study- (적응 모델링과 유전알고리듬을 이용한 절삭공정의 최적화(I) -모의해석-)

  • Ko, Tae Jo;Kim, Hee Sool;Kim, Do Gyun
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.13 no.11
    • /
    • pp.73-81
    • /
    • 1996
  • This paper presents a general procedure for the selection of the machining parameters for a given machine which provides the maximum material removal rate using a Genetic Algorithms(GAs). Some constraints were given in order to achieve desired surface integrity and cutting tool life conditions as wel as to protect machine tool. Such a constrained problem can be transformaed to unconstrained problem by associating a penalty with all constraint violations and the penalties are included in the function evaluation. Genetic Algorithms can be used for finding global optimum cutting conditions with respect to the above cost function transformed by pennalty function method. From the demonstration of the numerical results, it was found that the near optimal conditions could be obtained regardless of complex solution space such as cutting environment.

  • PDF

Automatic Construction of SHACL Schemas for RDF Knowledge Graphs Generated by Direct Mappings

  • Choi, Ji-Woong
    • Journal of the Korea Society of Computer and Information
    • /
    • v.25 no.10
    • /
    • pp.23-34
    • /
    • 2020
  • In this paper, we proposes a method to automatically construct SHACL schemas for RDF knowledge graphs(KGs) generated by Direct Mapping(DM). DM and SHACL are all W3C recommendations. DM consists of rules to transform the data in an RDB into an RDF graph. SHACL is a language to describe and validate the structure of RDF graphs. The proposed method automatically translates the integrity constraints as well as the structure information in an RDB schema into SHACL. Thus, our SHACL schemas are able to check integrity instead of RDBMSs. This is a consideration to assure database consistency even when RDBs are served as virtual RDF KGs. We tested our results on 24 DM test cases, published by W3C. It was shown that they are effective in describing and validating RDF KGs.

A Study on the Fuel Assembly Stress Analysis for Seismic and Blowdown Events (지진 및 냉각재상실사고시의 핵연료집합체 응력해석에 관한 연구)

  • Kim, Il-Kon
    • Nuclear Engineering and Technology
    • /
    • v.25 no.4
    • /
    • pp.552-560
    • /
    • 1993
  • In this study, the detailed fuel assembly stress analysis model to evaluate the structural integrity for seismic and blowdown accidents is developed. For this purpose, as the first step, the program MAIN which identifies the worst bending mode shaped fuel assembly(FA) in core model is made. And the finite element model for stress calculation of FA components is developed. In the model the fuel rods (FRs) and the guide thimbles are modelled by 3-dimensional beam elements, and the spacer grid spring is modelled by a linear and relational spring. The constraints come from the results of the program MAIN. The stress analysis of the 16$\times$16 type FA under arbitary seismic load is performed using the developed program and modelling technique as an example. The developed stress model is helpful for the stress calculation of FA components for seismic and blowdown loads to evaluate the structural integrity of FA.

  • PDF

Development and Characterization of Hafnium-Doped BaTiO3 Nanoparticle-Based Flexible Piezoelectric Devices (Hf 도핑된 BaTiO3 나노입자 기반의 플렉서블 압전 소자 개발 및 특성평가)

  • HakSu Jang;Hyeon Jun Park;Gwang Hyeon Kim;Gyoung-Ja Lee;Jae-Hoon Ji;Donghun Lee;Young Hwa Jung;Min-Ku Lee;Changyeon Baek;Kwi-Il Park
    • Journal of Sensor Science and Technology
    • /
    • v.33 no.1
    • /
    • pp.34-39
    • /
    • 2024
  • Energy harvesting technology that converts the wasted energy resources into electrical energy is emerging as a semipermanent power source for self-powered electronics and wireless low-power sensor systems. Among the various energy conversion techniques, flexible piezoelectric energy harvesters (f-PEHs), using materials with piezoelectric effects, have attracted significant interest because they can harvest a small mechanical energy into electrical signals without constraints of time and space in various environments. In this study, we used a flexible piezoelectric composite film fabricated by dispersing BaHfxTi(1-x)O3 (x = 0, 0.01, 0.05, 0.1) piezoelectric powders inside a polymeric matrix to facilitate f-PEHs. The fabricated f-PEH with optimal Hf contents (x = 0.05) generated a maximum output voltage of 0.95 V and current signal of 130 nA with stable electrical/mechanical disabilities under periodically bending deformations. In addition, we demonstrated a cantilever-type f-PEH and investigated its potential as a sensor by characterizing the output performance under mechanical vibrations at various frequencies. This study provides the breakthrough for realizing self-powered energy harvesting and sensing systems by adopting the lead-free piezoelectric composites under vibrational environments.

Testing Transactions based on Verification of Isolation Levels (고립화 수준을 검증하기 위한 트랜잭션의 시험)

  • Hong, Seok-Hee
    • The Journal of the Korea Contents Association
    • /
    • v.8 no.7
    • /
    • pp.75-84
    • /
    • 2008
  • Concurrency and synchronization problems are often caused by database applications concurrently accessing databases managed by DBMS. Most commercial DBMSs support isolation levels to resolve these problems. Verification of isolation levels are most important because consistency and integrity constraints of the database can be violated according to isolation levels of transactions that consists of database applications. We propose a test tool set to verify and reveal faulty settings of isolation levels and implement a prototype of the test tool set. The proposed tool set analyzes the SQL statements of ESQL/C programs, attaches the test codes to verify isolation levels, runs the test transactions and detects errors.

Parallel View Consistency Maintenance Using Referential Integrity Constraints in Data Warehouse Environment (데이터 웨어하우스에서 참조 무결성 제약 조건을 이용한 병렬 뷰 일관성 관리 기법)

  • 이병숙;김진호;옥수호;이우기
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2002.04b
    • /
    • pp.40-42
    • /
    • 2002
  • 데이터 웨어하우스는 물리적으로 여러 사이트에 위치한 분산된 데이터 소스로부터 추출한 온라인 분석 정보를 유지하는 실체 뷰 의 집합으로 구성된다. 따라서 데이터 소스에 변경 사항이 발생하면 데이터 웨어하우스와 일관성을 유지하기 위해 뷰에도 그 변경사항을 반영하는 뷰 관리가 필요하다 동시에 변경되는 여러 데이터 소스와 뷰의 상태 사이에 일관성을 보장하기 위해서는 각 소스의 변경 사항을 순서대로 뷰에 반영해야 한다. 이때 각 소스의 변경 사항을 뷰 정의와 관련된 다른 소스들과 조인을 수행해야 하는 등 뷰 갱신을 위해 많은 비용이 소요된다. 이러한 뷰 갱신 비용을 줄이는 방법중의 하나로 병렬처리 기법을 활용하는 연구가 시도되고 있다. 따라서 이 논문에서는 뷰의 일관성을 보장하기 위해 수행해야 하는 서브질의론 병렬로 처리하는 알고리즘을 제시하였다. 이 방법에서는 서브질의의 조인 연산들을 소스 렐레이션들 간의 참조 무결성 제약 조건을 이용하여 병렬로 처리한다. 질의의 조인 처리를 병렬화 하기 위해 소스 릴레이션간의 참조 무결성 제약조건의 툭송울 이용하여, 여러 릴레이션을 참조하는 릴레이션에서 발생하는 변경 사항에 대해 참조하는 릴레이션의 수만큼 병렬로 조인 연산을 수행하는 알고리즘을 제시하였다. 이렇게 함으로써 여러 소스 릴레이션의 조인으로 구성된 실체 뷰를 갱신하는 시간을 크게 단축하여 효율적으로 뷰를 관리하도록 하였으며, 소스의 증가에 따른 뷰 갱신 시간의 증가를 줄일 수 있도록 하였다.

  • PDF

Stochastic identification of masonry parameters in 2D finite elements continuum models

  • Giada Bartolini;Anna De Falco;Filippo Landi
    • Coupled systems mechanics
    • /
    • v.12 no.5
    • /
    • pp.429-444
    • /
    • 2023
  • The comprehension and structural modeling of masonry constructions is fundamental to safeguard the integrity of built cultural assets and intervene through adequate actions, especially in earthquake-prone regions. Despite the availability of several modeling strategies and modern computing power, modeling masonry remains a great challenge because of still demanding computational efforts, constraints in performing destructive or semi-destructive in-situ tests, and material uncertainties. This paper investigates the shear behavior of masonry walls by applying a plane-stress FE continuum model with the Modified Masonry-like Material (MMLM). Epistemic uncertainty affecting input parameters of the MMLM is considered in a probabilistic framework. After appointing a suitable probability density function to input quantities according to prior engineering knowledge, uncertainties are propagated to outputs relying on gPCE-based surrogate models to considerably speed up the forward problem-solving. The sensitivity of the response to input parameters is evaluated through the computation of Sobol' indices pointing out the parameters more worthy to be further investigated, when dealing with the seismic assessment of masonry buildings. Finally, masonry mechanical properties are calibrated in a probabilistic setting with the Bayesian approach to the inverse problem based on the available measurements obtained from the experimental load-displacement curves provided by shear compression in-situ tests.