JP2943720B2 - Master table search means generator - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a master table search function generator, and more particularly to a master table search function generator used to create a system using a database.

[0002]

2. Description of the Related Art Conventionally, as one of system development methods using a database, there is a development method using a master table.

[0003] A master table encodes data such as a customer name and a product name in data, for example.
It is a table showing the correspondence. By using the master table, when the data is changed, the change processing can be performed only by changing the data in the master table without changing the data in all the tables. Also, by reducing the data length by coding, the data amount of the database can be reduced.

[0004] However, the developer of the application system needs to code logic for searching the master table in order to convert the code obtained from the table into the corresponding data.

[0005]

As described above, a developer of an application system using a database must code logic for searching a master table using a code as a key when acquiring coded data. . That is, the conventional function of defining a table cannot provide a function of searching the table at the same time.

SUMMARY OF THE INVENTION It is an object of the present invention to obtain data corresponding to a code of a system using a database without requiring a developer of the system to be conscious of the data structure of the master table and coding logic for searching the master table. It is an object of the present invention to provide a master table searching means generating device capable of performing the above.

[0007]

According to the present invention, there is provided a master table retrieving means generating apparatus in a database system having a data table including a code obtained by coding data, and a master table indicating a correspondence between the data and the code. , A search function that refers to the master table when the master table is generated.

[0008] In addition, the present invention provides a master table search means generating apparatus in a database system having a data table including a code obtained by coding data, and a master table indicating a correspondence between the data and the code.
A master table definition unit is configured to generate the master table in accordance with the definition information defining the master table and to generate a search function that refers to the master table.

Further, the present invention provides a master table search means generating apparatus in a database system having a data table including a code obtained by coding data, and a master table indicating a correspondence between the data and the code.
A table definition unit that generates a data table and a master table according to arbitrary definition information, and a master table definition unit that generates a search function that refers to the master table according to definition information that defines the master table .

Further, in the master table search means generating device of the present invention, the master table definition section inputs definition information for defining a master table, sends out a search function for referring to the master table, and transmits the definition information to the master table. It is sent to a table definition unit, and the table definition unit is configured to generate a master table based on the definition information.

Further, in the master table search means generating apparatus of the present invention, the master table definition section generates a character string type search function or a numeric type search function corresponding to the data type of data to be searched for in the master table. It is configured so that

Further, in the master table searching means generating apparatus of the present invention, the search function is a character string type or a numerical type corresponding to a data type of data to be searched for in the master table.

[0013] The master table search means generating apparatus of the present invention further comprises a definition information discriminator for identifying whether the input table definition information is data table definition information or master table definition information; A table definition unit includes a table generation unit that generates a data table or a master table based on the table information, and a search function generation unit that generates a search function that searches the master table based on the master table definition information.

That is, according to the master table searching means generating device of the present invention, when a function for defining a master table is created and a master table is defined, a function for searching the master table is also defined. The developer causes the function corresponding to the process of acquiring data corresponding to the code from the master table. Therefore, by using the function, the developer can use the master table without being aware of the structure of the master table and without coding logic for searching the master table.

[0015]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing a first embodiment of the present invention. In the figure, a master table search means generating device according to the present invention includes a table definition section 1 for generating a data table 3, a first master table 4, and a second master table 6 according to respective definition information, and a master table for each. Search function 5 that refers to each master table according to definition information that defines
And a master table definition unit 2 that generates the data items 7 and 7.

The master table definition section 2 inputs definition information defining each master table, sends search functions 5 and 7 for referring to each master table, and sends each definition information to the table definition section 1. The table definition unit 1 generates a first master table 4 and a second master table 6 based on each definition information.

Further, the above-mentioned table definition section 1 stores the RDBM
S (relational database management system; hereinafter, referred to as RDBMS) is a table definition function provided as standard. The data table 3 is generated by the table definition unit 1 based on the definition of the data table. Further, the first master table 4 and the second master table 6 are generated by the table definition unit 1 based on the respective definitions. Each of these master tables is a table indicating the correspondence between code data.

FIG. 2 is an explanatory diagram showing an example of the operation of the master table definition unit 2. In the figure, a master table definition unit 2 generates a master table 4a via a table definition unit 1 based on a master table definition 2a. At the same time, the master table definition unit 2 generates a master table search function 5a or 5b. Here, a master table search function is created for a character string type or a numeric type corresponding to the data type of data to be searched for in the master table.

The master table search function has a plurality of arguments. The first argument indicates a column name to be searched, and the second and subsequent arguments indicate a code of data to be searched. This code corresponds to the key in the master table. The return value is data retrieved using the second argument or less as a key.

FIG. 3 is a flowchart showing the processing of the master table search function. In the figure, first, a step 51 checks whether or not the input argument is a normal value.

Next, a step 52 searches the target master table for the item specified by the first argument, using the arguments below the second argument as keys. Then, in step 53, it is checked whether or not the retrieved data is normal.
If there is no error here, this data is used as a return value and the process ends.

Further, in step 54, error processing corresponding to each of the errors generated in the above steps is performed.

The master table search function is classified into a character string type and a numerical type, but the processing flow is the same.

FIG. 4 is a block diagram showing an example of an application system using the data table and the master table created as described above. Referring to FIG. 8, in the application program 8, first, the data table search unit 81 searches the data table 3 to acquire data.

Next, the first master table search function calling unit 82 converts a code relating to the first master table 4 into data by the first master table search function 5 in the acquired data.

Further, the second master table search function calling unit 83 converts a code relating to the second master table 6 into data in the acquired data by the second master table search function 7.

The processing unit 84 executes a predetermined process using the data obtained as described above.

FIG. 5 is an explanatory diagram showing a specific example of the embodiment of the present invention. In the figure, a table definition unit 1 generates a sales table 3a based on the definition of a sales table. Similarly, a customer master 4b and a product master 6a are generated based on the definition of the customer master and the definition of the product master, respectively.

The master table definition unit 2 also stores a character string type customer master search function 5c, a character string type product master search function 7a, and a numeric type product master based on the customer master definition and the product master definition. Search function 7
Generate b. Here, since no numeric data exists in the customer master 4b, no numeric customer master search function is generated.

The sales table 3a shows sales-related data and is a data table including a customer code and a product code. The customer master 4b is a master table showing the correspondence between customer codes, customer names, and addresses. Further, the product master 6a is a master table showing correspondence between product codes, product names, and unit prices.

The character string type customer master search function 5c
Searches the customer master 4b using character string data as a search target and uses the customer code as a key to extract the customer name or address. The character string type product master search function 7a searches the product master 6a by using the product code as a key with the character string type data as a search target, and extracts a product name. Further, the numeric-type product master search function 7b searches for the product master 6a by using the product code as a key, and extracts the unit price using the numeric-type data as a search target.

FIG. 6 is an explanatory diagram showing an example of an application system using the database created in FIG. Referring to the figure, in the application program 8a, a step 81 is performed from the sales table 3a in the Sales No. (Record) with key as key
To get.

Next, a step 82a calls the character string type customer master search function 5c to search the customer master 4b and obtain the customer name corresponding to the corresponding customer code.
Further, a step 83a calls the numeric type product master search function 7b to search the product master 6a, and obtains a unit price corresponding to the corresponding product code.

In step 84a, a sales slip is created for each customer name using the data obtained in each of the above steps. In the example of FIG. 1002, the customer master 4b and the product master 6
a, the customer name “Yamada” and the unit price “80” are obtained,
The sales amount 400 (quantity 5 × unit price 80) is output to the sales slip.

FIG. 7 is a block diagram showing a second embodiment of the present invention. In the figure, a master table search means creating device according to the present invention provides a definition information discriminating unit 1 for identifying whether input table definition information 10a is data table definition information or master table definition information.
1 and a data table 3 based on the table definition information.
The table definition unit 10 includes a table generation unit 12 that generates 0 or a master table 40, and a search function generation unit 13 that generates a search function 50 that searches the master table based on the master table definition information.

In the above-described table definition unit 10, the table generation unit 12 realizes the function of the table definition unit 1 shown in FIG. 1, and the search function generation unit 13 and the definition information discrimination unit 11 operate in the master table shown in FIG. The function of the definition unit 2 is realized. With the above configuration, a table definition function including a data table and a master table can be handled in an integrated manner.

[0038]

As described above, according to the present invention, the means for searching the master table can be generated from the definition information of the master table. Therefore, by using this means (search function), the developer can acquire the data of the master table without directly accessing the master table. As a result, there is an effect that the master table can be used without being aware of the structure of the master table and without having to code logic for searching the master table.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a first embodiment of the present invention.

FIG. 2 is an explanatory diagram showing an operation of a master table definition unit.

FIG. 3 is a flowchart showing processing of a master table search function.

FIG. 4 is a block diagram showing an example of an application system using the present invention.

FIG. 5 is an explanatory view showing a specific example of the present invention.

FIG. 6 is an explanatory view showing a specific example of the present invention (continued).

FIG. 7 is a block diagram showing a second embodiment of the present invention.

[Explanation of symbols]

 1 Table definition part 2 Master table definition part 3 Data table 4, 6 Master table 5, 7 Master table search function 8 Application program

Continuation of the front page (56) References JP-A-7-110832 (JP, A) JP-A-7-160558 (JP, A) JP-A-6-223118 (JP, A) JP-A-2-1444671 (JP) , A) JP-A-63-298626 (JP, A) JP-A-7-73199 (JP, A) Ryosuke Hotaka, "Introduction to Illustrated Computer Series Database" p. 7. Ohmsha (December 25, 1978) Nikkei Byte D ECEMBER 1987, PP. 183-189, FIG1 (58) Fields investigated (Int. Cl. ⁶ , DB name) G06F 17/30 G06F 12/00 512

Claims (7)

(57) [Claims] 1. In a database system having a data table including a code obtained by coding data and a master table indicating a correspondence between the data and the code, the master table is referred to when the master table is generated. A master table search means generating device for generating a search function. 2. In a database system having a data table including a code obtained by coding data and a master table indicating a correspondence between the data and the code, the master table is generated according to definition information defining the master table. And a master table definition unit for generating a search function that refers to the master table. 3. In a database system having a data table including a code obtained by coding data and a master table indicating a correspondence between the data and the code, a data table and a master table are generated according to arbitrary definition information. A master table search means generation device, comprising: a table definition unit; and a master table definition unit that generates a search function that refers to the master table according to definition information that defines the master table. 4. The master table search means generating apparatus according to claim 3, wherein said master table definition section inputs definition information defining a master table, sends out a search function referring to said master table, and outputs said definition information. Is sent to the table definition unit, and the table definition unit generates a master table based on the definition information. 5. The master table search means generating apparatus according to claim 2, wherein said master table definition unit includes a character string type search function or a character string type search function corresponding to a data type of data to be searched for in a master table. A master table search means generating device for generating a numerical search function. 6. The master table search means generating apparatus according to claim 1, wherein said search function is a character string type or a numeric type corresponding to a data type of data to be searched for in a master table. Table search means generation device. 7. A definition information discriminator for identifying whether the input table definition information is data table definition information or master table definition information, and table generation for generating a data table or a master table based on the table definition information. A master table search means generation apparatus, comprising: a table definition unit including a unit and a search function generation unit that generates a search function for searching the master table based on the master table definition information.