JP2021056704A - Data extracting method and data extracting program - Google Patents

Abstract

To provide a data extracting method and a data extracting program capable of associating the item name of a first data file with the item name of a second data file even if the item name of the first data file is changed.SOLUTION: An information processing system stores, in a keyword DB, data extracted from a customer XML file in association with an item name in the customer XML file, receives a data extracting request along with a second item name in the keyword DB, obtains a first item name in the customer XML file corresponding to the second item name from an association information file, and searches the customer XML file with the first item name being as a key. In the searching, when it is determined that the first item name is not found in the customer XML file, first data corresponding to the first item name is obtained from the keyword DB, a third item name corresponding to the first data is obtained from the customer XML file, and the second item name and the third item name are stored in the association information file in association with each other.SELECTED DRAWING: Figure 6

Description

The present invention relates to a data extraction method and a data extraction program.

A bill of materials is used when manufacturing hardware, such as in the field of automobile manufacturing. The bill of materials plays an important role in supporting the quality of products, such as managing from development to manufacturing consistently and ensuring traceability.

As for software, the number of control units mounted on vehicles is increasing rapidly and the relationships are becoming complicated, and the importance of management by bill of materials is increasing.

Japanese Unexamined Patent Publication No. 2003-91530

However, the customer's Extensible Markup Language (XML) format file is expected to change due to the customer's convenience, such as a change in the data output tool or a change in the file structure due to development or design reasons. In this case, since the data to be registered in the software BOM cannot be searched by the correspondence map information DB with the software BOM Database (DB) prepared in advance, the data should be registered in the software BOM. Can no longer be done.

In one aspect, even if the item name of the first data file is changed, it is intended to associate with the item name of the second data file.

One aspect is a data extraction method in which the data extracted from the first data file is stored in the second data file, the item name of the first data file and the item name of the second data file. By referring to the correspondence information file that stores the correspondence of, the data of the item of the first data file whose name is different from the item of the second data file is extracted and stored in the second data file. In the data extraction method that can be performed, the data extracted from the first data file is stored in the save file in association with the item name of the first data file, and the second data file is used. The data extraction request accompanied by the second item name is received, the first item name of the first data file corresponding to the second item name is acquired from the correspondence information file, and the first item name is used. The first data file is searched for in the key, and when it is determined in the search that the first item name is not found in the first data file, the saved file is changed to the first item name. The corresponding first data is acquired, the third item name corresponding to the first data is acquired from the first data file, and the second item name and the third item name correspond to each other. Attach and record in the corresponding information file.

In one aspect, even if the item name of the first data file is changed, it can be associated with the item name of the second data file.

It is a figure explaining the example of registration of the information in the software bill of materials DB as a related example. It is a figure which illustrates the process when the customer XML file is changed in the customer system shown in FIG. It is a block diagram which shows typically the configuration example of the information processing system in one example of Embodiment. It is a block diagram which shows typically the hardware configuration example of the server shown in FIG. It is a block diagram which shows typically the software configuration example of the server shown in FIG. It is a figure explaining the example of registration of the information in the software bill of materials DB in the information processing system shown in FIG. It is a figure which illustrates the process when the XML file is changed in the customer system shown in FIG. It is a table which shows the 1st example of a software bill of materials. It is a table which shows the 2nd example of a software bill of materials. It is a figure which illustrates the software bill of materials included in the software bill of materials DB in the server shown in FIG. It is a figure which illustrates the keyword DB shown in FIG. 6 and FIG. It is a figure which illustrates the approval screen for the change of the correspondence map information DB shown in FIG. 6 and FIG. It is a flowchart explaining the outline of the update process of the software bill of materials DB in the server shown in FIG. It is a flowchart explaining the detail of the update process of the software bill of materials DB in the server shown in FIG. It is a flowchart explaining the update process of the software bill of materials DB in the information processing system shown in FIG.

Hereinafter, one embodiment will be described with reference to the drawings. However, the embodiments shown below are merely examples, and there is no intention of excluding the application of various modifications and techniques not specified in the embodiments. That is, the present embodiment can be variously modified and implemented within a range that does not deviate from the purpose.

Further, each figure does not mean that it includes only the components shown in the figure, but may include other functions and the like.

Hereinafter, since the same reference numerals indicate the same parts in the drawings, the description thereof will be omitted.

[A] Related Example FIG. 1 is a diagram illustrating an example of registering information in the software bill of materials DB 602 as a related example.

The software bill of materials system 60 creates the software bill of materials DB 602 based on the customer XML file 701 input from the customer system 70.

The customer XML file 701 includes tag information extracted from files in various formats such as word processing software and presentation software.

In the customer XML file 701 of the customer system 70, the tag of "<SHORT-NAME> ECU9 <SHORT-NAME>" is included in the XML description example shown by the reference numeral A1 (see reference numeral A11).

In the mapping table information DB601 of the software bill of materials system 60, in the map table description example shown by reference numeral A2, "ECU-INSTANCE / SHORT-NAME" is included as the relative path of the XML tag and the data to be acquired (ECU-INSTANCE / SHORT-NAME). (See reference numeral A21). Further, in the map table description example shown by reference numeral A2, "PHYSICS_ECU / PHYSICS_ECU_NAME" is included as the column information of the software bill of materials DB602 for registering the data acquired from XML (see reference numeral A22).

In the software bill of materials DB 602 of the software bill of materials system 60, "ECU9" is registered for "PHYSICS_ECU_NAME" by the mapping by the mapping map information DB (see reference numeral A3).

FIG. 2 is a diagram illustrating processing when the customer XML file 701 is changed in the customer system 70 shown in FIG.

As shown by reference numeral B1, in the customer XML file 701, for example, the data storage information may be changed at the convenience of the customer.

In the customer XML file 701 of the customer system 70, the tag of "<LONG-NAME> ECU9 <LONG-NAME>" is included in the XML description example shown by the reference numeral B2 (see reference numeral B21). That is, the tag "SHORT_NAME" shown in FIG. 1 is changed to "LONG_NAME" in the example shown in FIG.

In the mapping table information DB 601 of the software bill of materials system 60, in the map table description example shown by reference numeral B3, "ECU-INSTANCE / SHORT-NAME" is included as the relative path of the XML tag and the data to be acquired (ECU-INSTANCE / SHORT-NAME). Reference numeral B31). That is, the XML tag and the relative path do not match.

Further, in the map table description example shown by reference numeral B3, "PHYSICS_ECU / PHYSICS_ECU_NAME" is included as the column information of the software bill of materials DB602 for registering the data acquired from XML (see reference numeral B32). However, since there is no data acquired from XML, the data cannot be registered in the software bill of materials DB602.

[B] Example of Embodiment [B-1] Example of System Configuration FIG. 3 is a block diagram schematically showing a configuration example of the information processing system 100 in the example of the embodiment.

The information processing system 100 includes a server 1 and a plurality of (three in the illustrated example) terminals 2. The server 1 and each terminal 2 are connected to each other so as to be able to communicate with each other via the network 3.

The server 1 is a computer (information processing device) having a server function, and creates a software bill of materials DB 102, which will be described later, using FIG. 6 and the like.

The terminal 2 manages the XML file 201 described later using FIG. 6 and the like, and provides the XML file 201 to the server 1.

FIG. 4 is a block diagram schematically showing a hardware configuration example of the server 1 shown in FIG.

As shown in FIG. 4, the server 1 includes a CPU 11, a memory 12, a display control unit 13, a storage device 14, an input interface (I / F) 15, a read / write processing unit 16, and a communication I / F 17. The terminal 2 may also have the hardware configuration as shown in FIG. 4 like the server 1.

The memory 12 is an example of a storage unit, and is an exemplary storage device including a Read Only Memory (ROM) and a Random Access Memory (RAM). A program such as a Basic Input / Output System (BIOS) may be written in the ROM of the memory 12. The software program of the memory 12 may be appropriately read and executed by the CPUs 11 and 21. Further, the RAM of the memory 12 may be used as a primary recording memory or a working memory.

The display control unit 13 is connected to the display device 130 and controls the display device 130. The display device 130 is a liquid crystal display, an Organic Light-Emitting Diode (OLED) display, a Cathode Ray Tube (CRT), an electronic paper display, or the like, and displays various information to an operator or the like. The display device 130 may be combined with an input device, for example, a touch panel.

The storage device 14 is an example device for reading, writing, and storing data, and for example, a Hard Disk Drive (HDD), a Solid State Drive (SSD), or a Storage Class Memory (SCM) may be used. The storage device 14 stores information related to the correspondence map information DB 101, the software bill of materials DB 102, and the keyword DB 103, which will be described later, using FIG.

The input I / F 15 may be connected to an input device such as a mouse 151 or a keyboard 152 to control an input device such as the mouse 151 or the keyboard 152. The mouse 151 and the keyboard 152 are examples of input devices, and an operator performs various input operations via these input devices.

The read / write processing unit 16 is configured so that the recording medium 160 can be attached. The read / write processing unit 16 is configured to be able to read the information recorded on the recording medium 160 while the recording medium 160 is attached. In this example, the recording medium 160 is portable. For example, the recording medium 160 is a flexible disk, an optical disk, a magnetic disk, a magneto-optical disk, a semiconductor memory, or the like.

The communication I / F 17 is an interface for enabling communication with an external device.

The CPU 11 is a processing device that performs various controls and calculations, and realizes various functions by executing an Operating System (OS) or a program stored in the memory 12.

The device for controlling the operation of the entire server 1 is not limited to the CPU 11, and may be, for example, any one of MPU, DSP, ASIC, PLD, and FPGA. Further, the device for controlling the operation of the entire server 1 may be a combination of two or more types of CPU, MPU, DSP, ASIC, PLD and FPGA. MPU is an abbreviation for Micro Processing Unit, DSP is an abbreviation for Digital Signal Processor, and ASIC is an abbreviation for Application Specific Integrated Circuit. PLD is an abbreviation for Programmable Logic Device, and FPGA is an abbreviation for Field Programmable Gate Array.

FIG. 5 is a block diagram schematically showing a software configuration example of the server 1 shown in FIG.

As shown in FIG. 5, the CPU 11 of the server 1 executes a program (in other words, a data extraction program) to save processing unit 111, first acquisition unit 112, search processing unit 113, and second acquisition unit. It functions as 114 and the recording processing unit 115.

The save processing unit 111 stores the data extracted from the XML file 201 in the keyword DB 103 in association with the item name of the XML file 201. In other words, the save processing unit 111 saves to the keyword DB 103 extracted from the XML file 201.

Further, when it is determined that the first item name is not found in the XML file 201 in the search of the XML file 201, the save processing unit 111 associates the second item name with the third item name. , May be stored in the keyword DB 103.

The first acquisition unit 112 receives the data extraction request with the second item name of the software bill of materials DB 102, and acquires the first item name of the XML file 201 corresponding to the second item name from the correspondence map information DB 101. To do.

The search processing unit 113 searches the XML file 201 using the first item name as a key.

The second acquisition unit 114 acquires the first data corresponding to the first item name from the keyword DB 103 when it is determined that the first item name is not found in the XML file 201 in the search of the XML file 201. Then, the third item name corresponding to the first data is acquired from the XML file 201.

The recording processing unit 115 associates the second item name with the third item name and records them in the association map information DB 101.

Further, the recording processing unit 115 may display a screen for asking the user whether to approve the association between the second item name and the third item name in the association map information DB 101.

FIG. 6 is a diagram illustrating an example of registering information in the software bill of materials DB 102 in the information processing system 100 shown in FIG.

The software bill of materials system 10 shown in FIG. 6 is executed by the server 1 shown in FIG. Further, the customer system 20 shown in FIG. 6 is executed by the terminal 2 shown in FIG.

In the example shown in FIG. 6, the correspondence map information DB 101 (may be referred to as “correspondence information file”) is acquired, and the XML file 201 (“first data file”) is acquired based on the contents of the correspondence map information DB 101. ”) Is searched. Then, desired data (“ECU9” in the illustrated example) is acquired from the XML file 201 and registered in the software bill of materials DB 102 (may be referred to as a “second data file”).

Further, the tag name (in the illustrated example, “ECU9”) corresponding to the same data as the software bill of materials DB 102 (“ECU9” in the illustrated example) corresponds to the keyword DB 103 (may be referred to as “save file”). It is registered in association with SHORT-NAME ”).

FIG. 7 is a diagram illustrating processing when the XML file 201 is changed in the customer system 20 shown in FIG.

In the example shown in FIG. 7, in the XML file 201 of the customer system 20, "<SHORT-NAME> ECU9 <SHORT-NAME>" is changed to "<LONG-NAME> ECU9 <LONG-NAME>" (reference numeral). See C1).

In this way, when the data location or the data structure is changed in the XML file 201, the desired data cannot be searched / registered from the XML file 201 even if the information registered in the correspondence map information DB 101 is referred to (). See symbol C2).

Therefore, the data (illustrated example, “ECU9”) registered in association with the tag name (“SHORT-NAME” in the illustrated example) that failed in the search is acquired from the keyword DB 103. Then, the XML file 201 is searched using the data as a key, and the tag name (“LONG-NAME” in the illustrated example) of the tag in which the data is registered is acquired (see reference numeral C3).

As a result, it was possible to recognize that the name of the tag that failed the search was changed to "LONG-NAME", so that "SHORT-NAME" in the correspondence map information DB 101 is changed to "LONG-NAME" (code). See C4).

In the subsequent update process of the software bill of materials DB 102, as shown in FIG. 6, data extraction is performed using the changed association map information DB 101.

FIG. 8 is a table showing the first example of the software bill of materials. FIG. 9 is a table showing a second example of the software bill of materials. FIG. 10 is a diagram illustrating a software bill of materials included in the software bill of materials DB 102 in the server 1 shown in FIG.

FIG. 8 shows a software bill of materials created by, for example, presentation software in the development department A, and FIG. 9 shows a software bill of materials created by, for example, spreadsheet software in the development department B.

In this way, the format of the software bill of materials may differ for each development department, but according to an example of this embodiment, as shown in FIG. 10, the software bill of materials in all departments is combined into a single software bill of materials. Is managed.

FIG. 11 is a diagram illustrating the keyword DB 103 shown in FIGS. 6 and 7.

As shown in FIG. 11, the keyword and the tag are registered in the keyword DB 103 in association with each other.

When the tag name of "ECU9" is changed from "SHORT-NAME" to "LONG-NAME" in the XML file 201 as shown with reference to FIGS. 6 and 7, the keyword "ECU9" is referred to. Multiple tags are registered.

FIG. 12 is a diagram illustrating an approval screen for a change in the correspondence map information DB 101 shown in FIGS. 6 and 7.

As shown by reference numeral D1, the searched ECU may be selected by pull-down in the ID of the search result.

As shown by reference numerals D2 and D3, the name and version of the selected ECU may be displayed in NAME and VERSION of the search result. NAME and VERSION may be acquired at the same time as the search.

As shown by reference numeral D4, in the data acquisition TAB of the search result, the TAB in which the selected ECU is described may be displayed.

As shown by reference numeral D5, in the data acquisition setting TAB of the search result, the TAB described in the correspondence map information DB 101 may be displayed.

As shown by reference numeral D6, in the search result approval column, a check box may be checked for the combination of the ID that accepts the search result and the data acquisition TAB. If there are too many search results to be displayed on one screen, the screen may be displayed so that it can be scrolled, or the search results that could not be displayed may be displayed on the screen of the next page. May be good.

[B-2] Operation Example An outline of the update process of the software bill of materials DB 102 in the server 1 shown in FIG. 3 will be described with reference to the flowcharts (steps S1 to S4) shown in FIG.

The search processing unit 113 determines whether or not there is data “SHORT_NAME” corresponding to the search target in the XML file 201 (step S1).

When there is data corresponding to the search target (see Yes route in step S1), the recording processing unit 115 sets the information corresponding to the data “SHORT_NAME” corresponding to the search target based on the correspondence in the correspondence map information DB 101. Is recorded in the software bill of materials DB 102.

On the other hand, when there is no data "SHORT_NAME" corresponding to the search target (see No route in step S1), the first acquisition unit 112 searches the keyword DB 103 using "SHORT_NAME" as a key (step S2).

The second acquisition unit 114 acquires "ECU9" corresponding to "SHORT_NAME" from the keyword DB 103 (step S3; see FIG. 11).

Then, the second acquisition unit 114 acquires "LONG_NAME" corresponding to "ECU9" in the keyword DB 103 from the XML file 201 and records it in the software bill of materials DB 102 (step S4; see FIG. 11). Further, the save processing unit 111 may register the correspondence between “ECU9” and “LONG_NAME” in the keyword DB 103.

Next, the details of the update process of the software bill of materials DB 102 in the server 1 shown in FIG. 3 will be described with reference to the flowcharts (steps S11 to S17) shown in FIG.

The search processing unit 113 searches the XML file 201 for data (step S11).

The search processing unit 113 determines whether or not there is data corresponding to the search target in the XML file 201 (step S12).

When there is data corresponding to the search target (see Yes route in step S12), the recording processing unit 115 provides information corresponding to the data corresponding to the search target to the software component based on the correspondence in the correspondence map information DB 101. Output to the table DB 102 (step S13), and the update process of the software bill of materials DB is completed.

On the other hand, when there is no data "SHORT_NAME" corresponding to the search target (see No route in step S12), the first acquisition unit 112 searches for the keyword DB 103 (step S14).

The second acquisition unit 114 searches the corresponding column of the XML file 201 (step S15).

The second acquisition unit 114 searches the corresponding column for the tag corresponding to the search result in the keyword DB 103 (step S16).

The second acquisition unit 114 outputs the acquired tag to the software bill of materials DB 102 (step S17), and the update process of the software bill of materials DB ends. Further, the save processing unit 111 may register the acquired tag in the keyword DB 103.

Next, the update process of the software bill of materials DB 102 in the information processing system 100 shown in FIG. 3 will be described according to the flowchart (steps S31 to S41) shown in FIG.

The customer system 20 selects the XML file 201 (step S31).

The software bill of materials system 10 fetches the XML file 201 from the customer system 20 (step S32).

The software bill of materials system 10 acquires the information of the correspondence map information DB 101 (step 33).

The software bill of materials system 10 searches the correspondence map information DB 101 to see if the content corresponding to the data of the captured XML file 201 is included (step S34).

The software bill of materials system 10 determines whether or not there is corresponding data in the correspondence map information DB 101 (step S35).

If there is relevant data (see YES route in step S35), the software bill of materials system 10 registers the data of the XML file 201 in the software bill of materials DB 102 (step S36).

Then, the customer system 20 presents the software bill of materials extracted from the software bill of materials DB 102 to the user (step S37), and the update process of the software bill of materials DB 102 ends.

If there is no corresponding data in step S35 (see the NO route in step S35), the software bill of materials system 10 acquires the keyword corresponding to the information included in the correspondence map information DB 101 from the keyword DB 103 (see the NO route in step S35). Step S38).

The software bill of materials DB 102 searches the XML file 201 based on the acquired keywords (step S39).

The software bill of materials system 10 registers the data of the XML file 201 in the software bill of materials DB 102 (step S36). After that, the step S37 process is performed as described above.

Further, the software bill of materials system 10 registers the map data in the correspondence map information DB 101 based on the acquired keyword and the search result from the XML file 201 (step S40).

Further, the software bill of materials system 10 registers the keyword in the keyword DB 103 based on the acquired keyword and the search result from the XML file 201 (step S41), and the update process of the software bill of materials DB 102 is completed.

[B-3] Effect According to the above-mentioned data extraction method and data extraction program, for example, the following effects can be achieved.

The save processing unit 111 stores the data extracted from the XML file 201 in a keyword in association with the item name of the XML file 201. The first acquisition unit 112 receives the data extraction request with the second item name of the software bill of materials DB 102, and acquires the first item name of the XML file 201 corresponding to the second item name from the correspondence map information DB 101. To do. The search processing unit 113 searches the XML file 201 using the first item name as a key. When it is determined in the search that the first item name is not found in the XML file 201, the second acquisition unit 114 acquires the first data corresponding to the first item name from the keyword DB 103, and the first The third item name corresponding to the data of is acquired from the XML file 201. The recording processing unit 115 associates the second item name with the third item name and records them in the association map information DB 101.

As a result, even if the item name of the first data file is changed, it can be associated with the item name of the second data file. Further, since it is not necessary to obtain the tool and file structure change information from the customer in advance and update the correspondence map table with the software bill of materials, the customer's trouble can be saved. Further, since it is not necessary to analyze the entire updated XML file 201, the processing load in the software bill of materials system 10 can be reduced.

By utilizing artificial intelligence and the like, similar words in the XML file 201 can be searched. Further, since the software bill of materials is automatically updated only by selecting the XML file 201, the customer can enhance the software bill of materials without any trouble.

The recording processing unit 115 causes the user to display a screen for confirming whether to approve the association between the second item name and the third item name in the association map information DB 101.

As a result, it is possible to prevent the software bill of materials DB 102 in which the incorrect correspondence is defined from being created.

When it is determined in the search that the first item name is not found in the XML file 201, the save processing unit 111 stores the second item name and the third item name in the keyword DB 103 in association with each other. You can do it.

As a result, the keyword DB 103 can be updated during the operation of the software bill of materials system 10, so that the accuracy of the created software bill of materials DB 102 can be improved.

[C] Other disclosed techniques are not limited to the above-described embodiments, and can be variously modified and implemented without departing from the spirit of the present embodiment. Each configuration and each process of the present embodiment can be selected as necessary, or may be combined as appropriate.

[D] Additional Notes The following additional notes will be further disclosed with respect to the above embodiments.

(Appendix 1)
It is a data extraction method that stores the data extracted from the first data file in the second data file, and stores the correspondence between the item name of the first data file and the item name of the second data file. By referring to the corresponding information file, it is possible to extract the data of the item of the first data file having a name different from the item of the second data file and store it in the second data file. In the data extraction method
The data extracted from the first data file is associated with the item name of the first data file and stored in the save file.
The data extraction request with the second item name of the second data file is accepted, and the first item name of the first data file corresponding to the second item name is acquired from the correspondence information file.
Search the first data file using the first item name as a key, and search for the first data file.
When it is determined in the search that the first item name is not found in the first data file, the first data corresponding to the first item name is acquired from the saved file, and the first item name is obtained. The third item name corresponding to the data of 1 is acquired from the first data file, and the third item name is obtained.
The second item name and the third item name are associated with each other and recorded in the corresponding information file.
Data extraction method.

(Appendix 2)
A screen for asking the user to confirm whether to approve the association between the second item name and the third item name in the correspondence information file is displayed.
The data extraction method according to Appendix 1.

(Appendix 3)
When it is determined in the search that the first item name is not found in the first data file, the second item name and the third item name are associated with each other and stored in the saved file. Remember,
The data extraction method according to Appendix 1 or 2.

(Appendix 4)
It is a data extraction program that stores the data extracted from the first data file in the second data file, and stores the correspondence between the item name of the first data file and the item name of the second data file. By referring to the corresponding information file, it is possible to extract the data of the item of the first data file having a name different from the item of the second data file and store it in the second data file. On the computer that runs the data extraction program
The data extracted from the first data file is associated with the item name of the first data file and stored in the save file.
The data extraction request with the second item name of the second data file is accepted, and the first item name of the first data file corresponding to the second item name is acquired from the correspondence information file.
Search the first data file using the first item name as a key, and search for the first data file.
When it is determined in the search that the first item name is not found in the first data file, the first data corresponding to the first item name is acquired from the saved file, and the first item name is obtained. The third item name corresponding to the data of 1 is acquired from the first data file, and the third item name is obtained.
The second item name and the third item name are associated with each other and recorded in the corresponding information file.
A data extraction program that executes processing.

(Appendix 5)
A screen for asking the user to confirm whether to approve the association between the second item name and the third item name in the correspondence information file is displayed.
The data extraction program according to Appendix 4, which causes the computer to execute the process.

(Appendix 6)
When it is determined in the search that the first item name is not found in the first data file, the second item name and the third item name are associated with each other and stored in the saved file. Remember,
The data extraction program according to Appendix 4 or 5, which causes the computer to execute the process.

100: Information processing system 10, 60: Software bill of materials system 1: Server 11: CPU
111: Evacuation processing unit 112: First acquisition unit 113: Search processing unit 114: Second acquisition unit 115: Recording processing unit 12: Memory 13: Display control unit 130: Display device 14: Storage device 15: Input I / F
151: Mouse 152: Keyboard 16: Read / write processing unit 160: Recording medium 17: Communication I / F
2: Terminal 3: Networks 20, 70: Customer system 21: CPU
33: Steps 101 and 601: Correspondence map information DB
102, 602: Software BOM 103: Keyword DB
201: XML file 701: Customer XML file

Claims (4)

It is a data extraction method that stores the data extracted from the first data file in the second data file, and stores the correspondence between the item name of the first data file and the item name of the second data file. By referring to the corresponding information file, it is possible to extract the data of the item of the first data file having a name different from the item of the second data file and store it in the second data file. In the data extraction method
The data extracted from the first data file is associated with the item name of the first data file and stored in the save file.
The data extraction request with the second item name of the second data file is accepted, and the first item name of the first data file corresponding to the second item name is acquired from the correspondence information file.
Search the first data file using the first item name as a key, and search for the first data file.
When it is determined in the search that the first item name is not found in the first data file, the first data corresponding to the first item name is acquired from the saved file, and the first item name is obtained. The third item name corresponding to the data of 1 is acquired from the first data file, and the third item name is obtained.
The second item name and the third item name are associated with each other and recorded in the corresponding information file.
Data extraction method. A screen for asking the user to confirm whether to approve the association between the second item name and the third item name in the correspondence information file is displayed.
The data extraction method according to claim 1. When it is determined in the search that the first item name is not found in the first data file, the second item name and the third item name are associated with each other and stored in the saved file. Remember,
The data extraction method according to claim 1 or 2. It is a data extraction program that stores the data extracted from the first data file in the second data file, and stores the correspondence between the item name of the first data file and the item name of the second data file. By referring to the corresponding information file, it is possible to extract the data of the item of the first data file having a name different from the item of the second data file and store it in the second data file. On the computer that runs the data extraction program
The data extracted from the first data file is associated with the item name of the first data file and stored in the save file.
The data extraction request with the second item name of the second data file is accepted, and the first item name of the first data file corresponding to the second item name is acquired from the correspondence information file.
Search the first data file using the first item name as a key, and search for the first data file.
When it is determined in the search that the first item name is not found in the first data file, the first data corresponding to the first item name is acquired from the saved file, and the first item name is obtained. The third item name corresponding to the data of 1 is acquired from the first data file, and the third item name is obtained.
The second item name and the third item name are associated with each other and recorded in the corresponding information file.
A data extraction program that executes processing.

Images