JP2018200598A - Component information management server - Google Patents

Abstract

To provide a component information management server including a component information database and capable of easily obtaining up-to-date component information while reducing a burden on a user of component information.SOLUTION: A component information management server including a component information database storing component information related to a component stores first component information containing image information and first attribute information of the component, second component information in which second attribute information of the component is added to the first component information, and a hash value calculated on the basis of the second component information in the component information database in association with each other. The server provides the second component information and/or the hash value according to reception of at least a part of the first component information.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a component information management server having a database for managing digital information of components.

  In recent years, information on various CAD parts such as 2D or 3D digital data used in design is made into a database, and a plurality of users use these parts information to select and design parts. It is done in For example, a system has been proposed in which information on building materials and the like used in construction work and civil engineering is made into a database and provided to users (see, for example, Patent Documents 1 and 2).

  For example, Patent Document 1 describes a building material information providing system including a database that stores information related to construction materials. In this building material information provision system database, in addition to information on construction materials such as construction material manufacturing date, type of work used, usage, etc., information such as the degree of damage, usage load, and period of use of construction materials is retained. The information is updated as the construction materials are used.

  Also in Patent Document 2, in addition to catalog information such as construction material ID, material name, material manufacturer, etc., a construction material test report is stored and information is shared between the contractors. A system has been proposed, and further, by storing hash values of these pieces of information, the originality of catalog information and test report of construction materials is also guaranteed.

JP 2002-083016 A JP 2007-207137 A

  Here, when performing construction design and architectural design, it is required to obtain the latest and accurate information regarding the distribution information such as parts distribution area and parts prices. In some cases, such distribution information that fluctuates from time to time may not be reflected in the parts database in a timely manner, and it is necessary for the designer to collect information by himself / herself. Further, there is no component database that can obtain the latest and accurate component information based on the component information obtained in the past even if the component has been used in the past.

  The present invention has been made in order to solve the above-described problems, and it is possible to reduce the burden on the user of the part information and to easily obtain the latest part information with guaranteed originality. An object of the present invention is to provide a component information management server including a component information database.

  In order to solve the above problems, a component information management server of the present invention is a component information management server including a component information database in which component information related to a component is recorded, and the component information database includes the component information database. First component information including shape information and first attribute information of the component; second component information obtained by adding second attribute information of the component to the first component information; and the second component information. The hash value calculated based on the component information is recorded in association with the second component information and / or the hash value in response to receiving at least a part of the first component information. I will provide a.

  The second attribute information may include distribution information of the component.

  The distribution information may include at least one of distribution area information of the part and price information of the part.

  The second part information may be part information of a substitute part of the part.

  The part information includes information indicating that the part is a scrap part when the part is a scrap part, and the part information of the scrap part is stored in the part information database. May be recorded in association with the part information.

  According to the present invention, there is provided a component information management server provided with a component information database that makes it possible to easily obtain the latest component information whose originality is guaranteed while reducing the burden on the user of the component information. It becomes possible to do.

FIG. 1 is a diagram showing an outline of a component information management system. FIG. 2 is a diagram illustrating a configuration example of an input terminal, an editing terminal, an inquiry terminal, and a part information management server in the part information management system. FIG. 3 is a diagram illustrating an example of component information in the component information database. FIG. 4 is a diagram illustrating an example of management of component information in the component information management server. FIG. 5 is a diagram for explaining part information addition and inquiry processing. FIG. 6 is a diagram for explaining the update / inquiry process of the component information. FIG. 7 is a diagram illustrating an example of a flowchart of component information addition, update, and inquiry processing in the component information management server.

  Hereinafter, embodiments for carrying out the present invention will be described.

<Outline of parts information management system>
FIG. 1 is a diagram showing an outline of a component information management system.

  The component information management system includes an input terminal 10 for inputting first component information, which is original component information, to the component information management server 20, a component information management server 20 for managing component information, an attribute added to the component information, or An editing terminal 30 for updating the part information and an inquiry terminal 40 for inquiring the part information are configured. The parts information management system in the present embodiment is applied to a database of 2D and 3D digital data of parts used for design of construction work and civil engineering work, but is not limited to them, and digital data of parts is stored in a plurality of parts. It can be applied to any database shared by users.

  The input terminal 10 creates or acquires original first part information data including part shape information and attribute information, and transmits the data to the part information management server 20 for registration. The component information management server calculates a first hash value based on the received first component information, and records the first component information and the calculated first hash value in association with each other. This first hash value can be used as information for proving authenticity and originality of the first component information.

  The editing terminal 30 creates second part information by adding an attribute to the original part information registered in the part information management server 20, and transmits the created second part information to the part information management server 20. ,sign up. The second part information is obtained by adding parts distribution information to the first part information which is original part information. Distribution information added includes, but is not limited to, information on parts distribution areas and parts price information, and includes information on all parts that can fluctuate when parts are distributed in the market. .

  The component information management server 20 calculates the second hash value based on the received second component information, and calculates the original first component information and the second component information to which the attribute is added and the calculated second component information. Record the hash value associated with. This second hash value can be used as information for proving authenticity and originality of the second component information. Providing second component information based on shape information and attribute information included in the first component information by associating and storing the original first component information and the second component information to which the attribute is added. The authenticity and originality of the second component information can be confirmed by the second hash value.

  The editing terminal 30 updates the second part information registered in the part information management server 20 to create third part information, and transmits the created third part information to the part information management server 20. Can register. The third part information is, for example, part information of a part that can be used as a substitute part because the part related to the second part information becomes a discontinued number.

  The component information management server calculates a third hash value based on the received third component information, and associates the original first component information and the third component information with the calculated third hash value. Record. By associating and storing the original first component information and the updated third component information, it is possible to provide the third component information based on the shape information and attribute information included in the first component information. It becomes.

  Further, the second part information that has become the scrap number may be recorded as scrap part information. Accordingly, it is possible to provide the second part information of the abandoned number based on the original first part information.

  The inquiry terminal 40 inquires and verifies the component information registered in the component information management server 20. The inquiry terminal 40 obtains the second component information and the third component information by transmitting the shape information and attribute information included in the first component information, which is the original component information, to the component information management server 20. . By adding distribution information or the like to the attribute information of the component information registered in the component information management server 20 by the editing terminal 30 or updating it to the component information of the alternative component, the inquiry terminal 40 can obtain the original shape information. The latest part information can be obtained based on the attribute information.

  Further, the inquiry terminal 40 can confirm the authenticity and originality of the component information by using a hash value stored in association with the component information. For example, the authenticity and originality of the component information are confirmed by calculating the hash value by itself based on the acquired component information and comparing the calculated hash value with the hash value registered in the component information management server 20 can do. Furthermore, component information can also be obtained using this hash value.

<Configuration of parts information management system>
FIG. 2 is a diagram illustrating a configuration example of an input terminal, an editing terminal, an inquiry terminal, and a part information management server in the part information management system.

  The input terminal 10 includes an input unit 12 for inputting various information, a display unit 13 for displaying various information, an I / F unit 14 for communicating with the component information management server 20, and a central processing unit 11 for controlling each unit. And a storage unit 15 for storing various information. The central processing unit 11 executes processing for creating or acquiring original first part information data including part shape information and attribute information and transmitting the data to the part information management server 20.

  The editing terminal 30 includes an input unit 32 for inputting various information, a display unit 33 for displaying various information, an I / F unit 34 for communicating with the component information management server 20, and a central processing unit 31 for controlling each unit. And a storage unit 35 for storing various information. The central processing unit 31 creates the second part information by adding an attribute to the first part information, creates the third part information in which the second part information is updated, A process of transmitting the third component information to the component information management server 20 is executed.

  The inquiry terminal 40 includes an input unit 42 for inputting various types of information, a display unit 43 for displaying various types of information, an I / F unit 44 for communicating with the component information management server 20, and a central processing unit 41 for controlling each unit. And a storage unit 45 for storing various information. The central processing unit 41 executes processing for verifying component information registered in the component information management server 20, and processing for confirming authenticity and originality of component information using a hash value.

  The component information management server 20 includes a central processing unit 21 that manages component information and the like, an input terminal 10, an editing terminal 30, an I / F unit 25 that communicates with the inquiry terminal 40 via the network 50, and components A parts information database 26 for storing information and the like is provided.

  The central processing unit 21 operates as a component information management unit 22 that manages component information, a hash information management unit 23 that manages hash information, and a discarded component information management unit 24 that manages discarded component information. The component information database 26 stores component information, hash information, scrapped component information, a database table for associating component information and hash information, and authentication information (ID, password) for authenticating each terminal.

  In the component information management unit 22, the first to third component information is associated with the hash value calculated based on the first to third component information, and the associated information is recorded in the component information database 26. Is executed. The hash information management unit 23 calculates the first to third hash values based on the first to third component information, and the abandoned component information management unit 24 converts the discarded component information to the component information. Processing to be recorded in the database 26 is executed. This scrap part information management unit may store past information of the updated part information.

<Part information, database table>
FIG. 3 is a diagram illustrating an example of component information in the component information database. The component information database of the component information management server is updated with original component information (first component information), component information with attributes added to the original component information (second component information), and replacement components. Component information (third component information) and hash values (first to third hash values) of the respective component information are stored in association with each other.

  The original part information includes part shape information, and attribute information including information such as code information, part name, model number, manufacturer, date of manufacture, and the like. Note that the content of the attribute information is an example, and is not limited to the illustrated one. In some cases, attribute information is not added and only shape information is provided.

  In the second component information, distribution information such as the distribution region and price of the component is added to the original component information. This added distribution information is not limited to the information such as the distribution region and price of the exemplified parts, but includes information on all parts that can fluctuate when the parts are distributed in the market. In addition, for information with high frequency of fluctuation, such as price information, a method may be adopted in which a specific price code is attached to each part and a separate database is referred to. The third part information is, for example, part information of a part that can be used as a substitute part because the part related to the second part information becomes a discontinued number. In this case, information indicating that the number is abolished is added to the second component information.

  In the component information database, a database table for associating each component information is also recorded. In the database table, unique code information (# 1 to # 3) that can identify each component information is recorded in association with each other, and the latest component information is provided using the information in this database table. Can do. In this database table, hash values and attribute information based on the latest component information may be stored in association with each other.

  For example, when the code information # 1 of the original part information is received, the database table is searched for the code information # 2 or the code information # 3 corresponding to the received code information # 1 and found. Component information corresponding to code information # 2 or code information # 3 is provided. Here, the information received to provide the component information is not limited to the code information, but by receiving the part name information, model number information, etc., which are part of the shape information and attribute information included in the component information. The latest corresponding part information may be provided. In addition, by receiving the hash value, it is possible to provide component information corresponding to the hash value.

<Management of parts information>
FIG. 4 is a diagram illustrating an example of management of component information in the component information management server. In the example of FIG. 4, original part information corresponding to parts A-A, A-b, and A-c, which are parts of company A, is registered on the site of company A. A-(# 1), A- -B (# 1) and Ac (# 1) are unique code information for specifying each piece of component information. If the code number of the A company site is not guaranteed to be unique in the parts information management server, it is necessary to transfer codes and prepare a comparison table. Attribute information such as distribution information is not added to the component information corresponding to Aa (# 1), Ab (# 1), and Ac (# 1).

  In the component information database 26, hash (# 1), which is hash information associated with the component information of Aa (# 1), is added with attribute information in association with the component information of Ab (# 1). The component information of the A-b (# 2) and the hash information (hash (# 2)) are updated in association with the component information of the Ac (# 1). In addition, hash (# 3) which is hash information is recorded.

  Since the inquiry terminal can obtain the code information Ab (# 1) and the part information of the desired part from the site of the company A, the code information Ab (# 1) is transmitted to the part information management server. By transmitting, the latest part information of Ab (# 2) to which attribute information is added can be obtained. Further, hash (# 2), which is a hash value of the part information of Ab (# 2), can be obtained as necessary, and the authenticity and originality of the part information can be confirmed. Similarly, by transmitting the code information Ac (# 1) to the component information management server, the updated component information of Ac (# 3) and hash (# 3) that is the hash value thereof are obtained. You can also.

  In the example of FIG. 4, the example in which the part information of Ab (# 2) to which the attribute information is added is obtained by inputting the original code information Ab (# 1). If the association of the code information is stored in the database table, the original part information Ab (# 1) or A- using the code information Ab (# 2) or Ac (# 3). It is also possible to obtain part information of c (# 1). Also, the latest corresponding component information can be obtained based on the hash value, the shape information included in the component information, and the attribute information. Part name information, model number information, and the like, which are part of frequently used attribute information, may be stored in a database.

  Furthermore, in the part information database 26, the part information of Ac (# 2) is updated to the part information of Ac (# 3), so the part information of Ac (# 2) is discarded. It is recorded in the scrap number table as part number information. By searching this waste number table, the part information of Ac (# 2), which is a waste number, can be obtained from the code information Ac (# 1). According to this waste number table, it is possible to obtain information that Ac (# 2) is a waste number without searching for attribute information in the part information.

<Addition processing of parts information>
FIG. 5 is a diagram for explaining part information addition and inquiry processing.

  The person who inputs the component information logs in to the component information management server from the input terminal in order to input the component information. When the authentication result is OK, the input terminal transmits the first component information that is the original component information. The component information management server calculates a first hash value based on the first component information, and records it in association with the first component information.

  Next, the component information editor logs in to the component information management server from the editing terminal in order to add attribute information to the component information. If the authentication result is OK, the editing terminal transmits the code information included in the original first part information to the parts information management server, and thereby the original first registered in the part information management server. The component information is obtained, attribute information is added to the first component information to create second component information, and the created second component information is transmitted to the component information management server. The component information management server calculates a second hash value based on the received second component information or the like, and records it in association with the received second component information.

  The part information inquirer logs in to the part information management server from the inquiry terminal in order to inquire the part information. When the authentication result is OK, the inquiry terminal transmits the code information included in the original first component information to the component information management server, so that the second component information that is the latest information at this time is obtained. Can be obtained.

<Part information update processing>
FIG. 6 is a diagram for explaining the update / inquiry process of the component information.

  The part information updater logs in to the part information management server from the editing terminal in order to update the part information. If the authentication result is OK, the editing terminal transmits the code information included in the original first component information to the component information management server, thereby registering the second component information registered in the component information management server. Is obtained, third part information that is update information of the second part information is created, and the created third part information is transmitted to the part information management server. The component information management server calculates a third hash value based on the received third component information and the like, records the third hash value in association with the received third component information, and stores the second component information as abandoned component information. Record as.

  The part information inquirer logs in to the part information management server from the inquiry terminal in order to inquire the part information. If the authentication result is OK, the inquiry terminal transmits the code information included in the first component information, which is the original information, to the component information management server. Can be obtained.

  FIG. 7 is a diagram illustrating an example of a flowchart of component information addition, update, and inquiry processing in the component information management server. In this figure, the authentication process at each terminal is omitted.

  When receiving the first component information from the input terminal (S1-1), the component information management server calculates a first hash value based on the first component information (S1-2), The calculated first hash value is stored in association (S1-3). When the code information of the component information is received from the editing terminal (S1-4), the corresponding first component information is transmitted (S1-5), and when the second component information is received (S1- 6) A hash value is calculated based on the received second component information (S1-7), and the first and second component information and the calculated second hash value are stored in association with each other (S1-8).

  When the code information of the component information is received from the editing terminal (S1-9), the corresponding second component information is transmitted (S1-10), and when the third component information is received (S1- 11) A third hash value is calculated based on the received third component information (S1-12), and the first and third component information and the calculated third hash value are stored in association with each other (S1- 13) The second part information is set as a scrap number (S1-14).

  When receiving the code information of the first component information from the inquiry terminal (S1-15), the component information management server transmits the third component information which is the latest information at this time (S1-16).

  As described above, according to the present embodiment, the component information database is constructed by associating the original component information with the component information to which the attribute information is added or the updated component information and the hash value. It is possible to easily obtain the latest reliable component information while reducing the burden.

  The present invention can be used in a component information management database that shares and uses digital information of components.

  DESCRIPTION OF SYMBOLS 10 ... Input terminal, 11 ... Central processing part, 12 ... Input part, 13 ... Display part, 14 ... I / F part, 15 ... Memory | storage part, 20 ... Component information management server, 21 ... Central processing part, 22 ... Component information , 23 ... Hash information management part, 24 ... Disused part information management part, 25 ... I / F part, 26 ..., part information database, 30 ... editing terminal, 31 ... central processing part, 32 ... input part, 33 ... Display unit 34 ... I / F unit 35 ... Storage unit 40 ... Inquiry terminal 41 ... Central processing unit 42 ... Input unit 43 ... Display unit 44 ... I / F unit 45 ... Storage unit 50 ... network.

Claims (5)

A component information management server having a component information database in which component information related to components is recorded,
The component information database includes first component information including shape information of the component, first attribute information of the component, and second attribute information of the component added to the first component information. 2 component information and a hash value calculated based on the second component information are recorded in association with each other,
Providing the second component information and / or the hash value in response to receiving at least a portion of the first component information;
Component information management server. The second attribute information includes distribution information of the component;
The component information management server according to claim 1. The distribution information includes at least one of distribution region information of the component and price information of the component;
The component information management server according to claim 2. The second part information is part information of a substitute part of the part;
The component information management server according to any one of claims 1 to 3. The part information includes information indicating that the part is a scrap part when the part is a scrap part, and the part information of the scrap part is stored in the part information database. Recorded in association with the parts information of
The component information management server according to claim 4.

Images