KR100458542B1 - Integrated Table Providing Method - Google Patents

Abstract

The present invention relates to a method for creating an integrated statistical table that can represent a plurality of statistical tables with different row data or column data as a single statistical table. A first step of providing a user interface comprising; A second step of receiving, from a user, a selection of the number, direction, and presence of a mixed connection of the connection statistics table through each check box of the user interface; A third step of activating an additional sheet corresponding to the selection according to the user's selection and receiving information on an additional row or information on an additional column from the user; And a fourth step of integrating two or more statistical tables into one statistical table by connecting the number of statistical tables selected by the user in a mixing or non-mixing manner in a direction selected by the user.

Description

Integrated Table Providing Method

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for creating a statistical table based on information in a database, and more particularly, to a method for creating an integrated statistical table capable of expressing a plurality of statistical tables having different row data or column data as a single statistical table.

In general, the statistics writer is a tool that retrieves the data in the database, processes the statistics according to the user's request, and then outputs them in the form of a table desired by the user.

1 is a block diagram showing the configuration of a statistics generator according to the prior art. The statistics builder is composed of a user interface 100, a structured query language (SQL) builder 110, a data fetcher 120, a statistics value processor 130, a table builder 140, and a database 150. Here, the user interface 100, the SQL writer 110, the data fetcher 120, the statistical value processor 130, and the table writer 140 are constituent blocks of a general application program, and are loaded into the main memory of the computer when executed. It works. The database 150 is a set of data stored in the auxiliary storage of the computer in a certain configuration form and stores information necessary for generating a report.

The user interface 100 is a configuration block that receives information about a row, a column, a content item, and a required statistical value of a statistics table that a user wants to create, and typically uses a graphical user interface (GUI) in a PC. The SQL writer 110 is a block for constructing SQL for fetching data from the database 150 by using information about rows, columns, and content items input from the user. The data extractor 120 is a configuration block for extracting data necessary for preparing a statistical table from the database 150 using the SQL written in the SQL writer 110. The statistical value processor 130 is a configuration block for obtaining a statistical value desired by the user using the extracted content item data. There are five types of statistical functions for content items that are commonly used: sum, average, maximum, minimum, and count. The table builder 140 is a block for constructing a statistical table using the retrieved row data, column data, and the obtained statistical value.

Here, the information on the rows means information on the data constituting the vertical axis of the statistics table, the information on the columns means information on the data constituting the horizontal axis of the statistics table, and the information on the content items is the information on these rows and columns. Means information on the data to be drawn as a component of the matrix constituting the data.

2 and 3 is an exemplary design sheet and statistics table showing the distribution of personnel by the final education of each department according to the prior art. 3 is a department name as the information on the row in the design sheet, as shown in Figure 2, the education information for the column, the resident number is selected for the content item, and the number for the statistical function for the content item is selected Statistical tables provided in the case. In this case, the reason why the social security number is selected as the content item is that the data on the social security number is composed of only the non-overlapping values, so that the number of the item, that is, the number of persons can be accurately obtained.

4 and 5 are exemplary design sheets and statistical tables showing the distribution of gender personnel for each department according to the prior art. FIG. 5 shows a department name as information on a row, a gender as a information about a column, a resident number as a information about a content item, and a number as a statistical function for a content item as shown in FIG. Statistical tables provided in the case.

The statistical tables according to FIGS. 3 and 5 have different column data but the same row data. Therefore, for such data, the function of integrating different column data for the same row data and displaying them in one statistical table may be useful. Although the function of showing the contents of FIGS. 3 and 5 in one statistical table is useful in the actual statistical table creation, the function is not implemented in the existing statistical generator.

That is, according to the prior art, if the rows or columns are different, there is an inefficient problem of manually combining new statistical documents by combining the results of designing different statistical tables and executing the results as the statistical tables.

The present invention has been made to solve the above problems, and when designing a statistical document, if the number of rows or columns of each statistical table is different and cannot be made into a single statistical table, a single statistical table is created by concatenating each statistical table into one. The purpose is to provide a method for doing so.

1 is a block diagram showing the configuration of a statistics generator according to the prior art.

2 and 3 is an exemplary design sheet and statistics table showing the distribution of personnel by the final education of each department according to the prior art.

4 and 5 are exemplary design sheets and statistical tables showing the distribution of gender personnel for each department according to the prior art.

6 is a block diagram showing the configuration of a statistics builder incorporating the present invention.

7 is a flowchart illustrating a method of creating an integrated statistical table according to the present invention.

8 illustrates an example of a user interface provided by the present invention.

9 and 10 show examples of additional sheets provided by the present invention.

11 illustrates an example of a consolidated statistical table provided by the present invention.

In order to achieve the above object, a configuration of the present invention is as follows. An integrated statistical table creating method for creating a statistical table in a statistical writer that statistically processes data in a database according to a user's request and outputs the data in a predetermined table format. A first step of providing a user interface including a number of columns of statistical tables to be linked to a user from among two or more statistical tables having different numbers of columns or information about the content items, a direction selection box of the statistical tables to be linked, and a check box for whether there is a mixed link; A second step of receiving, from a user, a selection of the number, direction, and presence or absence of a mixed connection table of connection statistics tables through respective check boxes of the user interface; A third step of activating an additional sheet corresponding to the user selection of the second step and receiving information on an additional row or information on an additional column from the user; And a fourth step of connecting the statistical tables of the number selected by the user in a mixed or non-mixed manner in the direction selected by the user and integrating them into one statistical table.

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

6 is a block diagram showing the configuration of a statistics builder incorporating the present invention. The user interface 600, the SQL writer 610, the data fetcher 620, the statistical processor 630, the table writer 640, and the database 650 shown in FIG. The statistics builder corresponds to the user interface 100, the SQL builder 110, the data fetcher 120, the statistics processor 130, the table builder 140, and the database 150, respectively.

In order to obtain a statistical table integration function according to the present invention, the user interface 600 provides information on the information on the row data, the information on the column data, the number of statistical tables to be linked, the connection direction of the statistical tables to be linked, the presence or absence of mixed connection at the time of connection It further includes an integrated information input processing unit 602 to receive input from the user. In addition, the data extractor 620 further includes an integrated data extractor 622 for extracting data of all the statistical tables to be integrated from the database 650, and the table builder 640 stores the columns in a fixed state. Fetch and expand the content data in a row in a horizontal direction, or pull and expand the content data in a row in a vertical direction with a fixed column, or a combination of both methods to pull and expand the data in rows and columns in a vertical and horizontal direction. An integrated statistical table generator 642 for creating a statistical table is further provided.

7 is a flow chart illustrating a method of creating an integrated statistical table according to the present invention.

First, the user inputs information on the row data of the statistics table, information on the column data, information on the statistical function for each content item, and information on how to display the data when there is more than one type of content item. Create a statistical document of the statistical table (S 710).

As described above, according to an exemplary embodiment of the present invention according to FIGS. 2 and 3, the user has a final education level as information on column data, a department name as information on row data, and a social security number as information on content item data. Is entered.

Next, the user is selected whether to create a connection statistics document or a consolidated statistical table incorporating a plurality of statistical tables (S 720). When the integrated statistics table creation is not selected, for example, individual statistics tables as shown in FIGS. 3 and 5 are created for the statistics table creation user interface of FIGS. 2 and 4 (S 750 ′).

If the user selects the connection statistics setting, the user interface is provided to the user, including a check box of the number of statistics tables to be linked, a direction check box of the statistics tables to be linked, and a check box for whether there is a mixed connection, and the number of connection statistics tables from the user through each check box of the user interface. In step S730, the controller receives a selection of direction and mixed connection.

The number of statistical tables that can be linked in the number of statistical table selection box is preferably 2 to 10, the statistical table direction selection column may include a horizontal direction and a vertical direction, the mixed connection presence or absence check box is a horizontal direction and vertical It may include a 'yes' menu when the mixed connection in the same direction at the same time, and a 'no' menu when connected only in one of the horizontal direction or vertical direction.

8 illustrates an example of a user interface provided by the present invention. Referring to the drawings, the connection statistics number check box 810 is set to two means to combine two different statistics table into one statistics table, and the connection statistics direction check box 820 is set to horizontal so that the two Since the statistics tables have the same rows, the number of rows is fixed and the columns are interconnected in the horizontal direction by expanding only the columns. The mixed connection check box 830 is set to 'no' so that the horizontal and vertical directions are the two directions. It can be seen that they are only interconnected in a single horizontal direction, not mixed connections.

According to the user's selection, the additional sheet corresponding to the selection is activated, and information about the additional row or the additional column is input to the additional sheet from the user (S740).

9 is a view showing an example of an additional sheet provided in the present invention. As a user selects connection statistics by FIG. 8, a new sheet called 'statistic 2' as shown in FIG. 9 is added and provided to the user.

In this additional sheet, the consolidation statistics direction is selected horizontally in FIG. 8, so that the rows are fixed and the information about the additional columns are horizontally integrated. In order to add the statistical table as shown in FIG. 5 to the result statistical table of FIG. 3 by the sheet of FIG. 2, the user may create and execute the design sheet as shown in FIG. 10 having the same format as that made in FIG. 4. Referring to FIG. 10, the information about the row is fixed to the department name as in FIG. 2, the gender is selected as the information on the added column, the resident number is selected as the information about the content item, and the statistics function about the content item. Indicates that the number is selected. FIG. 10 is the same as the same sheet as in FIG. 4, but the total part does not need to be duplicated because the sheet of FIG. 2 already includes the total part. Therefore, the total part is not shown and the title is selected as the gender. Is a different design sheet.

As a result, when the two sheets of FIG. 2 and FIG. 10 are executed, a statistical table in which different column information, that is, educational information of FIG. 2 and gender information of FIG. 10 are integrated into one can be provided (S750).

11 illustrates an example of a consolidated statistical table provided by the present invention.

Referring to the drawings, it can be seen that the statistical table of FIG. 3 and the statistical table of FIG. 5 are integrated into one statistical table.

To summarize the results so far, first, the sheet of Fig. 2 is a statistical table in which row information is defined as department names such as management team, logistics team, sales team, and material team, and column information is defined as academic records such as high school, doctoral, master's, and bachelor's degree. Next, since the number of connection statistics is two by the user interface of FIG. 8, a new statistics table is additionally integrated to add two statistics tables as a whole, and the connection direction is set in a horizontal direction so that the row information is fixed. Waits for input of additional column information, and finally, additional column information defined by gender is inputted by the user-created sheet of FIG. 10 based on the additional sheet of FIG. The consolidated statistics table of FIG. 10 is provided in which the statistics table is integrated.

In the present invention, the method of integrating two statistical tables in which the number of columns to the information of the columns are different has been described, but the present invention is not limited thereto. That is, it is possible to integrate by selecting two or more consolidation statistics for two or more statistics tables, and the selection of the direction of the consolidation statistics in FIG. It is possible to combine the two statistics tables in a simple way, and moreover, it is possible to provide one statistical table that is integrated with each other by selecting a mixed connection even for a plurality of statistical tables that differ in both the number and information of columns and rows.

According to the present invention, there is an effect that a plurality of statistical tables having different rows and columns can be easily integrated into one statistical table.

In addition, according to the present invention, it is possible to reduce the waste of time and manpower that the author of the document has to execute the sheets separately to manipulate the results, and to eliminate the possibility of errors that can be caused by manual work, It is effective to check complex and various result documents or statistics tables in one sheet.

Claims (7)

In the integrated statistics table creation method to create a statistics table in the statistics builder that statistically processes the data in the database as required by the user and outputs it in the form of a regular table, A first step of providing a user interface including a selection number of statistical tables to be linked to a user among two or more statistical tables having different numbers of rows and columns or information on the content items thereof, a direction selection box of statistical tables to be linked, and a check box for whether there is a mixed connection or not; A second step of receiving, from a user, a selection of the number, direction, and presence or absence of a mixed connection table of connection statistics tables through respective check boxes of the user interface; A third step of activating an additional sheet corresponding to the user selection of the second step and receiving information on an additional row or information on an additional column from the user; And A fourth step of connecting the statistical tables of the number selected by the user in a mixed or non-mixed manner in the direction selected by the user and integrating them into one statistical table; Integrated statistics table creation method comprising a. The method of claim 1, Method for producing a statistical table, characterized in that the range of the number of statistical tables that can be connected in the statistical table number selection column. The method of claim 1, The statistical table direction selection box includes a horizontal direction and a vertical direction. The method of claim 1, The mixed connection check box includes a 'yes' menu when mixed connection in a horizontal direction and a vertical direction at the same time, and a 'no' menu when only one direction is connected in a horizontal direction or a vertical direction. How to create a statistics table. The method according to any one of claims 3 to 4, In the second step, when the user selects the horizontal direction and selects 'no', the additional sheet of the third step is fixed with the number of rows for each statistical table having the same row and different columns. A method of creating a statistical table, characterized in that it is performed in a non-mixed manner to add columns in the horizontal direction. The method according to any one of claims 3 to 4, If the user selects the vertical direction in the second step and selects no mixed connection, the additional sheet of the third step is vertical while the number of columns is fixed for each statistical table having the same column and different rows. A method of creating a statistical table, characterized in that it is executed in a non-mixed manner to add rows in the direction. The method according to any one of claims 3 to 4, If YES is selected in the second step, the additional sheet of the third step is mixed to add a column in the horizontal direction and a row in the vertical direction for each statistical table having different rows and different columns. Statistics table creation method characterized in that the execution.