JP2005018454A - Table output program - Google Patents

Abstract

In a display method for a database or the like, there is provided a table output program capable of preventing crying of reference item strings and easily performing item analysis.
A data extraction unit 1300 for acquiring a data table, an input / output unit 1100 for acquiring an input instruction having a plurality of items of items specified for sorting, and a control for changing the order of the data tables according to the input instruction. And a processing unit 1400. By displaying and outputting from the input / output unit 1100 a data table created by changing the column order of the items in the sort order, the comparison item column can be easily viewed and the data analysis can be easily performed. it can.
[Selection] Figure 1

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a table output program for changing a display method of a database or the like.
[0002]
[Prior art]
Conventionally, when a large amount of data stored in a database is displayed and analyzed, a list of two-dimensional tables in which a plurality of related items are arranged in a row and the data of each item are arranged vertically is used. There is a spreadsheet program that can perform comparative examination and analysis.
[0003]
In such a spreadsheet program, for example, bibliographic items of published patent gazettes are listed, and items such as the application date, IPC (international patent classification), and applicant of bibliographic items are displayed in parallel in the column direction. One data is displayed for each line, and it is used for examining the technical fields of competitors, technological trends, patent application trends, and progress of specific technologies.
[0004]
Furthermore, in the spreadsheet program as described above, the column items of the above list are sorted by application date, IPC, applicant, etc., in the row direction of the data, for example, in order of application date, so that the above examination can be easily performed. is doing.
[0005]
However, in such a list, if the item to be examined is a single item, it can be rearranged, but when focusing on multiple items, the other items must be picked up one by one. This work is complicated and difficult to understand at first glance.
[0006]
Therefore, when focusing on two items, a two-dimensional table is created in which one of the focused items is a column item and the other focused item is a row item (see, for example, Patent Document 1). ).
[0007]
A configuration diagram of such a table creation system will be described with reference to FIG. As shown in FIG. 22, the conventional table creation system includes an input unit 1, an instruction table 2, and a multidimensional table creation unit 3.
[0008]
The user instructs the input unit 1 to place an object stored in the database 4 in the n-dimensional area, column header area, row header area, and data area of the instruction table 2. The input unit 1 generates table creation instruction data from the instruction table 2 in which the objects are arranged, and sends the table creation instruction data to the multidimensional table creation unit 3. The multidimensional table creation unit 3 searches the database 4 according to the table creation instruction data given from the input unit 1, processes the search result based on the table creation instruction data, generates a multidimensional table, and outputs it To do.
[0009]
FIG. 23 shows a multidimensional table generated by this conventional table creation system. As shown in FIG. 23, in this multi-dimensional table, sales area items are shown as column headings, and product name and monthly items are shown as row headings. Therefore, as the row item, the monthly degree by product is represented as an item of one row, and the number of sales is displayed at the intersection with the column item.
[0010]
[Patent Document 1]
Japanese Patent Laid-Open No. 10-040050
[0011]
[Problems to be solved by the invention]
However, in such a conventional table creation system, since the multi-dimensional table is created by inputting the condition specification on the interface screen different from the data table, the operation is difficult to understand and the layout design is difficult. was there.
[0012]
In addition, in the conventional multidimensional table, it is easy to see by displaying a plurality of items in rows and columns. Therefore, there are three items that can be specified, that is, a column item and one or more items in a row. There is a problem that there are three items, that is, an item at the intersection and only one item at the intersection can be compared. Furthermore, when the number of items in the line item increases, the effect is not only diminished, but it is also difficult to make a comparison.
[0013]
For example, even if the created table is expressed as a multidimensional table, the entity is a two-dimensional table. Therefore, if there are three or more comparison items as described above, the row item or the column item Since items are nested, there is a problem that it becomes harder to see as the number of items increases.
[0014]
Also, even in a list that sets only conventional column items, it is displayed in a fixed layout designed at the time of creating the program, so if you sort by specifying multiple items, depending on the specified item, the items will remain separated As a result, there is a problem that the data string to be referred to breaks up, and the important data string cannot be referred to unless the horizontal scroll operation is performed.
[0015]
Therefore, the present invention can display the analysis target items in an easy-to-view manner by changing the item sequence order of the specified items, changing the layout according to the purpose of use, and displaying the results. It is an object to provide a table output program that can be easily provided.
[0016]
[Means for Solving the Problems]
In order to solve the above problems, the present invention provides a data table acquisition step for acquiring a data table having a plurality of data items, and a rearrangement condition having designation information of a data item for changing the arrangement position from the data items. A rearrangement condition acquisition step for acquiring, a data table update step for changing the order of the data tables in accordance with the acquired rearrangement condition, and a data table output step for outputting the updated data table It is characterized by.
[0017]
As a result, the layout of the data table can be changed in accordance with the specified arrangement conditions, so that the result table displayed in the desired order can be output, and the item sequence to be referred to can be prevented from crying and output. This makes it possible to easily analyze items from the data table.
[0018]
In the present invention, in order to solve the above problem, the rearrangement condition acquisition step acquires a plurality of the data item designation information and the arrangement order of the data items as the rearrangement condition, and the data table update step includes According to the rearrangement order, the designated data items are arranged adjacent to each other, and the data table is updated.
[0019]
Thereby, a plurality of the data item designation information and the arrangement order of the data items are acquired as the rearrangement condition, and the data items are arranged adjacent to each other according to the arrangement order of the data items. Can be displayed in a desired arrangement order, and data analysis can be easily performed as an item arrangement suitable for data analysis.
[0020]
Further, in order to solve the above-described problem, the present invention provides a plurality of data item designation information as the rearrangement condition and an arrangement order of the data items as the data item designation information and the sort priority set as the sort condition. The data table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order, and sorts the designated data items according to the sort priority order to update the data table. It is characterized by doing.
[0021]
As a result, the data items are rearranged in the sort priority order while sorting according to the sort priority order, so that the arrangement of the item columns suitable for sorting can be changed while sorting the items. Thus, the column and the comparison item column can be changed to an easily viewable position.
[0022]
In order to solve the above problem, the present invention provides a rearrangement condition acquisition step in which a priority order acquisition step for acquiring a rearrangement condition in which the sort priority is set, and a sort condition from the acquired rearrangement condition. A rearrangement condition storage step for storing the condition, a condition confirmation determination step for determining the condition of the rearrangement condition, and when resetting the rearrangement condition, the priority order acquisition step, the rearrangement condition storage step, and the condition A reconfiguration condition acquisition step that repeats the confirmation determination step, and a relocation condition delivery step that delivers the stored relocation condition to the data table update step when the setting of the relocation condition is confirmed, When the rearrangement condition storing step has already stored the rearrangement condition, it is designated by the newly acquired rearrangement condition. Sort that includes the sort priority specified for the data item of the relocation condition acquired and lowering the sort priority of the stored data item for which the sort priority higher than the sort priority of the selected data item is set A table output program for storing conditions.
Is.
[0023]
With this, if you specify a new sort priority item with a sort condition already set, a new specified item is inserted between the set items, so if you want to add a sort item, Setting and sorting conditions can be re-set by inputting only the added amount without starting again, and setting items can be easily added.
[0024]
In order to solve the above problem, the present invention provides a rearrangement condition acquisition step in which a priority order acquisition step for acquiring a rearrangement condition in which the sort priority is set, and a sort condition from the acquired rearrangement condition. A rearrangement condition storage step for storing the condition, a condition confirmation determination step for determining the condition of the rearrangement condition, and when resetting the rearrangement condition, the priority order acquisition step, the rearrangement condition storage step, and the condition A reconfiguration condition acquisition step that repeats the confirmation determination step, and a relocation condition delivery step that delivers the stored relocation condition to the data table update step when the setting of the relocation condition is confirmed, The priority order acquisition step acquires the rearrangement condition in which the sort specification cancellation of the data item is set, and the rearrangement When the record storage step acquires the sort specification cancellation, the sort priority of the stored data item having a higher sort priority than the sort priority of the data item for which the acquired sort specification cancellation is specified is increased. At the same time, the sorting condition including the sorting priority of the data item for which the obtained sort designation cancellation is designated is returned to an initial value, and the sorting condition is stored.
[0025]
As a result, if you specify an item for canceling the sort specification after the sort condition has been set, only the item for which the cancellation is specified is deleted from the sort item, and other items are carried forward, so only a specific item is selected from the sort specification item. When it is desired to remove the setting item, it is possible to reset the item by simply specifying the item to be deleted without re-setting the item and setting the sorting condition from the beginning, and the setting item can be easily deleted.
[0026]
Furthermore, in order to solve the above-described problem, the present invention provides that the rearrangement condition obtaining step performs the rearrangement in which the left or right side designation in the data table is designated as the data item designation information and the data item rearrangement position. Obtaining an arrangement condition, and the data table updating step relocates the data item designated according to the obtained rearrangement condition to the left or right side in the data table, and updates the data table. It is characterized by.
[0027]
As a result, the specified items are moved to the left or right side of the data table and rearranged, so that items that you want to focus on or do not focus on can be placed in a position where you can see or not see them, making data analysis easier. Will be able to.
[0028]
Furthermore, in order to solve the above problems, the table output method of the present invention includes a data table acquisition step for acquiring a data table having a plurality of data items, and data item designation information for changing the arrangement position from the data items. A rearrangement condition obtaining step for obtaining a rearrangement condition, a data table updating step for changing the arrangement order of the data tables according to the obtained rearrangement condition, and a data table output step for outputting the updated data table It is characterized by comprising.
[0029]
By this method, the layout of the data table can be changed according to the specified arrangement conditions, so that the result table displayed in the desired order can be output, and the item column to be referred to can be prevented from crying and output The item analysis can be easily performed from the data table.
[0030]
Further, in the table output method of the present invention, in order to solve the above problem, the rearrangement condition acquisition step acquires a plurality of the data item designation information and the arrangement order of the data items as the rearrangement condition, and the data The table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order of the data items, and updates the data table.
[0031]
According to this method, a plurality of the data item designation information and the arrangement order of the data items are acquired as the rearrangement condition, and the data items are arranged adjacent to each other according to the arrangement order of the data items. The items can be displayed in the desired arrangement order, and the data analysis can be easily performed as the item arrangement suitable for the data analysis.
[0032]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings.
[0033]
FIG. 1 shows a configuration diagram of a table output system for realizing a table output program according to the present invention. As illustrated in FIG. 1, the table output system 1000 includes an input / output unit 1100, a data extraction unit 1300, a control processing unit 1400, and a storage unit 1500.
[0034]
The table output system 1000 is connected to the database 2000, acquires a desired data table from the database 2000 in accordance with a user input instruction, performs an update process, and displays and outputs it.
[0035]
In this embodiment, the database 2000 is external to the table output system 1000. However, the database 2000 may be internal to the table output system 1000.
[0036]
The input / output unit 1100 of the table output system 1000 accepts user input instructions and displays and outputs the output results of the table output system 1000 and supplementary information.
[0037]
The data extraction unit 1300 extracts a desired data table from the database 2000 in accordance with a user input instruction input to the input / output unit 1100.
[0038]
The control processing unit 1400 is a peach that performs overall control of the table output system 1000. In particular, according to a user input instruction input to the input / output unit 1100, the control processing unit 1400 is a weighting table stored in the storage unit 1500 described below. Data table update processing is performed.
[0039]
The storage unit 1500 stores the data table extracted by the data extraction unit 1300, the above-described weighting table (details will be described later), and various necessary data.
[0040]
Here, the data table used in the present embodiment is shown in FIG. 2 and described.
[0041]
Here, as the data table, sales data 2100 representing sales status data at a car store is shown. Sales data 2100 is stored in database 2000.
[0042]
As shown in FIG. 2, the sales data 2100 includes sales representative names such as sales, number of business days, sales district, classification indicating whether the customer who sold the car is an individual or a company, sales month when the car was sold, sales As an item, the model, model, etc.
[0043]
The operation processing in such a table output system 1000 will be described with reference to FIG.
[0044]
As shown in FIG. 3, in the table output system 1000, first, an input instruction is acquired from the user (s110). In the input instruction acquisition, the input / output unit 1100 acquires user operation information and transmits it to the control processing unit 1400, and the control processing unit 1400 interprets the input instruction from the operation information.
[0045]
Next, the initial design SQL statement is read according to the input instruction interpreted by the control processing unit 1400 (s120). Next, data is extracted according to the read SQL sentence (s130: data table acquisition step). In the data extraction process, the data extraction unit 1300 extracts desired data from the database 2000 in accordance with an instruction from the control processing unit 1400 and stores it in the storage unit 1500. Here, the sales data 2100 is read and stored in the storage unit 1500 as sales data 1510.
[0046]
Next, a weighting table initial setting process is performed (s140). Here, the weighting table is a work table 1520 created in the storage unit 1500 in order to easily rearrange items when rearranging items in the data table.
[0047]
Next, the data table stored in the storage unit 1500, here, the sales data 1510 and the setting information are displayed on the screen (s150: data table output step). In this screen display, the control processing unit 1400 causes the sales data 1510 stored in the storage unit 1500 to be displayed on the display screen via the input / output unit 1100. In addition, if sort priority, auxiliary information for rearrangement designation, and the like have already been set, they are also displayed.
[0048]
FIG. 4 shows a display screen example. In accordance with the display screen shown in FIG. 4, the user inputs an input instruction to be described later. To be specific, click on the “up” or “down” on the item name display with the mouse to specify the sort order, or select “Left priority pin” or “Right” in the “Pin area”. Drag the “priority pin” and drop it in the desired column.
[0049]
When “ascending” or “descending” is specified, the sorting priority of the specified item and whether ascending or descending order is determined, and when “priority pin” of “pin storage” is dragged and dropped Determines the position of the specified item after rearrangement to be left-justified or right-justified.
[0050]
Next, an input instruction is acquired from the user (s160: rearrangement condition acquisition step), and it is determined whether or not the result display needs to be changed (s170). If the result display needs to be changed, the following process is performed. If the result display does not need to be changed, the process is terminated.
[0051]
If the result display needs to be changed, a weight / sort designation process is performed (s180). In the weight / sort designation process, the sort condition and the arrangement position are set for the weighting table 1520.
[0052]
Next, display definition reconstruction processing is performed (s190: data table update step). In the display definition reconstruction process, the arrangement of items is changed according to the conditions set in the weighting table 1520, and an SQL sentence is generated.
[0053]
Next, data extraction is performed according to the reconstructed SQL statement of the display definition (s200). In this data extraction process, data is extracted according to a weighting table 1520 stored in the storage unit 1500 in accordance with an instruction from the control processing unit 1400.
[0054]
Next, returning to the screen display process (s150: data table output step), the updated sales data 1510 is displayed, and the above process is repeated.
[0055]
Next, the above process will be described in detail.
[0056]
First, the weighting table initial setting process (s140) will be described with reference to a flowchart shown in FIG. A data structure diagram of the weighting table 1520 is shown in FIG.
[0057]
As shown in FIG. 6, the weighting table 1520 has items of current display order, item, sort priority, sort direction, and pin. The current display order indicates the column position to be displayed by the number of items from the left, and the item indicates the corresponding display item name. The sort priority order is a priority order for sorting (rearranging) by the corresponding item, and the first key, the second key,... The sort direction indicates whether the target item column is arranged in ascending order or descending order, and the pin is a flag that indicates whether to exclude from column position rearrangement or whether to fix it to the left or right It is.
[0058]
In the weighting table initial setting process (s140), first, column items are read from the read data table, that is, the sales data 1510 stored in the storage unit 1500, and one row of data per item is created as the weighting table 1520. (S310). Further, the display order at the time of designing the sales data 1510 is stored in the current display order of the weighting table 1520 (s320).
[0059]
Next, “HIGH-VALUE” (handled as the largest value in the corresponding item) is stored in the sorting priority of the weighting table 1520 (s330). Next, “0” is stored in the pin. Here, “0” of the pin indicates a neutral position for distinguishing from an item whose arrangement position is changed, in addition to a sort item described later.
[0060]
With the above processing, the weighting table initial setting processing (s140) is completed.
[0061]
Next, the weight / sort designation processing (s180) will be described with reference to a flowchart shown in FIG. In this process, it is determined whether the sort condition is set or the priority placement position is set in accordance with an input instruction from the user, and the process is distributed to each process and the weighting table 1520 is set.
[0062]
First, in the weight / sort designation processing (s180), whether the input instruction from the user has designated “rising” or “falling” above the display of the item name, or “left” in the “pin storage” Depending on whether the “priority pin” or the “right priority pin” has been dragged and dropped, it is determined whether it is “designation of sort priority” or “designation of priority arrangement position” (s410).
[0063]
When “ascending” or “descending” is designated, it is “specifying sort priority”, so sort item setting processing (s420) is performed, and “left priority pin” or “right priority pin” is dragged and dragged. If it has been dropped, it is “priority placement position designation”, so priority placement item setting processing (s430) is performed.
[0064]
Next, the sort item setting process (s420) will be described with reference to flowcharts shown in FIGS. In this process, the sort condition is set for the weighting table 1520.
[0065]
In the sort item setting process (s420), first, according to an input instruction from the user, a “specified item” in which “ascending” or “descending” is specified and an “elevating / lowering category” that distinguishes between ascending or descending order are set. (S510). Next, all sort priorities designated from the weighting table 1520 are read (s520).
[0066]
Next, along with the read “sort priority” that has been read, “item name” for which the sort priority is set and “distinguishment between ascending / descending order” that is the sorting condition for the item are displayed in a pop-up. Further, at the bottom of this display, the read “maximum value of sorting priority” + “value” of “1” and the item “added behind” are displayed in a pop-up (s530).
[0067]
Here, FIG. 10 shows an example of this sort priority designation (sort item addition) screen. In this screen example, the sales month, sales district, and vehicle type have already been set as the first, second, and third sort priority, respectively, and the number of business days is specified as the sort item in descending order by the user's specification. The example of a display is shown. As a result, a specified column (here, the number of negotiation days) can be newly added to the sort item.
[0068]
Next, it is determined whether or not the sort priority is already set for the user-specified item (s540). When the sort priority is set for the specified item, the item “name” + “cancel” of “specified item” is displayed in the list of the specified item together with the read “sort priority” that has been read. Pop-up display is performed (s550).
[0069]
FIG. 11 shows an example of this sort priority designation (sort designation release) screen. In this screen example, the sales month, sales district, and vehicle type have already been set as the first, second, and third sort priority, respectively, and the display example when the sales district is specified by the user's specification Show. Thereby, the designated column (here, the sales district) can be released from the sort item.
[0070]
Next, the sort priority in the popup selected by the user in accordance with the sort priority designation (sort item addition or sort designation cancellation) screen is acquired as an “update item” (s560).
[0071]
Next, it is determined whether or not the acquired “update item” is an item “added behind” (s570). If it is “added behind”, the sorting priority of the specified item in the weighting table 1520 is set. , The value of the sort priority maximum value + 1 is stored. In the sort direction, “ascending order” or “descending order” is stored according to the ascending / descending division (s580). When the “update item” is “added behind”, the sort specification process (s420) is terminated in the update process (s580) of the weighting table 1520.
[0072]
Next, if the acquired “update item” is not “added after”, the sort priority of a row having a value larger than the sort priority of the specified item in the weighting table 1520 is decremented (−1) ( s610). Furthermore, the sorting priority and sorting direction of the designated item in the weighting table 1520 are initialized (the sorting priority is “HIGH-VALUE”, and the sorting direction is cleared) (s620). Here, in the case of adding a sort item, the sort priority and sort direction of the designated item have already been initialized, so nothing is changed.
[0073]
FIG. 12 shows changes in the weighting table 1520 when the sales district is released from the sort designation item by the designated item initialization process (s610, s620). As shown in FIG. 12, the sorting priority of the sales district and the sorting direction are initialized, and the sorting priority of the vehicle type is increased.
[0074]
Next, it is determined whether or not the acquired “update item” matches the “specified item” (s630), and if it matches, the sort item setting process (s420) is terminated.
[0075]
Next, if the acquired “update item” does not match the “specified item”, the sort priority of “update item” is saved (s640). Next, the sort priority of a row having a value equal to or higher than the sort priority of the update item in the weighting table 1520 is incremented (+1) (s650). Further, the saved sort priority order is stored in the sort priority order of the designated item of the weighting table 1520, and “ascending order” or “descending order” according to the “elevation category” is stored in the sort direction (s660). ).
[0076]
FIG. 13 shows a change in the weighting table 1520 when the number of negotiation days is additionally specified with the third sort priority in the update item addition processing (s650, s660). As shown in FIG. 13, the sorting priority of the negotiation days and the sorting direction are set, and the sorting priority of the vehicle type is lowered.
[0077]
With the above processing, this sort item setting processing (s420) is completed.
[0078]
Next, the priority arrangement item setting process (s430) will be described with reference to a flowchart shown in FIG. In this process, priority placement setting of items for preferentially determining the placement position is performed on the weighting table 1520.
[0079]
FIG. 15 shows an example of a screen when the priority arrangement position is designated. As shown in FIG. 15, here, the left priority is specified for the sales and the right priority is specified for the division.
[0080]
In the priority arrangement item setting process (s430), first, according to an input instruction from the user, the “priority pin classification” for distinguishing whether the designated one is the “left priority pin” or the “right priority pin”, and the dropped item “Designated item” indicating “” is set (s710). Next, according to the “priority pin classification”, it is determined whether it is a “left priority pin” or a “right priority pin” (s720).
[0081]
If it is a “left priority pin”, “LOW-VALUE” (left priority) is stored in the pin designation of the designation item of the weighting table 1520 (s730). If it is a “right priority pin”, “HIGH-VALUE” (right priority) is stored in the pin designation of the designation item of the weighting table 1520 (s740). Here, LOW-VALUE is a value that takes the minimum value in the corresponding item, and HIGH-VALUE is a value that takes the maximum value in the corresponding item. Accordingly, the pin designation size relationship here is “LOW-VALUE” <“0” <“HIGH-VALUE”.
[0082]
FIG. 16 shows a change in the weighting table 1520 when the left priority is set for sales and the right priority is specified for the division by the priority arrangement item setting process. As shown in FIG. 16, “LOW-VALUE (left priority)” is set for the business pin designation, and “HIGH-VALUE (right priority)” is set for the segment pin designation.
[0083]
With the above processing, the priority arrangement item setting processing (s430) is completed. The weight / sort designation process (s180) is also terminated by the sort item setting process (s420) and the priority arrangement item setting process (s430).
[0084]
Next, the display definition reconstruction process (s190) will be described with reference to a flowchart shown in FIG. In this process, the arrangement of items is changed according to the conditions of the weighting table 1520 set in the weight / sort designation process (s180), and the SQL sentence is generated.
[0085]
First, in the display definition reconstruction process (s190), the weighting table 1520 is sorted by the set pin designation, sort priority, and current display order (s810).
[0086]
FIG. 18 shows changes in the weighting table 1520 when sorting is performed according to pin designation, sorting priority, and current display order. As shown in FIG. 18, “sales” is the first item and “category” is the last item according to the pin designation sort. In addition, according to the sort priority, “Sales” is followed by “Sales Month”, “Sales District”, “Vehicle Type”, and the current display order is followed by “Negotiation Days”, “Type”, and finally Is "category".
[0087]
Next, the current display order of the weighting table 1520 is renumbered in order from the top (s820), and the weighting table 1520 is read (s830). Next, the SQL statement is generated by arranging the output of the SELECT phrase and the current display order in ascending order (s 840), and the SQL statement is generated by combining the ORDER BY phrase with the sort direction (DESC) in order from the lowest sort priority. (S850).
[0088]
With the above processing, the display definition reconstruction processing (s190) ends.
[0089]
In this way, after reorganizing the table definition, data is extracted, displayed on the screen, and relocation conditions are input again if necessary. Therefore, a desired item string can be moved to a specified position, the data table can be easily viewed, and data analysis can be easily performed. For example, since the data can be arranged in order from the left according to the sorting priority, there is no crying of the data string to be referred to, and an important data string can be easily compared and referenced without performing a horizontal scroll operation or the like.
[0090]
FIGS. 19 and 20 show examples of data tables in which item strings are rearranged by the table output program.
[0091]
In the example of the data table shown in FIG. 19, for the sales data 2100, the items “Sales Month”, “Sales District”, and “Vehicle Type” are set to the first, second, and third sort priority levels. , Rearranged in the order of sort priority.
[0092]
The example of the data table shown in FIG. 20 shows an example of the rearrangement data table when the left priority is set for “sales” and the right priority is set for “category” in addition to the above conditions.
[0093]
In the above description, the sales data 2100 is first read from the database 2000 and all data is stored as the sales data 1510 in the storage unit 1500 of the table output system 1000. After setting the arrangement condition and the like, the sales data 2100 may be directly read from the database 2000 when it is necessary to display the data.
[0094]
Furthermore, in the above embodiment, each item name is displayed on the data table display, but the item name display may not be performed. In the above-described embodiment, both the sort item setting process and the priority placement item setting process are performed.
[0095]
Here, FIG. 21 shows an example of an input screen for inputting a rearrangement instruction in the table output program when no item name is displayed in the data table and only the sort item setting process is performed.
[0096]
As described above, according to the present invention, an input instruction having a plurality of items of information specified for sorting is acquired, and the data table is rearranged according to the input instructions. The created data table can be displayed and output, the comparison item column can be easily seen, and data analysis can be easily performed.
[0097]
Furthermore, the following is added to the present invention.
[0098]
(Appendix 1)
A data table acquisition step of acquiring a data table having a plurality of data items;
A rearrangement condition acquisition step for acquiring a rearrangement condition having designation information of a data item for changing the arrangement position from among the data items of the data table;
A data table update step of arranging the data items designated according to the acquired rearrangement condition at a predetermined position and changing the order of arrangement of the data tables;
A table output program comprising: a data table output step for outputting the updated data table.
[0099]
(Appendix 2)
In the table output program described in Appendix 1,
The relocation condition acquisition step acquires a plurality of the data item designation information and the arrangement order of the data items as the relocation condition,
The table output program wherein the data table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order of the data items, and updates the data table.
[0100]
(Appendix 3)
In the table output program described in Appendix 2,
The plurality of data item designation information as the rearrangement condition and the arrangement order of the data items are the data item designation information and the sort priority set as the sort condition,
The data table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order, and sorts the designated data items according to the sort priority order to update the data table. A table output program characterized by that.
[0101]
(Appendix 4)
In the table output program described in Appendix 3,
The rearrangement condition acquisition step includes
A priority acquisition step of acquiring a rearrangement condition in which the sort priority is set;
A rearrangement condition storing step for storing a sort condition including the designated data item information and sort priority from the acquired rearrangement condition;
Condition determination determination step for acquiring condition determination determination information for determining whether or not the setting of the rearrangement condition is fixed, and performing condition determination determination;
When the condition determination determination information for resetting the rearrangement condition in the condition determination step is acquired, the priority setting step, the rearrangement condition storage step, and the condition determination step are repeated. A condition acquisition step;
A relocation condition transfer step of transferring the stored relocation condition to the data table update step when acquiring the condition determination determination information that the setting of the relocation condition is fixed in the condition determination step ,
When the rearrangement condition storing step has already stored the rearrangement condition, stored data in which the sort priority higher than the sort priority of the data item specified by the newly acquired rearrangement condition is set A table output program for lowering the sorting priority of an item and storing a sorting condition including a sorting priority designated in the data item of the acquired rearrangement condition.
[0102]
(Appendix 5)
In the table output program described in Appendix 3,
The rearrangement condition acquisition step includes
A priority acquisition step of acquiring a rearrangement condition in which the sort priority is set;
A rearrangement condition storing step for storing a sort condition including the designated data item information and sort priority from the acquired rearrangement condition;
Condition determination determination step for acquiring condition determination determination information for determining whether or not the setting of the rearrangement condition is fixed, and performing condition determination determination;
When the condition determination determination information for resetting the rearrangement condition in the condition determination step is acquired, the priority setting step, the rearrangement condition storage step, and the condition determination step are repeated. A condition acquisition step;
A relocation condition transfer step of transferring the stored relocation condition to the data table update step when acquiring the condition determination determination information that the setting of the relocation condition is fixed in the condition determination step ,
The priority order acquisition step acquires a rearrangement condition in which the sort designation cancellation of the data item is set,
When the rearrangement condition storing step acquires the sort designation cancellation, the sort priority of the stored data item in which the sort priority higher than the sort priority of the data item for which the acquired sort specification cancellation is specified is set. A table output program which raises the rank, returns the sort condition including the sort priority of the data item for which the obtained sort designation cancellation is designated to an initial value, and stores the sort condition.
[0103]
(Appendix 6)
In the table output program described in Appendix 1,
The rearrangement condition acquisition step acquires the rearrangement condition in which designation on the left side or the right side in the data table is performed as the designation information of the data item and the rearrangement position of the data item,
The data table updating step updates the data table by moving the data item specified according to the acquired rearrangement condition to the left or right side of the data table and rearranging the data table. program.
[0104]
(Appendix 7)
A data table acquisition step of acquiring a data table having a plurality of data items;
A rearrangement condition acquisition step for acquiring a rearrangement condition having designation information of a data item for changing the arrangement position from among the data items of the data table;
A data table update step of arranging the data items designated according to the acquired rearrangement condition at a predetermined position and changing the order of arrangement of the data tables;
And a data table output step for outputting the updated data table.
[0105]
(Appendix 8)
In the table output method according to attachment 7,
The relocation condition acquisition step acquires a plurality of the data item designation information and the arrangement order of the data items as the relocation condition,
The table output method, wherein the data table update step arranges the designated data items adjacent to each other according to the arrangement order of the data items, and updates the data table.
[0106]
【The invention's effect】
According to the present invention, a specified arrangement condition is obtained by acquiring a data table, acquiring a rearrangement condition, changing the arrangement order of the data tables according to the rearrangement condition, and outputting an updated data table. Because the data table layout can be changed according to the data table, the result table displayed in the desired order can be output to prevent the item string you want to refer to from crying, making it easy to analyze items from the output data table Can be done.
[0107]
According to the present invention, a plurality of the data item designation information and the arrangement order of the data items are acquired as the rearrangement condition, and the designated data items are arranged adjacent to each other according to the rearrangement order. Since the data table is updated, a plurality of the data item designation information and the arrangement order of the data items are acquired as the rearrangement condition, and the data items are arranged adjacent to each other according to the arrangement order of the data items. Therefore, a plurality of data items can be displayed in a desired arrangement order, and data analysis can be easily performed as an item arrangement suitable for data analysis.
[0108]
Further, according to the present invention, the plurality of data item designation information as the rearrangement condition and the arrangement order of the data items are the data item designation information set as the sort condition and the sort priority, and the arrangement order includes Therefore, the specified data items are arranged adjacent to each other, and the specified data items are sorted according to the sort priority order, and the data table is updated. Therefore, it is suitable for sorting while sorting items. The arrangement of the selected item string can be changed, and the sort item string and the comparison item string can be changed to a position that is easy to see.
[0109]
According to the present invention, when the rearrangement condition is already stored, the stored data in which the sort priority higher than the sort priority of the data item specified by the newly acquired rearrangement condition is set By lowering the sorting priority of the item and storing the sorting condition including the sorting priority specified in the data item of the acquired rearrangement condition, a new sorting priority is assigned with the sorting condition already set. If you specify an item, a new specified item is inserted between the set items, so if you want to add a sort item, enter only the added amount without starting the item setting and sort condition setting from the beginning. The setting item can be reset and the setting item can be easily added.
[0110]
Further, according to the present invention, when the sort designation cancellation is acquired, the sort priority of the stored data item in which the sort priority higher than the sort priority of the data item for which the acquired sort specification cancellation is specified is set. The sort condition including the sort priority of the data item for which the acquired sort specification cancellation is specified is returned to the initial value, and the sort condition is stored, so that the sort specification is canceled from the state where the sort condition has been set. If an item is specified, only the item for which cancellation is specified is deleted from the sort item, and other items are moved forward, so if you want to remove only a specific item from the sort specification item, you can start item settings and sort condition settings. It is possible to set again by simply specifying the item to be deleted without having to start again. That.
[0111]
Further, according to the present invention, the rearrangement condition that designates the left or right side in the data table as the designation information of the data item and the rearrangement position of the data item is acquired, and the acquired rearrangement condition is included in the acquired rearrangement condition. Therefore, the designated data item is moved to the left or right side in the data table and rearranged, and the data table is updated. This can make data analysis easier.
[0112]
Furthermore, according to this data output method, the data table is acquired, the rearrangement condition is acquired, the arrangement order of the data table is changed according to the rearrangement condition, and the updated data table is output, thereby specifying Since the layout of the data table can be changed according to the arranged conditions, it is possible to output the result table displayed in the desired order and prevent tearing off of the item sequence to be referred to. From the output data table Item analysis can be easily performed.
[0113]
According to the present data output method, a plurality of the designated data item designation information and the arrangement order of the data items are acquired as the rearrangement condition, and the designated data item is obtained according to the arrangement order of the data items. Are arranged adjacent to each other and the data table is updated, so that a plurality of data items can be displayed in a desired arrangement order, and data analysis can be easily performed as an item arrangement suitable for data analysis.
[Brief description of the drawings]
FIG. 1 is a configuration diagram showing a table output system according to the present invention.
FIG. 2 is a data structure diagram of sales data.
FIG. 3 is a flowchart showing an operation process of the table output system.
FIG. 4 is an example of an input screen for inputting a rearrangement instruction.
FIG. 5 is a flowchart showing an operation process of a weighting table initial setting process.
FIG. 6 is a data structure diagram of a weighting table.
FIG. 7 is a flowchart showing an operation process of a weight / sort designation process.
FIG. 8 is a flowchart showing an operation process of a sort item setting process.
FIG. 9 is a flowchart showing an operation process of a sort item setting process.
FIG. 10 is a screen example of sorting priority designation (sort item addition);
FIG. 11 is a screen example of sort priority designation (sort designation cancellation);
FIG. 12 is a diagram illustrating a change in a weighting table due to release of a sort item.
FIG. 13 is a diagram showing changes in the weighting table due to the addition of sort items.
FIG. 14 is a flowchart illustrating a priority arrangement item setting process.
FIG. 15 is an example of a screen when a priority arrangement position is designated.
FIG. 16 is a diagram illustrating a change in the weighting table by the priority arrangement item setting process.
FIG. 17 is a flowchart showing display definition reconstruction processing;
FIG. 18 is a diagram showing a change in a weighting table in which sorting processing is performed by pin designation, sorting priority, and current display ranking.
FIG. 19 is a diagram illustrating an example of a data table in which item strings are rearranged by a table output program.
FIG. 20 is a diagram illustrating an example of a data table in which item strings are rearranged by a table output program.
FIG. 21 is an example of an input screen for inputting a rearrangement instruction without item name display;
FIG. 22 is a configuration diagram of a conventional table creation system.
FIG. 23 is a diagram showing a multidimensional table created by a conventional table creation system.
[Explanation of symbols]
1 Input section
2 Instruction table
3 Multidimensional table creation part
4 Database
1000 table output system
1100 Input / output unit
1300 Data extraction unit
1400 Control processing unit
1500 storage unit
1510 Sales data
1520 Weighting table
2000 database
2100 Sales data

Claims (5)

A data table acquisition step of acquiring a data table having a plurality of data items;
A rearrangement condition acquisition step for acquiring a rearrangement condition having designation information of a data item for changing the arrangement position from among the data items of the data table;
A data table update step of arranging the data items designated according to the acquired rearrangement condition at a predetermined position and changing the order of arrangement of the data tables;
A table output program comprising: a data table output step for outputting the updated data table. In the table output program according to claim 1,
The relocation condition acquisition step acquires a plurality of the data item designation information and the arrangement order of the data items as the relocation condition,
The table output program wherein the data table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order of the data items, and updates the data table. In the table output program according to claim 2,
The plurality of data item designation information as the rearrangement condition and the arrangement order of the data items are the data item designation information and the sort priority set as the sort condition,
The data table updating step arranges the designated data items so as to be adjacent to each other according to the arrangement order, and sorts the designated data items according to the sort priority order to update the data table. A table output program characterized by that. In the table output program according to claim 1,
The rearrangement condition acquisition step acquires the rearrangement condition in which designation on the left side or the right side in the data table is performed as the designation information of the data item and the rearrangement position of the data item,
The data table updating step updates the data table by moving the data item specified according to the acquired rearrangement condition to the left or right side of the data table and rearranging the data table. program. A data table acquisition step of acquiring a data table having a plurality of data items;
A rearrangement condition acquisition step for acquiring a rearrangement condition having designation information of a data item for changing the arrangement position from among the data items of the data table;
A data table update step of arranging the data items designated according to the acquired rearrangement condition at a predetermined position and changing the order of arrangement of the data tables;
And a data table output step for outputting the updated data table.

Images