• 제목/요약/키워드: Database Reverse Engineering

검색결과 28건 처리시간 0.016초

마스터 데이터를 활용한 마이크로 서비스 아키텍처에서의 데이터베이스 리버스 엔지니어링 (Database Reverse Engineering Using Master Data in Microservice Architecture)

  • 신광철;이춘열
    • 한국정보통신학회논문지
    • /
    • 제23권5호
    • /
    • pp.523-532
    • /
    • 2019
  • 마이크로 서비스 아키텍처는 매우 밀접한 비즈니스 기능을 수행하기 위한 목적으로 시스템을 소형 경량 서비스로 분할하는 것에 중점을 두고 있기 때문에 민첩성, 개발 생산성, 신뢰성, 배포 용이성에만 집중하는 경향이 있다. 마이크로 서비스 아키텍처에서 바라보는 데이터베이스는 단지 데이터를 저장하고 추출하는 파일 혹은 스토리지이며, 소프트웨어 개발 편리성과 확장성을 위해서 데이터 품질은 희생될 수 있음을 강조한다. 데이터베이스 구조와 데이터 의미를 이해하기 위해 사용되는 데이터베이스 리버스 엔지니어링은 비즈니스 의사 결정을 위한 데이터 활용을 위해 필요하다. 하지만, 데이터 품질을 경시하는 마이크로 서비스 아키텍처에서는 리버스 데이터베이스 엔지니어링 적용에 어려움이 있다. 본 연구는 해결책으로써 개념 데이터 모델 복원 시 마스터 데이터를 활용한 데이터 리버스 엔지니어링 방법을 제안한다. 적용 사례로 마이크로 서비스 아키텍처로 구현된 반품 서비스 데이터베이스에 제안 방법을 구현하여 적용 가능성을 검증하였다.

역설계를 이용한 자유곡면 모델링 시스템 개발 (Development of Free-Form Surface Modeling System Using the Reverse engineering Technology)

  • 명태식
    • 한국생산제조학회지
    • /
    • 제9권3호
    • /
    • pp.111-122
    • /
    • 2000
  • It is difficult to make shape library for featrue-based modeling because free-form surface is various shaped complicated To make modeling using similar shape feature-based model is easy and fast. Recently RE(Reverse Engineering) technolo-gy is very convenient method to get free-form surface. This study develops surface editor which makes surface modeling to manipulate control points and this study We study on the effective model data management using database system.

  • PDF

Reverse Engineering을 위한 보간곡선, 곡면의 가공 및 오차 보정 (Manufacturing and error compensation of interpolated curves and surfaces for reverse Engineering)

  • 양재봉
    • 한국공작기계학회:학술대회논문집
    • /
    • 한국공작기계학회 1997년도 추계학술대회 논문집
    • /
    • pp.230-234
    • /
    • 1997
  • Reverse engineering involves digitizing a three-dimensional model or part converting the data to a CAD database description and manufacturing by CNC. Currently, the digitization is done through measurements taken manually by a CMM or touch probe mounted on a CNC machinetool. Some reverse engineering techniques require close integration between the data collection method and the surface-fitting algorithms. Accurate surface data are collected by input to the surface fitting method. This study has been found that both the smoothness of surfaces and accuracy of surface fitting are related with the degree of the interpolated surfaces.

  • PDF

플래너 밀러 재제조를 위한 역설계 및 마모 분석에 관한 연구 (A Study on the Reverse Engineering and Wear Analysis for Remanufacturing Planner Miller)

  • 최두한;공석환;변정원;김태우;홍대선
    • 한국산업융합학회 논문집
    • /
    • 제25권6_2호
    • /
    • pp.1103-1110
    • /
    • 2022
  • The old machine tools that have been used for a long time cause both increase in defective rate and decrease in productivity compared to new machines due to wear and failure of their components. In order to improve productivity and quality of machined components through remanufacturing, it is necessary to analyze the wear and failure of major components of old machine tools. In this study, the process for reverse engineering is designed for the remanufacture of planner millers, which belong to a very large machine tool. Also, the suitability of the designed process is verified through the analysis of the selected remanufactured components. In the first step of the process, some major components of the aging planner miller are scanned using a 3D laser scanner. In the next step, reverse engineering is performed using the data obtained through 3D scanning. Finally, wear and failure analysis is performed by comparing the reverse engineering data with the scan data. As a result, this reverse design and wear analysis can complement the insufficient design database and reduce costs in the maintenance of remanufactured products.

A Study on the Cost Estimate System Development Method for Nuclear Power Plant Construction Projects

  • Lee, Sang Hyun
    • 국제학술발표논문집
    • /
    • The 7th International Conference on Construction Engineering and Project Management Summit Forum on Sustainable Construction and Management
    • /
    • pp.133-137
    • /
    • 2017
  • Nuclear power plants in Korea are usually built based on a duplicated model; so the project cost data of the preceding unit can be used as reference when estimating the project cost for the succeeding unit. However, since the contracting method is oriented towards the price, empirical factors such as making top-down estimations using the reverse calculation method based on the completion cost of the preceding unit is dominant. In order to develop a project cost database to resolve such problems, the detailed cost boundary of the project cost data must be categorized by project and by system. This study proposes a method to connect the code of account with the base quantities and the IAEA account, and proposes a database structure for the development of a project cost estimation system. The estimation system developed in the future is expected to utilize the proposed project cost data structure.

  • PDF

데이터베이스 시스템에서 디지털 포렌식 조사를 위한 체계적인 데이터 추출 기법 연구 (Research of organized data extraction method for digital investigation in relational database system)

  • 이동찬;이상진
    • 정보보호학회논문지
    • /
    • 제22권3호
    • /
    • pp.565-573
    • /
    • 2012
  • 기업의 탈법, 비리 등 부정행위를 조사할 경우 인사, 회계, 물류, 생산 등의 업무데이터(Business Data)의 확보가 필요하다. 다수의 기업들은 분산된 업무 데이터를 데이터베이스(Database)화하여 통합적으로 관리하고 있기 때문에 디지털 포렌식 조사를 위하여 데이터베이스에 대한 체계적인 업무데이터 추출기법 연구가 중요하다. 일반적인 정보체계 환경에서 데이터베이스는 상위 어플리케이션 및 대용량 파일 서버와 통합된 정보체계 내의 부분적 형태로 존재한다. 또한 사용자가 입력한 원시 업무 데이터는 정규화 과정을 거친 테이블 설계에 의해 하나 이상의 테이블에 분산되어 저장된다. 기존 데이터베이스 구조 분석에 관한 연구들은 데이터베이스의 최적화와 시각화를 위하여 테이블 간 연관관계 분석이 가장 중요한 연구대상이었다. 그러나 원시 업무데이터를 획득해야 하는 디지털 포렌식 관점의 연구는 테이블 간 연관관계 시각화보다 데이터의 해석이 더 중요한 연구대상이다. 본 논문에서는 데이터베이스 내부에서 미리 정의된 테이블 간 연관관계 분석기술뿐만 아니라 도메인 전문 지식(domain knowledge)을 활용한 체계화된 분석절차를 제시하여 데이터베이스에 저장된 원시 업무 데이터 구조를 분석하고 사건관련 데이터를 추출할 수 있는 분석방안을 제안한다.

데이터베이스 역공학을 이용한 데이터 구조 추출에 관한 연구 (A Study on The Data Structure Extraction using Database Reverse Engineering)

  • 황태희;김미화;배석찬
    • 한국산업정보학회:학술대회논문집
    • /
    • 한국산업정보학회 2000년도 추계공동학술대회논문집
    • /
    • pp.447-451
    • /
    • 2000
  • 데이터베이스 역공학은 소프트웨어의 융통성을 개선하여 과거의 개발들을 재사용하고 유지비용을 감소하는데 목적이 있다. 파일과 데이터베이스 구조의 의미 기술을 회복하는 것은 역공학의 중요한 측면이다. 이것은 데이터베이스의 정확한 데이터 구조와 무결성 제약을 발견하는 데이터 구조 추출을 포함한다. 본 논문에서는 관계 데이터베이스에 초점을 두고 소프트웨어 유지 보수를 용이하게 하기 위하여 역공학을 이용한 데이터 구조 추출 방법을 제안한다.

  • PDF

각형 강관기둥부재의 한계온도 평가 연구 (Evaluation of Limiting Temperatures of Rectangular Hollow Sections)

  • 권인규
    • 한국건축시공학회:학술대회논문집
    • /
    • 한국건축시공학회 2012년도 춘계 학술논문 발표대회
    • /
    • pp.331-332
    • /
    • 2012
  • Structural steel has been used as a primary materials to columns and beams since 1960's in Korea with an advantages of excellent of load-bearing capacity and design flexibility, and faster construction. However, if the steel columns made of structural steel exposed to fire the load-bearing capacity is going down steadily and finally reach to collapse. Therefore, building regulation requires fire resistance according to building occupation, scales. The fire resistance can be evaluated two categories. One is prescriptive method that is based on building regulation, specification and so on and the other is performance-based fire engineering method. The latter can be designed based on scientific and engineering consequences. The easiest evaluation way using the fire engineering design is comparing to the limiting temperature and maximum temperature calculated based on heat transfer theory. If the limiting temperature of a column exceeds the maximum temperature of it, the column can carry the load during the fire. Therefore, the database of limiting temperature is very essential for evaluation of column. In this paper, to build the database of column made of rectangular hollow sections 8 fire tests with loading were conducted and the relation between the limiting temperature and the applied loads showed in reverse proportion.

  • PDF

Identification of Anti-Cancer Targets of Eco-Friendly Waste Punica granatum Peel by Dual Reverse Virtual Screening and Binding Analysis

  • Usha, Talambedu;Goyal, Arvind Kumar;Lubna, Syed;Prashanth, H.P.;Mohan, T. Madhan;Pande, Veena;Middha, Sushil Kumar
    • Asian Pacific Journal of Cancer Prevention
    • /
    • 제15권23호
    • /
    • pp.10345-10350
    • /
    • 2015
  • Background: Punica granatum (family: Lythraceae) is mainly found in Iran, which is considered to be its primary centre of origin. Studies on pomegranate peel have revealed antioxidant, anti-inflammatory, anti-angiogenesis activities, with prevention of premature aging and reducing inflammation. In addition to this it is also useful in treating various diseases like diabetes, maintaining blood pressure and treatment of neoplasms such as prostate and breast cancer. Objectives: In this study we identified anti-cancer targets of active compounds like corilagin (tannins), quercetin (flavonoids) and pseudopelletierine (alkaloids) present in pomegranate peel by employing dual reverse screening and binding analysis. Materials and Methods: The potent targets of the pomegranate peel were annotated by the PharmMapper and ReverseScreen 3D, then compared with targets identified from different Bioassay databases (NPACT and HIT's). Docking was then further employed using AutoDock pyrx and validated through discovery studio for studying molecular interactions. Results: A number of potent anti-cancerous targets were attained from the PharmMapper server according to their fit score and from ReverseScreen 3D server according to decreasing 3D scores. Conclusion: The identified targets now need to be further validated through in vitro and in vivo studies.

Inversion of Spread-Direction and Alternate Neighborhood System for Cellular Automata-Based Image Segmentation Framework

  • Lee, Kyungjae;Lee, Junhyeop;Hwang, Sangwon;Lee, Sangyoun
    • Journal of International Society for Simulation Surgery
    • /
    • 제4권1호
    • /
    • pp.21-23
    • /
    • 2017
  • Purpose In this paper, we proposed alternate neighborhood system and reverse spread-direction approach for accurate and fast cellular automata-based image segmentation method. Materials and Methods On the basis of a simple but effective interactive image segmentation technique based on a cellular automaton, we propose an efficient algorithm by using Moore and designed neighborhood system alternately and reversing the direction of the reference pixels for spreading out to the surrounding pixels. Results In our experiments, the GrabCut database were used for evaluation. According to our experimental results, the proposed method allows cellular automata-based image segmentation method to faster while maintaining the segmentation quality. Conclusion Our results proved that proposed method improved accuracy and reduced computation time, and also could be applied to a large range of applications.