JP2001005823A - Database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow even a person having no skill in database software to grasp the contents of a database by retrieving the database with an optional data name corresponding to a data ID by 1:1 as a keyword. SOLUTION: A database 10 stores data, and the data in the database 10 are given a data ID of a style characteristic to database software. A definition means 11 defines an optional data name by 1:1 with the data ID, and a table preparing means 12 prepares the corresponding table of the data ID and the defined data name. A corresponding table memory 13 stores a prepared corresponding table T. A designating means 14 designates the data name and a retrieving means 15 calculates the data ID corresponding to the data name designated by the means 14 from the table T to retrieve data with the calculated data ID from the database. A display means 16 displays information required for managing, retrieving, etc., the database 10.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for constructing and managing a database.

[0002]

2. Description of the Related Art Data bases store data in a predetermined format. The database has various data contents and data structures depending on the purpose of use and the like. The conventional problems of a database system having a database are described below.

(Problem 1) In a large-scale system, many databases are distributed and arranged in the system. The data of each database is provided with a data ID in a format unique to each database software. For example,
In the database A, a data ID in a format compatible with the database software a is assigned, and in the database B, a data ID in a format compatible with the database software b is assigned. For this reason, only those who are experienced in the database software a or b cannot easily recognize what data is stored in the databases A and B. That is, the data ID of the conventional database is not a general easy-to-understand identifier.

(Problem 2) When it is desired to take in data from an external database to an internal database in the system, if the communication protocol is different between the external database and the internal database, the structure of the internal database must be changed. For example, there was a problem that data from an external database could not be imported.

[0005]

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and has the following objects. An arbitrary data name corresponding to the data ID and 1: 1 is defined, and the database can be searched using this data name as a keyword. As a result, a database system is realized in which even a person who is not familiar with database software can easily grasp the contents of the database. A plurality of types of protocols are prepared, and communication with the external database is performed by using the protocol according to the system of the external database. This realizes a database system that can easily take in data of an external database having a different communication protocol from that of the database system.

[0006]

SUMMARY OF THE INVENTION The present invention is a database system having the following configuration.

(1) In a database system having a database storing data with a data ID of a format unique to database software, the data I
Definition means for defining an arbitrary data name 1: 1 with D;
A table creating means for creating a correspondence table between the data ID and the defined data name, a correspondence table memory for storing the created correspondence table, a designation means for designating the data name, and a correspondence to the data name designated by the designation means A search unit for determining a data ID from the correspondence table and searching a database for data with the determined data ID from a database.

(2) A plurality of databases are distributed and arranged,
In each database, in a database system in which data having a data ID in a format unique to each database software is stored, a definition means for defining an arbitrary data name 1: 1 with the data ID; Table creation means for creating a correspondence table with the defined data name, correspondence table memory for storing the created correspondence table, designation means for designating the data name, and data ID corresponding to the data name designated by the designation means A search means for searching the database for data with the data ID determined from the correspondence table.

(3) Display means for displaying a table detail designation screen in which the data ID is associated with an input area for inputting a data name, and input means for inputting a data name in an input area on the screen The database system according to (1) or (2), wherein the table creation means describes a data name input to the input area in a corresponding portion of the correspondence table.

(4) In a database system in which a data table in which data stored in a database are compiled in predetermined units is stored, and the stored data table is provided with a table ID in a format unique to database software, Definition means for defining an arbitrary table name on a 1: 1 basis, table creation means for creating a correspondence table between a table ID and a defined table name, correspondence table memory for storing the created correspondence table, and table name designation And a search means for determining a table ID corresponding to the table name specified by the specification means from the correspondence table, and searching a database for a data table having the determined table ID. Database system.

(5) Display means for displaying an index screen in which the table ID is associated with an input area for inputting a table name, and input means for inputting a table name in an input area on the screen. (4) The database system according to (4), wherein the table creating means describes a table name input to the input area in a corresponding portion of the correspondence table.

(6) In a database system having a database in which data is stored in accordance with a predefined format, communication is possible with a plurality of types of protocols, a protocol is selected according to the type of the external database, and an external device is selected according to the selected protocol. Communicates with the database,
A database system comprising interface means for taking in data of an external database into an internal database in the system.

(7) When the format of the data table in the external database is different from the format of the data table in the internal database, the data in the data table of the external database is associated with the data in the data table of the internal database. The database system according to (6), further comprising adjusting means for describing data sent from the database in a corresponding part of a data table of the internal database.

(8) When the type of data sent from the data table of the external database but not in the data table of the internal database is sent,
The database system according to (6), wherein the data is discarded.

(9) In a database system having a database in which data is stored in accordance with a predefined format, a method in which a predetermined arithmetic expression is defined is provided, and a method group having a predetermined number of such methods is provided. And a method processing means for performing an arithmetic operation on the input raw data by the arithmetic expression when an activation signal is supplied from the computer and storing the arithmetic result in a database.

(10) The database system according to (9), wherein the activation signal is given at a fixed period or at an arbitrary timing.

(11) The database has a structure of a database object, and the database object collectively holds data in a predetermined unit, and transfers the held data when a message is given. (9) The database system according to the above.

(12) The database system according to (11), wherein the database object collectively holds data on one device existing in the plant.

[0019]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below in detail with reference to the drawings. FIG. 1 is a configuration diagram showing one embodiment of the present invention. In FIG. 1, data is stored in a database 10. The data in the database 10 is provided with a data ID in a format unique to the database software. The definition means 11 defines an arbitrary data name 1: 1 with the data ID. The table creating means 12 creates a correspondence table between the data ID and the defined data name. The correspondence table memory 13 stores the created correspondence table T.

The specifying means 14 specifies a data name.
The search means 15 finds a data ID corresponding to the data name designated by the designation means 14 from the correspondence table T, and searches the database for data with the found data ID.

The display means 16 displays information necessary for database management, search, and the like. The display means 16 displays the data I
A table detail designation screen is displayed in which D is associated with an input area for inputting a data name. Input means 17
Input the data name in the input area of the table detail designation screen. At this time, the table creating means 12 describes the input data name in a corresponding portion of the correspondence table T.
The display control means 18 controls the display means 16.

The operation of the database system shown in FIG. 1 will be described. The description will be made in accordance with the order of the signal flows shown in FIGS. First, a procedure for creating a correspondence table will be described. The definition means 11 defines an arbitrary data name 1: 1 with the data ID. The table creating means 12 creates a correspondence table between data IDs and data names. The created correspondence table is stored in the correspondence table memory 13.

Next, the procedure for searching the database will be described. The specifying means 14 specifies a data name. The search means 15 gives the specified data name to the correspondence table memory 13. The data ID corresponding to the data name is read from the correspondence table T. The search means 15 gives the read data ID to the database 10. Data with the given data ID is stored in the database 10
Is read from.

A procedure for inputting a data name on a screen will be described. The display means 16 displays a table detail designation screen in which a data ID is associated with an input area for inputting a data name. The input means 17 inputs a data name in an input area of the table detail designation screen. Thereby, the correspondence between the data ID and the data name can be confirmed on the table detail designation screen. The table creation means 12 describes the data name input by the input means 17 in a corresponding part of the correspondence table T.
As a result, a correspondence table is constructed.

Definition means 11, designation means 14, input means 1
Reference numeral 7 includes, for example, a keyboard, a mouse, and the like.
These may be integrated.

FIG. 2 is a diagram showing an example of an application system of the present invention. FIG. 2 shows an example of an information integration system of a refinery. In FIG. 2, the planning unit 30 creates a production plan from a resource allocation plan based on business demand. The production plan database 31 stores the production plan created by the planning unit 30. This production plan is, for example, a monthly production plan. The scheduling unit 32 creates a schedule for executing, for example, a daily production plan and a blend plan based on the production plan in the production plan database 31.

The on-site database 35 stores data used when performing oil refining. The off-site database 36 stores data used when carrying out receipt / shipment and storage. The on-site database 35 includes a history database 351, a real-time database 352, and an event database 353.
Stores the history of the process data transmitted from the distributed control system 38, the current process data, and the alarm information. In the off-site database 36, an inventory database 361 stores inventory data of products and semi-finished products. The oil amount movement database 362 stores oil amount data that moves between tanks when blending oil.

The operation management database 37 stores data necessary for operation management. In the operation management database 37, a plant model database 371 stores data on a plant model. The calculation value database 372 stores calculation value data obtained by performing arithmetic processing on raw data from the plant. The product database 373 stores data on product production amounts and the like. The target value library database 374 stores data on target values of the production plan. The lab database 375 stores data on the lab test system.

The data processing section 39 processes data of each database. The operation management unit 40 manages the control operation of the distributed control system 38 using the processing result of the data processing unit 39. The distributed control system 38 operates the refinery plant 41 under the control of the operation management unit 40.

In such a refinery information integration system, the database system according to the present invention comprises a production plan database 31, 33, a blend plan database 3
4. Applied to the on-site database 35, the off-site database 36, the operation management database 37, and the like.

FIG. 3 is a view showing an example of the table detail designation screen. FIG. 3 shows a screen example in the information integration system of a refinery. As shown in FIG. 3, on the detail designation screen, a data ID and an input area for inputting a data name are displayed in association with each other. For example, the data name “planned date” is input in the input area G. The data name “planned date” and the data ID “tm
“stmp” is displayed correspondingly. The data name is also input to other input areas. The input data name is described in the correspondence table.

FIG. 4 is a block diagram showing another embodiment of the present invention. In FIG. 4, the database 101 stores a data table in which data is organized in predetermined units. The stored data table is given a table ID in a format unique to the database software. For example, a data table is constructed by collecting data related to a certain device arranged in a plant. The definition unit 111 has a table ID and a 1: 1
Define an arbitrary table name in. Table creation means 1
Reference numeral 21 creates a correspondence table between the table ID and the defined table name. The correspondence table memory 131 stores the created correspondence table. The specifying means 141 specifies a table name.

The search means 151 finds a table ID corresponding to the table name designated by the designation means 141 from the corresponding table, and searches the database 101 for a data table with the found table ID. The display unit 161 displays an index screen in which a table ID is associated with an input area for inputting a table name. The input unit 171 inputs a table name into an input area on the index screen. Table creation means 1
Reference numeral 21 describes the table name input by the input means 171 in a corresponding portion of the corresponding table.

FIG. 5 is a diagram showing an example of the index screen. On the index screen, table names and table IDs are displayed in correspondence with the data tables included in the database. Information indicating the definition state of the table name is displayed on the screen. In the example of the figure, all table names are "defined". The index screen allows easy-to-understand indexes on the data table. This makes it easy to know what data tables are stored in the database.

FIG. 6 is a view showing another embodiment of the present invention. FIG. 6 shows a main configuration of the present invention. The embodiment shown in FIG. 6 is a database system in which data can be taken from an external database to a database in the system. An interface means 60 is provided between the database 50 outside the database system 1 and the database 10 in the system.

The interface means 60 is provided with a plurality of types of protocols P1 to P4. Selection means 61
Selects the protocol according to the system where the external database resides. The interface means 60 communicates with the database 50 according to the selected protocol, and takes the data of the database 50 into the database 10.

The adjusting means 62 performs adjustment when the format of the data table held by the database 50 and the format of the data table held by the database 10 are different. That is, when the format of the data table in the database 50 is different from the format of the data table in the database 10, the adjusting unit 62 associates the data in the data table of the database 50 with the data in the data table of the database 10, The data sent from the database 50 is described in the corresponding part of the data table of the database 10. Thereby, even if the format of the data table is different, the data sent from the external database is appropriately reflected in the internal database.

The adjusting means 62 includes a database 50
When data of a type that is present in the data table but not in the data table of the database 10 is sent,
Discard this data.

FIG. 7 is a diagram showing another embodiment of the present invention. FIG. 7 shows a main configuration of the present invention. In FIG. 7, the method processing means 70 performs an arithmetic operation on the raw data K1 and K2, and stores the operation results in the databases 10a and 10b. In the method processing unit 70, the storage unit 71 provides the area where the method groups 72 and 73 exist. The method group 72 is provided with methods 721 to 723 in which predetermined arithmetic expressions are defined. Similarly, a method group 73 in which a predetermined arithmetic expression is defined is also stored in the method group 73.
1,732 are prepared. Note that the number of method groups and methods may be other than the numbers shown in the figure.

The execution means 74 causes each method of the method groups 72 and 73 to perform an operation when a start signal is given from outside. Each method is based on the input raw data K1,
An operation is performed on K2 using an operation expression defined for itself. The storage means 75, 76 stores the operation result in the database 10a, 1
0b. The start signal is given at a fixed period or at an arbitrary timing.

The operation of the embodiment shown in FIG. 7 will be described. When a start signal is given, each method performs the following operation on the raw data K1. Method 721 A + B = a Method 722 C + D = b Method 723 DE-c Method 731 F + G = d Method 732 HI = e The operation results a, b, and c are stored in the database 10a,
The calculation results d and e are stored in the database 10b.

In this way, the necessary operation results are stored in the database. The method is realized by, for example, a subroutine program. The embodiment in FIG. 7 is implemented, for example, in the calculation value database 372 in FIG.

FIG. 8 is a diagram showing a configuration example of a database provided in the system of the present invention. A database is made up of database objects. Storage means 8
0 provides the area where the database object 81 exists. The database object 81 collectively stores data in predetermined units, and transfers the stored data when a message is given. In the example of the figure, the database object 81 is provided with the identifier “TIC101”, and collectively holds data on controllers that perform PID control. The stored data includes, for example, a process value, an alarm upper limit value, and an alarm lower limit value. When a message is given, the database object 81 starts its own program and transfers data such as a process value and an alarm upper limit value. In addition,
Not limited to the controller, the database object may collectively hold data on one device existing in the plant.

As described above, since the data object collectively holds data in a predetermined unit, the search becomes easier as compared with the case of searching for a database (relational database) associated with each other.

[0045]

According to the present invention, the following effects can be obtained.

According to the first aspect of the present invention, an arbitrary data name corresponding to the data ID and 1: 1 is defined, and the database can be searched using the data name as a keyword. As a result, even those who are not familiar with database software can easily grasp the contents of the database.

According to the second aspect of the present invention, even when databases operating with various database software are scattered in a plant, the contents of the database can be grasped without being conscious of the difference between these database software.

According to the third aspect of the present invention, the data name can be defined while confirming the correspondence between the data ID and the data name on the screen.

According to the fourth aspect of the present invention, when data is stored in a database in the form of a data table, even those who are not familiar with database software can easily grasp the contents of the database.

According to the fifth aspect of the present invention, the table name can be defined while confirming the correspondence between the table ID and the table name on the screen.

According to the invention of claim 6, data of an external database having a different communication protocol from that of the database system can be easily taken in.

According to the invention of claim 7, even if the formats of the data tables in the external database and the internal database are different, the data in the external database can be appropriately reflected in the internal database.

According to the invention of claim 8, data unnecessary for the internal database can not be reflected.

According to the ninth aspect of the present invention, a desired operation result can be stored in the database.

According to the tenth aspect, an operation can be executed at an appropriate timing according to the data input timing.

According to the eleventh aspect of the present invention, the data is collectively stored in the database, so that the search becomes easier as compared with the case of searching the relational database.

According to the twelfth aspect, data can be searched for each device existing in the plant.

As described above, according to the present invention, it is possible to realize a database system in which even a person who is not familiar with database software can easily grasp the contents of the database.

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing one embodiment of the present invention.

FIG. 2 is a diagram showing an example of an application system of the present invention.

FIG. 3 is a diagram showing an example of a table detail designation screen.

FIG. 4 is a configuration diagram showing another embodiment of the present invention.

FIG. 5 is a diagram showing an example of an index screen.

FIG. 6 is a view showing another embodiment of the present invention.

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

FIG. 8 is a diagram showing a configuration example of a database provided in the system of the present invention.

[Explanation of symbols]

 10, 10a, 10b, 101 Database 11, 111 Definition means 12, 121 Table creation means 13, 131 Corresponding table memory 14, 141 Designation means 15, 151 Search means 16, 161 Display means 17, 171 Input means 50 External database 60 Interface Face means 62 Adjusting means 70 Method processing means 72, 73 Method groups 721 to 723, 731, 732 Methods 81 Database object T Correspondence table G Input area

Claims (12)

[Claims] 1. A database system having a database storing data to which data IDs of a format unique to database software are stored, a definition means for defining an arbitrary data name 1: 1 with the data ID, Table creation means for creating a correspondence table of data names defined as IDs, a correspondence table memory for storing the created correspondence tables, designation means for designating data names, and data corresponding to the data names designated by the designation means I
A search unit for determining D from the correspondence table and searching the database for data with the determined data ID from the database. 2. A database system in which a plurality of databases are distributed and each database stores data to which a data ID of a format unique to each database software is stored. Definition means for defining a data name, a table creation means for creating a correspondence table between the data ID and the defined data name, a correspondence table memory for storing the created correspondence table, and a designation means for designating the data name. Data I corresponding to the data name specified by the specifying means
A search unit for determining D from the correspondence table and searching the database for data with the determined data ID from the database. 3. A display means for displaying a table detail designation screen in which the data ID is associated with an input area for inputting a data name, an input means for inputting a data name in an input area on the screen, 3. The database system according to claim 1, wherein the table creation unit describes a data name input to the input area in a corresponding portion of the correspondence table. 4. 4. A database system in which a data table in which data stored in a database is compiled in a predetermined unit is stored, and the stored data table is provided with a table ID in a format unique to database software. : 1 means for defining an arbitrary table name, table creation means for creating a table corresponding to a table ID and a defined table name, a correspondence table memory for storing the created correspondence table, and designation for designating a table name Means for determining a table ID corresponding to the table name specified by the specifying means from the correspondence table, and searching a database for a data table having the determined table ID. system. 5. A display means for displaying an index screen in which the table ID is associated with an input area for inputting a table name, and an input means for inputting a table name in an input area on the screen. 5. The database system according to claim 4, wherein said table creation means describes a table name input to said input area in a corresponding portion of said correspondence table. 6. A database system having a database in which data is stored in accordance with a predefined format is capable of communicating with a plurality of types of protocols, selecting a protocol according to the type of external database, and selecting an external database according to the selected protocol. A database system comprising an interface means for communicating with an external database and taking in data from an external database into an internal database in the system. 7. When the format of the data table in the external database is different from the format of the data table in the internal database, the data in the data table of the external database is correlated with the data in the data table of the internal database. 7. An adjusting means for describing the data sent from the server in a corresponding part of a data table of the internal database.
The described database system. 8. The apparatus according to claim 6, wherein said adjusting means discards data of a type which is present in the data table of the external database but not in the data table of the internal database. Database system. 9. A database system having a database in which data is stored in accordance with a predefined format is provided with a method in which a predetermined arithmetic expression is defined, and a method group having a predetermined number of the methods is provided. A database system comprising a method processing means for performing an operation on the input raw data by the operation expression when a start signal is given, and storing the operation result in a database. 10. The database system according to claim 9, wherein said activation signal is given at a fixed period or at an arbitrary timing. 11. The database has a structure of a database object, and the database object collectively stores data in a predetermined unit, and transfers the stored data when a message is given. Item 14. The database system according to Item 9. 12. The database system according to claim 11, wherein said database object collectively holds data on one device existing in a plant.