Database construction device, database production method, and program
The database construction device addresses inefficiencies in logistics communication by automating the extraction and storage of business identifiers and record configuration information from multiple formats, enhancing database management efficiency.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- HERBIT CO LTD
- Filing Date
- 2026-01-22
- Publication Date
- 2026-07-30
AI Technical Summary
Existing logistics communication systems require manual information processing and fail to effectively utilize communication information between parties involved in transportation, leading to inefficiencies in database management.
A database construction device that receives and processes communication information from multiple formats, using natural language processing and AI to automatically extract and store business identifiers and record configuration information, enabling seamless integration of communication data into a business database.
Automates the addition of operational information to a database, facilitating efficient management of logistics data by accurately extracting and storing relevant information from diverse communication formats.
Smart Images

Figure 0007897676000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a database construction device and the like for constructing a database for managing business information in logistics such as international logistics.
Background Art
[0002] Conventionally, for goods transported between domestic and foreign countries by a plurality of transportation means including ships, information such as the transportation progress status of individual goods including mixed goods and the arrival schedule at each location has been detailed and real-time, and has been made public and notified to shippers, agents who arrange exports, etc. There has been a tracking system for goods transported in a combined manner (see, for example, Patent Document 1).
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, in the prior art, communication information between a requester who requests the transportation of goods in logistics such as international logistics and a trustee who accepts the request for the transportation (among the parties involved in the transportation of the goods) is exchanged in various forms such as e-mail and chat. Therefore, it has been necessary to manually perform information processing operations such as confirmation of the communication information and registration in the database, which has been cumbersome.
[0005] Also, in the prior art, communication information between parties involved in logistics could not be appropriately utilized.
Means for Solving the Problems
[0007] This configuration allows for easy addition of operational information to the database using communication information among those involved in the transportation of goods in logistics.
[0008] Furthermore, the database construction device of this second invention differs from the first invention in that the communication receiving unit receives communication information in two or more formats, and the acquisition unit acquires business identifiers and record configuration information from the communication information in different ways depending on the format.
[0009] This configuration allows for easy addition of business-related information to the database using two or more different forms of communication.
[0010] Furthermore, the database construction device of this third invention, compared to the second invention, is a database construction device in which the acquisition unit comprises a determination means for determining the format of communication information, and an acquisition means for acquiring a business identifier and record configuration information from the communication information in different ways according to the determined format.
[0011] This configuration allows for easy addition of business-related information to the database using two or more different forms of communication.
[0012] Furthermore, the database construction device of this fourth invention is a database construction device in which, with respect to any one of the first to third inventions, the acquisition unit acquires business identifiers and record configuration information from communication information using natural language processing.
[0013] This configuration allows for the acquisition of business identifiers and record configuration information from communication information.
[0014] Furthermore, the database construction device of this fifth invention is a database construction device in which, with respect to any one of the first to third inventions, the acquisition unit provides an information acquisition prompt that instructs the acquisition of a business identifier and record configuration information from communication information to a generating AI, and acquires the business identifier and record configuration information from the generating AI.
[0015] This configuration allows for the acquisition of business identifiers and record configuration information from communication information.
[0016] Furthermore, the database construction device of the sixth invention further comprises, with respect to any one of the first to fifth inventions, an identifier acquisition unit that acquires an identifier of an individual associated with communication information, and a rule acquisition unit that acquires rule information corresponding to the individual identifier acquired by the identifier acquisition unit from a rule management unit which stores one or more rule information for acquiring a business identifier, and the acquisition unit is a database construction device that acquires a business identifier from communication information using the rule information acquired by the rule acquisition unit.
[0017] This configuration allows for the accurate acquisition of business identifiers based on rules set for each participant.
[0018] In addition, the database construction device of the seventh invention, with respect to the sixth invention, the acquisition unit is a database construction device that gives the generation AI the identifier acquisition prompt for instructing to acquire the business identifier based on the rule information from the communication information, the communication information, and the rule information, and acquires the business identifier based on the rule information from the generation AI.
[0019] With such a configuration, an appropriate business identifier based on the rules set for each participant can be acquired.
[0020] In addition, the database construction device of the eighth invention, with respect to any one of the first to seventh inventions, the acquisition unit is a database construction device that acquires one or more business identifiers for communication information including two or more types of business identifiers.
[0021] With such a configuration, after acquiring the optimal business identifier from two or more types of business identifiers, the record configuration information can be accurately stored in the record.
[0022] In addition, the database construction device of the ninth invention, with respect to any one of the first to eighth inventions, the acquisition unit acquires the meta information of the communication information, and the storage unit is a database construction device that stores the meta information in the business database in association with the record identified by the business identifier.
[0023] With such a configuration, the meta information of the communication information can be stored in the database in association with the business identifier.
Advantages of the Invention
[0024] According to the database construction device of the present invention, information related to the business can be automatically stored in the database by using the communication information among the participants involved in the transportation of goods in the logistics.
Brief Description of the Drawings
[0025] [Figure 1] Conceptual diagram of information system A in Embodiment 1 [Figure 2] Block diagram of the sympathy information system A [Figure 3] Flowchart showing an operation example of the database construction device 1 [Figure 4] Flowchart showing an operation example of the database construction device 1 [Figure 5] Diagram showing an example of the same business information management table [Figure 6] Diagram showing an example of the same prompt management table [Figure 7] Diagram showing an example of the same rule information management table [Figure 8] Diagram showing an example of an email received by the database construction device 1 [Figure 9A] Diagram showing an example of the same business information management table [Figure 9B] Diagram showing an example of the same business information management table [Figure 10] Diagram showing an example of a chat received by the database construction device 1 [Figure 11A] Diagram showing an example of the same business information management table [Figure 11B] Diagram showing an example of the same business information management table [Figure 12] Block diagram of the same computer system
Mode for Carrying Out the Invention
[0026] Hereinafter, embodiments of a database construction device and the like will be described with reference to the drawings. In the embodiments, components denoted by the same reference numerals perform the same operations, and thus the description may be omitted again.
[0027] (Embodiment 1) In the present embodiment, communication information between two or more participants related to the transportation of goods in logistics such as international logistics is acquired, and from the communication information, a business identifier for specifying business information and record configuration information are acquired, and the record configuration information is added to the record identified by the business identifier in a database construction device will be described.
[0028] "Parties involved" refers to the client who requests the transportation of goods, the contractor who accepts the request for said transportation, and any other persons involved in said transportation besides the client and contractor.
[0029] The client is usually the shipper who requests the transportation of goods, but it can also be a freight forwarder who acts as an intermediary for the transportation of goods at the request of the shipper.
[0030] A consignee is usually a company that transports goods, but a freight forwarder is also acceptable. A company that transports goods is usually a shipping company, but an airline is also acceptable.
[0031] Other parties involved in the transportation besides the client and the contractor include, for example, the importer of the goods if the client is the exporter of the goods, the exporter of the goods if the client is the importer of the goods, customs brokers, warehouse operators managing the goods, shipping companies, airlines, freight forwarders, and trucking companies that have not been directly commissioned by the client to transport the goods.
[0032] Communication information refers to information relating to communication between parties involved in logistics. Communication information is information for communication between parties involved in logistics. It can be said that communication information is information generated through communication between parties involved in logistics. Communication information includes, for example, information that includes business information. Communication information includes, for example, information that includes metadata, which will be described later. Communication information includes, for example, email (hereinafter referred to as "email" as appropriate), chat, telephone voice, and audio and image information in web conferences.
[0033] Communication information includes, for example, user-input information or user-received information. User-input information is information entered by those involved in logistics. This includes, for example, emails sent by logistics personnel, information entered in chats by logistics personnel, or information spoken over the phone. User-received information includes, for example, emails received by logistics personnel, chats received by logistics personnel, or information received over the phone.
[0034] Communication information is information that consists of at least one or more forms, such as text information, audio information, and image information. Text information is, for example, text information contained in emails and text information contained in chats. Audio information is, for example, audio information showing conversations between logistics stakeholders and recordings of phone calls from logistics stakeholders. Image information is, for example, photographs of packages and videos of meetings between logistics stakeholders.
[0035] Business information refers to information relating to cargo transportation operations in logistics, such as international logistics, and includes business identifiers and record configuration information. Business information includes, for example, one or more of the following: participant identifiers, information identifying the moving object, information specifying the status of the moving object, information identifying the origin, information identifying the destination, information identifying the loading port, information identifying the unloading port, information specifying the date and time of departure from the origin or loading port, information specifying the date and time of arrival at the destination or unloading port, information specifying the container type and size, information specifying the weight of the cargo, information specifying the cargo transportation costs, and information specifying the cargo transportation conditions.
[0036] A business identifier is information that identifies business information. Typically, a business identifier identifies a single piece of business information. Examples of business identifiers include booking numbers, bill of lading numbers, container numbers, product IDs, invoice numbers, purchase order numbers, or combinations of these numbers or IDs. However, business identifiers are not limited to these numbers or IDs.
[0037] A booking number is a reservation number assigned when a client requests the transportation of goods. A B / L (Bill of Lading) number is the number of a security issued by the consignee to the client. A container number is the number of the container used to transport the goods requested by the client.
[0038] Record configuration information refers to the information that constitutes a record in a business database that stores business information. Record configuration information is associated with a business identifier. Record configuration information may be part or all of the business information. Examples of record configuration information include: participant identifier, client identifier, contractor identifier, information identifying the moving object, information specifying the status of the moving object, information identifying the departure point, information identifying the destination, information identifying the loading port, information identifying the unloading port, information specifying the date and time of departure from the departure point or loading port, information specifying the date and time of arrival at the destination or unloading port, information specifying the container type and size, information specifying the weight of the cargo, information specifying the cost of transporting the cargo, and information specifying the transport conditions of the cargo.
[0039] A mobile object is usually a ship that moves on the sea, but it can also be an aircraft that moves through the air. An aircraft is usually an airplane, but it can also be a helicopter, etc. A mobile object is, for example, a ship used for logistics such as international logistics, or an aircraft used for logistics such as international logistics.
[0040] Furthermore, in this embodiment, a database construction device that acquires two or more types of communication information will be described.
[0041] Furthermore, in this embodiment, a database construction device for determining the format of communication information will be described.
[0042] Furthermore, in this embodiment, a database construction device that acquires business identifiers and record configuration information using natural language processing will be described.
[0043] Furthermore, in this embodiment, a database construction device that acquires business identifiers and record configuration information using a generating AI will be described.
[0044] Furthermore, in this embodiment, an participant identifier associated with communication information is obtained, rule information corresponding to the participant identifier is obtained, and a business identifier is obtained using the rule information.
[0045] An participant identifier is information that identifies the parties involved in logistics. Typically, a participant identifier identifies the client who requests the transportation of goods and the contractor who accepts the transportation request, but it may also be information that identifies parties other than the client and contractor who are involved in the transportation.
[0046] Information that identifies the client may include, for example, the client's name or client's ID. The client's name may include, for example, the company name, the company name and department name, or the individual's name.
[0047] Information identifying the contractor may include, for example, the contractor's name or the contractor's ID. The contractor's name may include, for example, the company name, the company name and department name, or the individual's name.
[0048] Information that identifies parties other than the client and contractor involved in the transportation may include, for example, the names of those involved in the transportation or their IDs. The names of those involved in the transportation may include, for example, company names, company names and department names, or individual names.
[0049] Rule information refers to information that indicates the rules for obtaining business identifiers. Rule information is information that corresponds to participant identifiers. Rule information may also include information that indicates the rules for obtaining record structure information. Rule information is written, for example, using regular expressions. There are no particular restrictions on how the rule information is written.
[0050] Rule information is, for example, information that shows the rules for the Booking number set by a given contractor. Rule information is, for example, information that shows the rules for the Booking number, which is a business identifier, such as "Contractor A's Booking number consists of 5 letters and 7 numbers." Rule information is, for example, information that shows the rules for the B / L number, which is a business identifier, such as "Contractor B's B / L number consists of "ONEY" + "Booking number." Rule information is, for example, information that shows the rules for record structure information, such as "Client C sets a Job No. for each business separately from the business identifier."
[0051] Rule information is, for example, information that formalizes the correspondence between tags included in emails and attribute names in the business information management table described later. Rule information is, for example, information that indicates the rule to include strings that match the attribute names in the business information management table within the tags in emails.
[0052] Furthermore, in this embodiment, we will describe a database construction device that uses a generating AI to acquire business identifiers based on rule information set for each participant.
[0053] Furthermore, in this embodiment, a database construction device that acquires one or more business identifiers from two or more types of business identifiers will be described.
[0054] Furthermore, in this embodiment, a database construction device that acquires metadata of communication information and stores it in association with records will be described.
[0055] Metadata refers to information related to communication information. Metadata is information that can be used, for example, to search for and classify communication information. Metadata includes information that identifies the sender of an email, information that identifies the date an email was received, and information about attachments attached to an email. Metadata may be the same as the communication information. Information about attachments may include, for example, the creation date, size, type of file, or creator.
[0056] In this specification, information X being associated with information Y means that information Y can be obtained from information X, or information X can be obtained from information Y, and the method of association is irrelevant. Information X and information Y may be linked, may reside in the same buffer, may information X be contained in information Y, or information Y may be contained in information X, and so on.
[0057] Furthermore, in this specification, selecting or determining information Z means obtaining information Z, obtaining a pointer to information Z, obtaining the ID of information Z, setting a flag on information Z, etc., and it is sufficient to be able to access information Z.
[0058] Figure 1 is a conceptual diagram of information system A in this embodiment. Information system A comprises a database construction device 1, one or more information servers 2, one or more terminal devices 3, and one or more generation AI devices 4.
[0059] Database Construction Device 1 is a device that constructs a database for managing business information in logistics. Database Construction Device 1 can be, for example, a cloud server or an ASP server, but the type is not specified. Database Construction Device 1 can also be a terminal. If Database Construction Device 1 is a terminal, it can be, for example, a personal computer, a smartphone, or a tablet device, but the type is not specified. Database Construction Device 1 may also have a database for managing business information. The database for managing business information may reside on a device other than Database Construction Device 1.
[0060] Information Server 2 is a server that stores one or more pieces of communication information. For example, Information Server 2 could be a mail server, a chat server, or a web conferencing server. A mail server manages email information, such as Outlook® or Gmail®. A chat server manages chat information, such as LINE®, Slack, or Microsoft Teams®. A web conferencing server manages web conferencing information, such as Zoom® or Teams. Note that communication information may also be stored in Database Construction Device 1. In this case, Information Server 2 is not necessary in Information System A.
[0061] Terminal device 3 is a terminal used by the user. The user is typically a person involved in logistics. Terminal device 3 can be, for example, a personal computer, smartphone, or tablet, but the type is not limited.
[0062] The generation AI device 4 is a device that has the functionality of a generation AI. The generation AI device 4 has, for example, the functionality of a text generation AI. The generation AI device 4 may also have the functionality to generate still images, videos, or audio information. The generation AI may be, for example, ChatGPT (registered trademark) or Gemini, but is not limited to that. The generation AI device 4 may be, for example, a cloud server, an ASP server, or a server that implements SaaS, but is not limited to that type. The generation AI device 4 will be referred to as the generation AI as appropriate. Furthermore, the database construction device 1 may also have the functionality of a generation AI. In such a case, the generation AI device 4 is not necessary in information system A.
[0063] The database construction device 1 and one or more information servers 2, the database construction device 1 and one or more terminal devices 3, and the database construction device 1 and one or more generation AI devices 4 are normally able to communicate with each other via a network such as the Internet.
[0064] Figure 2 is a block diagram of the database construction device 1 in this embodiment.
[0065] The database construction device 1 comprises a storage unit 11, a reception unit 12, a processing unit 13, and an output unit 14. The storage unit 11 comprises a business management unit 111, a prompt management unit 112, and a rule management unit 113. The reception unit 12 comprises a communication reception unit 121. The processing unit 13 comprises an acquisition unit 131, a storage unit 132, an identifier acquisition unit 133, and a rule acquisition unit 134. The acquisition unit 131 includes a discrimination means 1311 and an acquisition means 1312.
[0066] The storage unit 11, which constitutes the database construction device 1, stores various types of information. These types of information include, for example, business information, rule information, information acquisition prompts (described later), and identifier acquisition prompts.
[0067] The business management department 111 stores the business database.
[0068] A business database is a database that manages one or more business information items. For example, a business database stores record configuration information in records identified by business identifiers. For example, a business database stores metadata of communication information associated with records identified by business identifiers. For example, a business database stores a business information management table as shown in Figure 5. A business database can also be a business information management table. A business information management table can be, for example, a relational database, but it can also be an object-oriented database, a network database, or a CSV file, etc., and its structure is not specified. Here, a database can simply be considered as a collection of records (information).
[0069] A business information management table is a table used to manage business information. The business information management table manages one or more records, for example, each having attribute names such as "ID," "Business Information ID," "Business Identifier," "Participant Identifier," "Departure Point," and "Destination." "ID" is information that identifies the record. "Business Information ID" is information that identifies the business information. "Business Identifier" is, for example, a Booking number, B / L number, container number, product ID, invoice number, PO number, or a combination of these numbers or IDs. "Participant Identifier" is information that identifies the participants in the logistics, such as information that identifies the shipper, freight forwarder, shipping company or airline, importer, exporter, customs broker, warehouse operator, or trucking company. "Departure Point" is information that identifies the departure point of the cargo. "Destination" is information that identifies the destination of the cargo. When managing business information for cargo transport by ship, the business information management table may also include information that identifies the loading port and the unloading port.
[0070] The prompt management unit 112 stores one or more prompts. Prompts include, for example, information acquisition prompts, identifier acquisition prompts, and metadata acquisition prompts. A prompt is an instruction given to the generating AI. Information acquisition prompts and identifier acquisition prompts are not limited to strings, but may also be prompts consisting of images, videos, audio, etc.
[0071] An information retrieval prompt is a prompt used to instruct the generating AI to retrieve business identifiers and record configuration information from communication information. An example of an information retrieval prompt might be: "You are the manager of logistics and trade operations. Analyze the following communication information and present the business identifier and record configuration information. Note that the record configuration information is information related to transportation operations. The record configuration information may be information from a portion of the records that make up the business information management table."
[0072] An identifier retrieval prompt is a prompt used to instruct the generating AI to retrieve a business identifier based on rule information from communication information. An identifier retrieval prompt might look like this: "You are the manager of logistics and trade operations. Analyze the following communication and rule information and present the business identifier."
[0073] A metadata acquisition prompt is a prompt used to instruct the generating AI to acquire metadata from communication information. An example of a metadata acquisition prompt might be: "You are the manager of logistics and trade operations. Please analyze the following communication information and present the metadata. Metadata is information that can be used to search and classify communication information. Metadata includes, for example, information that identifies the sender of an email, information that identifies the date an email was received, and information about attachments attached to an email."
[0074] The rule management unit 113 stores one or more rule information. For example, the rule management unit 113 stores a rule information management table.
[0075] A rule information management table is a table used to manage rule information. For example, a rule information management table manages one or more records that have attribute names such as "ID," "Rule Information ID," "Rule Target," "Participant Identifier," "Rule," and "Specific Example." "ID" is information that identifies the record. "Rule Information ID" is information that identifies the rule information. "Rule Target" is information that identifies the target for which the rule is set. "Participant Identifier" is information that identifies the participants in logistics. "Specific Example" is information that shows a specific example that follows the rule.
[0076] The rule management unit 113 stores a tag correspondence table that formalizes the correspondence between tags included in emails, which are communication information, and attribute names in the business information management table. The tag correspondence table manages one or more records that have, for example, an "ID," a "rule information ID," a "tag," and an "attribute name." The "ID" is information that identifies the record. The "rule information ID" is information that identifies the rule information. The "tag" is information that identifies the tag included in the email and the string included within the tag. The "attribute name" is information that identifies the attribute name in the business information management table.
[0077] The reception unit 12 receives various instructions and information. For example, the reception unit 12 receives various instructions and information from the information server 2, terminal device 3, or generating AI. These instructions and information include communication information and responses from the generating AI.
[0078] Here, "reception" typically refers to receiving information from the information server 2, terminal device 3, or generating AI, but it may also be a concept that includes receiving information input from input devices such as keyboards, mice, and touch panels, as well as receiving information read from recording media such as optical discs, magnetic discs, and semiconductor memory.
[0079] The communication reception unit 121 receives communication information. The communication reception unit 121 receives communication information from, for example, one or more information servers 2. The communication reception unit 121 acquires communication information from one or more information servers 2, for example, by API or crawling. Note that the means for acquiring communication information are not limited to API and crawling. The communication reception unit 121 receives communication information in two or more formats, for example. The communication reception unit 121 receives communication information in at least one or more formats, for example, string information, audio information, and image information. Format can also be called data type. Communication information in two or more formats may include, for example, email, chat information, and audio and image information from web conferences.
[0080] The processing unit 13 performs various processes. These various processes include, for example, the processes performed by the acquisition unit 131, the storage unit 132, the identifier acquisition unit 133, the rule acquisition unit 134, the discrimination means 1311, or the acquisition means 1312.
[0081] The acquisition unit 131 acquires a business identifier and record configuration information from each of the one or more communication information received by the communication reception unit 121. The acquisition unit 131 acquires the business identifier and record configuration information from the communication information by, for example, the following natural language processing or generation AI processing.
[0082] The acquisition unit 131 acquires the business identifier and record configuration information from the communication information in different ways, depending on the format of the communication information. Different methods include, for example, methods using natural language processing and methods using generative AI. Different methods include, for example, methods using different rules within the natural language processing method, and different methods including methods using different prompts within the generative AI method.
[0083] The format of communication information can be, for example, text, images, or audio information. The format of communication information can be, for example, email, chat, or audio information from web conferences. The format of communication information can be, for example, a file type (e.g., Word file, Excel file, PDF, CSV, PNG, GIF, JPEG).
[0084] The discrimination means 1311 determines the format of the communication information. The discrimination means 1311 determines the format of the communication information based, for example, on the data format (file extension) of the communication information. The discrimination means 1311 determines the format of the communication information based, for example, on the data structure of the communication information. The discrimination means 1311 obtains, for example, the format corresponding to the original information server 2 from which the communication information was acquired. Determining the format and obtaining the format means, for example, obtaining a format identifier that identifies the format. The discrimination means 1311 determines, for example, whether the communication information is string information, audio information, or image information.
[0085] Next, the acquisition means 1312 acquires the business identifier and record configuration information from the communication information in different ways, depending on the format of the communication information determined by the discrimination means 1311.
[0086] (1) In the case of natural language processing The acquisition unit 131 performs natural language processing on the communication information and obtains a business identifier and record configuration information from the communication information. The acquisition unit 131 performs different natural language processing depending on the format of the communication information and obtains a business identifier and record configuration information from the communication information.
[0087] The acquisition means 1312, for example, if the communication information is string information, performs natural language processing on the string contained in the communication information to obtain the business identifier and record configuration information.
[0088] The acquisition means 1312, for example, performs natural language processing on the strings contained in the communication information and acquires the target business identifier as a string that matches the business identifier string identified by the rules of the strings contained in the rule information acquired by the rule acquisition unit 134.
[0089] The acquisition means 1312, for example, divides the acquired string into morphemes and obtains a business identifier from the morphemes that matches the rule information (for example, "5 letters and 7 numbers") that identifies the business identifier (for example, "Booking number").
[0090] Furthermore, the acquisition means 1312 detects, for example, a tag that identifies record configuration information from the acquired string, and acquires the string associated with that tag as record configuration information. For example, the acquisition means 1312 detects a tag consisting of the string "Departure Point" enclosed in specific brackets such as square brackets or parentheses, and acquires the string paired with that tag as information that identifies the departure point, which is record configuration information.
[0091] The acquisition means 1312, for example, if the communication information is voice information, performs voice recognition processing on the communication information and obtains a string corresponding to the voice information. The acquisition means 1312 then performs natural language processing on the obtained string and obtains the string that matches the string of the business identifier identified by the rule information obtained by the rule acquisition unit 134 as the target business identifier. Furthermore, the acquisition means 1312 detects a tag that identifies the record configuration information from the obtained string and obtains the string corresponding to the tag as the record configuration information.
[0092] The acquisition means 1312, for example, if the communication information is image information, performs image recognition processing on the communication information and obtains the string contained in the image information. The acquisition means 1312 then performs natural language processing on the obtained string and obtains the string that matches the string of the business identifier identified by the rule information obtained by the rule acquisition unit 134 as the target business identifier. Furthermore, the acquisition means 1312 detects a tag that identifies the record configuration information from the obtained string and obtains the string corresponding to the tag as the record configuration information.
[0093] (2) When using a generative AI The acquisition unit 131 provides the information acquisition prompt from the prompt management unit 112 and the communication information received by the communication reception unit 121 to the generation AI, and acquires the business identifier and record configuration information from the generation AI.
[0094] The acquisition unit 131 provides, for example, the identifier acquisition prompt from the prompt management unit 112, the communication information received by the communication reception unit 121, and the rule information acquired by the rule acquisition unit 134 to the generation AI, and acquires the business identifier from the generation AI.
[0095] The acquisition unit 131 acquires one or more business identifiers from communication information that includes two or more business identifiers. If the communication information includes two or more business identifiers, the acquisition unit 131 extracts, for example, the strings of the two or more business identifiers contained in the communication information. For each of the extracted business identifier strings, the acquisition unit 131 evaluates the degree of conformity between the identification pattern of business identifiers defined based on the rule information and the extracted business identifier string. Based on the degree of conformity, the acquisition unit 131 acquires an evaluation value (score) for each of the extracted business identifier strings.
[0096] Suppose the identification pattern for the business identifier is "one uppercase letter + one lowercase letter + three digits" (for example, [AZ][az][0-9][0-9][0-9]), and the two business identifiers obtained are "Ab123" and "A4123". In this case, the acquisition unit 131 obtains an evaluation value of "5 / 5" for the business identifier "Ab123" because all the characters in the business identifier "Ab123" match the identification pattern. Also, in the business identifier "A4123", "A", "1", "2", and "3" match, but the second character "4" does not match the rule [az], so the acquisition unit 131 obtains an evaluation value of "4 / 5" for the business identifier "A4123". Then, the acquisition unit 131 selects "Ab123" as the business identifier with the higher evaluation value.
[0097] The evaluation of the degree of relevance may be based, for example, on the degree of string matching, similarity, distance, degree of conformance to a predetermined rule, or a combination thereof. The acquisition unit 131 may, for example, identify the string with the highest acquired evaluation value as the business identifier. Alternatively, the acquisition unit 131 may acquire the acquired evaluation value in association with each of the extracted business identifier strings, allowing the user to select one or more business identifiers from two or more extracted business identifiers based on the evaluation value.
[0098] The acquisition unit 131 acquires metadata from the communication information. The acquisition unit 131 acquires metadata from the communication information received by the communication reception unit 121. The acquisition unit 131 acquires metadata from the communication information by, for example, the following natural language processing or generation AI processing.
[0099] (1) In the case of natural language processing The acquisition unit 131 acquires metadata from the communication information in different ways depending on the format of the communication information.
[0100] The acquisition means 1312 acquires metadata from the communication information in different ways depending on the format determined by the discrimination means 1311.
[0101] The acquisition means 1312, for example, if the communication information is string information, performs natural language processing on the string contained in the communication information and obtains metadata. The acquisition means 1312, for example, detects a tag that identifies metadata from the acquired string and obtains the string associated with the tag as metadata. The acquisition means 1312, for example, detects the sender's email address from the acquired email string and obtains a string that identifies the sender of the email (for example, a domain name) as metadata from the detected email address.
[0102] The acquisition means 1312, for example, if the communication information is voice information, performs speech recognition processing on the communication information and obtains a string corresponding to the voice information in the communication information. Then, the acquisition means 1312 performs natural language processing on the obtained string and obtains metadata. The acquisition means 1312 also obtains the communication information itself, which is voice information, as metadata. The acquisition means 1312 also obtains the voice information received by the communication reception unit 121 as voice information without performing speech recognition processing on it.
[0103] The acquisition means 1312, for example, if the communication information is image information, performs image recognition processing on the communication information and obtains the string contained in the image information within the communication information. Then, the acquisition means 1312 performs natural language processing on the obtained string to obtain metadata. The acquisition means 1312 also obtains the communication information itself, which is image information, as metadata. The acquisition means 1312 also obtains the image information received by the communication reception unit 121 as image information without performing image recognition processing on it.
[0104] (2) When using a generative AI The acquisition unit 131 provides the metadata acquisition prompt from the prompt management unit 112 and the communication information received by the communication reception unit 121 to the generation AI, and acquires metadata from the generation AI.
[0105] The storage unit 132 appends record configuration information to records in the business database. The record configuration information appended by the storage unit 132 may be only a portion of the information in the business database records. The storage unit 132 appends the record configuration information to records identified by the business identifier. The storage unit 132 determines whether there is an existing record containing a business identifier that matches the business identifier associated with the record configuration information to be appended. If the storage unit 132 determines that such an existing record exists, it appends the record configuration information to the existing record. On the other hand, if the storage unit 132 determines that such an existing record does not exist, it creates a new record and writes the record configuration information to the new record. For example, the storage unit 132 executes "UPDATE business database SET attribute name = part of business information...WHERE business identifier = 123".
[0106] Furthermore, the storage unit 132 searches the business database using the acquired business identifier as a key, and if it cannot find a record, it determines that there are no existing records.
[0107] The storage unit 132 stores metadata in the business database. The storage unit 132 stores metadata in association with records identified by business identifiers. For example, the storage unit 132 stores metadata acquired by the acquisition unit 131 in association with the record. For example, the storage unit 132 appends metadata of a string acquired by the acquisition unit 131 to the record. For example, the storage unit 132 associates metadata, such as audio information acquired by the acquisition unit 131, with the record. For example, the storage unit 132 associates metadata, such as image information acquired by the acquisition unit 131, with the record. Note that storing metadata in association with a record can also be done by appending metadata to the record.
[0108] The identifier acquisition unit 133 acquires participant identifiers. For example, the identifier acquisition unit 133 acquires participant identifiers associated with communication information. The identifier acquisition unit 133 performs natural language processing on the string of communication information acquired by the acquisition unit 131 and acquires participant identifiers contained in the communication information. Note that the participant identifier associated with the communication information may also be a participant identifier within the communication information.
[0109] The rule acquisition unit 134 acquires rule information from the rule management unit 113. The rule acquisition unit 134 acquires rule information corresponding to the participant identifier acquired by the identifier acquisition unit 133, for example. The rule acquisition unit 134 acquires rule information corresponding to the participant identifier by searching the rule information management table stored in the rule management unit 113 using the participant identifier acquired by the identifier acquisition unit 133 as the key.
[0110] The rule acquisition unit 134 acquires rule information from the learning model. This learning model is a model acquired through a learning process using two or more training data sets, with communication information as the explanatory variable and a business identifier corresponding to the participant identifier as the dependent variable.
[0111] The output unit 14 outputs various types of information and instructions. For example, the output unit 14 transmits various types of information and instructions to the terminal device 3 and the generation AI. These types of information and instructions include business information, business identifiers, and record configuration information.
[0112] Here, output usually refers to transmission to terminal device 3 or generating AI, but it may also be a concept that includes display on a screen, projection using a projector, printing with a printer, sound output, transmission to devices other than terminal device 3, storage on a recording medium, and handover of processing results to other processing devices or other programs.
[0113] The storage unit 11, the business management unit 111, the prompt management unit 112, and the rule management unit 113 are preferably non-volatile recording media, but can also be implemented with volatile recording media. The process by which information is stored in the storage unit 11, etc., is not specified. For example, information may be stored in the storage unit 11, etc., via a recording media, information transmitted via a communication line, etc., may be stored in the storage unit 11, etc., or information input via an input device may be stored in the storage unit 11, etc.
[0114] The reception unit 12 and the communication reception unit 121 are preferably implemented by wireless or wired communication means, but may also be implemented by means of receiving broadcasts, device drivers for input means such as touch panels and keyboards, or control software for menu screens.
[0115] The processing unit 13, acquisition unit 131, storage unit 132, identifier acquisition unit 133, rule acquisition unit 134, discrimination means 1311, and acquisition means 1312 can typically be implemented using a processor, memory, etc. The processing procedures of the processing unit 13, etc., are typically implemented in software, and this software is recorded on a recording medium such as ROM. However, it may also be implemented in hardware (dedicated circuitry). The processor can be a CPU, MPU, GPU, etc., and the type is not limited.
[0116] The output unit 14 is usually implemented by wireless or wired communication means, but it may also be implemented by broadcasting means.
[0117] Next, the operation of the database construction device 1 will be explained using the flowcharts in Figures 3 and 4. First, the operation of the database construction device 1 when the acquisition unit 131 acquires business identifiers and record configuration information from communication information using natural language processing will be explained using the flowchart in Figure 3.
[0118] (Step S301) The communication reception unit 121 determines whether or not it has received communication information. The communication reception unit 121 determines, for example, whether or not it has received communication information from the information server 2 or the terminal device 3. If communication information has been received, the process proceeds to step S302; otherwise, it returns to step S301.
[0119] (Step S302) The determination means 1311 of the acquisition unit 131 determines whether the communication information received by the communication reception unit 121 in step S301 is string information. If it is string information, proceed to step S303; otherwise, proceed to step S313.
[0120] (Step S303) The rule acquisition unit 134 acquires rule information from the rule management unit 113 or the learning model.
[0121] (Step S304) The acquisition means 1312 of the acquisition unit 131 performs natural language processing on the string of communication information according to the rule information acquired by the rule acquisition unit 134 in step S303.
[0122] (Step S305) The acquisition means 1312 determines from the result of the natural language processing in step S304 whether or not the communication information string contains a business identifier. If a business identifier is included, the process proceeds to step S306; otherwise, the process returns to step S301.
[0123] (Step S306) The acquisition means 1312 determines from the result of the natural language processing in step S304 whether or not the string of communication information contains record configuration information. If record configuration information is included, the process proceeds to step S307; otherwise, the process returns to step S301.
[0124] (Step S307) The storage unit 132 determines whether there is an existing record in the business database that contains a business identifier that matches the business identifier obtained by the acquisition means 1312 in step S305. If an existing record exists, the process proceeds to step S308; otherwise, the process proceeds to step S309.
[0125] (Step S308) The storage unit 132 appends the record configuration information acquired by the acquisition means 1312 in step S306 to the existing record.
[0126] (Step S309) The storage unit 132 creates a new record in the business database.
[0127] (Step S310) The storage unit 132 records the business identifier acquired by the acquisition means 1312 in step S305 and the record configuration information acquired by the acquisition means 1312 in step S306 in the new record created in step S309.
[0128] (Step S311) The acquisition unit 131 acquires metadata from the communication information received by the communication reception unit 121 in step S301.
[0129] (Step S312) The storage unit 132 associates the metadata acquired in step S311 with the record in which the record configuration information was described in step S308 or step S310.
[0130] (Step S313) The discrimination means 1311 determines whether the communication information received by the communication reception unit 121 in step S301 is voice information. If it is voice information, proceed to step S314; otherwise, proceed to step S315.
[0131] (Step S314) The acquisition unit 131 performs speech recognition processing on the voice information of the communication information received by the communication reception unit 121 in step S301, and acquires string information corresponding to the voice information.
[0132] (Step S315) The discrimination means 1311 determines whether the communication information received by the communication reception unit 121 in step S301 is image information. If it is image information, the process proceeds to step S316; otherwise, the process returns to step S301.
[0133] (Step S316) The acquisition unit 131 performs image recognition processing on the image information of the communication information received by the communication reception unit 121 in step S301, and acquires string information corresponding to the image information.
[0134] In the flowchart shown in Figure 3, processing is terminated by power-off or processing termination interrupts.
[0135] Furthermore, in steps S302, S313, or S315 of the flowchart in Figure 3, the communication reception unit 121 determines whether the received communication information is text information, audio information, or image information. However, the determination is not limited to these, and for example, it may also determine whether the communication information is of any of the following data types: email, chat information, audio information or image information from a web conference.
[0136] Next, the operation of the database construction device 1 when the acquisition unit 131 acquires business identifiers and record configuration information from communication information through processing using generation AI will be explained using the flowchart in Figure 4.
[0137] (Step S401) The communication reception unit 121 determines whether or not it has received communication information. The communication reception unit 121 determines, for example, whether or not it has received communication information from the information server 2 or the terminal device 3. If communication information has been received, the process proceeds to step S402; otherwise, it returns to step S401.
[0138] (Step S402) The rule acquisition unit 134 acquires rule information from the rule management unit 113 or the learning model.
[0139] (Step S403) The acquisition unit 131 acquires an information acquisition prompt from the prompt management unit 112.
[0140] (Step S404) The acquisition unit 131 passes the rule information acquired by the rule acquisition unit 134 in step S402, the information acquisition prompt acquired in step S403, and the communication information received by the communication reception unit 121 in step S401 to the generation AI.
[0141] (Step S405) The acquisition unit 131 determines whether or not it has obtained an answer from the generating AI. If an answer has been obtained, it proceeds to step S406; otherwise, it returns to step S405.
[0142] (Step S406) The acquisition unit 131 determines whether the response from the generating AI in step S405 contains a business identifier. If a business identifier is included, the unit proceeds to step S407; otherwise, it returns to step S401.
[0143] (Step S407) The acquisition unit 131 determines whether the response from the generating AI in step S405 contains record configuration information. If it contains record configuration information, the process proceeds to step S307; otherwise, it returns to step S401.
[0144] In the flowchart shown in Figure 4, processing is terminated by power-off or processing termination interrupts.
[0145] Furthermore, in step S402 of the flowchart in Figure 4, the rule acquisition unit 134 acquires rule information, and in step S404, the acquisition unit 131 passes the rule information to the generation AI. However, this is not the only option. For example, it is not necessary to acquire rule information in step S402, nor to pass the rule information to the generation AI in step S404.
[0146] The specific operation of the database construction device 1 in this embodiment will be described below.
[0147] The prompt management unit 112 stores the prompt management table shown in Figure 6. The prompt management table manages one or more records that have, for example, the attribute name "ID", "prompt identifier", and "prompt".
[0148] The rule management unit 113 stores the rule information management table shown in Figure 7. The rule information management table manages one or more records that have, for example, attribute names "ID", "Rule Information ID", "Rule Target", "Shipping Company", "Forwarder", "Rule", and "Specific Example".
[0149] In light of the above situation, the following two specific examples will be explained. Specific example 1 is the case where the communication information is email. Specific example 2 is the case where the communication information is chat.
[0150] (Specific example 1) Let's assume that User X is a person who manages container transportation operations at shipping company ONE and manages business information regarding the transportation of cargo for shipper ABC. Let's assume that User X was requested by shipper ABC to transport cargo and contacted shipper ABC with the shipping schedule via email 801 as shown in Figure 8. Let's also assume that User X assigns a Booking number, which is a business identifier, to each transportation and manages business information including the transportation of shipper ABC using the business information management table 901 shown in Figure 9A. That is, let's assume that the business database of the business management unit 111 of the database construction device stores the business information management table 901. The business information management table 901 manages one or more records that have, for example, attribute names "ID", "Business Information ID", "Business Identifier", "Shipper", "Departure Point", "Loading Port", "Unloading Port", and "Destination". Although "Departure Date" and "Arrival Date" are not listed as attribute names in the business information management table 901, the business information management table 901 may manage information that identifies the departure date of the cargo and information that identifies the arrival date of the cargo. Furthermore, while the Business Information Management Table 901 lists Booking number, B / L number, and container number as "business identifiers," the Business Information Management Table 901 may also manage business identifiers as, for example, product ID, invoice number, PO number, or a combination of multiple business identifiers.
[0151] The communication reception unit 121 receives email 801 as communication information from the information server 2 when the information server 2 receives email 801 from user X's terminal device 3.
[0152] When the communication receiving unit 121 receives email 801 from the information server 2, the discrimination means 1311 of the acquisition unit 131 determines that the received communication information, email 801, is string information.
[0153] Next, the identifier acquisition unit 133 performs natural language processing on email 801 and obtains the ship company "ONE," which is the participant identifier, from the domain name of the sender's email address 802 contained in email 801. Then, the rule acquisition unit 134 retrieves the rule information corresponding to the ship company "ONE" by searching the rule information management table (Figure 7) stored in the rule management unit 113 using the ship company "ONE," which is the participant identifier, as the key. Specifically, the rule acquisition unit 134 retrieves the rule information for "ID=1" and "ID=4" from the rule information management table (Figure 7).
[0154] The acquisition means 1312 of the acquisition unit 131 performs natural language processing on email 801 according to the rule information for "ID=1" and "ID=4" in the rule information management table (Figure 7). The acquisition means 1312 detects the [Booking No.] tag 803 from email 801 according to the rule information for "ID=1" in the rule information management table (Figure 7), and acquires the string 804 that is paired with tag 803 as the booking number. Furthermore, the acquisition means 1312 detects the [B / L No.] tag 805 and the [Container No.] tag 806 from email 801. Then, the acquisition means 1312 acquires the string 807 that is paired with tag 805 as the B / L number, and acquires the string 808 that is paired with tag 806 as the container number.
[0155] Next, the acquisition means 1312 obtains record configuration information from email 801 by performing natural language processing on email 801. Specifically, the acquisition means 1312 detects the tags 809 for [origin], 810 for [loading port], 811 for [destination], and 812 for [unloading port] from email 801. The acquisition means 1312 then obtains the string 813 paired with tag 809 as information identifying the origin, the string 814 paired with tag 810 as information identifying the loading port, the string 815 paired with tag 811 as information identifying the destination, and the string 816 paired with tag 812 as information identifying the unloading port. In addition, the acquisition means 1312 obtains the shipper "ABC", which is the participant identifier, from the domain name of the recipient's email address 817 contained in email 801.
[0156] The storage unit 132 determines whether there is an existing record in the business information management table 901 that contains a Booking number matching the Booking number acquired by the acquisition means 1312. Here, it is assumed that "ID=1" in the business information management table 901 contains the same Booking number as the Booking number acquired by the acquisition means 1312 from the communication information. The storage unit 132 searches the business information management table 901 using the Booking number acquired by the acquisition means 1312 as the key and determines that there is an existing record "ID=1" in the business information management table 901.
[0157] Next, the storage unit 132 adds the information identifying the "B / L number," "container number," "shipper," "origin," "loading port," "unloading port," and "destination," which the acquisition means 1312 obtained from email 801, to "ID=1" in the business information management table 901, according to the rule information for "ID=8" in the rule information management table (Figure 7).
[0158] Furthermore, the acquisition unit 131 acquires metadata from the email 801 received by the communication reception unit 121. Specifically, the acquisition unit 131 acquires the domain name as metadata from the sender's email address 802 of the email 801 received by the communication reception unit 121, and acquires a string that identifies the date the email was received as metadata from the reception date 818 of the email 801.
[0159] Next, the storage unit 132 added a string identifying the sender of the acquired email and a string identifying the date the email was received to "ID=1" in the business information management table 901.
[0160] The output unit 14 transmits the business information for "ID=1" in the business information management table 902 shown in Figure 9B to the terminal device 3 of user X.
[0161] User X's terminal device 3 receives and outputs the relevant business information. Terminal device 3 outputs a business information management table 902 with the business identifier and record configuration information added to "ID=1", for example, as shown in Figure 9B.
[0162] Based on the above, user X can obtain business information management table 902, which has the business identifier and record configuration information added, based on the email received from shipper ABC.
[0163] (Specific example 2) User Y is a person who manages logistics outsourcing operations at FORD Corporation and manages business information related to the transportation of cargo for shipper AAA. User Y was requested by shipper AAA to transport cargo and requested the shipping company YANG MING to transport shipper AAA's cargo. User Y then contacted shipper AAA with the shipping schedule using Chat 1001 as shown in Figure 10. Furthermore, User Y assigns a Booking number, which is a business identifier, to each shipment and manages business information including the shipment for shipper AAA using the business information management table 1101 shown in Figure 11A. In other words, the business database of the business management unit 111 of the database construction device stores the business information management table 1101 shown in Figure 11A. The business information management table 1101 manages one or more records that have, for example, attribute names "ID", "Business Information ID", "Business Identifier", "Shipper", "Shipping Company", "Departure Point", "Loading Port", "Unloading Port", and "Destination". Although the business information management table 1101 does not list "Departure Date" and "Arrival Date" as attribute names, the business information management table 1101 may also manage information that identifies the departure date of a shipment and information that identifies the arrival date of a shipment. Furthermore, although the business information management table 1101 lists Booking number, B / L number, and container number as "business identifiers," the business information management table 1101 may also manage business identifiers such as product ID, invoice number, PO number, or a combination of multiple business identifiers.
[0164] The communication reception unit 121 receives the chat information 1001 from the information server 2 as communication information when the information server 2 receives the chat information 1001 between user Y and consignor AAA from user Y's terminal device 3.
[0165] When the communication reception unit 121 receives chat 1001 information from the information server 2, the rule acquisition unit 134 retrieves the rule information corresponding to the forwarder "FORD" by searching the rule information management table (Figure 7) stored in the rule management unit 113 using the participant identifier forwarder "FORD" as the key. Specifically, the rule acquisition unit 134 retrieves the rule information for "ID=4" in the rule information management table (Figure 7).
[0166] Next, the acquisition unit 131 acquires the information acquisition prompt "ID=1" from the prompt management table (Figure 6). Then, the acquisition unit 131 assigns the chat 1001 information received by the communication reception unit 121 from the information server 2 to the variable <communication information> of the information acquisition prompt "ID=1", and assigns the rule information "ID=4" acquired by the rule acquisition unit 134 from the rule information management table (Figure 7) to the variable <rule information>, thereby configuring the information acquisition prompt "ID=1" to be given to the generating AI.
[0167] The acquisition unit 131 passes the configured "ID=1" information acquisition prompt, the chat 1001 information received by the communication reception unit 121, and the "ID=4" rule information acquired by the rule acquisition unit 134 to the generation AI. The acquisition unit 131 then obtains a response from the generation AI and acquires the business identifier and record configuration information from that response. Specifically, the acquisition unit 131 acquires the business identifier, "Booking number," and record configuration information such as "shipping company," "departure point," "loading port," "unloading port," and "destination" from the generation AI's response.
[0168] The storage unit 132 determines whether there is an existing record in the business information management table 1101 that contains a Booking number that matches the Booking number obtained by the acquisition unit 131. Here, it is assumed that the "ID=1" in the business information management table 1101 of the business database contains the same Booking number as the Booking number obtained by the acquisition unit 131 from the AI's response. The storage unit 132 searches the business information management table 1101 using the Booking number obtained by the acquisition unit 131 as the key, and determines that there is an existing record "ID=1" in the business information management table 1101.
[0169] Next, the storage unit 132 adds the information identifying the "shipping company," "destination," "loading port," "unloading port," and "destination," which the acquisition unit 131 obtained from the AI's response, to "ID=1" in the business information management table 1101.
[0170] The output unit 14 transmits the business information for "ID=1" in the business information management table 1102 shown in Figure 11B to the terminal device 3 of user Y.
[0171] User Y's terminal device 3 receives and outputs the business information. Terminal device 3 outputs a business information management table 1102 in which the business identifier and record configuration information are added to "ID=1", for example, as shown in Figure 11B.
[0172] Based on the above, user Y can obtain the business information management table 1102, which has business identifiers and record configuration information added to it, based on the chat information with shipper AAA.
[0173] As described above, according to this embodiment, information related to operations can be easily added to a database using communication information between parties involved in the transportation of goods in logistics.
[0174] Furthermore, according to this embodiment, business-related information can be easily added to the database using two or more different forms of communication information.
[0175] Furthermore, according to this embodiment, a business identifier and record configuration information can be obtained from communication information.
[0176] Furthermore, according to this embodiment, a business identifier can be accurately obtained based on rules set for each participant.
[0177] Furthermore, according to this embodiment, the optimal business identifier can be obtained from two or more types of business identifiers, and record configuration information can be accurately stored in the record.
[0178] Furthermore, according to this embodiment, metadata of communication information can be stored in a database in association with a business identifier.
[0179] The processing in the above embodiment may be implemented by software. This software may be distributed by software download or the like. Alternatively, this software may be recorded on a recording medium such as a CD-ROM and distributed. This also applies to other embodiments in this specification. The software that implements information system A in this embodiment is the following program. In other words, this program causes a computer to function as a communication receiving unit that receives communication information regarding communication between two or more parties involved in the transportation of goods in logistics, an acquisition unit that obtains a business identifier that identifies the business information regarding the transportation requested by the client from the communication information received by the communication receiving unit, and record configuration information that constitutes a record in a business database that stores the business information, and an storage unit that adds the record configuration information to the record identified by the business identifier in the business database.
[0180] Figure 12 is a block diagram of a computer system 300 that executes the program described herein to realize the database construction device 1 and other devices of the various embodiments described above.
[0181] In Figure 12, the computer system 300 includes a computer 301 with a CD-ROM drive, a keyboard 302, a mouse 303, and a monitor 304.
[0182] In Figure 8, the computer 301 includes, in addition to the CD-ROM drive 3012, an MPU 3013, a bus 3014 connected to the CD-ROM drive 3012, a ROM 3015 for storing programs such as boot-up programs, a RAM 3016 connected to the MPU 3013 for temporarily storing application program instructions and providing temporary storage space, and a hard disk 3017 for storing application programs, system programs, and data. Although not shown here, the computer 301 may further include a network card for providing connectivity to a LAN.
[0183] The program that causes the computer system 300 to execute the functions of the database construction device 1, etc., as described above, may be stored on CD-ROM 3101, inserted into CD-ROM drive 3012, and then transferred to hard disk 3017. Alternatively, the program may be transmitted to computer 301 via a network (not shown) and stored on hard disk 3017. The program is loaded into RAM 3016 during execution. The program may also be loaded directly from CD-ROM 3101 or the network.
[0184] The program does not necessarily have to include an operating system (OS) or third-party program that causes the computer 301 to execute functions such as the database construction device 1 of the above-described embodiment. The program only needs to include the instruction portion that calls appropriate functions (modules) in a controlled manner and obtains the desired result. How the computer system 300 operates is well known, so a detailed explanation is omitted.
[0185] The above program includes an information processing method used in a computer 301 equipped with a processor and memory, which includes: a communication reception step for receiving communication information relating to communication between two or more parties involved in the transportation of goods in logistics; an acquisition step for obtaining from the communication information received in the communication reception step a business identifier that identifies the business information relating to the transportation requested by the requester, and record configuration information that constitutes a record in a business database that stores the business information; and an storage step for adding the record configuration information to the record identified by the business identifier in the business database.
[0186] In the above program, steps such as sending information and receiving information do not include hardware-based processing, such as processing performed by a modem or interface card in the transmission step (processing that can only be performed by hardware).
[0187] Furthermore, the computer running the above program may be a single computer or multiple computers. In other words, it may perform centralized processing or distributed processing.
[0188] Furthermore, it goes without saying that in each of the above embodiments, two or more communication means present in a single device may be physically implemented in a single medium.
[0189] Furthermore, in each of the above embodiments, each process may be implemented by centralized processing by a single device, or by distributed processing by multiple devices.
[0190] It goes without saying that the present invention is not limited to the embodiments described above, and various modifications are possible, all of which are also included within the scope of the present invention. [Industrial applicability]
[0191] As described above, the database construction device according to the present invention has the effect of automatically accumulating information related to operations using communication information among those involved in the transportation of goods in logistics, and is useful as a database construction device for constructing a database for managing operational information in logistics.
Claims
1. A communication reception department that receives communication information, such as chat, telephone voice, or audio information from web conferences, regarding communication between two or more parties involved in the transportation of goods in logistics, An acquisition unit acquires from the communication information received by the communication receiving unit a business identifier that identifies the business information related to the transportation, and record configuration information that constitutes a record in a business database in which business information including information identifying the departure point and information identifying the destination is stored. The system comprises a storage unit that appends the record configuration information acquired by the acquisition unit to the business database, in association with the business identifier acquired by the acquisition unit, The acquisition unit is, A database construction device that detects a tag that identifies the record configuration information based on a string corresponding to the aforementioned communication information, and acquires the string associated with the tag as record configuration information.
2. The communication receiving unit is: The system accepts two or more forms of communication information, including the aforementioned chat, the aforementioned telephone audio, or the aforementioned audio information in the aforementioned web conference. The acquisition unit is, Depending on the format, the business identifier and the record configuration information are obtained from the communication information in different ways. The database construction apparatus according to claim 1, wherein the different methods are a method using natural language processing and a method using generative AI, or a method using different rules within the natural language processing method, or a method using different prompts within the generative AI method.
3. The acquisition unit is, A database construction device according to claim 1, which obtains the business identifier and the record configuration information from the aforementioned communication information by natural language processing.
4. The acquisition unit is, A database construction device according to claim 1, comprising an information acquisition prompt that instructs the communication information to acquire the business identifier and the record configuration information, and providing the communication information to a generating AI, and acquiring the business identifier and the record configuration information from the generating AI.
5. The acquisition unit is, A database construction device according to claim 1, comprising: an identifier acquisition prompt that instructs the communication information to acquire the business identifier based on rule information indicating rules for acquiring the business identifier; and providing the communication information and the rule information to a generating AI, and acquiring the business identifier based on the rule information from the generating AI.
6. The acquisition unit is, A database construction device according to claim 1, which obtains one or more business identifiers from the communication information that includes two or more types of business identifiers.
7. The acquisition unit is, The metadata of the aforementioned communication information is obtained, The storage unit is The database construction device according to claim 1, which stores the metadata in the business database in association with the record identified by the business identifier.
8. A method for producing a database, wherein a computer performs all the processing that a database construction device according to any one of claims 1 to 7 would perform.
9. Computers, A program for causing a database construction device to function as described in any one of claims 1 to 7.