WO2019205346A1

WO2019205346A1 - Operation and maintenance method and device for bi tool, computer device, and storage medium

Info

Publication number: WO2019205346A1
Application number: PCT/CN2018/099777
Authority: WO
Inventors: 黄涛; 杨勇; 宋剑锋
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-04-23
Filing date: 2018-08-10
Publication date: 2019-10-31
Also published as: CN108595625A; CN108595625B

Abstract

An operation and maintenance (O&M) method for a BI tool, comprising: monitoring an operation state of a BI tool, and when the operation state of the BI tool satisfies an O&M condition, triggering an O&M operation instruction (S10); acquiring an O&M object indicated by the O&M operation instruction and the level of the O&M object (S20); determining an operable object at the same level as said O&M object and/or an operable object at a level lower than that of said O&M object as objects to be operated and maintained (S30); performing operation and maintenance on said objects according to the O&M operation indicated by the O&M operation instruction (S40). Further disclosed are an O&M device for a BI tool, a computer device and a non-volatile readable storage medium. The described O&M method, O&M device, computer device and storage medium can improve the O&M efficiency of the BI tool.

Description

Operation and maintenance method, device, computer device and storage medium of BI tool

This application claims the priority of the Chinese Patent Application entitled "BI Tool Operation and Maintenance Method, Apparatus, Computer Device and Storage Medium" by the Chinese Patent Office on April 23, 2018, the application number is 201810368097. The content is incorporated herein by reference.

Technical field

The present invention relates to the field of operation and maintenance technologies of data mining software, and in particular, to a method, device, computer device and storage medium for operating and maintenance of a BI tool.

Background technique

Business Intelligence (BI) analysis tools are also known as BI tools. The BI tool is a tool that effectively integrates the system data applied in the enterprise and provides reports quickly and accurately. It can help users understand the required enterprise information and help users make business decisions. Common BI tools (BI systems) are Cognos, Pentaho, Tableau, etc.

At present, for the operation and maintenance method of the BI tool, the operation and maintenance personnel usually observe the running application state, locate the position where the problem may occur, and then operate the BI tool through the console. A server cluster that usually deploys BI tools contains more servers, and there may be more nodes involved in operation and maintenance. The operation and maintenance of BI tools through existing operation and maintenance methods is relatively inefficient.

Summary of the invention

In view of the above, it is necessary to provide a BI tool operation and maintenance method, device, computer device and storage medium, which can improve the operation and maintenance efficiency of the BI tool.

The application provides an operation and maintenance method of a BI tool, and the method includes:

Monitoring the running state of the BI tool, and triggering the operation and maintenance operation instruction when the running state of the BI tool meets the operation and maintenance condition;

Obtaining an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

Determining an operable object at the same level as the operation and maintenance object, and/or an operable object having a hierarchy lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated;

Performing operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.

In a preferred implementation of the present application, the hierarchy of the operation and maintenance object includes a subsystem hierarchy, a logical unit hierarchy, and an application node hierarchy.

In a preferred implementation of the present application, the operating state of the BI tool is monitored, and when the operating state of the BI tool meets the operation and maintenance conditions, the operation and maintenance operation instruction is triggered, including:

Obtaining system resources consumed by the BI tool when it runs;

And when the system resource consumed by the running of the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Controlling the pending server to suspend operation among the objects to be operated.

Obtaining cache information of a server of the BI tool;

And when the cache size of the server reaches a preset cache value, triggering an operation and maintenance operation instruction, where the operation operation instruction is used to clean the cache of the server;

Obtaining a server that is not in a refresh state among the objects to be operated;

Clearing the cache of the server that is not in the refresh state among the objects to be operated.

Obtaining the system time of the server of the BI tool;

If the system time is a preset time, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to perform data synchronization on the BI tool;

Determining that the preset server among the objects to be operated is a server to be synchronized;

Data synchronization is performed on the server to be synchronized.

In a preferred implementation of the application, the method further includes:

Displaying a selection page of the operation and maintenance operation, where the selection page includes an operation and maintenance operation and an operation and maintenance object;

The operation and maintenance operation instruction is triggered according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.

In a preferred embodiment of the present application, the method further includes:

After the operation and maintenance of the operation and maintenance object to be operated, if the information about the abnormal operation of the BI tool is acquired, the alarm information is sent.

The application also provides an operation and maintenance device of a BI tool, the device comprising:

a monitoring module, configured to monitor an operating state of the BI tool, and trigger an operation and maintenance operation instruction when the running state of the BI tool meets an operation and maintenance condition;

An acquiring module, configured to acquire an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

a determining module, configured to determine an operable object at the same level as the operation and maintenance object, and/or an operable object whose level is lower than the level of the operation and maintenance object is an operation and maintenance object to be operated;

The processing module is configured to perform operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.

In a preferred embodiment of the present application, the hierarchy of the operation and maintenance object includes a subsystem hierarchy, a logical unit hierarchy, and an application node hierarchy.

In a preferred embodiment of the present application, the monitoring module is specifically configured to:

Obtaining system resources consumed by the BI tool when it runs;

And when the system resource consumed by the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process;

The processing module is specifically configured to:

Obtaining cache information of a server of the BI tool;

The processing module is specifically configured to:

Obtaining the system time of the server of the BI tool;

The processing module is specifically configured to:

Data synchronization is performed on the server to be synchronized.

In a preferred embodiment of the present application, the apparatus further includes:

a display module, configured to display a selection page of the operation and maintenance operation, where the selection page includes an operation and maintenance operation and an operation and maintenance object;

The triggering module is configured to trigger an operation and maintenance operation instruction according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.

The reminding module is configured to: after the operation and maintenance of the operation and maintenance object to be operated, obtain the information that the BI tool runs abnormally, and send an alarm message.

The application also provides a computer device comprising a memory and a processor, the memory for storing at least one instruction, the processor for executing the at least one instruction to implement the BI described in any embodiment The operation and maintenance method of the tool.

The present application also provides a non-volatile readable storage medium, wherein the non-volatile readable storage medium stores at least one instruction, which is implemented in any embodiment when executed by a processor The operation and maintenance method of the BI tool.

As shown in the above technical solution, the present application triggers an operation and maintenance operation instruction by monitoring an operation state of the BI tool, and when the operation state of the BI tool meets an operation and maintenance condition; acquiring an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object; an operable object that is at the same level as the operation and maintenance object, and/or an operable object whose hierarchy is lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated; The operation and maintenance operation indicated by the operation and maintenance operation instruction performs operation and maintenance on the operation and maintenance object to be operated. When the running state of the BI tool meets the operation and maintenance conditions, the operation and maintenance operation instruction is automatically triggered, and when the operation and maintenance object is determined, the operable object at the same level as the operation and maintenance object is determined according to the hierarchy of the operation and maintenance object, and The operation object that is lower than the hierarchy of the operation and maintenance object is the operation and maintenance object to be operated. Therefore, the operation and maintenance object indicated by the operation and maintenance operation instruction can determine that multiple objects are to be operated and operated, and then The operation object is operated and maintained. No maintenance personnel are required to manually monitor and perform operation and maintenance processing one by one, which greatly improves the efficiency of operation and maintenance.

DRAWINGS

1 is a flowchart of an operation and maintenance method of a BI tool according to an embodiment of the present application;

2 is a diagram showing an example of a hierarchy of an operation and maintenance object in the embodiment of the present invention;

3 is a block diagram of an operation and maintenance apparatus of a BI tool according to an embodiment of the present application;

FIG. 4 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of the present invention for implementing an operation and maintenance method of a BI tool.

detailed description

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the drawings in the embodiments of the present application. It is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

The above described objects, features and advantages of the present application will become more apparent and understood.

As shown in FIG. 1 , FIG. 1 is a flowchart of an operation and maintenance method of a BI tool according to an embodiment of the present application. The order of the steps in the flowchart may be changed according to different requirements, and some steps may be omitted.

S10: Monitor an operating state of the BI tool, and trigger an operation and maintenance operation instruction when the running state of the BI tool meets an operation and maintenance condition.

The operation and maintenance method of the BI tool described in this application can be used for operation and maintenance of any BI tool deployed in Cognos, Pentaho, Tableau, or at least two BI tools deployed in Cognos, Pentaho, and Tableau. Operation and maintenance.

The above operation and maintenance instructions include, but are not limited to, restarting BI tool instructions, starting BI tool instructions, suspending BI tool instructions, clearing cache instructions, cleaning log instructions, data synchronization instructions, and model issuing instructions.

Among them, the instruction to restart the BI tool is used to restart the BI tool.

The Start BI Tools command is used to launch the BI tool from the shutdown state.

The pause BI tool instruction is used to tentatively set the running BI tool, and the cleanup cache instruction is used to clean up the cache in the BI system, such as cleaning up a Cognos cache.

The cleanup log directive is used to log the BI system runtime, such as cleaning up a Cognos log.

The data synchronization instructions are used to synchronize data between different BI systems, such as synchronizing the specified data in the current first Cognos system to the second Cognos system.

The model release directive is used to publish the model. In the Cognos system, the model is used to define how the data is organized and what the structure of the data is. Models can be created in advance as needed or created during use.

The above operation and maintenance conditions can be set according to requirements. Different operation and maintenance conditions can be set for different parameters of the BI tool runtime server.

For example, the specified command is sent to the server of the BI tool to detect the availability of the BI tool. When the normal value is returned, the status of the BI tool is determined to be normal. When the returned value is an abnormal value, it is determined that the running state of the BI tool satisfies the operation and maintenance condition. , trigger the corresponding operation and maintenance operation instructions.

Optionally, in other embodiments of the present application, the step S10 monitors an operation state of the BI tool. When the running state of the BI tool meets an operation and maintenance condition, the triggering the operation and maintenance operation instruction includes:

Obtaining system resources consumed by the BI tool when it runs;

When the system resource consumed by the BI tool exceeds a preset threshold, an operation and maintenance operation instruction is triggered, and the operation and maintenance operation instruction is used to schedule the running process.

The above system resources include a CPU, a memory, and a shared storage of a server that are not limited to the BI system. System resources are hardware resources of the servers of the BI system. The preset thresholds corresponding to different system resources are different.

For example, monitoring the CPU usage of the BI tool at runtime, when the CPU utilization exceeds 90%, triggers the operation and maintenance operation instruction. Specifically, it is an operation and maintenance operation instruction that triggers a server for the BI tool. This directive is used to schedule a running process. For example, a process that occupies too much resources is suspended, or a sequence of operations is scheduled.

At the same time, the commonly deployed BI tool has multiple servers. When the operation and maintenance operation command is triggered, it may be an operation and maintenance operation instruction issued for one or more specified servers.

In this embodiment, when the system resource of the BI tool is running exceeds a preset threshold, it indicates that the performance problem of the BI tool may be caused, which affects the user's use. Therefore, the operation and maintenance operation instructions of the server for the BI tool are sent, so that the operation and maintenance personnel are not required to find and find the problem, and the operation and maintenance can be performed in an active and timely manner to improve the operation and maintenance efficiency.

Obtaining cache information of a server of the BI tool;

When the cache size of the server reaches a preset cache value, an operation and operation operation instruction is triggered, where the operation operation instruction is used to clean the cache of the server.

The preset cache value may be specifically set as needed.

Preferably, the preset cache value may be determined according to the size of the remaining space of the disk in the server of the BI tool. For example, the default cache value is 70% or 80% of the size of the remaining cache capacity in the BI tool's server.

In a specific implementation, if there are multiple servers, if only one of the servers has a cache that reaches a preset cache value, the command to clear the cache may be sent only to the one or several servers.

In this embodiment, the cache in the server can be cleaned in time to avoid the problem that the system running efficiency or abnormal operation caused by the cache is not cleaned up.

Obtaining the system time of the server of the BI tool;

If the system time is a preset time, an operation and maintenance operation instruction is triggered, and the operation and maintenance operation instruction is used to perform data synchronization on the BI tool.

The system time of the server of the BI tool may be the current system time of the server of the BI tool. The value of the specific preset time can be set as needed.

The data synchronization of the BI tool is specifically performed by sending the operation and maintenance operation instruction to one or more Cognos systems, so that the data of the Cognos system that receives the operation and maintenance operation instruction is synchronized with the data between the other Cognos systems.

At the same time, when the preset time arrives, the triggered operation and maintenance operation instruction may also be an instruction for performing model release, or an instruction for clearing the log.

In this embodiment, when the system time reaches the preset system time, the operation and maintenance operation instruction for the BI tool is sent, and the operation and maintenance personnel can manually trigger the operation and maintenance operation instruction when the operation and maintenance personnel manually operate when the preset system time is reached. , carry out active operation and maintenance, improve the efficiency of operation and maintenance.

S20. Acquire an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object.

The above operation and maintenance object may refer to an object to perform an operation and maintenance operation. For example, the operation and maintenance object is a Cognos system, and the specific operation and maintenance object may be one or several servers in a certain Cognos system.

At the same time, different levels can be set in advance for the operation and maintenance objects. For example, in a deployed BI system, including three cognos systems, the first Cognos system, the second Cognos system, and the third Cognos system are set to the first level. Set the database corresponding to each Cognos system to the second level.

Optionally, in other embodiments of the present application, the hierarchy of the operation and maintenance object includes a subsystem level, a logic unit level, and an application node level.

In this embodiment, the hierarchy of the operation and maintenance objects is divided into three levels, that is, a subsystem level, a logical unit level, and an application node level.

The subsystem level may be a BI system, for example, the operation and maintenance object of the subsystem level is the Cognos subsystem.

The logical unit level can also be referred to as the LE (logic element) level. The LE level can be divided into system architectures of the subsystems. For example, the subsystem is a Cognos system, and the Cognos subsystem is a three-tier architecture, including: presentation/web tier, application tier, and data tier. The operation and maintenance objects at the logical unit level are instance objects of the presentation layer, instance objects of the application layer, and instance objects of the data layer.

The application node level is the corresponding application node under the LE level. For example, a Cognos subsystem has 10 hosts, 2 of which are web hosts (network hosts), 6 are app hosts (application hosts), and 2 are cm hosts (content management hosts). Each host is an application node level. Operation and maintenance object.

At the same time, under the subsystem level is the LE level, and under the LE level is the application node level.

Specifically, please refer to FIG. 2, which is an example diagram of the hierarchy of the operation and maintenance object. In FIG. 2, for an operation and maintenance object having a plurality of logical unit levels under one subsystem level, one or more operation node levels of the application node level may also be operated under the logical unit level.

S30. Determine an operable object at the same level as the operation and maintenance object, and/or an operable object whose level is lower than the level of the operation and maintenance object is an operation and maintenance object to be operated.

The above operable object is an object that can be operated and operated.

For example, a Cognos subsystem consists of 10 hosts, 2 of which are web hosts (network hosts), 6 are app hosts (application hosts), and 2 are cm hosts (content management hosts). Each host is an operational object. If the operation and maintenance object is the Cognos subsystem, the operation and maintenance object to be operated can be 10 hosts (including 2 web hosts, 6 app hosts, and 2 cm hosts).

If the operation and maintenance object is an operable object of the LE level, specifically an instance object of an application tier, the operation and maintenance object to be operated may be six app hosts.

If the operation and maintenance object is a web host (an instance object of the application node level), the operation and maintenance object to be operated may be the web host.

S40: Perform operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.

After determining the operation and maintenance object to be operated, the operation and maintenance operation is performed on the operation and maintenance object.

It can be understood that the operation and maintenance operations that can be performed for different operation and maintenance objects can be different. Some operation and maintenance operations are available to all operation and maintenance objects, and some operation and maintenance operations are only available for some operation and maintenance objects. For example, restarting apache is an operation that a web host will have. Model publishing is an operation that the app host will have. Start synchronization, close synchronization, and clean up the queue are operations that are only available to the cm host. The specific operation and maintenance operations depend on the operations indicated by the operation and maintenance instructions.

For example, a Cognos subsystem has 10 hosts, 2 of which are web hosts, 6 are app hosts, 2 are cm hosts, and operation and maintenance operations are restart operations. If the operation and maintenance object to be operated is 10 hosts, all 10 hosts perform a restart operation. If the operation and maintenance object to be operated is 6 app hosts, only 6 app hosts perform a restart operation; if the operation and maintenance object is a web host with IP 10.20.30.40, only the web host performs a restart operation.

Optionally, if the received operation and maintenance operation instruction is used to schedule the running process. The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction may include:

The above suspension condition may be set in advance as needed. For example, one or more servers have lower priority for performing tasks; or one server runs at night, and the refresh report service is not executed at this time, and the server is running and starts a large number of refreshes. The service related to the report can be determined to suspend the server at this time.

The specific pause condition is not limited to the above, and can be set according to the operational needs of the BI tool in practice.

Optionally, if the received operation and maintenance operation instruction is an instruction for cleaning the cache of the server of the BI tool, the operation and maintenance operation indicated by the operation and maintenance operation instruction is performed on the to-be-operated operation. Dimensional objects are operated and maintained, including:

For example, the operation and maintenance object to be operated may be one or more servers that need to be cache cleaned. When one or more servers that need to be cleaned are not in a refresh state, they are cache cleaned.

In this embodiment, the cache cleaning of the server may be performed according to the operation and maintenance operation instruction, and when the cache is cleared, only the cache of the server that is not in the refresh state is cleaned. When the server is in the refresh state, some files in the cache may be required to support the refresh. Therefore, when the cache is cleaned in this embodiment, the BI tool may also be prevented from running.

Optionally, if the received operation and maintenance operation instruction is an instruction for performing data synchronization on the BI tool, the operation and maintenance operation indicated by the operation and maintenance operation instruction is performed on the operation and maintenance object to be operated. Operation and maintenance, including:

Data synchronization is performed on the server to be synchronized.

The above preset server may be a server capable of data synchronization, such as a cm host (content management host).

Specifically, the preset servers among the objects to be operated may all be the server to be synchronized or part of the server to be synchronized. After the server to be synchronized is acquired from the objects to be operated, the data to be synchronized is synchronized with the server to be synchronized. When data synchronization is performed, the data on the object to be operated may be synchronized to other storage areas, or the data of other storage areas may be synchronized to the object to be operated.

For example, if the object to be operated is two cm hosts, the data on the two cm hosts is synchronized with other storage areas for data backup, or the data in other servers is synchronized to the two cm hosts.

In other embodiments of the present application, after the operation and maintenance operation is performed on the operation and maintenance object to be operated, the result of the operation and maintenance operation may be summarized. For example, whether all the operation and maintenance objects to be operated successfully perform the operation and maintenance operations, or whether the execution time of the operation and maintenance objects exceeds the preset time. Similarly, the results of the operation and maintenance operations can be sent to the operation and maintenance staff, so that the operation and maintenance work can quickly understand the operation and operation and maintenance status of the BI tools.

In this embodiment, the operation and maintenance operations can be performed on a plurality of operable objects quickly, thereby improving the efficiency of operation and maintenance. At the same time, since the logical unit level and the application node level are included in the hierarchy of the operation and maintenance object, accurate operation and maintenance operations can be performed on a certain type of host and a certain host quickly and accurately.

Optionally, in other embodiments of the present application, the method described in the present application may further include:

The selection page of the operation and maintenance operation is displayed, and the selection page includes an operation and maintenance operation and an operation and maintenance object; and an operation and maintenance operation instruction is triggered according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.

The above operation and maintenance operations include but are not limited to: restart BI tools, start BI tools, suspend BI tools, clean up caches, clean up logs, synchronize data, and publish models.

The selection page includes an operation and maintenance operation object and an operation and maintenance object, which means that the operation and maintenance operation and the operation and maintenance object are displayed on the selected page, and the user can select the operation and maintenance operation and the operation and maintenance object from the selection page.

In this embodiment, a page for displaying an operation and maintenance operation may be displayed on the graphical user interface for the operation and maintenance personnel to view. At the same time, the operation and maintenance operations performed according to the operation and maintenance operation instructions are determined according to the operation and maintenance personnel. Therefore, in the operation and maintenance method provided by the present application, not only can the operation and maintenance be automated, but also the selection interface is provided for the operation and maintenance personnel to select and trigger the instruction, so that the operation and maintenance personnel are more convenient in system operation and maintenance.

Optionally, in another embodiment of the present application, the method described in the present application may further include:

After the operation and maintenance of the operation and maintenance object to be operated, if the information about the abnormal operation of the BI tool is acquired, an alarm message is sent.

Specifically, during the period after the operation and maintenance of the operation and maintenance object is performed, when the information of the BI tool running abnormal (for example, the BI tool cannot run normally or the buffer space is insufficient) is obtained, the reminder is performed.

For example, when a certain Cognos system fails to start after multiple restarts, the operation and maintenance personnel may need to view the exception and process it. At this time, the alarm information is sent to the operation and maintenance personnel, so that the operation and maintenance personnel can process the abnormality in time and perform precise operation and maintenance. .

In this embodiment, in addition to automatic operation and maintenance, the alarm information can be sent to the operation and maintenance personnel in time when the automatic operation and maintenance cannot be performed, so that the problems in the running process of the BI tool can be solved in time to avoid the system failure affecting the user. usage of.

The operation and maintenance method of the BI tool provided by the present application monitors the running state of the BI tool, and when the running state of the BI tool meets the operation and maintenance condition, triggers the operation and maintenance operation instruction; acquires the operation and maintenance object indicated by the operation and maintenance operation instruction, and a hierarchy of the operation and maintenance object; an operable object that is at the same level as the operation and maintenance object, and/or an operable object whose hierarchy is lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated; The operation and maintenance operation indicated by the operation and maintenance operation instruction performs operation and maintenance on the operation and maintenance object to be operated. When the running state of the BI tool meets the operation and maintenance conditions, the operation and maintenance operation instruction is automatically triggered, and when the operation and maintenance object is determined, according to the hierarchy of the operation and maintenance object, the operable object of the operation and maintenance object at the same level is determined, and The operation object that is lower than the hierarchy of the operation and maintenance object is the operation and maintenance object to be operated. Therefore, the operation and maintenance object indicated by the operation and maintenance operation instruction can determine that multiple objects are to be operated and operated, and then The operation object is operated and maintained. No maintenance personnel are required to manually monitor and perform operation and maintenance processing one by one, which greatly improves the efficiency of operation and maintenance.

As shown in FIG. 3, FIG. 3 is a functional block diagram of an operation and maintenance apparatus of a BI tool according to an embodiment of the present application. The operation and maintenance device of the BI tool includes a monitoring module 210, an obtaining module 220, a determining module 230, and a processing module 240. A module as referred to herein refers to a series of computer readable instruction segments that can be executed by a processor of a computer device and that are capable of performing a fixed function, which are stored in a memory of the computer device. In the present embodiment, the functions of the respective modules will be described in detail in the subsequent embodiments.

The monitoring module 210 is configured to monitor an operating state of the BI tool, and trigger an operation and maintenance operation instruction when the running state of the BI tool meets an operation and maintenance condition.

The operation and maintenance device of the BI tool described in the present application can perform operation and maintenance on any BI tool deployed in Cognos, Pentaho, Tableau, or at least two BI tools deployed in Cognos, Pentaho, and Tableau. Operation and maintenance.

Optionally, in other embodiments of the present application, the monitoring module 210 is specifically configured to:

Obtaining a system resource consumed by the running of the BI tool; when the system resource consumed by the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process .

Obtaining cache information of the server of the BI tool; when the cache size of the server reaches a preset cache value, triggering an operation and maintenance operation instruction, where the operation operation instruction is used to clean the cache of the server.

The preset cache value may be specifically set as needed.

Obtaining a system time of the server of the BI tool; if the system time is a preset time, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to perform data synchronization on the BI tool.

The obtaining module 220 is configured to acquire an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object.

The determining module 230 is configured to determine an operable object at the same level as the operation and maintenance object, and/or an operable object whose level is lower than the level of the operation and maintenance object is an operation and maintenance object to be operated.

The above operable object is an object that can be operated and operated.

The processing module 240 is configured to perform operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.

Optionally, if the received operation and maintenance operation instruction is used to schedule the running process. The processing module is specifically configured to:

Optionally, if the received operation and maintenance operation instruction is an instruction for cleaning the cache of the server of the BI tool, the processing module is specifically configured to:

Obtaining a server that is not in a refresh state among the objects to be operated; and clearing a cache of a server that is not in a refresh state among the objects to be operated.

For example, the operation and maintenance object to be operated may be one or more servers that need to be cache cleaned. When one or more servers that need to be cleaned are not in a refresh state, they are cached.

Optionally, if the received operation and maintenance operation instruction is an instruction for performing data synchronization on the BI tool, the processing module is specifically configured to:

Determining that the preset server among the objects to be operated is a server to be synchronized; and performing data synchronization on the server to be synchronized.

Optionally, in other embodiments of the present application, the apparatus described in the present application may further include a display module and a trigger module.

The display module is configured to display a selection page of the operation and maintenance operation, and the selection page includes an operation and maintenance operation and an operation and maintenance object.

Optionally, in another embodiment of the present application, the apparatus described in the present application may further include a reminding module.

The operation and maintenance device of the BI tool provided by the present application monitors the running state of the BI tool through the monitoring module. When the running state of the BI tool meets the operation and maintenance conditions, the operation and maintenance operation instruction is triggered; and the obtaining module acquires the operation and operation operation instruction instruction. The operation and maintenance object and the hierarchy of the operation and maintenance object; the determination module determines an operable object at the same level as the operation and maintenance object, and/or the operable object whose hierarchy is lower than the hierarchy of the operation and maintenance object is to be operated An operation and maintenance object; the processing module performs operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction. When the running state of the BI tool meets the operation and maintenance conditions, the operation and maintenance operation instruction is automatically triggered, and when the operation and maintenance object is determined, according to the hierarchy of the operation and maintenance object, the operable object of the operation and maintenance object at the same level is determined, and The operation object that is lower than the hierarchy of the operation and maintenance object is the operation and maintenance object to be operated. Therefore, the operation and maintenance object indicated by the operation and maintenance operation instruction can determine that multiple objects are to be operated and operated, and then The operation object is operated and maintained. No maintenance personnel are required to manually monitor and perform operation and maintenance processing one by one, which greatly improves the efficiency of operation and maintenance.

The above-described integrated modules and units implemented in the form of software function modules can be stored in a non-volatile readable storage medium. The software function module described above is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor to perform the methods described in various embodiments of the present application. Part of the steps.

As shown in FIG. 4, FIG. 4 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of the present invention for implementing an operation and maintenance method of a BI tool. The computer device comprises at least one transmitting device 31, at least one memory 32, at least one processor 33, at least one receiving device 34 and at least one communication bus. Wherein, the communication bus is used to implement connection communication between these components.

The computer device is a device capable of automatically performing numerical calculation and/or information processing according to an instruction set or stored in advance, and the hardware thereof includes but is not limited to a microprocessor and an application specific integrated circuit (ASIC). , Field-Programmable Gate Array (FPGA), Digital Signal Processor (DSP), embedded devices, etc. The computer device may also include a network device and/or a user device. The network device includes, but is not limited to, a single network server, a server group composed of multiple network servers, or a cloud computing-based cloud composed of a large number of hosts or network servers, where the cloud computing is distributed computing. A super virtual computer consisting of a group of loosely coupled computers.

The computer device may be, but is not limited to, any electronic product that can interact with a user through a keyboard, a touch pad, or a voice control device.

The network in which the computer device is located includes, but is not limited to, the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (VPN), and the like.

The receiving device 34 and the transmitting device 31 may be wired transmission ports, or may be wireless devices, for example, including antenna devices, for performing data communication with other devices.

The memory 32 is used to store program code. The memory 32 may be a circuit having a memory function in a physical form, such as a RAM (Random-Access Memory), a FIFO (First In First Out), or the like. Alternatively, the memory 32 may also be a memory having a physical form, such as a memory stick, a TF card (Trans-flash Card), a smart media card, a secure digital card, a flash memory card. Storage devices such as (flash card) and the like.

The processor 33 can include one or more microprocessors, digital processors. The processor 33 can call program code stored in the memory 32 to perform related functions. For example, the various units described in FIG. 4 are program code stored in the memory 32 and executed by the processor 33 to implement an operation and maintenance method of the BI tool. The processor 33, also known as a central processing unit (CPU), is a very large-scale integrated circuit, which is a computing core (Core) and a control unit (Control Unit).

In the several embodiments provided by the present application, it should be understood that the disclosed system, apparatus, and method may be implemented in other manners. For example, the device embodiments described above are merely illustrative. For example, the division of the modules is only a logical function division, and the actual implementation may have another division manner.

The modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, each functional module in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of hardware plus software function modules.

It is obvious to those skilled in the art that the present application is not limited to the details of the above-described exemplary embodiments, and the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present application. Therefore, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the invention is defined by the appended claims instead All changes in the meaning and scope of equivalent elements are included in this application. Any accompanying drawings in the claims should not be construed as limiting the claim. In addition, it is to be understood that the word "comprising" does not exclude other elements or steps. A plurality of units or devices recited in the system claims can also be implemented by a unit or device by software or hardware. The second word is used to denote the name and does not denote any particular order.

It should be noted that the above embodiments are only used to explain the technical solutions of the present application, and are not limited thereto. Although the present application is described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present application can be applied. Modifications or equivalents are made without departing from the spirit and scope of the technical solutions of the present application.

Claims

An operation and maintenance method of a BI tool, characterized in that the method comprises:

Monitoring the running state of the BI tool, and triggering the operation and maintenance operation instruction when the running state of the BI tool meets the operation and maintenance condition;

Obtaining an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

Determining an operable object at the same level as the operation and maintenance object, and/or an operable object having a hierarchy lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated;

Performing operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.
The method of claim 1 wherein the hierarchy of operation and maintenance objects comprises a subsystem hierarchy, a logical unit hierarchy, and an application node hierarchy.
The method according to claim 1 or 2, wherein the monitoring of the operating state of the BI tool, when the operating state of the BI tool meets the operation and maintenance conditions, triggers an operation and maintenance operation instruction, including:

Obtaining system resources consumed by the BI tool when it runs;

And when the system resource consumed by the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Controlling the pending server to suspend operation among the objects to be operated.
The method according to claim 1 or 2, wherein the monitoring of the operating state of the BI tool, when the operating state of the BI tool meets the operation and maintenance conditions, triggers an operation and maintenance operation instruction, including:

Obtaining cache information of a server of the BI tool;

And when the cache size of the server reaches a preset cache value, triggering an operation and maintenance operation instruction, where the operation operation instruction is used to clean the cache of the server;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Obtaining a server that is not in a refresh state among the objects to be operated;

Clearing the cache of the server that is not in the refresh state among the objects to be operated.
The method according to claim 1 or 2, wherein the monitoring of the operating state of the BI tool, when the operating state of the BI tool meets the operation and maintenance conditions, triggers an operation and maintenance operation instruction, including:

Obtaining the system time of the server of the BI tool;

If the system time is a preset time, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to perform data synchronization on the BI tool;

And performing operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction, including:

Determining that the preset server among the objects to be operated is a server to be synchronized;

Data synchronization is performed on the server to be synchronized.
The method of claim 1 or 2, wherein the method further comprises:

Displaying a selection page of the operation and maintenance operation, where the selection page includes an operation and maintenance operation and an operation and maintenance object;

The operation and maintenance operation instruction is triggered according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.
The method of claim 1 or 2, wherein the method further comprises:

After the operation and maintenance of the operation and maintenance object to be operated, if the information about the abnormal operation of the BI tool is acquired, the alarm information is sent.
An operation and maintenance device for a BI tool, characterized in that the device comprises:

a monitoring module, configured to monitor an operating state of the BI tool, and trigger an operation and maintenance operation instruction when the running state of the BI tool meets an operation and maintenance condition;

An acquiring module, configured to acquire an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

a determining module, configured to determine an operable object at the same level as the operation and maintenance object, and/or an operable object whose level is lower than the level of the operation and maintenance object is an operation and maintenance object to be operated;

The processing module is configured to perform operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.
A computer apparatus, comprising: a memory for storing at least one instruction, and a processor for executing the at least one instruction to implement the following steps:

Monitoring the running state of the BI tool, and triggering the operation and maintenance operation instruction when the running state of the BI tool meets the operation and maintenance condition;

Obtaining an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

Determining an operable object at the same level as the operation and maintenance object, and/or an operable object having a hierarchy lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated;

Performing operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.
The computer apparatus according to claim 9, wherein the monitoring the running state of the BI tool, when the operating state of the BI tool meets the operation and maintenance condition, triggering the operation and maintenance operation instruction, including:

Obtaining system resources consumed by the BI tool when it runs;

And when the system resource consumed by the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Controlling the pending server to suspend operation among the objects to be operated.
The computer apparatus according to claim 9, wherein the monitoring the running state of the BI tool, when the operating state of the BI tool meets the operation and maintenance condition, triggering the operation and maintenance operation instruction, including:

Obtaining cache information of a server of the BI tool;

And when the cache size of the server reaches a preset cache value, triggering an operation and maintenance operation instruction, where the operation operation instruction is used to clean the cache of the server;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Obtaining a server that is not in a refresh state among the objects to be operated;

Clearing the cache of the server that is not in the refresh state among the objects to be operated.
The computer apparatus according to claim 9, wherein the monitoring the running state of the BI tool, when the operating state of the BI tool meets the operation and maintenance condition, triggering the operation and maintenance operation instruction, including:

Obtaining the system time of the server of the BI tool;

If the system time is a preset time, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to perform data synchronization on the BI tool;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Determining that the preset server among the objects to be operated is a server to be synchronized;

Data synchronization is performed on the server to be synchronized.
The computer apparatus of claim 9, wherein the processor is further configured to execute the at least one instruction to implement the following steps:

Displaying a selection page of the operation and maintenance operation, where the selection page includes an operation and maintenance operation and an operation and maintenance object;

The operation and maintenance operation instruction is triggered according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.
The computer apparatus according to claim 9, wherein said processor is operative to execute said at least one instruction to implement the following steps:

After the operation and maintenance of the operation and maintenance object to be operated, if the information about the abnormal operation of the BI tool is acquired, the alarm information is sent.
A non-volatile readable storage medium having stored thereon computer instructions, wherein the computer instructions are executed by a processor to implement the following steps:

Monitoring the running state of the BI tool, and triggering the operation and maintenance operation instruction when the running state of the BI tool meets the operation and maintenance condition;

Obtaining an operation and maintenance object indicated by the operation and maintenance operation instruction and a hierarchy of the operation and maintenance object;

Determining an operable object at the same level as the operation and maintenance object, and/or an operable object having a hierarchy lower than the hierarchy of the operation and maintenance object is an operation and maintenance object to be operated;

Performing operation and maintenance on the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction.
The storage medium of claim 15, wherein the operating state of the BI tool is monitored, and when the operating state of the BI tool meets the operation and maintenance condition, the operation and maintenance operation instruction is triggered, including:

Obtaining system resources consumed by the BI tool when it runs;

And when the system resource consumed by the BI tool exceeds a preset threshold, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to schedule a running process;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Controlling the pending server to suspend operation among the objects to be operated.
The storage medium of claim 15, wherein the operating state of the BI tool is monitored, and when the operating state of the BI tool meets the operation and maintenance condition, the operation and maintenance operation instruction is triggered, including:

Obtaining cache information of a server of the BI tool;

And when the cache size of the server reaches a preset cache value, triggering an operation and maintenance operation instruction, where the operation operation instruction is used to clean the cache of the server;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Obtaining a server that is not in a refresh state among the objects to be operated;

Clearing the cache of the server that is not in the refresh state among the objects to be operated.
The storage medium of claim 15, wherein the operating state of the BI tool is monitored, and when the operating state of the BI tool meets the operation and maintenance condition, the operation and maintenance operation instruction is triggered, including:

Obtaining the system time of the server of the BI tool;

If the system time is a preset time, triggering an operation and maintenance operation instruction, where the operation and maintenance operation instruction is used to perform data synchronization on the BI tool;

The operation and maintenance operation of the operation and maintenance object to be operated according to the operation and maintenance operation indicated by the operation and maintenance operation instruction includes:

Determining that the preset server among the objects to be operated is a server to be synchronized;

Data synchronization is performed on the server to be synchronized.
The storage medium of claim 15 wherein said computer instructions are further executed by said processor to:

Displaying a selection page of the operation and maintenance operation, where the selection page includes an operation and maintenance operation and an operation and maintenance object;

The operation and maintenance operation instruction is triggered according to the operation and maintenance operation and the operation and maintenance object selected from the selection page.
The storage medium of claim 15 wherein said computer instructions are executed by a processor to implement the following steps:

After the operation and maintenance of the operation and maintenance object to be operated, if the information about the abnormal operation of the BI tool is acquired, the alarm information is sent.