JP5487181B2 - Setting information input support apparatus and program - Google Patents

Description

  Embodiments described herein relate generally to a setting information input support apparatus and program for supporting setting of information necessary for automatic generation of an application.

  In general, applications often use relational databases. In this relational database, there may be a relationship between a plurality of tables.

  For example, if the employee table has a department number column and the department table has a department number and department column, it can be said that the employee table and the department table are related via the department number. The department name can be referred to from the department number of the employee table via the department number of the department table. For this reason, it can be said that there is a reference relationship between the employee table and the department table. Note that the department number in the employee table in such a case is called an external key in the employee table.

  When an application that accesses a table having such a reference relationship is created, the display format of the table to be referred to, the display content of the reference screen, and the like are varied.

  By the way, in recent years, systems for automatically generating applications are increasing. Therefore, when an application as described above is automatically generated, the user needs to set many items as input information in order to specify various display formats for the automatically generated application.

JP 2004-318260 A JP 2005-055951 A

  As described above, in order to automatically generate an application corresponding to the reference relationship between tables in the relational database, the user needs to set many items.

  However, if the user has to set all of these many items, it is troublesome and very complicated for the user.

  Therefore, an object of the embodiment disclosed in the present specification is to provide a setting information input support apparatus and program capable of supporting the setting of information necessary for automatic generation of an application.

  According to the embodiment, a setting information input support apparatus that supports setting of information necessary for automatically generating an application is provided.

  The setting information input support device according to the embodiment is first table information indicating a first table composed of a plurality of columns used in the application, and whether or not each of the columns is a primary key. First table information including primary key information to be displayed and each column name of the column, and second table information indicating a second table composed of a plurality of columns used in the application, An input information file in which a plurality of table information including primary key information indicating whether each is a primary key and second table information including the column name of each column is set.

  The setting information input support device according to the embodiment includes table information acquisition means for acquiring a plurality of table information set in the input information file.

  The setting information input support device according to the embodiment is indicated by the first table information based on the primary key information included in the first table information among the plurality of table information acquired by the table information acquisition unit. First determination means for determining whether a target column, which is one of a plurality of columns constituting the first table, is a primary key.

  When the first determination unit determines that the target column is not a primary key, the setting information input support device according to the embodiment includes a plurality of columns constituting the first table including the target column. The first table includes a first specifying unit that specifies a column that is a primary key based on primary key information included in the first table information.

  The setting information input support apparatus according to the embodiment includes a first foreign key candidate acquisition unit that acquires a column specified by the first specification unit as a foreign key candidate in the first table.

  The setting information input support device according to the embodiment configures a second table other than the first table configured from the target column when the first determination unit determines that the target column is not a primary key. The column that is the primary key in the second table among the plurality of columns to be identified based on the primary key information included in the second table information of the plurality of table information acquired by the table information acquisition unit Second specifying means is provided.

  The setting information input support device according to the embodiment includes a column name of the target column included in the first table information and a column name of the column specified by the second specifying unit included in the second table information. Are provided with second determination means for determining whether or not the two are the same.

  In the setting information input support device according to the embodiment, when the second determination unit determines that the column name of the target column and the column name of the column specified by the second specification unit are the same, There is provided second foreign key candidate acquisition means for acquiring a column specified by the second specifying means as a foreign key candidate in the first table.

  The setting information input support apparatus according to the embodiment includes a presentation unit that presents a column acquired as a foreign key candidate by the first and second foreign key candidate acquisition unit.

The block diagram which shows the hardware constitutions of the setting information input assistance apparatus which concerns on embodiment. The block diagram which mainly shows a function structure of the setting information input assistance apparatus 30 shown in FIG. The figure which shows an example of the data structure of the 1st table information 221 set to the input information file 22 shown in FIG. The figure which shows an example of the data structure of the 2nd table information 222 set to the input information file 22 shown in FIG. The figure which shows an example of the display item at the time of the reference contained in reference destination table definition information. The figure which shows an example of the screen at the time of the reference of a foreign key reference table. The figure which shows an example of the display item at the time of the reference contained in reference destination table definition information. The figure which shows an example of the screen at the time of the reference of a foreign key reference table. The figure which shows an example of the display item at the time of the reference contained in reference destination table definition information. The figure which shows an example of the screen at the time of the reference of a foreign key reference table. The figure which shows an example of the data structure of the rule currently hold | maintained at the input value candidate acquisition rule holding | maintenance part 23 shown in FIG. The flowchart which shows the process sequence of the setting information input assistance apparatus 30 which concerns on this embodiment. The flowchart which shows the process sequence of a 1st input value candidate acquisition process. The flowchart which shows the process sequence of a 1st input value candidate acquisition process. The figure which shows an example of the data structure of the input value candidate of the foreign key output with respect to the input value determination part. The figure which shows an example of a 1st input value candidate selection screen. The figure which shows an example of the pull-down display in the 1st input value candidate selection screen shown in FIG. The flowchart which shows the process sequence of a 2nd input value candidate acquisition process. The figure which shows an example of the data structure of the candidate of the input value of the foreign key reference destination table output with respect to the input value determination part 33. FIG. The figure which shows an example of a 2nd input value candidate selection screen. The figure which shows an example of the pull-down display in the 2nd input value candidate selection screen shown in FIG. The flowchart which shows the process sequence of a 2nd input value candidate acquisition process. The figure which shows an example of the data structure of the candidate of the input value of the foreign key reference destination structure column output with respect to the input value determination part 33. FIG. The figure which shows an example of a 3rd input value candidate selection screen. The figure which shows an example of the pull-down display in the 3rd input value candidate selection screen shown in FIG. The flowchart which shows the process sequence of a 4th input value candidate acquisition process. The figure which shows an example of the data structure of the input value candidate of the display format at the time of the reference output with respect to the input value determination part 33. FIG. The figure which shows an example of a 4th input value candidate selection screen. The figure which shows an example of the pull-down display in the 4th input value candidate selection screen shown in FIG. The flowchart which shows the process sequence of a 5th input value candidate acquisition process. The figure which shows an example of the data structure of the input value candidate of the display item at the time of the reference output with respect to the input value determination part. The figure which shows an example of the 5th input value candidate selection screen. The figure which shows an example of the pull-down display in the 5th input value candidate selection screen shown in FIG.

  Hereinafter, embodiments will be described with reference to the drawings.

  FIG. 1 is a block diagram showing a hardware configuration of the setting information input support apparatus according to the present embodiment. As shown in FIG. 1, the computer 10 is connected to an external storage device 20 such as a hard disk drive (HDD). The external storage device 20 stores a program 21 executed by the computer 10. The computer 10 and the external storage device 20 constitute a setting information input support device 30.

  The setting information input support device 30 is used to support setting of information necessary for automatically generating an application, for example.

  FIG. 2 is a block diagram mainly showing a functional configuration of the setting information input support device 30 shown in FIG.

  As illustrated in FIG. 2, the setting information input support device 30 includes an input information acquisition unit 31, an input value candidate acquisition unit 32, an input value determination unit 33, and an input information reflection unit 34. In the present embodiment, these units 31 to 34 are realized by the computer 10 illustrated in FIG. 1 executing the program 21 stored in the external storage device 20. This program 21 can be stored in advance in a computer-readable storage medium and distributed. Further, this program 21 may be downloaded to the computer 10 via, for example, a network.

  The setting information input support device 30 includes an input information file 22 and an input value candidate acquisition rule holding unit 23. In the present embodiment, the input information file 22 and the input value candidate acquisition rule holding unit 23 are stored in, for example, the external storage device 20.

  In the input information file 22, for example, information necessary for automatically generating an application is set. The information set in the input information file 22 is used, for example, when an application is automatically generated.

  In the input information file 22, table information indicating a table composed of a plurality of columns used in an automatically generated application is set for each table. The table information set in the input information file 22 includes primary key information indicating whether or not each column constituting the table indicated by the table information is a primary key, the column name of the column, and the like. . Note that information such as primary key information and column names included in the table information is preset (input) by a user, for example.

  In addition to the information set in advance, the input information file 22 automatically generates an application such as information about a table having a reference relationship with the table indicated by the table information (hereinafter referred to as a reference table). Is set as necessary information.

  The input information acquisition unit 31 acquires table information (that is, a plurality of table information) for each table set in the input information file 22 from the input information file 22. Here, the plurality of table information acquired by the input information acquisition unit 31 is information (input information) input (set) in advance by the user as described above.

  The input value candidate acquisition rule holding unit 23 holds rules used by the input value candidate acquisition unit 32 in advance. Details of the rules held in the input value candidate acquisition rule holding unit 23 will be described later.

  The input value candidate acquisition unit 32 is based on a plurality of table information (table information for each table) acquired by the input information acquisition unit 31 and a rule stored in the input value candidate acquisition rule storage unit 23. A process of acquiring a candidate for a value (input value) to be set to 22 is executed.

  The input value determination unit 33 outputs the input value candidates acquired by the input value candidate acquisition unit 32. The input value determining unit 33 determines the output value candidate to be set as a value (that is, an input value) to be set in the input information file 22 in accordance with a user operation.

  The input information reflecting unit 34 sets (reflects) the input value determined by the input value determining unit 33 in the input information file 22.

  The data structure of the input information file 22 shown in FIG. 2 will be described with reference to FIGS. As described above, table information (that is, a plurality of table information) for each table used in the application is set in the input information file 22.

  Each piece of table information set in the input information file 22 includes table definition information that defines the structure of the table indicated by the table information, and information about a table (reference destination table) that has a reference relationship with the table (hereinafter referred to as a reference table). Reference table definition information).

  Here, it is assumed that a plurality of table information including the first and second table information is set in the input information file 22. Hereinafter, the table indicated by the first table information is referred to as a first table, and the table indicated by the second table information is referred to as a second table.

  FIG. 3 shows an example of the data structure of the first table information 221 set in the input information file 22.

  The first table information 221 shown in FIG. 3 includes first table definition information 221a and first reference destination table definition information 221b.

  The first table definition information 221a includes a table name and a table ID (items thereof). In the table name item, the table name of the first table is set. In the table ID item, a table ID (table identification information) for identifying the first table is set.

  The first table definition information 221a includes, for each column constituting the first table, the column name (logical name, physical name), type, digit, scale, Not Null, primary key, external key of the column. Key, search condition, list display and exclusive control (items) are included.

  Information indicating whether each column is Null (that is, empty) is set in the Not Null item. In the primary key item, information (primary key information) indicating whether each column is a primary key is set. In the foreign key item, information indicating whether each column is a foreign key is set. In the search condition item, information indicating whether each column is an item (column) displayed as a search condition when the first table indicated by the first table information is referenced is set. In the list display item, information indicating whether each column is an item (column) displayed as a list when referring to the first table indicated by the first table information is set. In the exclusive control item, information (exclusive control information) indicating whether each first column is a column for exclusive control is set.

  The first reference destination table definition information 221b includes, for each foreign key in the first table, the foreign key name of the foreign key, the foreign key reference destination table, the foreign key reference destination configuration column, the display format and reference at the time of reference. The display item of the hour is included.

  In the item of foreign key name, a column name (physical name) of a column set as a foreign key in the first table is set. In the item of the foreign key reference destination table, a reference destination table (hereinafter referred to as a foreign key reference destination table) referred to by the foreign key in the first table is set. The items in the foreign key reference table include items of name and ID (physical name). The table name of the foreign key reference table is set in the item of the name included in the item of the foreign key reference table. In the item of ID included in the item of the foreign key reference destination table, a table ID for identifying the foreign key reference destination table is set. The item of the foreign key reference destination configuration column includes the column name (physical name) of the column that is the primary key in the table among the plurality of columns constituting the foreign key reference destination table (table set in the item). Is set.

  In the item of the display format at the time of reference, for example, the display format when the external key reference table (table set in the item) is referred to by the application is set. The reference display format (display format set in the item) includes, for example, a check box, a radio button, a combo box, a list box, and a popup.

  The item displayed when referring to the foreign key reference table (table set in the item) is set in the item of the display item at the time of reference. The items of display items at the time of reference include search conditions and list display items. A column name (physical name) of a column displayed as a search condition when the foreign key reference table is referenced is set in the search condition item included in the display item item at the time of reference. A column name (physical name) of a column displayed as a list when the foreign key reference table is referenced is set in the list display item included in the display item item at the time of reference. The item of the display item at the time of reference (the search condition and the list display included) is set when a popup is set (specified) in the item of the display format at the time of reference.

  In the first table information 221 shown in FIG. 3, the items corresponding to the dotted frame 101 (that is, the table name, table ID, logical name, physical name, type, digit, scale included in the first table definition information 221a). , Not Null, primary key, search condition, list display, and exclusive control items) are items set by the user. Further, in the first table information 221 shown in FIG. 3, items corresponding to the thick line frame 102 (that is, the external key included in the first table definition information 221a and the external included in the first reference table definition information 221b). The key name, foreign key reference table, foreign key reference destination configuration column, reference display format and reference display item) are items for which input support is performed in the setting information input support device 30.

  FIG. 4 shows an example of the data structure of the second table information 222 set in the input information file 22. The second table information 222 shown in FIG. 4 includes second table definition information 222a and second reference destination table definition information 222b.

  The second table definition information 222a includes a table name and a table ID (items) as in the first table definition information 221a. In the second table definition information 222a, for each column constituting the second table, the column name (logical name, physical name), type, digit, scale, Not Null, primary key, external key Key, search condition, list display and exclusive control (items) are included. Since these items are as described in the first table definition information 221a, detailed description thereof is omitted.

  The second reference destination table definition information 222b includes, for each foreign key in the second table, the foreign key name of the foreign key, the foreign key reference destination table, as in the first reference destination table definition information 221b. , Foreign key reference destination configuration column, reference display format and reference display item (items). Since these items are as described in the first reference table definition information 222b described above, detailed description thereof is omitted.

  Similarly to the first table information 221 shown in FIG. 3, in the second table information 222 shown in FIG. 4, the items corresponding to the dotted frame 101 are items set by the user, and the thick line frame 102 is the setting information. This is an item for which input support is performed in the input support device 30.

  In the present embodiment, items corresponding to the dotted frame 101 of the first table information 221 shown in FIG. 3 and the second table information 222 (including a plurality of table information) shown in FIG. It is assumed that is set (input).

  In the reference table definition information included in the table information set in the input information file 22 as described above, for example, a column name or the like is set in the search condition and list display item included in the display item at the time of reference ( However, depending on the setting method, it is possible to display a plurality of contents for the foreign key reference table.

  Here, with reference to FIGS. 5 to 10, a screen when referring to the foreign key reference table (hereinafter referred to as a reference screen) will be specifically described.

  Note that the foreign key reference table is assumed to be the second table indicated by the second table information 222 shown in FIG. 4 described above.

  First, as shown in FIG. 5, a case is assumed where the items of the display items at the time of reference included in the reference table definition information (the search conditions and the items of the list display included) remain blank.

  In this case, as shown in FIG. 6, the search condition area 301 provided on the reference screen 300 has “display” in the search condition item included in the second table definition information 222a shown in FIG. The logical name (column name) of the set column is displayed as a label. Here, in the search condition area 301 provided in the reference screen 300, “department number”, “department name”, and “location”, which are logical names of columns in which “display” is set in the search condition item, are displayed. Is displayed as a label.

  Further, as shown in FIG. 6, “display” is set in the list display area 302 included in the above-described second table definition information 222a shown in FIG. 4 in the list display area 302 provided in the reference screen 300. The column's logical name (column name) is displayed as a label. Here, in the list display area 302 provided in the reference screen 300, “department number”, “department name”, and “location”, which are logical names of columns in which “display” is set in the list display item, are displayed. Is displayed as a label.

  Next, as shown in FIG. 7, when a column name (physical name) is set in the display item item (reference item and list display item) included in the reference table definition information at the time of reference. Suppose. In the example illustrated in FIG. 7, “deptno” and “dname” are set in the search condition items, and “dname” and “loc” are set in the list display items.

  In this case, as shown in FIG. 8, in the search condition area 311 provided on the reference screen 310, “display” is displayed in the search condition item included in the second table definition information 222a shown in FIG. The logical name of the column in which the physical name is set in the item of the search condition included in the item of the display condition included in the item of the display item when referring to the reference table definition information shown in FIG. 7 is displayed as a label. Here, since “deptno” and “dname” are set in the search condition items included in the display item items when referring to the reference table definition information, the search condition area provided in the reference screen 310 In 311, “department number” and “department name” which are logical names of columns whose physical names are “deptno” and “dname” are displayed as labels.

  Also, as shown in FIG. 8, “display” is set in the list display item included in the second table definition information 222a shown in FIG. 4 in the list display area 312 provided in the reference screen 310. The logical name of the column in which the physical name is set in the list display item included in the item of the display item at the time of referring to the reference destination table definition information shown in FIG. 7 is displayed as a label. Here, since “dname” and “loc” are set in the list display items included in the display item items when referring to the reference destination table definition information, the list display area provided in the reference screen 310 In 312, “Department name” and “Location”, which are logical names of columns whose physical names are “dname” and “loc”, are displayed as labels.

  Next, as shown in FIG. 9, it is assumed that “none” is set in the search condition item included in the display item item when referring to the reference table definition information.

  In this case, as shown in FIG. 10, the reference screen 320 is not provided with a search condition area, and only a list display area 321 is provided. In the list display area 321 provided in the reference screen 320, as in the list display area 302 shown in FIG. 6 described above, “display” is displayed in the list display item included in the second table definition information 222a shown in FIG. ”Is displayed in the column logical name (in this case,“ department number ”,“ department name ”, and“ location ”).

  FIG. 11 shows an example of the data structure of the rules held in the input value candidate acquisition rule holding unit 23 shown in FIG. The rules held in the input value candidate acquisition rule holding unit 23 include, for example, first to fifth rules described below.

  The first rule is a foreign key candidate acquisition rule used to acquire a value candidate (foreign key input value candidate) to be set in the foreign key item. The second rule is a foreign key reference destination table candidate acquisition rule used to acquire a value candidate (candidate of an input value of the foreign key reference destination table) to be set in an item of the foreign key reference destination table. The third rule is a foreign key reference destination configuration column candidate acquisition rule used to acquire a value candidate to be set in an item of the foreign key reference destination configuration column (a candidate for an input value of the foreign key reference destination configuration column). It is. The fourth rule is a display format candidate acquisition rule at the time of reference used to acquire a value candidate (candidate of an input value of a display format at the time of reference) to be set in the item of the display format at the time of reference. The fifth rule is a display item candidate acquisition rule at the time of reference used for acquiring a value candidate (candidate of an input value of a display item at the time of reference) to be set to the item of the display item at the time of reference.

  The first rule is described in the first to third lines in the rule shown in FIG. The rule name (foreign key candidate acquisition rule) of the first rule is described in the first line of the rule shown in FIG. 11, and the contents of the first rule are described in the second and third lines. ing.

  According to the second line of the rule shown in FIG. 11 (that is, the first rule), when the target column is not the primary key and the column for exclusive control, the primary key in the table including the target column is displayed. Is described as a foreign key candidate. Further, according to the third line of the rule shown in FIG. 11 (that is, the first rule), if the target column is not the primary key and exclusive control column, a table other than the table composed of the target column. Describes that a column that is a primary key and that has the same column name (physical name) as the target column is a candidate for a foreign key.

  The second rule is described in the fourth and fifth lines in the rule shown in FIG. The rule name (foreign key reference destination table candidate acquisition rule) of the second rule is described in the fourth line of the rule shown in FIG. 11, and the contents of the second rule are described in the fifth line. Yes.

  Note that, according to the fifth line of the rule shown in FIG. 11 (that is, the second rule), the column name (physical name) is the foreign key name (value set in the item) of the target foreign key. It is described that a table (that is, a column having the same column name as the foreign key name) and the column of which is the primary key is a candidate for the foreign key reference table.

  The third rule is described in the sixth and seventh lines in the rule shown in FIG. The rule name of the third rule (foreign key reference destination configuration column candidate acquisition rule) is described in the sixth line of the rule shown in FIG. 11, and the contents of the third rule are described in the seventh line. ing.

  Note that, according to the seventh line of the rule shown in FIG. 11 (that is, the third rule), the table referred to by the target foreign key (that is, set in the item of the foreign key reference table of the target foreign key) In this table, the column that is the primary key is described as a foreign key reference destination constituent column candidate.

  The fourth rule is described in the 8th to 10th lines in the rule shown in FIG. The rule name of the fourth rule (display format candidate acquisition rule at the time of reference) is described in the eighth line of the rule shown in FIG. 11, and the contents of the fourth rule are described in the ninth and tenth lines. Is described.

  According to the ninth line of the rule shown in FIG. 11 (that is, the fourth rule), the column (that is, the foreign key reference destination) set in the item of the foreign key reference destination configuration column of the target foreign key. It is described that when the number of digits of a column in which a physical name is set in the component column is 1, a check box, a radio button, a combo box, and a list box are candidates for a display format at the time of reference. In addition, according to the tenth line of the rule shown in FIG. 11 (that is, the fourth rule), when the number of columns in the column set in the foreign key reference destination configuration column of the target foreign key is 2 or more Describes that a popup is a candidate for a display format at the time of reference.

  The fifth rule is described in the 11th and 12th lines in the rule shown in FIG. The rule name of the fifth rule (display item candidate acquisition rule at the time of reference) is described in the eleventh line of the rule shown in FIG. 11, and the contents of the fifth rule are described in the twelfth line. Yes.

  In addition, according to the 12th line of the rule shown in FIG. 11 (that is, the fifth rule), the table (foreign key reference table) set in the item of the foreign key reference table of the target foreign key is configured. It is described that a column that is not a column for exclusive control among a plurality of columns to be used is a display item candidate at the time of reference.

  Next, a processing procedure of the setting information input support device 30 according to the present embodiment will be described with reference to the flowchart of FIG.

  The input value candidate acquisition unit 32 executes the processes from step S1 onward in the order of each of the first to fifth rules included in the rules held in the input value candidate acquisition rule holding unit 23 described above. To do.

  The input information acquisition unit 31 acquires a plurality of table information (input information set for each item) set in the input information file 22 from the input information file 22 (step S1).

  Next, the input value candidate acquisition unit 32 uses a target rule (for example, the first rule) to acquire a value (input value) candidate to be set in the input information file 22 (hereinafter, input value candidate). Acquisition process) (step S2). Details of the input value candidate acquisition process executed in step S2 will be described later.

  Next, it is determined whether or not an input value candidate has been output in the input value candidate acquisition process in step S2 (step S3).

  When it is determined that an input value candidate has been output (YES in step S3), the input value determination unit 33 presents the input value candidate to the user. In this case, the user can select (specify) an input value (that is, a value to be set in the input information file 22) from among the input value candidates presented by the input value determining unit 33.

  The input value determining unit 33 determines an input value from among input value candidates presented to the user in accordance with the user operation (step S4). In other words, the input value determining unit 33 determines an input value candidate designated by the user as an input value among the input value candidates presented to the user.

  The input information reflecting unit 34 reflects (sets) the input value determined by the input value determining unit 33 in the input information file 22 (step S5).

  Next, it is determined whether or not the processing after step S1 described above has been executed with all the first to fifth rules as target rules (step S6).

  If it is determined that the process is not executed with all the rules as target rules (NO in step S6), the process returns to step S1 and is repeated.

  In this case, the process after step S1 is executed by setting the next rule that is not the target rule as the target rule. Specifically, since the processing is executed with the first to fifth rules as target rules in order, for example, when the target rule is the first rule, the next rule is the second rule as the target rule. The process after step S1 is performed.

  By repeating the process in this manner, the input value candidate acquisition process is executed using each of the first to fifth rules.

  On the other hand, when it is determined that the process has been executed for all the rules (YES in step S6), the process is terminated.

  If it is determined in step S3 that no input value candidate is output, the process in step S6 is executed.

  As described above, in the process of the setting information input support device 30, the input value candidate acquisition process (the process of step S2) is executed using each of the first to fifth rules. This input value candidate acquisition process differs depending on the contents of the rules used (that is, the first to fifth rules).

  When the input candidate acquisition process is executed using the first to fifth rules in order, each of the table information (table definition information and reference table definition information included) set in the input information file 22 , It is checked whether or not values are set in the order of the foreign key (foreign key name), the foreign key reference destination table, the foreign key reference destination constituent column, the reference display format, and the reference display item.

  Here, each input value candidate acquisition process when the first to fifth rules are used will be described in detail.

  In the following description, the input value candidate acquisition process when the first rule is used is the first input value candidate acquisition process, and the input value candidate acquisition process when the second rule is used is the second input value candidate. The acquisition process, the input value candidate acquisition process when the third rule is used, the third input value candidate acquisition process, and the input value candidate acquisition process when the fourth rule is used are the fourth input value candidate acquisition process. The input value candidate acquisition process when the fifth rule is used is referred to as a fifth input value candidate acquisition process.

  In the description of the first to fifth input value candidate acquisition processes, for the sake of convenience, it is assumed that, for example, first and second table information are set as a plurality of table information in the input information file 22. To do. In this case, the tables indicated by the first and second table information are referred to as first and second tables, respectively. The table definition information included in the first table information is referred to as first table definition information, and the reference destination table definition information included in the first table information is referred to as first reference destination table definition information. Further, table definition information included in the second table information is referred to as second table definition information, and reference destination table definition information included in the second table information is referred to as second reference destination table definition information.

  Since the first and second table information are set as a plurality of table information in the input information file 22, the first information set in the input information file 22 in step S1 shown in FIG. 12 described above. It is assumed that the input information acquisition unit 31 acquires the second table information (values set in the respective items).

  First, the processing procedure of the first input value candidate acquisition process will be described with reference to the flowcharts of FIGS. 13 and 14.

  The first input value candidate acquisition process is an input value candidate acquisition process when the first rule (foreign key candidate acquisition rule) is used as described above. In this first input value candidate acquisition process, as a foreign key in the table among a plurality of columns constituting the table indicated by the table information set in the input information file 22 based on the first rule. Column candidates to be set (foreign key input value candidates) are acquired.

  First, the input value candidate acquisition unit 32 acquires the first and second table information acquired by the input information acquisition unit 31 (values set in the respective items) from the input information acquisition unit 31 ( Step S11). Each of the first and second table information includes table definition information and reference destination table definition information as described above. Hereinafter, the table definition information included in the first table information is referred to as first table definition information, and the reference destination table definition information included in the first table information is referred to as first reference destination table definition information. Further, the table definition information included in the second table information is referred to as second table definition information, and the reference destination table definition information included in the second table information is referred to as second reference destination table definition information.

  The input value candidate acquisition unit 32 acquires a first rule (foreign key candidate acquisition rule) included in the rules held in the input value candidate acquisition rule holding unit 23 (step S12). The processes in steps S13 to S18 described below are executed based on the first rule. Since the contents of the first rule are as described in FIG. 11 described above, detailed description thereof is omitted here.

  Next, the input value candidate acquisition unit 32 performs the following processing after step S13 for each of the columns constituting the table indicated by the table information acquired in step S11 (here, the first and second table information). Execute. Hereinafter, the column that is the target of this processing is the target column. That is, the target column is one column among a plurality of columns constituting the table indicated by the table information acquired in step S1. Here, it is assumed that one of the plurality of columns constituting the first table indicated by the first table information among the first and second table information acquired in step S11 is the target column. .

  The input value candidate acquisition unit 32 determines whether the foreign key (item) of the target column included in the first table definition information included in the first table information is null (step S13).

  When it is determined that the foreign key of the target column is null (YES in step S13), the input value candidate acquisition unit 32 selects the main column of the target column included in the first table definition information included in the first table information. Referring to the key (item), it is determined whether or not the target column is a primary key in the first table (step S14). In this case, if the primary key item of the target column included in the first table definition information is null, it is determined that the target column is not the primary key, and “O” is set in the primary key item of the target column. If so, it is determined that the target column is a primary key.

  When it is determined that the target column is not the primary key (NO in step S14), the input value candidate acquisition unit 32 performs exclusive control (of the target column included in the first table definition information included in the first table information). Referring to (Item), it is determined whether or not the target column is a column for exclusive control in the first table (step S15). In this case, if the exclusive control item of the target column included in the first table definition information is null, it is determined that the target column is not an exclusive control column, and “exclusive” is displayed in the exclusive control item of the target column. If is set, it is determined that the target column is a column for exclusive control.

  When it is determined that the target column is not a column for exclusive control (NO in step S15), the input value candidate acquisition unit 32 performs the first process based on the first table definition information included in the first table information. Foreign key candidate identification processing is executed (step S16).

  In the first foreign key candidate specifying process, the input value candidate acquiring unit 32 starts from the target column based on the value (primary key information) set in the primary key item included in the first table definition information. A column that is a primary key is searched in the first table to be configured. In this case, the input value candidate acquisition unit 32 refers to the primary key item included in the first table definition information to determine whether each of the columns constituting the first table is a primary key. The search process is executed by The input value candidate acquisition unit 32 specifies the searched column as a foreign key candidate in the first table.

  Next, the input value candidate acquisition unit 32 executes a second foreign key candidate specifying process based on the first and second table definition information included in the first and second table information (step S17). .

  In the second foreign key candidate acquisition process, the input value candidate acquisition unit 32 selects a column that is a primary key in another table (here, the second table) other than the first table including the target columns. Search for. In this case, the input value candidate acquisition unit 32 uses the second table based on the value (primary key information) set in the primary key item included in the second table definition information included in the second table information. The search processing is executed by determining whether or not each of the columns constituting the key is a primary key. The input value candidate acquisition unit 32 specifies the column that is the primary key in the second table by this search process. Next, the input value candidate acquisition unit 32 refers to the physical name (items) included in the first and second table definition information, and determines the physical name of the target column and the identified column (in the second table). It is determined whether or not the physical name of the column that is the primary key is the same. When it is determined that the physical name of the target column and the physical name of the column that is the primary key in the second table are the same, the input value candidate acquisition unit 32 determines the column that is the primary key in the second table. As a candidate for a foreign key in one table.

  As described above, when the first and second foreign key candidate specifying processes are executed, the input value candidate acquiring unit 32 determines the physical name of the column specified in the first and second foreign key candidate specifying processes. ) As a column candidate to be set as a foreign key in the first table (that is, a candidate for the input value of the foreign key) (step S18).

  If it is determined in step S14 that the target column is a primary key, and if it is determined in step S15 that the target column is a column for exclusive control, the processes in steps S16 to S18 are not executed.

  Next, the input value candidate acquisition unit 32 executes the processing from step S13 onward for all the columns constituting the table indicated by the table information (first and second table information) acquired in step S11. It is determined whether or not (step S19).

  When it is determined that the processing has not been executed for all the columns (NO in step S19), the process returns to the above-described step S13 and is repeated. In this case, the process is executed with a column for which the process after step S13 is not executed as the target column.

  On the other hand, if it is determined that the process has been executed for all columns (YES in step S19), the input value candidate acquisition unit 32 has a candidate for the input value of the foreign key acquired in the process of step S19 described above. It is determined whether or not (step S20).

  When it is determined that there is an input value candidate for the foreign key (YES in step S20), the input value candidate acquisition unit 32 outputs the input value candidate for the foreign key to the input value determination unit 33 (step) S21). Note that the foreign key input value candidates output to the input value determining unit 33 include column names (physical names) of columns that are foreign key candidates.

  On the other hand, when it is determined that there is no candidate input value for the foreign key (NO in step S20), the process in step S21 is not executed.

  In addition, when it is determined in step S13 described above that the foreign key of the target column is not null, the input value candidate acquisition unit 32 performs the foreign key included in the first reference destination table definition information included in the first table information. It is determined whether the physical name of the target column is set in the name (item) (step S22).

  When it is determined that the physical name of the target column is not set in the foreign key name (NO in step S22), the input value candidate acquisition unit 32 acquires the physical name of the target column included in the first table definition information Then, the obtained physical name of the target column is reflected (set) as the external key name in the input information file 22 (step S23). Specifically, the input value candidate acquisition unit 32 sets the physical name of the target column to the foreign key name (item) included in the first reference table definition information. This setting process is executed via the input information reflecting unit 34. When the process of step S23 is executed, the process of step S19 described above is executed.

  On the other hand, when it is determined that the physical name of the target column is set as the foreign key name (YES in step S22), the process of step S23 is not executed, and the process of step S19 described above is executed.

  As described above, in the first input value candidate acquisition process, for example, when the target column that is one of the plurality of columns constituting the first table is not the primary key and the column for exclusive control, A column that is a primary key in the first table and a column that is a primary key in a second table other than the first table and that has the same physical name as the target column are foreign keys in the first table. As a column candidate (candidate of input value of foreign key).

  13 and 14 described above, the column constituting the first table is described as the target column. However, the columns constituting the table other than the first table (here, the second table) are not included. The same applies to the case of the target column.

  Here, the first input value candidate acquisition process will be specifically described with reference to FIGS. 3 and 4 described above. Here, a case will be described in which each of the columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is a target column.

  First, a case is assumed where a column whose logical name is “employee number” among a plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is a target column. Hereinafter, a column whose logical name is “employee number” is simply referred to as an “employee number” column. The same applies to the other columns.

  In this case, “◯” is set in the item of the primary key in the “employee number” column included in the first table definition information 221a included in the first table information 221 shown in FIG. Therefore, the “employee number” column is the primary key (column) in the first table. Therefore, when the “employee number” column constituting the first table is the target column, the input value candidate of the foreign key is not acquired.

  Next, it is assumed that the “name” column of the plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is the target column.

  In this case, the primary key item and the exclusive control item in the “name” column included in the first table definition information 221a included in the first table information 221 illustrated in FIG. 3 are null. Therefore, the “name” column is not the primary key column and the exclusive control column in the first table.

  Here, in the first table including the “name” column as the target column, the “employee number” column is the primary key as described above. Therefore, in the first foreign key candidate specifying process described above, the “employee number” column is specified as a foreign key candidate in the first table.

  On the other hand, according to the first table definition information 221a shown in FIG. 3, the physical name of the “name” column is “ename”. Further, according to the second table definition information 222a shown in FIG. 4, the main key column in the table (here, the second table) other than the first table composed of the “name” column is the main table. This is a “department number” column in which “◯” is set in the key item. Further, according to the second table definition information 222 a shown in FIG. 4, the physical name of the “department number” column is “deptno”.

  Here, the physical name in the “name” column, which is the target column (here, “ename”) and the physical name in the “department number” column, which is the primary key in the second table (the table other than the first table) The names (here “deptno”) are not identical. Therefore, in the second foreign key candidate specifying process described above, the foreign key candidates in the first table are not specified.

  That is, when the “name” column constituting the first table is the target column as described above, the “employee number” column specified in the first foreign key candidate specifying process is the input value of the foreign key. Obtained as a candidate.

  It should be noted that the “job title” column, the “superior” column, the “employment date” column, and “salary” among the plurality of columns constituting the first table shown by the first table information 221 shown in FIG. Similarly, when the column and the “allowance” column are the target columns, the “employee number” column is acquired as a candidate for the input value of the foreign key.

  Next, it is assumed that the “department number” column among the plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is the target column.

  In this case, the item of the main key and the item of exclusive control in the “department number” column included in the first table definition information 221a included in the first table information 221 shown in FIG. 3 are null. Therefore, the “department number” column is not the primary key column and the exclusive control column in the first table.

  Here, in the first table including the “department number” column that is the target column, the “employee number” column is the primary key as described above. Therefore, in the first foreign key candidate specifying process described above, the “employee number” column is specified as a foreign key candidate in the first table.

  On the other hand, according to the first table definition information 221a shown in FIG. 3, the physical name of the “department number” column constituting the first table is “deptno”. Further, according to the second table definition information 222a shown in FIG. 4, the column that is the primary key in the table (here, the second table) other than the first table composed of the “department number” column is This is a “department number” column in which “◯” is set as the primary key item. Furthermore, according to the second table definition information 222a shown in FIG. 4, the physical name of the “department number” column constituting the second table is “deptno”.

  Here, the physical name of the “department number” column that is the target column and the physical name of the “department number” column that is the primary key in the second table are the same as “deptno”. Therefore, in the second foreign key candidate specifying process described above, the “department number” column, which is the primary key in the second table, is specified as a foreign key candidate in the first table.

  That is, as described above, when the “department number” column constituting the first table is the target column, the “employee number” column and the second external number specified in the first foreign key candidate specifying process The “department number” column (column that is the primary key in the second table) specified in the key candidate specifying process is acquired as a candidate for the input value of the foreign key.

  Next, it is assumed that the “version” column among the plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is the target column.

  In this case, “O” is set in the exclusive control item of the “version” column included in the first table definition information 221a included in the first table information 221 shown in FIG. For this reason, the “version” column is a column for exclusive control in the first table. Therefore, when the “version” column constituting the first table is the target column, the input value candidate of the foreign key is not acquired.

  As described above, the input value candidate of the foreign key acquired by the input value candidate acquiring unit 32 (that is, the column candidate to be set as the foreign key) is output to the input value determining unit 33.

  Here, FIG. 15 shows an example of the data structure of the input value candidate of the foreign key output to the input value determining unit 33.

  As shown in FIG. 15, the input value candidate (foreign key input value candidate) output to the input value determination unit 33 is input as a foreign key input value candidate by the input value candidate acquisition unit 32. The physical name of the acquired column (the column identified as a foreign key candidate in the first and second foreign key candidate identification processing) is included as the reference table primary key. In addition to the reference table primary key, candidates for input values of foreign keys include the target column name, table name, table ID, reference table name, and reference table ID.

  The target column name is the column name (physical name) of the target column when the input value candidate of the foreign key is acquired. The table name is a table name of a table configured from the target column. The table ID is an identifier for identifying a table composed of target columns.

  The reference table name is determined by the foreign key when a column that is a candidate for the input value of the foreign key (that is, a column acquired by the input value candidate acquisition unit 32 as a candidate for the input value of the foreign key) is used as the foreign key. This is the table name of the table that is referred to and for which the column is set as the primary key. The reference table ID is a table that is referred to by the foreign key when a column that is a candidate for the input value of the foreign key is used as the foreign key, and for identifying the table in which the column is set as the primary key. Table ID.

  The target column name, table name, table ID, reference destination table name, and reference destination table ID included in the input value candidates of the foreign key output to the input value determination unit 33 are the first input value candidates described above. It is acquired from the table information (first and second table information) acquired in the acquisition process.

  In the example shown in FIG. 15, the foreign key input value candidates 1 and 2 are included in the foreign key input value candidates.

  Note that the foreign key input candidates 1 and 2 shown in FIG. 15 are targeted for the “department number” column among the plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. An example of a foreign key input value candidate output in the first input value candidate acquisition process in the case of a column is shown.

  The external key input value candidate 1 includes a target column name “deptno”, a table name “employee table”, a table ID “emp”, a reference table name “employee table”, a reference table ID “emp”, and a reference destination Contains the table primary key "empno". According to this, the foreign key input value candidate 1 has a “department number” column (a column whose physical name is “deptno”) constituting the first table indicated by the first table information 221 shown in FIG. This indicates that the input value candidate of the foreign key in the case of the target column is the “employee number” column (its physical name). The “employee number” column, which is a candidate for the input value of the foreign key, is a column specified in the first foreign key candidate specifying process described above.

  The foreign key input value candidate 2 includes a target column name “deptno”, a table name “employee table”, a table ID “emp”, a reference table name “department table”, a reference table ID “dept”, and a reference. The destination table primary key “deptno” is included. According to this, the foreign key input value candidate 2 has a “department number” column (a column whose physical name is “deptno”) constituting the first table indicated by the first table information 221 shown in FIG. This indicates that the input value candidate of the foreign key in the case of the target column is the “department number” column (its physical name). The “department number” column, which is a candidate for the input value of the foreign key, is a column specified in the second foreign key candidate specifying process described above.

  Here, the input value of the foreign key output when the “department number” column among the plurality of columns constituting the first table indicated by the first table information 221 shown in FIG. 3 is the target column. Although the candidates have been described, the same applies to the foreign key input value candidates that are output when the other column is the target column.

  Note that the foreign key input value candidate shown in FIG. 15 includes only the physical name of the target column as the target column name, but may include the logical name of the target column in addition to the physical name. I do not care.

  When the input value candidate of the external key in the format shown in FIG. 15 is output to the input value determining unit 33, the input value determining unit 33 is a screen for selecting the input value candidate of the external key. (Hereinafter referred to as a first input value candidate selection screen) is displayed.

  Here, FIG. 16 shows an example of a first input value candidate selection screen (foreign key input value candidate selection screen). On the first input value candidate selection screen 400, for example, a table name and a table ID are displayed. The table name and table ID displayed on the first input value candidate selection screen 400 are the table names included in the input value candidates for the external key output to the input value determination unit 33 shown in FIG. And the table ID.

  Further, the first input value candidate selection screen 400 includes target column names (here, logical name and physical) included in the foreign key input value candidates output to the input value determination unit 33 shown in FIG. Name) is displayed.

  Further, in the first input value candidate selection screen 400, a pull-down 401 is provided in association with the target column name. In the pull-down 401 provided on the first input value candidate selection screen 400, for example, as shown in FIG. 17, a candidate for an input value of a foreign key (here, a set of a reference destination table ID and a reference destination table main key). ) Is set. Note that FIG. 17 shows the display of the pull-down 401 associated with the logical name “department number” and the physical name “deptno” (that is, the input value candidate of the foreign key when the target column is the “department number” column). ). That is, as shown in FIG. 17, the pull-down 401 associated with the logical name “department number” and the physical name “deptno” is included in each of the external key input value candidates 1 and 2 shown in FIG. The set of the reference table ID and the reference table primary key (that is, the candidate input value of the foreign key) is displayed.

  As a result, the user can actually select an input value from among the input value candidates for the external key (that is, the column candidates to be set as the external key) via the first input value candidate selection screen 400. Can be selected. As shown in FIG. 17, “(blank)” is set for the external key, and the user can also select “(blank)”.

  In addition, a setting button 402 is provided on the first input value candidate selection screen 400. When the user selects an input value candidate of a desired external key on the pull-down 401 provided on the first input value candidate selection screen 400 and designates (presses) the setting button 402, the input of the selected external key is performed. A value candidate is determined as an input value (a column to be set as an external key), and the input value is reflected in the input information file 22 by the input information reflecting unit 34.

  In this case, the input information reflecting unit 34 is a table included in the table information set in the input information file 22 (table information indicating a table identified by the table ID included in the input value candidate of the foreign key described above). In the definition information, “◯” is set in the item of the foreign key of the column determined as the input value (the column that is a candidate for the foreign key input value). Thereby, the column determined as the input value is set as the foreign key.

  Further, the input information reflection unit 34 uses the physical name of the column set as the foreign key (the physical name of the column included as the reference table primary key in the input value candidate of the foreign key) as the input value of the foreign key. It is set in the item of foreign key name included in the reference table definition information of the table information indicating the table identified by the table ID included in the candidate.

  Further, the input information reflecting unit 34 adds the foreign key reference item to the item of the foreign key reference destination table included in the reference table definition information including the item of the foreign key name in which the physical name of the column set as the foreign key is set. Set the table (foreign key reference table) referenced by. In this case, the input information reflecting unit 34 converts the table name of the foreign key reference destination table (the reference table name included in the candidate input value of the foreign key) into the item of the name included in the item of the foreign key reference destination table. Set. Further, the input information reflection unit 34 sets the table ID of the foreign key reference destination table (reference destination table ID included in the candidate input value of the foreign key) to the item of ID included in the item of the foreign key reference destination table. To do.

  Further, the input information reflecting unit 34 has the physical name of the column that is the primary key (the reference destination included in the input value candidate of the foreign key) in the table (foreign key reference destination table) set in the item of the foreign key reference destination table. Table primary key) is set to the item of the foreign key reference destination configuration column included in the reference table definition information including the item of the foreign key name in which the physical name of the column set as the foreign key is set.

  That is, when a foreign key input value candidate is acquired in the first input value candidate acquisition process and a foreign key is set from the input key candidates (that is, the column), the reference destination Appropriate input values are automatically set for the items of the foreign key name, foreign key reference destination table, and foreign key reference destination configuration column of the foreign key included in the table definition information.

  Next, the processing procedure of the second input value candidate acquisition process will be described with reference to the flowchart of FIG.

  The second input value candidate acquisition process is an input value candidate acquisition process when the second rule (foreign key reference destination table candidate acquisition rule) is used as described above. In this second input value candidate acquisition process, based on the second rule, it is set in the item of the foreign key reference destination table included in the reference destination table definition information of the table information set in the input information file 22. A power value candidate (a candidate for an input value in the foreign key reference table) is acquired.

  When the second input value candidate acquisition process is executed, if a foreign key is set in the table indicated by the table information set in the input information file 22, the reference destination table definition of the table information is set. It is assumed that a value is set in at least the foreign key name item included in the information.

  First, the input value candidate acquisition unit 32 acquires the first and second table information acquired by the input information acquisition unit 31 from the input information acquisition unit 31 (step S31).

  The input value candidate acquisition unit 32 acquires a second rule (foreign key reference destination table candidate acquisition rule) included in the rules held in the input value candidate acquisition rule holding unit 23 (step S32). The processes of steps S33 to S36 described below are executed based on the second rule. Since the contents of the second rule are as described in FIG. 11 described above, detailed description thereof is omitted here.

  Next, the input value candidate acquisition unit 32 stores the foreign key (the first and second table information of the first and second table information) in the table indicated by the table information (here, the first and second table information) acquired in step S31. The following processing from step S33 onward is executed for each of the foreign key names included in the reference table definition information. Hereinafter, the foreign key that is the target of this processing is the target foreign key. Here, it is assumed that the target foreign key is a foreign key in the first table.

  The input value candidate acquisition unit 32 refers to the reference destination table definition information (first reference destination table definition information) included in the first table information acquired in step S31, and refers to the external key reference destination of the target external key. It is determined whether or not the ID (item) included in the table item is null (step S33).

  When it is determined that the ID is null (YES in step S33), the input value candidate acquisition unit 32 uses the second table information indicated by the second table information based on the first and second table information. Is a corresponding table (step S34). The input value candidate acquisition unit 32 determines whether a table other than the table (here, the first table) configured from the columns set as the target foreign key is the corresponding table.

  Here, the corresponding table is composed of a column whose physical name is the foreign key name (the physical name set in the item) of the target foreign key included in the first reference table information of the first table information. Refers to the table to be played. In other words, the corresponding table is a table having the same column name (physical name) as the foreign key name of the target foreign key.

  When it is determined that the second table is the corresponding table (YES in step S34), the input value candidate acquisition unit 32 is the external key name of the target foreign key among the plurality of columns constituting the second table. It is determined whether or not a column whose physical name is (physical name set in the item) is a primary key in the second table (step S35). In this case, the input value candidate acquisition unit 32 executes a determination process with reference to the item of the primary key included in the table definition information (second table definition information) of the second table information indicating the second table. .

  When it is determined that the column whose physical name is the foreign key name of the target foreign key is the primary key in the second table (YES in step S35), the input value candidate acquisition unit 32 selects the second table ( (Table name and table ID) are acquired as input value candidates in the foreign key reference table of the target foreign key (step S36). The table name and table ID of the second table are acquired from the second table information (second table definition information included in the second table information).

  Next, the input value candidate acquisition unit 32 performs all the foreign keys (that is, the first and second table information) in the table indicated by the table information (first and second table information) acquired in step S31. In step S37, it is determined whether or not the processing from step S33 onward is executed for all the external keys set in step S37.

  If it is determined that the processing has not been executed for all the external keys (NO in step S37), the process returns to the above step S33 and the processing is repeated. In this case, the processing is executed with the foreign key that has not been subjected to the processing after step S33 as the target foreign key.

  On the other hand, when it is determined that the process has been executed for all the foreign keys (YES in step S37), the input value candidate acquisition unit 32 stores the input values of the foreign key reference destination table acquired in the process of step S36 described above. It is determined whether there is a candidate (step S38).

  When it is determined that there are input value candidates in the foreign key reference destination table (YES in step S38), the input value candidate acquisition unit 32 sets the input value candidates in the foreign key reference destination table to the input value determination unit 33. The data is output (step S39). The input value candidates of the foreign key reference destination table output to the input value determining unit 33 include table names and table IDs of tables that are candidates for values to be set in the items of the foreign key reference destination table. Is included.

  On the other hand, if it is determined that there is no input value candidate in the foreign key reference table (NO in step S38), the process in step S39 is not executed.

  As described above, the first input value candidate acquisition process shown in FIGS. 13 and 14 is executed before the second input value candidate acquisition process shown in FIG. In this first input value candidate acquisition process, when a foreign key input value candidate is acquired and a foreign key is set from among the input value candidates of the foreign key, the reference table definition is made as described above. Values are also set for items in the foreign key reference table included in the information (name and ID items included therein).

  Therefore, in such a case, it is determined in step S33 described above that the ID is not null, input value candidates in the foreign key reference table are not acquired, and the process of step S37 is executed.

  If it is determined in step S34 that the second table is not the corresponding table, and the column whose physical name is the foreign key name of the target foreign key is not the primary key in the second table (corresponding table) in step S35. Is determined, the process of step S37 is executed.

  As described above, in the second input value candidate acquisition process, if the column is a primary key in a table composed of columns having the physical name of the foreign key name of the target foreign key, the table name of the table The table ID is acquired as a candidate for the input value of the foreign key reference table.

  For example, “deptno” is set in the item of the foreign key name included in the first reference table definition information 221b of the first table information 221 shown in FIG. 3 by the process of step S23 shown in FIG. Assume a case. In this case, a column whose physical name is the foreign key name “deptno” is present in a plurality of columns constituting the second table indicated by the second table information 222 shown in FIG. In addition, a column (“department number” column) whose physical name is “deptno” among the plurality of columns is a primary key in the second table. Therefore, when the foreign key whose foreign key name is “deptno” is the target foreign key, the table name and table ID of the second table are acquired as input value candidates of the foreign key reference table.

  In this way, the input value candidates in the foreign key reference table acquired by the input value candidate acquisition unit 32 are output to the input value determination unit 33.

  Here, FIG. 19 shows an example of the data structure of input value candidates in the foreign key reference table output to the input value determining unit 33.

  As shown in FIG. 19, the input value candidate (foreign key reference destination table input value candidate) of the foreign key reference destination table that is output to the input value determining unit 33 is used in step S36 shown in FIG. The acquired table name and table ID (here, the table name and table ID of the second table) are included as the reference table name and reference table ID. In addition to the reference destination table name and the reference destination table ID, candidates for input values in the foreign key reference destination table include a table name, a table ID, an external key name, and a reference destination table primary key.

  The table name is a table name of a table (that is, a table in which the target foreign key is set) including columns set as target foreign keys (target foreign key columns). The table ID is an identifier for identifying a table composed of columns of the target foreign key. The foreign key name is the foreign key name of the target foreign key (the physical name of the column of the target foreign key). The reference destination table primary key is the physical name of the column that is the primary key in the table identified by the reference destination table ID included in the input value candidates of the foreign key reference destination table. That is, the reference table primary key is the physical name of the column that is the primary key in the table (foreign key reference table) referenced by the target foreign key.

  The table name, table ID, foreign key name, and reference table primary key included in the input value candidates of the foreign key reference table are the table information (first and second) acquired in the second input value candidate acquisition process described above. Obtained from the second table information).

  In the example shown in FIG. 19, the foreign key reference destination table input value candidate 1 is included in the input value candidates in the foreign key reference destination table.

  Note that the foreign key reference destination table input value candidate 1 shown in FIG. 19 includes, for example, “Foreign key name” included in the first reference destination table definition information 221b of the first table information 221 shown in FIG. This is an example of input value candidates in the foreign key reference table output in the second input value candidate acquisition process when “deptno” is set.

  The foreign key reference destination table input value candidate 1 includes table name “employee table”, table ID “emp”, foreign key name “deptno”, reference destination table name “department table”, reference destination table ID “dept”. And the referenced table primary key "deptno". According to this, the foreign key reference destination table input value candidate 1 is, for example, “deptno” in the foreign key name included in the first reference destination table definition information 221b of the first table information 221 shown in FIG. "Is the second table (table name" department table "and table ID" dept ") indicated by the second table information 222 shown in FIG. ).

  When the input value candidates of the foreign key reference table in the format shown in FIG. 19 are output to the input value determining unit 33, the input value determining unit 33 selects the input value candidates of the foreign key reference table. Is displayed (hereinafter referred to as a second input value candidate selection screen).

  Here, FIG. 20 shows an example of a second input value candidate selection screen (foreign key reference destination table input value candidate selection screen). On the second input value candidate selection screen 410, for example, a table name and a table ID are displayed. The table name and table ID displayed on the second input value candidate selection screen 410 are included in the input value candidates of the foreign key reference table output to the input value determination unit 33 shown in FIG. Table name and table ID.

  Further, in the second input value candidate selection screen 410, a pull-down 411 is provided in association with the external key name of the target external key. In the pull-down 411 provided in the second input value candidate selection screen 410, for example, as shown in FIG. 21, the input value candidates of the foreign key reference destination table (here, the reference destination table name and the reference destination table ID) are displayed. And a reference table primary key set).

  As a result, the user can select input value candidates in the foreign key reference table (that is, table name and table ID candidates to be set in the items of the foreign key reference table via the second input value candidate selection screen 410). ) Can be selected from among the candidates that should actually be input values.

  The second input value candidate selection screen 410 is provided with a setting button 412. When the user selects an input value candidate in a desired external key reference destination table in the pull-down 411 provided on the second input value candidate selection screen 410 and designates (presses) the setting button 412, the selected external key Input value candidates in the key reference table are determined as input values (table name and table ID to be set in the external key reference table items), and the input values are reflected in the input information file 22 by the input information reflection unit 34. Is done.

  In this case, the input information reflecting unit 34 stores the table information set in the input information file 22 (table information indicating a table identified by the table ID included in the input value candidates of the foreign key reference destination table described above). The table name and table ID determined as input values (candidates for input values in the foreign key reference table) are entered in the foreign key reference table items (name and ID fields included) included in the reference table definition information. The reference destination table name and reference destination table ID included) are set. Thereby, the input information reflection unit 34 sets a table referred to by the target external key in the item of the foreign key reference destination table included in the reference destination table definition information.

  Further, the input information reflecting unit 34 has a physical name of a column that is a primary key in a table set as an item of the foreign key reference destination table (a reference destination table primary key included in an input value candidate of the foreign key reference destination table). Is set to the item of the foreign key reference destination configuration column of the target foreign key included in the reference destination table definition information including the item of the foreign key reference destination table.

  That is, input value candidates in the foreign key reference table are acquired in the second input value candidate acquisition process, and values are set in the items in the foreign key reference table from among the input value candidates in the foreign key reference table. In such a case, an appropriate input value is automatically set for the item of the foreign key reference destination configuration column included in the reference destination table definition information including the item of the foreign key reference destination table.

  Next, the processing procedure of the third input value candidate acquisition process will be described with reference to the flowchart of FIG.

  The third input value candidate acquisition process is an input value candidate acquisition process when the third rule (foreign key reference destination constituent column candidate acquisition rule) is used as described above. In the third input value candidate acquisition process, based on the third rule, the item is set in the item of the foreign key reference destination configuration column included in the reference destination table definition information of the table information set in the input information file 22 A candidate for a value to be obtained (a candidate for an input value in a foreign key reference destination constituent column) is acquired.

  When the third input value candidate acquisition process is executed, if a foreign key is set in the table indicated by the table information set in the input information file 22, the reference destination table definition of the table information is set. It is assumed that values are set in at least the foreign key name and foreign key reference table items included in the information.

  First, the input value candidate acquisition unit 32 acquires the first and second table information acquired by the input information acquisition unit 31 from the input information acquisition unit 31 (step S41).

  The input value candidate acquisition unit 32 acquires a third rule (foreign key reference destination constituent column candidate acquisition rule) included in the rules held in the input value candidate acquisition rule holding unit 23 (step S42). The processes in steps S43 to S45 described below are executed based on the third rule. The contents of the third rule are as described with reference to FIG. 11 described above, and thus detailed description thereof is omitted here.

  Next, the input value candidate acquisition unit 32 stores the foreign key (the first and second table information of the first and second table information) in the table indicated by the table information (here, the first and second table information) acquired in step S41. For each of the foreign key names included in the reference table definition information), the following processing from step S43 is executed. Hereinafter, the foreign key that is the target of this processing is the target foreign key. Here, it is assumed that the target foreign key is a foreign key in the first table.

  The input value candidate acquisition unit 32 refers to the reference destination table definition information (first reference destination table definition information) included in the first table information acquired in step S41, and refers to the external key reference destination of the target external key. It is determined whether the configuration column (item) is null (step S43).

  When it is determined that the foreign key reference destination configuration column is null (YES in step S43), the input value candidate acquisition unit 32 stores the foreign key reference destination table of the target foreign key included in the first reference destination table definition information. The column that is the primary key in the table in which the table name and the table ID are set in the item (name and ID included in (in other words, the table set in the item of the foreign key reference table) is specified ( Step S44).

  The foreign key reference table in which the table name and the table ID are set in the item of the foreign key reference table of the target foreign key is a table identified by the table ID, and is referenced by the target foreign key. It is a table. Hereinafter, the foreign key reference destination table in which the table name and the table ID are set in the item of the foreign key reference destination table of the target foreign key is simply referred to as a target foreign key reference destination table. Here, it is assumed that the target foreign key reference table is the second table.

  In this case, the input value candidate acquisition unit 32 refers to the item of the primary key included in the second table definition information of the second table information indicating the second table which is the target foreign key reference table, step S44. Execute the process.

  The input value candidate acquisition unit 32 inputs the physical name of the identified column (here, the column that is the primary key in the second table) into the foreign key reference destination configuration column included in the first reference destination table definition information. Obtained as a value candidate (step 45). Note that the physical name of the column that is the primary key in the second table is acquired from the second table information.

  For example, when the first input value candidate acquisition process shown in FIG. 13 and FIG. 14 and the second input value candidate acquisition process shown in FIG. If it is set, it is determined in step S43 described above that the foreign key reference destination configuration column is not null, and the processing in steps S44 and S45 is not executed.

  Next, the input value candidate acquisition unit 32 selects all the foreign keys (that is, the first and second table information) in the table indicated by the table information (first and second table information) acquired in step S41. In step S46, it is determined whether or not the processing in step S43 and subsequent steps has been executed for all the external keys set in step S46.

  If it is determined that the processing has not been executed for all the external keys (NO in step S46), the processing returns to the above-described step S43 and is repeated. In this case, the processing is executed using the foreign key that has not been processed in step S43 and subsequent steps as the target foreign key.

  On the other hand, when it is determined that the processing has been executed for all the foreign keys (YES in step S46), the input value candidate acquisition unit 32 receives the input values of the foreign key reference destination constituent columns acquired in the processing in step S45 described above. It is determined whether or not there is a candidate (step S47).

  When it is determined that there is an input value candidate for the foreign key reference destination constituent column (YES in step S47), the input value candidate acquisition unit 32 sets the input value candidate for the foreign key reference destination constituent column as an input value determination unit. It outputs to 33 (step S48). The input value candidates of the foreign key reference destination configuration column output to the input value determination unit 33 include the physical names of columns that are candidates for values to be set in the items of the foreign key reference destination configuration column. included.

  On the other hand, when it is determined that there is no input value candidate in the foreign key reference destination configuration column (NO in step S47), the process in step S48 is not executed.

  As described above, in the third input value candidate acquisition process, the physical name of the column that is the primary key in the target foreign key reference destination table is acquired as the input value candidate of the foreign key reference destination constituent column.

  For example, if the target foreign key reference destination table is the second table indicated by the second table information 222 shown in FIG. 4, that is, the name item included in the item of the foreign key reference destination table of the target foreign key Assume that “dept” is set in the “department table” and the ID item. In this case, the physical name (in this case, “deptno”) as the primary key in the second table that is the target foreign key reference table is the input value candidate of the foreign key reference destination configuration example. Get as.

  In this way, the input value candidates of the foreign key reference destination configuration column acquired by the input value candidate acquisition unit 32 are output to the input value determination unit 33.

  Here, FIG. 23 shows an example of the data structure of the candidate input value of the foreign key reference destination constituent column output to the input value determining unit 33.

  As shown in FIG. 23, the input value candidate of the foreign key reference destination constituent column output to the input value determining unit 33 (foreign key reference destination constituent column input value candidate) includes the steps shown in FIG. The physical name of the column that is the primary key in the target foreign key reference destination table acquired in the process of S45 is included as the reference destination table primary key (foreign key reference destination constituent column). In addition to the reference destination table primary key, candidates for input values in the foreign key reference destination configuration column include a table name, a table ID, a foreign key name, a reference destination table name, and a reference destination table ID.

  The table name is a table name of a table composed of columns of the target foreign key. The table ID is an identifier for identifying a table composed of columns of the target foreign key. The foreign key name is the foreign key name of the target foreign key. The reference destination table name is the table name of the target foreign key reference destination table. The reference destination table ID is a table ID for identifying the target foreign key reference destination table.

  The table name, table ID, foreign key name, reference destination table name, and reference destination table ID included in the input value candidates of the foreign key reference destination constituent column are the tables acquired in the third input value candidate acquisition process described above. It is acquired from information (first and second table information).

  In the example shown in FIG. 23, the foreign key reference destination constituent column input value candidate 1 is included in the input value candidates of the foreign key reference destination constituent column.

  Note that the foreign key reference destination configuration column input value candidate 1 shown in FIG. 23 is an item of the foreign key reference destination table included in the first reference destination table definition information 221b of the first table information 221 shown in FIG. In addition, when the table name and the table ID included in the second table information 222 shown in FIG. 4 are set, the input value candidates of the foreign key reference destination constituent columns that are output in the third input value candidate acquisition process It is an example.

  The foreign key reference destination component column input value candidate 1 includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, a reference destination table name “department table”, and a reference destination table ID “dept”. ”And the referenced table primary key“ deptno ”. According to this, the foreign key reference destination configuration column input value candidate 1 is stored in the foreign key reference destination table included in the first reference destination table definition information 221b of the first table information 221 shown in FIG. When the second table (table name and table ID included in the second table information 222 shown in FIG. 4) is set in the item, the input value candidates of the foreign key reference destination constituent column are the second table. Indicates the physical name “deptno” in the “department number” column which is the primary key.

  When the input value candidates of the foreign key reference destination constituent column in the format shown in FIG. 23 are output to the input value determining unit 33, the input value determining unit 33 inputs the input value of the foreign key reference destination constituent column. A screen for selecting a candidate (hereinafter referred to as a third input value candidate selection screen) is displayed.

  FIG. 24 shows an example of a third input value candidate selection screen (foreign key reference destination configuration column input value candidate selection screen). On the third input value candidate selection screen 420, for example, a table name and a table ID are displayed. The table name and table ID displayed on the third input value candidate selection screen 420 are candidates for the input values of the external key reference destination configuration column output to the input value determination unit 33 shown in FIG. Table name and table ID included.

  In the third input value candidate selection screen 420, a pull-down 421 is provided in association with the external key name of the target external key. In the pull-down 421 provided in the third input value candidate selection screen 420, for example, as shown in FIG. 25, input value candidates in the external key reference destination configuration column (here, reference destination table name, reference destination table). ID and reference table primary key set) are set.

  As a result, the user can input the input value candidate of the foreign key reference destination constituent column (that is, the physical name of the column to be set in the item of the foreign key reference destination constituent column) via the third input value candidate selection screen 420. Candidates that should actually be input values can be selected from among the above.

  In addition, a setting button 422 is provided on the third input value candidate selection screen 420. When the user selects an input value candidate of a desired external key reference destination configuration column in the pull-down 421 provided on the third input value candidate selection screen 420 and designates (presses) the setting button 422, the selected item is selected. Candidates for input values in the foreign key reference destination constituent column are determined as input values (physical names of columns to be set in the foreign key reference destination constituent column), and the input information is reflected in the input information file 22 by the input information reflecting unit 34. Is done.

  In this case, the input information reflecting unit 34 sets the table information set in the input information file 22 (table information indicating the table identified by the table ID included in the input value candidates of the above-described foreign key reference destination configuration column). The physical name of the column determined as the input value in the item of the foreign key reference destination component column of the target foreign key included in the reference table definition information of the target (reference destination included in the candidate input value of the foreign key reference destination component column Table primary key).

  Next, the procedure of the fourth input value candidate acquisition process will be described with reference to the flowchart of FIG.

  The fourth input value candidate acquisition process is an input value candidate acquisition process when the fourth rule (display format candidate acquisition rule at the time of reference) is used as described above. In the fourth input value candidate acquisition process, based on the fourth rule, the display format item at the time of reference included in the reference table definition information of the table information set in the input information file 22 is set. A power value candidate (a candidate for an input value in a display format at the time of reference) is acquired. In addition, the item of the display format at the time of reference included in the reference destination table definition information includes the table (foreign key reference destination table) set in the item of the foreign key reference destination table included in the reference destination table definition information. The display format at the time of reference is set.

  When the fourth input value candidate acquisition process is executed, if a foreign key is set in the table indicated by the table information set in the input information file 22, the reference destination table definition of the table information is set. It is assumed that values are set in at least the items of the foreign key name, the foreign key reference destination table, and the foreign key reference destination configuration column included in the information.

  First, the input value candidate acquisition unit 32 acquires the first and second table information acquired by the input information acquisition unit 31 from the input information acquisition unit 31 (step S51).

  The input value candidate acquisition unit 32 acquires a fourth rule (display format candidate acquisition rule at the time of reference) included in the rules held in the input value candidate acquisition rule holding unit 23 (step S52). The processes in steps S53 to S56 described below are executed based on the fourth rule. The contents of the fourth rule are as described with reference to FIG. 11 described above, and thus detailed description thereof is omitted here.

  Next, the input value candidate acquisition unit 32 stores the foreign key (the first and second table information of the first and second table information) in the table indicated by the table information (here, the first and second table information) acquired in step S51. The following processing from step S53 onward is executed for each of the external key names included in the reference table definition information. Hereinafter, the foreign key that is the target of this processing is the target foreign key. Here, it is assumed that the target foreign key is a foreign key in the first table.

  The input value candidate acquisition unit 32 refers to the reference destination table definition information (first reference destination table definition information) included in the first table information acquired in step S51, and displays when the target external key is referred to. It is determined whether or not the format (item) is null (step S53).

  When it is determined that the display format at the time of reference is null (YES in step S53), the input value candidate acquisition unit 32 includes the foreign key reference destination configuration column of the target foreign key included in the first reference destination table definition information. Identify the column where the physical name is set in the item. Here, the column specified by the input value candidate acquisition unit 32 is a table (that is, the target external key) set in the item of the foreign key reference destination table of the target foreign key included in the first reference destination table definition information. This is a column that is a primary key in the reference table. Hereinafter, it is assumed that the target foreign key reference table is the second table.

  Next, the input value candidate acquisition unit 32 displays the column digit (item of the column included in the table definition information included in the table information (here, the second table information) indicating the table configured from the identified columns. It is determined whether or not the value set in (2) is 2 or more (step S54).

  When it is determined that the column digit is not 2 or more, that is, 1 (NO in step S54), the input value candidate acquisition unit 32 displays a check box, a radio button, a combo box, and a list box at the time of reference. As an input value candidate (step S55).

  On the other hand, when it is determined that the column digit is 2 or more (YES in step S54), the input value candidate acquisition unit 32 acquires the pop-up as the input value candidate of the display format at the time of reference (step S56).

  When the process of step S55 or S56 is executed, the input value candidate acquisition unit 32 executes all the foreign keys (that is, the first and second table information) in the table indicated by the table information (first and second table information) acquired in step S51. It is determined whether or not the processing after step S53 described above has been executed for all the foreign keys set in the first and second table information (step S57).

  If it is determined that processing has not been executed for all foreign keys (NO in step S57), the process returns to step S53 described above and the processing is repeated. In this case, the processing is executed using the foreign key that has not been processed in step S53 and subsequent steps as the target foreign key.

  On the other hand, when it is determined that the processing has been executed for all the foreign keys (YES in step S57), the input value candidate acquisition unit 32 displays the input values in the display format at the time of reference acquired in steps S55 and S56 described above. It is determined whether there is a candidate (step S58).

  When it is determined that there is an input value candidate in the display format at the time of reference (YES in step S58), the input value candidate acquisition unit 32 sends the input value candidate in the display format at the time of reference to the input value determination unit 33. The data is output (step S59).

  On the other hand, if it is determined that there is no input value candidate in the display format at the time of reference (NO in step S58), the process in step S59 is not executed.

  If it is determined in step S53 that the display format at the time of reference is not null, the processing in steps S54 to S56 is not executed, and the processing in step S57 is executed.

  As described above, in the fourth input value candidate acquisition process, the number of digits in the column of the foreign key reference destination constituent column of the target foreign key (the column in which the physical name is set in the item of the foreign key reference destination constituent column) Based on, the input value candidates in the display format at the time of reference are acquired.

  For example, the target foreign key reference destination table is the second table indicated by the second table information 222 shown in FIG. 4, and “deptno” is set in the item of the foreign key reference destination configuration column of the target foreign key. In this case, the number of digits in the column whose physical name is “deptno” (that is, the “department number” column) included in the second table definition information 222a of the second table information 222 is 2 or more. Pop-ups are acquired as input value candidates for the display format at the time of reference.

  In this way, the input value candidates in the display format at the time of reference acquired by the input value candidate acquisition unit 32 are output to the input value determination unit 33.

  Here, FIG. 27 shows an example of the data structure of the input value candidates in the display format at the time of reference output to the input value determining unit 33.

  As shown in FIG. 27, the input value candidate of the display format at the time of reference output to the input value determining unit 33 (display format input value candidate at the time of reference) is set to step S55 shown in FIG. The display format candidates (check boxes, radio buttons, combo boxes, list boxes, or pop-ups) at the time of reference acquired in S56 are included as display formats. In addition to the display format, the input value candidates in the display format at the time of reference output to the input value determination unit 33 include a table name, a table ID, and a foreign key name.

  The table name is a table name of a table composed of columns of the target foreign key. The table ID is an identifier for identifying a table composed of columns of the target foreign key. The foreign key name is the foreign key name of the target foreign key.

  The table name, table ID, and foreign key name included in the input value candidates in the display format at the time of reference are the table information (first and second table information) acquired in the fourth input value candidate acquisition process described above. Obtained from.

  In the example shown in FIG. 27, the input value candidates for the display format at the time of reference output to the input value determination unit 33 include display format input value candidates 1 to 4 at the time of reference.

  For example, the display format input value candidates 1 to 4 at the time of reference shown in FIG. 27 are set in the second table as items of the foreign key reference destination table included in the first reference destination table definition information 221b shown in FIG. The fourth input value when the physical name “deptno” of the “department number” column included in the second table definition information 222a shown in FIG. 4 is set in the item of the foreign key reference destination configuration column. It is an example of a display format input value candidate (here, popup, check box, radio button, combo box, and list box) that is output in the candidate acquisition process.

  In the example shown in FIG. 27, the display format input value candidate 1 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display format “pop-up”. . According to this, the display format input value candidate 1 at the time of reference is a value candidate to be set in the item of the display format at the time of referring to the target foreign key (here, the foreign key whose foreign key name is “deptno”). It indicates that (candidate input value of display format at the time of reference) is a popup.

  Further, the display format input value candidate 2 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display format “pop-up”. According to this, the display format input value candidate 1 at the time of reference is a value candidate to be set in the item of the display format at the time of referring to the target foreign key (here, the foreign key whose foreign key name is “deptno”). It indicates that (candidate input value of display format at the time of reference) is a popup.

  Further, the display format input value candidate 3 at the time of reference includes a table name “employee table”, a table ID “emp”, an external key name “deptno”, and a display format “pop-up”. According to this, the display format input value candidate 1 at the time of reference is a value candidate to be set in the item of the display format at the time of referring to the target foreign key (here, the foreign key whose foreign key name is “deptno”). It indicates that (candidate input value of display format at the time of reference) is a popup.

  The display format input value candidate 4 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display format “pop-up”. According to this, the display format input value candidate 1 at the time of reference is a value candidate to be set in the item of the display format at the time of referring to the target foreign key (here, the foreign key whose foreign key name is “deptno”). It indicates that (candidate input value of display format at the time of reference) is a popup.

  In these examples, because the foreign key name is “deptno”, the display format candidate at the time of reference is “pop-up”, but if the foreign key name is something else, as the display format candidate at the time of reference, Check boxes, radio buttons, combo boxes and list boxes other than popups will also be shown.

  When the input value candidate of the display format at the time of reference in the format shown in FIG. 27 is output to the input value determining unit 33, the input value determining unit 33 selects the input value candidate of the display format at the time of reference. Is displayed (hereinafter referred to as a fourth input value selection screen).

  Here, FIG. 28 shows an example of a fourth input value candidate selection screen (display format input value candidate selection screen for reference). For example, a table name and a table ID are displayed on the fourth input value candidate selection screen 430. The table name and table ID displayed on the fourth input value candidate selection screen 430 are included in the input value candidates in the display format at the time of reference output to the input value determination unit 33 shown in FIG. Table name and table ID.

  In the fourth input value candidate selection screen 430, a pull-down 431 is provided in association with the external key name of the target external key. In the pull-down 431 provided on the fourth input value candidate selection screen 430, for example, input value candidates (here, pop-up) in the display format at the time of reference are set as shown in FIG.

  Thereby, the user can select from the input value candidates in the display format at the time of reference (that is, candidates of values to be set in the items of the display format at the time of reference) via the fourth input value candidate selection screen 430. Candidates that should actually be input values can be selected.

  In addition, a setting button 432 is provided on the fourth input value candidate selection screen 430. When the user selects an input value candidate in a display format at the time of reference in the pull-down 431 provided on the fourth input value candidate selection screen 430 and designates (presses) the setting button 432, the selected reference is selected. The input value candidate in the display format at that time is determined as the input value, and the input value is reflected in the input information file 22 by the input information reflecting unit 34.

  In this case, the input information reflecting unit 34 stores the table information set in the input information file 22 (table information indicating the table identified by the table ID included in the input value candidates of the display format at the time of reference described above). The display format (here, pop-up) determined as the input value is set in the item of the display format when referring to the target foreign key included in the reference table definition information.

  Next, the procedure of the fifth input value candidate acquisition process will be described with reference to the flowchart of FIG.

  The fifth input value candidate acquisition process is an input value candidate acquisition process when the fifth rule (display item candidate acquisition rule at the time of reference) is used as described above. In this fifth input value candidate acquisition process, based on the fifth rule, it is set in the item of the display item at the time of reference included in the reference table definition information of the table information set in the input information file 22. A power value candidate (a candidate for an input value of a display item at the time of reference) is acquired. The item of the display item at the time of reference included in the reference destination table definition information includes the table (foreign key reference destination table) set in the item of the foreign key reference destination table included in the reference destination table definition information. An item (display item) displayed at the time of reference is set.

  When the fifth input value candidate acquisition process is executed, if a foreign key is set in the table indicated by the table information set in the input information file 22, the reference table table of the table information It is assumed that values are set in the external key name, foreign key reference table, foreign key reference destination configuration column, and display format items at the time of reference included in the definition information.

  First, the input value candidate acquisition unit 32 acquires the first and second table information acquired by the input information acquisition unit 31 from the input information acquisition unit 31 (step S61).

  The input value candidate acquisition unit 32 acquires the fifth rule (display item candidate acquisition rule at the time of reference) included in the rules held in the input value candidate acquisition rule holding unit 23 (step S62). The processes in steps S63 to S67 described below are executed based on the fifth rule. The contents of the fifth rule are as described in FIG. 11 described above, and therefore detailed description thereof is omitted here.

  Next, the input value candidate acquisition unit 32 acquires the foreign key (the first and second table information of the first and second table information) in the table indicated by the table information (here, the first and second table information) acquired in step S61. For each of the foreign key names included in the reference table definition information), the following processing from step S63 is executed. Hereinafter, the foreign key that is the target of this processing is the target foreign key. Here, it is assumed that the target foreign key is a foreign key in the first table.

  The input value candidate acquisition unit 32 refers to the reference destination table definition information (first reference destination table definition information) included in the first table information acquired in step S61, and displays when the target external key is referred to. It is determined whether a pop-up is set for the format item (step S63).

  When it is determined that a pop-up is set in the display format item at the time of reference (step S63), the input value candidate acquisition unit 32 refers to the first reference destination table definition information and refers to the target foreign key. It is determined whether or not the current display item is null (step S64).

  When it is determined that the display item at the time of reference is null (YES in step S64), the input value candidate acquisition unit 32 stores the foreign key reference destination table of the target foreign key included in the first reference destination table definition information. Based on the table information indicating the table (target foreign key reference table) set in the item, a column that is not a column for exclusive control is specified from among the columns constituting the target foreign key reference table (step S65). ). Hereinafter, it is assumed that the target foreign key reference table is the second table. In this case, the input value candidate acquisition unit 32 stores the exclusive control items of the columns constituting the second table included in the second table information indicating the second table that is the target foreign key reference destination table. By determining whether or not it is null, a column that is not a column for exclusive control is specified.

  The input value candidate acquisition unit 32 acquires the physical name of the identified column as the input value candidate of the display item at the time of reference (step S66). The physical name of the column specified by the input value candidate acquisition unit 32 is acquired from the table definition information (second table definition information) included in the second table information indicating the second table.

  The input value candidate acquisition unit 32 is set in all the foreign keys (that is, the first and second table information) in the table indicated by the table information (first and second table information) acquired in step S61. It is determined whether or not the processing after step S63 described above has been executed for all the external keys) (step S67).

  If it is determined that the processing has not been executed for all the external keys (NO in step S67), the processing returns to the above-described step S63 and is repeated. In this case, the processing is executed using the foreign key that has not been processed in step S63 and subsequent steps as the target foreign key.

  On the other hand, if it is determined that the processing has been performed for all the foreign keys (YES in step S67), the input value candidate acquisition unit 32 displays the input value candidates for the display items at the time of reference acquired in step S66 described above. It is determined whether or not there is (step S68).

  When it is determined that there is an input value candidate for the display item at the time of reference (YES in step S68), the input value candidate acquisition unit 32 sets the input value candidate of the display item at the time of reference to the input value determination unit 33. In response, the data is output (step S69).

  On the other hand, when it is determined that there is no input value candidate for the display item at the time of reference (NO in step S68), the process in step S69 is not executed.

  If it is determined in step S63 that the pop-up item is not set for the display format item at the time of reference, or if it is determined in step S64 that the display item at the time of reference is not null, the process of step S67 is executed. Is done.

  As described above, in the fifth input value candidate acquisition process, the physical name of a column that is not a column for exclusive control among a plurality of columns constituting a table (target foreign key reference destination table) referenced by the target foreign key Is acquired as a candidate for the input value of the display item at the time of reference.

  For example, when the target foreign key reference table is the second table indicated by the second table information 222 shown in FIG. 4, the second table of the plurality of columns constituting the second table. The physical names “deptno”, “dname”, and “loc” of columns for which “◯” is not set in the exclusive control item included in the definition information 222a are acquired as input value candidates for the display item at the time of reference.

  Thus, the input value candidate of the display item at the time of reference acquired by the input value candidate acquisition unit 32 is output to the input value determination unit 33.

  Here, FIG. 31 shows an example of the data structure of the input value candidate of the display item at the time of reference output to the input value determining unit 33.

  As shown in FIG. 31, the input value candidate of the display item at the time of reference output to the input value determining unit 33 (display item input value candidate at the time of reference) is displayed in step S66 shown in FIG. Display item candidates at the time of reference acquired (physical names of columns that are not exclusive control columns among a plurality of columns constituting the target foreign key reference destination table) are included as display items. In addition to the display items, candidates for input values of display items at the time of reference output to the input value determining unit 33 include a table name, a table ID, and a foreign key name.

  The table name is a table name of a table composed of columns of the target foreign key. The table ID is an identifier for identifying a table composed of columns of the target foreign key. The foreign key name is the foreign key name of the target foreign key.

  The table name, table ID, and foreign key name included in the input value candidates in the display format at the time of reference are the table information (first and second table information) acquired in the fifth input value candidate acquisition process described above. Obtained from.

  In the example illustrated in FIG. 31, the display item input value candidates at the time of reference output to the input value determination unit 33 include display item input value candidates 1 to 3 at the time of reference.

  Note that the display item input value candidates 1 to 3 at the time of reference shown in FIG. 31 are set in the second table as items of the foreign key reference destination table included in the first reference destination table definition information 221b shown in FIG. It is an example of the input value candidate of the display format at the time of the reference output in the 5th input value candidate acquisition process in the case of being performed.

  In the example shown in FIG. 31, the display item input value candidate 1 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display item “deptno”. . According to this, the display item input value candidate 1 at the time of reference is a value candidate (reference) to be set to the display item at the time of reference of the target foreign key (here, the foreign key whose foreign key name is “deptno”). The candidate for the display item at the time is “deptno”.

  Further, the display item input value candidate 2 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display item “dname”. According to this, the display item input value candidate 2 at the time of reference is a value candidate (reference) to be set to the display item at the time of reference of the target foreign key (here, the foreign key whose foreign key name is “deptno”). The candidate for the display item at the time is “dname”.

  The display item input value candidate 3 at the time of reference includes a table name “employee table”, a table ID “emp”, a foreign key name “deptno”, and a display item “loc”. According to this, the display item input value candidate 3 at the time of reference is a value candidate (reference) that is set to the display item at the time of reference of the target foreign key (here, the foreign key whose foreign key name is “deptno”). This indicates that the display item candidate) is “loc”.

  When the input value candidate of the display item at the time of reference in the format shown in FIG. 31 is output to the input value determining unit 33, the input value determining unit 33 selects the input value candidate of the display format at the reference time. Is displayed (hereinafter referred to as a fifth input value selection screen).

  Here, FIG. 32 shows an example of a fifth input value candidate selection screen (display item input value candidate selection screen at the time of reference).

  In the fifth input value candidate selection screen 440, a pull-down 441 is provided in association with the external key name of the target external key. The pull-down 441 is provided for each of the search conditions and the list display. In the pull-down 441 provided on the fifth input value candidate selection screen 440, for example, as shown in FIG. 33, input value candidates of display items at the time of reference (here, “deptno”, “dname”, and “ loc ") is set. As shown in FIG. 33, a blank is set in the pull-down 441 provided in the fifth input value candidate selection screen 440, and “none” is also set only in the search condition ( "None" is not set in the list display).

  As a result, the user can select from the input value candidates for the display item at the time of reference (that is, the value candidates to be set in the item of the display item at the time of reference) via the fifth input value candidate selection screen 440. Candidates that should actually be input values can be selected.

  A setting button 442 is provided on the fifth input value candidate selection screen 440. When a user selects an input value candidate of a display item at a desired reference time from a pull-down 441 provided on the fifth input value candidate selection screen 440 and designates (presses) a setting button 442, the selected reference is selected. The input value candidate of the display item at that time is determined as the input value, and the input value is reflected in the input information file 22 by the input information reflecting unit 34.

  In this case, the input information reflecting unit 34 stores the table information set in the input information file 22 (table information indicating a table identified by the table ID included in the input value candidate of the display item at the reference time described above). The display item (in this case, ((blank)) ”, which is determined as the input value for the item of the display item at the time of referencing the target foreign key included in the reference table information (the search condition and list display item included) "None", "deptno", "dname" or "loc").

  A plurality of values can be set for the display item at the time of reference. For this reason, a pull-down addition button 443 and a pull-down deletion button 444 are provided on the fifth input value candidate selection screen 440. When the pull-down addition button 443 is designated (pressed) by the user, one pull-down 441 is added. Thereby, it is possible to select a plurality of values to be set in a plurality of reference display items. On the other hand, when the pull-down delete button 444 is designated (pressed) by the user, one pull-down 441 is deleted.

  As described above, in the present embodiment, a plurality of table information set in the input information file 22 is acquired, and the plurality of table information and rules stored in the input value candidate acquisition rule storage unit 23 (for example, Based on the first rule, candidates for values (input values) to be set in the input information file 22 are acquired.

  Specifically, in the present embodiment, a table (first table) indicated by first table information among a plurality of table information (for example, first and second table information) set in the input information file 22. If the target column that is one of a plurality of columns that constitute one table) is not the primary key in the first table, the column that is the primary key in the first table is the external in the first table. Obtained as a key candidate.

  In the present embodiment, for example, if the target column that is one of the plurality of columns constituting the first table indicated by the first table information is not the primary key in the first table, the first table Among the plurality of columns constituting a table different from the one table (for example, the second table), the column that is the primary key in the second table is included in the second table information indicating the second table. If the column name of the target column and the column name of the specified column are the same as those specified based on the primary key information (value set in the primary key item), the second table The column that is the primary key is acquired as a foreign key candidate in the first table.

  In the present embodiment, the foreign key candidates (foreign key input value candidates) acquired as described above are presented to the user.

  Accordingly, in the present embodiment, the user can select a foreign key (a column to be actually set as a foreign key in the input information file 22) from the presented foreign key candidates. It is possible to support the setting of information necessary for automatic generation. In the present embodiment, a foreign key (indicating foreign key information) determined according to a user operation can be automatically set (reflected) in the input information file 22.

  In the present embodiment, when the foreign key is set in the input information file 22 as described above, the items of the foreign key name, the foreign key reference destination table, and the foreign key reference destination configuration column are also automatically appropriate. A value can be set in the input information file 22.

  Further, in the present embodiment, the input information file 22 (an item of the foreign key reference destination table) as the foreign key reference destination table based on the number of columns of the column set in the input information file 22 as the foreign key reference destination constituent column. The table display format candidates set in the table are acquired, and the acquired display format candidates are presented to the user. Thereby, in this embodiment, the presented display format candidate is determined as the display format of the foreign key reference table (display format to be set in the input information file 22) according to the user's operation, The determined display format can be set in the input information file 22.

  In this embodiment, a column that is not a column for exclusive control among a plurality of columns constituting a table set in the input information file 22 (an item of the foreign key reference destination table) as the foreign key reference destination table is included. It is acquired as a display item candidate of the table, and the acquired display item candidate is presented to the user. Thereby, in this embodiment, according to a user's operation, the displayed display item candidate is determined as a display item (display item to be set in the input information file 22) of the foreign key reference table, and The determined display item can be set in the input information file 22.

  Note that the present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage. Moreover, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, constituent elements over different embodiments may be appropriately combined.

  DESCRIPTION OF SYMBOLS 10 ... Computer, 20 ... External storage device, 22 ... Input information file, 23 ... Input value candidate acquisition rule holding | maintenance part, 30 ... Setting information input assistance apparatus, 31 ... Input information acquisition part, 32 ... Input value candidate acquisition part, 33 ... input value determination unit, 34 ... input information reflection unit.

Claims (6)

In a setting information input support device that supports setting of information necessary to automatically generate an application,
First key information indicating a first table composed of a plurality of columns used in the application, and indicating whether each of the columns is a primary key and each column of the columns First table information including a name and second table information indicating a second table composed of a plurality of columns used in the application, each column indicating whether or not each of the columns is a primary key An input information file in which a plurality of table information including primary key information and second table information including each column name of the column is set;
Table information acquisition means for acquiring a plurality of table information set in the input information file;
A plurality of columns constituting the first table indicated by the first table information based on the primary key information included in the first table information of the plurality of table information acquired by the table information acquisition means First determination means for determining whether the target column that is one of the primary keys is a primary key;
If the first determination unit determines that the target column is not the primary key, the column that is the primary key in the first table among the plurality of columns constituting the first table configured from the target column A first specifying means for specifying based on primary key information included in the first table information;
First foreign key candidate obtaining means for obtaining a column identified by the first identifying means as a foreign key candidate in the first table;
If the first determination unit determines that the target column is not a primary key, the second table among the plurality of columns constituting the second table other than the first table including the target column A second specifying means for specifying a column that is a primary key based on primary key information included in second table information of the plurality of table information acquired by the table information acquiring means;
A second determination unit that determines whether the column name of the target column included in the first table information and the column name of the column specified by the second specifying unit included in the second table information are the same; A determination means;
When the second determining unit determines that the column name of the target column and the column name of the column specified by the second specifying unit are the same, the column specified by the second specifying unit is Second foreign key candidate acquisition means for acquiring as a foreign key candidate in the first table;
A setting information input support device comprising: a presenting unit that presents a column acquired as a foreign key candidate by the first and second foreign key candidate acquiring unit. Determining means for determining the presented column as a foreign key in the first table in response to a user operation;
The setting information input support apparatus according to claim 1, further comprising setting means for setting the determined column in the input information file as an external key. The setting means includes
When the column acquired by the first foreign key candidate acquisition unit among the presented columns is determined as the foreign key, the first of the plurality of table information acquired by the table information acquisition unit The column name of the column included in the table information is set in the input information file as a foreign key name, and the first table indicated by the first table information is set as a foreign key reference table referenced by the foreign key. A column that is a primary key in the first table among a plurality of columns that constitute the first table set in the input information file and set in the input information file as the foreign key reference destination table is referred to the foreign key Set in the input information file as a destination configuration column,
When the column acquired by the second foreign key candidate acquisition unit among the presented columns is determined as the foreign key, the second of the plurality of table information acquired by the table information acquisition unit The column name of the column included in the table information is set in the input information file as a foreign key name, and the second table indicated by the second table information is set as a foreign key reference table referenced by the foreign key. The external key reference is made to the column that is the primary key in the second table among the plurality of columns that constitute the second table set in the input information file as the foreign key reference table set in the input information file. The setting information according to claim 2, wherein the setting information is set in the input information file as a destination configuration column. Information input support device. Further comprising a display format candidate acquisition means,
The first table information set in the input information file further includes the number of digits of each of the columns constituting the first table indicated by the first table information,
The second table definition information set in the input information file further includes the number of digits of each of the columns constituting the second table indicated by the second table information,
The display format candidate obtaining unit is configured to set the setting unit based on the number of columns of the column set in the input information file as a foreign key reference destination constituent column by the setting unit included in the first or second table information. To obtain a display format candidate of the first or second table set in the input information file as the foreign key reference destination table,
The presenting means further presents a display format candidate acquired by the display format candidate acquiring means,
The determining means determines the display format candidate as the display format of the first or second table set in the input information file as the foreign key reference table according to the operation of the user,
The setting information input support apparatus according to claim 3, wherein the setting unit sets the determined display format in the input information file. It further comprises display item candidate acquisition means,
The first table information set in the input information file includes exclusive control indicating whether each of the columns constituting the first table indicated by the first table information is a column for exclusive control. Further including information,
The second table information set in the input information file includes exclusive control indicating whether or not each of the columns constituting the second table indicated by the second table information is a column for exclusive control. Further including information,
The display item candidate acquisition unit is configured to set the first or second set of the input information file as an external key reference destination table by the setting unit based on exclusive control information included in the first or second table information. A column that is not a column for exclusive control among a plurality of columns constituting the table is acquired as a display item candidate of the first or second table,
The presenting means further presents display item candidates acquired by the display item candidate acquiring means,
The determining means determines the display item candidates as display items of the first or second table set in the input information file as the foreign key reference table according to the operation of the user,
The setting information input support apparatus according to claim 4, wherein the setting unit sets the determined display item in the input information file. 1st table information which shows the 1st table comprised from the some column used in an application, Comprising: The primary key information which shows whether each of the said column is a primary key, and each column name of the said column And second table information indicating a second table composed of a plurality of columns used in the application, and a main key indicating whether each of the columns is a primary key. An external storage device having an input information file in which a plurality of table information including key information and second table information including each column name of the column is set, and a computer using the external storage device In the setting information input support device to be executed, a program executed by the computer,
In the computer,
Obtaining a plurality of table information set in the input information file;
One of the plurality of columns constituting the first table indicated by the first table information based on the primary key information included in the first table information among the plurality of acquired table information. Determining whether the target column is a primary key;
When it is determined that the target column is not a primary key, a column that is a primary key in the first table among a plurality of columns constituting the first table configured from the target column is determined as the first table. Identifying based on first primary key information included in the information;
Obtaining the identified column as a foreign key candidate in the first table;
If it is determined that the target column is not the primary key, the column that is the primary key in the second table among the plurality of columns constituting the second table other than the first table configured from the target column is determined. Identifying based on primary key information included in second table information of the plurality of acquired table information;
Determining whether the column name of the target column included in the first table information is the same as the column name of the column that is the primary key in the specified second table included in the second table information When,
When it is determined that the column name of the target column and the column name of the column that is the primary key in the specified second table are the same, the column that is the primary key in the specified second table is Obtaining as a foreign key candidate in the first table;
Presenting a column acquired as a candidate for the foreign key.

Images