JP2005267193A - Database diagnosis system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To diagnose a database in a short and simple operation. <P>SOLUTION: Webpage presenting means 210 present an input page on a Web browser on a terminal device 100 to ask a database administrator to input a DBMS type, an OS type, an administrator username, a password and DB identification information used in a server 10 to be diagnosed. Script storing means 280 prepare diagnostic scripts suited to diagnose specific servers using specific types of DBMSs and OSs respectively. A diagnostic script suited to the server to be diagnosed is selected correspondingly, and executed by diagnosis executing means 220. When diagnosis result receiving means 230 receive diagnosis results, webpage presenting means 240 present them as a webpage on the screen of the terminal device 100. The diagnosis results are stored as XML data in diagnosis result storing means 290. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a database diagnosis system, and more particularly to a database diagnosis system that can perform diagnosis online via a network.

  Database systems are widely used as devices that process various business data using a computer. A database system is usually constructed by installing a database server on a network and accessing the database server from a large number of client computers. Therefore, as the amount of data to be handled as a database increases, the burden on the database server increases as the number of client computers connected via the network increases.

  In recent years, the Internet has come to function as a social backbone system, and there are many database servers that need to simultaneously accept access from a large number of client computers via the Internet. In the unlikely event that such a server goes down due to a high load, the social impact cannot be ignored. Under such circumstances, it is important to objectively measure the performance of the database server, and the database server performance is regularly measured and diagnosed using a database diagnosis system.

  A general method for measuring server performance is performed by a method of giving various processing requests to a server and measuring the response speed and throughput of the server for the processing. For example, the following Patent Document 1 discloses a method for measuring a server performance by calculating a response time from a difference between a time when a processing request is transmitted to the server and a reception time of response data for the processing request. Yes. Patent Document 2 below discloses a technique for measuring the performance of a server by performing emulation evaluation of the relationship between the number of simultaneous processes, throughput, and response time in a situation where no waiting time is generated.

In the case of a general database server, diagnosis is usually performed by giving a predetermined diagnosis script described as an SQL (Structured Query Language) statement and receiving a processing result corresponding thereto. SQL is a database query language that has become a standard by ISO, and many database servers currently available on the market support it.
JP-A-10-143401 Japanese Patent No. 2923874

  As described above, the diagnosis for the database server is usually executed by providing a diagnosis script written in SQL, but there is a dialect based on an extension standard unique to each company. For this reason, different SQL statements must be prepared depending on the type of DBMS (DataBase Management System) employed by each database server and the type of OS that is the backbone of the server.

  For this reason, conventionally, a diagnosis contractor who undertakes diagnosis consults with the database server administrator in advance, asks various information necessary for diagnosis such as the type of DBMS, and based on these information, the database It was necessary to create a diagnostic script for the server. Thus, when the diagnostic script is prepared, it is given to the database server and executed, the execution result is collected, processed into a predetermined diagnostic result format, and presented to the database server administrator. Will be stepped on. When diagnosis is performed according to such a conventional procedure, a long period of several days to several weeks is required until a diagnosis result is finally obtained, and the work load of the diagnosis contractor increases.

  Therefore, an object of the present invention is to provide a database diagnosis system that can perform a diagnosis on a database server in a shorter period of time and with a simpler work.

(1) According to a first aspect of the present invention, there is provided a database diagnosis system for diagnosing performance of a database server by giving a diagnosis script to the database server to be diagnosed and executing the script. A system main body connectable to a database server to be diagnosed via a network, and a terminal device connectable to the system main body via a network,
The terminal device is composed of a computer in which a web browser program is incorporated, and the web browser program is used to input information necessary for diagnosis and display processing of diagnostic results.
In the system body,
An input web page presenting means for presenting an input web page for inputting information necessary for diagnosis to the terminal device;
Based on the operation of the terminal device operator on the input Web page, the type of DBMS used for the database server to be diagnosed, the type of OS used for the database server to be diagnosed, and the diagnosis target A diagnosis target designation information input means for inputting, as diagnosis target designation information, a management user name and password for the database server to be specified, DB identification information for specifying the database server to be diagnosed,
Diagnostic scripts suitable for diagnosing a specific type of DBMS and a specific database server using a specific type of OS are stored for each combination of a plurality of types of DBMS and a plurality of types of OS. Script storage means,
Script selection means for selecting a specific diagnosis script corresponding to the combination of the DBMS and the OS based on the type of DBMS and the type of OS included in the diagnosis target designation information;
The selected diagnosis script is given to the database server to be diagnosed specified by the DB identification information included in the diagnosis target designation information together with the management user name and password included in the diagnosis target designation information. Diagnostic execution means for executing
A diagnostic result receiving means for receiving diagnostic result information indicating an execution result of the diagnostic script from the database server to be diagnosed;
A result display web page presenting means for presenting the received diagnosis result information as a result display web page to the terminal device;
Is provided.

(2) According to a second aspect of the present invention, in the database diagnosis system according to the first aspect described above,
Format conversion means for converting the received diagnosis result information into data described in a predetermined format;
Diagnostic result storage means for storing the converted data;
Is further provided.

(3) According to a third aspect of the present invention, in the database diagnosis system according to the second aspect described above,
The format conversion means has a function of converting the diagnosis result information received in the text data format into data described in the XML format.

(4) According to a fourth aspect of the present invention, in the database diagnosis system according to the second or third aspect described above,
The format conversion means has a function of adding information indicating the type of DBMS, information indicating the type of OS, and DB identification information as bibliographic information to the received diagnosis result information, for the database server to be diagnosed,
The diagnostic result storage means has a function of storing diagnostic result information with the bibliographic information added.

(5) According to a fifth aspect of the present invention, in the database diagnosis system according to the first to fourth aspects described above,
The DBMS type is specified by the DBMS name and its version.

(6) According to a sixth aspect of the present invention, in the database diagnosis system according to the first to fifth aspects described above,
The DB specifying information is configured by the IP address of the database server to be diagnosed and the name of the database to be diagnosed.

(7) According to a seventh aspect of the present invention, in the database diagnosis system according to the first to sixth aspects described above,
The result display Web page presenting means has a function of converting diagnosis result information into an HTML format based on a style sheet indicating a display format on the Web page.

  (8) According to an eighth aspect of the present invention, a system main body constituting the database diagnosis system according to the first to seventh aspects described above can be independently provided.

  (9) According to a ninth aspect of the present invention, a program for causing a computer to function is prepared as a system main body constituting the database diagnosis system according to the first to seventh aspects described above, and the program can be read by the computer It can be recorded and distributed on a simple recording medium.

  As described above, according to the database diagnosis system of the present invention, the operator who executes the diagnosis performs the diagnosis for the database server only by inputting the necessary information on the Web page displayed on the terminal device. Is automatically executed, and the result is immediately displayed on the Web page, so that the database server can be diagnosed in a short time and with simple work.

  Hereinafter, the present invention will be described based on the illustrated embodiments. FIG. 1 is a block diagram showing a basic configuration of a database diagnosis system according to an embodiment of the present invention. This database diagnosis system is a system having a function of diagnosing the database servers 10 and 20, and includes a terminal device 100 and a system main body 200. As shown in the figure, the database servers 10 and 20, the terminal device 100, and the system main body 200 are all connected to the network 300, and can access each other via the network 300 if necessary. Although a local network such as an in-house LAN can be used as the network 300, the Internet is used as the network 300 in this embodiment.

  Here, for convenience of illustration, a state in which one terminal device 100 and two database servers 10 and 20 are connected to the network 300 is shown, but in practice, a larger number of terminal devices. In general, the present invention is implemented in an environment in which a database server is connected to the network 300. In particular, when the Internet is used as the network 300, any database server connected to the Internet can be a diagnosis target server, and any terminal device connected to the Internet can be used as the database diagnosis according to the present invention. It can be used as a terminal device for the system.

  The database diagnosis system according to the present invention is configured by a combination of the terminal device 100 and the system main body 200. By giving a diagnosis script to the database servers 10 and 20 to be diagnosed and executing the script, It has a function to diagnose performance of the database server. Here, the system main body 200 is in a state in which it can be connected to the database servers 10 and 20 to be diagnosed via the network 300, and the terminal device 100 is in a state in which it can be connected to the system main body 200 via the network 300. It has become.

  The terminal device 100 used in the present invention is composed of a computer in which a Web browser program is incorporated. By using this Web browser program, input work of information necessary for diagnosis and display processing of diagnosis results are performed. Many general-purpose personal computers currently on the market incorporate a Web browser program as an environment for connecting to the Internet. Therefore, in practice, it is sufficient to use a personal computer in which a Web browser program is incorporated as the terminal device 100. However, the terminal device 100 is not necessarily configured by a personal computer, and may be a mobile phone or a PDA device as long as the device functions as a computer in which a Web browser program is incorporated. However, as will be described later, since the operator needs to input information necessary for diagnosis from the terminal device 100, it is preferable in practice to use a personal computer that allows easy input.

  On the other hand, the system main body 200 is a component constituting the main part of the database diagnosis system according to the present invention. As shown in the figure, the input Web page presentation means 210, the diagnosis execution means 220, the diagnosis result receiving means 230, and the result display The web page presentation unit 240, the diagnosis target designation information input unit 250, the script selection unit 260, the format conversion unit 270, the script storage unit 280, and the diagnosis result storage unit 290 are included. Hereinafter, the functions of these means will be described in order.

  First, the input Web page presentation unit 210 has a function of presenting an input Web page for inputting information necessary for diagnosis to the terminal device 100 via the network 300. Actually, since the input Web page is transmitted to the terminal device 100 as HTML data, the input Web page presenting means 210 distributes HTML data for displaying the input Web page. It will be configured by the server.

  On the other hand, the diagnosis target designation information input unit 250 inputs diagnosis target designation information necessary for performing a diagnosis on the database server to be diagnosed based on an operation on the input Web page by the operator of the terminal device 100. It is a component with the function to do. Specific contents of the diagnosis target designation information will be described later. Eventually, the diagnosis target designation information input unit 250 performs a process of fetching the diagnosis target designation information input from the terminal device 100 in cooperation with the input Web page presentation unit 210 functioning as a Web server. As described above, a mechanism for capturing information input on a Web page as data and displaying it on the Web page can be realized using a known technique such as CGI (Common Gateway Interface). Detailed description is omitted here.

  The script storage unit 280 is a combination of a plurality of types of DBMSs and a plurality of types of OSs, which is a diagnostic script suitable for diagnosing a specific database server using a specific type of DBMS and a specific type of OS. Each component is a stored component. As already described, diagnosis for a database server is usually executed by providing a diagnosis script written in SQL. Since there is a dialect according to each company's extension standard in SQL, each database server Different SQL statements must be prepared depending on the type of DBMS (DataBase Management System) and the type of OS that is the backbone of the server. The main point of the present invention is that a diagnosis script is prepared in advance for each combination of a plurality of types of DBMSs and a plurality of types of OSs, and a database server to be diagnosed adopts when actually performing a diagnosis. The diagnostic script corresponding to the combination of DBMS and OS is selected and used.

  FIG. 2 is a list of combinations of a plurality of types of DBMSs and a plurality of types of OSs. Here, for convenience, a combination of a specific type of DBMS and a specific type of OS is referred to as a “category”. In FIG. 2, a total of 10 categories are defined, and category IDs C111 to C120 (unique identifiers for distinguishing each category from each other) are assigned to each category. Currently, Oracle's Oracle (registered trademark), Microsoft's SQL Server (registered trademark), Sybase's Adaptive Server (registered trademark), etc. are used as the main DBMS. Servers that run these DBMSs As the operating system, UNIX (registered trademark), Windows (registered trademark) NT / 2000, NetWare (registered trademark), and the like are used. However, here, for convenience of explanation, as shown in the figure, three DBMSs “XXX”, “YYY”, “ZZZ”, and 3 “OS-A”, “OS-B”, “OS-C”. The following explanation will be given for a case where a street OS is mainly used.

  For example, in FIG. 2, the category identified by the category ID “C111” includes a specific type of DBMS “DBMS version 1.0 named XXX” and a specific type of OS “OS-A”. Shows the combination. In this embodiment, as shown in the figure, the type of DBMS is specified by the DBMS name and its version. For example, the categories C111 and C112 are all related to the DBMS having the same name “XXX”. However, since the versions are different, the types of DBMS are different from each other.

  Even if the DBMS name and its version are the same, if the OS type is different, it is classified into different categories. For example, the categories C119 and C120 are both related to the DBMS having the same name “ZZZ” and the same version “6.5” (in other words, the types of DBMS are completely the same). The OS type is classified into different categories because one is “OS-B” and the other is different from “OS-C”.

  Of course, this category need not be defined for all combinations that are mathematically possible, and need not be defined for combinations that do not actually exist. For example, a DBMS “ZZZ” is always used in an environment of “OS-B” or “OS-C”, and never used in an environment of “OS-A”. It is not necessary to define a category related to the combination of the DBMS “ZZZ” and the OS “OS-A”. Conversely, when a new DBMS is announced or a new version of the DBMS is released, new category definitions are sequentially added.

  In the illustrated embodiment, the type of OS is not distinguished by version. However, in the case of a database server that is currently generally used, this is because the DBMS name and its version, the OS name, This is because the same diagnostic script can be used even if the OS version changes. Of course, if necessary, the OS type may be specified by the OS name and its version.

  In order to construct the database diagnosis system according to the present invention, it is necessary to prepare a diagnosis script as a data file for each category defined by the table of FIG. The diagnostic script file name shown in the rightmost column of the table of FIG. 2 indicates the file name of the diagnostic script prepared in this way. A diagnosis script file for diagnosing a database server is usually composed of data in which SQL (Structured Query Language) statements are listed.

  FIG. 3 is a schematic diagram showing the contents of the diagnostic script file S111 prepared corresponding to the category C111 shown in FIG. As shown in the figure, this file S111 is a file in which a total of N SQL sentences are enumerated from the first SQL sentence to the Nth SQL sentence. These SQL statements constitute a diagnosis script suitable for diagnosis of the database server corresponding to category C111. In other words, as indicated in the column of category C111 in the table of FIG. 2, a specific type of DBMS “version 1.0 of DBMS named XXX” is changed to a specific type of OS “OS-A”. A file including a total of N SQL statements suitable for diagnosing a specific database server operating in the environment is a diagnostic script file S111.

  In the embodiment shown here, a total of 10 categories C111 to C120 are defined as shown in FIG. 2, and thus a total of 10 diagnostic script files S111 to S120 are prepared corresponding to these categories. It is necessary to keep it. The ten diagnostic script files S111 to S120 prepared in this way are stored in the script storage means 280 shown in FIG. The ten diagnostic script files S111 to S120 are files in which SQL statements suitable for performing diagnosis on a specific database server belonging to a specific category are listed. The work to create requires a great amount of labor, but once the creation work is completed, it can be repeatedly used as necessary by storing it in the script storage means 280.

  The contents of a plurality of (10 in the embodiment described here) diagnosis scripts stored in the script storage unit 280 in the database diagnosis system shown in FIG. 1 have been described above. As described above, the diagnostic target designation information input unit 250 has a function of inputting diagnostic target designation information based on an operation by the operator of the terminal device 100. The role of the diagnostic target designation information input here is as follows. One of them is to provide a reference for selecting a script suitable for a diagnosis target from a plurality of types of diagnosis scripts stored in the script storage unit 280.

  In the present invention, the diagnosis target designation information input by the diagnosis target designation information input means 250 is roughly divided into four pieces of information as shown in FIG. The first information is information indicating the type of DBMS used in the database server to be diagnosed. In the embodiment shown here, the DBMS name “XXX”, “YYY” or “ZZZ” and its This is information indicating the version. The second information is information indicating the type of OS used in the database server to be diagnosed. In the embodiment shown here, “OS-A”, “OS-B”, or “OS-C”. It will be information indicating any of "." The third information is the management user name and password for the database server to be diagnosed, and is required when the diagnosis script is executed on the database server to be diagnosed. The fourth information is DB identification information for specifying a database server to be diagnosed. In the case of the embodiment shown here, the DB specifying information as the fourth information includes the IP address of the database server to be diagnosed and the name of the database to be diagnosed (more specifically, the instance name and database name). Is used.

  As described above, the diagnostic target designation information input unit 250 has a function of inputting the four pieces of information shown in FIG. 4 as diagnostic target designation information. Is performed on the Web page displayed on the terminal device 100. Therefore, the input Web page presented by the input Web page presenting means 210 is provided with an input field suitable for inputting the four pieces of information shown in FIG. The operator of the terminal device 100 can perform an operation of inputting predetermined information in this input field by operating a keyboard and a mouse.

  The four pieces of information shown in FIG. 4 are all indispensable information when making a diagnosis on a specific database server. Conventionally, from the administrator of the database server to be diagnosed, It is information that has been communicated verbally or in writing. In the diagnosis system according to the present invention, such information is directly input on the Web page displayed on the terminal device 100 by the administrator of the database server to be diagnosed.

  For example, let us consider a case where the administrator A who has access rights to the database server 10 executes diagnosis for the server 10 with the management user name “admin” and the password “banana”. In this case, the administrator A may first access the input Web page presenting means 210 from the terminal device 100 via the network 300. Specifically, since the input web page presenting means 210 is constituted by a web server for presenting the input web page, the administrator A activates the web browser of the terminal device 100 to perform the input. What is necessary is just to access the URL address of the Web page presentation means 210. As a result, on the screen of the terminal device 100, an input Web page for inputting diagnosis target designation information including four pieces of information shown in FIG. 4 is displayed.

  Here, for convenience of explanation, the database server 10 to be diagnosed uses a specific type of DBMS “XXX version 1.0” in an environment of a specific type of OS “OS-A” (ie, a server (ie, “OS-A”)). , A server classified into category C111 in the table of FIG. In this case, the administrator A inputs information indicating the DBMS type such as the DBMS name “XXX” and its version “1.0” as the first information constituting the diagnosis target designation information. Further, as the second information, information indicating the OS type “OS-A” is input, and as the third information, information including the management user name “admin” and the password “banana” is input. . Further, as the fourth information, as the DB identification information for specifying the database server 10, the IP address of the database server 10 and the instance name and database name of the database operating there are input.

  When the diagnosis target designation information input means 250 inputs the diagnosis target designation information consisting of these four pieces of information, the diagnosis target designation information input means 250 gives the first information and the second information to the script selection means 260, and the third information and the fourth information are given. This is given to the diagnosis execution means 220.

  The script selection unit 260 corresponds to the combination of the DBMS and the OS based on the information indicating the DBMS type (first information) and the OS type (second information) included in the diagnosis target designation information. It has a function of selecting a specific diagnostic script from the script storage means 280. In the case of the above-described example, information “XXX version 1.0” is given as information indicating the type of DBMS, and information “OS-A” is given as information indicating the type of OS. The selection unit 260 performs a process of selecting the diagnostic script file S111 corresponding to the category C111 from the ten types of diagnostic script files S111 to S120 stored in the script storage unit 280. The script selection unit 260 has a function of reading the diagnosis script file S111 selected in this way from the script storage unit 280 and giving it to the diagnosis execution unit 220.

  The diagnosis execution unit 220 includes the diagnosis target designation information selected by the script selection unit 260 together with the management user name and password included in the diagnosis target designation information input by the diagnosis target designation information input unit 250. Is provided to a database server to be diagnosed specified by the DB identification information included in the database identification information and executed. In the case of the above example, the diagnosis script file S111 is selected by the script selection means 260. Therefore, the diagnosis execution means 220 can execute the diagnosis script described as an SQL statement in the diagnosis script file S111. Is given to the database server 10 to be diagnosed, and processing for executing this is performed.

  However, in order for the database server 10 to execute a predetermined diagnostic script, it is necessary to access the database server 10 with administrator authority. Therefore, the diagnosis execution unit 220 performs processing for transmitting the information of the management user name “admin” and the password “banana” input by the diagnosis target designation information input unit 250 to the database server 10 together with the diagnosis script file S111. . Further, in order to physically access the database server 10 via the network 300, the IP address of the database server 10 is required, and in order to physically access the database in the server 10, the database The diagnosis execution means 220 can recognize the IP address of the database server 10 and the diagnosis target database name from the DB identification information input by the diagnosis target designation information input means 250. The diagnosis object can be physically accessed using the identification information.

  FIG. 5 is a block diagram showing data used when the diagnosis execution means 220 executes diagnosis processing for the database server 10. As shown in the figure, the data necessary for the diagnosis execution is a diagnosis script file S111, a management user name and password, and DB identification information. Here, the diagnosis script file S111 is a file selected from the script storage unit 280 by the script selection unit 260, but the management user name, password, and DB identification information are input by the diagnosis target designation information input unit 250. The information included in the diagnosis target designation information.

  As described above, the processing procedure in the case of performing the diagnosis on the database server 10 has been described as an example, but the diagnosis on the database server 20 is also executed in the same procedure. Of course, if the DBMS or OS used in the database server 20 is different from the one used in the database server 10, the script selection means 260 creates a diagnostic script file belonging to a category different from the above specific example. Will be selected. If the administrator of the database server 20 is another administrator B, naturally, the administrator user name and password are input for the administrator B.

  Thus, when a diagnosis script is given to the database server 10 from the diagnosis execution means 220, the script is executed on the database server 10, and diagnosis result information indicating the execution result is returned to the system main body 200. . As shown in FIG. 3, the substance of the diagnostic script file is a plurality of SQL statements, and information indicating the execution results for the individual SQL statements is returned to the system main body 200 as diagnostic result information having a predetermined format. Will be.

  The diagnosis result receiving means 230 is a component having a function of receiving diagnosis result information returned from the database server to be diagnosed in this way. The format of the diagnosis result information varies depending on the type of DBMS that returns the diagnosis result information. In the case of a general DBMS, the format is a text data format file.

  FIG. 6 is a diagram showing a configuration example of diagnosis result information returned in the text data format. In this example, the diagnosis result (execution result of each SQL statement) for each SQL statement is indicated by the heading “Table”. For example, the part starting from the heading “□ Table 1 □” shown in the figure indicates the diagnosis result for the first SQL sentence, and the part starting from the heading “□ Table 2 □” is for the second SQL sentence. It shows the diagnosis result. In this example, the first SQL statement is a script that requests execution results for three items. As the execution result for item 1, three values of value 1, value 2, and value 3 are returned. As an execution result for item 2, two values of value 1 and value 2 are returned, and as an execution result for item 3, two values of value 1 and value 2 are returned. Yes. On the other hand, the second SQL statement is a script that requests execution results for two items that are related to each other. As the execution results for item 1 and item 2, a pair of “value 11, value 21” is obtained. , A pair of “value 12, value 22” and a pair of “value 13, value 23” are returned.

  The result display Web page presentation unit 240 is a component having a function of presenting the diagnosis result information received by the diagnosis result receiving unit 230 to the terminal device 100 as a result display Web page. For example, when diagnosis result information as shown in FIG. 6 is obtained, such information is presented as a Web page on the screen of the terminal device 100. In order to present information as a Web page on the screen of the terminal device 100, it is necessary to transmit the information to the terminal device 100 as HTML format data. The result display Web page presentation unit 240 stores style sheet information indicating the display format on the Web page, and has a function of converting the diagnosis result information into an HTML format based on the style sheet. doing.

  For example, in the case of converting the diagnosis result information in the text data format as shown in FIG. 6 into the HTML format, a heading portion such as “□ Table 1 □”, an item portion such as “item 1”, “value 1”, and the like. Prepare a style sheet that defines the value part in which color of what size character and the background part color, and text data based on this style sheet. It is only necessary to execute processing for inserting an HTML tag into each part of the above. Since the process of converting text data into HTML data using such a style sheet is already a known process, a detailed description thereof is omitted here.

  In the case of the embodiment shown in FIG. 1, instead of directly converting the text data received by the diagnosis result receiving unit 230 into HTML format data by the result display Web page presentation unit 240, the format conversion unit 270 once converts the XML data. A method is adopted in which the data is converted into data in the format and converted into HTML format data by the result display Web page presentation unit 240. The reason is that in the example shown in FIG. 1, all the diagnosis result information received by the diagnosis result receiving unit 230 is converted into the XML format and stored in the diagnosis result storing unit 290.

  The format conversion unit 270 is a component having a function of converting the diagnosis result information received by the diagnosis result receiving unit 230 into data described in a predetermined format, and the diagnosis result storage unit 290 includes: It is a component having a function of storing the data thus converted. In the example shown here, the format conversion means 270 has a function of converting the diagnosis result information received in the text data format into data described in the XML format. As described above, the format of the diagnosis result information returned from each database server varies depending on the type of DBMS. The format conversion unit 270 converts the format into a common format, and stores it in the diagnosis result storage unit 290. By doing so, since the diagnosis result information accumulated in the diagnosis result storage means 290 is information described in a common format independent of the type of DBMS, convenience in using this later is improved. To do.

  In the example shown here, the XML format is adopted as a common format. In the XML format data, the user can define and use a unique tag, so that there is an advantage that convenience in searching is improved. FIG. 7 is a diagram showing an example in which the diagnosis result information given as the text data shown in FIG. 6 is converted into XML format data. In the text data shown in FIG. 6, the content portion led to the heading “□ Table 1 □” is sandwiched between the tag <Table 1> and the tag </ Table 1> in the XML data shown in FIG. It is described in the state. In addition, in the XML data shown in FIG. 7, each item and its value are sandwiched with a value corresponding to the item between tags indicating each item name, such as <item 1> value 1 </ item 1>. Described in form. In the XML data in the format as shown in FIG. 7, each table name or item name is defined as tag information having a predetermined meaning, so that convenience such as search processing is improved.

  In order to convert the diagnosis result information described as text data as shown in FIG. 6 into XML data as shown in FIG. 7, the format of the diagnosis result information shown in FIG. 6 is recognized in advance. There is a need. For example, in the example shown in FIG. 6, if the rule that the part between “□” indicates the heading part of each table is recognized, “□ Table 1 □” and “□ Table 2 □” It can be seen that a conversion process of sandwiching a content portion existing between the tags <Table 1> and </ Table 1> may be performed. Since the format of the diagnosis result information varies depending on the type of DBMS, if the format conversion means 270 has a conversion processing program based on a predetermined algorithm for each category shown in FIG. Good.

  In the embodiment shown in FIG. 1, the XML-format diagnostic result information obtained by the conversion process by the format converting unit 270 is stored in the diagnostic result storing unit 290 and also given to the result display Web page presenting unit 240. . The result display Web page presentation unit 240 creates a result display Web page data in HTML format by applying a predetermined style sheet to the diagnosis result information in XML format, and transmits this to the terminal device 100. It has a function to do.

  Eventually, if the database diagnosis system according to the present invention is used, the administrator A can execute diagnosis processing for the database server 10 by the following procedure. First, the Web browser of the terminal device 100 is activated, and the URL of the Web server that functions as the input Web page presentation unit 210 is accessed. Then, since a predetermined input Web page is presented on the screen of the terminal device 100, an operation for inputting diagnosis target designation information as shown in FIG. 4 is performed on this Web page. Then, the diagnosis execution means 220 gives a predetermined diagnosis script to the database server 10 and executes diagnosis based on this diagnosis target designation information. The diagnosis result information obtained as a result is stored in the diagnosis result storage means 290 in the form of XML data, and transmitted from the result display Web page presentation means 240 to the terminal device 100 in the form of HTML data. The diagnosis result information transmitted in this way is eventually browsed by the Web browser of the terminal device 100.

  In this way, from the viewpoint of the administrator, when the operation for inputting the diagnosis target designation information is performed on the predetermined input Web page using the Web browser of the terminal device 100, the system body 200 automatically performs the diagnosis process. The result is displayed on the terminal device 100 as a result display Web page. Of course, the time from when an input operation is performed on the input web page until the diagnosis result information is displayed on the result display web page varies depending on the contents of the diagnostic script and the performance of the server. Specifically, the time is on the order of several tens of seconds to several minutes. Therefore, it is possible to make a diagnosis for the database server in a very short time and by a very simple operation as compared with the conventional diagnosis method.

  In the embodiment shown here, bibliographic information is added when diagnostic result information is stored in the diagnostic result storage means 290. FIG. 8 is a diagram illustrating an example of diagnosis result information to which the bibliographic information is added. The portion surrounded by a rectangle in FIG. 8 is a diagnostic result information main body. In this portion, for example, a main body of diagnostic result information described in XML format as shown in FIG. 7 is arranged. On the other hand, the portion described above the rectangle in FIG. 8 is newly added bibliographic information. In the illustrated example, this bibliographic information portion is also described in XML format, and the entire diagnosis result information shown in FIG. 8 is XML data.

  The tag <diagnosis result> on the first line in FIG. 8 corresponds to the tag </ diagnosis result> on the last line, and information between the pair of corresponding tags is information "diagnosis result". It shows that there is.

  In the second line of FIG. 8, a numerical value “365” is described surrounded by <counter> tags. This numerical value indicates the counter value (serial number value) of the diagnosis result information. Yes. This counter value is a value that is updated by one each time the diagnosis result information is stored in the diagnosis result storage means 290. The diagnosis result information shown in FIG. 8 is the 365th stored in the diagnosis result storage means 290. This is the second diagnosis result information. When new diagnostic result information is stored in the diagnostic result storage unit 290, a value obtained by adding 1 to the counter value of the diagnostic result information stored immediately before (366 in the above example) is used as the new diagnostic result information. It is given as a counter value of diagnosis result information.

  On the other hand, in the third line of FIG. 8, a numerical value “15” is described surrounded by <database ID> tags. This numerical value is based on the same type of DBMS and the same type of DB identification information. This is an ID given by attaching the same ID to the executed diagnosis result. For example, in the case of the above-described example, the diagnosis for the database server 10 uses a specific type of DBMS “XXX version 1.0” and a specific type of DB identification information “database in the database server 10”. Will be executed. In this case, the obtained diagnosis result information includes a predetermined combination of a specific type of DBMS “XXX version 1.0” and a specific type of DB identification information “database in the database server 10”. The database ID is assigned. If even one of the combination elements is different, a different database ID is assigned.

  Therefore, in this embodiment, when new diagnostic result information is stored in the diagnostic result storage means 290, past diagnostic result information executed based on the combination of the same type of DBMS and the same type of DB identification information. Is executed to check whether it has already been stored. And in the past, when diagnosis result information by the same combination has been stored, the same database ID as the past diagnosis result information is given to the diagnosis result information to be newly stored, If diagnostic result information based on the same combination is not stored, a new database ID is issued and assigned to the new diagnostic result information to be stored. Such a database ID is convenient to use when searching for a diagnosis result performed in the past with respect to a specific database server.

  In the 4th to 9th lines in FIG. 8, data surrounded by the <metadata> tag is described, and the tags <DBMS name>, <version>, <DB identification information>, and <script execution time> are used. The enclosed data is listed. Here, the data described together with the tags <DBMS name>, <version>, and <DB identification information> are the DBMS name, version, and data input by the diagnosis target designation information input means 250 when executing the diagnosis. The data described with the tag <script execution time>, which is DB identification information, is literally information indicating the time when the diagnosis was executed. In this way, if bibliographic information related to the diagnosis performed is added as “metadata” in the XML format, it is convenient when performing various search processes.

  Such a bibliographic information addition process may be executed by the format conversion means 270. That is, the format conversion unit 270 includes the information indicating the type of DBMS, the information indicating the type of OS, and the DB identification information in the diagnosis result information received by the diagnosis result receiving unit 230 as the bibliographic information. As shown in the example of FIG. 8, the diagnosis result information with the bibliographic information added can be stored in the diagnosis result storage means 290 for convenience such as search. Can be planned.

  Although the database diagnosis system according to the present invention has been described based on the embodiment shown in the block diagram of FIG. 1, each means described as an individual block in this block diagram is actually assigned to a computer. It is a component realized by incorporating a program. Therefore, the illustrated system main body 200 is constructed by incorporating a program for functioning as each means 210 to 290 in a general-purpose computer connected to the network 300, and the program is recorded in a computer-readable recording medium. It is possible to record and distribute on a medium.

It is a block diagram which shows the basic composition of the database diagnostic system which concerns on one Embodiment of this invention. It is a figure which shows an example of the list of the combination of multiple types of DBMS and multiple types of OS. It is a schematic diagram which shows the content of the script file for diagnosis S111 prepared corresponding to the category C111 shown in FIG. It is a block diagram which shows the specific content of the diagnostic object designation | designated information input by the diagnostic object designation | designated information input means 250 shown in FIG. It is a block diagram which shows the data used when the diagnostic execution means 220 performs the diagnostic process with respect to the database server 10. FIG. It is a figure which shows the structural example of the diagnostic result information returned in the format of text data from the database server. It is a figure which shows the example which converted the diagnostic result information given as text data shown in FIG. 6 into the data of XML format. It is a figure which shows an example of the diagnostic result information which added bibliographic information.

Explanation of symbols

10 ... database server 20 ... database server 100 ... terminal device (personal computer)
200 ... System main body 210 ... Input Web page presentation means 220 ... Diagnosis execution means 230 ... Diagnosis result reception means 240 ... Result display Web page presentation means 250 ... Diagnosis target designation information input means 260 ... Script selection means 270 ... Format conversion means
280 ... Script storage means 290 ... Diagnosis result storage means 300 ... Network (Internet)

Claims (9)

A database diagnosis system for diagnosing performance of a database server by giving a diagnosis script to the database server to be diagnosed and executing the script.
A system main body connectable to a database server to be diagnosed via a network, and a terminal device connectable to the system main body via a network,
The terminal device is composed of a computer in which a web browser program is incorporated, and is configured to perform an input operation of information necessary for diagnosis and display processing of a diagnosis result using the web browser program.
The system main body is
An input web page presenting means for presenting an input web page for inputting information necessary for diagnosis to the terminal device;
Based on the operation of the terminal device operator on the input Web page, the type of DBMS used for the database server to be diagnosed, the type of OS used for the database server to be diagnosed, and diagnosis A diagnostic target designation information input means for inputting, as diagnostic target designation information, a management user name and password for a target database server, DB identification information for specifying a database server to be diagnosed,
Diagnostic scripts suitable for diagnosing a specific type of DBMS and a specific database server using a specific type of OS are stored for each combination of a plurality of types of DBMS and a plurality of types of OS. Script storage means,
Script selection means for selecting a specific diagnosis script corresponding to the combination of the DBMS and the OS based on the type of DBMS and the type of OS included in the diagnosis target designation information;
The selected diagnosis script is given to the database server as the diagnosis target specified by the DB identification information included in the diagnosis target designation information together with the management user name and password included in the diagnosis target designation information. Diagnostic execution means for executing this, and
A diagnostic result receiving means for receiving diagnostic result information indicating an execution result of the diagnostic script from the database server to be diagnosed;
A result display web page presenting means for presenting the diagnosis result information as a result display web page to the terminal device;
A database diagnostic system comprising: The database diagnostic system according to claim 1,
Format conversion means for converting the received diagnosis result information into data described in a predetermined format;
Diagnostic result storage means for storing the converted data;
A database diagnosis system characterized by further comprising: The database diagnosis system according to claim 2, wherein
A database diagnostic system, wherein the format conversion means has a function of converting diagnostic result information received in a text data format into data described in an XML format. The database diagnosis system according to claim 2 or 3,
The format conversion means has a function of adding information indicating the type of DBMS, information indicating the type of OS, and DB identification information as bibliographic information to the received diagnosis result information, for the database server to be diagnosed,
A database diagnosis system, wherein the diagnosis result storage means has a function of storing diagnosis result information with the bibliographic information added thereto. In the database diagnostic system according to any one of claims 1 to 4,
A database diagnostic system characterized by identifying a DBMS type by a DBMS name and its version. In the database diagnosis system according to any one of claims 1 to 5,
A database diagnosis system comprising DB specifying information based on an IP address of a database server to be diagnosed and a name of a database to be diagnosed. In the database diagnosis system according to any one of claims 1 to 6,
A database diagnosis system, wherein the result display Web page presentation means has a function of converting diagnosis result information into an HTML format based on a style sheet indicating a display format on a Web page.   The system main body which comprises the database diagnostic system in any one of Claims 1-7.   A program for causing a computer to function as a system main body constituting the database diagnosis system according to claim 1, and a computer-readable recording medium storing the program.