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

The solution to realize the multi-organization and multi-view of BOM data through nosql database

A solution, multi-view technology, applied in the field of BOM system, can solve problems such as low processing efficiency, time-consuming retrieval, low user experience, etc., to achieve easy implementation, avoid table structure and business logic, and flexible data structure Effect

Inactive Publication Date: 2021-08-17
CHINA NORTH IND NEW TECH PROMOTION INST +2
View PDF11 Cites 0 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
  • The solution to realize the multi-organization and multi-view of BOM data through nosql database
  • The solution to realize the multi-organization and multi-view of BOM data through nosql database
  • The solution to realize the multi-organization and multi-view 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

A solution to realize multi-organization and multi-view of BOM data through NoSQL database. Multi-organization refers to the network relationship formed by multiple business organizations and superior-subordinate relationships in a large enterprise. Multi-view refers to the BOM tree corresponding to the same product. Different business organizations define, maintain, and view different content or values. For example, the common man-hour quota, the value maintained in the process department of the group is different from the value maintained by A branch factory or B branch factory. Therefore, for any same attribute of a node in the BOM tree, multiple values ​​can be stored in NoSQL data, and these values ​​are distinguished by TAG. When defining a view, define the value of the attribute through one TAG or multiple TAGs. Through the view definition, different BOM structures, node attributes and attribute values ​​are displayed for 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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/20
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

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

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