PCBN tool multimedia database consulting management system (2)

Cutting database submodule

This sub-module manages general cutting data and has the function of a general database.

Video database submodule

The sub-module uses multimedia technology to pre-edit and arrange various video data related to PCBN tool processing, and store it in the database as video data and manage it. Using the MMcontrol multimedia control in Visual Basic, the color video data of the actual processing using the PCBN tool can be adjusted and played, and the audio effect is good. Figure 3 shows the video of the PCBN tool cutting process played with this module.

Image database submodule

The sub-module archives existing PCBN tool image data such as tool wear image, tool life curve, tool structure map, etc. as image data, and can search as needed. Figure 4 shows an image of the wear pattern of the PCBN tool.

In the process of using PCBN tools, quick query of processing information has important practicality for operators. When developing a database management system, you need to establish an ODBC (Open Data Base Connectivity) data source. ODBC is essentially a database engine that provides access to a variety of data in a database.

ODBC is also a unified database application interface (API) designed for various database management systems. It consists of API, driver manager and driver. Because ODBC provides a unified interface to the database management system, designers do not have to care about the underlying DBMS (Data Base Management System) when programming, which greatly simplifies the data exchange between different DBMS. The query function of this system uses SQL (Structured Query Language) query technology. The technique is simple and easy to learn, and has great flexibility in selecting records in one or more tables in a relational database through command statements similar to English and according to criteria specified by the designer. The query method is simple and clear, and can be queried according to the tool number and the workpiece material. When querying according to the workpiece material, the result is displayed for all available tool types, so that the tool can be optimized. Figure 5 shows the PCBN tool query interface. After selecting the query mode, click the “Query” button to enter the query result interface as shown in Figure 6. Here, the user can query the most suitable cutting amount and tool geometry parameters when machining the corresponding material workpiece with any grade tool.

Tool life simulation module

Because the formula for calculating the tool life is quite complicated, in order to obtain the image and realistic 3D simulation surface of PCBN tool life, the system uses Matlab simulation software. Matlab is a high-performance programming software for engineering calculations. It has powerful calculation and graphics functions, can visualize a large number of data results, and can easily modify and edit the graphical interface. In the tool life simulation module, Visual Basic and Matlab interface technology are used. The Matlab program can be called in the Visual Basic environment, and the relevant parameters in the tool database can be read by using the DLL (Dynamic Link Library) dynamic link library in Matlab. 3D simulation graphics of tool life. Figure 7 shows a three-dimensional simulation of the machined surface roughness plotted against the tool's main declination, secondary declination, and feed. According to the cutting parameters v, f and a p to simulate the tool life, a clear and clear relationship between the tool life T and each cutting parameter can be obtained, which can provide necessary reference information for reasonable selection of cutting amount and improvement of tool life. In the next step, we will further enrich and improve the system functions by extending the powerful toolbox of Matlab software.

Technical advisory module

Use the technical advisory module to find out all kinds of information about PCBN tools. The module consists of five sub-modules.

System help submodule

The system help sub-module has a full library comment function, which can provide detailed help information for the user to use the system correctly. The sub-module is similar to a multimedia teaching software, with a voice commentary function, and is highly ornamental.

Manufacturer product introduction sub-module

This sub-module details the performance and characteristics of the PCBN tooling products of five well-known PCBN tool manufacturers (De Beers, Toshiba, Sumitomo, Yujie and GE) and some domestic manufacturers. The content is informative and extremely It is authoritative and provides necessary reference information for users to choose PCBN tool products reasonably. Figure 8 shows the interface of the manufacturer's product introduction sub-module.

Tool design using technical consulting sub-module

This sub-module mimics the format of the Windows Explorer, which will be related to the manufacturing process of PCBN tools, metal softening effects when cutting hardened steel, hard cutting mechanism, machined surface integrity, PCBN tool damage mechanism and tool life, PCBN tool Information such as the use of technology is integrated and queried in a VB environment. Use the Web Brower browser to view dynamic web effects (shown in Figure 9). Users can easily and quickly query the PCBN tool information in the catalog or index as needed.

Multimedia information browsing sub-module

Use this sub-module to view and browse all the data and multimedia data in the database.

Processing example introduction submodule

The sub-module can play a demonstration of the processing of the PCBN tool for the user in multimedia form.

Third, the online query function

The system has an online query function, which can use the Internet technology to remotely query the system database on the Internet. Because the system is built on the Microsoft SQL Server 7.0 platform, its network functionality is more stable than databases created with other software.

Fourth, the conclusion

The PCBN tool multimedia database consulting management system introduced in this paper is a Windows NT/98 environment-based application software with reasonable design, complete functions, rich information, beautiful interface, adaptability and portability, simple and flexible operation, stable operation. Reliable, easy to maintain and other advantages, can meet the needs of PCBN tool information management, and has extremely high use value for PCBN tool users and research and development personnel.

Previous page

Thin Edge Basin

Thin-edge ceramic bathroom hand wash Basin is cabinet basins with edge thickness 16mm-18mm. Elegant shape with different size and bowl depth. wholesale porcelain outdoor counter wash basin Double tank bathroom cabinet hand wash basins Toilet ceramic sink.For more details, thanks to click the relative items to view more information.Equipped with most advanced casting equipment and computerized kiln, Jetman is able to meet daily capacity of 3,000pcs. By installing most advanced production equipment, JETMAN has introduced more than 300 designs into its range, including Thin-edge basin, Mid-edge basin, Cabinet Basin, laundry basin, Art Basin, Counter basin and Color Basin. Thanks to its own R&D department, Jetman has an edge over others in developing exclusive designs upon customer drawings. Options of purchasing either AB grade or A grade are available.europe ceramic bathroom types hand wash bowl

Ceramic Bathroom Double Wash Basin,Long Narrow Bathroom Sink Basin,Bathroom White Wash Hand Basin, Wash Basin for Bathroom,Small Size Wash Basin Rectangular,Luxury Wash Basins,Vanity Top Bathroom Sink,White Wash Hand Basin,Mosaic Bathroom Tiles

GUANGDONG ZHIJIE SANITARY WARE CO., LTD. , https://www.zhijiesanitary.com