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
- detection
- server
- case
- sql statement
- 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
- 238000001514 detection method Methods 0.000 title claims abstract description 89
- 238000000034 method Methods 0.000 title claims description 6
- 238000011017 operating method Methods 0.000 abstract description 2
- 238000010295 mobile communication Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
一种数据库自动化探测系统及其运行方法，包括数据库服务器、web服务器、数据库探测服务器、操作终端、探测数据库；所述数据库服务器与web服务器相连、所述的数据库服务器与数据库探测服务器连接，所述的数据库探测服务器还与探测数据库相连、所述的操作终端与web服务器连接；本发明弥补了数据库探测只能通过查看数据库日志的方式来查看数据库的运行状态，并且弥补了只能人为的进行判断数据库是否正常。
A database automatic detection system and its operating method, comprising a database server, a web server, a database detection server, an operating terminal, and a detection database; the database server is connected to the web server, the database server is connected to the database detection server, and the The database detection server is also connected with the detection database, and the operation terminal is connected with the web server; the present invention makes up for the fact that the database detection can only check the operating status of the database by checking the database log, and makes up for the fact that it can only be judged manually Whether the database is normal.
Description
技术领域 technical field
本发明涉及一种数据库自动化探测技术领域。The invention relates to the technical field of database automatic detection.
背景技术 Background technique
随着移动通信市场竞争的日趋激烈，移动通信企业越来越意识到客户服务质量是企业最重要的核心竞争力，必须以客户为中心，获取较高的客户满意度和忠诚度，才能在竞争中立于不败之地。然而对于BOSS的各种故障往往都是由客户投拆后，才发现问题，再去解决故障。这样使客户对企业的满意度和忠诚度都会有所下降，使企业的竞争上打上折扣。With the increasingly fierce competition in the mobile communication market, mobile communication companies are increasingly aware that customer service quality is the most important core competitiveness of enterprises. They must focus on customers and obtain high customer satisfaction and loyalty in order to compete in the competition. Neutrality is invincible. However, for various failures of BOSS, it is often discovered by the customer after the customer votes and removes the problem, and then solves the failure. In this way, the customer's satisfaction and loyalty to the enterprise will decrease, and the competition of the enterprise will be discounted.
目前移动Boss系统的数据库容量巨大，每天都以数百万条的记录在增加，在增加的同时还在频繁的做查询、更新、删除和备份等操作，数据库的稳定性和可靠性是Boss系统能否正常运作的重要因素，因此为了能快速的反映出数据库的运行情况、运行状态以及稳定性，对这些数据库的探测就很有必要了。At present, the database capacity of the mobile Boss system is huge, and millions of records are increasing every day. At the same time, operations such as query, update, deletion and backup are performed frequently. The stability and reliability of the database are the key factors of the Boss system. It is an important factor for the normal operation of the database, so in order to quickly reflect the operation, operation status and stability of the database, it is necessary to detect these databases.
发明内容 Contents of the invention
本发明的目的是提供一种数据库自动化探测系统及其运行方法，其能自动进行数据库的探测，用户只需配置相应的连接数据库的配置信息以及执行数据库的sql语句即可实现24小时不间断的自动数据库探测，并可记录数据库响应的时间，以及执行sql语句的结果信息。The purpose of the present invention is to provide a database automatic detection system and its operating method, which can automatically detect the database, and the user only needs to configure the corresponding configuration information for connecting to the database and execute the sql statement of the database to realize 24-hour uninterrupted Automatic database detection, and can record the time of database response and the result information of executing sql statement.
本发明是这样实现的，一种数据库自动化探测系统，包括数据库服务器、web服务器、数据库探测服务器、操作终端、探测数据库；所述数据库服务器与web服务器相连，所述的数据库服务器与数据库探测服务器连接，所述的数据库探测服务器还与探测数据库相连，所述的操作终端与web服务器连接；The present invention is achieved in this way, a database automatic detection system, including a database server, a web server, a database detection server, an operating terminal, and a detection database; the database server is connected to the web server, and the database server is connected to the database detection server , the database detection server is also connected to the detection database, and the operation terminal is connected to the web server;
所述的数据库服务器保存所有数据库探测的案例信息、保存案例的任务的运行时间配置，保存所有的配置信息，以及保存案例运行的结果信息；The database server saves all database detection case information, saves the running time configuration of the task of the case, saves all configuration information, and saves the result information of the case operation;
所述的Web服务器提供了一个操作界面，从而给用户更好的编辑后台服务探测案例、后台服务案例运行任务、以及后台服务探测结果信息展示；The web server provides an operation interface, so as to better edit background service detection cases, background service case running tasks, and background service detection result information display for users;
所述的数据库探测服务器根据数据库探测案例的任务配置信息，来统一调度数据库探测案例到相应的探测数据库中去执行sql语句，并判断执行sql语句返回的内容是否正确来驱动下一步的探测；According to the task configuration information of the database detection case, the database detection server uniformly dispatches the database detection case to the corresponding detection database to execute the sql statement, and judges whether the content returned by the execution sql statement is correct to drive the next step of detection;
所述的探测数据库包括支持所有能通过odbc或unixodbc或ado或dbx访问的数据库，包括关系型和非关系型数据库，如Oracle、SQL Server、DB2、TeraData；Described detection database comprises supporting all databases that can be accessed by odbc or unixodbc or ado or dbx, including relational and non-relational databases, such as Oracle, SQL Server, DB2, TeraData;
所述的操作终端为用户的操作界面，用于数据库探测案例的配置以及探测任务的设置；The operation terminal is the user's operation interface, which is used for the configuration of database detection cases and the setting of detection tasks;
为了使系统有效的运行，本发明提供了一种上述的数据库自动化探测系统的运行方法，其特征在于：In order to make the system run effectively, the present invention provides a kind of operation method of the above-mentioned database automatic detection system, it is characterized in that:
按以下步骤实现：Follow these steps to achieve:
步骤1，操作终端配置数据库探测案例；Step 1, operating the terminal to configure the database detection case;
步骤2，操作终端配置数据库探测案例运行的任务，包括运行的时间设定，可设置具体的分钟、小时、日、月、年；Step 2, the operation terminal configures the task of running the database detection case, including the setting of the running time, which can be set to specific minutes, hours, days, months, and years;
步骤3，任务时间匹配到了，数据库探测服务器运行该探测案例；Step 3, when the task time is matched, the database detection server runs the detection case;
步骤4，连接要探测的数据库Step 4, connect to the database to be detected
步骤5，判断是否连接成功，连接成功后继续下一步操作；Step 5, judge whether the connection is successful, and continue to the next step after the connection is successful;
步骤6，在要探测的数据库中，执行sql语句操作；Step 6, in the database to be detected, execute the sql statement operation;
步骤7，判断sql语句执行是否成功；Step 7, judging whether the execution of the sql statement is successful;
步骤8，探测结束并将结果保存到数据库服务器中。Step 8, the detection ends and the result is saved to the database server.
本发明弥补了数据库探测只能查看数据库日志的方式来查看数据库的运行状态，并且弥补了只能人为的进行判断数据库是否正常。The present invention makes up for the way that the database detection can only check the database log to check the running state of the database, and makes up for the fact that the database can only be judged whether the database is normal or not.
下面结合附图及实施例对本发明做进一步说明。The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
附图说明 Description of drawings
图1是本发明的系统结构示意图。Fig. 1 is a schematic diagram of the system structure of the present invention.
图2是本发明实施例的工作流程图。Fig. 2 is a working flow chart of the embodiment of the present invention.
具体实施方式 Detailed ways
如图1所示，本发明公开了一种数据库自动化探测系统，包括数据库服务器、web服务器、数据库探测服务器、操作终端、探测数据库；所述数据库服务器与web服务器相连、所述的数据库服务器与数据库探测服务器连接，所述的数据库探测服务器还与探测数据库相连、所述的操作终端与web服务器连接；As shown in Figure 1, the present invention discloses a database automatic detection system, including a database server, a web server, a database detection server, an operation terminal, and a detection database; the database server is connected to the web server, and the database server is connected to the database The detection server is connected, and the database detection server is also connected with the detection database, and the operation terminal is connected with the web server;
所述的数据库服务器保存所有数据库探测的案例信息、保存案例的任务的运行时间配置，保存所有的配置信息，以及保存案例运行的结果信息；The database server saves all database detection case information, saves the running time configuration of the task of the case, saves all configuration information, and saves the result information of the case operation;
所述的Web服务器提供了一个操作界面，从而给用户更好的编辑后台服务探测案例、后台服务案例运行任务、以及后台服务探测结果信息展示；The web server provides an operation interface, so as to better edit background service detection cases, background service case running tasks, and background service detection result information display for users;
所述的数据库探测服务器根据数据库探测案例的任务配置信息，来统一调度数据库探测案例到相应的探测数据库中去执行sql语句，并判断执行sql语句返回的内容是否正确来驱动下一步的探测；According to the task configuration information of the database detection case, the database detection server uniformly dispatches the database detection case to the corresponding detection database to execute the sql statement, and judges whether the content returned by the execution sql statement is correct to drive the next step of detection;
所述的探测数据库包括支持所有能通过odbc/unixodbc/ado/dbx访问的数据库，包括关系型和非关系型数据库，如Oracle、SQL Server、DB2、TeraData；Described detection database comprises and supports all databases that can be accessed by odbc/unixodbc/ado/dbx, including relational and non-relational databases, such as Oracle, SQL Server, DB2, TeraData;
所述的操作终端为用户的操作界面，用于数据库探测案例的配置以及探测任务的设置；The operation terminal is the user's operation interface, which is used for the configuration of database detection cases and the setting of detection tasks;
为了使上述的数据库自动化探测系统能很好的工作，本发明提供了一种该系统的运行方法，其特征在于：In order to make the above-mentioned database automatic detection system work well, the present invention provides a kind of operation method of the system, which is characterized in that:
按以下步骤实现：Follow these steps to achieve:
步骤1，操作终端配置数据库探测案例；Step 1, operating the terminal to configure the database detection case;
步骤2，操作终端配置数据库探测案例运行的任务，包括运行的时间设定，可设置具体Step 2, the operation terminal configures the task of running the database detection case, including the setting of the running time, which can be set specifically
的分钟、小时、日、月、年；minutes, hours, days, months, years;
步骤3，任务时间匹配到了，数据库探测服务器运行该探测案例；Step 3, when the task time is matched, the database detection server runs the detection case;
步骤4，连接要探测的数据库Step 4, connect to the database to be detected
步骤5，判断是否连接成功，连接成功后继续下一步操作；Step 5, judge whether the connection is successful, and continue to the next step after the connection is successful;
步骤6，在要探测的数据库中，执行sql语句操作；Step 6, in the database to be detected, execute the sql statement operation;
步骤7，判断sql语句执行是否成功；Step 7, judging whether the execution of the sql statement is successful;
步骤8，探测结束并将结果保存到数据库服务器中。Step 8, the detection ends and the result is saved to the database server.
下面以探测kpi数据库为例，操作步骤在kpi一级客服数据库中执行sql语句：select′一级客服文件未上传′as cnt from app_alarm where app_id in(1133，1134，1135，1136)andcurrent_val>＝1 and total_time>60。The following takes the detection of the KPI database as an example. The operation steps are to execute the sql statement in the KPI first-level customer service database: select 'the first-level customer service file has not been uploaded' as cnt from app_alarm where app_id in(1133, 1134, 1135, 1136) and current_val>=1 and total_time>60.
如图2所示，探测kpi数据库的具体步骤如下：As shown in Figure 2, the specific steps for detecting the KPI database are as follows:
步骤1，操作终端配置数据库探测_Kpi_一级客服案例；Step 1, the operation terminal configuration database detection_Kpi_level customer service case;
步骤2，操作终端配置数据库探测案例运行的任务(运行的时间设定，可设置具体的分钟、小时、日、月、年)；Step 2, the operation terminal configures the task of running the database detection case (running time setting, specific minutes, hours, days, months, and years can be set);
步骤3，任务时间匹配到了，数据库探测服务器运行该探测案例；Step 3, when the task time is matched, the database detection server runs the detection case;
步骤4，连接kpi数据库Step 4, connect to the kpi database
步骤5，判断是否连接成功，连接成功后继续下一步操作；Step 5, judge whether the connection is successful, and continue to the next step after the connection is successful;
步骤6，在kpi数据库中，执行sql语句操作；Step 6, in the kpi database, execute the sql statement operation;
步骤7，判断sql语句执行是否成功；Step 7, judging whether the execution of the sql statement is successful;
步骤8，探测结束并将结果保存到数据库服务器中；Step 8, the detection ends and the result is saved to the database server;
至此，数据库探测的流程结束。So far, the process of database detection ends.
本发明能自动进行数据库的探测，用户只需配置相应的连接数据库的配置信息以及执行数据库的sql语句即可实现24小时不间断的自动数据库探测，并可记录数据库响应的时间(精确到毫秒)，以及执行sql语句的结果信息。弥补了数据库探测只能查看数据库日志的方式来查看数据库的运行状态，并且弥补了只能人为的进行判断数据库是否正常。The invention can automatically detect the database, and the user only needs to configure the corresponding configuration information for connecting to the database and execute the sql statement of the database to realize 24-hour uninterrupted automatic database detection, and can record the response time of the database (accurate to milliseconds) , and the result information of executing the sql statement. It makes up for the fact that the database detection can only view the database log to check the running status of the database, and makes up for the fact that it can only be judged manually whether the database is normal.
Claims (2)
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 | 销售力网络公司 | Method and system for performing cross-storage joins in multi-tenant storage |
| 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 | 销售力网络公司 | Method and system for performing cross-storage joins in multi-tenant storage |
| CN103299267B (en) * | 2010-12-20 | 2016-05-18 | 销售力网络公司 | Method and system for performing cross-storage joins in multi-tenant storage |
| 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 |
|---|---|---|
| US8381189B2 (en) | Bug clearing house | |
| CN108491422B (en) | Database automation operation and maintenance management method, server and storage medium | |
| US8140477B2 (en) | Continuous integration of business intelligence software | |
| CN104769554B (en) | System, method, device and computer program product for providing mobile device support services | |
| US8126581B2 (en) | Improving design manufacturing, and transportation in mass manufacturing through analysis of defect data | |
| CN101430688A (en) | Database automatic detection system and its operation method | |
| CN106713007A (en) | Alarm monitoring system and alarm monitoring method and device for server | |
| CN107220178A (en) | A kind of method that server diagnostic test results quasi real time show | |
| US12093886B2 (en) | Systems and methods for initiating electronic remediation actions | |
| KR101137087B1 (en) | Business application entity subscription synch operation management | |
| CN113886128B (en) | A method and system for fault diagnosis and data recovery of SSD | |
| CN101312543A (en) | A method and TV set for recording TV abnormalities | |
| CN109933798B (en) | Audit log analysis method and audit log analysis device | |
| CN112099981A (en) | Automatic checking and repairing method for system data | |
| US20230177040A1 (en) | Method and system for creating a unified data repository | |
| CN110543418A (en) | database performance test method, system and storage medium | |
| CN111800782A (en) | Method, system, device and medium for generating differential packets online | |
| CN100461167C (en) | General database automatic dump method and system | |
| CN113220726A (en) | Data quality detection method and system | |
| CN115827451A (en) | Method and device for detecting test defects, storage medium and electronic device | |
| CN115543984A (en) | Data management method and system, medium and equipment | |
| CN108197956B (en) | Method and system for controlling product abnormity risk of e-commerce platform | |
| CN1992751B (en) | Charging note complete monitoring warning system and operation method | |
| CN103177318A (en) | How to create a table of materials | |
| CN113626233B (en) | A method, device and equipment for automatically detecting BIOS watchdog function |
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 |