Summary of the invention
The main purpose of the present invention is to provide a kind of database monitoring method, device, equipment and readable storage medium storing program for executing, purportsIn the applicability and reliability for improving database monitoring.
To achieve the above object, the present invention provides a kind of database monitoring method, the database monitoring method include withLower step:
The connection configuration information of database to be monitored is received, and according to the connection configuration information, to default monitoring templateThe connecting object of concentration is configured, to obtain current monitor template set;
In the database to be monitored, the monitoring SQL statement that subitem is respectively monitored in the current monitor template set is executed,And the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
If trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information, and according to pre-If alarm mode the warning information is sent to alarm group of contacts.
Optionally, according to the connection configuration information, the connecting object in default monitoring template set is configured, to obtainThe step of taking current monitor template set include:
The identification field of each connecting object in default monitoring template set, and the identification field according to each connecting object are obtained,The correspondence configuration parameter of each connecting object is obtained from the connection configuration information;
According to the correspondence configuration parameter of each connecting object, the connecting object in default monitoring template set is configured, withObtain current monitor template set.
Optionally, the step of monitored results according to each monitoring subitem determine whether trigger data library alarm command packetIt includes:
It determines in each monitoring subitem and is located in default monitored results group with the presence or absence of the monitored results of at least one monitoring subitem;
If the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group, triggerDatabase alarm command, otherwise not trigger data alarm command.
Optionally, the step of monitored results generation warning information according to each monitoring subitem includes:
Default warning information template is obtained, and the monitored results of each monitoring subitem are filled to the default warning information mouldIn plate, to generate warning information.
Optionally, the monitored results by each monitoring subitem are filled into the default warning information template, to generateThe step of warning information includes:
Obtain the location information of each monitoring subitem in the default warning information template;
According to the location information of each monitoring subitem, affiliated filling of each monitoring subitem in default warning information template is determinedPosition;
The monitored results of each monitoring subitem are filled into filling position belonging to the correspondence into default warning information template.
Optionally, the database monitoring method further include:
Currently available cpu resource is obtained, and according to currently available cpu resource, determines the execution side of database monitoring operationFormula is single task executive mode or multitask executive mode;
If the executive mode of database monitoring operation is single task executive mode, the monitoring of a monitoring subitem is executed every timeSQL statement;
If the executive mode of database monitoring operation is multitask executive mode, determined according to currently available cpu resourceIt is synchronous to execute number of tasks, and according to the synchronous execution number of tasks, execute the monitoring SQL statement of the monitoring subitem of corresponding number.
Optionally, described to determine that synchronous the step of executing page number includes: according to currently available cpu resource
The mapping table of the currently available cpu resource that acquisition prestores and synchronous execution number of tasks, and closed from the mappingIt is to inquire synchronous execution number of tasks corresponding with currently available cpu resource in table.
In addition, to achieve the above object, the present invention also provides a kind of database monitoring device, the database monitoring deviceInclude:
Configuration module is right for receiving the connection configuration information of database to be monitored, and according to the connection configuration informationConnecting object in default monitoring template set is configured, to obtain current monitor template set;
Execution module, for executing in the current monitor template set and respectively monitoring subitem in the database to be monitoredMonitoring SQL statement, and according to it is each monitoring subitem monitored results determine whether trigger data library alarm command;
Alarm module, if being used for trigger data library alarm command, the monitored results according to each monitoring subitem generate alarmInformation, and the warning information is sent to alarm group of contacts according to preset alarm mode.
In addition, to achieve the above object, the present invention also provides a kind of database monitoring equipment, the database monitoring equipmentIncluding processor, memory and it is stored in the database monitor that can be executed on the memory and by the processor,When wherein the database monitor is executed by the processor, realize such as the step of above-mentioned database monitoring method.
In addition, to achieve the above object, the present invention also provides a kind of readable storage medium storing program for executing, being deposited on the readable storage medium storing program for executingDatabase monitor is contained, wherein realizing that above-mentioned database such as is supervised when the database monitor is executed by processorThe step of prosecutor method.
The present invention provides a kind of database monitoring method, device, equipment and readable storage medium storing program for executing, and the present invention receives to be monitoredThe connection configuration information of database, and according to connection configuration information, the connecting object in default monitoring template set is configured,To obtain current monitor template set;In database to be monitored, the monitoring SQL that subitem is respectively monitored in current monitor template set is executedSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;If the alarm of trigger data library refers toIt enables, then the monitored results according to each monitoring subitem generate warning information, and send warning information according to preset alarm modeAlarm group of contacts is given, template set is monitored by setting, monitoring template set is used in PostgreSQL database under each application systemMonitoring, do not need operation maintenance personnel configuration monitoring strategy, only need simple configuration database connecting object, can be realizedThe monitoring of PostgreSQL database, the effective deployment difficulty for lowering monitoring, improves the applicability of database monitoring.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present embodiments relate to database monitoring method be mainly used in database monitoring equipment, the database monitoringEquipment, which can be PC (personal computer personal computer), portable computer, mobile terminal etc., has display and processingThe equipment of function.
Referring to Fig.1, Fig. 1 is the hardware structural diagram of database monitoring equipment involved in the embodiment of the present invention.In the embodiment of the present invention, database monitoring equipment may include (such as the central processing unit Central of processor 1001Processing Unit, CPU), communication bus 1002, user interface 1003, network interface 1004, memory 1005.Wherein,Communication bus 1002 is for realizing the connection communication between these components;User interface 1003 may include display screen(Display), input unit such as keyboard (Keyboard);Network interface 1004 optionally may include that the wired of standard connectsMouth, wireless interface (such as WI-FI interface);Memory 1005 can be high speed RAM memory, be also possible to stable memory(non-volatile memory), such as magnetic disk storage, memory 1005 optionally can also be independently of aforementioned processor1001 storage device.It will be understood by those skilled in the art that hardware configuration shown in Fig. 1 is not constituted to limit of the inventionIt is fixed, it may include perhaps combining certain components or different component layouts than illustrating more or fewer components.
With continued reference to Fig. 1, the memory 1005 in Fig. 1 as a kind of readable storage medium storing program for executing may include operating system, netNetwork communication module and database monitor.In Fig. 1, network communication module is mainly used for connecting server, with serverCarry out data communication;And processor 1001 can call the database monitor stored in memory 1005, and execute this hairThe database monitoring method that bright embodiment provides.
The embodiment of the invention provides a kind of database monitoring methods.
It is the flow diagram of database monitoring method first embodiment of the present invention referring to Fig. 2, Fig. 2.
In the present embodiment, which is realized by database monitoring equipment, which can be withIt is the terminal devices such as PC, palm PC and tablet computer, is chosen as equipment shown in FIG. 1, the database monitoring method includesFollowing steps:
Step S101 receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoringConnecting object in template set is configured, to obtain current monitor template set;
Step S102 executes the monitoring SQL language that subitem is respectively monitored in current monitor template set in database to be monitoredSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
Step S103, if trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode.
Currently, the monitor mode of PostgreSQL database is that operation maintenance personnel uses monitoring tools, configuration monitoring strategy prisonDatabase is controlled, for the database used under different application systems, operation maintenance personnel needs to configure different monitoring strategies, dataThe applicability and reliability of library monitoring are lower, influence the monitoring efficiency of database.In view of the above problem, proposed in the present embodimentA kind of database monitoring method, the specific steps of database monitoring method described in detail below:
Step S101 receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoringConnecting object in template set is configured, to obtain current monitor template set;
In the present embodiment, when monitoring the configuration-direct of monitoring data collection of operation maintenance personnel triggering, equipment display connectionObject configuration interface, and receive the connection configuration for the database to be monitored that operation maintenance personnel is inputted based on the connecting object configuration interfaceInformation.Wherein, which includes but is not limited to grouping, system where the said system of database to be monitored, systemAffiliated function or subsidiary, alarm group of contacts, PostgreSQL database host IP, PostgreSQL database host port,Database-name, database login user and database login password, the connecting object configuration interface show object oriented andParameter declaration, and grouping, system affiliated function or subsidiary where the said system of database to be monitored, system and alarm connectionThe parameter declaration of group is alarm satellite information, and PostgreSQL database host IP, PostgreSQL database host port,The parameter declaration of database-name, database login user and database login password is monitoring data library configuration information.
Equipment receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoring templateThe connecting object of concentration is configured, to obtain current monitor template set, i.e., to the data to be monitored in default monitoring template setSaid system, the grouping of system place, system affiliated function or the subsidiary in library, alarm group of contacts, PostgreSQL database masterMachine IP, PostgreSQL database host port, database-name, database login user and database login password are matchedIt sets.
Wherein, presetting monitoring template set includes but is not limited to the monitoring SQL statement of database availability monitor subitem, applicationSQL execution efficiency monitors monitoring SQL statement, the database of the monitoring SQL statement of subitem, background job executive condition monitoring subitemConnection number monitors the monitoring SQL statement of subitem and the monitoring SQL statement of Database lock monitoring subitem.Database availability monitorWhether the monitoring SQL statement of subitem can receive external request for monitoring data library, monitors subitem using SQL execution efficiencyMonitoring SQL statement be used to pass through database snapshot information, it is determined whether there are what execution efficiency was lower than default efficiency to apply SQLAnd for obtaining the current execution time for applying SQL by pg_stat_activity view, it is determined whether exist and currently holdThe row time is more than specified duration using SQL;The monitoring SQL statement that background job executive condition monitors subitem is used forFunction quartzchk is created in PostgreSQL database, is recalled function select*from quartzchk inquiry backstage and is madeIndustry executive condition;Current connection sum of the monitoring SQL statement of database connection number monitoring subitem for monitoring data library accounts for numberIt whether is more than given threshold according to the ratio of the maximum allowable connection number in library;The monitoring SQL statement of Database lock monitoring subitem is for supervisingWhen controlling whether database Database lock occurs, and Database lock occur, pass through pg_locks and pg_stat_activity viewIt is associated inquiry, refines each SQL statement lock status.
Specifically, equipment obtains the identification field of each connecting object in default monitoring template set, and according to each connecting objectIdentification field, the correspondence configuration parameter of each connecting object is obtained from the connection configuration information, i.e., connection configuration information inConfiguration parameter and identification field have corresponding relationship, can be inquired by the identification field of each connecting object and get each connecting objectCorrespondence configuration parameter, then according to the correspondence configuration parameter of each connecting object, to the connecting object in default monitoring template setIt is configured, to obtain current monitor template set, i.e., is configured the design parameter of each connecting object in default monitoring template setFor corresponding configuration parameter.
Step S102 executes the monitoring SQL language that subitem is respectively monitored in current monitor template set in database to be monitoredSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
In the present embodiment, in configuring default template set after the connecting object of database to be monitored, equipment is wait superviseIt controls in database, executes the monitoring SQL statement for respectively monitoring subitem in current monitor template set, and the monitoring according to each monitoring subitemAs a result determine whether trigger data library alarm command.Specifically, the monitoring SQL statement of database availability monitor subitem is executed,Whether monitoring data library can receive external request, if external request can not be received by monitoring database, monitor knotFruit is that database access is abnormal, if monitoring database can receive external request, monitored results are database accessNormally;
The monitoring SQL statement using SQL execution efficiency monitoring subitem is executed, monitoring data library SNAPSHOT INFO, statistics is recentlySQL executive condition is applied in given number of days, it is determined whether is lower than the application SQL of default efficiency there are execution efficiency and is passed throughPg_stat_activity view obtains the current execution time for applying SQL, it is determined whether there are current execution times more than fingerTiming it is long apply SQL, be lower than the application SQL of default efficiency if there is execution efficiency or there are current execution times to be more thanSpecified duration applies SQL, then monitored results are that execution efficiency is lower than the application SQL of default efficiency or current execution time is more thanSpecified duration applies SQL, i.e. SQL execution efficiency is abnormal, if default effect is respectively above or be equal to using the execution efficiency of SQLRate, and be respectively no more than specified duration using the current execution time of SQL, then monitored results are that SQL execution efficiency is normal;
The monitoring SQL statement for executing background job executive condition monitoring subitem, creates letter in PostgreSQL databaseNumber quartzchk recalls function select*from quartzchk inquiry background job executive condition, and monitored results areBackstage effect executive condition;Wherein, using first create function quartzchk, recall function select*fromWhen the mode of quartzchk inquires background job executive condition, when can avoid system of the monitoring without background job, the SQL of appearanceSentence reports an error phenomenon, improves applicability;
The monitoring SQL statement of database connection number monitoring subitem is executed, the current connection sum in monitoring data library accounts for dataWhether the ratio of the maximum allowable connection number in library is more than preset threshold, if the current connection sum of database accounts for database maximum and permitsPerhaps the ratio of connection number is more than preset threshold, then monitored results are the connection number of each user, and database excess load, if dataThe ratio that the current connection sum in library accounts for the maximum allowable connection number of database is no more than given threshold, then monitored results are databaseNon- excess load;
The monitoring SQL statement of Database lock monitoring subitem is executed, whether there is the SQL language of lock status in monitoring data librarySentence, if there are the SQL statements of lock status for database, is associated by pg_locks and pg_stat_activity viewInquiry, refines the lock status of the SQL statement, and monitored results include the affairs letter of the PID for generating the process locked, latching mode and lockBreath does not generate monitored results if the SQL statement of lock status is not present in database, wherein latching mode includesAccessShareLock、RowShareLock、RowExclusiveLock、ShareUpdateExclusiveLock、ShareLock, ShareRowExclusiveLock, ExclusiveLock and AccessExclusiveLock etc..
Specifically, equipment, which determines in each monitoring subitem, is located at default prison with the presence or absence of the monitored results of at least one monitoring subitemIt controls in result group, if the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group,Trigger data library alarm command, otherwise trigger data alarm command, i.e., the monitored results of each monitoring subitem are not located at defaultIn monitored results group, then not trigger data alarm command.It should be noted that above-mentioned default monitored results group can be by this field skillArt personnel are configured based on actual conditions, and the present embodiment is not especially limited this.
Step S103, if trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode.
In the present embodiment, if trigger data library alarm command, the monitored results according to each monitoring subitem generate alarmInformation, and the warning information is sent to alarm group of contacts according to preset alarm mode.Specifically, default warning information is obtainedTemplate, and the monitored results of each monitoring subitem are filled into the default warning information template, to generate warning information, that is, obtainThe location information of each monitoring subitem in the default warning information template, and the location information according to each monitoring subitem are taken, is determinedAffiliated filling position of each monitoring subitem in default warning information template, and the monitored results of each monitoring subitem are filled to pre-If filling position belonging to the correspondence in warning information template, to generate warning information.Wherein, warning information includes but is not limited to instituteGrouping, system affiliated function or subsidiary, alarm group of contacts and exception information where category system, system, and the exception information packetInclude but be not limited to database disconnect, the low SQL language using SQL, background job executive condition and lock status of execution efficiencySentence, the alarm mode include but is not limited to mail alarm, short message alarm and warning by telephone.
In the present embodiment, the present invention receives the connection configuration information of database to be monitored, and according to connection configuration information, rightConnecting object in default monitoring template set is configured, to obtain current monitor template set;In database to be monitored, executeThe monitoring SQL statement of subitem is respectively monitored in current monitor template set, and the monitored results according to each monitoring subitem determine whether to touchSend out database alarm command;If trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode, template set is monitored by setting, monitors template setIt is used in the monitoring of PostgreSQL database under each application system, does not need operation maintenance personnel configuration monitoring strategy, is only needed simpleConfiguration database connecting object, the monitoring of PostgreSQL database can be realized, the effective deployment difficulty for lowering monitoring,Improve the applicability of database monitoring.
Further, referring to Fig. 3, it is based on above-mentioned first embodiment, proposes the second of database monitoring method of the present inventionEmbodiment, the difference with previous embodiment be, the database monitoring method further include:
Step 104 obtains currently available cpu resource, and according to currently available cpu resource, determines that database monitoring operatesExecutive mode be single task executive mode or multitask executive mode;
In the present embodiment, equipment obtains currently available cpu resource, and according to currently available cpu resource, determines that database is supervisedThe executive mode of control operation is single task executive mode or multitask executive mode, specially determines currently available cpu resourceWhether it is more than default cpu resource, if currently available cpu resource is more than default cpu resource, can determines that database monitoring is graspedThe executive mode of work is multitask executive mode, if currently available cpu resource is less than default cpu resource, can be determinedThe executive mode of database monitoring operation is single task executive mode.
If the executive mode of step 105, database monitoring operation is multitask executive mode, according to currently available CPUResource determines synchronous execution number of tasks, and according to the synchronous execution number of tasks, executes the monitoring of the monitoring subitem of corresponding numberSQL statement.
In the present embodiment, if the executive mode of database monitoring operation is multitask executive mode, foundation currently may be usedWith cpu resource determine it is synchronous execute number of tasks, that is, obtain the currently available cpu resource that prestores and the mapping of synchronous execution page numberRelation table, and from mapping table, synchronous execution number of tasks corresponding with currently available cpu resource is inquired, and according to synchronizationNumber of tasks is executed, executes the monitoring SQL statement of the monitoring subitem of corresponding number, i.e. equipment executes sequence according to default, wait superviseIt controls in database, executes and the monitoring SQL statement of the synchronous monitoring subitem for executing number of tasks corresponding number.If database monitoringThe executive mode of operation is single task executive mode, then executes the monitoring SQL statement of a monitoring subitem every time, i.e., equipment is according to pre-If executing sequence, in database to be monitored, the monitoring SQL statement that subitem is respectively monitored in current monitor template set is executed.It needsIllustrate, above-mentioned default execution sequence can be configured by those skilled in the art based on actual conditions, and the present embodiment is to thisIt is not especially limited.
Wherein, default cpu resource can be arranged according to CPU total resources, or be arranged according to specific needs by user.WhenWhen cpu resource is less than default cpu resource, it can be determined according to the mapping relations that can be used between cpu resource and synchronization page quantityThe synchronization page quantity that can be performed simultaneously, such as in mapping relations, when available cpu resource is less than A, what correspondence can be performed simultaneouslySynchronization page quantity is 2;When available cpu resource is more than or equal to A, is less than B, synchronization page number that correspondence can be performed simultaneouslyAmount is 3;When available cpu resource is more than or equal to B, is less than C, the synchronization page quantity that correspondence can be performed simultaneously is 4,In, A < B < C.
In the present embodiment, the present invention determines the prison of the synchronous monitoring subitem executed by the currently available cpu resource of equipmentSQL statement is controlled, equipment can be performed simultaneously the monitoring SQL statement of multiple monitoring subitems, effective to improve database monitoring efficiency.
In addition, the embodiment of the present invention also provides a kind of database monitoring device.
It is the functional block diagram of database monitoring device first embodiment of the present invention referring to Fig. 4, Fig. 4.
Database monitoring device of the present invention is virtual bench, is stored in the memory of database monitoring equipment shown in Fig. 1It is functional for realizing the institute of database monitor in 1005;Receive the connection configuration information of database to be monitored, and foundationThe connection configuration information configures the connecting object in default monitoring template set, to obtain current monitor template set;?In the database to be monitored, the monitoring SQL statement that subitem is respectively monitored in the current monitor template set is executed, and according to each prisonThe monitored results of control subitem determine whether trigger data library alarm command;If trigger data library alarm command, according to each monitoringThe monitored results of subitem generate warning information, and the warning information is sent to alarm connection according to preset alarm modeGroup.
Specifically, in the present embodiment, the database monitoring device includes:
Configuration module 101 matches confidence for receiving the connection configuration information of database to be monitored, and according to the connectionBreath configures the connecting object in default monitoring template set, to obtain current monitor template set;
Execution module 102, for executing in the database to be monitored, respectively monitoring is sub in the current monitor template setThe monitoring SQL statement of item, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
Alarm module 103, if being used for trigger data library alarm command, the monitored results according to each monitoring subitem, which generate, is accusedAlert information, and the warning information is sent to alarm group of contacts according to preset alarm mode.
Further, the configuration module 101 is also used to:
The identification field of each connecting object in default monitoring template set, and the identification field according to each connecting object are obtained,The correspondence configuration parameter of each connecting object is obtained from the connection configuration information;
According to the correspondence configuration parameter of each connecting object, the connecting object in default monitoring template set is configured, withObtain current monitor template set.
Further, the execution module 102 is also used to:
It determines in each monitoring subitem and is located in default monitored results group with the presence or absence of the monitored results of at least one monitoring subitem;
If the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group, triggerDatabase alarm command, otherwise not trigger data alarm command.
Further, the alarm module 103 is also used to:
Default warning information template is obtained, and the monitored results of each monitoring subitem are filled to the default warning information mouldIn plate, to generate warning information.
Further, the alarm module 103 is also used to:
Obtain the location information of each monitoring subitem in the default warning information template;
According to the location information of each monitoring subitem, affiliated filling of each monitoring subitem in default warning information template is determinedPosition;
The monitored results of each monitoring subitem are filled into filling position belonging to the correspondence into default warning information template.
Further, the database monitoring device further include:
Determining module determines database monitoring for obtaining currently available cpu resource, and according to currently available cpu resourceThe executive mode of operation is single task executive mode or multitask executive mode;
The execution module 102, if the executive mode for being also used to database monitoring operation is single task executive mode, oftenThe secondary monitoring SQL statement for executing a monitoring subitem;
The execution module 102, if the executive mode for being also used to database monitoring operation is multitask executive mode, according toSynchronous execution number of tasks is determined according to currently available cpu resource, and according to the synchronous execution number of tasks, executes the prison of corresponding numberControl the monitoring SQL statement of subitem.
Further, the execution module, is also used to:
The mapping table of the currently available cpu resource that acquisition prestores and synchronous execution number of tasks, and closed from the mappingIt is to inquire synchronous execution number of tasks corresponding with currently available cpu resource in table.
Wherein, the function of modules is realized and above-mentioned database monitoring method embodiment in above-mentioned database monitoring deviceIn each step it is corresponding, function and realization process no longer repeat one by one here.
In addition, the embodiment of the present invention also provides a kind of readable storage medium storing program for executing.
It is stored with database monitor on readable storage medium storing program for executing of the present invention, wherein the database monitor is processedWhen device executes, realize such as the step of above-mentioned database monitoring method.
Wherein, database monitor, which is performed realized method, can refer to each of database monitoring method of the present inventionA embodiment, details are not described herein again.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-rowHis property includes, so that the process, method, article or the system that include a series of elements not only include those elements, andAnd further include other elements that are not explicitly listed, or further include for this process, method, article or system institute it is intrinsicElement.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to doThere is also other identical elements in the process, method of element, article or system.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment sideMethod can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many casesThe former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior artThe part contributed out can be embodied in the form of software products, which is stored in one as described aboveIn storage medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that terminal device (it can be mobile phone,Computer, server, air conditioner or network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hairEquivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skillsArt field, is included within the scope of the present invention.