Supercharge Your Innovation With Domain-Expert AI Agents!

Storing method and device and query method and device of bill of materials

A bill of materials, material technology, applied in special data processing applications, instruments, electrical digital data processing and other directions, can solve the problems of high calling overhead, low query efficiency, complex processing logic, etc.

Inactive Publication Date: 2010-05-12
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] It can be seen that the existing technology adopts a hierarchical storage method, which has complex processing logic and low query efficiency during application.
Since in actual production, the query for BOM is very frequent, it will cause a very high overhead for each call, seriously affecting the availability of the system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Storing method and device and query method and device of bill of materials
  • Storing method and device and query method and device of bill of materials
  • Storing method and device and query method and device of bill of materials

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0089] In order to enable those skilled in the art to better understand the solutions of the embodiments of the present invention, the embodiments of the present invention will be further described in detail below in conjunction with the drawings and implementations.

[0090] The method and device for storing the bill of materials in the embodiment of the present invention is aimed at the problem of low processing efficiency and high overhead when querying the BOM that adopts hierarchical storage in the prior art. For all BOM data, all BOM data are expanded according to the forward expansion method of hierarchical storage For sub-item materials, traverse all data nodes of the BOM according to the expansion result, record the structure information of the data nodes, establish a query structure of the BOM according to the structure information, and store the query structure in the database , to support BOM fast query.

[0091] like Figure 4 As shown, it is a flowchart of a met...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a storing technology of bill of materials, and discloses a storing method and a storing device of bill of materials, wherein the method comprises the steps of unfolding hierarchically stored bill of materials in positive direction; traversing all the data nodes of the bill of materials and recording the structural information of the data nodes; establishing a query structure of the bill of materials according to the structural information; and storing the query structure of the bill of materials in a data base. Accordingly, the invention also discloses a query method and a query device of bill of materials. The invention can realize the fast query on the bill of materials, reduce the system cost on unfolding the bill of materials, and improve query efficiency.

Description

technical field [0001] The invention relates to a material list storage technology, in particular to a material list storage method and device, and a query method and device. Background technique [0002] To adopt computer-aided enterprise production management, first of all, the computer must be able to read the composition of the products manufactured by the enterprise and all the materials involved. In order to facilitate computer identification, it is necessary to convert the product structure represented by the diagram into a certain data format. The file that describes the product structure in data format is the bill of materials, or BOM. It is a technical document defining the product structure, so it is also called product structure table or product structure tree. In some industries, it may be called a "recipe," "table of ingredients," or other names. [0003] BOM is very important basic data in the production system. In the process of MRP (Material Requirements ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06Q10/00G06Q10/06
Inventor 白智勇
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com