JP3998022B2 - Data aggregation display device and recording medium - Google Patents

Description

The present invention relates to a data aggregation display device that facilitates classification and aggregation from a tabulation table composed of a plurality of item data to desired item data, and a recording medium for storing the processing program.

  Conventionally, for example, office computers and general-purpose computers mainly for office work use various application programs such as spreadsheets and databases, and are used for accounting tables in various formats in accounting operations. .

  The various types of summary tables created using this application program are configured based on a variety of various item data. By changing the description formulas that set the aggregation conditions for the item data to be aggregated, The user can change the total content to a desired classification format.

  However, in a summary table created using such a conventional application program, the user desires the summary content by changing the description formula in which the summary condition of the item data to be aggregated is set. Although it was possible to change to the format, the screen operation until reaching the screen to change the description formula is complicated, and it is also necessary for beginners to understand and change the description contents of the description formula There was a problem that was difficult.

  In addition, since the conventional summary table displays all record data in the database as a whole in a tabular format, in order to instruct classification / aggregation with the desired aggregation item, in addition to changing the description formula above, the category / aggregation item A plurality of complicated operations such as calling various sub-windows for designating an item are necessary, and there is a problem that it takes time and effort to obtain a result of classification and aggregation of a desired aggregation item.

  An object of the present invention is to facilitate the operation and processing when classifying and counting the total content of a total table into a desired total item.

The data summary display device of the present invention includes a database storage means for storing a record composed of key items and data items, and an analysis that classifies the key items into a plurality of groups and defines the upper and lower hierarchical relationships of the key items in each group. Analysis table storage means for storing a table, summary table display means for displaying data classified and aggregated by the selected key item in a table format, and key items for each group based on the analysis table as X-axis direction a key item display means for respectively displayed on the Y-axis direction, when the displayed key item is selected operations to identify the selected key item data by classifying the records by the key field The totalizing means for summing up and the data of the result of the classification and summing are displayed in a tabular format by the totalizing display means, and the group of the selected key item is displayed. And display control means for displaying by the key item display means key fields of the lower layer a-loop, the X-axis, in either one axis in the Y-axis, the key items that are specified in the other axis Is selected, the classification and aggregation means exchanges the key items designated by the X axis and the Y axis, and records the records in the X axis direction and the Y axis direction by the exchanged key items. Is classified and tabulated, and the tabulated result is output.

According to the data totaling display device of the present invention, when classifying and summarizing records in a database, the key items hierarchized by group are displayed separately in the two-dimensional direction of the X axis and the Y axis so as to be selected. In addition, by operating the selection buttons corresponding to the two-dimensionally arranged key items, it is possible to easily specify and change the axis direction for classification and aggregation.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  1 to 18 are diagrams showing an embodiment of a computer system to which the present invention is applied.

  First, the configuration will be described.

  FIG. 1 is a block diagram showing a main configuration of a computer system 1 according to the present embodiment. In FIG. 1, a computer system 1 includes a CPU 2, an input device 3, a RAM 4, a display device 5, a printing device 6, a storage device 7, and a storage medium 8. It is connected.

  A CPU (Central Processing Unit) 2 expands a system program stored in the storage device 7 and application programs designated from various application programs corresponding to the system to a program storage area (not shown) in the RAM 6, Various instructions or data input from the input device 3 are temporarily stored in the RAM 6, various processes are executed in accordance with the application program stored in the storage device 7 in accordance with the input instructions and input data, and the processing results Is stored in the RAM 6 and displayed on the display device 5. Then, the processing result stored in the RAM 6 is stored in the storage destination in the storage device 7 instructed to be input from the input device 3.

  In addition, the CPU 2 executes data analysis processing related to a summary table, which will be described later, reads a processing target database record designated from the database stored in the storage device 7, and analyzes each summary item set in this database record. Set a hierarchical structure that associates aggregated items by grouping them by key items, sets index key items and data item names to be analyzed in the record format of the analysis database described later, and sets analysis key and calculation items described later. Set the analysis key items and calculation items for each group in the record format, and display on the display device 5 an analysis browser screen in which selection buttons for classification and aggregation are arranged in the row direction and the column direction based on the analysis key items. The database can be easily reduced by simply operating the selection button for classification and aggregation. To facilitate the classification aggregation processing of the definitive summary fields.

  Then, the CPU 2 stores the selection state of the key item selected on the analysis browser screen in the selection state table 4a stored in the RAM 4, and the selection item data is grouped in the extraction condition table 4c stored in the RAM 4 for each group. The range of the data record to be analyzed is specified, and the hierarchy designation state for each key item group is stored in the group-specific hierarchy designation state table 4b stored in the RAM 4.

  Further, the CPU 2 executes a group hierarchy display process, which will be described later, and color-codes each key item selected on the analysis browser screen based on the stored contents of the extraction condition table 4c so that the selected hierarchy can be recognized for each group. The group-specific hierarchical display frames are displayed on the display device 5 and the selection key items stored in the selection state table 4a are highlighted in the group-specific hierarchical display frames to display the reduced aggregated items hierarchically by group. To do.

  Furthermore, the CPU 2 executes an item arrangement process to be described later to determine the arrangement method of the database record developed by the data analysis process, and displays a selection screen for selecting the item arrangement method on the display device 5. As the item arrangement method, for example, when one horizontal row, one vertical column, or multiple rows are selected, the arrangement position of the items in the database developed based on the item arrangement method is set, and all records are expanded. The arrangement direction of the summary items can be easily changed.

  The input device 3 includes a cursor key, a numeric input key, various function keys, and the like, and outputs a pressed signal of a pressed key to the CPU 2.

  A RAM (Random Access Memory) 4 forms a memory area for developing various data when the CPU 2 executes the various application programs, and the selection state table is used as a table used in the data analysis processing executed by the CPU 2. 4a, a group-specific hierarchy designation state table 4b, and an extraction condition table 4c are formed. Specific examples of the selection status table 4a, the group-specific hierarchy designation status table 4b, and the extraction condition table 4c are shown in FIG.

  FIG. 2A shows a selection state table 4a, which stores each key item (row direction: x axis, column direction: column direction) selected on the analysis browser screen. . FIG. 5B shows a group-specific hierarchy designation state table 4b. In this group-specific hierarchy designation state table 4b, the number of hierarchies currently selected for each group corresponding to each key item selected in the analysis browser screen is displayed. Remembered. FIG. 5C shows an extraction condition table 4c. In the extraction condition table 4c, each key item selected on the analysis browser screen is stored for each corresponding group.

  The display device 5 is configured by a CRT (Cathode Ray Tube) or the like, and displays display data input from the CPU 2. The printing device 6 prints and outputs print data (record data of a summary table, etc.) input from the CPU 2 on a predetermined recording sheet.

  The storage device 7 has a storage medium 8 in which programs, data, and the like are stored in advance, and the storage medium 8 is configured by a magnetic or optical recording medium or a semiconductor memory. The storage medium 8 is fixedly attached to the storage device 7 or is detachably mounted. The storage medium 8 includes the system program, various application programs corresponding to the system, a data analysis processing program, A slice button processing program, a group hierarchy display processing program, an item arrangement processing program, and data processed by each processing program are stored.

  Further, the program, data, and the like stored in the storage medium 8 may be configured to be received and stored from other devices connected via a communication line or the like, and further connected via a communication line or the like. Another apparatus may be provided with a storage device including the storage medium, and the program and data stored in the storage medium 8 may be used via a communication line.

  Further, in the storage medium 8, the analysis key items which are the total items set in the database record to be processed by the data analysis processing executed by the CPU 2 are shown as index key items and data item names to be analyzed as shown in FIG. It is set and stored in the record format of the analysis database shown in (a). In the record format of the analysis database shown in FIG. 3A, “item, genre, product, sales office, business partner, year, month, year / month” is set as an analysis key item in the index key column. “Sales” is set in the data item name column as the analysis data item name corresponding to the index key item.

  Furthermore, in the storage medium 8, the analysis key items grouped from the total items set in the database record to be analyzed by the data analysis process executed by the CPU 2 and the calculation items are shown in FIG. It is set and stored in accordance with the analysis key to be shown and the record format of the calculation item. In the analysis key and calculation item record format shown in FIG. 3B, the grouped branch key items are set in the analysis key column for each hierarchy. The grouping is "item, department, business partner, date", the item analysis group is "item, genre, product", the department analysis group is "sales office, person in charge", and the business partner analysis group Each customer has an analysis key item set for each hierarchy, and “Year / Year / Month” is set for each hierarchy. In addition, the calculation contents “# aggregate (), # composition ratio ()” corresponding to “sales, composition ratio” are set in the calculation item column as calculation items, and the record format of this analysis key and calculation items is tabulated. And stored in the storage medium 8.

  Next, the operation of the present embodiment will be described.

  First, the data analysis processing executed by the CPU 2 will be described based on the flowcharts shown in FIGS.

  In FIG. 4, first, the CPU 2 causes the display device 5 to display a database designation screen that prompts designation of a database to be analyzed, and when the database to be analyzed is designated (step S1), the designation is made. It is determined whether or not an analysis key having a format corresponding to the database and a record format table of calculation items are set in the storage medium 8 (step S2). If it has been set, the process proceeds to step S4. If it has not been set, the grouping setting of the analysis key item and the calculation item are set from the aggregation item set in the designated database, and FIG. ) And stored in the storage medium 8 as a record format table of analysis keys and calculation items (step S3).

  Next, select buttons corresponding to the number of groups of analysis key items set in the record format table of analysis keys and calculation items are displayed in the analysis browser screen configuration in the vertical axis (y axis: row direction) and horizontal axis (x axis: column). It is expanded in the RAM 4 so as to be arranged in the direction (step S4). Then, the 0th hierarchy is set in each of the groups A to D of the group-specific hierarchy designation state table 4b shown in FIG. 2B stored in the RAM 4 (step S5).

  In step S4, the analysis button item name (item, sales office, business partner, year) is set to the selection buttons arranged on the vertical and horizontal axes in the analysis browser screen configuration, and the analysis browser is displayed on the display device 5. A screen is displayed (step S6). Next, the calculation item data is calculated for all the records in the specified database, that is, the calculation item “sales” set in the analysis key and the calculation item record format table shown in FIG. , “Composition ratio” is calculated for all records (step S7), and displayed in a tabular format in the analysis browser screen (step S8).

  An example of the top screen of the analysis browser displayed on the display device 5 by the processing of steps S4 to S8 is shown in FIG. In the top screen of the analysis browser shown in FIG. 6, each selection button arranged in the row direction (y axis) and the column direction (x axis) has an analysis of the 0th hierarchy grouped from the specified database. The key item “item, sales office, business partner, year” is set, and the calculation item “sales, composition ratio” is displayed in a table format.

  Next, in the top screen of the analysis browser shown in FIG. 6, it is determined whether or not the selection button operation in the row direction or the column direction has been operated (step S9), and when the selection button is operated, the operated row direction or column direction is determined. The key item set to the selection button is specified as a selection key, and this specified selection key item is stored in the selection state table 4a of FIG. 2A stored in the RAM 4 (step S10). Then, +1 is updated for the group in the group-specific hierarchy designation state table 4b to which the selected key item corresponds (step S11).

  The records in the database are classified for each selection key item specified in step S10 (step S12), the data of the calculation item is calculated for each classification (step S13), and the analysis browser screen is displayed in the table format for each classification. Displayed (step S14). FIG. 7 shows an example of the analysis browser screen displaying the result of classifying and calculating records in the database for each selection key item. In the analysis browser screen shown in FIG. 7, the “item” key is selected as the row digging key on the top screen of the analysis browser shown in FIG. 6, the digging process is executed, and “calculator” and “clock” are selected as the items. ”Shows the case where the result of calculating the“ sales ”and“ composition ratio ”by classifying records for each“ is displayed in a table format.

  Further, in the analysis browser screen shown in FIG. 7, as a result of selecting “item” as the row digging key in the analysis browser screen of FIG. 6, the group to which “item” corresponds is displayed in the digging key display area of that row. The analysis key item “Genre” of the first hierarchy that is one level lower than the 0th hierarchy “item” is displayed as a selection button, and the “item” selection button on the column side is selected in the drill key display area of that column As a result, the “item” selection button is deleted. Further, in the analysis browser screen shown in FIG. 7, item buttons that can be selected and operated are also set in each item portion of “calculator” and “clock” displayed in the item column in a table format.

  Next, in the analysis browser screen in which the database as shown in FIG. 7 is classified by the selected drilling item and the calculation result is displayed in a table format, the operation of the selection button or the table in the row and column drilling key display area is displayed. It is determined whether or not an item button is operated in the format display area (step S15). When the button is operated, it is determined whether or not the selected button of the analysis key item in the row and column digging key display area is operated (step S16). If the analysis key item selection button is operated, the process proceeds to step S18. If the analysis key item selection button is not operated and the item button in the table is selected, the selected item data is stored. The extraction condition table 4c of FIG. 2 (c) stored in the RAM 4 stores the key item data (step S17), and the process returns to the button operation determination process of step S15.

  When the analysis key item selection button is operated, in step S18, the operated analysis key item button is selected, that is, the selected state stored in the selection state table 4a in the processing of step S10. It is determined whether or not the button is on the row side (x axis) or the column side (y axis). If the selected axis button is not operated, the process proceeds to step S27. If the selected axis button is operated, the item data selected by the previous button operation is stored in the extraction condition table 4c. It is checked whether it has been done (step S19). If the selected item data is not stored in the extraction condition table 4c, the process returns to the button operation determination process in step S15. If the selected item data is stored in the extraction condition table 4c, the operated selection button is the same as the selection key item name of the x-axis or y-axis selection button stored in the selection state table 4a. Is checked (step S20).

  When the operated selection button is not the same as the selection key item name stored in the selection state table 4a, the process returns to the process of specifying the selection key item of the operated selection button in step S10. When the operated selection button is the same as the selection key item name stored in the selection state table 4a, it is further determined whether or not the operated selection button is the same axis as the selected axis. Check (step S21). When the operated selection button is not the same axis as the selected axis, the process proceeds to step S26, and when the operated selection button is the same axis as the selected axis, FIG. The analysis key item of the first hierarchy which is the lower hierarchy in the same group set in the analysis key column in the record format table of the analysis key and the calculation item shown in FIG. 6 is specified as a selection key item (step S22).

  Then, the group in the group-specific hierarchy designation state table 4b to which the selected analysis key item corresponds is updated by +1 (step S23), and the stored contents in the selection state table 4a by the selection key item specified in the process of step S22. Is updated (step S24). Then, the record range in the database that matches the extraction condition of the selection key item stored in the extraction condition table 4c is specified (step S25), and the process returns to the process of step S12 and shown in steps S12 to S14. By executing the above process, the records in the database are classified for each selected key item in the specified record range, the data of the calculation item is calculated for each category, and the table for each category is displayed in the analysis browser screen. indicate. FIG. 8 shows an example of an analysis browser screen that displays the result of classifying and calculating records in the database for each selected key item in the specified record range.

  In the analysis browser screen shown in FIG. 8, in the analysis browser screen of FIG. 7, the item “calculator” button in the table format is selected, the “sales office” key is selected as the row digging key, and the digging processing is executed. The table shows the result of calculating “sales” and “composition ratio” by classifying records for each item “calculator” and “sales office”.

  In addition, in the analysis browser screen shown in FIG. 8, as a result of selecting “Sales Office” as the row digging key in the analysis browser screen of FIG. 7, “Sales Office” is included in the digging key display area of that row. The analysis key item “person in charge” in the first hierarchy, which is one level lower than the 0th hierarchy “sales office” of the group to be displayed, is displayed as a selection button. Since the “selection button” is selected, the “sales office” selection button is deleted. Further, in the analysis browser screen shown in FIG. 8, item buttons that can be selected and operated are set in each item portion of “central sales office” and “Shinjuku sales office” displayed in the sales office column in a table format.

  If the operated selection button is not the same axis as the selected axis in step S21, the process proceeds to step S26 to select the x-axis (column direction) and y-axis (row direction) selection buttons. The selection contents of the analysis key item operated in the direction of the axis are reversed in the axial direction, the selection contents of the analysis key item reversed in the axial direction are stored in the selection state table 4a, and the process returns to step S12 to return to step S12. By executing the processing shown in step S14, the records in the database are classified by the analysis key items of the x-axis (column direction) and the y-axis (row direction) stored in the selection state table 4a. Calculate the data of the calculation item and display it in the analysis browser screen in the table format according to the classification.

  The selection contents of the analysis key item for which the x-axis (column direction) and y-axis (row direction) selection buttons are operated are reversed in the axial direction, and the records in the database are classified by the reversed analysis key item in the axial direction. FIG. 9 shows an example of an analysis browser screen in which calculation item data is calculated for each category and displayed in a table format for each category.

  In the analysis browser screen shown in FIG. 9, in the analysis browser screen of FIG. 8, the “Year” key is selected as the key for digging the column, and the digging process is executed. This shows the case where the results calculated by classifying “sales” and “composition ratio” by year for each “office” and “Shinjuku sales office” are displayed in a table format.

  Further, in the analysis browser screen shown in FIG. 9, as a result of selecting “Year” as the row digging key in the analysis browser screen in FIG. 8, the group to which “Year” corresponds is displayed in the digging key display area of the row. The analysis key item “Year / Month” in the first hierarchy, which is one level lower than the 0th hierarchy “Year”, is displayed as a selection button. Since it is selected, the “year” selection button is deleted. In addition, in the analysis browser screen shown in FIG. 9, item buttons that can be selected and operated are also set for each item portion of “1995” and “1996” displayed in the year column in a table format.

  If the operated button is not the button of the selected axis in the process of step S18, the process proceeds to step S27, and the analysis key item set in the operated selection button is the selected axis ( It is determined whether or not the selection button is the same as the selection button in the x-axis or y-axis group. If the analysis key item set for the operated selection button is the same as the group of the selected axis (x axis or y axis), the process returns to the button operation determination process in step S15. If the analysis key item set for the operated selection button is not the same as the group of the selected axis (x-axis or y-axis), the process returns to step S10 to set the operated selection button. The analyzed key item is identified as a selection key.

  Then, the group in the group-specific hierarchy designation state table 4b corresponding to the selected key item is updated by +1 (step S11), and the records in the database are classified by the selected key item specified in step S10 (step S12). ), The calculation item data is calculated for each category (step S13), and displayed in the analysis browser screen in the table format for each category (step S14).

  As described above, by executing the data analysis process, the aggregated items are grouped as analysis key items for the database related to the summary table, and each analysis key item is set in a hierarchical relationship within the corresponding group. By displaying the analysis browser screen in which the divided analysis key items are set as selection buttons for instructing the drilling process and arranged in the row direction (y-axis) and the column direction (x-axis) on the display device 5, the summary table is displayed. The operation when classifying and summarizing to an arbitrary aggregation item can be simplified with only the selection button operation, and the classification and aggregation processing to the aggregation item of the lower hierarchy that is hierarchized by group in the database can be facilitated. .

  Next, when a group other than the analysis key item set in the analysis browser screen is designated by a slice button operation (not shown) in the database displayed in the table format in the analysis browser screen by the data analysis process, The slice button process executed by the CPU 2 will be described based on the flowchart shown in FIG.

  That is, in the above data analysis processing, the case where the records are classified and totaled in the two-dimensional direction of the x-axis and the y-axis by the selection of the selection button of the analysis key item arranged in the analysis browser screen is shown. In this slice button processing, A case will be described in which records are classified and totaled in the three-dimensional direction of the z-axis by designating a group including analysis data not arranged in the analysis browser screen by a slice button operation (not shown).

  In FIG. 10, first, the CPU 2 specifies a group including a selection key item other than the selection key item by operating a slice button (not shown) on the analysis browser screen as shown in FIGS. Step S31) As a data list of key items included in the specified group, for example, a supplier data list sub-window as shown in FIG. 11 is displayed (step S32). When item data is selected in this subwindow (step S33), the selected item data is stored as data of the corresponding key item in the extraction condition table 4c of FIG. 2C (step S34). And the range of the record in the said database which matches the extraction conditions of each selection item data memorize | stored in the extraction condition table 4c is specified (step S35).

  After the range of this record is specified, the process proceeds to step S12 in FIG. 4 and the process shown in steps S12 to S14 is executed, so that the records in the database are selected for each selected key item in the specified record range. Is calculated, and the data of the calculation item is calculated for each category, and displayed in the analysis browser screen in a tabular format for each category.

  Next, a group hierarchy display process executed by the CPU 2 in order to display the selection state of the analysis key item selected in the analysis browser screen in the data analysis process for each group will be described based on the flowchart shown in FIG.

  In FIG. 12, first, the CPU 2 displays a selected button in red among a plurality of selection buttons arranged in the x axis (column direction) on the top screen of the analysis browser shown in FIG. The currently selected button among the plurality of selection buttons arranged in the row direction is displayed in blue (step S41). Next, the content (analysis key item) stored in the extraction condition table 4c in FIG. 2C, that is, the content of the selected analysis key item is displayed in the group-specific display frame as shown in FIG. 13A. (Step S42), among these group display frames, the background of the group display frame including the analysis key item set to the button selected on the x axis is displayed in red, and the button currently selected on the y axis The background of the group display frame including the analysis key item set to “blue” is displayed in blue, and the background of the group display frame including the analysis key item set to the other unselected buttons is displayed in gray (step S43). .

  Next, the selection key item portion stored in the selection state table 4a in FIG. 2A is highlighted (step S44), and the selection key item specified in the slice button process is displayed in yellow (step S44). S45), this group hierarchy display processing is terminated.

  The group-by-group display frame shown in FIG. 13A shows a case where the contents of the analysis key items stored in the extraction condition table 4c are displayed in the four group-by-group display frames of groups 1 to 4. In one display frame, “item (calculator), genre (), product ()” is set as an analysis key item, and since the analysis key item in the group 1 is not selected, the background is displayed in gray, and the group 2 “Sales office (), charge ()” is displayed as an analysis key item in the display frame, and the analysis key item “Sales office ()” in that group 2 is selected on the y-axis side, so the background is blue In addition, the selection key item is highlighted. In addition, “Customer ()” is set as the analysis key item in the group 3 display frame, the analysis key item in the group 3 is not selected, so the background is displayed in gray, and the analysis is displayed in the group 4 display frame. “Year (), Year and month ()” is displayed as the key item, and since the analysis key item “Sales office ()” in the group 4 is selected on the x-axis side, the background is displayed in red, The selection key item is highlighted.

  The group 3 display frame shown in FIG. 5B shows a state in which “(B company)” of the identified supplier is displayed in yellow as a selection key item after the analysis key item is selected by the slice button. Yes.

  Note that the above group hierarchy display process is repeatedly executed every time the selection key item is selected and the slice button is operated in the data analysis process.

  As described above, by executing the group hierarchy display processing, the selection key item selected on the analysis browser screen in the above data analysis processing displays the group-specific hierarchy position, and the analysis data item selection state can be visualized. Can be recognized.

  Next, the item arrangement process executed by the CPU 2 when changing the item arrangement of the database record displayed in the table format in the analysis browser screen in the data analysis process will be described based on the flowchart shown in FIG.

  In FIG. 14, first, the CPU 2 displays a selection window for selecting an item arrangement process on the display device 5 (step S51). A display example of this selection window is shown in FIG. The selection window shown in FIG. 15 shows a case where “display format, rearrangement, warning display, composition ratio, display restriction, item arrangement” is displayed as selectable processing contents.

  When “item placement” is selected by clicking the mouse in this selection window, an item placement window for selecting the item placement method shown in FIG. 15 is displayed (step S52). In the item arrangement window shown in FIG. 15, “placement in one horizontal row, arrangement in one vertical row, arrangement in a plurality of rows” is displayed as the arrangement method of selectable items, and the item number designation frame in one row is displayed. Show.

  When an item arrangement method is selected in this item arrangement window, the selected item arrangement method is determined (step S53). When “Arrange in a horizontal row” is selected as the item arrangement method, the labels of the calculation items in the database are arranged horizontally (step S54), and the calculated data of the calculation items of each record is displayed under the corresponding label. (Step S55). The horizontal arrangement of the total data is repeatedly executed for all the records (step S56), and it is confirmed that the horizontal arrangement of the total data of all the records is completed. Is displayed (step S65), and this item arrangement process is terminated.

  FIG. 18 shows a display example of the database when “arrange in a horizontal row” is selected as the item arrangement method.

  Further, when “arrange vertically” is selected as the item arrangement method, the labels of the calculation items in the database are arranged vertically (step S57), and the total data of the calculation items of each record is displayed next to the corresponding label. Are arranged vertically (step S58). This vertical arrangement of the total data is repeatedly executed for all the records (step S59), and when it is confirmed that the vertical arrangement of the total data of all the records has been completed, each vertical record unit is enclosed in a thick frame line in a tabular format. Is displayed (step S65), and this item arrangement process is terminated.

  FIG. 16 shows a display example of the database when “arrange in a vertical row” is selected as the item arrangement method.

  When “arrange on multiple lines” is selected as the item arrangement method, the number of items to be arranged on one line is designated in the item arrangement window shown in FIG. 15 (step S60), and the items to be arranged on the one line are specified. The number of rows for developing the aggregated data is specified by the number (step S61). Then, the calculation item labels in the database are arranged in a plurality of rows and a plurality of columns based on the specified number of rows (step S62), and the calculation item aggregated data of each record is arranged in a plurality of rows and a plurality at the corresponding label positions. Arrange in a row (step S63). The multiple rows and multiple columns of the aggregated data are repeatedly executed for all records (step S64). When it is confirmed that the multiple rows and multiple columns of the aggregated data of all records are completed, the multiple rows and multiple columns are confirmed. Are displayed in a tabular format in a unit of each record arranged in the table (step S65), and this item arrangement processing is terminated.

  FIG. 17 shows a display example of the database when “arrange on multiple lines” is selected as the item arrangement method.

  As described above, by executing the item arrangement processing, it is possible to easily rearrange the classification and aggregation results of the database displayed in the tabular format on the analysis browser screen in the data analysis processing in an arbitrary item arrangement form. become.

  As described above, in the computer system 1 according to the present embodiment, the aggregated items are grouped as analysis key items for the database related to the summary table, and each analysis key item is set in a hierarchical relationship within the corresponding group. By displaying the analysis browser screen arranged in the row direction (y-axis) and column direction (x-axis) on the display device 5 by setting the grouped analysis key items to the selection buttons for instructing the drilling process, the summary table The operation for classifying and summing the items into arbitrary summation items becomes simple with only the selection button operation, and the classification and summarization processing to the summarization items in the lower hierarchy layered by group in the database can be facilitated.

  Therefore, database classification / aggregation processing with a desired aggregation item that required a change in the description formula describing classification conditions and complicated window operations can be executed with a simple button operation. It is possible to reduce the time and effort of the user required for the classification and aggregation process.

  In the computer system 1 of the present embodiment, by executing the slice button process, it is possible to specify a group including analysis data that is not arranged in the analysis browser screen, and the three-dimensional direction of the z axis. It is easy to classify and aggregate records.

  Furthermore, in the computer system 1 of the present embodiment, by executing the group hierarchy display process, the hierarchy position by group corresponding to the selection key item selected on the analysis browser screen in the data analysis process is displayed and analyzed. The selection state of the data item can be visually recognized.

  In the above data analysis processing, if the same analysis key item is specified on the other axis with respect to the analysis key item specified by the selection button arranged on the x axis or the y axis, the x axis Since the analysis key items specified on the y-axis are exchanged and records can be classified and aggregated by the exchanged analysis key items, the selection button corresponding to the analysis key item placed in the secondary case is operated. By simply doing this, you can easily change and specify the axis direction for classification and aggregation.

  Furthermore, in the computer system 1 of the present embodiment, by executing the item arrangement process, the database classification and tabulation results displayed in the tabular format on the analysis browser screen in the data analysis process are reproduced in an arbitrary item arrangement form. Easy to arrange.

It is a block diagram which shows the principal part structure of the computer system 1 in one embodiment to which this invention is applied. It is a figure which shows the various tables stored in RAM4 of FIG. 1, (a) is a figure which shows the selection state table 4a, (b) is a figure which shows the hierarchy designation | designated state table 4b classified by group, (c) is extraction conditions It is a figure which shows the table 4c. It is a figure which shows the record format set to the storage medium 8 of FIG. 1, (a) is a figure which shows the record format of the database for analysis, (b) is a figure which shows the record format of an analysis key and a calculation item. It is a flowchart which shows a part of data analysis process performed by CPU2 of FIG. It is a flowchart which shows a part of data analysis process following FIG. FIG. 5 is a diagram showing a top screen of an analysis browser displayed on the display device 5 in the data analysis processing of FIG. 4. It is a figure which shows the analysis browser screen displayed on the display apparatus 5 after digging down by the "item" of a line direction in the top screen of the analysis browser of FIG. FIG. 8 is a diagram illustrating an analysis browser screen displayed on the display device 5 after the drilling by “calculator” and “sales office” in the row direction is executed on the analysis browser screen of FIG. 7. FIG. 9 is a diagram showing an analysis browser screen displayed on the display device 5 after the drilling by “year” in the column direction is executed in the analysis browser screen of FIG. 8. It is a flowchart which shows the slice button process performed by CPU2 of FIG. It is a figure which shows the supplier data subwindow displayed on the display apparatus 5 by the slice button process of FIG. It is a flowchart which shows the group hierarchy display process performed by CPU2 of FIG. It is a figure which shows the display content displayed on the display apparatus 5 by the group hierarchy display process of FIG. 12, (a) is a figure which shows group hierarchy display, (b) is a figure which shows the display after slice button selection. It is a flowchart which shows the item arrangement | positioning process performed by CPU2 of FIG. It is a figure which shows the selection screen of the display format displayed on the display apparatus 5 by the item arrangement process of FIG. 14, and an item arrangement method. FIG. 15 is a diagram showing an example of a database record displayed on the display device 5 when a vertical column is selected by the item arrangement process of FIG. 14. FIG. 15 is a diagram illustrating an example of a database record displayed on the display device 5 when a plurality of rows are selected by the item arrangement process of FIG. 14. It is a figure which shows an example of the database record displayed on the display apparatus 5 when one horizontal line is selected by the item arrangement | positioning process of FIG.

Explanation of symbols

1 Computer system 2 CPU
3 Input device 4 RAM
4a Selection state table 4b Hierarchy designation state table 4c by group Extraction condition table 5 Display device 6 Printing device 7 Storage device 8 Storage medium 9 Bus

Claims (3)

Database storage means for storing records consisting of key items and data items;
An analysis table storage means for classifying the key items into a plurality of groups and storing an analysis table that defines a hierarchical relationship of the upper and lower key items in each group;
A summary table display means for displaying in tabular form the data classified and aggregated by the selected key item;
Key item display means for displaying key items for each group in the X-axis direction and the Y-axis direction for each group based on the analysis table;
When the displayed key item is selected operations to identify the selected key item, classification collecting unit to aggregate data by classifying the records by the key field,
Display control means for displaying the data of the classified and aggregated results in a tabular format by the aggregation display means, and displaying the key items in the lower hierarchy that are groups of the selected key items by the key item display means And when the key item designated on the other axis is selected and operated on either one of the X axis and the Y axis, the classification and aggregation means designates the X axis and the Y axis. A data totaling and displaying apparatus characterized in that, by exchanging key items, the records are classified and totaled in the X-axis direction and Y-axis direction by the exchanged key items, and the totaled result is output .   When the key item is selected and operated, the display control means deletes the key item displayed in the X-axis direction or the Y-axis direction corresponding to the selected key item. The data tabulation display device according to claim 1. Computer
Means for storing records consisting of key items and data items;
Means for classifying key items into a plurality of groups and storing an analysis table that defines the hierarchical relationship of the upper and lower key items within each group;
Means to display the data tabulated by the selected key item in tabular form,
Means for displaying key items for each group in the X-axis direction and the Y-axis direction for each group based on the analysis table;
When the displayed key item is selected operations to identify the selected key item, and means to aggregate the data by classifying the records by the key field,
And displays the data of the classification aggregated results tabulated, a program for causing a key field of a lower layer comprising a group of said selection operation key fields as means for displaying by the key item display means When a key item designated on the other axis is selected on either the X axis or the Y axis, the means for counting is designated on the X axis and the Y axis. A computer-readable program that records a program characterized by exchanging key items that are exchanged, classifying and summing the records in the X-axis direction and Y-axis direction according to the exchanged key items, and outputting the summation result Recording medium.

Images