METHOD FOR PROVIDING DATABASE MANAGEMENT AND THE DATABASE MANAGEMENT SERVER THEREOF

• US 20130304695A1
• Filed: 03/14/2013
• Published: 11/14/2013
• Est. Priority Date: 03/22/2012
• Status: Abandoned Application

• Current Assignee: LG CNS Company Limited (LBHunet Co., Ltd.)
• Original Assignee: LG CNS Company Limited (LBHunet Co., Ltd.)
• Inventors: Lee, Joon Ik, Park, Jung In, Chon, Hye Kyoung, Hwang, Deok Young, Wi, Jeong Hyun, Lee, Chin Sik
• Application Number:
  US13/831,253
• Publication Number:
  US 20130304695A1
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 11/3414 Workload generation, e.g. scripts, playback
• CPC Class Codes: G06F 11/3466 Performance evaluation by tracing or monitoring
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

The present invention provides diagnosis and management of a database system. The method for database management comprises (a) generating a list of at least one database managed by the database system; (b) providing a list of diagnostic items including a plurality of diagnostic items which can be carried out against at least one database selected from the list; and (c) carrying out diagnosis by providing the database system with at least one script related to at least one diagnostic item selected from the list of diagnostic items, wherein the at least one script is configured to have a run time set up differently according to the status of the database system. Database management provides various diagnostic items through remote connection to a particular database system and providing a quantitative analysis of the corresponding diagnosis result, thereby enabling more complete and comfortable database management.

Claims

1. A method for database management which connects to a predetermined database system through a network and is carried out in a database management server capable of providing diagnosis of the database system, the method comprising:

generating a list of at least one database managed by the database system;

providing a list of diagnostic items including a plurality of diagnostic items which can be carried out against at least one database selected from the list; and

carrying out diagnosis by providing the database system with at least one script related to the at least one diagnostic item selected from the list of diagnostic items, wherein the at least one script is configured to have a run time set up differently according to the status of the database system.

2. The method of claim 1, wherein the carrying out diagnosis comprises:

checking a current status of the database system; and

configuring the run time of the at least one script by reflecting the current status checked.

3. The method of claim 2, wherein the carrying out diagnosis comprises:

providing at least one script in which the run time is specified; and

if the database system'"'"'s load exceeds a predetermined value while the provided at least one script is running, controlling the provided at least one script to stop running.

4. The method of claim 1, wherein the providing the list of diagnostic items comprises:

generating a plurality of standardized diagnostic scripts based on a database management system (DBMS) or version information thereof; and

generating the list of diagnostic items by classifying the plurality of diagnostic scripts according to the diagnostic items.

5. The method of claim 1, wherein the providing the list of diagnostic items comprises:

checking a past diagnosis history of the database system; and

providing the list of diagnostic items including a recommendation for at least one diagnostic item by using the past diagnosis history checked.

6. The method of claim 1, further comprising processing according to a predetermined quantitative criterion raw data generated by execution of the script received from the database system.

7. The method of claim 6, wherein the processing comprises:

generating a temporary table which stores the raw data;

storing in the temporary table at least one of;

data obtained from execution of the script, and extended data obtained from application of an extended procedure for the raw data; and

determining the raw data by separating or merging at least part of the raw data stored in the temporary table based on information in the operating system for the database system.

8. The method of claim 6, further comprising calculating at least one evaluation result about the at least one diagnostic item by using the processed data.

9. The method of claim 8, wherein the calculating comprises:

evaluating the database system by comparing the processed data with reference data assigned to the database system for each of the at least one evaluation item; and

converting the comparison result into a grade data.

10. The method of claim 8, further comprising generating a diagnostic report including the at least one evaluation result.

11. The method of claim 10, wherein the generating the diagnostic report comprises:

checking a history of diagnostic reports pre-generated for and stored in the database system; and

providing a comparison result after comparing the diagnostic reports pre-generated and stored with the generated diagnostic report.

12. A method for database management which is carried out in a database management server capable of connecting to a predetermined database system through a network and analyzing the connected database system, the method comprising:

providing a list of diagnostic items including a plurality of diagnostic items carried out in the database system;

generating at least one script for carrying out the diagnosis and associating the script with the diagnostic item; and

modifying the at least one script associated with the at least one diagnostic item selected from the list of diagnostic items to reflect the status of the database system and carry out diagnosis by executing the modified at least one script.

13. The method of claim 12, wherein the at least one script is configured to have a separate run time and, being executed in the database system during a configured run time, generates diagnostic data about the corresponding database system.

14. The method of claim 13, wherein the at least one script contains a predetermined query with which system information about the database system is obtained and, if a load applied to the database system in response to the query exceeds a predetermined load, execution of the corresponding script is stopped.

15. The apparatus of claim 12, wherein the diagnostic item includes at least one of:

basic information about the database system, configuration management, failure management, capacity management, performance management, availability management, and security management; and

wherein the at least one diagnostic item is associated with the at least one script for the corresponding diagnosis.

16. The method of claim 12, wherein the modifying the at least one script comprises checking system information of the database system while the modified at least one script is running in the database system;

and

if a load exceeding a predetermined value is applied to the database system, controlling the at least one script in execution to stop running.

17. The method of claim 12, wherein the modifying the at least one script comprises setting up a maximum run time for the at least one script by reflecting a status of the database system;

and

determining priority for each of the at least one script, where the priority is considered first over the maximum run time.

18. The method of claim 12, further comprising providing evaluation data calculated by comparing an execution result of the at least one script generated from the modified at least one script with reference data of the corresponding database system.

19. A database management server, which connects to a predetermined database system through a network and provides diagnosis of the database system, the database management server comprising:

an evaluation item management unit managing a plurality of diagnostic items carried out in the database system;

a script management unit managing a plurality of scripts for carrying out a predetermined diagnosis in relation to each of the plurality of diagnostic items;

a controller selecting at least one script associated with at least one diagnostic item selected from the plurality of diagnostic items and providing the database system with the selected at least one script by setting up limiting conditions on the execution thereof.

20. The database management server of claim 19, wherein the controller sets up a maximum run time for the at least one script depending on the status of the database system, and provides the at least one script to the database system.

21. The database management server of claim 19, wherein the controller checks a load applied on the database system, which is generated by the at least one script, and if the load exceeds a predetermined threshold, controls the corresponding at least one script to stop running.

22. The database management server of claim 19, further comprising a report management unit which processes raw data generated by execution of the at least one script according to a predetermined quantitative criterion, and evaluates the database system by comparing the processed data with reference data assigned to the database system.

23. A computer-readable storage medium storing computer instructions, which when executed, enables a computer system to carry out a method for database management and provide diagnosis of a connected database system, the computer instructions comprising:

generating a list of at least one database managed by the database system;

providing a list of diagnostic items including a plurality of diagnostic items which can be carried out for at least one database selected from the list; and

carrying out a diagnosis against the database system by providing the database system with at least one script related to at least one diagnostic item selected from the list of diagnostic items, wherein the at least one script is configured to have a run time set up differently according to the status of the database system.

24. A method for deploying a database management server for use in a computer system that provides data integration using automated data processing based on target metadata, the method comprising:

providing a computer infrastructure operable to;

provide a list of diagnostic items including a plurality of diagnostic items, which can be carried out in the database system;

generate at least one script for carrying out the diagnosis and relating the generated at least one script to the diagnostic item; and

modify at least one script associated with the at least one diagnostic item selected from the list of diagnostic items by reflecting the status of the database system and carrying out diagnosis by executing the modified at least one script.