JPH11288404A - System for defining system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily prepare system definition information for sufficiently developing the performance of each computer, to capture a whole system from the large amount of definition information, and to easily refer to the arbitrary definition information at the time of preparing the definition information of a database system for sharing and executing the roles on plural computers. SOLUTION: An operation system(OS) information obtaining part 121 obtains performance information from an OS 11, and a storing part 122 preserves the performance information in a storage file 13. When the performance information is required from other computers 2 and 3, a fetching part 123 obtains the performance information, and transmits the performance information through a transmitting and receiving part 125. Also, a comparing part 124 compares the performance information of the OS 11 with the performance information of the storage file 13. When they are made incoincident as the result of this comparison, it is judged that the hard is exchanged, and new performance information is preserved in the storage file 13, and transmitted to the origin of request. Also, the constitution information is hierarchically displayed with an icon by a GUI, and the icon is selected so that the arbitrary definition information can be called.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a database system definition for centrally managing system definition information using a communication function of a personal computer and a graphical user interface.

[0002]

2. Description of the Related Art In a conventional system, definition contents suitable for each computer constituting a parallel system are created for each computer. As a unified management method of the system definition, there is a technique described in JP-A-4-260149 and JP-A-8-63441. JP-A-4-
No. 260149 describes a method in which definition information is created using a graphical user interface and the definition information is distributed to each computer. In this scheme,
There is a problem in that the system definition creator needs to know the performance of each computer in advance, and the number of computers cannot be understood by many systems. In addition, since the CPU and memory of the personal computer can be easily changed, it is difficult to always grasp the latest performance. On the other hand, the technology described in JP-A-8-63441 defines the ratio of server types in the entire system to one system management computer, and defines the server type of the computers connected to the system by the defined ratio. This is a method determined by the system management computer. In this method, since a large number of computers are defined as a percentage, it is not necessary to know each computer, but it is not possible to make settings in consideration of performance such as CPU processing speed and memory capacity of each computer constituting the system. There is.

In the technique described in Japanese Patent Application Laid-Open No. 4-260149, a method of creating network definition information by using a GUI is considered, but a method of creating database system definition information by using a GUI is also considered. Not.

[0004]

In a database system operating on a plurality of computers, the performance of each computer is not always the same. Generally, CPU
It is desirable that a computer having a high processing speed and a large memory capacity perform database processing with high traffic, and a computer having a low CPU processing speed and a small memory capacity perform database processing with low traffic. According to the technique described in Japanese Patent Application Laid-Open No. 4-260149, a system administrator can create system definition information, so that a system can be constructed in consideration of the performance of each computer. And computers cannot be managed by many systems. Further, since the CPU and the memory of the personal computer can be easily changed, it is difficult to always manage the latest performance. The technique described in Japanese Patent Application Laid-Open No. 8-63441 discloses a CPU processing speed of each computer,
Since the system determines the server type without considering the performance such as the memory capacity, it is not possible to construct a system that fully exploits the performance of the computer. When the parallel database system definition information to be executed by assigning a role to a plurality of computers is created by a GUI, a configuration information display method unique to the parallel database system is required. 1
There is a feature that the definition information is diffused such as one system common definition information, a plurality of computer definition information, and a plurality of server definition information for each computer. Even if a large number of computers are defined, there is a need for a display method that allows the entire system to be grasped at a glance and that allows the user to quickly find the desired definition information.

[0005] It is an object of the present invention to easily construct a system with the best performance and to always maintain optimum performance when system definition information is managed in a unified manner. Further, by using the GUI, it is possible to easily grasp the configuration of the entire system and to easily refer to arbitrary definition information from a large amount of definition information.

[0006]

The above object is achieved by the following method. Performance information such as CPU processing speed and memory capacity is stored inside the computer. When the performance information is requested from another computer, the stored performance information is transmitted using communication. For example, in the case of centralized management using a GUI, at the time of selecting a computer name constituting a system, performance information of the computer is acquired via communication, and the performance information is displayed on a GUI screen. Thus, the definition information creator can easily know the performance of the computer. The memory capacity used by the database system can be set as a standard value based on the memory capacity of the performance information. On the other hand, when centralized management is performed based on the ratio of server types, when a general computer inquires of the management computer about the server type, the general computer transmits performance information to the management computer. Thus, the management computer can determine the type of server to be assigned and the type of data to be handled based on the performance information. It is also possible to determine whether the hardware has been replaced by comparing the performance information with the previous performance information when the computer is started. When it is determined that hardware has been replaced, the latest performance information can be always maintained by transmitting new performance information to the request source.

In order to display the configuration information on the GUI,
Each of the system common definition information, computer definition information, and server definition information is represented by an icon. The display order of the icons is such that the system common definition information, which exists only once in the system, is displayed at the upper level, the computer definition information having the number of computers is displayed at the middle, and the server definition defining the role of each computer is displayed at the lower level. When each icon is selected by a method such as double-clicking a mouse, the respective definition information is displayed. As a result, the entire system can be grasped at a glance, and the desired definition information can be quickly confirmed.

[0008]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The configuration of the present invention will be described with reference to FIG.
This is an example in which one parallel database system is constructed by three computers. Each of the computers 1, 2, and 3 has an OS (Operation System).
m) 11, performance information control 12, and storage file 13. The performance information control 12 includes an OS information acquisition unit 121, a storage unit 122, an extraction unit 123, a comparison unit 124, and a transmission / reception unit 1.
Consists of 25. The storage file 13 has performance information 131. The OS information acquisition unit 121 acquires performance information such as a CPU processing speed and a memory capacity from the OS. The storage unit stores the performance information acquired from the OS in the storage file 13. The extracting unit 123 reads the performance information from the storage file 13. The comparing unit 124 compares the performance information held by the OS with the performance information 131 stored in the storage file 13. The transmission / reception unit 125 transmits and receives performance information. The flow of the present invention will be described with reference to FIG. The definition information creation computer or the computer that determines the server type requests performance information from each computer. Each computer receives a performance information request 41. It is checked 42 whether the performance information 131 has been stored in the storage file 13. Performance information 1
If 31 has already been stored, go to 45. If the performance information 131 is not stored, the performance information is acquired from the OS 43,
After saving the performance information 131 in the storage file 13, 44
To 45. At 45, the performance information 131 is read. The read performance information is transmitted 46 to the request source. Thereby, the definition information creation computer or the computer that determines the server type can know the performance information of each computer. FIG. 3 shows a flow of automatically updating performance information when hardware such as a CPU and a memory is changed. After changing the CPU and memory, the computer is turned on (51). It is started 52 from the OS. It is checked 53 whether the performance information 131 has been stored. If stored, go to 56. If not stored, the performance information is obtained from the OS 54 and the performance information is stored in the storage file 13. The performance information 131 is read 56 from the storage file 13. The performance information 131 of the OS and the stored performance information 131 are compared 57. If they match, the CPU and memory are not changed, and the process ends. If they do not match, there is a change in the CPU and memory, so the new performance information is stored 58 in the storage file 13. The stored performance information is transmitted 59 to the definition information creation computer or the computer that determines the server type. This makes it possible to automatically notify the definition information creating computer or the server type determining computer of the new performance information. FIG. 4 shows an example in which the present invention is applied to centralized management by creating GUI definition information. In this case, the definition information creator displays a screen for selecting a computer to which the server is assigned. The GUI definition control 14 requests performance information from the performance information control 12.

[0009] The extraction unit 123 of the performance information control 12 reads the performance information 131 in the storage file 13 and passes it to the GUI definition control 14. If the requested computer performance information 131 does not exist in the storage file 13, the transmission / reception unit 1
25 to request the performance information of the corresponding computer. The GUI definition control 14 edits the received performance information and displays it on the screen 15. The definition information creator selects an appropriate computer as a server on the screen 15. The GUI definition control 14 stores the selected computer in the definition file 16 as a server. This allows the definition information creator to select a computer in consideration of server traffic. In the example of FIG. 4, the CPU speed and the memory capacity of the computers 1 and 2 are 2
00 MHz, 100 MB, CP of computer 3
It can be seen from the screen 15 that the U speed and the memory capacity are 100 MHz and 50 MB. The definition information creator may allocate the computer 1 or 2 to the server with high traffic and the computer 3 to the server with low traffic. Next, FIG. 5 shows an example in which the present invention is applied to centralized management based on the ratio of server types. Before the ratio definition control 17 determines the server type based on the ratio, it requests performance information from the performance information control 12. The extraction unit 123 of the performance information control 12 reads the performance information 131 in the storage file 13 and passes it to the GUI definition control 14. If the requested computer performance information 131 does not exist in the storage file 13, the transmission / reception unit 125 is used to request the performance information of the corresponding computer. The ratio definition control 17 determines a server type according to the server determination condition 18 based on the received performance information. Thus, the server type that meets the performance of the computer can be determined instead of simply determining the server type based on the ratio alone. In the example of FIG. 5, the conditions are set such that a server with high traffic is allocated when the CPU speed and the memory capacity are equal to or higher than the average, and a server with low traffic is allocated when the CPU speed and the memory capacity are lower than the average. In this case, computer 1,
The computer 2 allocates a server with high traffic because the CPU speed and the memory capacity are above average. The computer 3 allocates a server with low traffic because the CPU speed and the memory capacity are less than the average.

FIG. 6 shows a method of displaying system configuration information. The configuration information display screen 6 is the content displayed on the display device, and can be scrolled up and down. The feature of the parallel database system is that one system common definition information, a plurality of computer definition information, and a role (server) are assigned to each computer. Therefore, the system name, the computer name, and the server name are displayed in a hierarchy so that the configuration can be easily grasped. The icon 61 of the system common definition information and the system name, which exist only in one system, are displayed at the upper level of the hierarchy. The computer definition information icon 62 and the computer name are displayed at the middle of the hierarchy. The server definition information icons 63, 64, and 65 and the server name are displayed below. The server changes the icon depending on the service role and displays it. If there are a plurality of computers 62 and a plurality of servers 63, 64, 65, they are displayed in order of name. In the example of FIG. 6, the system name is SYS01,
Computer names COM01, COM02, COM03
COM01 has servers BAC01 and DI
There are C01 and FRN01. COM02 has a server BA
There are C02 and FRN02, and COM03 has server BA
There is C03. As described above, the system configuration can be grasped at a glance. In addition, by selecting an icon with a pointing device such as a mouse, the definition information corresponding to the selected icon is displayed. In the example of FIG. 6, the server FR
When N01 is selected, the definition information 66 of the server FRN01 is displayed. Thus, the user can immediately refer to and update the definition information to be viewed.

[0011]

As described above, according to the present invention, the performances of a plurality of computers on a database system can be easily known. Further, when the performance of the computer is changed due to hardware replacement, it is possible to automatically acquire the latest performance. Therefore, since the server can be determined in consideration of the computer performance, it is possible to easily construct and maintain a system that maximizes the computer performance. Also, by combining with a GUI, it is possible to solve the difficulty of managing the system configuration peculiar to the parallel database.

[Brief description of the drawings]

FIG. 1 is a configuration diagram illustrating an embodiment of the present invention.

FIG. 2 is a flowchart for acquiring performance information.

FIG. 3 is a flowchart for updating performance information.

FIG. 4 is a diagram showing an example of application to definition information creation by a GUI according to an embodiment of the present invention.

FIG. 5 is a diagram illustrating an example of application to unified management based on a ratio according to an embodiment of the present invention.

FIG. 6 is a diagram illustrating a configuration information display example by a GUI according to the embodiment of the present invention.

[Explanation of symbols]

 1,2,3 Computer. DESCRIPTION OF SYMBOLS 11 Operation system 12 Performance information control 13 File which stores performance information 14 Definition information control using GUI 15 Screen displayed on display device 16 Definition information storage file using GUI 17 Control server type by ratio 18 Determine server For displaying 61-65 Icons displayed on GUI

Claims (4)

[Claims] When creating system definition information in a database system operating on one or a plurality of computers, performance information of a computer to be system-defined is obtained through communication, and the performance information is stored in the system. A database system definition method that builds a high-performance database system by reflecting it in definition information. 2. A database system definition method according to claim 1, wherein the latest performance information is always obtained by reacquiring the performance information at the time of starting the computer. 3. In the database system, when system configuration information is displayed on a graphical user interface (GUI), system common definition information, computer definition information, and server definition information are displayed as icons, respectively, and the icons are displayed on the system common basis. A database system definition method characterized by displaying hierarchically in the order of definition information, computer definition information, and server definition information. 4. The database system definition system according to claim 3, wherein a large amount of definition information is called from a large amount of definition information by selecting a definition information icon.