• Title/Summary/Keyword: Database Reverse Engineering

Search Result 28, Processing Time 0.028 seconds

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

  • Shin, Kwang-chul;Lee, Choon Y.
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.23 no.5
    • /
    • pp.523-532
    • /
    • 2019
  • Microservice architecture focuses on dividing it into small and lightweight services to build for the purpose of performing very close business functions. So it tends to concentrate only on agility, productivity, reliability, and ease of deployment of software development. Microservice architecture considers database as just a file or storage for storing and extracting data, emphasizing that data quality can be sacrificed for convenience and scalability of software development. Database reverse engineering for understanding database structure and data semantics is needed for data utilization for business decision making. However, it is difficult that reverse database engineering is applied in microservice architecture that neglects data quality. This study proposes database reverse engineering method that utilizes master data to restore the conceptual data model as a solution. The proposed method is applied to the return service database implemented by microservice architecture and verified its applicability.

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

  • 명태식
    • Journal of the Korean Society of Manufacturing Technology Engineers
    • /
    • v.9 no.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

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

  • 양재봉
    • Proceedings of the Korean Society of Machine Tool Engineers Conference
    • /
    • 1997.10a
    • /
    • 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 (플래너 밀러 재제조를 위한 역설계 및 마모 분석에 관한 연구)

  • Choi, Doo-Han;Kong, Seok-Hwan;Byeon, Jeong-Won;Kim, Tae-Woo;Hong, Dae-Sun
    • Journal of the Korean Society of Industry Convergence
    • /
    • v.25 no.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
    • International conference on construction engineering and project management
    • /
    • 2017.10a
    • /
    • 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 (데이터베이스 시스템에서 디지털 포렌식 조사를 위한 체계적인 데이터 추출 기법 연구)

  • Lee, Dong-Chan;Lee, Sang-Jin
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.22 no.3
    • /
    • pp.565-573
    • /
    • 2012
  • To investigate the business corruption, the obtainments of the business data such as personnel, manufacture, accounting and distribution etc., is absolutely necessary. Futhermore, the investigator should have the systematic extraction solution from the business data of the enterprise database, because most company manage each business data through the distributed database system, In the general business environment, the database exists in the system with upper layer application and big size file server. Besides, original resource data which input by user are distributed and stored in one or more table following the normalized rule. The earlier researches of the database structure analysis mainly handled the table relation for database's optimization and visualization. But, in the point of the digital forensic, the data, itself analysis is more important than the table relation. This paper suggests the extraction technique from the table relation which already defined in the database. Moreover, by the systematic analysis process based on the domain knowledge, analyzes the original business data structure stored in the database and proposes the solution to extract table which is related incident.

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

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

  • PDF

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

  • Kwon, In-Kyu
    • Proceedings of the Korean Institute of Building Construction Conference
    • /
    • 2012.05a
    • /
    • 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
    • /
    • v.15 no.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
    • /
    • v.4 no.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.