|
With the development of computer technology and the wide application of CAD, similar to PDM (Product Data Management, Product Data Management) system of information management systems continue to emerge, the BOM' dissertation">BOM system as an important part of the ERP system, due to the use of a long cycle, facilitate data acquisition and processing characteristics, more and more attention by the industry, and both the BOM as the core of the product information integration. In this paper, the actual needs of a large aviation manufacturing companies, respectively, in the Visual Studio 6.0 platform using VB language MyEclipse platform using JAVA language development tools, Oracle 9I database connected to its BOM management system all function. In addition, in order to better show reports and improve user efficiency, we also use Component One platform plug-ins, such as True DBGrid, Sizer One. On the server side, we use the ICA Citrix platform provides tools such as protocols and VPN achieve so in a different location, under different operating systems, user can use the system through the network normal. This article in-depth discussion BOM management system development status and potential problems, and summarizes the unique characteristics of the industry BOM model, as the basis of system. Product BOM tree, especially for the aviation industry so that the finished parts for complex products, both in depth and breadth are much higher than the general. This article by the current popular BOM structure analysis select multilayer traversal methods to construct the BOM tree, and completed middleware Find. Definition introduces a WBS (work breakdown structure), analysis of the relationship between BOM and WBS mapping, the establishment of a mathematical model of the BOM and WBS structure, as well as the mapping model between them, and the process is clear for an instance. Considering the specific business processes of the various departments in the design of the structure of the table to keep part of the redundant data, the introduction of materialized views and other space-for-time program, to improve system efficiency. And based on the entire business flow, the BOM system is divided into nine sub-system can execute concurrently, without disturbing each other, and strictly follow the business rules to achieve the work of the various departments. Practical application in the import of the product structure diagram, simply click on the corresponding parts, the system will automatically find whether the part contains the information of concern to the production department of the assembly, as well as the amount, origin. To ensure that the day-to-day production data and historical data to update, accurate and reliable, but also by adopting a series of ETL processes will meet certain conditions, the production data to the data warehouse to complete the next phase of the analysis due to the huge amount of data in the industry, , rather than stored in the production database. Reporting requirements of the user, through the introduction of the Excel object model, so that users can set the parameters in the system automatically by the system after the completion of the query and export functions. The system functions related to this article has been put into the production run, the completion of the expected target, to prove the feasibility and accuracy of the various algorithms.
|