KR101704145B1 - Controller Management Station for Supporting Heterogeneous Database and Controlling System Including The Controller Management Station - Google Patents

Abstract

A control system according to an aspect of the present invention, which is applicable even in an environment in which a database is not provided, is constituted by one or more controllers to collect various signals from facilities in the field, An industrial control station for performing sequence control; A plurality of racks included in each controller, a plurality of boards included in each rack, and a plurality of channels included in each board according to setting information input from a user, And a controller management station for diagnosing the state of the controller, the rack, the board, and the channel according to status information transmitted from the rack, the board, and the channel, and the controller management station includes a database management system And a file agent for generating a file path and file database for recording the channel setting information if the DBMS is not provided, and recording the setting information of the channel in the file database.

Description

Technical Field [0001] The present invention relates to a controller management station supporting heterogeneous databases and a control system including the same,

The present invention relates to a controller, and more particularly, to a system for managing an industrial controller.

Industrial controllers control a variety of field installations installed at industrial sites. For example, an industrial controller performs control over a continuous production process of a steel industry plant such as a rolling process or a plating process. The industrial controller supports RTOS (Real Time Operating System) based multi-processing and processes input / output data at high speed using various industrial communication based on optical communication.

The above-mentioned industrial controller is installed and managed by the controller management station which performs installation and diagnosis of the industrial controller. The controller management station shall store the configuration information for the industrial controller or the status information of the industrial controller in the database.

However, existing controller management stations only have to support only one kind of database. If customer wants to re-develop controller management station if database is different from database supported by controller management station, And a new database management system (DBMS) must be newly purchased.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and it is a technical object of the present invention to provide a controller management station supporting a heterogeneous database applicable to an environment without a database and a control system including the same.

It is another object of the present invention to provide a controller management station that supports heterogeneous databases that can be applied regardless of the types of databases, and a database management method of a control system including the same.

According to an aspect of the present invention, there is provided a control system including at least one controller for collecting various signals from equipment in the field and for controlling operations and sequences of control logic ) An industrial control station for performing control; A plurality of racks included in each controller, a plurality of boards included in each rack, and a plurality of channels included in each board according to setting information input from a user, And a controller management station for diagnosing the state of the controller, the rack, the board, and the channel according to status information transmitted from the rack, the board, and the channel, and the controller management station includes a database management system And a file agent for generating a file path and file database for recording the channel setting information if the DBMS is not provided, and recording the setting information of the channel in the file database.

According to another aspect of the present invention, there is provided a controller management station for supporting a heterogeneous database, the controller including a controller for controlling operations of respective devices installed in the field, a plurality of racks constituting the controller, A system manager for receiving configuration information of a plurality of channels included in each of the plurality of boards; And a database management system (DBMS). If the DBMS is not provided, a file path and a file database for recording the setting information of the channel are created, and setting information of the channel is recorded in the file database And a file agent.

According to the present invention, even in an environment in which a database is not provided, since a file database can be created and the controller management station can be used, it is possible to minimize the environmental restriction applied to the controller management station and thereby expand the coverage range of the controller management station Can be effective.

In addition, according to the present invention, since a controller management station can support a heterogeneous database, it is not necessary for a system developer to redevelop a controller management station according to a database type, thereby reducing system development cost and maintenance cost , It is not necessary for the customer to purchase a new database and database management system according to the controller management station, thereby reducing the system construction cost.

1 is a diagram showing a configuration of a control system according to an embodiment of the present invention
2 is a block diagram schematically illustrating a configuration of a controller management station supporting a heterogeneous database according to an embodiment of the present invention.
3A and 3B are views showing examples of interface screens for receiving setting information of an industrial control station.
4 is a diagram illustrating an example of a command execution procedure for recording channel setting information in a file database.
5 is a view showing data included in channel setting information.
FIG. 6 is a view illustrating a type of each board.
7 is a diagram showing an area where channel setting information is recorded on the file database.
FIG. 8 is an exemplary diagram illustrating a mapping rule for converting a first query statement into a second query statement.
FIG. 9 is an exemplary diagram illustrating a function mapping rule for converting a first query statement into a second query statement.
10 is a flowchart illustrating a database management method in a controller management station according to an embodiment of the present invention.

The meaning of the terms described herein should be understood as follows.

The word " first, "" second," and the like, used to distinguish one element from another, are to be understood to include plural representations unless the context clearly dictates otherwise. The scope of the right should not be limited by these terms.

It should be understood that the terms "comprises" or "having" does not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or combinations thereof.

It should be understood that the term "at least one" includes all possible combinations from one or more related items. For example, the meaning of "at least one of the first item, the second item and the third item" means not only the first item, the second item or the third item, but also the second item and the second item among the first item, Means any combination of items that can be presented from more than one.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is a block diagram illustrating a configuration of a control system according to an embodiment of the present invention.

1, a control system according to an embodiment of the present invention includes an industrial controller 100, an interface system 110, and a controller management station 120 to be controlled.

The industrial controller 100 collects various signals from facilities in the field, and performs calculation and sequence control functions of control logic for controlling each facility.

The interface system 110 performs an HMI (Human Machine Interface) function for operation and monitoring of the industrial controller 100.

The controller management station 120 performs installation / diagnosis of the industrial controller 100, maintenance of engineering data, and correction of applications that may occur during the operation of the industrial controller 100.

Hereinafter, a configuration of a controller management station supporting heterogeneous databases according to an embodiment of the present invention will be described in more detail with reference to FIG.

2 is a block diagram schematically illustrating a configuration of a controller management station supporting a heterogeneous database according to an embodiment of the present invention.

A controller management station (hereinafter referred to as 'controller management station') 200 that supports the heterogeneous database shown in FIG. 2 includes an installation / diagnosis of an industrial control station for controlling the operation of various equipment installed in the field, And an application modification function that may occur during the operation of the industrial control station.

At this time, the industrial control station interlocked with the controller management station 200 according to the present invention may be implemented with a plurality of controllers (not shown, for example, eight), and each controller includes a plurality of racks, And a plurality of channels (e.g., slots) constituting a plurality of boards.

Accordingly, the controller management station 200 of the present invention includes a plurality of controllers constituting an industrial control station, a plurality of racks included in each controller, a plurality of boards mounted in each rack, and a plurality of channels Lt; / RTI >

In particular, the controller management station 200 according to the present invention records setting information on the channels of the respective controllers in the database.

Hereinafter, the configuration of the controller management station 200 according to the present invention will be described in more detail.

The controller management station 200 according to the present invention includes a system manager 210 and a DB agent 220, as shown in FIG.

The system manager 210 provides an operator with an interface screen for installing an industrial control station that controls the operation of each equipment installed in the field, and the system manager 210 provides an interface screen to the industrial control station based on the setting information of the industrial control station, Perform setup.

To this end, the system manager 210 includes an interface unit 212, a configuration information analysis unit 214, and a status diagnosis unit 216.

First, the interface unit 212 provides an interface screen for receiving configuration information of the industrial control station to the operator, and receives configuration information of the industrial control station through the interface screen. The interface unit 212 provides the input setting information to the setting information analysis unit 214.

Specifically, the interface unit 212 receives setting information for a plurality of controllers constituting an industrial control station, setting information for a plurality of racks mounted on each controller, information for a plurality of boards mounted on each rack, Setting information, and setting information for a plurality of channels included in each board.

In one embodiment, the interface unit 212 provides the operator with an interface screen as shown in FIG. 3A, thereby providing configuration information for a plurality of controllers, setting information for a plurality of racks mounted on each controller, The setting information for a plurality of boards mounted on the rack can be obtained. The setting information of the controller, the rack setting information, and the board setting information received through the interface unit 212 are used for recording setting information of a channel to be described later.

In accordance with this embodiment, the interface unit 212 displays the name of the controller, the index of the controller (controller ID), the method of storing information, the IP address of the controller, the number of racks, You can receive configuration information about the index of the rack, the type of rack, the number of boards, the index of the board, the type of board, and so on.

In addition, the interface unit 212 receives the setting information for a plurality of channels included in each board by providing an operator with an interface screen as shown in FIG. 3B. In FIG. 3B, a channel is indicated by the name tag.

According to this embodiment, the interface unit 212 may receive information on the board name, rack name, tag length, and the like from the operator through the interface screen shown in FIG. 3B.

In addition, the interface unit 212 according to the present invention receives status information of the industrial control station from the industrial control station, and transmits diagnostic information of the industrial control station, which is generated based on the received status information and status information, .

The setting information analyzing unit 214 analyzes the setting information of the industrial control station received through the interface unit 212. More specifically, the setting information analyzing unit 214 extracts the index of the controller, the index of the rack, and the index of the board from the setting information of the industrial control station input through the interface screen, and provides the index to the database agent 220. The index of the controller, the index of the rack, and the index of the board acquired by the setting information analyzing unit 214 are used for creating a file path or a file database for recording setting information of a channel thereafter.

The status diagnosis unit 216 receives the status information from the controllers, the racks, the boards, and the channels included in the industrial control station to determine the operating status of the controller, rack, board, and channel (e.g., And the like). The state diagnosis unit 216 provides the monitoring result to the operator through the interface unit 212. [

In addition, the system manager 210 performs maintenance of the engineering data required for operation of the controller management station 200 and modification of the application installed in the industrial control station.

Next, the database agent 220 records the setting information of the industrial control station, that is, the setting information of the channel, which is transmitted from the system manager 210, in the database.

Particularly, the database agent 220 according to the present invention sets a channel by using a different mechanism depending on the presence or absence of a database management system (DBMS) of the controller management station 200 Record information in the database.

To this end, the database agent 220 according to the present invention includes a DBMS determination unit 222, a file agent 224, and a DBMS agent 226, as shown in FIG.

The DBMS determination unit 222 detects the DBMS configuration information of the user and confirms whether the controller management station 200 has the DBMS. In one embodiment, the DBMS determination unit 222 can determine whether the controller management station 200 has a DBMS by detecting a flag value for a data storage method obtained through the interface unit 212 .

For example, if the flag value for the data storage method is set to 0, the DBMS determination unit 222 determines that the controller management station 200 does not have a DBMS, and if the value of the flag for the data storage method is 1 It can be determined that the controller management station 200 has a DBMS.

The file agent 224 determines that the DBMS does not include the DBMS by the DBMS determination unit 222 based on the setting information of the industrial control station transmitted from the system manager 210. [ A file path for recording setting information and a file database are created.

In one embodiment, the file agent 224 creates a file database for recording the setting information of the channel and the file path for recording the setting information of the channel using the index of the controller, the index of the rack, and the index of the board can do. For example, if the index of a specific controller is 01, the index of a rack included in the controller is 120, and the index of a board included in the corresponding rack is 01, the file agent 224 determines that the file path for the corresponding channel is "C: \\ 120 \\ 01 \ ", and creates a file database having the file name "0112001.txt" in the corresponding directory.

Then, the file agent 224 records the setting information of the channel in the generated file database. 4, the file agent 224 opens the file database of the corresponding channel in the directory in which the file database of the corresponding channel is recorded by using the file path for the channel, The setting information of the channel is recorded.

5, the setting information of the channel includes a Tag name, a minimum value ScaleMin of the channel output, a maximum value ScaleMax of the channel output, a resolution of the channel, Information about the scan type of the channel (ScanType), information about the channel code (SignFlag), and the HMI index of the channel (HMIidx). Here, the information on the scan type of the channel indicates information indicating whether or not to scan at a high speed among the channels.

Herein, the name of the channel is sequentially arranged in the order of the type of the board including the corresponding channel, the index of the controller including the corresponding channel, the index of the rack including the corresponding channel, and the index of the board including the corresponding channel ≪ / RTI > At this time, the type of the board is as shown in Fig.

For example, if the type of the board including the specific channel is MX, the index of the controller including the channel is 01, the index of the rack including the channel is 120, the index of the board including the channel 01 ", the file agent 224 can generate the name of the corresponding channel as "MX0112001 ".

The file agent 224 stores the channel setting information in the file database. The file agent 224 stores each data on a column separated according to an offset value preliminarily allocated to each data constituting the channel setting information Can be recorded.

For example, as shown in FIG. 7, when the size of the area where the setting information of each channel is to be recorded on the file database is 18 Bytes, the offset of the column in which the channel name is to be written is 0, Since the channel name (TagName) is recorded in the column and the offset of the column in which the minimum value of the channel is recorded is 2, the minimum value (ScaleMin) of the channel is recorded in the column where the second byte is the starting point. Since the offset of the column in which the maximum value of the channel is to be recorded is 6, the maximum value (ScaleMax) of the channel is recorded in the column where the sixth byte is the starting point, and the offset of the column in which the resolution of the channel is recorded is 10, The resolution of the channel is recorded in the column. Since the offset of the column in which the scan type of the channel is to be recorded is 12, the scan type value (ScanType) of the channel is recorded in the column where the 12th byte is the starting point, and the offset of the column in which the sign of the channel is recorded is 14, And the HMI index of the channel is recorded in the column where the 16th byte is the starting point since the offset of the column in which the HMI index of the channel is recorded is 16.

On the other hand, when a deletion request for one of the channels recorded on the file database is received, the file agent 224 according to the present invention not deletes all the setting information of the corresponding channel on the file database, The setting information of the corresponding channel is not referenced by performing null processing on the bytes corresponding to the setting information of the channel.

2, when it is determined by the DBMS determination unit 222 that the controller management station 200 includes a DBMS, the DBMS agent 226 determines that the DBMS agent 226 is connected to the industrial control station And generates a query statement for transmitting setting information, that is, channel setting information, to the corresponding DBMS.

To this end, the DBMS agent 226 includes a query statement generation unit 232, a query statement conversion unit 234, and a query statement execution unit 236.

First, the query-statement generating unit 232 generates a first query statement for recording channel setting information according to a predetermined reference-type DBMS. In one embodiment, the DBMS of the reference type is set to MS-SQL, and the first query statement generation unit 232 generates a first query statement according to MS-SQL.

If the type of the DBMS provided in the controller management station 200 is not the same as the reference type, the query conversion unit 234 converts the type of the DBMS provided in the controller management station 200 into a predetermined conversion rule And converts the first query statement into a second query statement according to the DBMS provided in the controller management station 200.

8, if the first query statement is generated according to MS-SQL and the type of the DBMS provided in the controller management station 200 is Oracle, the query statement conversion unit 234, Converts the first query statement into a second query statement according to Oracle.

In one embodiment, the query statement transformer 234 transforms the query statement into a function used in the first query statement according to a predetermined function mapping rule in the DBMS provided in the controller management station 200 Function, and converts the first query statement into the second query statement using the converted function. An example of a function mapping rule between MS-SQL and Oracle is shown in FIG.

The query statement execution unit 236 transfers the second query sentence generated by the query statement generation unit 232 or the second query sentence converted by the query statement conversion unit 234 to the corresponding DBMS, The channel setting information can be recorded in the table of the database according to the query statement or the second query statement.

In this way, the controller management station 200 according to the present invention can be applied even if the customer does not use the DBMS or the DBMS used by the customer is not supported by the controller management station 200, Accordingly, it is not necessary to change the design of the controller management station 200 or to purchase a new DBMS by the customer, which can overcome the restriction of the environment according to the type of the DBMS.

Meanwhile, the system manager 210 according to the present invention writes the setting information of the channel in the shared memory 230 before recording the channel setting information in the database, so that various processes driven by the controller management station 200 So that the setting information of the channel can be shared.

In the above-described embodiment, the database agent 220 has described only the channel setting information of the industrial control station in the file database or in the database linked to the DBMS. However, in the modified embodiment, The setting information of the rack, and the information of the channel may be recorded in a database linked to the file database or the DBMS.

Hereinafter, a database management method in the controller management station according to the present invention will be described with reference to FIG.

10 is a flowchart illustrating a database management method in a controller management station according to an embodiment of the present invention.

The database management method shown in Fig. 10 can be performed by the controller management station shown in Fig.

First, the controller management station receives a plurality of controllers included in an industrial control station, a plurality of racks constituting each controller, a plurality of boards included in each rack, and setting information of channels included in each board (S1000) .

In one embodiment, the controller management station provides the interface screen as shown in FIG. 3A to the operator so that the setting information of the controller, the setting information of the rack, and the setting information of the board are input through the corresponding interface screen, By providing the operator with the interface screen as shown, the setting information of the channels can be inputted through the interface screen.

Then, the controller management station parses the setting information obtained in S1000 to acquire the index of the controller, the index of the rack, and the index of the board (S1010).

Then, the controller management station confirms whether the DBMS is present (S1020). If it is determined that the DBMS is not provided, the controller management station determines whether the DBMS is available or not by using the controller index, the rack index, A file path and a file database for recording setting information of channels included in the board are created (S1025).

In one embodiment, the controller management station may check whether a DBMS is present by checking the value of a flag indicating whether the DBMS is present or not. For example, the controller management station determines that the DBMS is not provided if the value of the flag indicating whether the DBMS is present is 0, and determines that the DBMS is provided if the value of the flag indicating whether the DBMS is present is 1 .

In generating the file path and the file database, the controller management station determines that the index of the specific controller is 01, the index of the rack included in the controller is 120, and the index of the board included in the corresponding rack is 01, Can be created with the file path of "C: \ 01 \\ 120 \\ 01", and a file database having the file name of "0112001.txt" in the corresponding directory can be created.

Then, the controller management station generates the name of the channel using the type of the board, the index of the controller including the corresponding channel, the index of the rack including the corresponding channel, and the index of the board including the corresponding channel ( S1030).

In one embodiment, the controller management station sequentially arranges the type of the board, the index of the controller including the channel, the index of the rack including the channel, and the index of the board including the channel, Can be created.

Thereafter, the controller management station records the setting information of the channel including the name of the channel in the file database created in step S1020 (S1040). 4, the controller management station opens the file database of the corresponding channel in the directory in which the file database of the corresponding channel is recorded using the file path for the channel, As shown in FIG.

In one embodiment, the channel setting information includes at least one of a minimum value ScaleMin of a channel output, a maximum value ScaleMax of a channel output, a resolution of a channel, information on a scan type of a channel (ScanType) Information (SignFlag), and a channel's HMI index (HMIidx).

In recording the setting information of the channel in the file database, the controller management station records each data on a column separated according to an offset value preliminarily allocated to each data constituting the channel setting information . For example, as shown in FIG. 7, when the size of the area where the setting information of each channel is to be recorded on the file database is 18 Bytes, the offset of the column in which the channel name is to be written is 0, Since the channel name (TagName) is recorded in the column and the offset of the column in which the minimum value of the channel is recorded is 2, the minimum value (ScaleMin) of the channel is recorded in the column where the second byte is the starting point. Since the offset of the column in which the maximum value of the channel is to be recorded is 6, the maximum value (ScaleMax) of the channel is recorded in the column where the sixth byte is the starting point, and the offset of the column in which the resolution of the channel is recorded is 10, The resolution of the channel is recorded in the column. Since the offset of the column in which the scan type of the channel is to be recorded is 12, the scan type value (ScanType) of the channel is recorded in the column where the 12th byte is the starting point, and the offset of the column in which the sign of the channel is recorded is 14, And the HMI index of the channel is recorded in the column where the 16th byte is the starting point since the offset of the column in which the HMI index of the channel is recorded is 16.

On the other hand, when the deletion request for one of the channels recorded on the file database is received, the controller management station does not delete all the setting information of the corresponding channel on the file database, By processing the bytes, the configuration information of the corresponding channel is not referred to.

If it is determined in step S1020 that the DBMS is provided, the controller management station generates the names of the channels included in each board using the controller index, the index of the rack, and the index of the board obtained in step S1010 (S1050) In operation S1060, a first query statement for recording channel setting information including the name of the generated channel is generated.

At this time, the controller management station generates the first query statement according to the DBMS of the reference type based on the DBMS of the preset reference type.

Accordingly, the controller management station determines whether the type of the DBMS included in the controller management station is the same as the preset type (S1070). If not, the controller management station determines whether the type of the DBMS Into a second query sentence according to the following equation (S1075).

In one embodiment, the controller management station converts a function used in a first query statement into a function used in the provided DBMS according to a predetermined function mapping rule, and then, using the converted function, To the second query statement.

Thereafter, the controller management station transfers the first query statement or the second query statement to the corresponding DBMS so that the corresponding DBMS executes the first query statement or the second query statement to record the channel setting information in the database (S 1080).

In the above-described embodiment, the channel setting information is input together with the setting information of the controller, the rack, and the board. However, this is only one example. In a modified embodiment, And the file path and file database based on the index of the board.

It will be understood by those skilled in the art that the present invention can be embodied in other specific forms without departing from the spirit or essential characteristics thereof.

It is therefore to be understood that the above-described embodiments are illustrative in all aspects and not restrictive. The scope of the present invention is defined by the appended claims rather than the detailed description and all changes or modifications derived from the meaning and scope of the claims and their equivalents are to be construed as being included within the scope of the present invention do.

200: controller management station 210: system manager
212: interface unit 214: setting information analyzing unit
216: state diagnosis unit 220: database agent
222: DBMS judgment unit 224: File agent
226: DBMS agent 232: Query statement generation unit
234: Query statement conversion unit 236: Query statement execution unit

Claims (16)

An industrial control station consisting of one or more controllers, for collecting various signals from facilities in the field and for performing control and sequence control of control logic for control of the respective facilities; And
A plurality of racks included in each controller, a plurality of boards included in each rack, and a plurality of channels included in each board according to setting information input from a user, And a controller management station for diagnosing the status of the controller, the rack, the board, and the channel according to status information transmitted from the rack, the board, and the channel,
The controller management station comprises:
A file path and a file database for recording the setting information of the channel if the DBMS is not provided, and a file for recording setting information of the channel in the file database, A control system comprising an agent. The method according to claim 1,
The file agent comprising:
Wherein the index of the controller, the index of the rack, and the index of the board are sequentially arranged to generate the file path and the file name of the file database. The method according to claim 1,
The setting information of the channel includes:
A name of the channel, a minimum output value of the channel, a maximum output value of the channel, a resolution of the channel, information on a scan type of the channel, information on a sign of the channel, -Machine Interface index,
Wherein the name of the channel is generated by sequentially arranging the type of the board, the index of the controller, the index of the rack, and the index of the board. 3. The method of claim 2,
The file agent comprising:
Wherein each of the data constituting the channel setting information is recorded in a column separated according to an offset value allocated to each data item. The method according to claim 1,
The controller management station comprises:
Further comprising a DBMS agent for generating a query statement for recording the channel setting information if the DBMS is provided and for transmitting the generated query statement to the provided DBMS. 6. The method of claim 5,
The DBMS agent,
A query statement generating unit for generating a first query statement according to a DBMS of a predetermined reference type;
A query statement converting unit for converting the first query statement into a second query according to a type of the provided DBMS according to a predetermined conversion rule when the type of the provided DBMS differs from the predetermined reference type; And
And a query statement execution unit for transmitting the first query statement or the second query statement to the provided DBMS. The method according to claim 1,
The controller management station comprises:
Further comprising: a system manager configured to set the controller, the rack, the board, and the channel according to the setting information. A plurality of racks constituting the controller, a plurality of boards included in the respective racks, and a plurality of channels included in each of the plurality of boards, A system manager for receiving from the system manager; And
A file path and a file database for recording the setting information of the channel if the DBMS is not provided, and a file for recording setting information of the channel in the file database, A controller management station that supports heterogeneous databases, including agents. 9. The method of claim 8,
The setting information of the channel includes:
A name of the channel, a minimum output value of the channel, a maximum output value of the channel, a resolution of the channel, information on a scan type of the channel, information on a sign of the channel, And an index of a physical address of the controller. 10. The method of claim 9,
The name of the channel,
Wherein the controller is configured by sequentially arranging the type of the board, the index of the controller, the index of the rack, and the index of the board. 10. The method of claim 9,
The file agent comprising:
Wherein each of the data constituting the channel setting information is recorded in a column separated according to an offset value assigned to each data item. 10. The method of claim 9,
The file agent comprising:
And nulls the setting information of the deleted channel if any one of the plurality of channels is deleted. 9. The method of claim 8,
The file agent comprising:
Wherein the index of the controller, the index of the rack, and the index of the board are sequentially arranged to generate the file path and the file name of the file database. 9. The method of claim 8,
Further comprising a DBMS agent for generating a query statement for recording the channel setting information if the DBMS is provided and for transmitting the generated query statement to the provided DBMS, Controller management station. 15. The method of claim 14,
The DBMS agent,
A query statement generating unit for generating a first query statement according to a DBMS of a predetermined reference type;
A query statement converting unit for converting the first query statement into a second query according to a type of the provided DBMS according to a predetermined conversion rule when the type of the provided DBMS differs from the predetermined reference type; And
And a query statement execution unit for transmitting the first query statement or the second query statement to the DBMS. 16. The method of claim 15,
Wherein the query-
Converts the function used in the first query statement into a function used in the provided DBMS according to a predetermined function mapping rule and converts the first query statement into the second query statement using the converted function A controller management station that supports heterogeneous databases.

Images