KR101351079B1 - Method and system for providing service for controlling program linked to database - Google Patents

Abstract

The present invention is a method and system for providing a service that allows an administrator to easily control a program linked with a database. In the present invention, in a system for controlling a program linked with a database, in the method for controlling the program, providing an input interface to an administrator, receiving an SQL statement from the administrator via the input interface, the receiving Processing the SQL statement in a database, receiving the SQL processing result, extracting column information from the SQL processing result, and matching attribute values with respect to the column information. According to the present invention as described above, it is possible to provide a service that allows an administrator to easily control a program without having specialized knowledge of the overall program.

Description

TECHNICAL AND SYSTEM FOR PROVIDING SERVICE FOR CONTROLLING PROGRAM LINKED TO DATABASE}

The present invention relates to a method and a system for providing a service that allows an administrator to easily control a computer program. More particularly, the present invention provides a service that allows an administrator to easily control a program linked to a database. Method and system.

In order to effectively manage a company, a number of tools have been introduced to manage company resources collectively. In recent years, many companies have a database that stores information about a company's resources, such as company funds, accounting, purchasing, production, and sales. Introduced the ERP (Enterprise Resource Planning) system to efficiently manage By using the ERP system, the company was able to manage the company's overall business processes and identify problems in real time.

Such an ERP system should be able to reflect changes in the company's business processes, such as company organization. For example, if a manufacturing plant's ERP system manages only one year's output, but wants to manage this year's output compared to last year, the ERP system needs to change. In other words, the ERP system needs to be constantly updated, and managers must hire professional developers who have a thorough knowledge of the ERP system deployed in the company. Similarly, Korean Patent Publication No. 10-2004-93680 proposes a method for quickly constructing an ERP system, but in order to realize the method, a developer who can develop the program described in the above method is required.

In other words, a company manager needs developers every time he wants to maintain an ERP system, but in reality, it is difficult to hire such developers immediately, and there is a problem incurred by hiring developers.

In addition, developers must analyze all program sources of the ERP system, unless the party has developed the ERP system, which causes unnecessary processes repeatedly. In addition, the source code that controls the ERP system is often complicated, and if the source code is incorrectly coded in a very small part, the entire program may malfunction, causing serious errors in the ERP system.

Therefore, the present invention has been made to solve the above problems, and the present invention is to provide a service that allows the administrator to easily control the program, without the involvement of a developer having a professional knowledge of programming. .

It is also an object of the present invention to reduce the time and cost required for an administrator to control a program.

In addition, an object of the present invention is to provide a more accurate control method for the administrator to control the program.

According to a feature of the present invention for achieving the above object, in a system for controlling a program linked with a database, in the method for controlling the program, providing an input interface to an administrator, through the input interface Receiving an SQL statement from the administrator, processing the received SQL statement in a database, receiving the SQL processing result, extracting column information from the SQL processing result, and an attribute value for the column information Matching.

In the present invention, the step of receiving the execution request of the program from the user through the input interface, and through the output interface, to the user to display a view page applying the matched attribute value to the column information It further comprises a step.

In the present invention, the step of matching includes automatically determining an attribute value for the column information, and matching the determined attribute value to correspond to the column information.

Also, in the present invention, the determining may include obtaining the attribute value of the column information in the same form as the form in which the column information is used, having the same name as the column information and having a matching attribute value. And determining the obtained attribute value as an attribute value of the column information.

In the present invention, the determining may include obtaining table information of a database corresponding to the column information from the SQL statement, and determining an attribute value of the table information as an attribute value of the column information. It includes.

Also, in the present invention, the determining may include: retrieving attribute values of column information having the same name as the column information and matching attribute values already present in all forms; Obtaining an attribute value represented by a frequency, and determining the obtained attribute value as an attribute value of the column information.

In addition, in the present invention, a system for controlling a program interoperating with a database, comprising: a user terminal configured to provide an input interface to an administrator, a server configured to receive an SQL syntax from the user terminal and deliver the SQL syntax to a database And a database configured to process an SQL syntax received from the server, wherein the server receives an SQL processing result from the database, extracts column information from the SQL processing result, and attributes for the column information. It is further configured to match the value.

According to the present invention as described above, it is possible to provide a service in which an administrator can easily control a program without the involvement of a developer having expertise in programming.

In addition, the present invention can reduce the time and cost required for the administrator to control the program.

In addition, the present invention can provide a more accurate control method for the administrator to control the program.

1 illustrates a system in accordance with a preferred embodiment of the present invention.
2 is an overall schematic diagram of a server according to a preferred embodiment of the present invention.
3 is a flowchart of an operation for providing a method according to a preferred embodiment of the present invention.
4 and 5 are an input interface and an output interface according to a preferred embodiment of the present invention.
6 is a flowchart of an operation for providing a method according to a preferred embodiment of the present invention.

BRIEF DESCRIPTION OF THE DRAWINGS The advantages and features of the present invention and the manner of achieving them will become apparent with reference to the embodiments described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below, but can be implemented in various different forms, and only the embodiments make the disclosure of the present invention complete, and the general knowledge in the art to which the present invention belongs. It is provided to fully inform the person having the scope of the invention, which is defined only by the scope of the claims. Like reference numerals refer to like elements throughout.

1 is a conceptual diagram schematically showing the configuration of a service providing system 100 according to an embodiment of the present invention.

The service providing system 100 according to the embodiment of the present invention provides a service that enables a company administrator who does not have expertise in program development to change a program linked to a database by using several SQL statements.

As shown in FIG. 1, the service providing system 100 includes user terminals 101 and 102, a server 200, and a database 300, which are connected through a network to communicate with each other.

User terminal (101, 102) includes a user who needs to access a program linked with a database, or an apparatus for accessing the service providing system 100 by the administrator who manages the database and the program, In general, it can be an electronic terminal. For example, the user terminals 101 and 102 may be any of a console, a cellular telephone, a personal computer (PC), a tablet computer, a mobile communication terminal, a notebook computer, and personal digital assistants (PDAs). .

The user terminals 101 and 102 include an input interface capable of receiving input from an administrator or a user, and also include an output interface capable of displaying information received from the server 200 to an administrator or a user. The administrator or the user may request the server 200 to execute a specific application through the input interface provided by the user terminals 101 and 102. Also, an SQL statement for controlling an application linked with a database may be requested. You can enter The user terminals 101 and 102 transmit information input through the input interface to the server 200.

The server 200 transmits the result according to the request input through the network to the user terminals 101 and 102. When the server 200 is requested to execute an application program from the user, the execution result of the application program may be transmitted to the user terminals 101 and 102. In addition, when the server 200 receives an SQL statement related to a specific application from an administrator, the server 200 transmits the SQL statement to the database 300 to be executed, and the execution result, that is, the SQL processing result is output from the database 300. After receiving the request from the user terminals 101 and 102 to execute the specific application, the specific application is executed by reflecting the result of the SQL processing and the SQL syntax, and the user terminal 101 or 102 is executed. To send.

The database 300 is a storage medium for receiving, storing and providing data in response to a request of a plurality of users associated with the system in the service providing system 100. The table of database 300 is a database object for representing entities organized by columns and rows.

The database 300 is operated by a database management system (DBMS) that comprehensively maintains and manages data. Such a DBMS allows applications of multiple users to access data in the database 300. In addition, the DBMS analyzes the SQL syntax received from the server 200 and executes the SQL syntax in the database 300, and transmits the processing result to the server 200 as the SQL processing result.

2 is a block diagram schematically illustrating a configuration of a server 200 included in a service providing system 100 according to an exemplary embodiment of the present invention.

The server 200 includes a communication unit 210, a user request processing unit 220, a result analyzing unit 230, an attribute matching unit 240, and an application program managing unit 250.

The communication unit 210 connects the server 200 with a network outside the server, and enables the server 200 to communicate with the user terminals 101 and 102 or the database 300. In addition, the communication unit 210 connects the respective components in the server 200, and allows the respective components to communicate.

The user request processing unit 220 processes the request received through the communication unit 210. That is, when a user requests to execute an application through the user terminals 101 and 102, for example, when a request is made to execute an application such as a web page, the user request processing unit 220 according to the request. The request is transmitted to the application manager 250 to execute the application program, and the application manager 250 transmits a view page, which is an execution result, to the user terminals 101 and 102. In addition, when the user request processing unit 220 receives the SQL statement from the administrator through the user terminals 101 and 102, the user request processing unit 220 transmits the SQL statement to the database 300 to be executed and outputs the result of the SQL processing according to the execution. The processor 230, the attribute matching unit 240, and the application manager 250 are processed.

The result analyzing unit 230 receives the result obtained by the user request processing unit 220 transferring the SQL syntax received from the user terminal 101, 102 to the database 300. The result of executing such an SQL statement in a database is called "SQL processing result" for convenience. The result analyzing unit 230 extracts column information to be displayed to the user from the received SQL processing result. For example, if the SQL statement input by the administrator includes a SELECT command for performing an inquiry on any data included in the database 300, the SQL processing result of executing the SQL statement in the database 300 Includes column information and row information corresponding to the column information. Accordingly, the result analyzer 230 may extract column information from the SQL processing result.

The attribute matching unit 230, for each of the extracted column information, indicates whether to display an attribute value (e.g., column type (e.g., binary number, text format, etc.), column information on the view page. , A characteristic of defining the column information such as a selection of a group to which the access right to the column information is granted, a width and a height when the column information is displayed on the view page, and the like. At this time, an attribute value matching the column information may be set by receiving an input from the administrator, but an attribute value matching the column information may be automatically set on the system without additional administrator setting. In the present invention, since the attribute value matching the column information can be automatically set, the administrator can save the trouble of manually setting the attribute value, and control such as changing the program can be performed in a short time. Can also prevent mistakes in setting attribute values incorrectly.

The application manager 240 manages an application operated on the server 200. When the user requests a result according to the execution of a specific application, the view page, which is a result generated by executing the specific application, is transmitted to the user terminals 101 and 102. In addition, when there is an SQL statement that is called when the application is executed, and the SQL statement is changed by the administrator, the application manager 240 dynamically outputs a result according to the SQL change when the specific application is executed. And the view page accordingly are transmitted to the user terminal (101, 102).

In this case, the application program is a program that interoperates with a database and performs operations on the database, and may be, for example, a dynamic web page script (eg, a script written in asp, php, or jsp). When the SQL statement is called when the program is executed, the SQL statement may be reflected and displayed to the user as, for example, a html type view page.

Hereinafter, with reference to Figs. 3 to 6, the operation of controlling the program that the administrator operates the database according to an embodiment of the present invention will be described.

As shown in FIG. 3, the server 200 operates according to information input from the user terminals 101 and 102 (S310). If the user executes the application managed by the server 200 and requests the view page according to the execution result, the server 200 executes the application and displays the view page according to the result of the user terminal 101. 102) (s350). On the other hand, if the information entered by the administrator is an SQL statement, and the SQL statement is an SQL statement that is called at the time of execution of the application program, the SQL statement is to be executed in the database (300). At this time, the DBMS managing the database 300 processes the received SQL syntax through parsing, etc., and transmits a return value (ie, a SQL processing result) according to the processing result to the server 200 (S320). For example, as shown in FIG. 4, the user terminal 101 provides an input interface 410 to an administrator, through which the administrator can input an SQL syntax. The input SQL statement is transmitted to the server 200, and the server 200 obtains an SQL processing result for the SQL statement by transferring the received SQL statement to the database 300. For example, when an administrator inputs an SQL statement such as 420 of FIG. 4, an SQL processing result, that is, column information and row information, according to a SELECT command that is an SQL command may be obtained from the database 300.

Upon receiving the SQL processing result, the server 200 extracts column information from the SQL processing result (s330), and sets attribute values for each column information (s340). That is, as shown in FIG. 4, the column information 430 is extracted from the SQL processing result according to the SQL syntax shown in 410 of FIG. 4, and the attribute value 440 corresponding to each column information, for example, Set Title, Type, Hidden, Required, Read, Text Align, Title Align, Width, Heigt, Remark, etc. In this case, the attribute value is a value for setting the appearance of each column information when the view page is displayed in the output interface, and a method of automatically setting the attribute value is described in more detail with reference to FIG. 6.

Thereafter, the view page of the application is displayed to the user by reflecting the set property value (S350). That is, when the view page according to the execution result of the application program is requested from the user terminal 101 (that is, the administrator) as well as other user terminal 102 (that is, the user) who inputs the SQL syntax, the column information and The view page reflecting the set property value and the result value according to the SQL statement is transmitted to the user terminal (101, 102). The view page is displayed via the output interface of the user terminal. That is, as shown in FIG. 5, each column information 500 is displayed according to a corresponding attribute value, and row information about each column information 500 is also displayed.

On the other hand, when the server 200 extracts column information from the SQL processing result, an attribute value corresponding to each column information should be set, and this attribute value does not need to be set by the administrator, and is automatically set in the server 200. Can be.

As shown in FIG. 6, when column information is extracted from an SQL processing result and an attribute value needs to be set, column information having the same name exists in the same form as the form including the corresponding column information, and If the attribute value is set, the attribute value of the column information is applied (s610). If not, the process proceeds to the next step. The form here includes, for example, the form in which the view page delivered to the user is displayed. For example, referring to FIGS. 4 and 5, in the form "coc200" forming the "distribution criteria generation and inquiry" view page, there is no column information having the same name as the column information "cc_cd", There is no column information with the same name as the column information "cc_cd" in the same form used in the view page.

In the next step, the SQL syntax is analyzed and the attribute value registered in the table information of the database where the column information is obtained is applied (s620). For example, for 450 in FIG. 5, that is, column information "qty", the SQL statement 420 is analyzed and a table of the database where the column information is obtained, that is, coc200 is known and registered in the table coc200. The attribute value of the column information qty is applied. However, for the column information "cc_cd", the attribute value registered in the table information corresponding to the column information "cc_cd" cannot be known as a result of analyzing the SQL statement 420, and thus proceeds to the next step.

In the next step, the most used attribute value among the attribute values applied to the column information having the same name is applied to all the forms (s630). For example, 460 of FIG. 4, that is, column information "cc_cd" does not have column information having the same name in the same form, and also obtains an attribute value registered in corresponding table information as a result of analyzing an SQL syntax. In all forms, the attribute values of column information having the same name are searched for, and the most used attribute values among the attribute values (if there are two or more used attribute values, randomly, Obtains the selected attribute value), and matches and applies the column information "cc_cd". As a result, for column information "cc_cd", the attribute value of column information cc_cd, which is used in the HRA110 form and has the same column information name, is applied. As a result, Title is "Cost Division" and Type is "Combo". The property value is applied. To indicate that an attribute value of column information in another form is applied, the name of the other form may be described in the remarks column as shown at 460 of FIG. 5.

In this way, the administrator does not need to set an attribute value corresponding to the column information cumbersomely, and the administrator can control the application program in a simple manner in a shorter time.

As such, in the present invention, an administrator can modify a portion of a data operation with a few simple SQL commands without having to analyze the source code of the entire application in order to modify a portion of an application that performs an operation on a database. I can solve it. This allows administrators to access the database, obtain desired data or change the database, and compute data from the database with simple SQL statements without having to know what the application is or how the application is structured. It can be displayed to users of the application program, including. As a result, the cost and time required to control the application can be saved, and the application can be controlled more accurately.

Those skilled in the art may appreciate that various example logic blocks and algorithm steps described in connection with the embodiments disclosed herein may be implemented in electronic hardware, computer software, or a combination thereof. To clearly illustrate this possibility of replacing hardware and software, various illustrative steps have been described above primarily in terms of their functionality. Whether such functionality is implemented in hardware or software depends upon the particular application and design constraints imposed on the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but should not interpret it as causing a decision of such implementation to fall outside the scope of the present invention.

The foregoing examples are only illustrative of the present invention in detail, and the present invention is not limited to these examples. Additions, omissions, substitutions, and other modifications can be made without departing from the spirit of the present invention. The present invention is not limited by the foregoing description, but is limited only by the scope of the appended claims.

100: service providing system 101, 102: user terminal
200: server 300: database
210: communication unit 220: user request processing unit
230: result analysis unit 230: attribute matching unit
250: Application Management Department

Claims (7)

In the system for controlling a program linked with a database, the method for controlling the program,
Providing an input interface to an administrator;
Receiving an SQL statement from the manager via the input interface;
Processing the received SQL statements in a database;
Receiving the SQL processing result and extracting column information from the SQL processing result; And
Matching attribute values for the column information;
The matching step comprises:
Automatically determining an attribute value for the column information; And
And matching the determined attribute value to correspond to the column information. The method of claim 1,
Receiving a request to execute the program from a user through the input interface; And
And displaying, to the user, a view page to which the matched attribute value is applied to the column information through an output interface. delete The method of claim 1,
Wherein the determining comprises:
Acquiring an attribute value of column information in the same form as that in which the column information is used, having the same name as the column information and having a matching attribute value; And
And determining the obtained attribute value as an attribute value of the column information. The method of claim 1,
Wherein the determining comprises:
Obtaining table information of a database corresponding to the column information from the SQL statement; And
And determining an attribute value of the table information as an attribute value of the column information. The method of claim 1,
Wherein the determining comprises:
Retrieving, in all forms, the attribute value of column information having the same name as the column information and having a matching attribute value;
Acquiring attribute values represented by the highest frequency among the retrieved attribute values; And
And determining the obtained attribute value as an attribute value of the column information. As a system to control a program linked with a database,
A user terminal configured to provide an input interface to an administrator;
A server configured to receive an SQL statement from the user terminal and to deliver the SQL statement to a database; And
A database configured to process the SQL syntax received from the server,
The server comprises:
Receive SQL processing results from the database, extract column information from the SQL processing results, match attribute values for the column information, and automatically determine attribute values for the column information, and determine the determined attribute values for the column. And further configured to match in correspondence with the information.

Images