JP2011164679A - System, method, and program for statistical processing - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a statistical processing system, a statistical processing method and a statistical processing program capable of more easily and effectively utilizing a statistical result. <P>SOLUTION: In response to a total request from a client terminal 10, a server control part 21 of a library task management server 20 performs tabulation processing, and generates tabulation result data and tabulation result detail data, and records the data in a statistical history record, and transmits them to a client terminal 10. Tabulation value data are included in the tabulation result data, and data ID constituting the tabulation value, the data ID displayed in a cell specified with a line number, and a string number is included in the tabulation result detail data. A terminal control part 11 of the client terminal 10 displays a tabulation result list table on the basis of the tabulation result data, and when a cell is selected, makes a retrieval request including the data ID of the data configuring the tabulation value of the cell, and acquires the task processing management record of the data ID, and executes the display processing of the detailed content of the tabulation value. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a statistical processing system, a statistical processing method, and a statistical processing program for outputting statistical information.

  In recent years, statistical processing for collecting and analyzing management data has been performed in order to improve business services. For example, in library service operations, the use of book materials and the use of human resources are improved based on the results of counting up lending management data and the like.

  When performing such total analysis, statistical processing is executed using a statistical program that can access each business processing database. A technique for displaying the tabulated results in a tabular format based on an output unit instructed by an operator has also been studied (for example, see Patent Document 1). In the technique described in this document, the tabulation results are displayed using a table format in which output units multiplexed in a plurality of stages are set on the horizontal axis and the vertical axis. By using such a table format, it is possible to display the tabulation results in a higher dimension than two dimensions.

  In addition, when the classification to be aggregated or the contents of the data to be aggregated are changed, the aggregation results may be different even under the same aggregation conditions as when statistical processing was performed in the past. In view of this, a technique for storing the output conditions used in the statistical processing in association with the aggregated results has been studied (for example, see Patent Document 2). In the technique described in this document, the aggregation condition is registered in the statistical database, and the aggregation processing request is transmitted to the server. The server manages the execution of the aggregation process according to the received aggregation process request and registers the aggregation result in the statistical database in correspondence with the aggregation process request.

  However, when only the total results are registered in the statistical database as in the prior art, it is not possible to grasp the contents of the data constituting the total value. In order to view the contents of the data that makes up the aggregated value, it is necessary to start a business processing program for accessing this aggregated data and perform a search again under the same conditions as the output conditions used in statistical processing. there were.

  In addition, when viewing the total result, there may be a case where it is desired to further subdivide the displayed total value. In this case, the statistical process must be performed again using the output condition obtained by adding the condition for narrowing down to the condition of the statistical process already performed.

  The present invention has been made in view of the above-described problems, and an object of the present invention is to provide a statistical processing system, a statistical processing method, and a statistical processing program capable of easily effectively using statistical results.

In order to solve the above problems, the invention described in claim 1 is related to a management data identifier, a client terminal comprising an input means for inputting an instruction for statistical processing, and an output means for outputting a statistical processing result. A statistical processing system, comprising: a statistical history data storage means for storing a result of statistical processing; and a control means connected to the management target data storage means for storing the recorded management target records. The means includes statistical processing means for executing statistical processing of the management target record recorded in the management target data storage means according to the output condition and output unit acquired from the client terminal, statistical processing results, and statistical processing results A statistical result storage means for associating a management data identifier of a management target record that constitutes a record with the statistical history data storage means; A statistical processing result output means for outputting the statistical processing result to the client terminal, and a statistical processing detailed result transmission for transmitting a management data identifier of a management target record constituting the statistical processing result to the client terminal And a means.

  According to a second aspect of the present invention, in the statistical processing system according to the first aspect, the statistical history data storage means records the total result data and the total result detailed data in association with each other, and the statistical processing means The management object data storage means extracts management data that meets the output condition, and executes statistical processing for summing up the management data for each item of the output unit, and the statistical processing result output means includes the summary result As data, means for generating and recording data for displaying tabulated values for each item of the output unit in a table format, and position information for specifying the position of each cell in the table as the tabulated result detailed data; And means for generating and recording block data including the management data identifier of the management data constituting the aggregate value displayed in the cell. That.

  According to a third aspect of the present invention, in the statistical processing system according to the second aspect, the control means outputs a subclassification output unit for displaying subclassification information in the tabulation result data from the client terminal, Means for receiving a subclassification instruction including a management data identifier of management data constituting the aggregate value displayed in the subclassification target cell; and a management target record of the management data identifier included in the subclassification instruction The management data retrieved and extracted in the data storage means is aggregated for each item of the output unit of the received fine classification, and further provided with means for transmitting the fine classification aggregation result data for displaying the aggregated value on the client terminal This is the gist.

  According to a fourth aspect of the present invention, there is provided a client terminal comprising an input means for inputting a statistical processing instruction and an output means for outputting a statistical processing result, and a management storing a management target record associated with a management data identifier A statistical processing method using a statistical processing system that includes a statistical history data storage unit that is connected to a target data storage unit and stores a result of statistical processing, and a control unit, wherein the control unit includes: According to the output condition and output unit acquired from the client terminal, the statistical processing stage for executing the statistical processing of the management target record recorded in the management target data storage means, the statistical processing result, and the statistical processing result are configured A statistical result storing step of associating a management data identifier of a record to be managed with the statistical history data storage means and storing the statistical result storage step; A statistical processing result output stage for outputting the statistical processing result to an ant terminal; and a statistical processing detailed result transmission stage for transmitting a management data identifier of a management target record constituting the statistical processing result to the client terminal. The gist is to execute.

The invention according to claim 5 is a client terminal comprising an input means for inputting a statistical processing instruction and an output means for outputting a statistical processing result, and a management storing a management target record associated with the management data identifier A statistical processing program for use in a statistical processing system, which is connected to the target data storage means and includes statistical history data storage means for storing the results of statistical processing, and control means, the control means comprising: According to the output condition and output unit acquired from the client terminal, statistical processing means for executing statistical processing of the management target record recorded in the management target data storage means, statistical processing result, and management constituting this statistical processing result A statistical result storage means for associating the management data identifier of the target record with the statistical history data storage means, Statistical processing result output means for outputting the statistical processing result to the client terminal, and statistical processing detailed result transmission means for transmitting the management data identifier of the management target record constituting the statistical processing result to the client terminal It is made to function as.

(Function)
According to the present invention, the control unit executes the statistical processing of the management target record recorded in the management target data storage unit according to the output condition and output unit acquired from the client terminal. The control means records the statistical processing result and the management data identifier of the management target record constituting the statistical processing result in the statistical history data storage means in association with each other. The control means outputs the statistical processing result to the client terminal. The control means transmits the management data identifier of the management target record constituting the statistical processing result to the client terminal. For this reason, the management data identifier can be used to identify the data that constitutes the result of the aggregation process, so it is possible to grasp the details of the data that constitute the aggregation value in more detail and effectively use the statistical results. it can.

  According to the present invention, the control means generates and records data for displaying the tabulated value for each item of the output unit in tabular form as the tabulation result data. The control means generates and records block data including position information for specifying the position of each cell in this table and management data identifiers of the management data constituting the total value displayed in the cells as the total result detailed data. To do. For this reason, since the total value of a statistical result and the data which comprise each total value are linked | related, the content of a total value can be grasped | ascertained.

  According to the present invention, the control means, from the client terminal, outputs the fine classification output unit for displaying the fine classification information in the aggregation result data and the management data constituting the aggregate value displayed in the fine classification target cell. A subclassification instruction including a management data identifier is received. The control unit searches the management target data storage unit for the management target record of the management data identifier included in the subclassification instruction, totals the extracted management data by the item of the output unit of the subclassification received, and calculates the total value. Subclassification summary result data to be displayed on the client terminal is transmitted. For this reason, since a part of the result of the statistical processing can be dug down and finely classified, the result of the statistical processing once performed can be effectively used.

  According to the present invention, statistical results can be effectively used.

The schematic block diagram of the library business management system in embodiment. It is explanatory drawing explaining the data structure recorded on the database, (a) shows a library database, (b) shows a statistics database. Explanatory drawing for demonstrating the data structure of the data recorded on the total result data area | region recorded in the statistics database, and the total result detailed data area | region. The flowchart for demonstrating the process sequence of the statistical process in embodiment. The flowchart for demonstrating the process sequence of the detailed display process in embodiment. The flowchart for demonstrating the process sequence of the output unit narrowing-down process in embodiment. The screen figure explaining a condition input screen when performing a statistics instruction | indication. FIG. 2 is an explanatory diagram for displaying detailed contents from statistical results, where (a) is a table showing statistical results, and (b) is a detailed contents screen diagram when a cell of this table is selected. FIG. 6 is an explanatory diagram for displaying the detailed contents further narrowed down from the statistical results, where (a) shows an item to be sub-classified, and (b) is a table of results sub-classified according to the selected item. Indicates. Explanatory drawing of the table | surface of the finely classified result in the example of a change.

  Hereinafter, an embodiment embodying the present invention will be described with reference to FIGS. In the present embodiment, a description will be given using a library business management system that executes statistical processing on business data of a library installed in an educational institution as the statistical processing system. As shown in FIG. 1, the library business management system includes a client terminal 10 and a library business management server 20. The library business management system executes library business processing such as browsing management, catalog management, and mutual loan management.

Here, first, the client terminal 10 will be described.
As shown in FIG. 1, the client terminal 10 includes a terminal control unit 11, a display unit 12, and an input unit 13.

  The terminal control unit 11 includes a CPU, a RAM, a ROM, and the like (not shown) and performs processing described later. The terminal control unit 11 functions as the business processing unit 110 by executing various business processing client programs. Specifically, the terminal control unit 11 functions as a business processing unit 110 that executes processing corresponding to each program by executing a browsing client program, a catalog client program, a mutual borrowing client program, and the like. Further, the terminal control unit 11 functions as the statistical processing unit 111 by executing the statistical processing client program.

  In the present embodiment, the business processing unit 110 will be described with respect to a case where a browsing client program is executed. Therefore, the business processing unit 110 functions as a browsing business instruction unit that gives instructions to the library business management server 20 regarding browsing business such as lending, returning, and user management.

  The statistical processing means 111 of the terminal control unit 11 instructs the library business management server 20 to start statistical processing. Further, the statistical processing means 111 outputs the result of the statistical processing acquired from the library business management server 20 in a table format.

  Furthermore, the statistical processing unit 111 of the present embodiment stores an activation program table and an output unit table. The activation program table is a table for determining a program to be activated in accordance with the statistical type. In the startup program table, a statistical type identifier (statistic type ID) that specifies a statistical type, which will be described later, and a program identifier that specifies each business processing client program to be started are associated. The output unit table is a table for determining an output unit that can be displayed corresponding to a statistical type. In the output unit table, a statistical type ID and an output unit corresponding to the statistical type ID are associated with each other. Here, the output unit is a unit for classifying data of this statistical type.

  Further, the terminal control unit 11 is connected to the display unit 12 and the input unit 13. The display unit 12 is a display and is an output unit that displays various screens. The input unit 13 is a keyboard and pointing device, and is an input unit that inputs an instruction from an administrator and supplies the instruction to the terminal control unit 11.

  On the other hand, the library business management server 20 connected to the client terminal 10 includes a server control unit 21, a library database 22, and a statistics database 23 as control means. The library database 22 functions as a management target data storage unit, and the statistical database 23 functions as a statistical history data storage unit.

The server control unit 21 includes a CPU, a RAM, a ROM, and the like (not shown), and performs processing described later (processing including a statistical processing stage, a statistical result storage stage, a statistical processing result output stage, a statistical processing detailed result transmission stage, and the like). . The server control unit 21 functions as the business processing unit 210 by executing various business processing management server programs. In this embodiment, the server control unit 21 functions as a business processing unit 210 that executes processing corresponding to each program by executing a browsing server program, a catalog server program, a mutual loan server program, and the like. Further, the server control unit 21 functions as the statistical processing unit 211 by executing the statistical processing management server program.

  In the present embodiment, a case where the business processing unit 210 executes a browsing server program will be described. Accordingly, the business processing unit 210 functions as a browsing business processing unit that executes browsing business processing such as lending, returning, and user management in response to an instruction from the browsing business instruction unit.

  The statistical processing unit 211 of the server control unit 21 functions as a statistical processing unit, a statistical result storage unit, a statistical processing result output unit, and a statistical processing detailed result transmission unit. Specifically, the statistical processing unit 211 aggregates data recorded in the library database 22 in response to an instruction from the statistical processing unit 111 of the terminal control unit 11. The statistical processing means 211 of the present embodiment performs a totaling process for totaling data for each specified classification (output unit) as the statistical processing. The statistical processing means 211 includes a work memory for performing statistical processing. Further, the statistical processing unit 211 records the output condition and output unit of the data to be aggregated, and the aggregation result in the statistical database 23.

  The library database 22 includes various databases (browsing database, catalog database, mutual lending database, etc.) used by each business processing means 210 for processing. Each database in the library database 22 stores a business process management record as a management target record.

  In the present embodiment, a browsing database used when the browsing management process is executed will be described. In this browsing database, as shown in FIG. 2A, a lending management record 220 is recorded. This lending management record 220 is recorded when lending materials (books and magazines) to users. The lending management record 220 includes data on data ID, lending status, user ID, name, affiliation, school year, lending material ID, material name, material classification, lending classification, lending date and lending day.

  Data relating to a management data identifier (data ID) for specifying each lending management record is recorded in the data ID data area. This data ID is unique within the browsing database. Therefore, when each database used by each business processing unit 210 and this data ID are specified, the server control unit 21 can specify a lending management record (business process management data).

  A status flag for specifying the lending status is recorded in the lending status data area. This status flag includes a lending flag indicating “lending” and a return flag indicating “returned”.

In the user ID data area, data relating to a user identifier (user ID) for specifying the user who applied for this loan is recorded.
In the name data area, data related to the user's name is recorded.

  In the affiliation data area, data relating to an affiliation identifier for specifying the affiliation of the user is recorded. As this affiliation identifier, an identifier that identifies a department, research student, staff member, or the like is used.

In the grade data area, when the user is a student, data relating to the grade is recorded.
In the rental material ID data area, data relating to an identifier for identifying the lent material is recorded.

In the material name data area, data relating to the name of the material for which lending has been applied is recorded.
In the material classification data area, a flag for specifying the classification of this material is recorded. In the material classification data area, a book flag indicating “book” or a magazine flag indicating “magazine” is recorded.

In the lending date data area, data relating to the lending time (date) is recorded.
In the lending day data area, data relating to the day of the lending date is recorded.

On the other hand, as shown in FIG. 2B, the statistical database 23 stores a statistical type record 231, a statistical pattern record 232, and a statistical history record 233.
The statistical type record 231 is a record relating to the statistical type indicating the target of statistical processing. This statistical type record 231 is registered before the statistical processing is executed. The statistical type record 231 includes data regarding the statistical type ID, the statistical field name, and the statistical type name.

In the statistical type ID data area, data relating to an identifier (statistic type ID) for specifying each statistical type record is recorded.
In the statistical field name data area, data relating to the name of the field to which the statistical type belongs is recorded. The statistical field names include “inventory statistical field” and “collection statistical field”.
In the statistical type name data area, data relating to the name of the statistical type is recorded. Names of this statistical type include “number of loans / returns” and “number of books in the library”.

  The statistical pattern record 232 is a record relating to a statistical pattern indicating a counting method (conditions such as a period and a classification) in a target of statistical processing. This statistical pattern record 232 is registered before the statistical processing is executed. The statistical pattern record 232 includes data regarding a statistical pattern identifier, a statistical type ID, and detailed conditions.

In the statistical pattern identifier data area, data relating to a statistical pattern identifier for specifying each statistical pattern is recorded.
In the statistical type ID data area, data relating to the statistical type ID for specifying the statistical type of this statistical pattern is recorded. The statistical type record 231 and the statistical pattern record 232 are associated with each other through the statistical type ID.

  In the detailed condition data area, data related to the detailed condition when performing statistical processing using this statistical pattern is recorded. The detailed condition includes a database specifying identifier for specifying a target database to be aggregated among various databases of the library database 22. Further, the detailed condition data includes data related to the pattern name of the statistical pattern, the aggregation condition of the items to be aggregated of the statistics, and the like.

The statistical history record 233 is a record relating to the execution log of statistical processing. The statistical history record 233 is newly generated and recorded when a statistical processing instruction is received from the client terminal 10, and is updated when the statistical processing is completed. The statistical history record 233 includes data relating to a statistical history ID, an executor ID, an execution date and time, a statistical pattern ID, a totaling result, a totaling result detail, an output condition, and an output unit.

In the statistics history ID data area, data relating to an identifier (statistic history ID) for specifying a statistics history record is recorded.
In the executor ID data area, data relating to an identifier (executor ID) for specifying a person in charge who has instructed execution of statistical processing is recorded.

In the execution date / time data area, data related to the date / time when the statistical processing is executed is recorded.
In the statistical pattern ID data area, data relating to the statistical pattern ID for specifying the statistical pattern of the statistical processing is recorded. The statistical history record 233 and the statistical pattern record 232 are associated through this statistical pattern ID.

  In the total result data area, data related to the total value totaled by the statistical processing is recorded. Each total value is displayed in each cell arranged in a matrix composed of “rows” and “columns”.

  In the total result detailed data area, data relating to the details of the total value totaled by the statistical processing is recorded. Details of the total result data and the total result data will be described later.

  In the output condition data area, data relating to the output condition is recorded in order to specify the target range of statistical processing. As this output condition, for example, a data lending period or a lending classification is used.

  In the output unit data area, data related to classification (output unit) to be aggregated in the statistical processing is recorded. In the present embodiment, it is assumed that “row” and “column” can be classified in one or two dimensions. For this reason, output units of up to two dimensions (total of four dimensions) can be recorded corresponding to “row” and “column”. As the output unit, in the case of browsing statistics, each classification of the lending management record 220 (lending status, affiliation, grade, material classification, lending classification, lending date, lending day, etc.) can be used.

(Aggregation result data and aggregation result detailed data)
Next, the data structure of the aggregation result data area and the aggregation result detailed data area included in the above-described statistical history record 233 will be described with reference to FIG.

The tabulation result data area is composed of data areas of row number data, column number data, and tabulation value data.
In the row number data area and the column number data area, data relating to the number of rows and columns of cells in the form of a matrix for displaying the aggregate value as a statistical result is recorded. The number of rows and the number of columns are the number of items of output units displayed on the vertical axis and the horizontal axis. Here, the number of items is the number of items classified in one output unit. For example, when the output unit is “affiliation”, the items are “student”, “research student”, and “staff”, and the number of items is “3”. Furthermore, when two types of output units are set as the vertical axis (or horizontal axis), the number obtained by multiplying the number of items included in the two types of output units is the number of rows (or the number of columns).

  Each total value displayed in each cell is recorded in the total value data area. In this total value data area, “1 row and 1 column”, “1 row and 2 columns”,..., “1 row and m columns”, “2 rows and 1 column”,. As shown, the total values of the cells are arranged and recorded in the order of the matrix.

On the other hand, data in CSV format is recorded in the detailed result data area. In this totaling result detailed data area, block data relating to each cell is recorded side by side via a line feed code. Each block data is composed of data relating to a row number, a column number, and a data ID.

In the row number data area, data relating to the row position (row number) of the cell in which each total value is displayed is recorded.
In the column number data area, data relating to the column position (column number) of the cell in which each total value is displayed is recorded.

  In the data ID data area, a data ID for specifying data obtained by calculating the aggregate value displayed in the cell specified by the row number and the column number is recorded. In this data ID data area, the number of data IDs corresponding to the total value is recorded.

  Specifically, as shown in FIG. 3, in the data ID data area corresponding to the column number “1” in the row number “1” of the total result details, the “first row and first column” cell in the total result is displayed. Data IDs of the five pieces of data for which the displayed total value “5” is calculated are recorded. In the data ID data area corresponding to the column number “2” in the row number “1” of the aggregation result details, the aggregation value “3” displayed in the cell of “1 row, 2 column” in the aggregation result is calculated 3 A data ID of each piece of data is recorded.

  Next, processing performed using the system configured as described above will be described. Here, description will be made in the order of statistical processing, detailed display processing, and output unit narrowing processing. In the present embodiment, a case where statistical processing relating to the lending management record 220 is performed will be described.

  When the client terminal 10 is used, a person in charge who performs library work executes a login process. By this login process, the terminal control unit 11 of the client terminal 10 stores the person-in-charge ID of the person in charge in an executor ID data storage unit (not shown).

(Statistical processing)
First, statistical processing will be described with reference to FIG.
The terminal control unit 11 of the client terminal 10 executes a statistical pattern ID acquisition process (step S1-1). First, when executing statistical processing, the person in charge instructs activation of the statistical client program. In this case, the terminal control unit 11 outputs a statistics selection screen on the display. This statistical selection screen includes a pull-down menu in which statistical classification names are arranged. Here, the person in charge selects a statistical classification name using a pull-down menu.

  In this case, the statistical processing unit 111 of the terminal control unit 11 transmits a request for a statistical type list to the library business management server 20. This request includes the selected statistical classification name data.

  The server control unit 21 of the library business management server 20 that has received the request for the statistical type list extracts the statistical type record 231 in which the received statistical classification name is recorded from the statistical database 23. Then, the server control unit 21 transmits the statistical classification name of the statistical type record 231 to the client terminal 10.

  The terminal control unit 11 of the client terminal 10 that has received the statistical classification name displays a statistical selection screen. The statistics selection screen includes a list in which the received statistics type names are arranged. In this list, each statistic type name is associated with a statistic type ID.

Here, the person in charge selects a statistic type name in the list on the statistic selection screen. In this case, the terminal control unit 11 transmits the statistical type ID associated with the selected statistical type name to the library business management server 20.

  The server control unit 21 of the library business management server 20 that has received the statistical type ID extracts a statistical pattern record 232 including the statistical type ID from the statistical database 23. Then, the server control unit 21 transmits data regarding the statistical pattern ID and pattern name of the extracted statistical pattern record 232 to the client terminal 10.

  The terminal control unit 11 of the client terminal 10 that has received the statistical pattern ID and the pattern name displays a condition selection screen. The condition selection screen includes a list in which received pattern names are arranged. In this list, each pattern name is associated with a statistical pattern ID.

  Here, the person in charge selects a pattern name on the condition selection screen. The terminal control unit 11 of the client terminal 10 acquires a statistical pattern ID associated with the selected pattern name.

  Next, the terminal control unit 11 of the client terminal 10 executes output condition acquisition processing (step S1-2). Specifically, the statistical processing means 111 of the terminal control unit 11 displays a condition input screen 500 shown in FIG. The condition input screen 500 displays the selected statistical classification name, statistical type name, condition name, and execution button. Furthermore, the condition input screen 500 includes a condition input column for inputting each output condition such as a total period, a user category, a loan category, and the like. Further, the condition input screen 500 includes a selection field for selecting an output unit of rows and columns. Here, the person in charge inputs an output condition and an output unit in each input field, and selects an execution button. Through the above operation, the terminal control unit 11 of the client terminal 10 acquires the input output condition and output unit.

  Next, the terminal control unit 11 of the client terminal 10 executes an aggregation request process (step S1-3). Specifically, the statistical processing unit 111 of the terminal control unit 11 transmits a count request to the library business management server 20. The aggregation request includes the acquired statistical pattern ID, the output condition and output unit, and the logged-in person in charge ID.

  The server control unit 21 of the library business management server 20 executes a process for registering aggregate information such as output conditions and execution date / time conditions (step S1-4). Specifically, the statistical processing unit 211 of the server control unit 21 generates a statistical history record 233 with a new statistical history ID. Next, the statistical processing means 211 records the received statistical pattern ID, output condition, output unit, and person in charge ID in this statistical history record 233. Further, the statistical processing means 211 records the current date in the execution date / time data area of the statistical history record 233. The statistical history record 233 is recorded in the statistical database 23.

Next, the server control unit 21 of the library business management server 20 executes a counting process (step S1-5). Specifically, the statistical processing unit 211 of the server control unit 21 extracts the statistical pattern record 232 in which the statistical pattern ID received from the client terminal 10 is recorded from the statistical database 23. Then, the statistical processing means 211 specifies the database to be accessed (here, the browsing database) among the library database 22 from the database specifying identifier set in the detailed condition of the extracted statistical pattern record 232. The statistical processing means 211 extracts the lending management record 220 that matches the received output condition and the total condition of the statistical pattern record 232 from this database. The statistical processing unit 211 calculates a total value obtained by totaling the extracted lending management records 220 for each received output unit item. In this case, the statistical processing means 211 temporarily stores in the work memory the data ID of the lending management record 220 used for calculating each aggregate value in association with this aggregate value.

  Next, the server control unit 21 of the library business management server 20 executes a statistical processing result registration process (step S1-6). Specifically, the statistical processing unit 211 of the server control unit 21 specifies the number of rows and the number of columns according to the received number of items in the output unit. Next, the statistical processing means 211 specifies the position of the cell for displaying each total value calculated in step S1-5 from the number of rows and the number of columns. Further, the statistical processing unit 211 arranges the total values in the order in which they are arranged at the specified cell positions. Then, the statistical processing unit 211 records the specified number of rows and columns and the total values arranged in the order of the table format in the total result data area of the statistical history record 233. Further, the statistical processing means 211 generates block data including the row number and column number where each aggregate value is arranged and the data ID temporarily stored in association with the aggregate value, and the statistical history record 233 Record in the tabulation result detailed data area.

  Next, the server control unit 21 of the library business management server 20 executes a transmission process of the statistical processing result including the data ID of the total value (step S1-7). Here, the statistical processing unit 211 of the server control unit 21 generates statistical result display screen data including a total result list based on the total result data and the total result detailed data of the statistical history record 233. Specifically, the statistical processing unit 211 generates a table of the number of rows and the number of columns of the aggregation result data. The statistical processing unit 211 generates a summary result list that sequentially displays each summary value of the summary result data in each cell of the generated table. Next, the statistical processing means 211 embeds the data ID of the data obtained by calculating the total value displayed in each cell in each cell of the total result list. Further, the statistical processing means 211 embeds a statistical type ID in this tabulated result list. Then, the statistical processing unit 211 transmits the statistical result display screen data to the client terminal 10.

  The terminal control unit 11 of the client terminal 10 executes a result output process (step S1-8). Specifically, the statistical processing unit 111 of the terminal control unit 11 displays a statistical result display screen including the total result list 600 illustrated in FIG. 8A based on the received statistical result display screen data. Thus, the statistical process ends.

(Detail display process)
Next, the detailed display process performed when browsing the content of the total value displayed in one cell of the total result list 600 will be described with reference to FIG.

  First, the person in charge double-clicks and selects a cell in which an aggregate value whose contents are to be browsed is displayed. In this case, the terminal control unit 11 of the client terminal 10 executes a program activation process corresponding to the statistical type (step S2-1). Specifically, the statistical processing unit 111 of the terminal control unit 11 identifies the statistical type ID embedded in the tabulation result list 600. Next, the statistical processing means 111 specifies the program identifier corresponding to this statistical type ID in the startup program table. Then, the statistical processing unit 111 activates a business processing client program (in this embodiment, a browsing client program) corresponding to the program identifier.

  Next, the terminal control unit 11 of the client terminal 10 executes a data ID specifying process corresponding to the selected cell (step S2-2). Specifically, the statistical processing unit 111 of the terminal control unit 11 specifies the data ID embedded in the selected cell.

Next, the terminal control unit 11 of the client terminal 10 executes a data content reference request process (step S2-3). Specifically, the statistical processing unit 111 of the terminal control unit 11 provides the business processing unit 110 with a search request including the specified data ID. The business processing means 110 transmits the acquired data ID to the library business management server 20, thereby
Make a data request.

  The server control unit 21 of the library business management server 20 executes a search process for the received data ID data (step S2-4). Specifically, the business processing unit 210 of the server control unit 21 searches the library database 22 (browsing database) for a business processing management record (lending management record 220) in which the received data ID is recorded.

  Next, the server control unit 21 of the library business management server 20 executes transmission processing of the extracted data (step S2-5). Specifically, the business processing unit 210 of the server control unit 21 transmits the business process management record (lending management record 220) extracted in step S2-4 to the client terminal 10.

  The terminal control unit 11 of the client terminal 10 executes the display process of the detailed contents of the total value for the selected cell (step S2-6). Specifically, the business processing unit 110 of the terminal control unit 11 displays a search result display screen that displays a list of received business processing management records (lending management records 220). Here, a list display screen 650 shown in FIG. 8B is displayed on the display. This list display screen 650 includes the contents of the six data obtained by calculating the total value “6” of the cell selected by the person in charge. Thus, the detailed display process ends.

(Output unit narrowing process)
Next, output unit narrowing-down processing for displaying the aggregated values displayed in one cell of the aggregated result list 600 in a further fine classification will be described with reference to FIG.

  First, the person in charge right-clicks and selects a cell in the tabulation result list 600 in which the tabulated value to be sub-classified is displayed. In this case, the terminal control unit 11 of the client terminal 10 executes output unit list display processing (step S3-1). Specifically, the statistical processing unit 111 of the terminal control unit 11 extracts the output unit associated with the statistical type ID of the tabulation result list 600 from the output unit table. The statistical processing means 111 specifies output units excluding output units already used as output units of the total result list 600 among the extracted output units as displayable output units. As shown in FIG. 9A, the statistical processing unit 111 generates a pull-down menu 610 in which the specified displayable output units are arranged and displays them in the vicinity of the selected cell.

  Next, the terminal control unit 11 of the client terminal 10 executes a process for specifying an output unit to be subdivided (step S3-2). Here, the person in charge clicks and selects one output unit in the pull-down menu. In this case, the statistical processing unit 111 of the terminal control unit 11 specifies the selected output unit as the fine classification output unit.

  Next, the terminal control unit 11 of the client terminal 10 executes a block data specifying process for the selected cell (step S3-3). The statistical processing means 111 of the terminal control unit 11 specifies the row number and column number of the selected cell. Further, the statistical processing means 111 specifies the data ID embedded in this cell.

  Next, the terminal control unit 11 of the client terminal 10 executes output narrowing aggregation request processing (step S3-4). Specifically, the statistical processing unit 111 of the terminal control unit 11 specifies the statistical history ID embedded in the statistical result list 600. The statistical processing means 111 transmits a fine classification instruction including the specified row number, column number, data ID, statistical history ID, and fine classification output unit to the library business management server 20.

The server control unit 21 of the library business management server 20 executes a search process for the aggregation target data (step S3-5). Specifically, the statistical processing unit 211 of the server control unit 21 extracts a statistical history record 233 in which the received statistical history ID is recorded in the statistical database 23. The statistical processing means 211 specifies the statistical pattern record 232 in which the statistical pattern ID included in the statistical history record 233 is recorded. The statistical processing unit 211 specifies a target database corresponding to the database specifying identifier of the detailed condition of the statistical pattern record 232. The statistical processing means 211 searches the specified target database for a business process management record in which the received data ID is recorded. Here, the statistical processing unit 211 searches the browsing database for the lending management record 220 in which the received data ID is recorded.

  Next, the server control unit 21 of the library business management server 20 executes a data totaling process in the subcategory output unit (step S3-6). Specifically, the statistical processing unit 211 of the server control unit 21 calculates the total value of the fine classification by totaling the lending management records 220 extracted by the search in step S3-5 by the item of the fine classification output unit. To do.

  Next, the server control unit 21 of the library business management server 20 executes a process of transmitting the fine classification tabulation result data (step S3-7). Specifically, the statistical processing unit 211 of the server control unit 21 specifies a cell for displaying the recount value according to the acquired row number and column number. Then, the statistical processing unit 211 generates a re-aggregation aggregation result list in which the item names of the fine classification output items and the aggregation values are arranged in the specified cell. The statistical processing means 211 generates statistical result redisplay screen data including the generated total result list. Then, the statistical processing unit 211 transmits the statistical result redisplay screen data to the client terminal 10.

  The terminal control unit 11 of the client terminal 10 executes display processing of the recount value in the selected cell (Step S3-8). Specifically, the statistical processing unit 111 of the terminal control unit 11 displays a statistical result redisplay screen including the total result list 700 illustrated in FIG. 9B based on the received statistical result redisplay screen data. . In the total result list 700, the total value for each item of the selected output unit is displayed in the selected cell. Thus, the output unit narrowing process ends.

According to this embodiment, the following effects can be obtained.
(1) In this embodiment, the library business management server 20 that has received a counting request from the client terminal 10 executes a counting process (step S1-5). In this tabulation process, the server control unit 21 of the library business management server 20 generates tabulation result data and tabulation result detailed data, records them in the statistics history record 233, and transmits them to the client terminal 10. The total result data is composed of row number data, column number data, and total value data. The total result detailed data is constituted by block data including line number data of the total value, column number data, and data ID data of the data for which the total value is calculated, being continued via a line feed code. For this reason, the aggregation value of the aggregation result data is associated with the data ID of the data for which the aggregation value is calculated. The terminal control unit 11 of the client terminal 10 executes a result output process based on the received aggregation result data (step S1-8). After that, when a cell of the tabulation result list 600 is selected by double-clicking, the terminal control unit 11 of the client terminal 10 includes the data ID of data constituting the tabulation value displayed in the selected cell. A search request is made (step S2-3). And the terminal control part 11 acquires the business process management record specified by this data ID, and performs the display process of the detailed content of the total value of the selected cell (step S2-6). Therefore, if the person in charge wants to view the detailed contents of the aggregated value, he / she can easily grasp the contents of the aggregated value simply by selecting the cell he / she wants to browse and use the statistical results effectively. Can do.

(2) In this embodiment, the server control unit 21 of the library business management server 20 generates statistical result display screen data including a summary result list (step S1-7). The terminal control unit 11 of the client terminal 10 displays a statistical result display screen including the total result list 600 based on the statistical result display screen data. Further, the server control unit 21 of the library business management server 20 generates statistical result redisplay screen data including a summary result list. The terminal control unit 11 of the client terminal 10 displays a statistical result redisplay screen including the summary result list 700 based on the statistical result redisplay screen data. For this reason, the processing load in the client terminal 10 can be reduced.

  (3) In the present embodiment, the statistical processing unit 111 of the terminal control unit 11 stores an activation program table in which programs to be activated corresponding to statistical types are associated. When the cell of the tabulation result list 600 is selected by double-clicking, the terminal control unit 11 of the client terminal 10 executes a program activation process corresponding to the statistical type (step S2-1). In this case, the terminal control unit 11 identifies a program identifier corresponding to the statistical type ID associated with the summary result list 600 from the activation program table, activates the business processing client program corresponding to the program identifier, Content reference request processing is executed (step S2-3). Accordingly, since the client terminal 10 automatically activates an appropriate program according to the statistical type, it is possible to easily acquire and output the contents of the lending management record 220 for which the total value has been calculated.

  (4) In the present embodiment, the statistical processing unit 111 of the terminal control unit 11 executes the output unit list display process when the cell displaying the total value of the total result list 600 is selected by right-clicking. (Step S3-1). When the output unit is selected, the statistical processing unit 111 of the terminal control unit 11 executes the output narrowing aggregation request process (step S3-4), and the block data, the statistical history ID, and the fine classification output unit. Is transmitted to the library business management server 20. Based on the data ID acquired from the client terminal 10, the server control unit 21 of the library business management server 20 executes a search process for data to be aggregated, a data aggregation process in a subcategory output unit, and a transmission process for the aggregated data ( Steps S3-5 to S3-7). And the terminal control part 11 of the client terminal 10 performs the display process of the recount value in the selected cell (step S3-8). For this reason, since a part of the result of statistical processing can be further classified and displayed, the result of statistical processing once performed can be used effectively.

  (5) In this embodiment, the terminal control unit 11 of the client terminal 10 specifies a cell for displaying the recount value in the recount value display process (step S3-8) in the selected cell, and this In the cell, the re-aggregation table in which the item names of the received fine classification output items and the respective aggregation values are arranged is displayed in the specified cell. For this reason, since the result of the fine classification about the part which performed the fine classification can be displayed on the same screen as another part, a statistical result can be analyzed comparing with another total value.

Moreover, you may change the said embodiment as follows.
In the statistical processing of the above embodiment, the server control unit 21 of the library business management server 20 transmits the total result data and the total result detailed data to the client terminal 10 (step S1-7). Instead of this, the server control unit 21 may transmit only the total result data to the client terminal 10. In this case, in response to a request from the client terminal 10, the data ID constituting the total value displayed in the selected cell is transmitted to the client terminal 10. Specifically, in the detailed display process, when the cell displaying the total value is selected, the terminal control unit 11 of the client terminal 10 transmits the row number and column number of this cell to the library business management server 21. As a result, a data ID acquisition request is made. The statistical processing means 211 of the library business management server 21 acquires from the statistical history record 233 block data in which the acquired cell row number and column number are recorded. Then, the statistical processing unit 211 transmits the acquired block data to the client terminal 10. In this case, since it is only necessary to transmit a part of the total result detailed data to the client terminal 10, the communication load can be reduced.

  In the output unit narrowing process of the above embodiment, when one cell is selected, sub-classification is performed on the aggregate value displayed in this cell. The number of cells for subclassification is not limited to one. For example, a plurality of cells may be selected to perform subclassification. Specifically, a plurality of cells displaying aggregate values to be finely classified are selected and right-clicked. In this case, the terminal control unit 11 obtains block data (row number, column number, and data ID) of each aggregate value displayed in the selected cells in the output narrowing aggregation request process (step S3-4). It transmits to the library business management server 20. The server control unit 21 of the library business management server 20 executes a search process for data to be aggregated, a data aggregation process in a subcategory output unit, and a transmission process for the aggregated data (steps S3-5 to S3-7). In the transmission processing of the totaled data (step S3-7), the server control unit 21 specifies a cell for displaying the retotal value according to the row number and column number of each selected cell. The server control unit 21 generates a reaggregation aggregation result list in which the item names of the fine classification output items and the aggregation values are arranged in the specified cell. Thereby, it is possible to browse the aggregated values of a plurality of cells to be compared and analyzed at the same time in the same output unit.

  In the above embodiment, the person in charge selected one output unit in the output unit narrowing process (steps S3-1 to 3-8). The number of output units selected in the output unit narrowing process is not limited to one, and a plurality of output units may be selectable. In this case, for example, as shown in FIG. 10, a tabulation result list 800 obtained by subdividing the selected cell into a table format may be displayed. Further, in this case, the display position of the output unit selected as the fine classification may be determined according to the strength of the association with the output unit already selected before the fine classification. Specifically, the server control unit 21 of the library business management server 20 stores an output unit relation table that records records in which relevant output units are associated with each other. For example, in this output unit relation table, an output unit of “affiliation” and an output unit of “school year” are associated with each other. Then, the server control unit 21 of the library business management server 20 specifies the cell for displaying the re-aggregated value in the aggregated data transmission process (step S3-7), It is determined using the output unit relation table whether or not there is a relationship with the displayed output unit. Specifically, a record in which the subcategory output unit and the already displayed output unit are registered is searched in the output unit relation table. Here, when the corresponding record is extracted from the output unit association table, the server control unit 21 outputs the output unit of the same axis (row or column) as the axis (row or column) on which the output unit is displayed. Generate a table displaying the subcategory output unit and include it in the identified cell. In this case, the person in charge can view the subcategories together with the total values of other cells. Further, when all of the aggregate values of the items of the fine classification output unit are “0”, this item may be deleted. Specifically, the server control unit 21 of the library business management server 20 searches for a row or column in which the aggregate values in one row or one column are all “0” in the item of the fine classification output unit. If there is a corresponding row or column, the server control unit 21 displays the tabulation result of the tabular recalculation in which this item is omitted. As a result, it is possible to perform analysis while paying attention to a row or column in which a predetermined value is set.

In the statistical processing of the above embodiment, the server control unit 21 of the library business management server 20 includes the total result list 600 in the statistical processing result transmission processing (step S1-7) including the data ID of the total value. Statistical result display screen data was generated. Further, the server control unit 21 generates statistical result redisplay screen data including the generated total result list 700 in the transmission process of the totaled data (step S3-7). The tabulation result lists 600 and 700 to be displayed may be generated not only by the server control unit 21 of the library business management server 20 but also by the terminal control unit 11 of the client terminal 10. In this case, the processing load on the library business management server 20 can be reduced.

  In the above-described embodiment, the server control unit 21 of the library business management server 20 performs the aggregation process for aggregating data for each specified classification (output unit) as the statistical process. The statistical processing is not limited to the aggregation processing, and other statistical processing such as processing using a normal distribution may be performed. Even in this case, the server control unit 21 records the statistical history data together with the statistical processing result, with the management target record constituting the statistical processing result as the statistical processing result details. Specifically, the server control unit 21 stores the management data identifier of the management target record in which the statistical value of each display range is calculated in association with each display range of the statistical processing result as the statistical processing result details. In this case, it is possible to easily grasp the management target record constituting the statistical processing result.

  DESCRIPTION OF SYMBOLS 10 ... Client terminal, 11 ... Terminal control part, 12 ... Display part, 13 ... Input part, 20 ... Library business management server, 21 ... Server control part, 22 ... Library database, 23 ... Statistical database, 110, 210 ... Business processing Means, 111, 211... Statistical processing means.

Japanese Patent Laying-Open No. 2006-4341 (FIGS. 11, 14, and 16) JP 2006-4356 A (FIGS. 1, 3 and 4)

Claims (5)

Connected to a client terminal having an input means for inputting an instruction for statistical processing, an output means for outputting a statistical processing result, and a management target data storage means for storing a management target record associated with the management data identifier With
A statistical processing system comprising statistical history data storage means for storing the results of statistical processing, and control means,
The control means includes
According to the output condition and output unit acquired from the client terminal, statistical processing means for executing statistical processing of the management target record recorded in the management target data storage means,
A statistical result storage means for associating a statistical processing result with a management data identifier of a management target record constituting the statistical processing result and recording it in the statistical history data storage means;
Statistical processing result output means for outputting the statistical processing result to the client terminal;
A statistical processing system comprising: statistical processing detailed result transmission means for transmitting a management data identifier of a management target record constituting the statistical processing result to the client terminal. In the statistical history data storage means, aggregated result data and aggregated result detailed data are recorded in association with each other,
The statistical processing means extracts management data that conforms to the output condition in the management target data storage means, and executes statistical processing to tabulate the management data for each output unit item,
The statistical processing result output means includes
Means for generating and recording data for displaying tabulated values for each item of the output unit in tabular form as the tabulated result data;
Means for generating and recording block data including position information for specifying the position of each cell in the table and management data identifiers of management data constituting the total value displayed in the cell as the total result detailed data; The statistical processing system according to claim 1, further comprising: The control means includes
Subclassification including a subclassification output unit for displaying subclassification information in the aggregation result data from the client terminal, and a management data identifier of management data constituting a total value displayed in the subclassification target cell Means for receiving instructions;
The management object data storage means retrieves the management object record of the management data identifier included in the subclassification instruction, and aggregates the extracted management data according to the item of the output unit of the subclassification received, and the total value is the client terminal. The statistical processing system according to claim 2, further comprising means for transmitting sub-category count result data to be displayed in step 1. Connected to a client terminal having an input means for inputting an instruction for statistical processing, an output means for outputting a statistical processing result, and a management target data storage means for storing a management target record associated with the management data identifier With
A statistical processing method using a statistical processing system comprising statistical history data storage means for storing the results of statistical processing and control means,
The control means includes
According to the output condition and output unit acquired from the client terminal, a statistical processing stage for performing statistical processing of the management target record recorded in the management target data storage means;
A statistical result storage step of associating a statistical processing result with a management data identifier of a management target record constituting the statistical processing result and recording it in the statistical history data storage means;
A statistical processing result output stage for outputting the statistical processing result to the client terminal;
A statistical processing detailed result transmission step of transmitting a management data identifier of a management target record constituting the statistical processing result to the client terminal; Connected to a client terminal having an input means for inputting an instruction for statistical processing, an output means for outputting a statistical processing result, and a management target data storage means for storing a management target record associated with the management data identifier With
A statistical processing program for use in a statistical processing system comprising statistical history data storage means for storing the results of statistical processing, and control means,
The control means;
Statistical processing means for performing statistical processing of the management target record recorded in the management target data storage means according to the output condition and output unit acquired from the client terminal,
A statistical result storage means for associating a statistical processing result with a management data identifier of a management target record constituting the statistical processing result and recording it in the statistical history data storage means;
Statistical processing result output means for outputting the statistical processing result to the client terminal, and statistical processing detailed result transmission for transmitting a management data identifier of a management target record constituting the statistical processing result to the client terminal A statistical processing program characterized by functioning as a means.

Images