Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Solution for realizing multiple organizations and multiple views of BOM data through NoSQL database

A solution, multi-view technology, applied in the field of BOM system, can solve problems such as time-consuming retrieval, low processing efficiency, and difficulty in understanding, and achieve the effect of avoiding table structure and business logic and being easy to implement

Inactive Publication Date: 2018-10-26
CHINA NORTH IND NEW TECH PROMOTION INST +2
View PDF11 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to meet the above business needs, many solutions using relational data have been proposed, but there are many limitations: 1) The table structure is complex, difficult to understand, and the development workload is heavy
2) When storing a large amount of data, the processing efficiency is low and the user experience is low; for example, it takes a considerable amount of time to retrieve a complete BOM tree
3) Limited by the relational database, the flexibility of the data format is poor

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
  • Solution for realizing multiple organizations and multiple views of BOM data through NoSQL database
  • Solution for realizing multiple organizations and multiple views of BOM data through NoSQL database
  • Solution for realizing multiple organizations and multiple views of BOM data through NoSQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] Suppose a group A has two branches B and C.

[0042] Define TAG: The value corresponding to TAG=0 is the default value, TAG=1 is group user, TAG=2 is B branch, TAG=3 is C branch. The priority of its value is, if the branch factory has a definition, the value of the branch factory will be adopted; if the branch factory does not define a value, the value of the group will be used. If neither is defined, default values ​​are used.

[0043] Assume that the BOM attributes include parent material (default attribute), quantity, color, etc.

[0044] Define the BOM view, respectively figure 1 , corresponding to group A, the attributes included in the view are upper and lower materials, quantity, color, TAG=[1,2], and the priority is defined as (2,1), that is, the value of TAG=2 has a higher priority than the value of TAG=1 ;

[0045] For the BOM tree corresponding to component M001, see image 3 .

[0046] Build a complete BOM tree in memory, and sort the nodes according t...

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 discloses a solution for realizing multiple organizations and multiple views of BOM data through an NoSQL database. The multiple organizations refer to a netty relationship composed of multiple business organizations and leader-member relations in a large enterprise, wherein the business organizations are such as design, process, production, sale, purchase and the like, and the leader-member relations are such as a group and branches and the like. The multiple views refer to BOM trees corresponding to the same product, and contents or values defined, maintained and viewed by different business organizations are different. For a common man-hour quota, a value maintained by a process department of the group is different from a value maintained by the A branch or the B branch. Therefore, for any same attribute of nodes in the BOM trees, multiple values can be stored in NoSQL data and are distinguished by TAGs. During view definition, attribute values can be defined through one or more TAGs. Through the view definition, different BOM structures, node attributes and attribute values are displayed for the different business organizations.

Description

technical field [0001] The present invention relates to a BOM system for the discrete manufacturing industry. Background technique [0002] For large-scale discrete manufacturing enterprises, there are usually the following typical business requirements: first, multi-organizational structure, that is, BOM data needs to be combined with enterprise organization, for example, for the same product, there are differences between production in factory A and factory B; other Second, multi-view, for the same BOM data, different business departments, groups / companies / workshops, etc. have different concerns, so it is an effective way to provide group views and company views; third, heterogeneous data, usually production includes multiple The data structure of different companies' data is different; Fourth, massive data. [0003] In order to meet the above business needs, many solutions using relational data have been proposed, but there are many limitations: 1) The table structure is...

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
IPC IPC(8): G06F17/30
Inventor 曲强何川马军应小昆周渝丰雷旭吴亚瑜高红云袁家鹏李济龙祁玉亭鄢泳苏震孙林沈明艳高原
Owner CHINA NORTH IND NEW TECH PROMOTION INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products