CN113268479A - Computer database cloud debugging and maintenance system - Google Patents
Computer database cloud debugging and maintenance system Download PDFInfo
- Publication number
- CN113268479A CN113268479A CN202110746486.3A CN202110746486A CN113268479A CN 113268479 A CN113268479 A CN 113268479A CN 202110746486 A CN202110746486 A CN 202110746486A CN 113268479 A CN113268479 A CN 113268479A
- Authority
- CN
- China
- Prior art keywords
- data
- maintenance
- module
- database
- error
- 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
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/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
Abstract
The invention discloses a cloud debugging and maintaining system for a computer database, which comprises a user login end, a database detection end, a cloud server, a system maintenance data recording end, a background maintenance end and a data commissioning end, wherein the user login end is connected with the database detection end through a network; the system comprises a user login end, a database, a cloud server, a system maintenance data recording end, a background maintenance end, a database detection end, a background maintenance end and a data trial operation end, wherein the user login end is connected with the database, the database is connected with the cloud server, the cloud server is respectively connected with the system maintenance data recording end and the background maintenance end, the database detection end is respectively connected with the database and the cloud server, the background maintenance end is connected with the data trial operation end, and the data trial operation end is connected with the system maintenance data recording end; the system maintenance log generation module and the system maintenance log storage module are used for storing the error data and the maintenance data, and then when the same error data is encountered later, the error data can be automatically maintained through the system maintenance data recording end, so that the safety of the database is guaranteed, and the cloud debugging and maintenance efficiency of the database is improved.
Description
Technical Field
The invention relates to the technical field of database cloud debugging, in particular to a computer database cloud debugging and maintaining system.
Background
A database is a "warehouse that organizes, stores, and manages data according to a data structure. The method is a large-volume data set which is stored in a computer for a long time, organized, sharable and uniformly managed, but when the computer database is used for a long time, system errors with large and small sizes can easily occur, so that the computer database cannot be normally used.
Therefore, a computer database cloud debugging and maintaining system is provided.
Disclosure of Invention
The invention aims to provide a computer database cloud debugging and maintaining system to solve the problems in the background technology.
In order to achieve the purpose, the invention provides the following technical scheme: a computer database cloud debugging and maintaining system comprises a user login end, a database detection end, a cloud server, a system maintenance data recording end, a background maintenance end and a data test operation end; the system comprises a user login end, a database, a cloud server, a system maintenance data recording end, a background maintenance end, a database detection end, a background maintenance end and a data trial operation end, wherein the user login end is connected with the database, the database is connected with the cloud server, the cloud server is respectively connected with the system maintenance data recording end and the background maintenance end, the database detection end is respectively connected with the database and the cloud server, the background maintenance end is connected with the data trial operation end, and the data trial operation end is connected with the system maintenance data recording end;
the system maintenance data recording end comprises an error data recording module, a maintenance data recording module, an error data matching module and a maintenance data calling-out module; the system maintenance data recording end records and stores error data and maintenance data respectively, when the error data is detected again, the current maintenance data is called automatically and maintained quickly, and common system errors are maintained more conveniently and quickly, so that the condition that the normal use of the system is influenced is avoided;
the data commissioning end comprises an error data import module, a maintenance data import module, a data maintenance result export module, a maintenance data modification module and a maintenance data export module;
when a new system error occurs at the data trial operation end, the wrong system data is imported, the maintenance data is imported, the system error data is subjected to trial operation maintenance, after the trial operation maintenance is finished, the maintenance result is exported, the maintenance result is analyzed and judged, when the maintenance data cannot comprehensively maintain the system error, the maintenance data is modified through the maintenance data modification module, then the trial operation maintenance is carried out again until the maintenance data can maintain the system error, and then the maintenance data is imported into the system maintenance data recording end through the maintenance data export module, so that the system data can be maintained subsequently.
Preferably: the cloud server comprises a data storage module, a data modification module, a data backup module, a system maintenance log generation module and a system maintenance log storage module;
the data backup module is used for automatically backing up files in the database; through the arrangement, the data in the database are automatically backed up, and the condition of data loss is avoided.
Preferably: the system maintenance log generation module and the system maintenance log storage module are used for recording and storing data generated during maintenance, so that the subsequent system maintenance is facilitated; through the arrangement, the maintained data can be stored, so that the data can be maintained automatically when the same error data is encountered next time, and the working efficiency is improved.
Preferably: the user login end comprises a user login module and a short message verification module;
the user login module logs in through the account and the password of the user, and the system sends short message verification to the mobile phone number reserved when the user logs in to the account, so that the user is ensured to log in, and the safety of the user account is improved; through the arrangement, the mode of short message verification can ensure that the user can log in the database, so that the safety of the database is improved.
Preferably: the database detection end comprises a timing self-detection module, a data detection module and a data comparison module;
the timing self-detection module carries out automatic database detection at a time interval set by a user, so that some potential dangers can be found, and the normal operation of the database is guaranteed; through the arrangement, automatic regular automatic detection can be carried out on the database, the safety of the database is improved, and the condition that the database cannot be normally used due to a large number of data errors inside the database is avoided.
Preferably: the data detection module is used for comprehensively detecting data in the database, comparing the suspicious data with normal data through the data comparison module after the suspicious data are detected, judging whether the data are dangerous or not, and sending the data into the cloud server for more comprehensive detection if the data are dangerous; through the arrangement, the method and the device are used for comprehensively detecting the data in the database.
Preferably: the background maintenance end comprises an error data export module and an error data analysis module; through the arrangement, the wrong system data can be comprehensively analyzed and processed.
Preferably: the error data export module is used for exporting the error data of the system so as to be convenient for researching the error data, and the error data analysis module is used for analyzing the error data of the system so as to find out the root cause of the error; through the arrangement, the root cause of the error data error is convenient to find, so that the error data error is maintained.
Compared with the prior art, the invention has the beneficial effects that:
1. the system maintenance log generation module and the system maintenance log storage module are used for storing the error data and the maintenance data, and then when the same error data is encountered later, the error data can be automatically maintained through the system maintenance data recording end, so that the safety of the database is guaranteed, and the cloud debugging and maintenance efficiency of the database is improved.
2. The data commissioning end can maintain wrong system data for multiple times through the maintenance data, when the maintenance data cannot perfectly maintain the wrong system data, the maintenance data is modified through the maintenance data modification module until the wrong system data is comprehensively maintained, the safety of database maintenance is guaranteed, the situation that the maintenance data cannot efficiently maintain the wrong system data is avoided, and the efficiency of cloud debugging and maintenance of the database is improved.
Drawings
FIG. 1 is a flow chart of the system of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Examples
Referring to fig. 1, the present invention provides a technical solution: a computer database cloud debugging and maintaining system comprises a user login end, a database detection end, a cloud server, a system maintenance data recording end, a background maintenance end and a data test operation end;
the system comprises a user login end, a database, a cloud server, a system maintenance data recording end, a background maintenance end, a database detection end, a data trial operation end and a system maintenance data recording end, wherein the user login end is connected with the database;
the system maintenance data recording end comprises an error data recording module, a maintenance data recording module, an error data matching module and a maintenance data calling-out module;
the system maintenance data recording end records and stores the error data and the maintenance data respectively, when the error data is detected again, the current maintenance data is called automatically and maintained rapidly, and some common system errors are maintained more conveniently and rapidly, so that the condition that the normal use of the system is influenced is avoided;
the data commissioning end comprises an error data import module, a maintenance data import module, a data maintenance result export module, a maintenance data modification module and a maintenance data export module;
when a new system error occurs at the data trial operation end, the wrong system data is imported, the maintenance data is imported, the system error data is subjected to trial operation maintenance, after the trial operation maintenance is finished, the maintenance result is exported, the maintenance result is analyzed and judged, when the maintenance data cannot comprehensively maintain the system error, the maintenance data is modified through the maintenance data modification module, then the trial operation maintenance is carried out again until the maintenance data can maintain the system error, and then the maintenance data is imported into the system maintenance data recording end through the maintenance data export module, so that the system data can be maintained subsequently.
In this embodiment, specifically: the cloud server comprises a data storage module, a data modification module, a data backup module, a system maintenance log generation module and a system maintenance log storage module;
the data backup module is used for automatically backing up files in the database; through the arrangement, the data in the database are automatically backed up, and the condition that the database cannot be normally used due to data loss is avoided.
In this embodiment, specifically: the system maintenance log generation module and the system maintenance log storage module are used for recording and storing data generated during maintenance, so that the subsequent system maintenance is facilitated; through the arrangement, data generated during system maintenance can be recorded and stored, and when corresponding system errors are encountered next time, the maintenance data at that time can be used for maintenance.
In this embodiment, specifically: the user login end comprises a user login module and a short message verification module;
the user login module logs in through the account and the password of the user, and the system sends short message verification to the mobile phone number reserved when the user logs in, so that the user is ensured to log in, and the safety of the user account is improved; through the setting, the login account can be ensured to be operated by the user through the short message verification mode, and the safety of the account is ensured.
In this embodiment, specifically: the database detection end comprises a timing self-detection module, a data detection module and a data comparison module;
the timing self-detection module carries out automatic database detection at a time interval set by a user, so that some potential dangers can be found, and the normal operation of the database is guaranteed; through the arrangement, the database can be regularly detected, so that the situation that the normal use of the database is seriously influenced due to more system errors caused by long-time non-detection of the database is avoided.
In this embodiment, specifically: the data detection module is used for comprehensively detecting data in the database, comparing the suspicious data with normal data through the data comparison module after the suspicious data are detected, judging whether the data are dangerous or not, and sending the data into the cloud server for more comprehensive detection if the data are dangerous; through the arrangement, the database can be conveniently and regularly detected, and the data security is guaranteed.
In this embodiment, specifically: the background maintenance end comprises an error data export module and an error data analysis module; through the arrangement, the data of system errors can be analyzed more conveniently.
In this embodiment, specifically: the error data export module is used for exporting the error data of the system so as to be convenient for researching the error data, and the error data analysis module is used for analyzing the error data of the system so as to find out the root cause of the error; through the arrangement, the system error data can be comprehensively analyzed, so that the error reason can be found out, and the system maintenance is facilitated.
Working principle or structural principle: the user uses the user login module to input an account number and a password, so that the short message verification module sends a verification short message to a reserved mobile phone number, thereby ensuring that the user can log in the database, the user can use the data in the database after logging in the database, meanwhile, when the database runs, the regular automatic detection is carried out on the data in the database through the timing self-detection module, after suspicious data is detected, the suspicious data is compared through the data comparison module, if the suspicious data is dangerous, the suspicious data is sent to the inside of the cloud processor, the data is stored through the cloud processor, then a system maintenance log is called out, so that the suspicious data is compared with the previous system error data, if the suspicious data is found to be the error data maintained before, the data can be sent to the inside of a system maintenance data recording terminal, the method comprises the steps of proportioning suspicious data, calling out previously maintained data to maintain the suspicious data and guarantee the safety of a database, sending new error data to the interior of a background maintenance end if a cloud database cannot find error data matched with the cloud database, analyzing the new error data through an error data export module and an error data analysis module to find the root cause of an error, sending the error data to the interior of a data commissioning end, sending maintenance data into the interior of the data commissioning end, maintaining the new error data, exporting maintenance results after maintenance is finished, analyzing and processing the maintenance results, and modifying the error data through a maintenance data modification module if the maintenance data cannot maintain the error data, and then performing trial operation again until the error data is completely maintained, and then sending the maintenance data and the error data to the inside of the system maintenance data recording end for storage, so that the system maintenance can be automatically performed when the error data is encountered next time, and the working efficiency of the system maintenance is improved.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (8)
1. The utility model provides a computer database cloud debugging maintenance system, includes user login end, database detection end, high in the clouds server, system maintenance data record end, backstage maintenance end and data test operation end, its characterized in that:
the system comprises a user login end, a database, a cloud server, a system maintenance data recording end, a background maintenance end, a database detection end, a background maintenance end and a data trial operation end, wherein the user login end is connected with the database, the database is connected with the cloud server, the cloud server is respectively connected with the system maintenance data recording end and the background maintenance end, the database detection end is respectively connected with the database and the cloud server, the background maintenance end is connected with the data trial operation end, and the data trial operation end is connected with the system maintenance data recording end; the system maintenance data recording end comprises an error data recording module, a maintenance data recording module, an error data matching module and a maintenance data calling-out module;
the system maintenance data recording end records and stores error data and maintenance data respectively, when the error data is detected again, the current maintenance data is called automatically and maintained quickly, and some common system errors are maintained more conveniently and quickly; the data commissioning end comprises an error data import module, a maintenance data import module, a data maintenance result export module, a maintenance data modification module and a maintenance data export module;
and when a new system error occurs at the data trial operation end, the wrong system data is imported, the maintenance data is imported, the system error data is subjected to trial operation maintenance, after the trial operation maintenance is finished, the maintenance result is exported, and the maintenance result is analyzed and judged.
2. The computer database cloud debugging maintenance system of claim 1, wherein: the cloud server comprises a data storage module, a data modification module, a data backup module, a system maintenance log generation module and a system maintenance log storage module;
the data backup module is used for automatically backing up files in the database.
3. The computer database cloud debugging maintenance system of claim 2, wherein: the system maintenance log generation module and the system maintenance log storage module are used for recording and storing data generated during maintenance.
4. The computer database cloud debugging maintenance system of claim 1, wherein: the user login end comprises a user login module and a short message verification module;
the user login module logs in through the account and the password of the user, and the system sends short message verification to the mobile phone number reserved when the user logs in to the account, so that the user can be ensured to log in.
5. The computer database cloud debugging maintenance system of claim 1, wherein: the database detection end comprises a timing self-detection module, a data detection module and a data comparison module;
the timing self-detection module carries out automatic database detection at a time interval set by a user.
6. The computer database cloud debugging maintenance system of claim 5, wherein: the data detection module is used for comprehensively detecting data in the database, after suspicious data are detected, the data are compared with normal data through the data comparison module to judge whether the data are dangerous or not, and if the data are dangerous, the data are sent to the inside of the cloud server to be more comprehensively detected.
7. The computer database cloud debugging maintenance system of claim 1, wherein: the background maintenance end comprises an error data export module and an error data analysis module.
8. The computer database cloud debugging maintenance system of claim 7, wherein: the error data export module is used for exporting the error data of the system, and the error data analysis module is used for analyzing the error data of the system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110746486.3A CN113268479A (en) | 2021-07-02 | 2021-07-02 | Computer database cloud debugging and maintenance system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110746486.3A CN113268479A (en) | 2021-07-02 | 2021-07-02 | Computer database cloud debugging and maintenance system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113268479A true CN113268479A (en) | 2021-08-17 |
Family
ID=77236342
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110746486.3A Pending CN113268479A (en) | 2021-07-02 | 2021-07-02 | Computer database cloud debugging and maintenance system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113268479A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103825758A (en) * | 2014-01-09 | 2014-05-28 | 国家电网公司 | Fault processing method for electric power communication network operation monitoring system |
| US20150358296A1 (en) * | 2014-06-09 | 2015-12-10 | Royal Canadian Mint/Monnaie Royale Canadienne | Cloud-based secure information storage and transfer system |
| US20170351716A1 (en) * | 2016-06-07 | 2017-12-07 | Oracle International Corporation | Resource allocation for database provisioning |
| CN110673830A (en) * | 2019-08-23 | 2020-01-10 | 安徽嘉亨软件开发有限公司 | Job task issuing device for software development |
| CN111831627A (en) * | 2020-07-24 | 2020-10-27 | 上海辕投信息科技有限公司 | Computer database cloud debugging and maintenance system |
-
2021
- 2021-07-02 CN CN202110746486.3A patent/CN113268479A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103825758A (en) * | 2014-01-09 | 2014-05-28 | 国家电网公司 | Fault processing method for electric power communication network operation monitoring system |
| US20150358296A1 (en) * | 2014-06-09 | 2015-12-10 | Royal Canadian Mint/Monnaie Royale Canadienne | Cloud-based secure information storage and transfer system |
| US20170351716A1 (en) * | 2016-06-07 | 2017-12-07 | Oracle International Corporation | Resource allocation for database provisioning |
| CN110673830A (en) * | 2019-08-23 | 2020-01-10 | 安徽嘉亨软件开发有限公司 | Job task issuing device for software development |
| CN111831627A (en) * | 2020-07-24 | 2020-10-27 | 上海辕投信息科技有限公司 | Computer database cloud debugging and maintenance system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111641601A (en) | Firewall management method, device, equipment and storage medium | |
| CN111244806B (en) | Power equipment safety debugging monitoring system and processing method | |
| CN109473945A (en) | A kind of verification of relay protection model data and method of automatic configuration | |
| CN114785613A (en) | Method and system for processing safety alarm event based on automatic arrangement | |
| CN115658420A (en) | Database monitoring method and system | |
| KR102059688B1 (en) | Cyber blackbox system and method thereof | |
| CN116861430B (en) | Malicious file detection method, device, equipment and medium | |
| CN113268479A (en) | Computer database cloud debugging and maintenance system | |
| CN111062503B (en) | Power grid monitoring alarm processing method, system, terminal and storage medium | |
| CN111931012A (en) | Data model self-adaption method and device based on fault management subsystem | |
| CN112444697A (en) | Power line information monitoring system and method | |
| CN111831627A (en) | Computer database cloud debugging and maintenance system | |
| CN113392079A (en) | Distributed storage cluster log storage optimization method, system and terminal | |
| CN113884943B (en) | Leakage fault analysis method, device, equipment and medium | |
| CN116302989A (en) | Pressure testing method and system, storage medium and computer equipment | |
| CN116230067A (en) | Automatic testing method, system, equipment and medium for solid state disk | |
| CN113285824B (en) | Method and device for monitoring security of network configuration command | |
| CN112653935A (en) | 5G base station is power for equipment with prevent invading automatic restoration function | |
| CN112395619A (en) | Vulnerability scanning method and device | |
| CN113076355A (en) | Method for sensing data security flow situation | |
| CN112712443A (en) | Event analysis method and analysis device for converter station | |
| CN111934949A (en) | Safety test system based on database injection test | |
| CN116980285B (en) | Data processing-based intelligent detection response method, system and medium for resident operation and maintenance | |
| CN112463163B (en) | Method and device for realizing quick positioning of function module code problem | |
| CN112367324B (en) | CDN attack detection method and device, storage medium and electronic equipment |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210817 |
|
| RJ01 | Rejection of invention patent application after publication |