KR100519453B1 - Apparatus and method for controlling work of database used in object-oriented application - Google Patents

Abstract

The present invention relates to an apparatus and method for controlling a database operation. The present invention relates to a first step of generating work request data based on the work command when a work command for a database work is generated from an application program. When the work request data is generated, the second step of inserting all the information of the work request data into the query data to enable access to the database to work, and in the second step if all the information of the work request data is inserted into the query data In the third step of identifying a work type to be worked through the database based on the query data, and if the work type is identified in the third step, a query statement generated after generating a query statement corresponding to the identified work type The fourth process of processing the database using the database, and the process of using the database in the fourth process is completed. Characterized in that the result made of a fifth process of providing the application. According to the present invention, when a database work command (eg, data deletion, modification, insertion, retrieval, etc.) from an application program is generated, a query statement according to the work command is provided to support the operation of the database through the corresponding query statement. This has the effect of allowing all applications to work with the database regardless of changes in the database framework.

Description

Apparatus and method for controlling work of database used in object-oriented application}

The present invention relates to an apparatus and method for controlling a database job, and more particularly, to performing a job using a database in an object-oriented application program so as to be able to access a database and process a desired job without generating a direct query statement in the application program. It relates to a database job control apparatus and method.

In general, when an application program wants to access a database and perform a desired operation (for example, deleting data, inserting data, modifying data, or retrieving data), the application program directly writes a query statement and then uses the created query statement. We had to carry out a series of processes.

As such, the way of working with a database by writing query statements directly in the application program must modify the application program having the query statement when the database framework changes.

As a result, it is necessary to modify the application program with the query statement every time the database framework is changed, which leads to a large amount of maintenance and maintenance of the application, and the inherent characteristics of the application may be degraded due to frequent application changes. This may cause stability problems of the whole system.

The present invention has been made to solve such a problem, and provides a database job control apparatus and method for performing a task using a database by providing a separate query statement when performing the task using a database in an object-oriented application program. Its purpose is to.

The database job control apparatus according to the present invention for achieving the above object generates a job request data based on the job command when the job command for the database job from the application program, the query data returned by passing to the query data provider Work request unit for transmitting to the work processing unit; When the work request data is transmitted from the work request unit, the query data providing unit for inserting all the information of the access request data into the query data to enable access to the database to work and delivers the query data to the work request unit; A job processing unit which receives the query data from the job requesting unit, recognizes a job type to be worked through the database, and generates a query statement according to the job type and processes the database through the generated query statement; And a result providing unit for providing a result according to the work completion of the work processing unit to the application program.

In addition, the database job control method according to the present invention for achieving the above object is a first step of generating a job request data based on the job command when a job command for a database job occurs from the application program, and the first step In the second step of inserting all the information of the work request data into the query data to enable access to the database to work when the work request data is generated in step 2, and inserting all the information of the work request data into the query data in the second step If the work type is identified in the third step and the work type is identified in the third step, the generated query statement is generated after generating a query statement corresponding to the identified work type. The fourth process of processing a database using a statement, and the fourth process of processing a database using a statement is completed. If, makin comprises a fifth process of providing the result to the application, there is the feature.

Hereinafter, on the basis of the accompanying drawings, a preferred embodiment of a database job control apparatus and method according to the present invention will be described in detail.

1 is a schematic block diagram of a database job control apparatus according to an embodiment of the present invention. Referring to FIG. 1, the database job control apparatus according to the present invention includes a job request unit 100, a query data provider 110, a job processor 120, a result provider 130, and a database 140. It is composed.

When the work request unit 100 generates a work command for the work of the database 140 from the application program, the work request data is generated and transmitted to the query data providing unit 110 based on the work command.

At this time, the work request data includes a database name which is name information of a database to be worked on, and a table name (ie, work table) which is name information on a table to be worked among (hereinafter, referred to as a work table) among tables included in the database. Name), a basic item group consisting of basic item names that are name information for basic items that make up the work table, and basic item values that are values for each basic item name, and the work table to be worked on The type of work is included.

Here, the job type is a delete job type for deleting a base item value for a predetermined base item name based on the work table, and an insert for inserting a new item name and an item value for the item name into the work table. (insert) an operation type, an update operation type for modifying a base item value for a given base item name to a new item value based on the job table, and retrieving a base item value for a given base item name from the job table. For example, a search task type.

On the other hand, when the job type is an insert job type, the job request data includes an item name (hereinafter referred to as the job target item name) to be newly inserted into the job table and an item value for the item name (hereinafter referred to as the job target item value). The work item group is further included.

In addition, when the work type is a modified work type, the work request data includes a basic item name (hereinafter referred to as a work target item name) for the basic item value to be modified among the basic item values constituting the work table and the previous default for the basic item name. The work item group further includes a new item value (hereinafter, referred to as a work item item value) to replace the item value.

The query data provider 110 manages a query data group including a plurality of query data for enabling access to the database 140 to be worked on.

FIG. 2 is a diagram showing an example of the configuration of query data. Referring to FIG. 2, the query data includes a flag field 201 for recording whether the current query data can be supported for work, and a package name field for recording a database name. 202, a table name field 203 for recording the work table name, a work type field 204 for recording the work type to be worked on the work table, and basic items constituting the work table. Work item group field 205 for recording the item name for the item to be worked on and the item value for the item name, the basic item name for the basic items constituting the work table, and the basic item value for each basic item name. A basic item group field 206 for recording.

FIG. 3A is an exemplary view showing the structure of the basic item group field 206. Referring to FIG. 3A, the basic item group field 206 includes basic item names and a plurality of basic item names for a plurality of basic items forming a work table. The default item values are recorded alternately. For example, a base item name is recorded at an even index (ie, index 0, index 2, .., index n), and an even number at an odd index (ie, index 1, index 3, .., index n + 1). Basic item values are recorded for each basic item name recorded in the index.

3B is an exemplary view showing a structure of a work target item group field 205 according to an insertion task type. Referring to FIG. 3B, work target item group field 205 includes items to be newly inserted into a work table. The item name (ie work item name) and the item value (ie work item value) for each work item name are recorded alternately.

3C is an exemplary view showing a structure of a work target item group field 205 according to a corrected work type. Referring to FIG. 3C, a work target item group field 205 is intended to be modified among basic item values forming a work table. The basic item name (ie, work item name) for the basic item value and the new item value (that is, work item value) to replace the basic item value are alternately recorded.

For example, when the third basic item value and the fourth basic item value are modified, the third basic item name of the third basic item value to be modified is set as the first work item item name in the index 0, and the third basic item value is recorded in the index 1 and the third basic item value. A new item value to replace the base item value is set and recorded as the first work item value. Similarly, the work target item name and work target item value for the fourth basic item value are also recorded in the index 2 and the index 3, respectively.

On the other hand, for the deletion job type and the retrieval job type, the job target item group fields 205 do not record the job target item names and the job target item values for each job target item name.

The query data providing unit 110 manages the query data group. When the work request data is transmitted from the work request unit 100, the query data providing unit 110 determines whether work support is possible for each of the plurality of query data included in the query data group. That is, based on the information recorded in the flag field 201 of each query data, it is determined whether the corresponding query data currently supports a job according to the database 140 work command from another application program.

And, if it is determined that the predetermined query data can be supported by the job, the query data provider 110 inserts all the information included in the job request data into each field of the corresponding query data, thereby inserting all the information of the job request data. Derived query data (hereinafter referred to as work assistant-query data) is derived.

On the other hand, the query data providing unit 110 determines whether all the query data included in the query data group can support the work, if it is determined that all the query data is not available for work, generates new query data and stores it in the query data group The work assistant-query data is derived by inserting all the information contained in the work request data into each field of the new query data.

Thereafter, the query data providing unit 110 adds the derived work assistant-query data to the work request data and transmits it to the work request unit 100.

In this case, the work request unit 100 receives the work request data added with the work assistant-query data from the query data providing unit 110 and transmits the work request data to the work processing unit 120.

The work processor 120 receives work request data to which work assistant-query data is added from the work request unit 100, and analyzes work assistant-query data added to the work request data based on the database 140. Identifies the type of work to be made, generates a query statement according to the identified work type, and processes the work of the database 140 using the query statement.

Here, the query processing generated by the job processor 120 according to the job type will be described in more detail as follows.

First, when the work type is a delete operation type for deleting a basic item value for a predetermined basic item among the existing basic items forming a table (that is, a work table) among the tables included in the database 140, The job processing unit 120 generates a delete-query statement based on the work table name included in the work assistant-query data and the basic item group.

For example, the job processor 120 generates a delete-query statement consisting of [delete from work table name where first basic item name = 'first basic item value' and second basic item name = 'second basic item value']. . At this time, the delete-query statement indicates the deletion of the first basic item value corresponding to the first basic item name located in the work table and the second basic item value corresponding to the second basic item name.

Thereafter, the job processing unit 120 uses the delete-query statement to determine the first basic item name and the second basic item which are item values for each of the first basic item name and the second basic item name from the work table located in the database 140. Delete the value.

On the other hand, if the job type is an insert job type for inserting a new item name (ie, a work target item name) and an item value (that is, work target item value) for the existing work table, the work processor 120 An insert-query statement is created based on the work table name, basic item group, and work target item group included in the sub-query data.

For example, the job processing unit 120 inserts [insert into a work table name (first basic item name, second basic item name, first working object item name) value ('first basic item value', 'second basic item value', ' First-entry item value ')] to generate an insert-query statement. Here, the insert-query statement indicates the insertion of the new first target item name and the first target item value for the first target item name in succession to the existing first basic item name and the second basic item name forming the work table. .

Thereafter, the job processing unit 120 uses the insert-query statement to generate a first work target item name, which is a new item name, and an item value for the first work target item name, in the corresponding work table of the database 140. Insert a value.

In addition, when the work type is a modified work type for modifying the basic item value for a predetermined basic item among the basic items located in the existing work table to a new item value, the work processor 120 is included in the work assistant-query data. Create a modify-query statement based on the work table name, basic item group, and target item group.

For example, the work processing unit 120 may include [update work table name set first work target item name = 'first work target item value', second work target item name = 'second work target item value' where first basic item name = ' Create a modified-query statement consisting of 'first basic item value' and second basic item name = 'second basic item value'.

Here, as shown in Figure 3c, the first target item name and the second target item name is the basic item name (for example, the third basic item value, the fourth basic item value) to be modified ( For example, each of the third basic item name and fourth basic item name).

Accordingly, the modified-query statement is performed on each of the third basic item name and the fourth basic item name, subject to the first basic item name and the first basic item value, the second basic item name, and the second basic item value constituting the work table. The modification of the basic item values (ie, the third basic item value, the fourth basic item value) to the first and second work item values.

Thereafter, the job processing unit 120 modifies the third basic item value for the third basic item name located in the corresponding work table to the first working target item value by using the modified-query statement, and also applies the fourth basic item name to the fourth basic item name. The fourth basic item value for the second target item value is modified.

Lastly, when the work type is a search work type for searching basic item values for a predetermined number of basic items among the basic items constituting the work table, the work processing unit 120 includes a work table included in the work assistant-query data. Generate a search-query statement based on the command name.

For example, the work processor 120 generates a search-query statement composed of [sp_columns @ table_name = 'work table name']. Thereafter, the job processor 120 searches for item names for all items constituting the job table and item values for each item name using the search-query statement. Hereinafter, the item name retrieved from the work table is called the original item name, and the item value for the original item name is called the original item value.

Then, when the processing unit 120 completes the deletion / insertion / modification task based on the database 140, the task processing unit 120 transmits the result data according to the normal processing completion of the corresponding deletion / insertion / modification task to the result providing unit 130. After completing the search operation, the result data including the original item names and the original item values for each original item name are transmitted to the result providing unit 130 based on the work table.

4 is a diagram showing an example of the configuration of the result data. Referring to FIG. 4, the result data is a flag field 301 for recording the result of deletion / insertion / modification and original item names for the search. The original item name group field 302 and the original item value group field 303 for recording the original item value for each original item name in the order of the original item name recorded in the original item name group field 302.

Accordingly, when the delete / insert / modify operation is normally completed, the job processor 120 records 'true' in the flag field 301 of the result data, otherwise records 'false' to delete / insert / modify the respective operations. Derived result data according to Meanwhile, the job processor 120 records the original item names searched according to the search operation in the original item name group field 302, and records the result data by recording the original item values for each original item name in the original item value group field 303. To derive.

The result providing unit 130 receives the work request data generated by the work requesting unit 100 according to the occurrence of the work command from the application program, a database name to be worked on, a work table name to be worked on, basic item names, and each basic Recognizes basic item group, work type, etc., including basic item values for item name.

As a result, when the result data is input from the job processing unit 120, the result data is identified by what job the result data, and if the result data by the deletion / insertion / modification operation, the result data is transferred to the application program, If the result data is a result of a search operation, a search request is made from an application program based on the original item names recorded in the original item name group field 302 and the original item values recorded in the original item value group field 303 of the result data. Only the original item value matching the basic item value for the basic item name is extracted and delivered to the application.

5 is an explanatory diagram for explaining a search result providing process of the result providing unit 130 according to an embodiment of the present invention.

Referring to FIG. 5, the result providing unit 130 receives work request data from the work request unit 100 and receives result data from the work processing unit 120, and the corresponding result data is searched based on the work request data. If it is determined based on the result data, the basic item group 401 is extracted from the work request data, and the original item name group 402 and the original item value group 403 are extracted from the result data. Here, in the original item value group 403, original item values for original item names recorded in the original item name group 402 are recorded in accordance with the indexes of the corresponding original item names.

The result providing unit 130 extracts a first basic item name (eg, A) located at index 0 of the basic item group 401 and searches whether the first basic item name exists in the original item name group 402. At this time, if the same item name as the first basic item name (eg, the third original item name) exists in the original item name group 402, the first basic item value for the first basic item name based on the original item value group 403. Search for whether there is a third original item value for a third original item name equal to (eg, "*").

Here, if the third original item value equal to the first basic item value exists in the original item value group 403, the original item value is extracted and passed to the application, otherwise, the next even index (e.g., index) Repeat the above process for 2).

Meanwhile, as shown in FIG. 5, a first original item name (eg, B) matching the second basic item name (eg, B) exists in the original item name group 402, and is present in the original item value group 403. If there is a first original item value (e.g., "nice") for the first original item name that is equal to the second basic item value (e.g., "nice") for the second basic item name, then the result provider 130 A first original item value (eg, nice) is extracted from the original item value group 403. Similarly, the result providing unit 130 extracts a second original item value (eg, free) from the original item value group 403.

Thereafter, the result providing unit 130 delivers the extracted original item value to the application whenever the original item value is extracted based on the original item value group 403, or based on the original item value group 403. When the extraction of the item value is completed, the extracted plurality of original item values are set as a group and transmitted to the application program.

6 is a flowchart illustrating a database job control method according to an embodiment of the present invention.

Referring to FIG. 6, when the work request unit 100 of the database work control apparatus according to the present invention receives a work command for the work of the database 140 from an application program (s100), the work request is based on the work command. Generate data (s110). Here, the description of the work request data is omitted since it was mentioned in the description of the work request unit 100.

The query data providing unit 110, when the job request data generated in step s110 is input, extracts the query data capable of supporting the work from the plurality of query data and inserts all the information of the job request data into the query data. After deriving the query data, the work assistant-query data is added to the work request data and transferred to the work request unit 100 (S120).

In this case, the work request unit 100 receives work request data including work assistant-query data from the query data providing unit 110 and transmits the work request data to the work processing unit 120.

The work processor 120 receives work request data from the work request unit 100, analyzes work assistant-query data included in the work request data, identifies a work type requested from an application program, and identifies the work type. After generating the query statement, the database 140 is operated using the generated query statement (s130, s140, s150). In this case, detailed descriptions of the steps s130, s140, and s150 are omitted in the description of the work processor 120 and thus will be omitted.

Then, the work processor 120 derives the result data according to the work completion after completing the work of the database 140 using the query statement (S160).

The result providing unit 130 analyzes the result data derived in step S160 and if the result data is determined to be result data based on the deletion / insertion / modification operation (s170), provides the result data to the application program (s180). ).

On the other hand, if the result data is determined to be the result data based on the search operation (s170), only the item value matching the basic item value requested to search from the application program is extracted from the result data and provided to the application program (s190).

FIG. 7 is a flowchart illustrating a query data providing step s120 according to an embodiment of the present invention. Referring to FIG. 7, first, the query data providing unit 110 includes a query data group including a plurality of query data. In operation S121, when the job request data is transmitted from the job request unit 100, it is searched whether there is a job supportable query data among the plurality of query data included in the query data group (S122).

When the search result (s122), the query data that can support the work is searched (s123), the query data is extracted from the query data group (s124), otherwise, new query data is generated and the generated query data is converted into the query data group To add (s125).

Then, by inserting all the information of the work request data into the query data obtained in step s124 or step s125 to derive the work assistant-query data that is the query data including all the information of the work request data (s126).

Thereafter, after adding the work assistant-query data derived in step s126 to the work request data, the work request data including the work assistant-query data is transferred to the work request unit 100 (s127).

8 is a flowchart illustrating a search result providing step s190 according to an embodiment of the present invention. Referring to FIG. 8, first, the result providing unit 130 extracts a basic item group from the work request data, and extracts an original item name group and an original item value group from the result data according to the search operation (S191).

After the predetermined basic item name is extracted from the basic item group (s192), it is searched whether the original item name that is the same item name as the basic item name exists in the original item name group (s193).

When the original item name that is the same item name as the base item name is searched based on the search result (s193) (s194), the original item value that is the same item value as the base item value for the base item name is added to the original item value group. If it is present (s195), otherwise, after extracting the next basic item name from the basic item group (s200), the process returns to the step (s193) of searching whether the original item name which is the same item name as the basic item name exists in the original item name group. .

Subsequently, when the original item value identical to the basic item value for the basic item name is searched based on the search result of the original item value group in step s195 (s196), the same original item value as the basic item value is extracted (s197). If the item value is not found (s196), the process returns to the step (s200) of extracting the next basic item name from the basic item group.

Finally, it is determined whether the current basic item name extracted from the basic item group corresponds to the last basic item name of the basic item group (s198). If the determination result corresponds to the last basic item name of the basic item group, it is extracted in step s197. The original item value is transmitted to the application program (s199), otherwise, the process returns to step S200 of extracting the next basic item name from the basic item group.

Here, FIG. 8 illustrates a method in which the result providing unit 130 provides the original item values extracted from the original item value group to the application program at once. On the other hand, the result providing unit 130 may provide the original item value to the application program each time the original item value is extracted from the original item value group.

So far I looked at the center of the preferred embodiment for the present invention. Those skilled in the art will appreciate that the present invention can be implemented in a modified form without departing from the essential features of the present invention. Therefore, the disclosed embodiments should be considered in descriptive sense only and not for purposes of limitation. The scope of the present invention is shown in the claims rather than the foregoing description, and all differences within the scope will be construed as being included in the present invention.

According to the present invention, when a database work command (eg, data deletion, modification, insertion, retrieval, etc.) from an application program is generated, a query statement according to the work command is provided to support the operation of the database through the corresponding query statement. This has the effect of allowing all applications to work with the database regardless of changes in the database framework.

1 is a schematic block diagram of a database job control apparatus according to an embodiment of the present invention;

2 is a view showing a configuration example of query data according to an embodiment of the present invention;

3A is an exemplary view showing the structure of a basic item group field according to an embodiment of the present invention;

3B is an exemplary view showing the structure of a work target item group field according to an insertion work type according to an embodiment of the present invention;

3C is an exemplary view showing the structure of a work target item group field according to a modified work type according to an embodiment of the present invention;

4 is a view showing an example of the configuration of the result data according to an embodiment of the present invention;

5 is an explanatory diagram for explaining a search result providing process of a result providing unit according to an embodiment of the present invention;

6 is a process flow diagram for a database job control method according to an embodiment of the present invention;

7 is a flowchart illustrating a query data providing step according to an embodiment of the present invention;

8 is a flowchart illustrating a search result providing step according to an embodiment of the present invention.

♣ Explanation of symbols for the main parts of the drawing ♣

100: work request unit 110: query data provider

120: processing unit 130: results providing unit

140: database

Claims (13)

When a work command for a database operation is generated from an application program, a first process of generating work request data based on the work instruction, wherein the first process is name information of a database to be analyzed and analyzed. Work table name which is the name of the database, name information about the table to work among the tables included in the database, work type to work based on the work table, and basic item name which is the name information about the basic items that make up the work table. And a job request data including a basic item group consisting of a basic item value which is data for each basic item name. A second process of inserting all the information of the work request data into the query data enabling access to the database to be worked on when the work request data is generated in the first process, wherein the second process has a plurality of query data; Steps 2-1 of managing the query data group; Steps 2-2 of Determining whether or not work support is possible for each of the plurality of query data when the work request data is generated; Steps 2-3 of generating new query data and adding the generated query data to the query data group if the query data capable of supporting work in step 2-2 is not extracted; and step 2-2 or the second step. In step 2-4, all information of the work request data is inserted into each field of the query data acquired through step 3; A third step of identifying a work type to be worked through the database based on the query data when all information of the work request data is inserted into the query data in the second step; If the work type is identified in the third process, a fourth process of processing a database using the generated query statement after generating a query statement corresponding to the identified work type; And a fifth process of providing a result to an application program when the job processing using the database is completed in the fourth process. delete The method of claim 1, wherein the query data is A flag field for recording whether or not the query data can be supported; A package name field for recording the database name, A table name field for recording the work table name, A job type field for recording the job type, A work target item group field for recording the item name for the item to be worked among the basic items forming the work table and the item value for the item name; A method for controlling database operations used in an object-oriented application, comprising: a basic item name for basic items constituting a work table and a basic item group field for recording basic item values for each basic item name. delete delete delete When a work command for working with a database is generated from an application program, a work request unit which delivers the returned query data to the work processing unit by generating work request data based on the work command and passing it to the query data providing unit. According to the work command, the database name which is the name information of the database to be worked on, the name of the work table which is the name information about the table to be worked among the tables included in the database, the job type to be worked on the work table and Creating a work request data including a basic item group consisting of a basic item name which is name information of basic items constituting a work table and a basic item value which is data for each basic item name; When the work request data is transmitted from the work request unit, the query data providing unit for inserting all the information of the work request data into the query data to enable access to the database to work and delivers the query data to the work request unit; A job processing unit which receives the query data from the job request unit, recognizes a job type to be worked through the database, and generates a query statement according to the job type to process the database through the generated query statement; And And a result providing unit for providing a result according to the job completion of the job processing unit to an application program. delete The method of claim 7, wherein the query data providing unit A flag field for recording job support, A package name field for recording the database name, A table name field for recording the work table name, A job type field for recording the job type, A work target item group field for recording the item name for the item to be worked among the basic items forming the work table and the item value for the item name; In an object-oriented application program, a plurality of query data including a basic item name for basic items constituting a work table and a basic item group field for recording basic item values for each basic item name are managed as a query data group. Database job control unit used. The method of claim 7, wherein the query data providing unit When the work request data is delivered from the work request unit, the query data that can support the work is extracted based on the flag fields of the query data included in the query data group, and the query data that can support the work is extracted. A database job control device for use in an object-oriented application, characterized by inserting all information of job request data into each field. The method of claim 7, wherein the query data providing unit Based on the flag fields of the query data included in the query data group, it is determined whether the query data can be supported for work. If the query data that can support the work is not extracted as a result, new fields are created for each field of the query data. A database job control device for use in an object-oriented application, characterized by inserting all the information of the job request data into. delete delete