JP2010128892A - Database generation device, database generation method, and computer program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database generation device, a database generation method and a computer program for easily generating a new database including a tabulation result even when tabulation processing is executed by merging a plurality of chart data. <P>SOLUTION: This database generation device is configured; to acquire one or more electronic document files; to store one or more filter condition information for extracting data by record units by setting extraction conditions by database item as filter conditions for executing filtering processing to one or more acquired electronic document file; to accept the selection of one or more filter condition information to be applied to the execution time of filtering processing; to read one or more filter condition information whose selection has been accepted; to execute the filtering processing; to calculate statistics on the basis of the data after the execution of the filtering processing; and to generate a database by summarizing the data after the execution of the filtering processing including the calculated statistics. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a database generation device, a database generation method, and a computer program that can easily generate a new database even when a plurality of table data having different data formats exist.

  When generating a relational database, table data generated in advance is often used. When the database items of the table data match, a new database can be easily generated by merging a plurality of table data.

 However, if the data format of the table data is not standardized, the data format of the table data depends on the creator, and even in the same application, the database items differ depending on the software program used, the database item array There is a difference in order and the like, and it cannot be merged as it is. In order to solve such a problem, conventionally, an intermediate file format is used, which is composed of new table data obtained by merging a plurality of table data having different database items or different database item arrangement orders. Database was generated.

For example, Patent Literature 1 discloses a database management system that generates one database from a plurality of table data via a CSV file that is often used as an intermediate file format for table data.
JP 2006-059135 A

  When a plurality of table data are merged via a CSV file as in Patent Document 1, for example, data for each item cannot be extracted, and therefore, the aggregation processing of data with matching items cannot be executed. . For this reason, usually, filtering processing is performed on the merged database under predetermined conditions to narrow down the total items, and then numerical data corresponding to the narrowed-down total items is totaled.

  However, since the filtering result is output for each filter condition, when performing a complicated aggregation, the filtering process is executed under one filter condition, and the aggregation result is stored in the storage device. There is a problem that processing for obtaining a desired filtering result, such as performing filtering processing again under other filter conditions, becomes complicated. In addition, since it is necessary to add up the totaled results again, it is necessary to repeat the above-mentioned operations for each file, which requires considerable man-hours. There was also.

  The present invention has been made in view of such circumstances, and a database that can easily generate a new database including a totaling result even when a totaling process is performed by merging a plurality of table data. An object of the present invention is to provide a generation device, a database generation method, and a computer program.

  In order to achieve the above object, a database generation device according to a first aspect of the present invention is a database generation device that generates a new database based on data filtered for one or a plurality of electronic document files including table data. An extraction condition is set for each database item as an electronic document file acquisition unit that acquires one or a plurality of the electronic document files and a filter condition for performing filtering processing on the acquired one or a plurality of electronic document files. Filter condition information storage means for storing one or more filter condition information for extracting data in record units, and filter condition information selection receiving means for receiving selection of the one or more filter condition information to be applied when executing the filtering process And one or more fields that accept the selection. Filtering condition means for reading out the data condition information and executing the filtering process, a statistic calculating means for calculating the statistic based on the data after the filtering process is executed, and after the filtering process including the calculated statistic is executed. And database generating means for generating a database by aggregating data.

  In the database generation device according to the second invention, in the first invention, the filter condition information selection accepting means includes the filter condition information in which the extracted record and the record to be displayed are linked, and the extracted record. The selection of the combination with the filter condition information in which each of the records displayed is independent is accepted.

  The database generation device according to a third aspect of the invention is characterized in that, in the first or second aspect of the invention, a statistic sequence adding means for adding a statistic sequence that is a data sequence of the calculated statistic is provided.

  The database generation device according to a fourth aspect of the present invention is the database generation device according to any one of the first to third aspects, wherein the statistic is a percentage, and the database generation means calculates the percentage according to the selection of the filter condition information. The total value used as the denominator is calculated.

  Next, in order to achieve the above object, a database generation method according to a fifth aspect of the present invention is a database generation method for generating a new database based on data obtained by filtering one or a plurality of electronic document files including table data. In the database generation method that can be executed by the apparatus, one or a plurality of the electronic document files are acquired, and a database item is used as a filter condition for performing a filtering process on the acquired one or a plurality of electronic document files. One or a plurality of filter condition information for extracting data in units of records by setting an extraction condition for each record is stored, and selection of one or a plurality of the filter condition information to be applied at the time of executing the filtering process is accepted, and the selection is accepted Read one or more filter condition information and filter It is executed, to calculate the statistics based on data after the execution of the filtering process, and generates a database including the calculated statistic aggregates data after the execution of the filtering process.

  The database generation method according to the sixth invention is the database generation method according to the fifth invention, wherein the filter condition information in which the extracted record and the record to be displayed are linked and the extracted record and the record to be displayed are independent of each other. It is characterized by accepting selection of a combination with the filtering condition information.

  The database generation method according to the seventh invention is characterized in that, in the fifth or sixth invention, a statistic sequence which is a data sequence of the calculated statistic is added.

  The database generation method according to an eighth aspect of the present invention is the database generation method according to any one of the fifth to seventh aspects, wherein the statistic is a percentage and is a denominator for calculating the percentage according to the selection of the filter condition information. A value is calculated.

  Next, in order to achieve the above object, a computer program according to a ninth aspect of the present invention provides a database generation device for generating a new database based on data obtained by filtering one or a plurality of electronic document files including table data In the computer program that can be executed, the database generation device performs electronic document file acquisition means for acquiring one or a plurality of the electronic document files, and performs a filtering process on the acquired one or a plurality of electronic document files Filter condition information storage means for storing one or more filter condition information for setting the extraction condition for each database item and extracting data in units of records as filter conditions for performing, one or more applied at the time of executing the filtering process Selection of filter condition information Filter condition information selection means for accepting, filtering execution means for reading out one or a plurality of the filter condition information accepted for selection, performing filtering processing, and statistics calculating means for calculating statistics based on data after execution of filtering processing And a function of database generation means for generating a database by aggregating data after execution of the filtering process including the calculated statistics.

  The computer program according to a tenth aspect of the present invention is the computer program according to the ninth aspect, wherein the filter condition information selection accepting means is configured such that the filter condition information in which the extracted record and the record to be displayed are linked, the extracted record, It is characterized by functioning as means for receiving selection of a combination with filter condition information that is independent from each other of the displayed records.

  According to an eleventh aspect of the invention, in the ninth or tenth aspect, the computer program causes the database generation device to function as a statistic sequence adding unit that adds a statistic sequence that is a data sequence of the calculated statistic. Features.

  The computer program according to a twelfth aspect of the present invention is the computer program according to any one of the ninth to eleventh aspects, wherein the statistic is a percentage, and the database generation means is configured to calculate a percentage according to the selection of the filter condition information. It is made to function as a means to calculate the total value used as the denominator.

  In the first invention, the fifth invention, and the ninth invention, each database item is acquired as a filter condition for acquiring one or a plurality of electronic document files and executing a filtering process on the acquired one or a plurality of electronic document files. One or a plurality of pieces of filter condition information for extracting data in units of records by setting an extraction condition is stored. A selection of one or a plurality of filter condition information to be applied at the time of executing the filtering process is received, the one or a plurality of filter condition information that has received the selection is read, and the filtering process is executed. A statistic is calculated based on the data after execution of the filtering process, and the database including the calculated statistic is aggregated to generate the database. This is a case where complicated statistics are calculated by accepting selection of appropriate filter condition information from one or a plurality of filter condition information that sets extraction conditions for each database item and extracts data in record units. However, the necessary data can be narrowed down by a single filtering process, and the extracted record and the displayed record do not necessarily need to match, so that it becomes a denominator for calculating the statistics displayed as a percentage. It is possible to calculate the total value and calculate the percentage with respect to the desired denominator.

  In the second invention, the sixth invention, and the tenth invention, the filter condition information in which the extracted record and the record to be displayed are linked and the filter in which the extracted record and the record to be displayed are independent By accepting the selection of the combination with the condition information, it is not limited to the filter condition information that identifies the records displayed according to the extracted records, so when calculating the statistics displayed in percentage In addition, an aggregate value as a denominator can be calculated and displayed separately, and a desired percentage can be calculated simply by executing a filtering process.

  In the third invention, the seventh invention, and the eleventh invention, by adding a statistic sequence that is a data sequence of the calculated statistic, for example, a total value that becomes a denominator when calculating a percentage may be included in the database. The percentage can be calculated without re-execution of the filtering process.

  In the fourth, eighth and twelfth inventions, the statistic is a percentage, and the percentage is calculated by calculating a total value as a denominator for calculating the percentage according to the selection of the filter condition information. The total value serving as the denominator can be stored in the database, and the percentage can be calculated without re-executing the filtering process.

  According to the present invention, a complicated statistic is calculated by accepting selection of appropriate filter condition information from one or a plurality of filter condition information that sets extraction conditions for each database item and extracts data in units of records. Even in this case, the necessary data can be narrowed down by a single filtering process, and the extracted records and the displayed records do not necessarily need to match, so the statistics displayed as a percentage are calculated. It is possible to calculate a total value as a denominator and calculate a percentage with respect to a desired denominator.

  Hereinafter, a database generation device according to an embodiment of the present invention will be specifically described with reference to the drawings. The following embodiments do not limit the invention described in the claims, and all combinations of characteristic items described in the embodiments are essential to the solution. It goes without saying that it is not limited.

  The present invention can be implemented in many different modes and should not be construed as being limited to the description of the embodiment. The same symbols are attached to the same elements throughout the embodiments.

  In the following embodiment, a database generation apparatus in which a computer program is introduced into a computer system will be described. However, as will be apparent to those skilled in the art, the present invention is a computer program that can be partially executed by a computer. Can be implemented. Therefore, the present invention can take an embodiment of hardware as a database generation device, an embodiment of software, or an embodiment of a combination of software and hardware. The computer program can be recorded on any computer-readable recording medium such as a hard disk, DVD, CD, optical storage device, magnetic storage device or the like.

  FIG. 1 is a block diagram illustrating a configuration example of a database generation device according to an embodiment of the present invention. The database generation device 1 according to the embodiment of the present invention includes at least a CPU (Central Processing Unit) 11, a memory 12, a storage device 13, an I / O interface 14, a video interface 15, a portable disk drive 16, a communication interface 17, and The internal bus 18 connects the hardware described above.

  The CPU 11 is connected to the above-described hardware units of the database generation device 1 via the internal bus 18, controls the operation of the above-described hardware units, and stores the computer program 100 stored in the storage device 13. Various software functions are executed according to the above. The memory 12 is composed of a volatile memory such as SRAM or SDRAM, and a load module is expanded when the computer program 100 is executed, and stores temporary data generated when the computer program 100 is executed.

  The storage device 13 includes a built-in fixed storage device (hard disk), a volatile memory such as SRAM, and a nonvolatile memory such as ROM. The computer program 100 stored in the storage device 13 is downloaded by a portable disk drive 16 from a portable recording medium 90 such as a DVD or CD-ROM in which information such as programs and data is recorded. To the memory 12 and executed. Of course, a computer program downloaded from an external computer connected to the network 2 via the communication interface 17 may be used.

  The storage device 13 includes an electronic document file storage unit 131, a filter condition information storage unit 132, and a database storage unit 133. The electronic document file storage unit 131 stores an electronic document file that includes table data and serves as a basis for generating a new database.

  The filter condition information storage unit 132 stores one or a plurality of filter condition information indicating a filter condition for performing a filtering process on the acquired one or more electronic document files. The filter condition information to be stored is stored in association with identification information for identifying the filter condition, for example, a filter condition name, and one or a plurality of filter condition information can be applied in units of records.

  The database storage unit 133 stores a database newly generated by merging table data included in a plurality of electronic document files.

  The communication interface 17 is connected to an internal bus 18 and can transmit and receive data to and from an external computer or the like by connecting to an external network 2 such as the Internet, LAN, or WAN. The electronic document file storage unit 131 is not limited to be provided in the storage device 13 of the database generation device 1 and may be scattered on the network 2 by being stored in a storage device of an external computer. .

  The I / O interface 14 is connected to a data input medium such as a keyboard 21 and a mouse 22 and receives data input. The video interface 15 is connected to a display device 23 such as a CRT monitor or LCD, and displays a predetermined image.

  FIG. 2 is a functional block diagram of the database generation device 1 according to the embodiment of the present invention. The electronic document file acquisition unit 201 acquires an electronic document file including one or more table data. The electronic document file may be read from the electronic document file stored in the electronic document file storage unit 131 of the storage device 13 or may be read from an external computer via the network 2. Further, input may be received via an input device such as a keyboard 21 and a mouse 22. When the electronic document file is stored in the electronic document file storage unit 131 of the storage device 13, the electronic document file may be stored in the file format as it is, or from the table data of one or a plurality of electronic document files in advance. By creating a database by extracting the data and reading the data from the generated database as table data, the table data of one or more electronic document files can be substantially read out. You may do it.

  The filter condition information selection accepting unit 202 executes the filtering process from one or a plurality of filter condition information indicating the filter condition for executing the filtering process stored in the filter condition information storage unit 132 of the storage device 13. Accept selection of filter condition information to apply. Filter condition information means information related to the conditions to be applied when executing the filtering process to narrow down the table data, and the filter condition information in which the extracted record and the record to be displayed are linked and extracted. This is a broad concept including both the filter condition information in which the recorded record and the displayed record are independent of each other. The selection of the filter condition information is accepted by, for example, a click operation with the mouse 22 or a key-in operation with the keyboard 21.

  The filtering execution unit 203 reads one or more pieces of filter condition information that has received the selection, and executes a filtering process. The statistic calculation unit 204 calculates a statistic such as a total, an average, and a standard deviation based on the data after execution of the filtering process.

  The database generation unit 205 generates a database by aggregating data after execution of the filtering process including the calculated statistics. Further, the statistic column adding unit 206 adds a statistic column indicating the calculated statistic to the database when the database generating unit 205 generates the database. By adding a statistic column, for example, by creating a database including a total column indicating the total, a statistic including other percentages can be easily calculated.

  FIG. 3 is a flowchart showing a database generation process procedure of the CPU 11 of the database generation apparatus 1 according to the embodiment of the present invention. In FIG. 3, the CPU 11 of the database generation apparatus 1 acquires an electronic document file including one or more table data (step S301). The electronic document file may be read from the electronic document file stored in the electronic document file storage unit 131 of the storage device 13 or may be read from an external computer via the network 2. Further, input may be received via an input device such as a keyboard 21 and a mouse 22.

  The CPU 11 stores the filter condition information to be applied at the time of executing the filtering process from one or a plurality of filter condition information indicating the filter condition for executing the filtering process stored in the filter condition information storage unit 132 of the storage device 13. The selection is accepted (step S302). Filter condition information means information related to the conditions to be applied when executing the filtering process to narrow down the table data, and the filter condition information in which the extracted record and the record to be displayed are linked and extracted. This is a broad concept including both the filter condition information in which the recorded record and the displayed record are independent of each other. The selection of the filter condition information is accepted by, for example, a click operation with the mouse 22 or a key-in operation with the keyboard 21. The selection of the filter condition information is not limited to the electronic document file unit, but may be a sheet unit included in the electronic document file or a record unit included in the sheet.

  The CPU 11 reads out one or a plurality of filter condition information whose selection has been accepted, and executes a filtering process on the acquired electronic document file (step S303). Since a plurality of filter condition information can be applied to one electronic document file, a desired filtering result can be obtained. Further, it is not always necessary to display the data extracted by executing the filtering process as display data. Therefore, selection of a plurality of filter condition information can be received, and a filtering result based on each filter condition information can be obtained independently.

  The CPU 11 calculates a statistic such as a total, an average, and a standard deviation based on the data after execution of the filtering process (step S304). Based on the filtering results based on multiple filter condition information, the total can be calculated for the predetermined filtering results, and other statistics can be calculated for the other filtering results, and used when calculating the percentage of content, etc. Can do.

  The CPU 11 aggregates the data after the filtering process including the calculated statistics (step S305). Note that, at the time of data aggregation, a statistics column indicating the calculated statistics may be added to form a database. For example, by calculating a database that includes a total column that indicates the total, and calculating the statistics that include the content rate and other percentages, the conventional filtering process also narrows down the total that is the basis of the calculation in turn, Based on the filter condition information, a total column that becomes a denominator of percentage calculation can be incorporated into a plurality of table data, so that a desired denominator can be selected according to the percentage to be calculated.

  CPU11 judges whether the production | generation instruction | indication which updates a database and produces | generates a new database was received (step S306). When the CPU 11 determines that the generation instruction has not been received (step S306: NO), the CPU 11 returns the process to step S302 and repeats the above-described process. If the CPU 11 determines that a generation instruction has been received (step S306: YES), the CPU 11 generates a new database based on the aggregated data and stores it in the database storage unit 133 (step S307).

  Hereinafter, based on the screen image displayed on the display device 23, a specific procedure for generating a database will be described. FIG. 4 is a view showing an example of a filtering processing operation screen that displays a list of contents stored in the database according to the embodiment of the present invention.

  In the example of FIG. 4, the filtering processing operation screen includes information for identifying an electronic document file to be filtered, for example, an electronic document file name display area 41 for displaying an electronic document file name, and a plurality of sheets in the electronic document file. When included, information for identifying a sheet to be subjected to filtering processing, for example, a sheet name display area 42 for displaying a sheet name, an item information display area 43 for displaying sheet item information, and a data string for each item are displayed. The data string display area 44 is configured. In addition, various operation buttons are arranged in the operation designation area 40 in which the operation buttons in the filtering process are collected.

  When the “filter condition setting” button 45 is selected with the mouse 22 or the like, a filter condition setting screen in which filter condition information can be set in a pop-up window or the like is displayed. FIG. 5 is a view showing an example of a filter condition setting screen according to the embodiment of the present invention.

  The filter condition setting screen shown in FIG. 5 is an example of a screen for setting a sub-hierarchy to be narrowed down when the item portion is configured in a hierarchy. The filter target item setting area 51 receives an input of a database item name that is a target of filtering processing. The input of the database item name is accepted by a copy and paste operation with the mouse 22, a key-in operation with the keyboard 21, or the like.

  The narrowing target item setting area 52 is a check box for checking the sub item name to be narrowed down. The displayed sub item name varies according to the database item name input in the filtering target item setting area 51. A check input to the check box is accepted by a click operation with the mouse 22.

  When the “clear all” button 53 is selected by the mouse 22 or the like, all the check boxes in the narrowing target item setting area 52 are cleared. When the “Cancel” button 55 is selected with the mouse 22 or the like, the screen returns to the filtering processing operation screen. When the “OK” button 54 is selected by the mouse 22 or the like, the screen is switched to the filter condition saving screen. FIG. 6 is a view showing an example of a filter condition saving screen according to the embodiment of the present invention.

  The filter condition saving screen shown in FIG. 6 is displayed in a pop-up window or the like even when the “filter condition saving” button 46 is selected by the mouse 22 or the like on the filtering processing operation screen shown in FIG. The filter condition input area 61 receives an input of a filter condition name for identifying as a filter condition.

  When the “Cancel” button 63 is selected with the mouse 22 or the like, the input filter condition name is canceled and the screen returns to the filtering processing operation screen. When the “OK” button 62 is selected with the mouse 22 or the like, the input filter condition name is stored in the filter condition information storage unit 132 in association with the filter condition information for executing the filtering process, and the filtering process operation screen is displayed. Return to.

  Returning to FIG. 4, when the “filter condition selection” button 47 is selected by the mouse 22 or the like, a filter condition selection screen for selecting filter condition information to be applied is displayed in a pop-up window or the like. FIG. 7 is an exemplary view of a filter condition selection screen according to the embodiment of the present invention.

  The filter condition selection screen shown in FIG. 7 accepts selection of one filter condition information from the filter condition information stored in the filter condition information storage unit 132. In the example of FIG. 7, the filter condition designation area 71 is a pull-down menu, and the selection of filter condition information to be selected is accepted by the mouse 22 or the like.

  When the “Cancel” button 73 is selected with the mouse 22 or the like, the filter condition information accepted for selection is canceled and the screen returns to the filtering processing operation screen. When the “OK” button 72 is selected with the mouse 22 or the like, the filter condition information for which the selection has been accepted is applied to the database whose contents are currently displayed on the filtering processing operation screen.

  FIG. 8 is a view showing an example of a total display screen according to the embodiment of the present invention. In the example of FIG. 8, when the “total display” button 48 is selected with the mouse 22 or the like, a total display area 81 is additionally displayed. In the total display area 81, total items for calculating the total of each database item are added.

  The total item is not limited to the item for calculating the total. When the “add total item” button 82 is selected with the mouse 22 or the like, a total item setting screen for setting the total item to be added is displayed. FIG. 9 is a view showing an example of a total item setting screen according to the embodiment of the present invention.

  In FIG. 9, the total item name display area 91 accepts input of the total item name to be added. The filter condition designation area 92 is a pull-down menu, and accepts selection of a filter condition name to be applied by the mouse 22 or the like.

  The target item designation area 93 is a pull-down menu, and accepts selection of a database item to be aggregated with the mouse 22 or the like. A totaling unit setting area 94 is a pull-down menu, and a mouse is used to select a unit to be totaled, for example, whole data included in a plurality of electronic document files, a book (multiple sheets) unit included in one electronic document file, a sheet unit, and the like. 22 or the like. The tabulation content setting area 95 is a pull-down menu, and accepts selections such as tabulation content, for example, obtaining an average, obtaining a minimum value, obtaining a maximum value, and obtaining a standard deviation, with the mouse 22 or the like. When the “cancel” button 97 is selected with the mouse 22 or the like, the accepted selection is canceled. When the “OK” button 96 is selected by the mouse 22 or the like, the screen is switched to the total display screen.

  FIG. 10 is a view showing an example of the contents of a database when the component content of a part is obtained. In the example of FIG. 10, “Product name”, “Part manufacturer”, “Part name”, “Part mass (g)”, “Content specific substance”, and “Content rate” are set as the database items, and totaling is performed. “Total 1” and “Total 2” are prepared as items, and “Calculation 1” is prepared as a calculation item.

  “Total 1” is a total item linked to the filter condition information at the time of executing the filtering process, and totals each product of the part mass × content rate. “Total 2” is an independent total item that is not linked to the filter condition information at the time of executing the filtering process, and totals the parts mass for each product. “Calculation 1” represents total 1 / total 2 as a percentage.

  For example, if the filter condition information is information that narrows down to “Cu” as “included specific substance”, it is narrowed down to product names that include “Cu”. FIG. 11 is an exemplary diagram of the contents of the database when narrowed down to “Cu”.

  When the conventional filtering process is executed, it is possible to narrow down to products including “Cu” in the same manner, but the value of “total 2” fluctuates. That is, since it is linked with the filter condition information at the time of executing the filtering process, the total of the parts mass for each product is totaled using only the data corresponding to the narrowed products. Therefore, when calculating the “Cu” content rate for each product, a correct value cannot be obtained because the denominator is not the part mass of the entire product.

  On the other hand, in the embodiment of the present invention, “Total 2” is independent of the filter condition information at the time of executing the filtering process and is independent. However, the value of “Total 2”, which is the mass of parts of the entire product, has not changed. Therefore, the “Cu” content rate for each product can be calculated correctly.

  Similarly, if the filter condition information is information that narrows down to “Ag” as “included specific substance”, the product name including “Ag” is narrowed down. FIG. 12 is an exemplary diagram of the contents of the database when narrowed down to “Ag”.

  When the conventional filtering process is executed, it is possible to narrow down to products including “Ag” in the same manner, but the value of “total 2” fluctuates. That is, since it is linked with the filter condition information at the time of executing the filtering process, the total of the parts mass for each product is totaled using only the data corresponding to the narrowed products. Therefore, when calculating the “Ag” content rate for each product, a correct value cannot be obtained because the denominator is not the part mass of the entire product.

  On the other hand, in the embodiment of the present invention, since “Total 2” is independent of the filter condition information at the time of executing the filtering process, it is independent of the product including “Ag”. It can also be seen that the value of “Total 2”, which is the part mass of the entire product, has not changed. Therefore, the “Ag” content rate for each product can be calculated correctly.

  As described above, according to the present embodiment, by selecting selection of appropriate filter condition information from one or a plurality of filter condition information that sets extraction conditions for each database item and extracts data in record units, Even when calculating statistical statistics, the necessary data can be narrowed down by a single filtering process, and the extracted records do not necessarily match the displayed records, so they are displayed as a percentage. It is possible to calculate and display a percentage with respect to a desired denominator by calculating a total value that serves as a denominator for calculating the statistic.

  The present invention is not limited to the above-described embodiments, and various changes and improvements can be made within the scope of the present invention. For example, the operation via the screen image is not limited to the operation using the mouse 22 or the like, and may be an operation with a finger using a touch panel or the like, for example. Further, the screen configuration and arrangement are not particularly limited as long as the same function can be secured.

It is a block diagram which shows the structural example of the database production | generation apparatus which concerns on embodiment of this invention. It is a functional block diagram of the database production | generation apparatus which concerns on embodiment of this invention. It is a flowchart which shows the procedure of the database production | generation process of CPU of the database production | generation apparatus which concerns on embodiment of this invention. It is an illustration figure of the filtering process operation screen which displays the list memorize | stored in the database which concerns on embodiment of this invention. It is an illustration figure of the filter condition setting screen which concerns on embodiment of this invention. It is an illustration figure of the filter condition preservation | save screen which concerns on embodiment of this invention. It is an illustration figure of the filter condition selection screen which concerns on embodiment of this invention. It is an illustration figure of the total display screen which concerns on embodiment of this invention. It is an illustration figure of the total item setting screen which concerns on embodiment of this invention. It is an illustration figure of the content of the database in the case of calculating | requiring the component content of components. It is an illustration figure of the content of the database at the time of narrowing down to "Cu". It is an illustration figure of the content of the database at the time of narrowing down to "Ag".

Explanation of symbols

1 Database generator 2 Network 11 CPU
12 memory 13 storage device 14 I / O interface 15 video interface 16 portable disk drive 17 communication interface 18 internal bus 23 display device 90 portable recording medium 100 computer program 131 electronic document file storage unit 132 filter condition information storage unit 133 database storage Part

Claims (12)

In a database generation device that generates a new database based on data filtered for one or a plurality of electronic document files including table data,
Electronic document file acquisition means for acquiring one or more electronic document files;
Stores one or more filter condition information for extracting data in record units by setting an extraction condition for each database item as a filter condition for executing filtering processing on one or more acquired electronic document files Filter condition information storage means;
Filter condition information selection accepting means for accepting selection of one or a plurality of the filter condition information to be applied when executing the filtering process;
Filtering execution means for reading out one or a plurality of filter condition information for which selection has been accepted and executing filtering processing;
A statistic calculation means for calculating a statistic based on data after execution of the filtering process;
A database generation device comprising: database generation means for generating a database by aggregating data after execution of filtering processing including the calculated statistics.   The filter condition information selection accepting means includes filter condition information in which the extracted record and the record to be displayed are linked, and filter condition information in which the extracted record and the record to be displayed are independent from each other. 2. The database generation apparatus according to claim 1, wherein selection of a combination is accepted.   The database generation apparatus according to claim 1, further comprising a statistic sequence adding unit that adds a statistic sequence that is a data sequence of the calculated statistic. The statistic is a percentage;
The database according to any one of claims 1 to 3, wherein the database generation unit calculates a total value as a denominator for calculating a percentage in accordance with the selection of the filter condition information. Generator. In a database generation method that can be executed by a database generation device that generates a new database based on data filtered in one or a plurality of electronic document files including table data,
Obtaining one or more electronic document files;
Stores one or more filter condition information for extracting data in units of records by setting an extraction condition for each database item as a filter condition for performing filtering processing on one or more acquired electronic document files ,
Receiving selection of one or a plurality of the filter condition information to be applied at the time of executing the filtering process;
Read out one or more filter condition information that has received the selection, execute the filtering process,
Calculate the statistics based on the data after the filtering process,
A database generation method characterized in that a database is generated by aggregating data after execution of filtering processing including calculated statistics.   It is characterized by accepting a selection of a combination of filter condition information in which the extracted record and the displayed record are linked, and filter condition information in which the extracted record and the displayed record are independent from each other. The database generation method according to claim 5.   7. The database generation method according to claim 5 or 6, wherein a statistics string that is a data string of the calculated statistics is added. The statistic is a percentage;
8. The database generation method according to claim 5, wherein an aggregate value that is a denominator for percentage calculation is calculated according to the selection of the filter condition information. 9. In a computer program that can be executed by a database generation device that generates a new database based on data subjected to filtering processing on one or a plurality of electronic document files including table data,
The database generation device;
Electronic document file acquisition means for acquiring one or more electronic document files;
Stores one or more filter condition information for extracting data in record units by setting an extraction condition for each database item as a filter condition for executing filtering processing on one or more acquired electronic document files Filter condition information storage means,
Filter condition information selection accepting means for accepting selection of one or a plurality of the filter condition information to be applied when executing the filtering process;
Filtering execution means for reading out one or a plurality of filter condition information accepted for selection and executing filtering processing;
Functions as a statistic calculation unit that calculates a statistic based on data after execution of filtering processing, and a database generation unit that aggregates data after execution of filtering processing including the calculated statistic and generates a database A computer program characterized by the above.   The filter condition information selection accepting means includes: filter condition information in which the extracted record and the displayed record are linked, and filter condition information in which the extracted record and the displayed record are independent from each other. The computer program according to claim 9, wherein the computer program functions as means for receiving selection of a combination. The database generation device;
The computer program according to claim 9 or 10, wherein the computer program is made to function as a statistic sequence adding means for adding a statistic sequence which is a data sequence of the calculated statistic. The statistic is a percentage;
12. The computer according to claim 9, wherein the database generation unit functions as a unit that calculates an aggregate value that serves as a denominator for percentage calculation according to the selection of the filter condition information. program.

Images