CN116185997A - Database management system supporting comprehensive server - Google Patents
Database management system supporting comprehensive server Download PDFInfo
- Publication number
- CN116185997A CN116185997A CN202310227087.5A CN202310227087A CN116185997A CN 116185997 A CN116185997 A CN 116185997A CN 202310227087 A CN202310227087 A CN 202310227087A CN 116185997 A CN116185997 A CN 116185997A
- Authority
- CN
- China
- Prior art keywords
- server
- database
- management
- management module
- data information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013515 script Methods 0.000 claims abstract description 41
- 238000012360 testing method Methods 0.000 claims abstract description 36
- 238000011161 development Methods 0.000 claims abstract description 26
- 230000002159 abnormal effect Effects 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims abstract description 7
- 230000010365 information processing Effects 0.000 claims abstract description 3
- 230000005856 abnormality Effects 0.000 claims description 9
- 238000000034 method Methods 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 4
- 230000000007 visual effect Effects 0.000 claims description 4
- 238000009434 installation Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 238000004891 communication Methods 0.000 abstract description 5
- 230000006978 adaptation Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003032 molecular docking Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3051—Monitoring arrangements for monitoring the configuration of the computing system or of the computing system component, e.g. monitoring the presence of processing resources, peripherals, I/O links, software programs
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a database management system supporting a comprehensive server, belongs to the field of database management, and relates to an operating system script; the system comprises a specific script, a management development server and a test management module; the specific script is deployed in the target server and used for realizing data information acquisition of the target server and sending the data information to a database of the management development server for storage; the test management module is used for processing the data information stored in the management development server database to obtain an output result; when the output result of the test management module after data information processing is more than or equal to the risk early warning value, the test management module sends an abnormal signal to an abnormal notification module, and the abnormal notification module notifies an administrator; the invention realizes the full-automatic server management, and can immediately and actively send information to inform a manager in the current mainstream communication mode for the abnormal condition of the server, thereby forming an unattended and safe scene.
Description
Technical Field
The invention belongs to the field of database management, relates to an operating system script, and particularly relates to a database management system supporting a comprehensive server.
Background
Today database systems are increasingly in demand, the number of servers in enterprise systems is increasing, and for numerous server assets, it is a major challenge to simply and efficiently manage, where comprehensive support of server hardware and support of database products for various demands in the servers are involved, and when an enterprise adds a new type of database product, how to ensure that management software used by the enterprise can be timely and effectively access management is a problem facing the present day.
In view of this problem, the management software currently existing on the market mainly has the following prominent problems:
1. the hardware server covered by the software technology is incomplete, and the matching of related management software needs to be matched and combined according to the hardware parameters of the server due to the different characteristic characteristics of various servers;
2. the variety of databases is various, the types are also quite different, most management software can provide certain support for the mainstream databases at present, but the new type databases lack certain support for relatively cool doors;
3. the docking of applications is relatively lacking, and typically the management software manufacturer adapts its own series of applications, and no adaptation is adopted for other manufacturer's applications.
To this end, the present invention proposes a database management system supporting a full server.
Disclosure of Invention
It is an object of the present application to provide a database management system that supports a comprehensive server.
In order to achieve the above object, the present application provides a database management system supporting a comprehensive server, including a specific script formed by writing specific script codes through a script compiling tool, a management development server, and a test management module connected with the management development server;
the specific script is deployed in the target server and used for realizing data information acquisition of the target server and sending the data information to a database of the management development server for storage;
the test management module is used for processing the data information stored in the management development server database to obtain an output result;
when the output result of the test management module after data information processing is more than or equal to the risk early warning value, the test management module sends an abnormal signal to the abnormal notification module, and the abnormal notification module notifies an administrator.
Preferably, the risk early warning value is set by a test management module.
Preferably, the script compiling tool is a Shell tool of a Linux operating system or a PowerShell tool of a Windows operating system.
Preferably, the target server is the server where the managed database is located; when a plurality of target servers exist, the specific script is distributed to the specific installation catalogs of the plurality of target servers in a one-key distribution mode in the same network segment to complete specific script deployment.
Preferably, when the specific script collects data information, the data reporting time is customized and reported to the management development server so as to be called by a test management module connected with the management development server.
Preferably, the mode of informing the administrator by the abnormality notification module includes one or more of short message, weChat, nail and mail.
Preferably, the process of processing the data information and obtaining the output result by the test management module is as follows:
inputting a search code in a specific script, and screening a query result by a test management module;
the test management module intercepts the effective part of the query result, reserves part of useful data segments, and places the part of useful data segments in the test management module;
visual interface presentation is performed through the REST interface.
Preferably, the target server comprises a general basic server system, an all-in-one server or a public cloud server which is applied to a database of a specific database manufacturer and is proposed by the manufacturer.
Compared with the prior art, the invention has the beneficial effects that:
the database management system supporting the comprehensive server provided by the invention supports all server types: for the hardware of the server, the system can achieve full compatibility, and the adaptation of script acquisition only needs to support an operating system layer. Through the underlying design logic, the native compilation tool of the operating system is adopted, and the method only depends on the operating system, namely, the database is supported by the invention as long as the operating system supports the use of the database.
The invention realizes the full-automatic server management, and for the conditions of downtime, disasters and the like of the server, the manager can immediately and actively send information to inform the manager in the current main stream communication mode, the manager does not need to watch the platform at any time, the manager can receive the notification when the accident happens, and the manager can receive the notification when the task execution is finished perfectly, so that an unattended scene which can be relieved is formed.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required in the prior art and the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a block diagram of a database management system supporting a full server according to the present invention.
Detailed Description
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
Referring specifically to fig. 1, a database management system supporting a full server includes a script compiling tool; the script compiling tool is used for compiling specific script codes to form specific scripts;
in the application, considering that the current mainstream operating systems are Linux and Windows, correspondingly, the script compiling tool provided by the invention is a Shell tool of Linux and a PowerShell tool of Windows;
the script is a corresponding operating system white band support without additionally installing compiling tool software.
In the application, a specific script written by a script compiling tool is used for realizing data information acquisition;
the data information comprises, but is not limited to, hardware specification information of a server, detailed specification information of a database product, storage capacity of a hard disk of the server, utilization rate of a memory of the server and the like, and the acquired data information is sent to a management development server for storage;
the management development server is connected with a test management module, and in one embodiment, the test management module is a front-end application program which is specifically installed on the management development server;
the specific script is deployed in a target server, wherein the target server is a server where a managed database is located;
the specific script of the invention can be deployed on a general basic server system, can be deployed on an all-in-one server which is applied to a database of a specific database manufacturer and is proposed by the manufacturer, such as an Oracle database machine (Oracle Database Appliance) of a Oracle company, or an Oracle database cloud server (Oracle Exadata), and can be deployed on a public cloud server;
when there are a plurality of target servers, in the same network segment, the specific script is distributed to the specific installation directories of the plurality of target servers in a one-key distribution mode;
when the specific script collects data information, the data reporting time is customized and reported to the management development server so as to be called by a test management module connected with the management development server;
the test management module self-defines reporting frequency according to requirements, opens a specific script, and the specific script collects data information of the target server in the whole course and reports the data information to the management development server, and stores the collected data information into a database of the management development server;
preferably, the test management module is further connected with an abnormality notification module; the abnormal notification module notifies an administrator of an abnormal result when the output result of the target server is abnormal;
specifically, the process of the abnormality notification module for performing abnormality result notification includes:
the test management module sets a risk early warning value, and when the result output by the test management module after processing the data information is greater than or equal to the risk early warning value, the test management module indicates that an abnormality exists, and the abnormality notification module notifies an administrator in a mainstream communication mode;
the main stream communication modes comprise short messages, weChat, nails, mails and the like;
it should be noted that, the process of processing the data information and obtaining the output result by the test management module is:
inputting a search code in a specific script, and screening a query result by a test management module;
the test management module intercepts the effective part of the query result, reserves part of useful data segments, and places the part of useful data segments in the test management module;
visual interface presentation is carried out through the REST interface;
for example: when the disk service condition of the Linux operating system is to be inquired, the corresponding operating system code is "df-h", then the "df-h" correlation is compiled in a Shell tool of the Linux operating system, the inquired result is filtered, and the output result is stored in a management development server provided with a front-end application program; and outputting the result by using the front-end application program.
It should be noted that, the result of code finding of the Linux operating system is very many, the invention effectively intercepts part of useful data from the result obtained by inquiry according to the actual application scene, puts the useful data in the column of the corresponding field of the database corresponding to the management development server, presents the result through the REST interface and does not need to enter the server to carry out complicated step inquiry, and the real-time health condition of the target server can be obtained only through the front-end application of the visual interface, thereby saving a large number of steps.
In a specific embodiment, a front-end interface is provided with a hard disk storage utilization percentage which is input and needs to be pre-warned, and a hard disk A (drop-down list box) is selected as an example, and a pre-warning value B; the "DESK_NAME" and the "DESK_VALUE" field columns of the "WAR_DESK" table respectively stored in the database of the management development server;
the method comprises the steps that a server automatically collects a 'DESK_NAME' column VALUE and a 'DESK_USAGE' column VALUE which are obtained by a command df-h|grep '/dev/' |awk-v nn= "$LINE-NUM '=nn { print $x }', and a selection statement is conducted to screen whether the current 'DESK_USAGE' VALUE of a 'hard disk A' is equal to the 'DESK_VALUE' VALUE or not;
if the judgment result is that the VALUE of DESK_USAGE is not less than the VALUE of DESK_VALUE (the cycle monitoring frequency is 5 minutes according to the state report refreshing time), the preset notification mode (short message, micro message, nail and mail) is sent through the notification function of the abnormality notification module.
Wherein WAR_DESK is a hard disk early warning table; DESK_NAME is the hard disk NAME; DESK_VALUE is a hard disk early warning VALUE; DESK_USAGE is the hard disk utilization rate;
in a specific embodiment, the front end interface is provided with a MEMORY usage percentage to be pre-warned, for example, a pre-warning VALUE A, and the MEMORY usage percentage is stored in a MEN_VALUE field column of a WAR_MEMORY table in a database of a management development server;
automatically collecting a 'MEN_TOTAL' column value obtained by a command free|awk-vnn= "$LINE_NUM '″ NR=nn { print $x }' in a script through a server;
performing a division algorithm to obtain a utilization rate MEN_USAGE, and then performing a select statement to screen whether the current MEN_USAGE VALUE and the MEN_USAGE VALUE are equal or not;
if the judgment result is that the MEN_USAGE VALUE is not less than the MEN_VALUE VALUE (the cycle monitoring frequency is 5 minutes according to the state report refreshing time), the preset notification mode (short message, micro message, nail and mail) is sent through the notification function of the abnormality notification module.
Wherein WAR_MENORY is a memory early warning table; MEN_VALUE is a memory early warning VALUE; MEN_TOTAL is the TOTAL memory; MEN_USED is the memory usage; the MEN_USAGE is the memory USAGE.
The database management system supporting the comprehensive server provided by the invention supports all server types: for the hardware of the server, the system can achieve full compatibility, and the adaptation of script acquisition only needs to support an operating system layer. Through our underlying design logic, the present invention also supports this database by employing the native compilation tools of the operating system, which only rely on the operating system, i.e., as long as the operating system supports the use of this database. The invention realizes the full-automatic server management, and for the conditions of downtime, disasters and the like of the server, the manager can immediately and actively send information to inform the manager in the current main stream communication mode, the manager does not need to watch the platform at any time, the manager can receive the notification when the accident happens, and the manager can receive the notification when the task execution is finished perfectly, so that an unattended scene which can be relieved is formed.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
1. The database management system supporting the comprehensive server is characterized by comprising a specific script formed by writing specific script codes through a script compiling tool, a management development server and a test management module connected with the management development server;
the specific script is deployed in the target server and used for realizing data information acquisition of the target server and sending the data information to a database of the management development server for storage;
the test management module is used for processing the data information stored in the management development server database to obtain an output result;
when the output result of the test management module after data information processing is more than or equal to the risk early warning value, the test management module sends an abnormal signal to the abnormal notification module, and the abnormal notification module notifies an administrator.
2. The database management system supporting a full server as recited in claim 1, wherein said risk early warning value is set by a test management module.
3. The database management system supporting a full server according to claim 1, wherein the script compiling tool is a Shell tool of a Linux operating system or a PowerShell tool of a Windows operating system.
4. The database management system supporting a full-scale server as claimed in claim 1, wherein the target server is a server where the managed database is located; when a plurality of target servers exist, the specific script is distributed to the specific installation catalogs of the plurality of target servers in a one-key distribution mode in the same network segment to complete specific script deployment.
5. The database management system supporting a comprehensive server according to claim 1, wherein when the specific script collects data information, the specific script defines data reporting time, and reports the data reporting time to the management development server for the test management module connected with the management development server to call.
6. The database management system supporting a full server according to claim 1, wherein the means for informing the administrator of the abnormality notification module comprises one or more of a short message, a WeChat, a spike, and a mail.
7. The database management system supporting a full server according to claim 1, wherein the process of processing the data information and obtaining the output result by the test management module is as follows:
inputting a search code in a specific script, and screening a query result by a test management module;
the test management module intercepts the effective part of the query result, reserves part of useful data segments, and places the part of useful data segments in the test management module;
visual interface presentation is performed through the REST interface.
8. The database management system supporting a full-scale server according to claim 4, wherein said target server comprises a general-purpose base server system, a all-in-one server adapted to a specific database vendor, or a public cloud server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310227087.5A CN116185997A (en) | 2023-03-10 | 2023-03-10 | Database management system supporting comprehensive server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310227087.5A CN116185997A (en) | 2023-03-10 | 2023-03-10 | Database management system supporting comprehensive server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116185997A true CN116185997A (en) | 2023-05-30 |
Family
ID=86442392
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310227087.5A Pending CN116185997A (en) | 2023-03-10 | 2023-03-10 | Database management system supporting comprehensive server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116185997A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105119757A (en) * | 2015-09-14 | 2015-12-02 | 沈文策 | Method and system for operation and maintenance automation of enterprise servers |
| CN112527584A (en) * | 2020-12-18 | 2021-03-19 | 上海万向区块链股份公司 | Software efficiency improving method and system based on script compiling and data acquisition |
| CN112799909A (en) * | 2021-01-26 | 2021-05-14 | 上海瀚银信息技术有限公司 | Automatic management system and method for server |
| CN113986257A (en) * | 2021-11-12 | 2022-01-28 | 航天信息股份有限公司 | Cloud platform front-end management interface deployment method and device and storage medium |
-
2023
- 2023-03-10 CN CN202310227087.5A patent/CN116185997A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105119757A (en) * | 2015-09-14 | 2015-12-02 | 沈文策 | Method and system for operation and maintenance automation of enterprise servers |
| CN112527584A (en) * | 2020-12-18 | 2021-03-19 | 上海万向区块链股份公司 | Software efficiency improving method and system based on script compiling and data acquisition |
| CN112799909A (en) * | 2021-01-26 | 2021-05-14 | 上海瀚银信息技术有限公司 | Automatic management system and method for server |
| CN113986257A (en) * | 2021-11-12 | 2022-01-28 | 航天信息股份有限公司 | Cloud platform front-end management interface deployment method and device and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 张硕 等: "《软件测试实用案例教程》", 31 January 2020, 华中科技大学出版社, pages: 111 - 121 * |
| 李欣: "《Oracle 9i数据库应用标准教程》", 31 March 2004, 上海科学普及出版社, pages: 269 - 273 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107678907B (en) | Database service logic monitoring method, system and storage medium | |
| US8775591B2 (en) | Real-time information technology environments | |
| CN101151593B (en) | Autonomic computing: management agent utilizing action policy for operation | |
| CN113595761B (en) | Micro-service component optimization method and medium of power system information communication integrated scheduling platform | |
| CN104731580A (en) | Automation operation and maintenance system based on Karaf and ActiveMQ and implement method thereof | |
| CN101848477A (en) | Method and system for diagnosing fault | |
| CN107992392B (en) | Automatic monitoring and repairing system and method for cloud rendering system | |
| CN105373899A (en) | Server asset management method and apparatus | |
| US8112451B1 (en) | Using intensional category assignment for a configuration management database | |
| US20100082388A1 (en) | Method and system for managing information technology (it) infrastructural elements | |
| CN114443435A (en) | Container micro-service oriented performance monitoring alarm method and alarm system | |
| CN105580007A (en) | Monitoring a computing network | |
| CN108052358B (en) | Distributed deployment system and method | |
| CN112579558A (en) | Method, device, storage medium and equipment for displaying topological graph | |
| CN109597764A (en) | A kind of test method and relevant apparatus of catalogue quota | |
| US20050096774A1 (en) | System and method for integrating transactional and real-time manufacturing data | |
| CN110795332A (en) | Automatic testing method and device | |
| CN102571413A (en) | Method for resource management under cluster environment | |
| WO2021012565A1 (en) | Business system test method and apparatus, device, and storage medium | |
| CN113094053A (en) | Product delivery method and device and computer storage medium | |
| CN104967532A (en) | TOC technology operation and maintenance system and application method | |
| US7281165B2 (en) | System and method for performing product tests utilizing a single storage device | |
| CN104951855A (en) | Apparatus and method for improving resource management | |
| CN114356654A (en) | Backup system, backup method, backup device, computer device, and storage medium | |
| CN101510156A (en) | Information system resource recovery method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |