TWI469067B - System and method for configuring the basal data of product - Google Patents

Description

Product basic data configuration system and method

The invention relates to a product basic data configuration system and method.

For some large companies, especially some multinational companies, the collection and processing of data is very important. The company needs a large amount of timely and accurate information every moment to ensure the timeliness and correctness of the decision. A common problem faced by these companies is that the data is distributed and dispersed due to the dispersion of the company's operations. With the development of computers and networks, some relatively independent departments, subsidiaries and branches within the company have gradually established their own internal network systems, which has improved the speed and accuracy of internal data processing. However, for the entire company, The data is still distributed in an island shape. Therefore, it takes a lot of manpower, material resources and financial resources to obtain integrated data from these data islands. However, it is difficult to ensure that the collected information is timely and effective.

At present, most of the product information is stored in the database in a linear structure, and the data is not closely related to each other, which is inconvenient for the user to operate and reduces the work efficiency.

In view of the above, it is necessary to provide an effective product basic data configuration system and method.

The product basic data configuration system includes a computer and a database connected to the computer, wherein the data warehouse stores a tree table and basic information of the product, and the computer includes: The class module is used to classify product data into two categories: departmental organization class and product class; definition module, which is used to define the upper and lower level relationship of the internal data of the two types of data, and respectively form internal data of the two types of data. a tree structure; an allocation module for assigning specific data to internal data of two types of data in which the upper and lower levels are defined; a saving module for a node of the tree structure to which the data is to be distributed and its parent node The information is saved in the tree table; and the connection module is used to use the leaf node of the departmental structure data tree structure as the parent node of the root node of the product data tree structure, and the two types of data are connected to form a complete node. Product information.

The basic data configuration method of the product comprises the following steps: dividing the product data into two categories: a departmental institution class and a product class; defining a subordinate relationship of the internal data of the two types of materials, respectively forming internal data of the two types of data into a tree Shape structure; assign specific data to the internal data of the two types of data defined by the superior and the subordinate relationship; save the node of the tree structure with the assigned data and the information of its parent node to the tree table; The leaf node of the data tree structure is used as the parent node of the root node of the product data tree structure. The two types of data are connected to form complete product information.

Compared with the prior art, the basic data configuration system and method of the product store the basic data of the product in the database in a tree structure, forming a unified, overall and dynamic product information, saving working time and improving Work efficiency.

1‧‧‧ computer

2‧‧‧Database

3‧‧‧ keyboard

4‧‧‧ Mouse

5‧‧‧ display

10‧‧‧Classification module

12‧‧‧Definition module

14‧‧‧Distribution module

16‧‧‧Save module

18‧‧‧Connecting module

S30‧‧‧ classify basic product information into two categories

S32‧‧‧ defines the relationship between the two types of internal data, forming a tree structure

S34‧‧‧Specify specific data for two types of internal data

S36‧‧‧Store the data-allocated nodes and their parent node information in the tree table

S38‧‧‧ Link two types of information to form complete product information

S40‧‧‧The complete product information number

S42‧‧‧The leaf number of the two types of data tree structures corresponding to the product number and the product number Points are correspondingly stored in the product information list

1 is a hardware architecture diagram of a preferred embodiment of a basic data configuration system for a product of the present invention.

2 is a functional block diagram of a computer of a preferred embodiment of the product basic data configuration system of the present invention.

Fig. 3 is a flow chart showing the operation of a preferred embodiment of the basic data configuration method of the product of the present invention.

4 is a schematic diagram showing the tree structure of the basic data configuration system of the product of the present invention.

This embodiment is described by taking the basic data configuration of the mold as an example.

As shown in FIG. 1, it is a hardware architecture diagram of a preferred embodiment of the basic data configuration system of the product of the present invention. The system includes a computer 1, a database 2 connected to the computer 1. The database 2 is used for storing basic information of a product, a product information list, and a tree table. The basic information of the product includes: a process of the product, a machine for producing the product, a cavity of the product, a model, a material number, and a material. The version number, color, product name, etc., the product information list and the tree table are all empty, and are used for storage in the basic data configuration process of the product. The computer 1 is also connected with a keyboard 3, a mouse 4 and a display 5 as input devices and output devices of the product basic data configuration system.

As shown in FIG. 2, it is a functional module diagram of the computer 1 of the preferred embodiment of the basic data configuration system of the present invention. The computer 1 includes a classification module 10, a definition module 12, a distribution module 14, a storage module 16, and a connection module 18.

The classification module 10 is used to classify product data into two categories: departmental institutions and product categories. The departmental organization category includes the departments, institutions, production lines, etc. that the processes for producing products need to go through, and the product categories include specific product information for production. Departmental institutions include: plant, process, machine, and cavity. Product categories include: model, item number, item number and so on.

The definition module 12 is used to define the relationship between the upper and lower levels of the internal data of the two categories, and respectively form the internal data of the two types into a tree structure. For example, as shown in Figure 4, the relationship between the departmental and institutional data can be defined from the top to the bottom: the factory-process-machine-cavity, the factory is the parent node of the process, and the process is the sub-knot of the plant. Point, the cavity is the leaf node of the tree structure, and the plant is the root node of the tree structure. Product category information from above The following can be defined as: model - material number - item number version, the model is the parent node of the item number, the item number is the parent node of the item number version, and the model is the root node of the product type data tree structure. .

The distribution module 14 is configured to allocate specific materials to the two types of internal materials of the defined superior relationship. For example, the factory that produces the mold includes: factory 1 and factory 2, and the distribution module 10 assigns the factory 1 and the factory 2 to the plant. The process for producing the mold includes: molding, assembly, baking, and the like, and the distribution module 10 distributes materials such as molding, assembly, baking, and the like to the process.

The save module 16 is used to save the node that has allocated the data and its parent node information to the tree table. For example, if plant 1 is the parent node of process 1, when the process 1 node is saved, the plant 1 is also saved to the information of process 1 in the tree table.

The connection module 18 is configured to connect the root node of the product data tree structure with the leaf node of the departmental organization data tree structure, and use the leaf node data of the departmental organization data tree structure as the product data. The parent node of the data of the root node of the tree structure, the connection module 18 connects the two types of data to form a complete product information. For example, the cavity is a leaf node of a departmental structure data tree structure, and the model is a root node of a product type data tree structure, and the connection module 18 connects the cavity with the model, if the specific type assigned to the model The data includes: model 1, model 2, etc., and the specific materials allocated to the cavity include: cavity 1, cavity 2, etc., the cavity used for the model 1 is the cavity 1, and the connection module 16 will be the cavity 1 As the parent node of model 1.

The distribution module 14 is further configured to assign a product number to the complete product information information that is connected.

The save module 16 is also used to number and department of each complete product information. The leaf nodes of the tree structure of the organization tree structure and the tree structure of the product class are correspondingly saved to the product information list, so that the user can find the product through the number in the product information list, and the department organization tree corresponding to the number through the number The leaf nodes of the structure leaf node and the product class tree structure find their respective root nodes to find the entire information of the product.

As shown in FIG. 3, it is a flowchart of the operation of the preferred embodiment of the basic data configuration method of the product of the present invention.

In step S30, the classification module 10 divides the product data into two categories: departmental institutions and product categories. The departmental organization category includes the departments, institutions, production lines, etc. that the processes for producing products need to go through, and the product categories include specific product information for production. Departmental institutions include: plant, process, machine, and cavity. Product categories include: model, item number, item number and so on.

In step S32, the definition module 12 defines the upper and lower levels of the internal data of the two categories, and respectively forms the internal data of the two types into a tree structure. For example, as shown in Figure 4, the relationship between departmental and institutional data can be defined from top to bottom: factory-process-machine-mould, the factory is the parent node of the process, and the process is the parent of the plant. Point, the cavity is the leaf node of the tree structure, and the plant is the root node of the tree structure. The relationship of product data can be defined from top to bottom: model - material number - material number version, the model is the parent node of the item number, the item number is the parent node of the item number version, and the model is the product category information. The root node of the tree structure.

In step S34, the distribution module 14 assigns specific materials to the two types of internal data of the defined upper and lower levels. For example, the factory that produces the mold includes: factory 1 and factory 2, and the distribution module 10 assigns the factory 1 and the factory 2 to the plant. The process for producing the mold includes: molding, assembly, baking, etc., and the distribution module 10 will be formed, assembled, and painted. The data is assigned to the process.

In step S36, the saving module 16 saves the node that has allocated the data and the information of its parent node to the tree table. For example, if plant 1 is the parent node of process 1, when the process 1 node is saved, the plant 1 is also saved to the information of process 1 in the tree table.

In step S38, the connection module 18 connects the root node of the product data tree structure with the leaf node of the department organization data tree structure, and uses the leaf node data of the department organization data tree structure as the product category. The parent node of the data of the root node of the data tree structure, the connection module 18 connects the two types of data to form a complete product information. For example, the cavity is a leaf node of a departmental structure data tree structure, and the model is a root node of a product type data tree structure, and the connection module 18 connects the cavity with the model, if the specific type assigned to the model The data includes: model 1, model 2, etc., and the specific materials allocated to the cavity include: cavity 1, cavity 2, etc., the cavity used for the model 1 is the cavity 1, then the connection module 16 will be the cavity 1 As the parent node of model 1.

In step S40, the distribution module 14 assigns a product number to the complete product information information that is connected.

In step S42, the saving module 16 saves the complete product information information number, the department organization tree structure leaf node, and the product tree structure leaf node correspondingly to the product information list, so as to facilitate the user to The number in the product information list finds the product, and the root node of the department organization tree structure leaf node and the product class tree structure corresponding to the number finds the root node to find the entire information of the product.

The above is only the preferred embodiment of the present invention, and has been used in a wide range of ways, and other equivalent changes or modifications have been made without departing from the spirit of the present invention. , should be included in the scope of the patent application below.

S30‧‧‧ classify basic product information into two categories

S32‧‧‧ defines the relationship between the two types of internal data, forming a tree structure

S34‧‧‧Specific information on the allocation of internal data for the two categories

S36‧‧‧Store the information of the assigned data and its parent node information in the tree table

S38‧‧‧ Link two types of information to form complete product information

S40‧‧‧The complete product information number

S42‧‧‧ stores the product number and the leaf nodes of the two types of data tree structures corresponding to the product number in the product information list correspondingly

Claims (5)

A product basic data configuration system includes a computer and a database connected to the computer, the data warehouse storing a tree table and basic information of the product, the computer comprising: a classification module, configured to divide the product data into two Class: departmental organization class and product class; definition module, which is used to define the upper and lower level relationship of the internal data of the two types of data, and respectively form the internal data of the two types of data into a tree structure; the distribution module is used for the Defining the internal data of the two types of data of the upper and lower levels of the specific data; the saving module is used to save the node of the tree structure and the information of the parent node of the allocated data to the tree table; and the connection module It is used to use the leaf node of the departmental organization data tree structure as the parent node of the root node of the product data tree structure. The two types of data are connected to form complete product information. The product basic data configuration system of claim 1, wherein the distribution module is further configured to allocate a product number to the product information. For example, the product basic data configuration system described in claim 2, the storage module is also used for the leaf node of the departmental organization tree structure of each complete product data, and the leaf node of the product type tree structure. The point and product number are saved in the product information list correspondingly. A product basic data configuration method is applied to a computer and a database connected to the computer, wherein the data warehouse stores a tree table and basic information of the product, and the method comprises the following steps: dividing the product data into two categories: a departmental institution Class and product categories; define the subordinate relationship of the internal data of the two types of data, respectively form the internal data of the two types of data into a tree structure; and assign specific data to the internal data of the two types of data defined by the superior and the lower level; Save the node of the tree structure and its parent node information of the assigned data to the tree table; and use the leaf node of the departmental organization data tree structure as the parent node of the root node of the product data tree structure Point, the two types of data are connected to form a complete product information. The method for configuring basic product data according to item 4 of the patent application scope, the method further comprising the steps of: assigning a product number to the product information information; and setting a leaf node of a tree structure of a departmental organization type of each complete product data, The leaf nodes and product numbers of the product tree structure are correspondingly saved to the product information list.