WO2019205344A1 - Report tool construction method and device, computer device, and storage medium - Google Patents

Report tool construction method and device, computer device, and storage medium Download PDF

Info

Publication number
WO2019205344A1
WO2019205344A1 PCT/CN2018/099772 CN2018099772W WO2019205344A1 WO 2019205344 A1 WO2019205344 A1 WO 2019205344A1 CN 2018099772 W CN2018099772 W CN 2018099772W WO 2019205344 A1 WO2019205344 A1 WO 2019205344A1
Authority
WO
WIPO (PCT)
Prior art keywords
pentaho
file
parameter
installation
obtaining
Prior art date
Application number
PCT/CN2018/099772
Other languages
French (fr)
Chinese (zh)
Inventor
宋剑锋
Original Assignee
平安科技(深圳)有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2019205344A1 publication Critical patent/WO2019205344A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/60Software deployment
    • G06F8/61Installation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/73Program documentation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/445Program loading or initiating
    • G06F9/44505Configuring for program initiating, e.g. using registry, configuration files

Definitions

  • the present application relates to the field of data mining technologies, and in particular, to a report tool construction method, device, computer device and storage medium.
  • 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.
  • Pentaho is an open source business intelligence analysis tool.
  • Pentaho Before applying Pentaho, Pentaho needs to be built (that is, from the running environment to the installation, so that Pentaho can run). In the prior art, when constructing Pentaho, it is usually required to perform manual tasks and perform a large number of manual operations (for example, custom installation on a Linux system), which is time-consuming, labor-intensive, and inefficient.
  • the application provides a method for constructing a report tool, the method comprising:
  • Pentaho parameter configuration file Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file.
  • the application also provides a reporting tool building device, the device comprising:
  • An environment initialization module is configured to receive a report construction instruction and initialize a Pentaho runtime environment
  • the installation module is configured to obtain a Pentaho installation file, and install Pentaho into the Pentaho running environment according to the installation information included in the report building instruction and the Pentaho installation file;
  • the configuration module is configured to obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
  • the application further 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 report described in any embodiment Tool construction method.
  • 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 reporting tool construction method.
  • the present application initializes the Pentaho running environment by receiving a report construction instruction; obtains a Pentaho installation file, and installs Pentaho to the Pentaho running environment according to the installation information included in the report construction instruction and the Pentaho installation file. Get the Pentaho parameter configuration file and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
  • FIG. 1 is a flowchart of a method for constructing a report tool according to an embodiment of the present application
  • FIG. 2 is a functional block diagram of a reporting tool construction device provided by an embodiment of the present application.
  • FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of a method for constructing a report tool according to the present application.
  • FIG. 1 is a flowchart of a method for constructing a report 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.
  • Pentaho runtime environment refers to the system environment when Pentaho is running.
  • the Pentaho runtime environment can be a Linux system, and at this time, Pentaho is applied to a Linux system.
  • the operation of Pentaho is based on the Linux operating system as an example.
  • the initialization of the Pentaho runtime environment includes but is not limited to: network initialization, security initialization, and user data initialization.
  • the initialization of the foregoing network may include an IP configuration.
  • the ip address included in the NIC file in the Linux system file can be modified by a script to perform network initialization.
  • the above security initialization may include firewall initialization.
  • the firewall of the Linux system can be automatically set by executing the iptables command.
  • the above user data initialization includes but is not limited to: creating a new user group, creating a new user, setting a user password, adding a user to a user group, and setting permissions for a new user. Specifically, you can create a user group by executing the addgroup command and create a new user by using useradd.
  • the initialization of the Pentaho runtime environment is not limited to the above mentioned ones, and may also include initialization of other environment variables. Specifically, which environment variables are configured during initialization differs depending on which operating system Pentaho runs.
  • the above Pentaho installation file refers to the installation file of the open source Pentaho software.
  • the specific storage directory can be a local storage directory or a remote storage directory.
  • the installation information included in the above report construction instruction may be installation-related information including an installation directory.
  • the above installation of Pentaho into the Pentaho runtime environment may specifically copy and save the Pentaho installation file in the installation directory of the Pentaho runtime environment.
  • obtaining the Pentaho installation file in the step S20 may include:
  • the above Pentaho source file is an open source Pentaho source code file.
  • the vulnerability to be fixed of the above Pentaho source file may be an existing discovered vulnerability.
  • the foregoing repairing the vulnerability to be repaired by the repair file may replace the file to be repaired with a related file of the vulnerability to be repaired, and replace a function code that has been developed with the function code in the source code.
  • the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired with a priority higher than a preset priority.
  • the preset priority may be set as needed. For example, the pending vulnerability of the Pentaho source file is divided into several levels, and the vulnerability to be fixed with a priority higher than a certain priority is selected.
  • the vulnerability is repaired according to the priority of the vulnerability to be repaired, and the vulnerability to be repaired with a higher priority can be repaired, so that the Pentaho source file does not have a system vulnerability that affects the running. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities with higher priority are repaired, so that the implementation does not affect the user's use, and the purpose of setting up the Pentaho report is saved.
  • the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired related to the specified function.
  • the above designated function can be preset as needed.
  • the vulnerability to be fixed in the Pentaho source file is a vulnerability to be fixed related to network security.
  • the function specified is that the frequency used in Pentaho is greater than the preset frequency.
  • the designated functions are not limited to the above mentioned ones, but may be other functions.
  • the vulnerability is repaired according to the function of the vulnerability to be repaired, and the vulnerability to be repaired related to the specified function can be repaired, so that when the specified function of the Pentaho is used, the abnormal error is reduced, and the stability of the Pentaho operation is improved. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities to be repaired related to the specified functions are repaired, so that the user does not affect the user's use and saves the construction time of the Pentaho report.
  • Pentaho has the A function
  • the code segment is m
  • the modified A function code segment is n
  • m is replaced with n, so that the Pentaho A function is implemented by the n code segment when it is executed.
  • the Pentaho file obtained through the above steps can improve the stability of the constructed Pentaho after the vulnerability is fixed, and can also improve the user experience when using the user. .
  • the obtaining the Pentaho installation file in the step S20 may further include:
  • the above Pentaho source file is an open source Pentaho source code file.
  • the above-mentioned module to be modified may be a functional module for secondary development of Pentaho.
  • the replacement file of the above-mentioned module to be modified can be obtained by searching for the file name of the specified file.
  • Pentaho Due to the use of Pentaho, some existing Pentaho function modules do not necessarily fully meet the user's needs. Therefore, through the above steps, the Pentaho installation file can be obtained, and the Pentaho system built is more suitable for the user's use requirements, and improves the user experience when the user is applied, and meets the actual needs of the user.
  • the module to be modified may include, but is not limited to, a report list optimization module, a My Folder module, a Favorites module, and a Recycle Bin module.
  • the report list optimization module is used to display the report in a friendly graphical user interface; my folder module is used to enable the user to modify the report according to their respective data requirements, and save it as their own report; the favorites function is used to Important report collection; the Recycle Bin module, which is used to delete the report saved in the My Folders module and send it to the Recycle Bin.
  • the code module for implementing the new function when obtaining the Pentaho installation file, may be obtained and integrated into the Pentaho source file, so that the obtained Pentaho installation file is more powerful.
  • the above Pentaho parameter configuration file may include parameters to be configured, and values of parameters to be configured.
  • the parameter initialization of the installed Pentaho according to the Pentaho parameter configuration file includes:
  • Performing parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file includes:
  • the installation folder of the above Pentaho installation is a folder for storing Pentaho after running Pentaho on the operating system, and for supporting files run by Pentaho.
  • the above installation folder includes a parameter file (such as a file in xml format) that stores Pentaho running parameters.
  • the running parameter in the parameter file is assigned by using the parameter to be configured, the same parameter as the parameter to be configured in the parameter file is obtained for assignment. For example, if the parameter to be configured includes the parameter a, the value of the parameter a in the parameter file to be configured is assigned to the running parameter a in the parameter file.
  • the parameter may be an address of the data source, a user access name of the data source, a user access password of the data source, and the like, and the address of the data source to be accessed, the user access name of the data source, and the data source may be scripted. User access passwords and other parameters are assigned.
  • Jdbc_username exampleuser
  • Jdbc_url jdbc:postgresql/.../$ ⁇ sid ⁇
  • Jdbc_url is the address of the data source to be accessed
  • Jdbc_password is the user access password of the data source
  • the ip is the address of the database to be accessed
  • the port is the port of the database to be accessed. Number, the unique identifier of the database to which the above sid is to be accessed.
  • the xml file for defining the parameters related to the Pentaho runtime can also be accessed through a pre-written program, and the values of some of the parameters, or code segments, are replaced.
  • the following example is an example of replacing the username and password in the pentaho.xml file. By replacing, you can look up the actual value of username and password based on the new assignment when reading the username and password.
  • driverClassName org.postgresql.Driver
  • Pentaho can be performed according to actual needs, and is not limited to the items mentioned in the above examples.
  • the method of the present application may further include: after obtaining the Pentaho parameter configuration file, before receiving the parameter initialization, if the parameter tuning instruction is received, determining that the Pentaho parameter configuration file is included
  • the parameters to be tuned are optimized; and the parameters to be tuned are optimized and adjusted.
  • the parameter to be tuned refers to a parameter that needs to be adjusted.
  • the determining the parameter to be tuned included in the Pentaho parameter configuration file may include: determining that the preset parameter in the Pentaho parameter configuration file is a parameter to be tuned.
  • the above optimization of the tuning parameters includes: re-assigning the tuning parameters.
  • the new value assigned to the parameter to be tuned may be a parameter value used in other environments where Pentaho has been applied.
  • Pentaho has been applied.
  • user session hold ie maximum number of seconds for user’s session
  • user session hold parameter is used to define how long a timeout prompt is generated without obtaining data. If the default setting is 30s and the value of the user session held in the history is 60s, adjust it to 60s. In actual use, after 30s users do not get the data, there will be no timeout prompt, and the timeout prompt will be generated when the data cannot be obtained after 60s.
  • the tuning parameters by tuning the tuning parameters, the user experience is more friendly when the built Pentaho system is running.
  • the setting of the parameter value to be tuned is set according to the historical record, which is more in line with the actual needs of the user.
  • the method described in the present application may further include:
  • the function code associated with the installed Pentaho may be a program that assists the Pentaho operation or assists the user operation.
  • the report execution plan can be initiated by a data driven execution plan, and the execution sequence is controlled by other BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
  • BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
  • the log monitor can monitor the output log during the use of Pentaho, which can be used to analyze the log or handle the alarm. For example, the log monitor reads the logs generated during the use of Pentaho, and if an initial keyword is obtained, an alert is issued.
  • the report tool construction method provided by the application receives the report construction instruction, initializes the Pentaho runtime environment, obtains the Pentaho installation file, and installs the Pentaho into the Pentaho runtime environment according to the installation information included in the report construction instruction and the Pentaho installation file; Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
  • FIG. 2 is a functional block diagram of a reporting tool construction device according to an embodiment of the present application.
  • the report tool building device includes an environment initialization module 210, an installation module 220, and a configuration module 230.
  • 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.
  • the functions of the respective modules will be described in detail in the subsequent embodiments.
  • the environment initialization module 210 is configured to receive a report construction instruction and initialize the Pentaho runtime environment.
  • Pentaho runtime environment refers to the system environment when Pentaho is running.
  • the Pentaho runtime environment can be a Linux system, and at this time, Pentaho is applied to a Linux system.
  • the operation of Pentaho is based on the Linux operating system as an example.
  • the initialization of the Pentaho runtime environment includes but is not limited to: network initialization, security initialization, and user data initialization.
  • the initialization of the foregoing network may include an IP configuration.
  • the ip address included in the NIC file in the Linux system file can be modified by a script to perform network initialization.
  • the above security initialization may include firewall initialization.
  • the firewall of the Linux system can be automatically set by executing the iptables command.
  • the above user data initialization includes but is not limited to: creating a new user group, creating a new user, setting a user password, adding a user to a user group, and setting permissions for a new user. Specifically, you can create a user group by executing the addgroup command and create a new user by useradd.
  • the initialization of the Pentaho runtime environment is not limited to the above mentioned ones, and may also include initialization of other environment variables. Specifically, which environment variables are configured during initialization differs depending on which operating system Pentaho runs.
  • the installation module 220 is configured to acquire a Pentaho installation file, and install Pentaho into the Pentaho runtime environment according to the installation information included in the report construction instruction and the Pentaho installation file.
  • the above Pentaho installation file refers to the installation file of the open source Pentaho software.
  • the specific storage directory can be a local storage directory or a remote storage directory.
  • the installation information included in the above report construction instruction may be installation-related information including an installation directory.
  • the above installation of Pentaho into the Pentaho runtime environment may specifically copy and save the Pentaho installation file in the installation directory of the Pentaho runtime environment.
  • the obtaining, by the installation module 220, the Pentaho installation file may include:
  • the above Pentaho source file is an open source Pentaho source code file.
  • the vulnerability to be fixed of the above Pentaho source file may be an existing discovered vulnerability.
  • the foregoing repairing the vulnerability to be repaired by the repair file may replace the file to be repaired with a related file of the vulnerability to be repaired, and replace a function code that has been developed with the function code in the source code.
  • the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired with a priority higher than a preset priority.
  • the preset priority may be set as needed. For example, the pending vulnerability of the Pentaho source file is divided into several levels, and the vulnerability to be fixed with a priority higher than a certain priority is selected.
  • the vulnerability is repaired according to the priority of the vulnerability to be repaired, and the vulnerability to be repaired with a higher priority can be repaired, so that the Pentaho source file does not have a system vulnerability that affects the running. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities with higher priority are repaired, so that the implementation does not affect the user's use, and the purpose of setting up the Pentaho report is saved.
  • the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired related to the specified function.
  • the above designated function can be preset as needed.
  • the vulnerability to be fixed in the Pentaho source file is a vulnerability to be fixed related to network security.
  • the function specified is that the frequency used in Pentaho is greater than the preset frequency.
  • the designated functions are not limited to the above mentioned ones, but may be other functions.
  • the vulnerability is repaired according to the function of the vulnerability to be repaired, and the vulnerability to be repaired related to the specified function can be repaired, so that when the specified function of the Pentaho is used, the abnormal error is reduced, and the stability of the Pentaho operation is improved. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities to be repaired related to the specified functions are repaired, so that the user does not affect the user's use and saves the construction time of the Pentaho report.
  • Pentaho has the A function
  • the code segment is m
  • the modified A function code segment is n
  • m is replaced with n, so that the Pentaho A function is implemented by the n code segment when it is executed.
  • the Pentaho file obtained by the embodiment can improve the stability of the Pentaho after the installation, and can also improve the user when using the user. Experience.
  • the obtaining, by the installation module 220, the Pentaho installation file may further include:
  • the above Pentaho source file is an open source Pentaho source code file.
  • the above-mentioned module to be modified may be a functional module for secondary development of Pentaho.
  • the replacement file of the above-mentioned module to be modified can be obtained by searching for the file name of the specified file.
  • the installation module 220 in this embodiment obtains the Pentaho installation file, and the Pentaho system is more suitable for the user's use requirements, and improves the user experience when the user is applied, and meets the actual needs of the user.
  • the module to be modified may include, but is not limited to, a report list optimization module, a My Folder module, a Favorites module, and a Recycle Bin module.
  • the report list optimization module is used to display the report in a friendly graphical user interface; my folder module is used to enable the user to modify the report according to their respective data requirements, and save it as their own report; the favorites function is used to Important report collection; the Recycle Bin module, which is used to delete the report saved in the My Folders module and send it to the Recycle Bin.
  • the code module for implementing the new function when obtaining the Pentaho installation file, may be obtained and integrated into the Pentaho source file, so that the obtained Pentaho installation file is more powerful.
  • the configuration module 230 is configured to obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
  • the above Pentaho parameter configuration file may include parameters to be configured, and attribute values of parameters to be configured.
  • the configuration module 230 is specifically configured to:
  • Performing parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file includes:
  • the installation folder of the above Pentaho installation is a folder for storing Pentaho after running Pentaho on the operating system, and for supporting files run by Pentaho.
  • the above installation folder includes a parameter file (such as a file in xml format) that stores Pentaho running parameters.
  • the running parameter in the parameter file is assigned by using the parameter to be configured, the same parameter as the parameter to be configured in the parameter file is obtained for assignment. For example, if the parameter to be configured includes the parameter a, the value of the parameter a in the parameter file to be configured is assigned to the running parameter a in the parameter file.
  • the parameter may be an address of the data source, a user access name of the data source, a user access password of the data source, and the like, and the address of the data source to be accessed, the user access name of the data source, and the data source may be scripted. User access passwords and other parameters are assigned.
  • Jdbc_username exampleuser
  • Jdbc_url jdbc:postgresql/.../$ ⁇ sid ⁇
  • Jdbc_url is the address of the data source to be accessed
  • Jdbc_password is the user access password of the data source
  • the ip is the address of the database to be accessed
  • the port is the port of the database to be accessed. Number, the unique identifier of the database to which the above sid is to be accessed.
  • the xml file for defining the parameters related to the Pentaho runtime can also be accessed through a pre-written program, and the values of some of the parameters, or code segments, are replaced.
  • the following example is an example of replacing the username and password in the pentaho.xml file. By replacing, you can look up the actual value of username and password based on the new assignment when reading the username and password.
  • driverClassName org.postgresql.Driver
  • Pentaho can be performed according to actual needs, and is not limited to the items mentioned in the above examples.
  • the apparatus described in the present application may further include a determining module and a tuning module.
  • the determining module is configured to: after obtaining the Pentaho parameter configuration file, before receiving the parameter initialization, if the parameter tuning instruction is received, determine the to-be-tuned parameter included in the Pentaho parameter configuration file.
  • the tuning module is configured to optimize and adjust the to-be-tuned parameters.
  • the parameter to be tuned refers to a parameter that needs to be adjusted.
  • the determining the parameter to be tuned included in the Pentaho parameter configuration file may include: determining that the preset parameter in the Pentaho parameter configuration file is a parameter to be tuned.
  • the above optimization of the tuning parameters includes: re-assigning the tuning parameters.
  • the new value assigned to the parameter to be tuned may be a parameter value used in other environments where Pentaho has been applied.
  • Pentaho has been applied.
  • user session hold ie maximum number of seconds for user’s session
  • user session hold parameter is used to define how long a timeout prompt is generated without obtaining data. If the default setting is 30s and the value of the user session held in the history is 60s, adjust it to 60s. In actual use, after 30s users do not get the data, there will be no timeout prompt, and the timeout prompt will be generated when the data cannot be obtained after 60s.
  • the tuning parameters by tuning the tuning parameters, the user experience is more friendly when the built Pentaho system is running.
  • the setting of the parameter value to be tuned is set according to the historical record, which is more in line with the actual needs of the user.
  • the apparatus described in the present application may further include:
  • the deployment module is configured to receive a deployment instruction, and deploy a functional code related to the installed Pentaho according to the deployment instruction.
  • the function code related to the installed Pentaho may be a program that assists the Pentaho operation or assists the user operation.
  • the report execution plan can be initiated by a data driven execution plan, and the execution sequence is controlled by other BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
  • BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
  • the log monitor can monitor the output log during the use of Pentaho, which can be used to analyze the log or handle the alarm. For example, the log monitor reads the logs generated during the use of Pentaho, and if an initial keyword is obtained, an alert is issued.
  • the report tool setting device receives the report construction instruction through the environment initialization module, and initializes the Pentaho runtime environment; the installation module acquires the Pentaho installation file, and installs the Pentaho according to the installation information included in the report construction instruction and the Pentaho installation file.
  • the configuration module obtains a Pentaho parameter configuration file, and initializes the installed Pentaho parameters according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
  • the above-described integrated unit implemented in the form of a software function module 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.
  • FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of the present invention.
  • 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.
  • 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 Internet 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.
  • VPN virtual private network
  • 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) memory, or the like.
  • 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.
  • the various units described in FIG. 3 are program code stored in the memory 32 and executed by the processor 33 to implement a reporting tool building method.
  • 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).
  • 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.
  • 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.

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Library & Information Science (AREA)
  • Stored Programmes (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present application provides a report tool creation method, comprising: receiving a report creation instruction, and initializing a Pentaho runtime environment; acquiring a Pentaho installation file, and installing, according to installation information contained in the report creation instruction and the Pentaho installation file, Pentaho in the Pentaho runtime environment; and acquiring a Pentaho parameter configuration file, and performing parameter initialization on the installed Pentaho platform according to the Pentaho parameter configuration file. The present application also discloses a report tool creation device, a computer device, and a storage medium. The present application improves report creation efficiency of a Pentaho platform.

Description

报表工具搭建方法、装置、计算机装置及存储介质Reporting tool construction method, device, computer device and storage medium
本申请要求于2018年04月23日提交中国专利局,申请号为201810367323.2发明名称为“报表工具搭建方法、装置、计算机装置及存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of the Chinese Patent Application filed on April 23, 2018, the Chinese Patent Application No. 201101367323.2, entitled "Reporting Tool Construction Method, Apparatus, Computer Device, and Storage Medium", the entire contents of which are incorporated by reference. In this application.
技术领域Technical field
本申请涉及数据挖掘技术领域,尤其涉及一种报表工具搭建方法、装置、计算机装置及存储介质。The present application relates to the field of data mining technologies, and in particular, to a report tool construction method, device, computer device and storage medium.
背景技术Background technique
商业智能(Business Intelligence,BI)分析工具也称为BI工具。BI工具是一种将企业中应用的各系统数据进行有效的整合,快速准确地提供报表的工具,可以帮助使用者了解所需的企业信息以及帮助使用者做出经营决策。其中,Pentaho是一种开源的商务智能分析工具。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. Among them, Pentaho is an open source business intelligence analysis tool.
目前,在应用Pentaho之前,需要对Pentaho进行搭建(即完成从运行环境到安装等,以使Pentaho能够运行)。而现有技术中,在对Pentaho进行搭建时,通常需要人工值守并且进行大量的手工作业(例如,在Linux系统上做定制安装),耗时耗力,效率不高。Currently, before applying Pentaho, Pentaho needs to be built (that is, from the running environment to the installation, so that Pentaho can run). In the prior art, when constructing Pentaho, it is usually required to perform manual tasks and perform a large number of manual operations (for example, custom installation on a Linux system), which is time-consuming, labor-intensive, and inefficient.
发明内容Summary of the invention
鉴于以上内容,有必要提供一种报表工具搭建方法、装置、计算机装置及存储介质,能提高Pentaho搭建的效率。In view of the above, it is necessary to provide a reporting tool construction method, device, computer device and storage medium, which can improve the efficiency of Pentaho construction.
本申请提供一种报表工具搭建方法,所述方法包括:The application provides a method for constructing a report tool, the method comprising:
接收报表搭建指令,初始化Pentaho运行环境;Receive report build instructions to initialize the Pentaho runtime environment;
获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;Obtaining a Pentaho installation file, and installing Pentaho into the Pentaho runtime environment according to the installation information included in the report building instruction and the Pentaho installation file;
获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file.
本申请还提供一种报表工具搭建装置,所述装置包括:The application also provides a reporting tool building device, the device comprising:
环境初始化模块,用于接收报表搭建指令,初始化Pentaho运行环境;An environment initialization module is configured to receive a report construction instruction and initialize a Pentaho runtime environment;
安装模块,用于获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;The installation module is configured to obtain a Pentaho installation file, and install Pentaho into the Pentaho running environment according to the installation information included in the report building instruction and the Pentaho installation file;
配置模块,用于获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。The configuration module is configured to obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
本申请还提供一种计算机装置,所述计算机装置包括存储器及处理器,所述存储器用于存储至少一个指令,所述处理器用于执行所述至少一个指令以实现任意实施例中所述的报表工具搭建方法。The application further 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 report described in any embodiment Tool construction method.
本申请还提供一种非易失性可读存储介质,其特征在于,所述非易失性可读存储介质存储有至少一个指令,所述至少一个指令被处理器执行时实现任意实施例中所述的报表工具搭建方法。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 reporting tool construction method.
由以上技术方案看出,本申请通过接收报表搭建指令,初始化Pentaho运行环境;获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。由于接收报表搭建指令后完成了初始化Pentaho环境到参数配置的全过程,无需用户进行大量的手动作业,从而提高了Pentaho搭建的效率。As seen from the above technical solution, the present application initializes the Pentaho running environment by receiving a report construction instruction; obtains a Pentaho installation file, and installs Pentaho to the Pentaho running environment according to the installation information included in the report construction instruction and the Pentaho installation file. Get the Pentaho parameter configuration file and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
附图说明DRAWINGS
为了更清楚地说明本申请实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据提供的附图获得其他的附图。In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings to be used in the embodiments or the prior art description will be briefly described below. Obviously, the drawings in the following description are only It is an embodiment of the present application, and those skilled in the art can obtain other drawings according to the provided drawings without any creative work.
图1是本申请实施例提供的一种报表工具搭建方法的流程图;1 is a flowchart of a method for constructing a report tool according to an embodiment of the present application;
图2是本申请实施例提供的报表工具搭建装置的功能模块图;2 is a functional block diagram of a reporting tool construction device provided by an embodiment of the present application;
图3是本申请实现报表工具搭建方法的较佳实施例的计算机装置的结构示意图。FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of a method for constructing a report tool according to the present application.
具体实施方式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.
如图1所示,图1为本申请实施例提供的一种报表工具搭建方法的流程图。根据不同的需求,该流程图中步骤的顺序可以改变,某些步骤可以省略。As shown in FIG. 1 , FIG. 1 is a flowchart of a method for constructing a report 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,接收报表搭建指令,初始化Pentaho运行环境。S10, receiving a report construction instruction, and initializing the Pentaho running environment.
上述报表搭建指令用于进行Pentaho报表搭建。The above report building instructions are used to build Pentaho reports.
上述Pentaho运行环境是指Pentaho运行时的系统环境。例如,Pentaho运行环境可以为Linux系统,则此时,Pentaho应用于Linux系统上。The above Pentaho runtime environment refers to the system environment when Pentaho is running. For example, the Pentaho runtime environment can be a Linux system, and at this time, Pentaho is applied to a Linux system.
初始化Pentaho运行环境的哪些方面根据Pentaho运行时的操作系统而 异。The aspects of initializing the Pentaho runtime environment vary depending on the operating system of the Pentaho runtime.
本实施例中,以Pentaho的运行基于Linux操作系统为例进行说明。当获取到Pentaho运行环境为Linux环境时,初始化Pentaho运行环境包括但不限于:网络初始化、安全初始化、用户数据初始化。In this embodiment, the operation of Pentaho is based on the Linux operating system as an example. When the Pentaho runtime environment is obtained as a Linux environment, the initialization of the Pentaho runtime environment includes but is not limited to: network initialization, security initialization, and user data initialization.
其中,上述网络的初始化可以包括IP配置。具体的,可以通过脚本修改Linux系统文件中网卡文件中包含的ip地址,以进行网络初始化。The initialization of the foregoing network may include an IP configuration. Specifically, the ip address included in the NIC file in the Linux system file can be modified by a script to perform network initialization.
上述安全初始化可以包括防火墙初始化。具体的,可以通过执行iptables命令对Linux系统的防火墙进行自动设置。The above security initialization may include firewall initialization. Specifically, the firewall of the Linux system can be automatically set by executing the iptables command.
上述用户数据初始化包括但不限于:新建用户组、新建用户、设置用户密码、添加用户到用户组,以及为新用户设定权限等。具体的,可以通过执行addgroup命令创建用户组,通过useradd新建用户。The above user data initialization includes but is not limited to: creating a new user group, creating a new user, setting a user password, adding a user to a user group, and setting permissions for a new user. Specifically, you can create a user group by executing the addgroup command and create a new user by using useradd.
同时,初始化Pentaho运行环境不限于以上提到的几种,也可以包括其他环境变量的初始化,具体的,初始化时进行哪些环境变量的配置因Pentaho运行基于哪个操作系统而异。At the same time, the initialization of the Pentaho runtime environment is not limited to the above mentioned ones, and may also include initialization of other environment variables. Specifically, which environment variables are configured during initialization differs depending on which operating system Pentaho runs.
S20,获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中。S20. Acquire a Pentaho installation file, and install Pentaho into the Pentaho running environment according to the installation information included in the report building instruction and the Pentaho installation file.
上述Pentaho安装文件是指开源的Pentaho软件的安装文件。The above Pentaho installation file refers to the installation file of the open source Pentaho software.
在具体实现时,可以从指定的存储目录中获取。具体的存储目录可以是本地的存储目录或者是远程的存储目录。In the specific implementation, it can be obtained from the specified storage directory. The specific storage directory can be a local storage directory or a remote storage directory.
上述报表搭建指令包含的安装信息可以是包含安装目录等与安装相关的信息。上述将Pentaho安装至所述Pentaho运行环境中具体可以是,将Pentaho安装文件复制并保存于Pentaho运行环境的安装目录中。The installation information included in the above report construction instruction may be installation-related information including an installation directory. The above installation of Pentaho into the Pentaho runtime environment may specifically copy and save the Pentaho installation file in the installation directory of the Pentaho runtime environment.
可选的,在本申请其他实施例中,所述步骤S20中获取Pentaho安装文件可包括:Optionally, in other embodiments of the present application, obtaining the Pentaho installation file in the step S20 may include:
(1)获取Pentaho源文件。(1) Obtain the Pentaho source file.
(2)获取所述Pentaho源文件的待修复漏洞,以及所述待修复漏洞的修复文件。(2) Obtaining a to-be-repaired vulnerability of the Pentaho source file, and a repair file of the vulnerability to be repaired.
(3)根据所述待修复漏洞的修复文件修复所述待修复漏洞,得到所述Pentaho安装文件。(3) repairing the to-be-repaired vulnerability according to the repair file of the vulnerability to be repaired, and obtaining the Pentaho installation file.
其中,上述Pentaho源文件是开源的Pentaho源代码文件。上述Pentaho源文件的待修复漏洞可以为现有的已发现漏洞。Among them, the above Pentaho source file is an open source Pentaho source code file. The vulnerability to be fixed of the above Pentaho source file may be an existing discovered vulnerability.
上述通过修复文件修复所述待修复漏洞,可以是将待修复文件替换待修复漏洞的相关文件,即将已开发的某一功能代码替换掉源代码中的该功能代码。The foregoing repairing the vulnerability to be repaired by the repair file may replace the file to be repaired with a related file of the vulnerability to be repaired, and replace a function code that has been developed with the function code in the source code.
可选的,在本申请另一实施例中,所述Pentaho源文件的待修复漏洞为优先级高于预设优先级的待修复漏洞。Optionally, in another embodiment of the present application, the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired with a priority higher than a preset priority.
其中,上述预设优先级可以根据需要设定。例如Pentaho源文件的待修复漏洞分为几个等级,选取优先级高于某一优先级的待修复漏洞。The preset priority may be set as needed. For example, the pending vulnerability of the Pentaho source file is divided into several levels, and the vulnerability to be fixed with a priority higher than a certain priority is selected.
本实施例根据待修复漏洞的优先级进行漏洞修复,可以将优先级较高的 待修复漏洞进行修复,使得Pentaho源文件不存在影响运行较大的系统漏洞。并且,不对所有的待修复漏洞进行修复,仅修复部分优先级较高的漏洞,实现即不影响用户使用,又节省Pentaho报表的搭建时间的目的。In this embodiment, the vulnerability is repaired according to the priority of the vulnerability to be repaired, and the vulnerability to be repaired with a higher priority can be repaired, so that the Pentaho source file does not have a system vulnerability that affects the running. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities with higher priority are repaired, so that the implementation does not affect the user's use, and the purpose of setting up the Pentaho report is saved.
可选的,在本申请另一实施例中,所述Pentaho源文件的待修复漏洞为与指定功能相关的待修复漏洞。Optionally, in another embodiment of the present application, the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired related to the specified function.
其中,上述指定功能可以根据需要预先设定。例如,Pentaho源文件的待修复漏洞为与网络安全相关的待修复漏洞。或者,指定功能为Pentaho中使用频率大于预设频率的功能。The above designated function can be preset as needed. For example, the vulnerability to be fixed in the Pentaho source file is a vulnerability to be fixed related to network security. Or, the function specified is that the frequency used in Pentaho is greater than the preset frequency.
同时,指定功能不限于以上提到的几种,还可以是其他功能。At the same time, the designated functions are not limited to the above mentioned ones, but may be other functions.
本实施例根据待修复漏洞的功能进行漏洞修复,可以将指定功能相关的待修复漏洞进行修复,使得在使用Pentaho的指定功能时,减少异常报错,提高Pentaho运行的稳定性。并且,不对所有的待修复漏洞进行修复,仅修复部分与指定功能相关的待修复漏洞,实现即不影响用户使用,又节省Pentaho报表的搭建时间的目的。In this embodiment, the vulnerability is repaired according to the function of the vulnerability to be repaired, and the vulnerability to be repaired related to the specified function can be repaired, so that when the specified function of the Pentaho is used, the abnormal error is reduced, and the stability of the Pentaho operation is improved. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities to be repaired related to the specified functions are repaired, so that the user does not affect the user's use and saves the construction time of the Pentaho report.
例如,若Pentaho有A功能,代码段为m,修改后的A功能代码段为n,则用n替换m,使得Pentaho的A功能在执行时,通过n代码段实现。For example, if Pentaho has the A function, the code segment is m, and the modified A function code segment is n, then m is replaced with n, so that the Pentaho A function is implemented by the n code segment when it is executed.
在本实施例中,由于Pentaho的源代码可能存在系统漏洞,因此,通过以上步骤获取到的Pentaho文件由于修复了漏洞可以使得搭建后的Pentaho稳定性更高,也可以提高用户使用时的用户体验。In this embodiment, since the source code of Pentaho may have a system vulnerability, the Pentaho file obtained through the above steps can improve the stability of the constructed Pentaho after the vulnerability is fixed, and can also improve the user experience when using the user. .
可选的,在本申请其他实施例中,所述步骤S20中获取Pentaho安装文件还可包括:Optionally, in other embodiments of the present application, the obtaining the Pentaho installation file in the step S20 may further include:
(1)获取Pentaho源文件。(1) Obtain the Pentaho source file.
(2)获取所述Pentaho源文件的待修改模块,以及所述待修改模块的替换文件。(2) Obtaining a module to be modified of the Pentaho source file, and a replacement file of the module to be modified.
(3)根据所述替换文件修改所述待修改模块,得到所述Pentaho安装文件。(3) modifying the module to be modified according to the replacement file to obtain the Pentaho installation file.
其中,上述Pentaho源文件是开源的Pentaho源代码文件。上述待修改模块可以是对Pentaho进行了二次开发的功能模块。上述待修改模块的替换文件可以通过查找指定文件的文件名来进行获取。Among them, the above Pentaho source file is an open source Pentaho source code file. The above-mentioned module to be modified may be a functional module for secondary development of Pentaho. The replacement file of the above-mentioned module to be modified can be obtained by searching for the file name of the specified file.
由于在使用Pentaho过程中,某些已有的Pentaho功能模块并不一定完全符合用户需求。因此可以通过以上步骤,得到Pentaho安装文件,进而搭建的Pentaho系统更符合用户的使用需求,提高用户应用时的用户体验,符合用户的实际需求。Due to the use of Pentaho, some existing Pentaho function modules do not necessarily fully meet the user's needs. Therefore, through the above steps, the Pentaho installation file can be obtained, and the Pentaho system built is more suitable for the user's use requirements, and improves the user experience when the user is applied, and meets the actual needs of the user.
具体实施时,待修改模块可以包括但不限于:报表清单优化模块、我的文件夹模块、收藏夹模块、回收站模块。In a specific implementation, the module to be modified may include, but is not limited to, a report list optimization module, a My Folder module, a Favorites module, and a Recycle Bin module.
其中,报表清单优化模块,用于以友好的图形用户界面展示报表;我的文件夹模块,用于使用户按各自的数据需求修改后,保存为自己专属的报表;收藏夹功能,用于将重要报表收藏;回收站模块,用于删除我的文件夹模块中保存的报表,发送至回收站。The report list optimization module is used to display the report in a friendly graphical user interface; my folder module is used to enable the user to modify the report according to their respective data requirements, and save it as their own report; the favorites function is used to Important report collection; the Recycle Bin module, which is used to delete the report saved in the My Folders module and send it to the Recycle Bin.
同时,在本申请其他实施例中,还可以在获取Pentaho安装文件时,获取实现新增功能的代码模块,并集成至Pentaho源文件中,使得获取到的Pentaho安装文件的功能更加强大。In addition, in other embodiments of the present application, when obtaining the Pentaho installation file, the code module for implementing the new function may be obtained and integrated into the Pentaho source file, so that the obtained Pentaho installation file is more powerful.
S30,获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。S30: Obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
上述Pentaho参数配置文件可以包括待配置参数,以及待配置参数的值。The above Pentaho parameter configuration file may include parameters to be configured, and values of parameters to be configured.
在进行参数初始化时,将Pentaho参数配置文件中的待配置参数进行赋值。When parameter initialization is performed, the parameters to be configured in the Pentaho parameter configuration file are assigned.
可选的,所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:Optionally, the parameter initialization of the installed Pentaho according to the Pentaho parameter configuration file includes:
所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:Performing parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file includes:
(1)获取所述Pentaho参数配置文件中的待配置参数;(1) Obtain a parameter to be configured in the Pentaho parameter configuration file;
(2)获取Pentaho安装后的安装文件夹中保存运行参数的参数文件;(2) Obtain the parameter file for saving the running parameters in the installation folder after Pentaho installation;
(3)利用所述待配置参数对所述参数文件中的运行参数赋值。(3) assigning a value to the running parameter in the parameter file by using the parameter to be configured.
上述Pentaho安装后的安装文件夹是将Pentaho安装在操作系统上之后,保存Pentaho运行时的相关信息,以及支持Pentaho运行的文件的文件夹。The installation folder of the above Pentaho installation is a folder for storing Pentaho after running Pentaho on the operating system, and for supporting files run by Pentaho.
上述安装文件夹中包括保存Pentaho运行参数的参数文件(如xml格式的文件)。The above installation folder includes a parameter file (such as a file in xml format) that stores Pentaho running parameters.
在利用待配置参数对参数文件中的运行参数赋值时,获取参数文件中与待配置参数相同的参数进行赋值。例如待配置参数包括参数a,则将待配置参数文件中参数a的值赋给参数文件中运行参数a。When the running parameter in the parameter file is assigned by using the parameter to be configured, the same parameter as the parameter to be configured in the parameter file is obtained for assignment. For example, if the parameter to be configured includes the parameter a, the value of the parameter a in the parameter file to be configured is assigned to the running parameter a in the parameter file.
具体实施时,参数可以是数据源的地址、数据源的用户访问名称、数据源的用户访问密码等参数,并且可以通过脚本对要访问的数据源的地址、数据源的用户访问名称、数据源的用户访问密码等参数进行赋值。In specific implementation, the parameter may be an address of the data source, a user access name of the data source, a user access password of the data source, and the like, and the address of the data source to be accessed, the user access name of the data source, and the data source may be scripted. User access passwords and other parameters are assigned.
以下为对参数进行赋值的示例:The following is an example of assigning a parameter:
ip=10.20.30.40Ip=10.20.30.40
port=12345Port=12345
sid=examplesidSid=examplesid
jdbc_username=exampleuserJdbc_username=exampleuser
jdbc_password=examplepwdJdbc_password=examplepwd
jdbc_url=jdbc:postgresql/…/${sid}Jdbc_url=jdbc:postgresql/.../${sid}
其中,上述Jdbc_url为要访问的数据源的地址,上述Jdbc_username数据源的用户访问名称,Jdbc_password为数据源的用户访问密码,上述ip是要访问的数据库的地址,上述port是要访问的数据库的端口号,上述sid要访问的数据库的唯一标识符。Wherein, the above Jdbc_url is the address of the data source to be accessed, the user access name of the Jdbc_username data source, Jdbc_password is the user access password of the data source, the ip is the address of the database to be accessed, and the port is the port of the database to be accessed. Number, the unique identifier of the database to which the above sid is to be accessed.
同时,在参数初始化时,还可以通过预先编写好的程序访问用于定义Pentaho运行时相关参数的xml文件,并且替换其中部分参数的值,或者是代码段。At the same time, when the parameters are initialized, the xml file for defining the parameters related to the Pentaho runtime can also be accessed through a pre-written program, and the values of some of the parameters, or code segments, are replaced.
例如,以下示例为对于pentaho.xml文件,替换掉其中的username以及password的示例,通过替换,可以在读取该username和password时,根据新的赋值来查找username以及password的实际值。For example, the following example is an example of replacing the username and password in the pentaho.xml file. By replacing, you can look up the actual value of username and password based on the new assignment when reading the username and password.
<?xml version="1.0"encoding="UTF-8"?><? Xml version="1.0"encoding="UTF-8"? >
<Context path="/pentaho"docbase="webapps/pentaho/"><Context path="/pentaho"docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate"auth="Container"type="javax.sql.DataSource"<Resource name="jdbc/Hibernate"auth="Container"type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"Factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="20000"maxIdle="5000"maxActive="20000"maxIdle="5000"
maxWait="10000000"username="${jdbc_username}"password="${jdbc_password}"maxWait="10000000"username="${jdbc_username}"password="${jdbc_password}"
driverClassName="org.postgresql.Driver"driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://${ip}:${port}/${sid}"Url="jdbc:postgresql://${ip}:${port}/${sid}"
validationQuery="select 1from dual"/>validationQuery="select 1from dual"/>
</Context></Context>
可以理解的,对Pentaho进行哪些参数初始化可以根据实际需要来进行,不限于以上举例中提到的几项。It can be understood that the parameter initialization of Pentaho can be performed according to actual needs, and is not limited to the items mentioned in the above examples.
进一步地,在本申请其他实施例中,本申请所述的方法还可包括:获取Pentaho参数配置文件之后,进行参数初始化之前,若接收到参数调优指令,确定所述Pentaho参数配置文件包含的待调优参数;以及对所述待调优参数进行优化调整。Further, in other embodiments of the present application, the method of the present application may further include: after obtaining the Pentaho parameter configuration file, before receiving the parameter initialization, if the parameter tuning instruction is received, determining that the Pentaho parameter configuration file is included The parameters to be tuned are optimized; and the parameters to be tuned are optimized and adjusted.
其中,上述待调优参数是指需要进行调优设置的参数。The parameter to be tuned refers to a parameter that needs to be adjusted.
上述确定Pentaho参数配置文件包含的待调优参数可以包括:确定Pentaho参数配置文件中的预设参数为待调优参数。The determining the parameter to be tuned included in the Pentaho parameter configuration file may include: determining that the preset parameter in the Pentaho parameter configuration file is a parameter to be tuned.
上述对待调优参数进行优化调整包括:对待调优参数进行重新赋值。The above optimization of the tuning parameters includes: re-assigning the tuning parameters.
具体的,赋予待调优参数的新的值可以是在其他已应用Pentaho的环境中使用过的参数值。通过历史记录中待调优参数的参数值来进行修改,可以使待调优参数更符合用户使用时的实际需求,提高用户体验。Specifically, the new value assigned to the parameter to be tuned may be a parameter value used in other environments where Pentaho has been applied. By modifying the parameter values of the parameters to be tuned in the history record, the parameters to be tuned can be more in line with the actual needs of the user and improve the user experience.
例如,用户会话保持,即maximum number of seconds for user’s session,用户会话保持这一参数用于定义在没有获取到数据的情况下经过多长时间产生超时提示。若默认设置为30s,而获取到历史记录中用户会话保持的值为60s,则将其调整为60s。在实际使用的时候,经过30s用户没有获取到数据,并不会产生超时提示,在经过60s仍无法获取到数据时,才产生超时提示。For example, user session hold, ie maximum number of seconds for user’s session, user session hold parameter is used to define how long a timeout prompt is generated without obtaining data. If the default setting is 30s and the value of the user session held in the history is 60s, adjust it to 60s. In actual use, after 30s users do not get the data, there will be no timeout prompt, and the timeout prompt will be generated when the data cannot be obtained after 60s.
在本实施例中,通过对调优参数进行调优,使得搭建好的Pentaho系统在运行时,用户体验更友好。并且本实施例中,待调优参数值的设定依据历史记录进行设定,更加符合用户的实际需求。In this embodiment, by tuning the tuning parameters, the user experience is more friendly when the built Pentaho system is running. In this embodiment, the setting of the parameter value to be tuned is set according to the historical record, which is more in line with the actual needs of the user.
进一步地,在本申请其他实施例中,本申请所述的方法还可包括:Further, in other embodiments of the present application, the method described in the present application may further include:
接收部署指令,根据所述部署指令部署与安装后的Pentaho相关的功能代码。Receiving a deployment instruction, and deploying a functional code related to the installed Pentaho according to the deployment instruction.
具体的,与安装后的Pentaho相关的功能代码可以是辅助Pentaho运行或 者是辅助用户操作的程序。Specifically, the function code associated with the installed Pentaho may be a program that assists the Pentaho operation or assists the user operation.
例如,部署报表执行计划程序。具体的,报表执行计划可由数据驱动发起执行计划,由其他BI工具(如Kettle)控制执行序列。例如,在凌晨执行数据刷新获取报表数据,执行目的是在完成后产生缓存,在白天的业务高峰期提供更快的响应,或者是通过邮件将其发送至指定邮箱中等。For example, deploy a report execution scheduler. Specifically, the report execution plan can be initiated by a data driven execution plan, and the execution sequence is controlled by other BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
或者,部署日志监控程序。通过日志监控程序可以监控Pentaho使用过程中的输出日志,进而可以对日志进行分析或者是报警处理。例如,日志监控程序读Pentaho使用过程中产生的日志,如果获取到预设的关键字,进行报警提示。Or, deploy the log monitor. The log monitor can monitor the output log during the use of Pentaho, which can be used to analyze the log or handle the alarm. For example, the log monitor reads the logs generated during the use of Pentaho, and if an initial keyword is obtained, an alert is issued.
在本实施例中,通过部署与安装后的Pentaho相关的功能代码,丰富Pentaho的功能,为用户使用提供强大的支持。In this embodiment, by deploying the functional code related to the installed Pentaho, the functions of Pentaho are enriched, and powerful support is provided for the user.
本申请提供的报表工具搭建方法接收报表搭建指令,初始化Pentaho运行环境;获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。由于接收报表搭建指令后完成了初始化Pentaho环境到参数配置的全过程,无需用户进行大量的手动作业,从而提高了Pentaho搭建的效率。The report tool construction method provided by the application receives the report construction instruction, initializes the Pentaho runtime environment, obtains the Pentaho installation file, and installs the Pentaho into the Pentaho runtime environment according to the installation information included in the report construction instruction and the Pentaho installation file; Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
如图2所示,图2为本申请实施例提供的报表工具搭建装置的功能模块图。所述报表工具搭建装置包括环境初始化模块210、安装模块220和配置模块230。本申请所称的模块是指一种能够被计算机装置的处理器所执行并且能够完成固定功能的一系列计算机可读指令段,其存储在计算机装置的存储器中。在本实施例中,关于各模块的功能将在后续的实施例中详述。As shown in FIG. 2, FIG. 2 is a functional block diagram of a reporting tool construction device according to an embodiment of the present application. The report tool building device includes an environment initialization module 210, an installation module 220, and a configuration module 230. 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.
环境初始化模块210,用于接收报表搭建指令,初始化Pentaho运行环境。The environment initialization module 210 is configured to receive a report construction instruction and initialize the Pentaho runtime environment.
上述报表搭建指令用于进行Pentaho报表搭建。The above report building instructions are used to build Pentaho reports.
上述Pentaho运行环境是指Pentaho运行时的系统环境。例如,Pentaho运行环境可以为Linux系统,则此时,Pentaho应用于Linux系统上。The above Pentaho runtime environment refers to the system environment when Pentaho is running. For example, the Pentaho runtime environment can be a Linux system, and at this time, Pentaho is applied to a Linux system.
初始化Pentaho运行环境的哪些方面根据Pentaho运行时的操作系统而异。The aspects of initializing the Pentaho runtime environment vary depending on the operating system of the Pentaho runtime.
本实施例中,以Pentaho的运行基于Linux操作系统为例进行说明。当获取到Pentaho运行环境为Linux环境时,初始化Pentaho运行环境包括但不限于:网络初始化、安全初始化、用户数据初始化。In this embodiment, the operation of Pentaho is based on the Linux operating system as an example. When the Pentaho runtime environment is obtained as a Linux environment, the initialization of the Pentaho runtime environment includes but is not limited to: network initialization, security initialization, and user data initialization.
其中,上述网络的初始化可以包括IP配置。具体的,可以通过脚本修改Linux系统文件中网卡文件中包含的ip地址,以进行网络初始化。The initialization of the foregoing network may include an IP configuration. Specifically, the ip address included in the NIC file in the Linux system file can be modified by a script to perform network initialization.
上述安全初始化可以包括防火墙初始化。具体的,可以通过执行iptables命令对Linux系统的防火墙进行自动设置。The above security initialization may include firewall initialization. Specifically, the firewall of the Linux system can be automatically set by executing the iptables command.
上述用户数据初始化包括但不限于:新建用户组、新建用户、设置用户密码、添加用户到用户组,以及为新用户设定权限等。具体的,可以通过执 行addgroup命令创建用户组,通过useradd新建用户。The above user data initialization includes but is not limited to: creating a new user group, creating a new user, setting a user password, adding a user to a user group, and setting permissions for a new user. Specifically, you can create a user group by executing the addgroup command and create a new user by useradd.
同时,初始化Pentaho运行环境不限于以上提到的几种,也可以包括其他环境变量的初始化,具体的,初始化时进行哪些环境变量的配置因Pentaho运行基于哪个操作系统而异。At the same time, the initialization of the Pentaho runtime environment is not limited to the above mentioned ones, and may also include initialization of other environment variables. Specifically, which environment variables are configured during initialization differs depending on which operating system Pentaho runs.
安装模块220,用于获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中。The installation module 220 is configured to acquire a Pentaho installation file, and install Pentaho into the Pentaho runtime environment according to the installation information included in the report construction instruction and the Pentaho installation file.
上述Pentaho安装文件是指开源的Pentaho软件的安装文件。The above Pentaho installation file refers to the installation file of the open source Pentaho software.
在具体实现时,可以从指定的存储目录中获取。具体的存储目录可以是本地的存储目录或者是远程的存储目录。In the specific implementation, it can be obtained from the specified storage directory. The specific storage directory can be a local storage directory or a remote storage directory.
上述报表搭建指令包含的安装信息可以是包含安装目录等与安装相关的信息。上述将Pentaho安装至所述Pentaho运行环境中具体可以是,将Pentaho安装文件复制并保存于Pentaho运行环境的安装目录中。The installation information included in the above report construction instruction may be installation-related information including an installation directory. The above installation of Pentaho into the Pentaho runtime environment may specifically copy and save the Pentaho installation file in the installation directory of the Pentaho runtime environment.
可选的,在本申请其他实施例中,所述安装模块220获取Pentaho安装文件可包括:Optionally, in other embodiments of the present application, the obtaining, by the installation module 220, the Pentaho installation file may include:
(1)获取Pentaho源文件。(1) Obtain the Pentaho source file.
(2)获取所述Pentaho源文件的待修复漏洞,以及所述待修复漏洞的修复文件。(2) Obtaining a to-be-repaired vulnerability of the Pentaho source file, and a repair file of the vulnerability to be repaired.
(3)根据所述待修复漏洞的修复文件修复所述待修复漏洞,得到所述Pentaho安装文件。(3) repairing the to-be-repaired vulnerability according to the repair file of the vulnerability to be repaired, and obtaining the Pentaho installation file.
其中,上述Pentaho源文件是开源的Pentaho源代码文件。上述Pentaho源文件的待修复漏洞可以为现有的已发现漏洞。Among them, the above Pentaho source file is an open source Pentaho source code file. The vulnerability to be fixed of the above Pentaho source file may be an existing discovered vulnerability.
上述通过修复文件修复所述待修复漏洞,可以是将待修复文件替换待修复漏洞的相关文件,即将已开发的某一功能代码替换掉源代码中的该功能代码。The foregoing repairing the vulnerability to be repaired by the repair file may replace the file to be repaired with a related file of the vulnerability to be repaired, and replace a function code that has been developed with the function code in the source code.
可选的,在本申请另一实施例中,所述Pentaho源文件的待修复漏洞为优先级高于预设优先级的待修复漏洞。Optionally, in another embodiment of the present application, the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired with a priority higher than a preset priority.
其中,上述预设优先级可以根据需要设定。例如Pentaho源文件的待修复漏洞分为几个等级,选取优先级高于某一优先级的待修复漏洞。The preset priority may be set as needed. For example, the pending vulnerability of the Pentaho source file is divided into several levels, and the vulnerability to be fixed with a priority higher than a certain priority is selected.
本实施例根据待修复漏洞的优先级进行漏洞修复,可以将优先级较高的待修复漏洞进行修复,使得Pentaho源文件不存在影响运行较大的系统漏洞。并且,不对所有的待修复漏洞进行修复,仅修复部分优先级较高的漏洞,实现即不影响用户使用,又节省Pentaho报表的搭建时间的目的。In this embodiment, the vulnerability is repaired according to the priority of the vulnerability to be repaired, and the vulnerability to be repaired with a higher priority can be repaired, so that the Pentaho source file does not have a system vulnerability that affects the running. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities with higher priority are repaired, so that the implementation does not affect the user's use, and the purpose of setting up the Pentaho report is saved.
可选的,在本申请另一实施例中,所述Pentaho源文件的待修复漏洞为与指定功能相关的待修复漏洞。Optionally, in another embodiment of the present application, the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired related to the specified function.
其中,上述指定功能可以根据需要预先设定。例如,Pentaho源文件的待修复漏洞为与网络安全相关的待修复漏洞。或者,指定功能为Pentaho中使用频率大于预设频率的功能。The above designated function can be preset as needed. For example, the vulnerability to be fixed in the Pentaho source file is a vulnerability to be fixed related to network security. Or, the function specified is that the frequency used in Pentaho is greater than the preset frequency.
同时,指定功能不限于以上提到的几种,还可以是其他功能。At the same time, the designated functions are not limited to the above mentioned ones, but may be other functions.
本实施例根据待修复漏洞的功能进行漏洞修复,可以将指定功能相关的待修复漏洞进行修复,使得在使用Pentaho的指定功能时,减少异常报错,提高Pentaho运行的稳定性。并且,不对所有的待修复漏洞进行修复,仅修复部分与指定功能相关的待修复漏洞,实现即不影响用户使用,又节省Pentaho报表的搭建时间的目的。In this embodiment, the vulnerability is repaired according to the function of the vulnerability to be repaired, and the vulnerability to be repaired related to the specified function can be repaired, so that when the specified function of the Pentaho is used, the abnormal error is reduced, and the stability of the Pentaho operation is improved. Moreover, all the vulnerabilities to be repaired are not repaired, and only some of the vulnerabilities to be repaired related to the specified functions are repaired, so that the user does not affect the user's use and saves the construction time of the Pentaho report.
例如,若Pentaho有A功能,代码段为m,修改后的A功能代码段为n,则用n替换m,使得Pentaho的A功能在执行时,通过n代码段实现。For example, if Pentaho has the A function, the code segment is m, and the modified A function code segment is n, then m is replaced with n, so that the Pentaho A function is implemented by the n code segment when it is executed.
在本实施例中,由于Pentaho的源代码可能存在系统漏洞,因此,通过本实施例获取到的Pentaho文件由于修复了漏洞可以使得搭建后的Pentaho稳定性更高,也可以提高用户使用时的用户体验。In this embodiment, since the source code of Pentaho may have a system vulnerability, the Pentaho file obtained by the embodiment can improve the stability of the Pentaho after the installation, and can also improve the user when using the user. Experience.
可选的,在本申请其他实施例中,所述安装模块220获取Pentaho安装文件还可包括:Optionally, in other embodiments of the present application, the obtaining, by the installation module 220, the Pentaho installation file may further include:
(1)获取Pentaho源文件。(1) Obtain the Pentaho source file.
(2)获取所述Pentaho源文件的待修改模块,以及所述待修改模块的替换文件。(2) Obtaining a module to be modified of the Pentaho source file, and a replacement file of the module to be modified.
(3)根据所述替换文件修改所述待修改模块,得到所述Pentaho安装文件。(3) modifying the module to be modified according to the replacement file to obtain the Pentaho installation file.
其中,上述Pentaho源文件是开源的Pentaho源代码文件。上述待修改模块可以是对Pentaho进行了二次开发的功能模块。上述待修改模块的替换文件可以通过查找指定文件的文件名来进行获取。Among them, the above Pentaho source file is an open source Pentaho source code file. The above-mentioned module to be modified may be a functional module for secondary development of Pentaho. The replacement file of the above-mentioned module to be modified can be obtained by searching for the file name of the specified file.
由于在使用Pentaho过程中,某些已有的Pentaho功能模块并不一定完全符合用户需求。因此本实施例中的安装模块220,得到Pentaho安装文件,进而搭建的Pentaho系统更符合用户的使用需求,提高用户应用时的用户体验,符合用户的实际需求。Due to the use of Pentaho, some existing Pentaho function modules do not necessarily fully meet the user's needs. Therefore, the installation module 220 in this embodiment obtains the Pentaho installation file, and the Pentaho system is more suitable for the user's use requirements, and improves the user experience when the user is applied, and meets the actual needs of the user.
具体实施时,待修改模块可以包括但不限于:报表清单优化模块、我的文件夹模块、收藏夹模块、回收站模块。In a specific implementation, the module to be modified may include, but is not limited to, a report list optimization module, a My Folder module, a Favorites module, and a Recycle Bin module.
其中,报表清单优化模块,用于以友好的图形用户界面展示报表;我的文件夹模块,用于使用户按各自的数据需求修改后,保存为自己专属的报表;收藏夹功能,用于将重要报表收藏;回收站模块,用于删除我的文件夹模块中保存的报表,发送至回收站。The report list optimization module is used to display the report in a friendly graphical user interface; my folder module is used to enable the user to modify the report according to their respective data requirements, and save it as their own report; the favorites function is used to Important report collection; the Recycle Bin module, which is used to delete the report saved in the My Folders module and send it to the Recycle Bin.
同时,在本申请其他实施例中,还可以在获取Pentaho安装文件时,获取实现新增功能的代码模块,并集成至Pentaho源文件中,使得获取到的Pentaho安装文件的功能更加强大。In addition, in other embodiments of the present application, when obtaining the Pentaho installation file, the code module for implementing the new function may be obtained and integrated into the Pentaho source file, so that the obtained Pentaho installation file is more powerful.
配置模块230,用于获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。The configuration module 230 is configured to obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
上述Pentaho参数配置文件可以包括待配置的参数,以及待配置的参数的属性值。The above Pentaho parameter configuration file may include parameters to be configured, and attribute values of parameters to be configured.
在进行参数初始化时,将Pentaho参数配置文件中的待配置参数进行赋值。When parameter initialization is performed, the parameters to be configured in the Pentaho parameter configuration file are assigned.
可选的,所述配置模块230具体用于:Optionally, the configuration module 230 is specifically configured to:
所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:Performing parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file includes:
(1)获取所述Pentaho参数配置文件中的待配置参数;(1) Obtain a parameter to be configured in the Pentaho parameter configuration file;
(2)获取Pentaho安装后的安装文件夹中保存运行参数的参数文件;(2) Obtain the parameter file for saving the running parameters in the installation folder after Pentaho installation;
(3)利用所述待配置参数对所述参数文件中的运行参数赋值。(3) assigning a value to the running parameter in the parameter file by using the parameter to be configured.
上述Pentaho安装后的安装文件夹是将Pentaho安装在操作系统上之后,保存Pentaho运行时的相关信息,以及支持Pentaho运行的文件的文件夹。The installation folder of the above Pentaho installation is a folder for storing Pentaho after running Pentaho on the operating system, and for supporting files run by Pentaho.
上述安装文件夹中包括保存Pentaho运行参数的参数文件(如xml格式的文件)。The above installation folder includes a parameter file (such as a file in xml format) that stores Pentaho running parameters.
在利用待配置参数对参数文件中的运行参数赋值时,获取参数文件中与待配置参数相同的参数进行赋值。例如待配置参数包括参数a,则将待配置参数文件中参数a的值赋给参数文件中运行参数a。When the running parameter in the parameter file is assigned by using the parameter to be configured, the same parameter as the parameter to be configured in the parameter file is obtained for assignment. For example, if the parameter to be configured includes the parameter a, the value of the parameter a in the parameter file to be configured is assigned to the running parameter a in the parameter file.
具体实施时,参数可以是数据源的地址、数据源的用户访问名称、数据源的用户访问密码等参数,并且可以通过脚本对要访问的数据源的地址、数据源的用户访问名称、数据源的用户访问密码等参数进行赋值。In specific implementation, the parameter may be an address of the data source, a user access name of the data source, a user access password of the data source, and the like, and the address of the data source to be accessed, the user access name of the data source, and the data source may be scripted. User access passwords and other parameters are assigned.
以下为对参数进行赋值的示例:The following is an example of assigning a parameter:
ip=10.20.30.40Ip=10.20.30.40
port=12345Port=12345
sid=examplesidSid=examplesid
jdbc_username=exampleuserJdbc_username=exampleuser
jdbc_password=examplepwdJdbc_password=examplepwd
jdbc_url=jdbc:postgresql/…/${sid}Jdbc_url=jdbc:postgresql/.../${sid}
其中,上述Jdbc_url为要访问的数据源的地址,上述Jdbc_username数据源的用户访问名称,Jdbc_password为数据源的用户访问密码,上述ip是要访问的数据库的地址,上述port是要访问的数据库的端口号,上述sid要访问的数据库的唯一标识符。Wherein, the above Jdbc_url is the address of the data source to be accessed, the user access name of the Jdbc_username data source, Jdbc_password is the user access password of the data source, the ip is the address of the database to be accessed, and the port is the port of the database to be accessed. Number, the unique identifier of the database to which the above sid is to be accessed.
同时,在参数初始化时,还可以通过预先编写好的程序访问用于定义Pentaho运行时相关参数的xml文件,并且替换其中部分参数的值,或者是代码段。At the same time, when the parameters are initialized, the xml file for defining the parameters related to the Pentaho runtime can also be accessed through a pre-written program, and the values of some of the parameters, or code segments, are replaced.
例如,以下示例为对于pentaho.xml文件,替换掉其中的username以及password的示例,通过替换,可以在读取该username和password时,根据新的赋值来查找username以及password的实际值。For example, the following example is an example of replacing the username and password in the pentaho.xml file. By replacing, you can look up the actual value of username and password based on the new assignment when reading the username and password.
<?xml version="1.0"encoding="UTF-8"?><? Xml version="1.0"encoding="UTF-8"? >
<Context path="/pentaho"docbase="webapps/pentaho/"><Context path="/pentaho"docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate"auth="Container"type="javax.sql.DataSource"<Resource name="jdbc/Hibernate"auth="Container"type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"Factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="20000"maxIdle="5000"maxActive="20000"maxIdle="5000"
maxWait="10000000"username="${jdbc_username}" password="${jdbc_password}"maxWait="10000000"username="${jdbc_username}" password="${jdbc_password}"
driverClassName="org.postgresql.Driver"driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://${ip}:${port}/${sid}"Url="jdbc:postgresql://${ip}:${port}/${sid}"
validationQuery="select 1from dual"/>validationQuery="select 1from dual"/>
</Context></Context>
可以理解的,对Pentaho进行哪些参数初始化可以根据实际需要来进行,不限于以上举例中提到的几项。It can be understood that the parameter initialization of Pentaho can be performed according to actual needs, and is not limited to the items mentioned in the above examples.
进一步地,在本申请其他实施例中,本申请所述的装置还可包括确定模块和调优模块。Further, in other embodiments of the present application, the apparatus described in the present application may further include a determining module and a tuning module.
确定模块,用于获取Pentaho参数配置文件之后,进行参数初始化之前,若接收到参数调优指令,确定所述Pentaho参数配置文件包含的待调优参数。The determining module is configured to: after obtaining the Pentaho parameter configuration file, before receiving the parameter initialization, if the parameter tuning instruction is received, determine the to-be-tuned parameter included in the Pentaho parameter configuration file.
调优模块,用于对所述待调优参数进行优化调整。The tuning module is configured to optimize and adjust the to-be-tuned parameters.
其中,上述待调优参数是指需要进行调优设置的参数。The parameter to be tuned refers to a parameter that needs to be adjusted.
上述确定Pentaho参数配置文件包含的待调优参数可以包括:确定Pentaho参数配置文件中的预设参数为待调优参数。The determining the parameter to be tuned included in the Pentaho parameter configuration file may include: determining that the preset parameter in the Pentaho parameter configuration file is a parameter to be tuned.
上述对待调优参数进行优化调整包括:对待调优参数进行重新赋值。The above optimization of the tuning parameters includes: re-assigning the tuning parameters.
具体的,赋予待调优参数的新的值可以是在其他已应用Pentaho的环境中使用过的参数值。通过历史记录中待调优参数的参数值来进行修改,可以使待调优参数更符合用户使用时的实际需求,提高用户体验。Specifically, the new value assigned to the parameter to be tuned may be a parameter value used in other environments where Pentaho has been applied. By modifying the parameter values of the parameters to be tuned in the history record, the parameters to be tuned can be more in line with the actual needs of the user and improve the user experience.
例如,用户会话保持,即maximum number of seconds for user’s session,用户会话保持这一参数用于定义在没有获取到数据的情况下经过多长时间产生超时提示。若默认设置为30s,而获取到历史记录中用户会话保持的值为60s,则将其调整为60s。在实际使用的时候,经过30s用户没有获取到数据,并不会产生超时提示,在经过60s仍无法获取到数据时,才产生超时提示。For example, user session hold, ie maximum number of seconds for user’s session, user session hold parameter is used to define how long a timeout prompt is generated without obtaining data. If the default setting is 30s and the value of the user session held in the history is 60s, adjust it to 60s. In actual use, after 30s users do not get the data, there will be no timeout prompt, and the timeout prompt will be generated when the data cannot be obtained after 60s.
在本实施例中,通过对调优参数进行调优,使得搭建好的Pentaho系统在运行时,用户体验更友好。并且本实施例中,待调优参数值的设定依据历史记录进行设定,更加符合用户的实际需求。In this embodiment, by tuning the tuning parameters, the user experience is more friendly when the built Pentaho system is running. In this embodiment, the setting of the parameter value to be tuned is set according to the historical record, which is more in line with the actual needs of the user.
进一步地,在本申请其他实施例中,本申请所述的装置还可包括:Further, in other embodiments of the present application, the apparatus described in the present application may further include:
部署模块,用于接收部署指令,根据所述部署指令部署与安装后的Pentaho相关的功能代码。The deployment module is configured to receive a deployment instruction, and deploy a functional code related to the installed Pentaho according to the deployment instruction.
具体的,与安装后的Pentaho相关的功能代码可以是辅助Pentaho运行或者是辅助用户操作的程序。Specifically, the function code related to the installed Pentaho may be a program that assists the Pentaho operation or assists the user operation.
例如,部署报表执行计划程序。具体的,报表执行计划可由数据驱动发起执行计划,由其他BI工具(如Kettle)控制执行序列。例如,在凌晨执行数据刷新获取报表数据,执行目的是在完成后产生缓存,在白天的业务高峰期提供更快的响应,或者是通过邮件将其发送至指定邮箱中等。For example, deploy a report execution scheduler. Specifically, the report execution plan can be initiated by a data driven execution plan, and the execution sequence is controlled by other BI tools such as Kettle. For example, performing data refresh in the early morning to obtain report data is performed to generate a cache after completion, to provide a faster response during peak business hours during the day, or to send it to a designated mailbox by mail.
或者,部署日志监控程序。通过日志监控程序可以监控Pentaho使用过程中的输出日志,进而可以对日志进行分析或者是报警处理。例如,日志监控程序读Pentaho使用过程中产生的日志,如果获取到预设的关键字,进行 报警提示。Or, deploy the log monitor. The log monitor can monitor the output log during the use of Pentaho, which can be used to analyze the log or handle the alarm. For example, the log monitor reads the logs generated during the use of Pentaho, and if an initial keyword is obtained, an alert is issued.
在本实施例中,通过部署与安装后的Pentaho相关的功能代码,丰富Pentaho的功能,为用户使用提供强大的支持。In this embodiment, by deploying the functional code related to the installed Pentaho, the functions of Pentaho are enriched, and powerful support is provided for the user.
本申请提供的报表工具搭建装置通过环境初始化模块接收报表搭建指令,初始化Pentaho运行环境;安装模块获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;配置模块获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。由于接收报表搭建指令后完成了初始化Pentaho环境到参数配置的全过程,无需用户进行大量的手动作业,从而提高了Pentaho搭建的效率。The report tool setting device provided by the application receives the report construction instruction through the environment initialization module, and initializes the Pentaho runtime environment; the installation module acquires the Pentaho installation file, and installs the Pentaho according to the installation information included in the report construction instruction and the Pentaho installation file. In the Pentaho runtime environment, the configuration module obtains a Pentaho parameter configuration file, and initializes the installed Pentaho parameters according to the Pentaho parameter configuration file. Since the process of initializing the Pentaho environment to the parameter configuration is completed after receiving the report construction instruction, the user does not need to perform a large number of manual operations, thereby improving the efficiency of the Pentaho construction.
上述以软件功能模块的形式实现的集成的单元,可以存储在一个非易失性可读取存储介质中。上述软件功能模块存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)或处理器(processor)执行本申请各个实施例所述方法的部分步骤。The above-described integrated unit implemented in the form of a software function module 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.
如图3所示,图3是本申请实现报表工具搭建方法的较佳实施例的计算机装置的结构示意图。所述计算机装置包括至少一个发送装置31、至少一个存储器32、至少一个处理器33、至少一个接收装置34以及至少一个通信总线。其中,所述通信总线用于实现这些组件之间的连接通信。As shown in FIG. 3, FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of the present invention. 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.
所述计算机装置是一种能够按照事先设定或存储的指令,自动进行数值计算和/或信息处理的设备,其硬件包括但不限于微处理器、专用集成电路(Application Specific Integrated Circuit,ASIC)、可编程门阵列(Field-Programmable Gate Array,FPGA)、数字处理器(Digital Signal Processor,DSP)、嵌入式设备等。所述计算机装置还可包括网络设备和/或用户设备。其中,所述网络设备包括但不限于单个网络服务器、多个网络服务器组成的服务器组或基于云计算(Cloud Computing)的由大量主机或网络服务器构成的云,其中,云计算是分布式计算的一种,由一群松散耦合的计算机集组成的一个超级虚拟计算机。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.
所述计算机装置所处的网络包括,但不限于互联网、广域网、城域网、局域网、虚拟专用网络(Virtual Private Network,VPN)等。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.
其中,所述接收装置34和所述发送装置31可以是有线发送端口,也可以为无线设备,例如包括天线装置,用于与其他设备进行数据通信。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.
所述存储器32用于存储程序代码。所述存储器32可以是集成电路中没有实物形式的具有存储功能的电路,如RAM(Random-Access Memory,随机存取存储器)、FIFO(First In First Out,先进先出)存储器等。或者,所述存储器32也可以是具有实物形式的存储器,如内存条、TF卡(Trans-flash Card)、智能媒体卡(smart media card)、安全数字卡(secure digital card)、快闪存 储器卡(flash card)等储存设备等等。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) memory, 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.
所述处理器33可以包括一个或者多个微处理器、数字处理器。所述处理器33可调用存储器32中存储的程序代码以执行相关的功能。例如,图3中所述的各个单元是存储在所述存储器32中的程序代码,并由所述处理器33所执行,以实现一种报表工具搭建方法。所述处理器33又称中央处理器(CPU,Central Processing Unit),是一块超大规模的集成电路,是运算核心(Core)和控制核心(Control Unit)。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. 3 are program code stored in the memory 32 and executed by the processor 33 to implement a reporting tool building method. 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 (20)

  1. 一种报表工具搭建方法,其特征在于,所述方法包括:A method for constructing a report tool, characterized in that the method comprises:
    接收报表搭建指令,初始化Pentaho运行环境;Receive report build instructions to initialize the Pentaho runtime environment;
    获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;Obtaining a Pentaho installation file, and installing Pentaho into the Pentaho runtime environment according to the installation information included in the report building instruction and the Pentaho installation file;
    获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file.
  2. 如权利要求1所述的方法,其特征在于,所述获取Pentaho安装文件包括:The method of claim 1 wherein said obtaining a Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修复漏洞,以及所述待修复漏洞的修复文件;Obtaining a to-be-repaired vulnerability of the Pentaho source file, and a repair file of the vulnerability to be repaired;
    根据所述待修复漏洞的修复文件修复所述待修复漏洞,得到所述Pentaho安装文件。Repairing the to-be-repaired vulnerability according to the repair file of the vulnerability to be repaired, and obtaining the Pentaho installation file.
  3. 如权利要求1所述的方法,其特征在于,所述获取Pentaho安装文件包括:The method of claim 1 wherein said obtaining a Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修改模块,以及所述待修改模块的替换文件;Obtaining a module to be modified of the Pentaho source file, and a replacement file of the module to be modified;
    根据所述替换文件修改所述待修改模块,得到所述Pentaho安装文件。Modifying the module to be modified according to the replacement file to obtain the Pentaho installation file.
  4. 如权利要求1至3中任一项所述的方法,其特征在于,所述方法还包括:The method of any of claims 1 to 3, further comprising:
    若接收到参数调优指令,确定所述Pentaho参数配置文件包含的待调优参数;If the parameter tuning instruction is received, determining the to-be-tuned parameter included in the Pentaho parameter configuration file;
    对所述待调优参数进行优化调整。Optimizing and adjusting the to-be-tuned parameters.
  5. 如权利要求1至3中任一项所述的方法,其特征在于,所述方法还包括:The method of any of claims 1 to 3, further comprising:
    接收部署指令,根据所述部署指令部署与安装后的Pentaho相关的功能代码。Receiving a deployment instruction, and deploying a functional code related to the installed Pentaho according to the deployment instruction.
  6. 如权利要求2所述的方法,其特征在于,所述Pentaho源文件的待修复漏洞为优先级高于预设优先级的待修复漏洞,或者所述Pentaho源文件的待修复漏洞为与指定功能相关的待修复漏洞。The method according to claim 2, wherein the to-be-repaired vulnerability of the Pentaho source file is a vulnerability to be repaired with a priority higher than a preset priority, or the to-be-repaired vulnerability of the Pentaho source file is a specified function Related vulnerabilities to be fixed.
  7. 如权利要求1至3中任一项所述的方法,其特征在于,所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:The method according to any one of claims 1 to 3, wherein the parameter initialization of the installed Pentaho according to the Pentaho parameter configuration file comprises:
    获取所述Pentaho参数配置文件中的待配置参数;Obtaining a parameter to be configured in the Pentaho parameter configuration file;
    获取Pentaho安装后的安装文件夹中用于运行参数的参数文件;Obtain the parameter file for running parameters in the installation folder of Pentaho installation;
    利用所述待配置参数对所述参数文件中的运行参数赋值。Assigning values to the operating parameters in the parameter file using the parameters to be configured.
  8. 一种报表工具搭建装置,其特征在于,所述装置包括:A report tool building device, characterized in that the device comprises:
    环境初始化模块,用于接收报表搭建指令,初始化Pentaho运行环境;An environment initialization module is configured to receive a report construction instruction and initialize a Pentaho runtime environment;
    安装模块,用于获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;The installation module is configured to obtain a Pentaho installation file, and install Pentaho into the Pentaho running environment according to the installation information included in the report building instruction and the Pentaho installation file;
    配置模块,用于获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。The configuration module is configured to obtain a Pentaho parameter configuration file, and perform parameter initialization on the installed Pentaho according to the Pentaho parameter configuration file.
  9. 一种计算机装置,其特征在于,所述计算机装置包括存储器及处理器,所述存储器用于存储至少一个指令,所述处理器用于执行所述至少一个指令以实现以下步骤: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:
    接收报表搭建指令,初始化Pentaho运行环境;Receive report build instructions to initialize the Pentaho runtime environment;
    获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;Obtaining a Pentaho installation file, and installing Pentaho into the Pentaho runtime environment according to the installation information included in the report building instruction and the Pentaho installation file;
    获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file.
  10. 如权利要求9所述的计算机装置,其特征在于,所述获取Pentaho安装文件包括:The computer apparatus according to claim 9, wherein said obtaining a Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修复漏洞,以及所述待修复漏洞的修复文件;Obtaining a to-be-repaired vulnerability of the Pentaho source file, and a repair file of the vulnerability to be repaired;
    根据所述待修复漏洞的修复文件修复所述待修复漏洞,得到所述Pentaho安装文件。Repairing the to-be-repaired vulnerability according to the repair file of the vulnerability to be repaired, and obtaining the Pentaho installation file.
  11. 如权利要求9所述的计算机装置,其特征在于,所述获取Pentaho安装文件包括:The computer apparatus according to claim 9, wherein said obtaining a Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修改模块,以及所述待修改模块的替换文件;Obtaining a module to be modified of the Pentaho source file, and a replacement file of the module to be modified;
    根据所述替换文件修改所述待修改模块,得到所述Pentaho安装文件。Modifying the module to be modified according to the replacement file to obtain the Pentaho installation file.
  12. 如权利要求9至11中任一项所述的计算机装置,其特征在于,所述处理器还用于执行所述至少一个指令以实现以下步骤:The computer apparatus according to any one of claims 9 to 11, wherein the processor is further configured to execute the at least one instruction to implement the following steps:
    若接收到参数调优指令,确定所述Pentaho参数配置文件包含的待调优参数;If the parameter tuning instruction is received, determining the to-be-tuned parameter included in the Pentaho parameter configuration file;
    对所述待调优参数进行优化调整。Optimizing and adjusting the to-be-tuned parameters.
  13. 如权利要求9至11中任一项所述的计算机装置,其特征在于,所述处理器还用于执行所述至少一个指令以实现以下步骤:The computer apparatus according to any one of claims 9 to 11, wherein the processor is further configured to execute the at least one instruction to implement the following steps:
    接收部署指令,根据所述部署指令部署与安装后的Pentaho相关的功能代码。Receiving a deployment instruction, and deploying a functional code related to the installed Pentaho according to the deployment instruction.
  14. 如权利要求9至11中任一项所述的计算机装置,其特征在于,所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:The computer apparatus according to any one of claims 9 to 11, wherein the parameter initialization of the installed Pentaho according to the Pentaho parameter configuration file comprises:
    获取所述Pentaho参数配置文件中的待配置参数;Obtaining a parameter to be configured in the Pentaho parameter configuration file;
    获取Pentaho安装后的安装文件夹中用于运行参数的参数文件;Obtain the parameter file for running parameters in the installation folder of Pentaho installation;
    利用所述待配置参数对所述参数文件中的运行参数赋值。Assigning values to the operating parameters in the parameter file using the parameters to be configured.
  15. 一种非易失性可读存储介质,其上存储有计算机指令,其特征在于,所述计算机指令被处理器执行时实现以下步骤: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:
    接收报表搭建指令,初始化Pentaho运行环境;Receive report build instructions to initialize the Pentaho runtime environment;
    获取Pentaho安装文件,根据所述报表搭建指令包含的安装信息和所述Pentaho安装文件将Pentaho安装至所述Pentaho运行环境中;Obtaining a Pentaho installation file, and installing Pentaho into the Pentaho runtime environment according to the installation information included in the report building instruction and the Pentaho installation file;
    获取Pentaho参数配置文件,根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化。Obtain the Pentaho parameter configuration file, and initialize the parameters of the installed Pentaho according to the Pentaho parameter configuration file.
  16. 如权利要求15所述的存储介质,其特征在于,所述获取Pentaho安装文件包括:The storage medium of claim 15, wherein the obtaining the Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修复漏洞,以及所述待修复漏洞的修复文件;Obtaining a to-be-repaired vulnerability of the Pentaho source file, and a repair file of the vulnerability to be repaired;
    根据所述待修复漏洞的修复文件修复所述待修复漏洞,得到所述Pentaho安装文件。Repairing the to-be-repaired vulnerability according to the repair file of the vulnerability to be repaired, and obtaining the Pentaho installation file.
  17. 如权利要求15所述的存储介质,其特征在于,所述获取Pentaho安装文件包括:The storage medium of claim 15, wherein the obtaining the Pentaho installation file comprises:
    获取Pentaho源文件;Obtain the Pentaho source file;
    获取所述Pentaho源文件的待修改模块,以及所述待修改模块的替换文件;Obtaining a module to be modified of the Pentaho source file, and a replacement file of the module to be modified;
    根据所述替换文件修改所述待修改模块,得到所述Pentaho安装文件。Modifying the module to be modified according to the replacement file to obtain the Pentaho installation file.
  18. 如权利要求15至17中任一项所述的存储介质,其特征在于,所述计算机指令被处理器执行时实现以下步骤:The storage medium according to any one of claims 15 to 17, wherein the computer instructions are executed by the processor to implement the following steps:
    若接收到参数调优指令,确定所述Pentaho参数配置文件包含的待调优参数;If the parameter tuning instruction is received, determining the to-be-tuned parameter included in the Pentaho parameter configuration file;
    对所述待调优参数进行优化调整。Optimizing and adjusting the to-be-tuned parameters.
  19. 如权利要求15至17中任一项所述的存储介质,其特征在于,所述计算机指令被处理器执行时实现以下步骤:The storage medium according to any one of claims 15 to 17, wherein the computer instructions are executed by the processor to implement the following steps:
    接收部署指令,根据所述部署指令部署与安装后的Pentaho相关的功能代码。Receiving a deployment instruction, and deploying a functional code related to the installed Pentaho according to the deployment instruction.
  20. 如权利要求15至17中任一项所述的存储介质,其特征在于,所述根据所述Pentaho参数配置文件对安装后的Pentaho进行参数初始化包括:The storage medium according to any one of claims 15 to 17, wherein the parameterizing the installed Pentaho according to the Pentaho parameter configuration file comprises:
    获取所述Pentaho参数配置文件中的待配置参数;Obtaining a parameter to be configured in the Pentaho parameter configuration file;
    获取Pentaho安装后的安装文件夹中用于运行参数的参数文件;Obtain the parameter file for running parameters in the installation folder of Pentaho installation;
    利用所述待配置参数对所述参数文件中的运行参数赋值。Assigning values to the operating parameters in the parameter file using the parameters to be configured.
PCT/CN2018/099772 2018-04-23 2018-08-10 Report tool construction method and device, computer device, and storage medium WO2019205344A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810367323.2 2018-04-23
CN201810367323.2A CN108595190B (en) 2018-04-23 2018-04-23 Report tool building method and device, computer device and storage medium

Publications (1)

Publication Number Publication Date
WO2019205344A1 true WO2019205344A1 (en) 2019-10-31

Family

ID=63614738

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/099772 WO2019205344A1 (en) 2018-04-23 2018-08-10 Report tool construction method and device, computer device, and storage medium

Country Status (2)

Country Link
CN (1) CN108595190B (en)
WO (1) WO2019205344A1 (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111178028A (en) * 2019-12-11 2020-05-19 深圳金赋科技有限公司 Method and equipment for cleaning financial data and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101958920A (en) * 2010-05-06 2011-01-26 浪潮电子信息产业股份有限公司 Method for establishing and applying Opensolairs IPS (Intrusion Prevention System)
CN102118500A (en) * 2010-12-27 2011-07-06 清华大学 Software package-based online automatic updating method for open source operating system of mobile terminal
CN106610853A (en) * 2015-10-26 2017-05-03 阿里巴巴集团控股有限公司 Application deployment method and device
CN106708573A (en) * 2016-12-19 2017-05-24 中国银联股份有限公司 System and method used for automatic installation of Hadoop cluster

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9747095B1 (en) * 2015-04-21 2017-08-29 Jpmorgan Chase Bank, N.A. System and method for automated content and software migration
CN107491463B (en) * 2016-07-21 2020-02-18 平安科技(深圳)有限公司 Optimization method and system for data query
CN106407170A (en) * 2016-09-30 2017-02-15 上海冰穹网络科技有限公司 Rapid generation method and system for data report
CN106708925A (en) * 2016-11-11 2017-05-24 山东浪潮云服务信息科技有限公司 Form business realization method and system, and business terminal
CN107193967A (en) * 2017-05-25 2017-09-22 南开大学 A kind of multi-source heterogeneous industry field big data handles full link solution

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101958920A (en) * 2010-05-06 2011-01-26 浪潮电子信息产业股份有限公司 Method for establishing and applying Opensolairs IPS (Intrusion Prevention System)
CN102118500A (en) * 2010-12-27 2011-07-06 清华大学 Software package-based online automatic updating method for open source operating system of mobile terminal
CN106610853A (en) * 2015-10-26 2017-05-03 阿里巴巴集团控股有限公司 Application deployment method and device
CN106708573A (en) * 2016-12-19 2017-05-24 中国银联股份有限公司 System and method used for automatic installation of Hadoop cluster

Also Published As

Publication number Publication date
CN108595190B (en) 2020-06-19
CN108595190A (en) 2018-09-28

Similar Documents

Publication Publication Date Title
US20220413979A1 (en) Control service for data management
US10798101B2 (en) Managing security groups for data instances
US20230089995A1 (en) Methods and apparatus to manage monitoring agents
US8938523B2 (en) System and method for deploying and maintaining software applications
US8713061B1 (en) Self-service administration of a database
CA2776384C (en) Self-service configuration for data environment
US11818161B2 (en) Network security through linking vulnerability management and change management
US20150271014A1 (en) Automatic configuration of new components by infrastructure management software
JP6994477B2 (en) Automated problem detection and resolution framework for enterprise resource planning
US10579283B1 (en) Elastic virtual backup proxy
EP4244689A1 (en) Automated product update management in managed networks
US20230131898A1 (en) Techniques for building and validating database software in a shared management environment
WO2019205344A1 (en) Report tool construction method and device, computer device, and storage medium
US11966880B2 (en) Policies and controls for building and validating database software in a shared management environment
US20180159737A1 (en) Method for Remote Management of Multiple Device Configurations
US20230125904A1 (en) Recommendation system for building and validating database software in a shared management environment
US20230067086A1 (en) Transformation of cloud-based data science pods
US10983899B2 (en) Automatic configuration and deployment of environments of a system
US11829749B2 (en) Incremental update for offline data access
WO2023069500A1 (en) Techniques for building and validating database software in a shared management environment
WO2022178174A1 (en) Automated product update management in managed networks

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18916103

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 03.02.2021)

122 Ep: pct application non-entry in european phase

Ref document number: 18916103

Country of ref document: EP

Kind code of ref document: A1