JP2842487B2 - Data editing method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data editing system for retrieving information stored in a database and editing the retrieved data.

[0002]

[Prior art]

Conventional example 1. FIG. 10 shows, for example, the following document (Japanese Unexamined Patent Publication No.
This is a conventional graph creation method that is well known by Japanese Patent Application Publication No. -302883: a graph creation device. In the figure, 1 is an input device for inputting a search request or a graph display request, 2 is a means for searching a database according to a search request, 3 is a database to be searched, 4 is a search result in a table format, and 6 is a graph according to a graph display request. Means for creating, 7 is a created graph, 10 is a column attribute table of search results, and 11 is a rule book having knowledge for creating a graph.

Next, the operation will be described. When a search request is input from the input device 1, the search target database 3 is searched by the database search means 2, and a search result 4 in the form of a table and a column attribute table storing the attributes of the columns of the search result 4 are created. Further, when a graph display request including designation of a column to be graphed is input from the input device 1, the graph display means 6 performs creation of an intermediate table, graph drawing, and graph output with reference to the graph drawing rule 11. .

Conventional example 2. FIG. 11 shows a table or graph creation method performed by a normal application program. In the figure, 1 is an input device for starting a program, 2
Is a means for searching a database necessary for creating a specific table or graph, 3 is a database to be searched, 6 is a means for creating a specific table or graph, 7 is a created table or graph, and 12 is a specific table or graph. This is a program for creating tables or graphs.

Next, the operation will be described. When the editing program is started from the input device 1, the database search means 2
Thus, the necessary search target database 3 is searched, and the graph display means 6 creates a specific table or graph 7.

[0006]

Since the conventional data editing system is configured as described above, a general database search is instructed to display a graph by specifying a column to be graphed. There is a need. This method of specifying a column is intended for a search file that is quite complicated using a large number of aggregation keys, and is as complex as a database search means. Also, in order to create a table graph with more detailed editing, it was necessary to individually create a dedicated application program for that purpose.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and an object of the present invention is to provide a data editing method which can automatically create a table or a graph by a simple operation and whose procedure can be easily defined. With the goal.

[0008]

The database according to the present invention is provided.
Data editing methods such as search results
A search structure obtained by analyzing the search request for the search request
In addition to storing the information, the search
A column or set of columns to be roughened or a set of column candidates
Identify and search the search pattern from the search structure information, search
It has a means to edit the data
It has an element of. (A) data storage means for storing data having a predetermined attribute as a search result ; (b) the same data as the data stored in the data storage means
Structure information storage that stores attributes as part of search structure information
Means, analyzes the search request by entering (c) a search request, the
After creating the search structure information, the search structure information
Together is stored in the granulation information storage unit, it searches a main input
Request and obtain the search result and store it in the data storage means.
Search means for, stored in the structural information storing means by (d) said search means
Is stored in the data storage means based on the retrieved structure information.
Editing means for editing data.

Further , according to the present invention, information obtained from search structure information is obtained.
Name of the procedure to be invoked according to the search pattern
The editing processing dictionary is described, and the editing means includes a search pattern.
Separate specific procedures for performing editing operations corresponding to
And the data editing method further comprises:
An edit processing dictionary for storing a procedure name to be started in accordance with a predetermined pattern; and a procedure storage means for storing a procedure for editing data corresponding to the procedure name stored in the edit processing dictionary. Analyzing the search structure information created by the search means stored in the structure information storage means, extracting a predetermined pattern, and selecting a procedure name to be activated based on the edit processing dictionary; And an editing unit for activating the procedure stored in the procedure storage unit and editing the data stored in the data storage unit.

Further , according to the present invention, a specific editing is requested.
Introduce a keyword to the database
A search request analysis dictionary that describes the relationship between sets of attributes of the
Procedure to be activated for each keyword in response to a specific editing request
And has the following elements.
You. (A) a database storing data having a predetermined attribute , (b) a predetermined keyword related to the keyword
An analysis dictionary for storing attributes of data stored in a database ; (c) a procedure storage means for storing a procedure for editing data corresponding to the keyword; (d) inputting a search request including the keyword; Attribute related to the keyword stored in the analysis dictionary
Used, the database retrieval means for retrieving the database, (e) by the procedure corresponding to the keyword stored in the procedure storage means, editing means for editing the retrieved data in the database retrieval means.

[0011]

In the data editing method for database search results and the like according to the first invention, search structure information such as data attributes and types is stored and analyzed to recognize and edit data search patterns. By providing the editing means, it becomes unnecessary to input a data editing request.

[0012] In the second invention, by providing an editing dictionary that describes the names of procedures to be activated for each predetermined pattern of data such as a search pattern, and a procedure storage means for storing these procedures, Can be changed for each application system or for each individual.

According to a third aspect of the present invention, there is provided a search request analysis dictionary describing a relationship between a keyword requesting a specific edit and a set of database attributes required for the specific edit, and a dictionary for a specific edit. By providing the editing means for executing the procedures in association with each other, the database searching means and the editing means can be provided separately when performing a specific editing, and the description of the keyword is added to the analysis dictionary. Different search is possible only by change,
Also, the editing means can easily perform new editing by storing the procedure for editing data corresponding to the keyword in the procedure storage means.

[0014]

【Example】

Embodiment 1 FIG. An embodiment of the first invention will be described with reference to the drawings.
FIG. 1 is a diagram showing the configuration and processing flow of an embodiment in a database search device according to the present invention. 10 is an input device for making a database search request, 5 is search structure information of a search request, 8 is a search request analysis dictionary used by the database search means, and 9 is a comparison with the configuration and operation flow diagram of the conventional example of FIG. Edit processing dictionary, 16 is a procedure storage means, 6
1 is a search structure analysis means, 62 is an intermediate table creation means,
Reference numeral 63 denotes an editing process executing unit. Other parts correspond to the conventional configuration.

The database search means 2 receives a database search request from the input device 1, analyzes the search request with reference to the analysis dictionary 8, creates search structure information 5 (an example of structure information storage means), and And search results in a tabular format 4 (an example of data storage means)
Create The search pattern for the table or graph display means 6 (an example of the editing means) is examined to identify an attribute or a set of attributes to be a main search target. The main search target corresponds to a column to be graphed specified by the input device in FIG.

After that, the table or graph display means 6 creates an intermediate table from the search results 4 in accordance with the search pattern in the intermediate table creating means 62. The editing processing executing means 63 creates the table or graph 7 by referring to the editing processing dictionary 9 according to the search pattern.

Next, the operation will be described with reference to FIG. In FIG. 2, it is assumed that a search request of “sales by product group” in 13a is made. The database search means 2 analyzes this to create search structure information of 10a, searches the sales accumulation database of 3a and the product group database of 3b, and obtains a search result in a table format of 4a.

Creation of search structure information 10a from search request 13a and search result 4 from search structure information 10a
For example, “a” can be obtained by using “correspondence table using database search device” of a patent application (Japanese Patent Application No. 3-171217) filed by the same applicant. But,
In particular, it is possible to create such a structure without using this method. The application is directed to a search request in Japanese sentence. For example, when there is a tabular search request, search structure information can be created from the search request. These search structure information 10a and search result 4
Since the specific method of obtaining a is not an important part of the present invention, a detailed description thereof will be omitted, and here, it is assumed that the search structure information 10a and the search result 4a are obtained from the search request 13a and the databases 3a and 3b. It will be described as a premise.

The search structure analysis means 61 analyzes the search structure information 10a according to the flow shown in FIG. 3 to obtain the search pattern 14a. The method of checking the search pattern 14a from the search structure information 10a is as follows. is there. First, the search structure information 10a shown in FIG. 2 is input in S30 of FIG. Here, the search types are classified into “variable”, “object”, and “subject of comparison”. For example, in the search request "What is sales by product group?", "Product group" is "variable", "sales" is "target", and "product group"
Search results are displayed in the order of “sales”. Also, as another example, in the case of the search request "What is the product group with the most sales?"
“Sales” is “comparison subject” and “product group” is “target”, and search results are displayed in the order of “product group” and “sales”. In step S31, the search type is determined. In the example of FIG. 2, the attributes to be searched are "major classification code", "small classification code", and "product classification" as shown on the left side of the search structure information 10a. Name, and “sales”, and their properties are, as shown on the right side of the search structure information 10a, the 3
One is “variable” and the last “sales” is “target”. As described above, since “variable” is included in the search types, the search types are “variable” and “object” as they are. Then, these four searched attributes are set as search target attributes in order of 1
The attribute numbers of ~ 4 are assigned as follows. Major classification code: Attribute number 1 Minor classification code: Attribute number 2 Product classification name: Attribute number 3 Sales: Attribute number 4 Then, in S32, since “Sales” whose search type is “Target” is a numerical value in a statistical value, It is determined that graph output is possible. In S33, the attribute number 4 of “sales” is stored as the search target attribute.

Next, in S34, grouping of attributes whose search type is "variable" is performed. Search structure information 10a
The variables described in this search are grouped into (major category code, minor category code) and (product category name) using the attributes described in (1) and the corresponding reference database information. That is, the first group consisting of the “major classification code” and the “small classification code” is regarded as the same group because all the attribute types are “code”. Further, in S35,
When the reference database of the next group consisting of “product category name” is checked, the reference database (product group master database) is the same as the reference database of the (major category code, minor category code) group, and the two are the same. , And the number of the aggregation key is one and the number of the aggregation key attribute is stored as 1 to 3 in S36.

Next, from the search pattern 14a, it is known that the number of total keys is one and the main attribute to be searched is one, so the intermediate table creating means 62 determines the representative attribute of the total key and the search target attribute. Intermediate table 15a consisting of
Is created as described below.

FIG. 4 is a diagram showing a procedure for obtaining the intermediate table 15a from the search pattern 14a. In the example of FIG. 2, since the number of total keys is 1, the last attribute of the total key "product classification name" is determined in S43. ”And a search target attribute“ sales ”alone are created as an intermediate table. Number of aggregation keys is 0
In the case of, a table of only the search results is created in S42,
Intermediate table. When the number of total keys is 2, a description will be given in a second embodiment described later. Next, the editing process executing means 63
Starts a standard procedure when the main axis is the representative attribute of the aggregation key and the statistical axis is the search target attribute from the intermediate table 15a, and creates the graph 7a.

Embodiment 2 FIG. In the first embodiment, the number of aggregation keys is 1
In the second embodiment, the case where the number of total keys is 2 will be described. In FIG. 5, it is assumed that a search request of “monthly sales for each product group” 13b is made. The database search means 2 analyzes this to create search structure information 10b, searches the cumulative sales database 3a and the merchandise group database 3b, and obtains a table-based search result 4b. The search structure analysis means 61 analyzes the search structure information 10b using the flow shown in FIG.
Know b. From the search pattern 14b, the number of total keys is 2
Since the main search target attribute is found to be one, the intermediate table creating unit 62 determines whether
By using S46, an intermediate table 15b is created which includes search target attributes in which the representative attribute of the aggregation key 1 is on the vertical axis and the representative attribute of the aggregation key 2 is on the horizontal axis. From the intermediate table 15b, the editing process executing means 63 sets the main axis as a representative attribute of the total key 2,
A standard procedure when the auxiliary axis is the representative attribute of the aggregation key 1 and the statistical axis is the search target attribute is started, and the graph 7b is created.

As described above, in the first and second embodiments, in the information search for searching the database, the search structure analyzing means 61 for determining the logical structure of the search, the intermediate table creating means 62, and the search result are automatically stored. The data editing method of the search result has been described in which the editing processing executing means 63 for performing the editing is used, and the editing means for displaying a table or a graph using the editing means is used.

According to the first and second embodiments, the provision of the search structure information and the search structure analyzing means 61 for analyzing the search structure information eliminates the need to input a column to be graphed in response to the search request. Table or graph creation processing can be automatically performed for various search patterns.

Embodiment 3 FIG. An embodiment of the second invention will be described with reference to the drawings. FIG. 1 is a diagram showing the configuration and processing flow of an embodiment in a database search device according to the present invention.
In the figure, reference numeral 9 denotes an editing dictionary, which stores the name of a procedure to be started for each search pattern. FIG. 6 is an example showing the contents of the editing dictionary 9 and procedures A and B.

Next, the operation will be described with an example.
In FIG. 2, it is assumed that a search request of “sales by product group” in 13a is made. The table or graph display means 6 analyzes the search structure information 10a to find the search pattern 14a,
An intermediate table 15a is created. Editing process executing means 63
Knows that there is only one aggregation key in the search pattern 14a, and obtains the procedure A with the standard processing procedure name 9a. When the processing procedure is started by specifying the processing procedure name 9a, the procedure A is executed. Procedure A creates a bar graph 7a using the first column "product classification name" of the intermediate table 15a as a main axis and the second column "sales" as a statistical axis.

In FIG. 5 , it is assumed that a search request of “monthly sales for each product group” 13b is made. The table or graph display means 6 analyzes the search structure information 10b to find out the search pattern 14b and creates an intermediate table 15b. The editing processing executing means 63 knows that the total number of keys is two by looking at the search pattern 14b, and obtains the procedure B with the standard processing procedure name 9b. When the processing procedure is started by specifying the processing procedure name 9b, the procedure B is executed. In the procedure B, the value of “month”, which is the column item name of the second and subsequent columns of the intermediate table 15b, is the main axis, the value of “sales”, which is the value of the second and subsequent columns, is the statistical axis, and the value of the first column Then, a superimposed line graph 7b is created using the “product classification name” as an auxiliary axis.

As described above, in the third embodiment, in the information search for searching the database, the graph is displayed according to the search structure analyzing means 61 and the intermediate table creating means 62 for determining the logical structure of the search. The data editing method of the search result, which has the editing process executing means 63 for activating the procedure for executing the search, and the editing means for displaying the graph by using these, has been described.

According to this embodiment, by providing an editing dictionary describing the names of procedures to be activated for each search pattern, the procedure for creating a table or graph can be changed for each application system or for each individual. it can. Also,
By providing a standard procedure and providing a means of modifying the procedure, it is possible to automatically create a standard table or graph and to respond to a wide variety of requirements for the format of the table or graph.

Embodiment 4 FIG. An embodiment of the third invention will be described with reference to the drawings. FIG. 1 is a diagram showing the configuration and processing flow of an embodiment in a database search device according to the present invention.
In the drawing, reference numeral 8 denotes an analysis dictionary, which stores a required attribute set of a database and a table creation request ID for a keyword requesting creation of a specific table or graph.

FIG. 7 shows an example of the contents of the analysis dictionary 8, showing an example in which the dictionary heading (keyword) is "sales status". The attribute numbers are sequentially numbered, but the higher attribute numbers indicate a hierarchical relationship, with the attributes “sales” and “gross profit” having the upper attribute “sales status”, and “sales” The lower part has the sales amount of the sales accumulation database 3a, and is obtained by this total operation. The “gross profit” also has the lower part of the gross margin amount of the sales accumulation database 3a, and is obtained by this total operation. I have.

The database search means 2 analyzes the database search request using the search request analysis dictionary 8, searches for a database including a required database attribute set, and searches for information including a tabulation request ID. The structure information 5 and the search result 4 are created.

Reference numeral 9 denotes an editing dictionary, which is a tabulation processing request I
For D, the name of the procedure activated for each search pattern is stored. Table or graph display means 6 is used to retrieve search structure information 5
Is analyzed by the search structure analysis means 61, and the search pattern and the tabulation request ID are checked. The intermediate table creating means 62 creates an intermediate table according to the search pattern. The editing process executing means 63 checks the editing process dictionary 9 from the search pattern and the tabulation request ID, and executes a corresponding procedure.

Next, the operation will be described with an example.
In FIG. 8, it is assumed that a search request of “sales status by customer” 13c is made. It is assumed that the word "sales status" is a keyword requesting a superimposed graph of sales, gross profit, and gross profit rate. The database search means 2 analyzes this using the search request analysis dictionary 8 and uses the customer code and the customer name of the customer master database as variables, targets "sales status", and stores sales cumulatively as an attribute. The search structure information of 10c in which “sales” and “gross profit”, which are the sum of the sales amount and the gross profit in the database, are searched is created. According to the search structure information, the sales accumulation database of 3a and the customer master database of 3c are searched to search for sales and gross profit, and a search result in a table format of 4c is obtained.

The retrieval structure analysis means 61 retrieves the retrieval structure information 1
By analyzing 0c, the search pattern 14c is known. The search structure information 10c indicates that the number of aggregation keys is one, the main search target attributes are two, and there is a tabulation request ID “sales status”. Intermediate table 15c consisting of attributes and search target attributes
Create The editing processing executing means 63 is provided for editing the editing dictionary 9
, It can be seen that the tabulation request ID is “sales status” and the number of aggregation keys is one.
After obtaining the procedure c of c, the corresponding processing procedure 16c is started.

The processing procedure 16c reads the intermediate table 15c, calculates a gross profit rate from sales and gross profit for each row,
A superimposition graph 7c of sales, gross profit, and gross profit rate is created using the main axis as a representative attribute of the aggregation key.

As described above, in the fourth embodiment, in the information search for searching the database, a predetermined keyword and an analysis dictionary for storing items related to the keyword are provided.
It has an editing dictionary for registering predetermined procedures and procedure storage means. When there is a search request including a keyword, the logical structure of the search is determined and automatically edited, and the keyword and the search pattern are automatically edited. The method of editing the search result, which is characterized by an editing means for activating a procedure corresponding to the above and displaying a table or a graph, has been described.

In this embodiment, a search request analysis dictionary that describes the relationship between a keyword for requesting the display of a specific table or graph and a set of database attributes necessary to create the keyword is provided. By providing an editing dictionary for associating a procedure for displaying a graph, a database search unit and a table or graph creating unit when creating a specific table or graph are separated.
When you create a specific table or graph,
In the database search procedure, only a set of necessary database attributes is described, and description of the search procedure itself is unnecessary. In addition, by associating a procedure for displaying a table or a graph with a search pattern to a keyword requesting display of a specific table or a graph, the same procedure can be started for the same search pattern. For example, “sales status by customer”, “sales status by month”, “sales status by product”, etc., which conventionally required the creation of individual programs, can be performed by one process.

[0040]

As described above, according to the first aspect, by analyzing a data pattern from data structure information, it becomes unnecessary to input an editing specification request such as designating a column to be graphed. This has the effect that data editing processing such as table or graph creation processing can be automatically performed on various data patterns.

According to the second aspect of the present invention, the procedure can be changed for each application system or for each individual by providing the editing processing dictionary in which the name of the procedure to be activated for each data pattern is described.

According to the third aspect of the present invention, there is provided a search request analysis dictionary for describing a relationship between a keyword requesting specific data editing and a set of attributes of a database required for creating the keyword, and a dictionary for searching for specific data. By providing editing means for associating the above procedure, there is an effect that specific data editing can be easily performed.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration and a processing flow according to an embodiment of the first, second, and third inventions.

FIG. 2 is a diagram showing an operation example of the first invention and the second invention.

FIG. 3 is a flowchart for obtaining a search pattern from search structure information.

FIG. 4 is a flowchart for creating an intermediate table from a search pattern.

FIG. 5 is a diagram showing an operation example of the first invention and the second invention.

FIG. 6 is a diagram showing an example of an editing dictionary and procedures according to the second invention.

FIG. 7 is a diagram showing an analysis dictionary according to a third invention.

FIG. 8 is a diagram showing an operation example of the third invention.

FIG. 9 is a diagram showing an example of an editing dictionary and a procedure according to the third invention.

FIG. 10 is an explanatory diagram of a conventional database search result editing method.

FIG. 11 is an explanatory diagram of another database search result editing method.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Input device 2 Database search means 3 Database 4 Search result (an example of a data storage means) 5 Search structure information (an example of a structure information storage means) 6 Table or graph display means (an example of an edit means) 7 Table or graph 8 Analysis Dictionary 9 Dictionary for editing 10 Column attribute table 11 Graph drawing rule 12 Table application program 13 Search request 14 Search pattern 15 Intermediate table 16 Table or graph creation procedure (an example of procedure)

Claims (3)

(57) [Claims] 1. A data editing method having the following elements: (a) data storage means for storing data having a predetermined attribute as a search result ; and (b) the same data as the data stored in the data storage means .
Structure information storage that stores attributes as part of search structure information
Means, analyzes the search request by entering (c) a search request, the
After creating the search structure information, the search structure information
And the above-mentioned search result is obtained from the input search request, and the data
Search means for storing the憶means, stored in the structural information storing means by (d) said search means
Is stored in the data storage means based on the retrieved structure information.
Editing means for editing data. 2. The data editing method according to claim 1, further comprising: an editing dictionary storing a procedure name to be activated in accordance with a predetermined pattern; and a procedure name storing the procedure name stored in the editing dictionary. and procedural memory means for storing a procedure for editing the data, analyzes the search structure information stored on SL retrieval means has created the structure information storage means, extracts a predetermined pattern, to the editing processing dictionary Select the procedure name to be activated based on the procedure, activate the procedure stored in the procedure storage means,
2. The data editing method according to claim 1, further comprising editing means for editing data stored in said data storage means. 3. A data editing method having the following elements: (a) a database storing data having a predetermined attribute ; and (b) a predetermined keyword relating to the keyword.
An analysis dictionary for storing attributes of data stored in a database ; (c) a procedure storage means for storing a procedure for editing data corresponding to the keyword; (d) inputting a search request including the keyword; Attribute related to the keyword stored in the analysis dictionary
Used, the database retrieval means for retrieving the database, (e) by the procedure corresponding to the keyword stored in the procedure storage means, editing means for editing the retrieved data in the database retrieval means.