CN101430688A - Database automatic detection system and its operation method - Google Patents
Database automatic detection system and its operation method Download PDFInfo
- Publication number
- CN101430688A CN101430688A CNA2008100721480A CN200810072148A CN101430688A CN 101430688 A CN101430688 A CN 101430688A CN A2008100721480 A CNA2008100721480 A CN A2008100721480A CN 200810072148 A CN200810072148 A CN 200810072148A CN 101430688 A CN101430688 A CN 101430688A
- Authority
- CN
- China
- Prior art keywords
- database
- server
- case
- detection
- operating terminal
- 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
Abstract
The invention discloses an automatic database detection system and an operation method thereof. The detection system comprises a database server, a web server, a database detection server, an operating terminal and a detection database; the database server is connected with the web server, the database server is connected with the database detection server which is further connected with the detection database, and the operating terminal is connected with the web server. The method and the system stop the problems that a running state of the database can only be checked by checking a database log during the database detection and that only people can judge whether the database is normal.
Description
Technical field
The present invention relates to a kind of data base automatic Detection Techniques field.
Background technology
Along with being growing more intense of mobile communication market competition, mobile communication enterprise recognizes that more and more the customer service quality is the most important core competitiveness of enterprise, must be customer-centric, obtain higher customer satisfaction and loyalty, could in competition, stand on the invincible position.Yet for the various faults of BOSS often all be lodge a complaint by the client after, just pinpoint the problems, go to solve fault again.The client can be descended to some extent to the satisfaction and the loyalty of enterprise, make in the competition of enterprise and stamp discount.
The database volume of present mobile Boss system is huge, every day is all with millions of the increase that is recorded in, when increasing, also do operations such as inquiry, renewal, deletion and backup frequent, the stability of database and reliability are the key factors that can the Boss system normal operation, therefore in order to reflect ruuning situation, running status and the stability of database fast, just necessary to the detection of these databases.
Summary of the invention
The purpose of this invention is to provide a kind of database automatic detection system and operation method thereof, it can carry out the detection of database automatically, the user only need dispose the configuration information of corresponding connection database and uninterrupted automatic database detection in 24 hours can be realized in the sql statement of execution database, and the time of recorded data storehouse response, and the object information of carrying out the sql statement.
The present invention is achieved in that a kind of database automatic detection system, comprises database server, web server, database detecting server, operating terminal, detection data storehouse; Described database server links to each other with the web server, and described database server is connected with the database detecting server, and described database detecting server also links to each other with the detection data storehouse, and described operating terminal is connected with the web server;
All configuration informations are preserved in configuration working time of the task that described database server preserves case information that all databases survey, preserve case, and the object information of preserving the case operation;
Described Web server provides an operation interface, surveys case, backstage service case operation task and the information exhibition of backstage service result of detection thereby better edit the backstage service for the user;
Described database detecting server is surveyed the task configuration information of case according to database, come the uniform dispatching database to survey case and in corresponding detection data storehouse, carry out the sql statement, and judge whether carry out content that the sql statement returns correctly drives next step detection;
Described detection data storehouse comprises supports all to comprise relationship type and non-relational database, as Oracle, SQL Server, DB2, TeraData by the database of odbc or unixodbc or ado or dbx visit;
Described operating terminal is user's a operation interface, is used for database and surveys the configuration of case and the setting of detection mission;
For system is effectively moved, the invention provides a kind of operation method of above-mentioned database automatic detection system, it is characterized in that:
Realize according to the following steps:
Step 1, the operating terminal configuration database is surveyed case;
Step 2, the operating terminal configuration database is surveyed the task of case operation, comprises the time set of operation, and concrete minute, hour, day, month, year can be set;
Step 3, matched task time, and the database detecting server moves this detection case;
Step 4, the database that connection will be surveyed
Step 5 judges whether successful connection, continues next step operation after the successful connection;
Step 6 in the database that will survey, is carried out the operation of sql statement;
Step 7 judges whether successful the sql statement is carried out;
Step 8, detection finish and the result are saved in the database server.
The present invention remedied database and surveyed and can only check that the mode of database journal checks the running status of database, and remedied can only be artificial whether carry out the judgment data storehouse normal.
The present invention will be further described below in conjunction with drawings and Examples.
Description of drawings
Fig. 1 is a system architecture synoptic diagram of the present invention.
Fig. 2 is the workflow diagram of the embodiment of the invention.
Embodiment
As shown in Figure 1, the invention discloses a kind of database automatic detection system, comprise database server, web server, database detecting server, operating terminal, detection data storehouse; Described database server links to each other with the web server, described database server is connected with the database detecting server, and described database detecting server also links to each other with the detection data storehouse, described operating terminal is connected with the web server;
All configuration informations are preserved in configuration working time of the task that described database server preserves case information that all databases survey, preserve case, and the object information of preserving the case operation;
Described Web server provides an operation interface, surveys case, backstage service case operation task and the information exhibition of backstage service result of detection thereby better edit the backstage service for the user;
Described database detecting server is surveyed the task configuration information of case according to database, come the uniform dispatching database to survey case and in corresponding detection data storehouse, carry out the sql statement, and judge whether carry out content that the sql statement returns correctly drives next step detection;
Described detection data storehouse comprises supports all to comprise relationship type and non-relational database, as Oracle, SQL Server, DB2, TeraData by the database of odbc/unixodbc/ado/dbx visit;
Described operating terminal is user's a operation interface, is used for database and surveys the configuration of case and the setting of detection mission;
For above-mentioned database automatic detection system can well be worked, the invention provides a kind of operation method of this system, it is characterized in that:
Realize according to the following steps:
Step 1, the operating terminal configuration database is surveyed case;
Step 2, the operating terminal configuration database is surveyed the task of case operation, comprises the time set of operation, can be provided with concrete
Minute, hour, day, month, year;
Step 3, matched task time, and the database detecting server moves this detection case;
Step 4, the database that connection will be surveyed
Step 5 judges whether successful connection, continues next step operation after the successful connection;
Step 6 in the database that will survey, is carried out the operation of sql statement;
Step 7 judges whether successful the sql statement is carried out;
Step 8, detection finish and the result are saved in the database server.
Be example to survey the kpi database below, operation steps is carried out the sql statement in kpi one-level customer service database: select ' one-level customer service file is not uploaded ' as cnt from app_alarm where app_id in (1133,1134,1135,1136) andcurrent_val 〉=1 and total_time〉60.
As shown in Figure 2, the concrete steps of detection kpi database are as follows:
Step 1, operating terminal configuration database detection _ Kpi_ one-level customer service case;
Step 2, the operating terminal configuration database is surveyed the task (time set of operation can be provided with concrete minute, hour, day, month, year) of case operation;
Step 3, matched task time, and the database detecting server moves this detection case;
Step 4 connects the kpi database
Step 5 judges whether successful connection, continues next step operation after the successful connection;
Step 6 in the kpi database, is carried out the operation of sql statement;
Step 7 judges whether successful the sql statement is carried out;
Step 8, detection finish and the result are saved in the database server;
So far, the flow process of database detection finishes.
The present invention can carry out the detection of database automatically, the user only need dispose the configuration information of corresponding connection database and uninterrupted automatic database detection in 24 hours can be realized in the sql statement of execution database, and the time of recorded data storehouse response (being accurate to millisecond), and the object information of carrying out the sql statement.Remedied database and survey and can only check that the mode of database journal checks the running status of database, and remedied can only be artificial whether carry out the judgment data storehouse normal.
Claims (2)
1, a kind of database automatic detection system comprises database server, web server, database detecting server, operating terminal, detection data storehouse; Described database server links to each other with the web server, and described database server is connected with the database detecting server, and described database detecting server also links to each other with the detection data storehouse, and described operating terminal is connected with the web server;
All configuration informations are preserved in configuration working time of the task that described database server preserves case information that all databases survey, preserve case, and the object information of preserving the case operation;
Described Web server provides an operation interface, surveys case, backstage service case operation task and the information exhibition of backstage service result of detection thereby better edit the backstage service for the user;
Described database detecting server is surveyed the task configuration information of case according to database, come the uniform dispatching database to survey case and in corresponding detection data storehouse, carry out the sql statement, and judge whether carry out content that the sql statement returns correctly drives next step detection;
Described detection data storehouse comprises supports all to comprise relationship type and non-relational database, as Oracle, SQL Server, DB2, TeraData by the database of odbc or unixodbc or ado or dbx visit;
Described operating terminal is user's a operation interface, is used for database and surveys the configuration of case and the setting of detection mission.
2, a kind of operation method of database automatic detection system as claimed in claim 1 is characterized in that:
Realize according to the following steps:
Step 1, the operating terminal configuration database is surveyed case;
Step 2, the operating terminal configuration database is surveyed the task of case operation, comprises the time set of operation, and concrete minute, hour, day, month, year can be set;
Step 3, matched task time, and the database detecting server moves this detection case;
Step 4, the database that connection will be surveyed
Step 5 judges whether successful connection, continues next step operation after the successful connection;
Step 6 in the database that will survey, is carried out the operation of sql statement;
Step 7 judges whether successful the sql statement is carried out;
Step 8, detection finish and the result are saved in the database server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100721480A CN101430688A (en) | 2008-11-18 | 2008-11-18 | Database automatic detection system and its operation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100721480A CN101430688A (en) | 2008-11-18 | 2008-11-18 | Database automatic detection system and its operation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101430688A true CN101430688A (en) | 2009-05-13 |
Family
ID=40646093
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008100721480A Pending CN101430688A (en) | 2008-11-18 | 2008-11-18 | Database automatic detection system and its operation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101430688A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103299267A (en) * | 2010-12-20 | 2013-09-11 | 销售力网络公司 | Methods and systems for performing cross store joins in a multi-tenant store |
| CN103324656A (en) * | 2012-03-22 | 2013-09-25 | 乐金信世股份有限公司 | Database management method and database management server thereof |
| CN103870377A (en) * | 2012-12-11 | 2014-06-18 | 深圳市腾讯计算机系统有限公司 | Method and device for detecting MySQL operation information |
| US9507822B2 (en) | 2010-04-19 | 2016-11-29 | Salesforce.Com, Inc. | Methods and systems for optimizing queries in a database system |
| CN109947772A (en) * | 2018-09-07 | 2019-06-28 | 网联清算有限公司 | Database automatic switching method, device, storage medium and computer equipment |
-
2008
- 2008-11-18 CN CNA2008100721480A patent/CN101430688A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9507822B2 (en) | 2010-04-19 | 2016-11-29 | Salesforce.Com, Inc. | Methods and systems for optimizing queries in a database system |
| US10162851B2 (en) | 2010-04-19 | 2018-12-25 | Salesforce.Com, Inc. | Methods and systems for performing cross store joins in a multi-tenant store |
| US10649995B2 (en) | 2010-04-19 | 2020-05-12 | Salesforce.Com, Inc. | Methods and systems for optimizing queries in a multi-tenant store |
| CN103299267A (en) * | 2010-12-20 | 2013-09-11 | 销售力网络公司 | Methods and systems for performing cross store joins in a multi-tenant store |
| CN103299267B (en) * | 2010-12-20 | 2016-05-18 | 销售力网络公司 | The method and system connecting for carrying out the interleaved of many tenant's storages |
| CN103324656A (en) * | 2012-03-22 | 2013-09-25 | 乐金信世股份有限公司 | Database management method and database management server thereof |
| CN103324656B (en) * | 2012-03-22 | 2018-09-25 | 乐金信世股份有限公司 | Data base management method and its Database Administration Server |
| CN103870377A (en) * | 2012-12-11 | 2014-06-18 | 深圳市腾讯计算机系统有限公司 | Method and device for detecting MySQL operation information |
| CN109947772A (en) * | 2018-09-07 | 2019-06-28 | 网联清算有限公司 | Database automatic switching method, device, storage medium and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103941675B (en) | Safety monitoring based on wireless network manages system | |
| CN108491422B (en) | Database automation operation and maintenance management method, server and storage medium | |
| CN101430688A (en) | Database automatic detection system and its operation method | |
| US8135610B1 (en) | System and method for collecting and processing real-time events in a heterogeneous system environment | |
| US20050165817A1 (en) | Data migration and analysis | |
| CN101470887A (en) | Credit early-warning system and method | |
| CN104574196A (en) | Automatic field data acquisition management system for crops | |
| CN104618948A (en) | File uploading monitoring method and system | |
| CN1971556A (en) | System and method to realize database upgrading in background management system | |
| CN112465582A (en) | Rental equipment working condition monitoring and management system | |
| CN105208627A (en) | Method for automatically accessing wireless local area network | |
| CN111181775B (en) | Integrated operation and maintenance management alarm method based on automatic host asset discovery | |
| CN1980153A (en) | System and method to manage changes to computer system | |
| US9158614B2 (en) | Service management device, display method, and information storage medium | |
| CN102281310B (en) | Method for monitoring on-line state of vehicle-mounted global positioning system (GPS) terminal in real time | |
| US7281165B2 (en) | System and method for performing product tests utilizing a single storage device | |
| CN111324480B (en) | Large-scale host transaction fault positioning system and method | |
| Vidovic et al. | Dynamic business process modelling using ARIS | |
| US20120023078A1 (en) | Non-destructive data storage | |
| JP2009025864A (en) | Repair information processing system and repair information processing program of multiple dwelling houses, and recording medium | |
| CN107783870A (en) | A kind of server-compatible test result management method and system | |
| CN101155380A (en) | Integrating system and method for wireless network test data | |
| KR101640870B1 (en) | Log management system and method thereof | |
| CN114237959A (en) | Robot life cycle management method, device, terminal and storage medium | |
| CN110838006B (en) | Test system for universal device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20090513 |