WO2019237533A1 - Method for calling influxdb database by service system, and storage medium, terminal device and apparatus - Google Patents

Method for calling influxdb database by service system, and storage medium, terminal device and apparatus Download PDF

Info

Publication number
WO2019237533A1
WO2019237533A1 PCT/CN2018/104974 CN2018104974W WO2019237533A1 WO 2019237533 A1 WO2019237533 A1 WO 2019237533A1 CN 2018104974 W CN2018104974 W CN 2018104974W WO 2019237533 A1 WO2019237533 A1 WO 2019237533A1
Authority
WO
WIPO (PCT)
Prior art keywords
data table
field information
data
memory consumption
original data
Prior art date
Application number
PCT/CN2018/104974
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 WO2019237533A1 publication Critical patent/WO2019237533A1/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/40—Data acquisition and logging
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Definitions

  • the present application relates to the field of database technology, and in particular, to a method, a storage medium, a terminal device, and a device for a business system to call an influxdb database.
  • Influxdb is an open source time series database, which is suitable for real-time processing of huge data information. It belongs to a memory / CPU high-consumption database solution.
  • business systems such as banking and credit are running, they usually need to call various business data from the server's influxdb database.
  • the business system calls the influxdb time series database interface, each piece of data needs to be calculated in the influxdb background, especially when the business system needs to display the called data through a visual interface, it will involve a large amount between the business system and the influxdb database.
  • the data transmission results in the database background being busy and continuously processing data, which will cause great resource consumption to the server and seriously affect the stable operation of the business system.
  • the present application provides a method, storage medium, terminal device, and device for a business system to call an influxdb database, which can reduce the resource consumption of a server in the process of calling data from a business system, thereby improving the stability of the business system operation.
  • a first aspect of the embodiments of the present application provides a method for a business system to call an influxdb database, including:
  • the first field information is field information corresponding to target data that the business system needs to call
  • a computer-readable storage medium stores computer-readable instructions.
  • the computer-readable instructions are executed by a processor, the computer-readable instructions are implemented as in the embodiments of the application.
  • the first aspect presents the steps of the business system calling the influxdb database method.
  • a third aspect of the embodiments of the present application provides a terminal device, including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, where the processor executes the computer When the instructions are readable, the steps of implementing the method of the influxdb database by the business system as proposed in the first aspect of the embodiments of the present application are implemented.
  • a fourth aspect of the embodiments of the present application provides a device for a business system to call an influxdb database, including:
  • a request acquisition module for acquiring a data call request of a business system
  • a field information determining module configured to determine first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
  • a raw data table obtaining module configured to obtain a raw data table associated with the first field information from an influxdb database
  • An aggregation processing module configured to perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
  • a data transmission module is configured to transmit the target data table to the service system.
  • the business system no longer directly fetches data from the interface of the influxdb database, that is, the data transmission between the business system and the influxdb database does not need to be performed directly on a visual interface. Because the data in the influxdb database is aggregated by using this processing logic, the resource consumption of the server is much smaller than the resource consumption of the server directly called by the influxdb database by the business system, so this application can effectively reduce the resource consumption of the database background server and improve the business system operation. The stability.
  • FIG. 1 is a flowchart of a first embodiment of a method for a business system to call an influxdb database provided by the present application
  • FIG. 2 is a flowchart of a second embodiment of a method for calling a influxdb database by a business system provided in the present application;
  • FIG. 3 is a structural diagram of an embodiment of a device for calling a influxdb database by a service system provided in the present application.
  • the embodiments of the present application provide a method, a storage medium, a terminal device, and a device for a business system to call an influxdb database, which can reduce the resource consumption of the server during the process of the business system calling data, thereby improving the stability of the business system operation.
  • a first embodiment of a method for a business system to call an influxdb database in an embodiment of the present application includes:
  • the business system When the business system needs to call the data of the influxdb database, it sends a corresponding data call request to the server where the influxdb database is located, and the server can obtain the data call request.
  • the server After acquiring the data call request, the server determines first field information according to the data call request, where the first field information is field information corresponding to the target data that the business system needs to call. For example, if the business system needs to call the 2017 business volume data, it can be determined that the first field information is “2017 business volume”.
  • the server After determining the first field information, the server obtains the original data table associated with the first field information from the influxdb database. After the original data table is aggregated and processed according to certain rules, the data that the business system needs to call can be obtained.
  • step 103 may include:
  • a field information association table is constructed according to the business rules in advance, and the association table records the association relationship between the fields.
  • the second field information associated with the first field information “2017 business volume” is “January 2017 business volume, January 2017 business volume ... December 2017 business volume”. Then, obtain the original data table whose field contains the second field information from the influxdb database, such as the "January 2017 business volume”, “February 2017 business volume”, "March 2017 business volume” ... data sheet.
  • the server After obtaining the original data table, the server performs aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data. That is, the business system can directly obtain the data to be called from the target data table.
  • step 104 may include:
  • the first field information "2017 business volume” is used as an example. First, it is extracted from the original data table "January 2017 business volume”, “February 2017 business volume”, “March 2017 business volume” ... Corresponding business volume data, and then the business volume data is aggregated according to certain aggregation processing rules (here, the business volume is added) to obtain the target data, that is, the 2017 business volume data. Finally, the obtained target data and the first field information are constructed into a table, that is, a target data table.
  • the original data table may also be aggregated at a preset time interval.
  • the minute / hour granularity can be achieved according to business requirements to generate a target data table. For example, you can aggregate data every minute.
  • the time interval can be adjusted through the following steps:
  • the memory consumption of the server can be monitored in real time. If the average value of the consumption in a unit time exceeds a preset upper limit value (that is, the first threshold value), the preset ratio will be gradually increased. Increasing the time interval until the average value of the memory consumption in a unit time is less than the first threshold. For example, the initial set time interval is 60s for one data aggregation process. If the average memory consumption of the system exceeds 95% of the limit within 1 hour, you can increase the time interval to a certain degree, such as 70s, making 1 The average memory consumption of the system during the hour is less than 95%.
  • the server actually constructs a piece of processing logic.
  • the processing logic is used to call the original data table of the influxdb database, and the original data table is aggregated to obtain The target data table required by the business system.
  • the server After the target data table is obtained, the server transmits the target data table to the business system, and the business system can call the target data.
  • a server based on an 8-core CPU and 32G memory In the mode where the original business system directly calls the influxdb interface, it can only support the data collection of more than 10 business terminals, processing about ten million levels, the memory consumption is greater than 32G, and the server will overflow memory. If this method is used, access to the data collection of more than 70 business terminals, the amount of business data will reach 100 million, and the memory consumption of the server will be about 20G, which is only 2/3 of the original.
  • the business system no longer directly retrieves data from the interface of the influxdb database, that is, the data transmission between the business system and the influxdb database does not need to be performed directly on a visual interface. Because the data in the influxdb database is aggregated by using this processing logic, the resource consumption of the server is much smaller than the resource consumption of the server directly called by the influxdb database by the business system, so this application can effectively reduce the resource consumption of the database background server and improve the business system operation. The stability.
  • a second embodiment of a method for a business system to call an influxdb database in an embodiment of the present application includes:
  • Steps 201-203 are the same as steps 101-103. For details, refer to the description of steps 101-103.
  • the memory consumption of the server where the influxdb database is located is monitored in real time.
  • step 205 may include:
  • the data in the influxdb database has the corresponding data aging.
  • the data aging is a parameter set by the influxdb database for the stored data, and is used to limit the period during which the data is valid.
  • the server's memory consumption is related to the data age of the original data table: the shorter the data age, the smaller the memory consumption. Therefore, when it is detected that the memory consumption of the server exceeds a certain threshold, the memory consumption can be reduced by shortening the data aging of the original data table, so that the memory consumption is smaller than the second threshold.
  • the data age of the original data table may be extended reasonably to meet the business requirements of high data age.
  • step (1) it may specifically include:
  • y represents the amount of memory consumption (in MB)
  • x represents the amount of data in the original data table (in tens of thousands). For example, when it is detected that the memory consumption of the server exceeds 10G (assuming 12G), the current data aging of the original data table is obtained, assuming 3 days.
  • the memory consumption of the server where the influxdb database is located can be further reduced during the process of calling data by the business system.
  • the original data table is cleared in the memory of the server to reduce the memory consumption.
  • Steps 207-208 are the same as steps 104-105. For details, refer to the related descriptions of steps 104-105.
  • the real-time monitoring of the memory consumption of the server where the influxdb database is located, and adjusting the data aging of the original data table according to the monitored memory consumption can be called in the business system
  • the process of data further reduces the memory consumption of the server where the influxdb database is located.
  • the above mainly describes a method for a business system to call an influxdb database, and a device for a business system to call an influxdb database will be described in detail below.
  • an embodiment of a device for a business system to call an influxdb database in an embodiment of the present application includes:
  • a request acquisition module 301 configured to acquire a data call request of a business system
  • a field information determining module 302 configured to determine first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
  • a raw data table obtaining module 303 configured to obtain a raw data table associated with the first field information from an influxdb database
  • An aggregation processing module 304 configured to perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
  • a data transmission module 305 is configured to transmit the target data table to the service system.
  • the raw data table obtaining module may include:
  • a field information query unit configured to query a second field information associated with the first field information in a preset field information association table
  • a raw data table obtaining unit configured to obtain a raw data table whose field contains the second field information from an influxdb database
  • the aggregation processing module may include:
  • a data extraction unit configured to extract data corresponding to the second field information from the original data table
  • An aggregation processing unit configured to perform aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data
  • a target data table constructing unit configured to construct the target data table according to the first field information and the target data.
  • the aggregation processing module is specifically configured to perform aggregation processing on the original data table according to a preset time interval
  • the time interval is adjusted by the following steps:
  • the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
  • the device for the business system to call the influxdb database may further include:
  • Memory consumption monitoring module used to monitor the memory consumption of the server where the influxdb database is located in real time
  • a data age adjustment module configured to adjust the data age of the original data table according to the memory consumption amount
  • the memory data clearing module is configured to clear the original data table from the memory of the server if the data of the original data table exceeds the data age.
  • the data aging adjustment module may include:
  • a first aging adjustment unit configured to shorten the data aging of the original data table when it is detected that the memory consumption is greater than a second threshold, so that the memory consumption is less than the second threshold;
  • a second aging adjustment unit configured to extend the data aging of the original data table when the memory consumption is less than a third threshold, so that the memory consumption is greater than the third threshold, and the third threshold Less than the second threshold.
  • the first aging adjustment unit may include:
  • a data aging obtaining subunit configured to obtain the current data aging of the original data table
  • the linear relationship expression query subunit is configured to query a preset relationship record table for a first linear relationship expression corresponding to the current data aging, and the relationship record table records a linear relationship corresponding to each data aging.
  • An expression, the linear relationship expression is used to represent a relationship between a memory consumption amount and a data amount of the original data table;
  • a linear relationship expression is substituted into the subunit, and is configured to substitute the detected memory consumption amount into the first linear relationship expression to calculate a corresponding target data amount;
  • a memory consumption calculation subunit configured to substitute the target data amount into each linear relationship expression in the relationship record table, and calculate and obtain a memory consumption amount corresponding to each linear relationship expression
  • a linear expression selection subunit configured to select, from the respective linear relationship expressions, a second linear relationship expression whose corresponding memory consumption is less than the second threshold;
  • the data aging adjustment subunit is configured to adjust the data aging of the original data table to a data aging corresponding to the second linear relationship expression.
  • An embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, any one shown in FIG. The steps of a method for a business system to call the influxdb database.
  • An embodiment of the present application further provides a terminal device including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor.
  • a terminal device including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor.
  • the processor executes the computer-readable instructions, The steps of implementing a method for influxdb database of any business system shown in FIG. 1 or FIG. 2 are implemented.

Landscapes

  • Engineering & Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Provided are a method for calling an influxdb database by a service system, and a storage medium, a terminal device and an apparatus. By means of constructing a section of processing logic at a server end of an influxdb database, an original data table of the influxdb database is called by using the processing logic when a data calling request of a service system is acquired, and aggregation processing is carried out on the original data table to obtain a target data table required by the service system. Finally, the service system can directly call data in the target data table. With this arrangement, the service system no longer calls and acquires data directly from an interface of the influxdb database, namely, data transmission on a visual interface does not need to be directly carried out between the service system and the influxdb database. By means of the method, the resource consumption of a database background server can be effectively reduced, and the operation stability of a service system is improved.

Description

业务系统调用influxdb数据库的方法、存储介质、终端设备及装置Method, storage medium, terminal equipment and device for business system to call influxdb database
本申请要求于2018年6月12日提交中国专利局、申请号为201810603099.2、申请名称为“一种业务系统调用influxdb数据库的方法、存储介质和服务器”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。This application claims the priority of a Chinese patent application filed on June 12, 2018 with the Chinese Patent Office, application number 201810603099.2, and application name "A method, storage medium, and server for calling an influxdb database by a business system", its entire contents Incorporated by reference in this application.
技术领域Technical field
本申请涉及数据库技术领域，尤其涉及一种业务系统调用influxdb数据库的方法、存储介质、终端设备及装置。The present application relates to the field of database technology, and in particular, to a method, a storage medium, a terminal device, and a device for a business system to call an influxdb database.
背景技术Background technique
Influxdb是一种开源的时序数据库，适用于庞大数据信息实时处理的应用场合，属于内存/CPU高消耗型的数据库解决方案。目前，银行、信贷等业务系统运行时，通常需要从服务器的influxdb数据库中调用各类业务数据。然而，由于业务系统在调用influxdb时序数据库接口时，每一笔数据都需要在influxdb后台进行计算，尤其当业务系统需要通过可视化界面展示调用的数据时，会涉及到业务系统与influxdb数据库之间大量的数据传输，导致数据库后台繁忙不断地进行数据处理，这会给服务器造成极大的资源消耗，严重影响业务系统的稳定运行。Influxdb is an open source time series database, which is suitable for real-time processing of huge data information. It belongs to a memory / CPU high-consumption database solution. At present, when business systems such as banking and credit are running, they usually need to call various business data from the server's influxdb database. However, when the business system calls the influxdb time series database interface, each piece of data needs to be calculated in the influxdb background, especially when the business system needs to display the called data through a visual interface, it will involve a large amount between the business system and the influxdb database. The data transmission results in the database background being busy and continuously processing data, which will cause great resource consumption to the server and seriously affect the stable operation of the business system.
技术问题technical problem
本申请提供了一种业务系统调用influxdb数据库的方法、存储介质、终端设备及装置，能够在业务系统调用数据的过程中降低服务器的资源消耗，从而提高业务系统运行的稳定性。The present application provides a method, storage medium, terminal device, and device for a business system to call an influxdb database, which can reduce the resource consumption of a server in the process of calling data from a business system, thereby improving the stability of the business system operation.
技术解决方案Technical solutions
本申请实施例的第一方面，提供了一种业务系统调用influxdb数据库的方法，包括：A first aspect of the embodiments of the present application provides a method for a business system to call an influxdb database, including:
获取业务系统的数据调用请求；Get the data call request of the business system;
根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；Determining first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
从influxdb数据库中获取与所述第一字段信息关联的原始数据表；Obtaining a raw data table associated with the first field information from an influxdb database;
对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；Perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
将所述目标数据表传送给所述业务系统。Transmitting the target data table to the business system.
本申请实施例的第二方面，提供了一种计算机可读存储介质，所述计算机可读存储介质存储有计算机可读指令，所述计算机可读指令被处理器执行时实现如本申请实施例的第一方面提出的业务系统调用influxdb数据库的方法的步骤。According to a second aspect of the embodiments of the present application, a computer-readable storage medium is provided. The computer-readable storage medium stores computer-readable instructions. When the computer-readable instructions are executed by a processor, the computer-readable instructions are implemented as in the embodiments of the application The first aspect presents the steps of the business system calling the influxdb database method.
本申请实施例的第三方面提供了一种终端设备，包括存储器、处理器以及存储在所述存储器中并可在所述处理器上运行的计算机可读指令，所述处理器执行所述计算机可读指令时实现如本申请实施例的第一方面提出的业务系统调用influxdb数据库的方法的步骤。A third aspect of the embodiments of the present application provides a terminal device, including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, where the processor executes the computer When the instructions are readable, the steps of implementing the method of the influxdb database by the business system as proposed in the first aspect of the embodiments of the present application are implemented.
本申请实施例的第四方面提供了一种业务系统调用influxdb数据库的装置，包括：A fourth aspect of the embodiments of the present application provides a device for a business system to call an influxdb database, including:
请求获取模块，用于获取业务系统的数据调用请求；A request acquisition module for acquiring a data call request of a business system;
字段信息确定模块，用于根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；A field information determining module, configured to determine first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
原始数据表获取模块，用于从influxdb数据库中获取与所述第一字段信息关联的原始数据表；A raw data table obtaining module, configured to obtain a raw data table associated with the first field information from an influxdb database;
聚合处理模块，用于对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；An aggregation processing module, configured to perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
数据传送模块，用于将所述目标数据表传送给所述业务系统。A data transmission module is configured to transmit the target data table to the service system.
有益效果Beneficial effect
在本申请中，业务系统不再直接从influxdb数据库的接口调取数据，也即业务系统和influxdb数据库之间无需直接进行可视化界面的数据传输。由于利用该处理逻辑调用influxdb数据库的数据进行聚合对服务器的资源消耗远远小于由业务系统直接调用influxdb数据库对服务器的资源消耗，故本申请能够有效降低数据库后台服务器的资源消耗，提高业务系统运行的稳定性。In this application, the business system no longer directly fetches data from the interface of the influxdb database, that is, the data transmission between the business system and the influxdb database does not need to be performed directly on a visual interface. Because the data in the influxdb database is aggregated by using this processing logic, the resource consumption of the server is much smaller than the resource consumption of the server directly called by the influxdb database by the business system, so this application can effectively reduce the resource consumption of the database background server and improve the business system operation. The stability.
附图说明BRIEF DESCRIPTION OF THE DRAWINGS
图1是本申请提供的一种业务系统调用influxdb数据库的方法的第一个实施例的流程图；FIG. 1 is a flowchart of a first embodiment of a method for a business system to call an influxdb database provided by the present application; FIG.
图2是本申请提供的一种业务系统调用influxdb数据库的方法的第二个实施例的流程图；2 is a flowchart of a second embodiment of a method for calling a influxdb database by a business system provided in the present application;
图3是本申请提供的一种业务系统调用influxdb数据库的装置的一个实施例的结构图。FIG. 3 is a structural diagram of an embodiment of a device for calling a influxdb database by a service system provided in the present application.
本发明的实施方式Embodiments of the invention
本申请实施例提供了一种业务系统调用influxdb数据库的方法、存储介质、终端设备及装置，能够在业务系统调用数据的过程中降低服务器的资源消耗，从而提高业务系统运行的稳定性。The embodiments of the present application provide a method, a storage medium, a terminal device, and a device for a business system to call an influxdb database, which can reduce the resource consumption of the server during the process of the business system calling data, thereby improving the stability of the business system operation.
请参阅图1，本申请实施例中一种业务系统调用influxdb数据库的方法的第一个实施例包括：Referring to FIG. 1, a first embodiment of a method for a business system to call an influxdb database in an embodiment of the present application includes:
101、获取业务系统的数据调用请求；101. Obtain a data call request of a business system;
当业务系统需要调用influxdb数据库的数据时，会发送相应的数据调用请求至influxdb数据库所在的服务器，该服务器即可获取到该数据调用请求。When the business system needs to call the data of the influxdb database, it sends a corresponding data call request to the server where the influxdb database is located, and the server can obtain the data call request.
102、根据所述数据调用请求确定第一字段信息；102. Determine first field information according to the data call request.
服务器在获取到该数据调用请求之后，根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息。比如，若业务系统需要调用2017年的业务量数据，则可确定第一字段信息为“2017年业务量”。After acquiring the data call request, the server determines first field information according to the data call request, where the first field information is field information corresponding to the target data that the business system needs to call. For example, if the business system needs to call the 2017 business volume data, it can be determined that the first field information is “2017 business volume”.
103、从influxdb数据库中获取与所述第一字段信息关联的原始数据表；103. Obtain a raw data table associated with the first field information from an influxdb database.
在确定第一字段信息之后，服务器从influxdb数据库中获取与所述第一字段信息关联的原始数据表。将该原始数据表按照一定的规则聚合处理后，即可得到业务系统需要调用的数据。After determining the first field information, the server obtains the original data table associated with the first field information from the influxdb database. After the original data table is aggregated and processed according to certain rules, the data that the business system needs to call can be obtained.
进一步的，步骤103可以包括：Further, step 103 may include:
（1）在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；(1) Query the second field information associated with the first field information in a preset field information association table;
（2）从influxdb数据库中获取字段包含所述第二字段信息的原始数据表。(2) Obtaining a raw data table from the influxdb database whose field contains the information of the second field.
在服务器端，预先根据业务规则构建字段信息关联表，该关联表记录了各个字段之间的关联关系。比如，与第一字段信息“2017年业务量”关联的第二字段信息为“2017年1月业务量、2017年1月业务量…2017年12月业务量”。然后，从influxdb数据库中获取字段包含所述第二字段信息的原始数据表，比如获取“2017年1月业务量”、“2017年2月业务量”、“2017年3月业务量”…的数据表。On the server side, a field information association table is constructed according to the business rules in advance, and the association table records the association relationship between the fields. For example, the second field information associated with the first field information “2017 business volume” is “January 2017 business volume, January 2017 business volume ... December 2017 business volume”. Then, obtain the original data table whose field contains the second field information from the influxdb database, such as the "January 2017 business volume", "February 2017 business volume", "March 2017 business volume" ... data sheet.
104、对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表；104. Aggregate the original data table output by the influxdb database to obtain a target data table.
在获取到原始数据表之后，服务器对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据。也即，业务系统能够直接从所述目标数据表中获取想要调用的数据。After obtaining the original data table, the server performs aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data. That is, the business system can directly obtain the data to be called from the target data table.
进一步的，步骤104可以包括：Further, step 104 may include:
（1）从所述原始数据表中提取所述第二字段信息对应的数据；(1) extracting data corresponding to the second field information from the original data table;
（2）采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；(2) Aggregating data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
（3）根据所述第一字段信息和所述目标数据构建所述目标数据表。(3) construct the target data table according to the first field information and the target data.
同样以第一字段信息“2017年业务量”为例子说明，首先从原始数据表“2017年1月业务量”、“2017年2月业务量”、“2017年3月业务量”…中提取对应的业务量数据，然后按照一定的聚合处理规则对这些业务量数据进行聚合处理（这里为将业务量相加），即可得到所述目标数据，即2017年的业务量数据。最后，将得到的目标数据和所述第一字段信息构建成一个表格，即目标数据表。Similarly, the first field information "2017 business volume" is used as an example. First, it is extracted from the original data table "January 2017 business volume", "February 2017 business volume", "March 2017 business volume" ... Corresponding business volume data, and then the business volume data is aggregated according to certain aggregation processing rules (here, the business volume is added) to obtain the target data, that is, the 2017 business volume data. Finally, the obtained target data and the first field information are constructed into a table, that is, a target data table.
另外，还可以按照预设的时间间隔对所述原始数据表进行聚合处理。In addition, the original data table may also be aggregated at a preset time interval.
具体的，可以按照业务需求实现分钟/小时为粒度，产生目标数据表。比如，可以每分钟聚合一次数据。Specifically, the minute / hour granularity can be achieved according to business requirements to generate a target data table. For example, you can aggregate data every minute.
其中，所述时间间隔可以通过以下步骤调整：The time interval can be adjusted through the following steps:
（1）实时监测influxdb数据库所在服务器的内存消耗量；(1) Real-time monitoring of the memory consumption of the server where the influxdb database is located;
（2）若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。(2) If the average value of the memory consumption in the unit time is greater than the first threshold, gradually increase the time interval according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold .
对于influxdb数据库所在的服务器来说，进行数据聚合需要消耗内存，而且数据聚合的频率越高（即聚合的时间间隔越短），则消耗的内存越大。为了避免服务器的内存消耗过大，可以实时监测服务器的内存消耗量，若该消耗量在单位时间内的均值超过某个预设的上限值（即第一阈值），则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。比如，初始设置的时间间隔为60s进行一次数据聚合处理，若监测到1小时内系统的内存消耗量均值超过极限值95%，则可以将时间间隔提高一定的程度，比如提高至70s，使得1小时内系统的内存消耗量均值小于95%。For the server where the influxdb database is located, data aggregation requires memory consumption, and the higher the frequency of data aggregation (that is, the shorter the time interval for aggregation), the greater the memory consumption. In order to avoid excessive memory consumption of the server, the memory consumption of the server can be monitored in real time. If the average value of the consumption in a unit time exceeds a preset upper limit value (that is, the first threshold value), the preset ratio will be gradually increased. Increasing the time interval until the average value of the memory consumption in a unit time is less than the first threshold. For example, the initial set time interval is 60s for one data aggregation process. If the average memory consumption of the system exceeds 95% of the limit within 1 hour, you can increase the time interval to a certain degree, such as 70s, making 1 The average memory consumption of the system during the hour is less than 95%.
在步骤101-104中，服务器实际上构建了一段处理逻辑，当获取到业务系统的数据调用请求时，利用该处理逻辑调用influxdb数据库的原始数据表，并对该原始数据表进行聚合处理，得到业务系统所需的目标数据表。In steps 101-104, the server actually constructs a piece of processing logic. When a data call request for the business system is obtained, the processing logic is used to call the original data table of the influxdb database, and the original data table is aggregated to obtain The target data table required by the business system.
105、将所述目标数据表传送给所述业务系统。105. Transmit the target data table to the service system.
在得到目标数据表之后，服务器将所述目标数据表传送给所述业务系统，业务系统即可调用所述目标数据。After the target data table is obtained, the server transmits the target data table to the business system, and the business system can call the target data.
实际测试结果如下：基于8核CPU，32G内存的服务器。原有业务系统直接调用influxdb接口的模式下，只能支撑10多台业务终端的数据采集，约千万级数量处理，内存消耗大于32G，服务器会内存溢出。若采用本方法，接入70多台业务终端的数据采集，业务数据量达亿笔，服务器的内存消耗约20G，仅仅为原来的2/3。The actual test results are as follows: A server based on an 8-core CPU and 32G memory. In the mode where the original business system directly calls the influxdb interface, it can only support the data collection of more than 10 business terminals, processing about ten million levels, the memory consumption is greater than 32G, and the server will overflow memory. If this method is used, access to the data collection of more than 70 business terminals, the amount of business data will reach 100 million, and the memory consumption of the server will be about 20G, which is only 2/3 of the original.
在本申请实施例中，业务系统不再直接从influxdb数据库的接口调取数据，也即业务系统和influxdb数据库之间无需直接进行可视化界面的数据传输。由于利用该处理逻辑调用influxdb数据库的数据进行聚合对服务器的资源消耗远远小于由业务系统直接调用influxdb数据库对服务器的资源消耗，故本申请能够有效降低数据库后台服务器的资源消耗，提高业务系统运行的稳定性。In the embodiment of the present application, the business system no longer directly retrieves data from the interface of the influxdb database, that is, the data transmission between the business system and the influxdb database does not need to be performed directly on a visual interface. Because the data in the influxdb database is aggregated by using this processing logic, the resource consumption of the server is much smaller than the resource consumption of the server directly called by the influxdb database by the business system, so this application can effectively reduce the resource consumption of the database background server and improve the business system operation. The stability.
请参阅图2，本申请实施例中一种业务系统调用influxdb数据库的方法的第二个实施例包括：Referring to FIG. 2, a second embodiment of a method for a business system to call an influxdb database in an embodiment of the present application includes:
201、获取业务系统的数据调用请求；201: Obtain a data call request of a business system;
202、根据所述数据调用请求确定第一字段信息；202: Determine first field information according to the data call request;
203、从influxdb数据库中获取与所述第一字段信息关联的原始数据表；203. Obtain a raw data table associated with the first field information from an influxdb database.
步骤201-203与步骤101-103相同，具体可参照步骤101-103的相关说明。Steps 201-203 are the same as steps 101-103. For details, refer to the description of steps 101-103.
204、实时监测influxdb数据库所在服务器的内存消耗量；204. Monitor the memory consumption of the server where the influxdb database is located in real time;
在数据调用过程中，实时监测influxdb数据库所在服务器的内存消耗量。During the data calling process, the memory consumption of the server where the influxdb database is located is monitored in real time.
205、根据所述内存消耗量调整所述原始数据表的数据时效；205. Adjust data aging of the original data table according to the memory consumption amount.
根据所述内存消耗量调整所述原始数据表的数据时效，具体的，步骤205可以包括：Adjusting the data aging of the original data table according to the memory consumption, specifically, step 205 may include:
（1）当检测到所述内存消耗量大于第二阈值时，缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值；(1) when it is detected that the memory consumption is greater than a second threshold, shortening the data aging of the original data table so that the memory consumption is less than the second threshold;
（2）当检测到所述内存消耗量小于第三阈值时，延长所述原始数据表的数据时效，使得所述内存消耗量大于所述第三阈值，所述第三阈值小于所述第二阈值。(2) when it is detected that the memory consumption is less than a third threshold, extending the data aging of the original data table so that the memory consumption is larger than the third threshold, and the third threshold is smaller than the second threshold Threshold.
influxdb数据库中的数据具有对应的数据时效。该数据时效是influxdb数据库为存储的数据设置的一个参数，用于限定数据在什么时段内有效。服务器的内存消耗量跟原始数据表的数据时效有关：数据时效越短，则内存消耗量越小。因此，当检测到服务器的内存消耗量超过某个阈值时，可以通过缩短所述原始数据表的数据时效来降低内存消耗量，使得所述内存消耗量小于所述第二阈值。另外，若内存资源比较充裕，内存消耗量较小时，也可以合理地延长所述原始数据表的数据时效，以满足高数据时效的业务需求。The data in the influxdb database has the corresponding data aging. The data aging is a parameter set by the influxdb database for the stored data, and is used to limit the period during which the data is valid. The server's memory consumption is related to the data age of the original data table: the shorter the data age, the smaller the memory consumption. Therefore, when it is detected that the memory consumption of the server exceeds a certain threshold, the memory consumption can be reduced by shortening the data aging of the original data table, so that the memory consumption is smaller than the second threshold. In addition, if the memory resources are relatively abundant and the memory consumption is small, the data age of the original data table may be extended reasonably to meet the business requirements of high data age.
对于上述步骤（1），具体可以包括：For the above step (1), it may specifically include:
（1.1）获取所述原始数据表当前的数据时效；(1.1) obtaining the current data aging of the original data table;
（1.2）在预设的关系记录表中查询与所述当前的数据时效对应的第一线性关系表达式，所述关系记录表记录着各个数据时效分别对应的线性关系表达式，所述线性关系表达式用于表示内存消耗量和所述原始数据表的数据量之间的关系；(1.2) Query a first linear relationship expression corresponding to the current data aging in a preset relationship record table, where the relationship record table records a linear relationship expression corresponding to each data aging, and the linear relationship An expression used to indicate a relationship between a memory consumption amount and a data amount of the original data table;
（1.3）将检测到的内存消耗量代入所述第一线性关系表达式，计算得到对应的目标数据量；(1.3) Substituting the detected memory consumption amount into the first linear relationship expression to calculate a corresponding target data amount;
（1.4）将所述目标数据量分别代入所述关系记录表中的各个线性关系表达式，计算得到各个线性关系表达式分别对应的内存消耗量；(1.4) Substituting the target data amount into each linear relationship expression in the relationship record table, and calculating the memory consumption corresponding to each linear relationship expression;
（1.5）从所述各个线性关系表达式中选取对应的内存消耗量小于所述第二阈值的第二线性关系表达式；(1.5) selecting from the respective linear relationship expressions a second linear relationship expression whose corresponding memory consumption is less than the second threshold;
（1.6）将所述原始数据表的数据时效调整为所述第二线性关系表达式对应的数据时效。(1.6) Adjusting the data aging of the original data table to the data aging corresponding to the second linear relationship expression.
表1Table 1
数据时效 Data aging 线性关系表达式 Linear relational expression
7天 7 days y = 2.6 x + 8867 y = 2.6 x + 8867
3天 3 days y = 1.6 x +7392 y = 1.6 x +7392
1天 1 day y = 2.02 x +2666 y = 2.02 x +2666
12小时 12 hours y = 1.97 x + 1672 y = 1.97 x + 1672
6小时 6 hours y = 1.38 x + 2484 y = 1.38 x + 2484
3小时 3 hours y = 1.09 x + 1707 y = 1.09 x + 1707
表1为一个关系记录表的示例，记录着各个数据时效分别对应的线性关系表达式，比如，数据时效“7天”对应线性关系表达式“y = 2.6 x + 8867”。在该表中，y表示内存消耗量（单位MB），x表示所述原始数据表的数据量（单位万笔）。比如，当检测到服务器的内存消耗量超过10G（假设为12G）时，获取所述原始数据表当前的数据时效，假设为3天。然后，在上述表格中查询时效3天对应的第一线性关系表达式，即y = 1.6 x +7392，将y=12G代入该公式，计算得到目标数据量x 0，然后将x 0分别代入上述表格中的各个线性关系表达式，计算得到各个线性关系表达式分别对应的内存消耗量，比如2.02 x 0+2666，1.97 x 0+1672等。最后，可以按照预设的规则选取其中一个数值小于10G的内存消耗量值，将数据时效调整为该内存消耗量值对应的数据时效，比如将时效调整为12小时或6小时。 Table 1 is an example of a relationship record table, which records the linear relationship expressions corresponding to the aging of each data, for example, the data aging "7 days" corresponds to the linear relationship expression "y = 2.6 x + 8867". In the table, y represents the amount of memory consumption (in MB), and x represents the amount of data in the original data table (in tens of thousands). For example, when it is detected that the memory consumption of the server exceeds 10G (assuming 12G), the current data aging of the original data table is obtained, assuming 3 days. Then, in the above table, query the first linear relationship expression corresponding to the aging period of 3 days, that is, y = 1.6 x +7392, substitute y = 12G into the formula, calculate the target data amount x 0 , and then substitute x 0 into the above For each linear relationship expression in the table, calculate the memory consumption corresponding to each linear relationship expression, such as 2.02 x 0 +2666, 1.97 x 0 +1672, and so on. Finally, one of the memory consumption values with a value less than 10G can be selected according to a preset rule, and the data age is adjusted to the data age corresponding to the memory consumption value, for example, the age is adjusted to 12 hours or 6 hours.
通过这样设置，可以在业务系统调用数据的过程中进一步降低influxdb数据库所在服务器的内存消耗量。With this setting, the memory consumption of the server where the influxdb database is located can be further reduced during the process of calling data by the business system.
206、若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表；206. If the data in the original data table exceeds the data age, then clear the original data table in the memory of the server;
若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表，以减小内存消耗量。If the data of the original data table exceeds the data age, the original data table is cleared in the memory of the server to reduce the memory consumption.
207、对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表；207: Aggregate the original data table output by the influxdb database to obtain a target data table.
208、将所述目标数据表传送给所述业务系统。208. Transmit the target data table to the service system.
步骤207-208与步骤104-105相同，具体可参照步骤104-105的相关说明。Steps 207-208 are the same as steps 104-105. For details, refer to the related descriptions of steps 104-105.
与本申请的第一个实施例相比，本实施例通过实时监测influxdb数据库所在服务器的内存消耗量，并根据监测到的内存消耗量调整所述原始数据表的数据时效，能够在业务系统调用数据的过程中进一步降低influxdb数据库所在服务器的内存消耗量。Compared with the first embodiment of the present application, in this embodiment, the real-time monitoring of the memory consumption of the server where the influxdb database is located, and adjusting the data aging of the original data table according to the monitored memory consumption, can be called in the business system The process of data further reduces the memory consumption of the server where the influxdb database is located.
应理解，上述实施例中各步骤的序号的大小并不意味着执行顺序的先后，各过程的执行顺序应以其功能和内在逻辑确定，而不应对本申请实施例的实施过程构成任何限定。It should be understood that the size of the sequence numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.
上面主要描述了一种业务系统调用influxdb数据库的方法，下面将对一种业务系统调用influxdb数据库的装置进行详细描述。The above mainly describes a method for a business system to call an influxdb database, and a device for a business system to call an influxdb database will be described in detail below.
请参阅图3，本申请实施例中一种业务系统调用influxdb数据库的装置的一个实施例包括：Referring to FIG. 3, an embodiment of a device for a business system to call an influxdb database in an embodiment of the present application includes:
请求获取模块301，用于获取业务系统的数据调用请求；A request acquisition module 301, configured to acquire a data call request of a business system;
字段信息确定模块302，用于根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；A field information determining module 302, configured to determine first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
原始数据表获取模块303，用于从influxdb数据库中获取与所述第一字段信息关联的原始数据表；A raw data table obtaining module 303, configured to obtain a raw data table associated with the first field information from an influxdb database;
聚合处理模块304，用于对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；An aggregation processing module 304, configured to perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
数据传送模块305，用于将所述目标数据表传送给所述业务系统。A data transmission module 305 is configured to transmit the target data table to the service system.
进一步的，所述原始数据表获取模块可以包括：Further, the raw data table obtaining module may include:
字段信息查询单元，用于在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；A field information query unit, configured to query a second field information associated with the first field information in a preset field information association table;
原始数据表获取单元，用于从influxdb数据库中获取字段包含所述第二字段信息的原始数据表；A raw data table obtaining unit, configured to obtain a raw data table whose field contains the second field information from an influxdb database;
所述聚合处理模块可以包括：The aggregation processing module may include:
数据提取单元，用于从所述原始数据表中提取所述第二字段信息对应的数据；A data extraction unit, configured to extract data corresponding to the second field information from the original data table;
聚合处理单元，用于采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；An aggregation processing unit, configured to perform aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
目标数据表构建单元，用于根据所述第一字段信息和所述目标数据构建所述目标数据表。A target data table constructing unit, configured to construct the target data table according to the first field information and the target data.
进一步的，所述聚合处理模块具体用于：按照预设的时间间隔对所述原始数据表进行聚合处理；Further, the aggregation processing module is specifically configured to perform aggregation processing on the original data table according to a preset time interval;
其中，所述时间间隔通过以下步骤调整：The time interval is adjusted by the following steps:
实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。If the average value of the memory consumption in the unit time is greater than the first threshold, the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
进一步的，所述业务系统调用influxdb数据库的装置还可以包括：Further, the device for the business system to call the influxdb database may further include:
内存消耗监测模块，用于实时监测influxdb数据库所在服务器的内存消耗量；Memory consumption monitoring module, used to monitor the memory consumption of the server where the influxdb database is located in real time;
数据时效调整模块，用于根据所述内存消耗量调整所述原始数据表的数据时效；A data age adjustment module, configured to adjust the data age of the original data table according to the memory consumption amount;
内存数据清除模块，用于若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表。The memory data clearing module is configured to clear the original data table from the memory of the server if the data of the original data table exceeds the data age.
更进一步的，所述数据时效调整模块可以包括：Furthermore, the data aging adjustment module may include:
第一时效调整单元，用于当检测到所述内存消耗量大于第二阈值时，缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值；A first aging adjustment unit, configured to shorten the data aging of the original data table when it is detected that the memory consumption is greater than a second threshold, so that the memory consumption is less than the second threshold;
第二时效调整单元，用于当检测到所述内存消耗量小于第三阈值时，延长所述原始数据表的数据时效，使得所述内存消耗量大于所述第三阈值，所述第三阈值小于所述第二阈值。A second aging adjustment unit, configured to extend the data aging of the original data table when the memory consumption is less than a third threshold, so that the memory consumption is greater than the third threshold, and the third threshold Less than the second threshold.
更进一步的，所述第一时效调整单元可以包括：Furthermore, the first aging adjustment unit may include:
数据时效获取子单元，用于获取所述原始数据表当前的数据时效；A data aging obtaining subunit, configured to obtain the current data aging of the original data table;
线性关系表达式查询子单元，用于在预设的关系记录表中查询与所述当前的数据时效对应的第一线性关系表达式，所述关系记录表记录着各个数据时效分别对应的线性关系表达式，所述线性关系表达式用于表示内存消耗量和所述原始数据表的数据量之间的关系；The linear relationship expression query subunit is configured to query a preset relationship record table for a first linear relationship expression corresponding to the current data aging, and the relationship record table records a linear relationship corresponding to each data aging. An expression, the linear relationship expression is used to represent a relationship between a memory consumption amount and a data amount of the original data table;
线性关系表达式代入子单元，用于将检测到的内存消耗量代入所述第一线性关系表达式，计算得到对应的目标数据量；A linear relationship expression is substituted into the subunit, and is configured to substitute the detected memory consumption amount into the first linear relationship expression to calculate a corresponding target data amount;
内存消耗量计算子单元，用于将所述目标数据量分别代入所述关系记录表中的各个线性关系表达式，计算得到各个线性关系表达式分别对应的内存消耗量；A memory consumption calculation subunit, configured to substitute the target data amount into each linear relationship expression in the relationship record table, and calculate and obtain a memory consumption amount corresponding to each linear relationship expression;
线性表达式选取子单元，用于从所述各个线性关系表达式中选取对应的内存消耗量小于所述第二阈值的第二线性关系表达式；A linear expression selection subunit, configured to select, from the respective linear relationship expressions, a second linear relationship expression whose corresponding memory consumption is less than the second threshold;
数据时效调整子单元，用于将所述原始数据表的数据时效调整为所述第二线性关系表达式对应的数据时效。The data aging adjustment subunit is configured to adjust the data aging of the original data table to a data aging corresponding to the second linear relationship expression.
本申请实施例还提供一种计算机可读存储介质，所述计算机可读存储介质存储有计算机可读指令，所述计算机可读指令被处理器执行时实现如图1或图2表示的任意一种业务系统调用influxdb数据库的方法的步骤。An embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, any one shown in FIG. The steps of a method for a business system to call the influxdb database.
本申请实施例还提供一种终端设备，包括存储器、处理器以及存储在所述存储器中并可在所述处理器上运行的计算机可读指令，所述处理器执行所述计算机可读指令时实现如图1或图2表示的任意一种业务系统调用influxdb数据库的方法的步骤。An embodiment of the present application further provides a terminal device including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor. When the processor executes the computer-readable instructions, The steps of implementing a method for influxdb database of any business system shown in FIG. 1 or FIG. 2 are implemented.

Claims (20)

  1. 一种业务系统调用influxdb数据库的方法，其特征在于，包括：A method for a business system to call an influxdb database, which includes:
    获取业务系统的数据调用请求；Get the data call request of the business system;
    根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；Determining first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
    从influxdb数据库中获取与所述第一字段信息关联的原始数据表；Obtaining a raw data table associated with the first field information from an influxdb database;
    对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；Perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
    将所述目标数据表传送给所述业务系统。Transmitting the target data table to the business system.
  2. 根据权利要求1所述的业务系统调用influxdb数据库的方法，其特征在于，所述从influxdb数据库中获取与所述第一字段信息关联的原始数据表包括：The method for calling an influxdb database by a business system according to claim 1, wherein the obtaining the original data table associated with the first field information from the influxdb database comprises:
    在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；Querying the second field information associated with the first field information in a preset field information association table;
    从influxdb数据库中获取字段包含所述第二字段信息的原始数据表；Obtaining a raw data table whose field contains the second field information from an influxdb database;
    所述对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表包括：Aggregating the original data table output by the influxdb database to obtain a target data table includes:
    从所述原始数据表中提取所述第二字段信息对应的数据；Extracting data corresponding to the second field information from the original data table;
    采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；Performing aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
    根据所述第一字段信息和所述目标数据构建所述目标数据表。Constructing the target data table according to the first field information and the target data.
  3. 根据权利要求1所述的业务系统调用influxdb数据库的方法，其特征在于，所述对influxdb数据库输出的所述原始数据表进行聚合处理具体为：The method for calling an influxdb database by a business system according to claim 1, wherein the performing aggregation processing on the original data table output by the influxdb database is:
    按照预设的时间间隔对所述原始数据表进行聚合处理；Perform aggregation processing on the original data table according to a preset time interval;
    其中，所述时间间隔通过以下步骤调整：The time interval is adjusted by the following steps:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。If the average value of the memory consumption in the unit time is greater than the first threshold, the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
  4. 根据权利要求1至3中任一项所述的业务系统调用influxdb数据库的方法，其特征在于，还包括：The method for calling an influxdb database by a business system according to any one of claims 1 to 3, further comprising:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    根据所述内存消耗量调整所述原始数据表的数据时效；Adjusting data aging of the original data table according to the memory consumption amount;
    若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表。If the data of the original data table exceeds the data age, the original data table is cleared from the memory of the server.
  5. 根据权利要求4所述的业务系统调用influxdb数据库的方法，其特征在于，所述根据所述内存消耗量调整所述原始数据表的数据时效包括：The method for calling an influxdb database by a business system according to claim 4, wherein the adjusting the data aging of the original data table according to the memory consumption comprises:
    当检测到所述内存消耗量大于第二阈值时，缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值；When it is detected that the memory consumption is greater than the second threshold, shortening the data aging of the original data table so that the memory consumption is less than the second threshold;
    当检测到所述内存消耗量小于第三阈值时，延长所述原始数据表的数据时效，使得所述内存消耗量大于所述第三阈值，所述第三阈值小于所述第二阈值。When the memory consumption is detected to be less than a third threshold, the data aging of the original data table is extended so that the memory consumption is greater than the third threshold, and the third threshold is smaller than the second threshold.
  6. 根据权利要求5所述的业务系统调用influxdb数据库的方法，其特征在于，所述缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值包括：The method for calling an influxdb database by a business system according to claim 5, wherein the shortening the data aging of the original data table so that the memory consumption is less than the second threshold comprises:
    获取所述原始数据表当前的数据时效；Obtaining the current data aging of the original data table;
    在预设的关系记录表中查询与所述当前的数据时效对应的第一线性关系表达式，所述关系记录表记录着各个数据时效分别对应的线性关系表达式，所述线性关系表达式用于表示内存消耗量和所述原始数据表的数据量之间的关系；Query a first linear relationship expression corresponding to the current data aging in a preset relationship record table, where the relationship record table records a linear relationship expression corresponding to each data aging, and the linear relationship expression uses The relationship between the amount of memory consumption and the amount of data in the original data table;
    将检测到的内存消耗量代入所述第一线性关系表达式，计算得到对应的目标数据量；Substituting the detected memory consumption amount into the first linear relationship expression to calculate a corresponding target data amount;
    将所述目标数据量分别代入所述关系记录表中的各个线性关系表达式，计算得到各个线性关系表达式分别对应的内存消耗量；Substituting the target data amount into each linear relationship expression in the relationship record table, and calculating a memory consumption amount corresponding to each linear relationship expression;
    从所述各个线性关系表达式中选取对应的内存消耗量小于所述第二阈值的第二线性关系表达式；Selecting from the respective linear relationship expressions a second linear relationship expression whose corresponding memory consumption is less than the second threshold;
    将所述原始数据表的数据时效调整为所述第二线性关系表达式对应的数据时效。Adjusting the data aging of the original data table to the data aging corresponding to the second linear relationship expression.
  7. 一种计算机可读存储介质，所述计算机可读存储介质存储有计算机可读指令，其特征在于，所述计算机可读指令被处理器执行时实现如下步骤：A computer-readable storage medium storing computer-readable instructions, wherein the computer-readable instructions implement the following steps when executed by a processor:
    获取业务系统的数据调用请求；Get the data call request of the business system;
    根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；Determining first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
    从influxdb数据库中获取与所述第一字段信息关联的原始数据表；Obtaining a raw data table associated with the first field information from an influxdb database;
    对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；Perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
    将所述目标数据表传送给所述业务系统。Transmitting the target data table to the business system.
  8. 根据权利要求7所述的计算机可读存储介质，其特征在于，所述从influxdb数据库中获取与所述第一字段信息关联的原始数据表包括：The computer-readable storage medium according to claim 7, wherein the obtaining the original data table associated with the first field information from an influxdb database comprises:
    在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；Querying the second field information associated with the first field information in a preset field information association table;
    从influxdb数据库中获取字段包含所述第二字段信息的原始数据表；Obtaining a raw data table whose field contains the second field information from an influxdb database;
    所述对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表包括：Aggregating the original data table output by the influxdb database to obtain a target data table includes:
    从所述原始数据表中提取所述第二字段信息对应的数据；Extracting data corresponding to the second field information from the original data table;
    采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；Performing aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
    根据所述第一字段信息和所述目标数据构建所述目标数据表。Constructing the target data table according to the first field information and the target data.
  9. 根据权利要求7所述的计算机可读存储介质，其特征在于，所述对influxdb数据库输出的所述原始数据表进行聚合处理具体为：The computer-readable storage medium according to claim 7, wherein the performing aggregation processing on the original data table output by the influxdb database is specifically:
    按照预设的时间间隔对所述原始数据表进行聚合处理；Perform aggregation processing on the original data table according to a preset time interval;
    其中，所述时间间隔通过以下步骤调整：The time interval is adjusted by the following steps:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。If the average value of the memory consumption in the unit time is greater than the first threshold, the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
  10. 根据权利要求7至9中任一项所述的计算机可读存储介质，其特征在于，所述计算机可读指令被处理器执行时还实现如下步骤：The computer-readable storage medium according to any one of claims 7 to 9, wherein when the computer-readable instructions are executed by a processor, the following steps are further implemented:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    根据所述内存消耗量调整所述原始数据表的数据时效；Adjusting data aging of the original data table according to the memory consumption amount;
    若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表。If the data of the original data table exceeds the data age, the original data table is cleared from the memory of the server.
  11. 根据权利要求10所述的计算机可读存储介质，其特征在于，所述根据所述内存消耗量调整所述原始数据表的数据时效包括：The computer-readable storage medium of claim 10, wherein the adjusting the data age of the original data table according to the memory consumption amount comprises:
    当检测到所述内存消耗量大于第二阈值时，缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值；When it is detected that the memory consumption is greater than the second threshold, shortening the data aging of the original data table so that the memory consumption is less than the second threshold;
    当检测到所述内存消耗量小于第三阈值时，延长所述原始数据表的数据时效，使得所述内存消耗量大于所述第三阈值，所述第三阈值小于所述第二阈值。When the memory consumption is detected to be less than a third threshold, the data aging of the original data table is extended so that the memory consumption is greater than the third threshold, and the third threshold is smaller than the second threshold.
  12. 根据权利要求11所述的计算机可读存储介质，其特征在于，所述缩短所述原始数据表的数据时效，使得所述内存消耗量小于所述第二阈值包括：The computer-readable storage medium of claim 11, wherein the shortening the data aging of the original data table so that the memory consumption is less than the second threshold comprises:
    获取所述原始数据表当前的数据时效；Obtaining the current data aging of the original data table;
    在预设的关系记录表中查询与所述当前的数据时效对应的第一线性关系表达式，所述关系记录表记录着各个数据时效分别对应的线性关系表达式，所述线性关系表达式用于表示内存消耗量和所述原始数据表的数据量之间的关系；Query a first linear relationship expression corresponding to the current data aging in a preset relationship record table, where the relationship record table records a linear relationship expression corresponding to each data aging, and the linear relationship expression uses The relationship between the amount of memory consumption and the amount of data in the original data table;
    将检测到的内存消耗量代入所述第一线性关系表达式，计算得到对应的目标数据量；Substituting the detected memory consumption amount into the first linear relationship expression to calculate a corresponding target data amount;
    将所述目标数据量分别代入所述关系记录表中的各个线性关系表达式，计算得到各个线性关系表达式分别对应的内存消耗量；Substituting the target data amount into each linear relationship expression in the relationship record table, and calculating a memory consumption amount corresponding to each linear relationship expression;
    从所述各个线性关系表达式中选取对应的内存消耗量小于所述第二阈值的第二线性关系表达式；Selecting from the respective linear relationship expressions a second linear relationship expression whose corresponding memory consumption is less than the second threshold;
    将所述原始数据表的数据时效调整为所述第二线性关系表达式对应的数据时效。Adjusting the data aging of the original data table to the data aging corresponding to the second linear relationship expression.
  13. 一种终端设备，包括存储器、处理器以及存储在所述存储器中并可在所述处理器上运行的计算机可读指令，其特征在于，所述处理器执行所述计算机可读指令时实现如下步骤：A terminal device includes a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, and is characterized in that the processor implements the computer-readable instructions as follows step:
    获取业务系统的数据调用请求；Get the data call request of the business system;
    根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；Determining first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
    从influxdb数据库中获取与所述第一字段信息关联的原始数据表；Obtaining a raw data table associated with the first field information from an influxdb database;
    对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；Perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
    将所述目标数据表传送给所述业务系统。Transmitting the target data table to the business system.
  14. 根据权利要求13所述的终端设备，其特征在于，所述从influxdb数据库中获取与所述第一字段信息关联的原始数据表包括：The terminal device according to claim 13, wherein the obtaining a raw data table associated with the first field information from an influxdb database comprises:
    在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；Querying the second field information associated with the first field information in a preset field information association table;
    从influxdb数据库中获取字段包含所述第二字段信息的原始数据表；Obtaining a raw data table whose field contains the second field information from an influxdb database;
    所述对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表包括：Aggregating the original data table output by the influxdb database to obtain a target data table includes:
    从所述原始数据表中提取所述第二字段信息对应的数据；Extracting data corresponding to the second field information from the original data table;
    采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；Performing aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
    根据所述第一字段信息和所述目标数据构建所述目标数据表。Constructing the target data table according to the first field information and the target data.
  15. 根据权利要求13所述的终端设备，其特征在于，所述对influxdb数据库输出的所述原始数据表进行聚合处理具体为：The terminal device according to claim 13, wherein the performing aggregation processing on the original data table output by the influxdb database is specifically:
    按照预设的时间间隔对所述原始数据表进行聚合处理；Perform aggregation processing on the original data table according to a preset time interval;
    其中，所述时间间隔通过以下步骤调整：The time interval is adjusted by the following steps:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。If the average value of the memory consumption in the unit time is greater than the first threshold, the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
  16. 根据权利要求13至15中任一项所述的终端设备，其特征在于，所述处理器执行所述计算机可读指令时还实现如下步骤：The terminal device according to any one of claims 13 to 15, wherein when the processor executes the computer-readable instructions, the following steps are further implemented:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    根据所述内存消耗量调整所述原始数据表的数据时效；Adjusting data aging of the original data table according to the memory consumption amount;
    若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表。If the data of the original data table exceeds the data age, the original data table is cleared from the memory of the server.
  17. 一种业务系统调用influxdb数据库的装置，其特征在于，包括：A device for a business system to call an influxdb database is characterized in that it includes:
    请求获取模块，用于获取业务系统的数据调用请求；A request acquisition module for acquiring a data call request of a business system;
    字段信息确定模块，用于根据所述数据调用请求确定第一字段信息，所述第一字段信息为所述业务系统需要调用的目标数据所对应的字段信息；A field information determining module, configured to determine first field information according to the data calling request, where the first field information is field information corresponding to target data that the business system needs to call;
    原始数据表获取模块，用于从influxdb数据库中获取与所述第一字段信息关联的原始数据表；A raw data table obtaining module, configured to obtain a raw data table associated with the first field information from an influxdb database;
    聚合处理模块，用于对influxdb数据库输出的所述原始数据表进行聚合处理，得到目标数据表，所述目标数据表包含所述目标数据；An aggregation processing module, configured to perform aggregation processing on the original data table output by the influxdb database to obtain a target data table, where the target data table includes the target data;
    数据传送模块，用于将所述目标数据表传送给所述业务系统。A data transmission module is configured to transmit the target data table to the service system.
  18. 根据权利要求17所述的装置，其特征在于，所述原始数据表获取模块包括：The apparatus according to claim 17, wherein the raw data table obtaining module comprises:
    字段信息查询单元，用于在预设的字段信息关联表中查询与所述第一字段信息关联的第二字段信息；A field information query unit, configured to query a second field information associated with the first field information in a preset field information association table;
    原始数据表获取单元，用于从influxdb数据库中获取字段包含所述第二字段信息的原始数据表；A raw data table obtaining unit, configured to obtain a raw data table whose field contains the second field information from an influxdb database;
    所述聚合处理模块包括：The aggregation processing module includes:
    数据提取单元，用于从所述原始数据表中提取所述第二字段信息对应的数据；A data extraction unit, configured to extract data corresponding to the second field information from the original data table;
    聚合处理单元，用于采用预设的聚合处理规则对所述第二字段信息对应的数据进行聚合处理，得到所述目标数据；An aggregation processing unit, configured to perform aggregation processing on data corresponding to the second field information by using a preset aggregation processing rule to obtain the target data;
    目标数据表构建单元，用于根据所述第一字段信息和所述目标数据构建所述目标数据表。A target data table constructing unit, configured to construct the target data table according to the first field information and the target data.
  19. 根据权利要求17所述的装置，其特征在于，所述聚合处理模块具体用于：按照预设的时间间隔对所述原始数据表进行聚合处理；The device according to claim 17, wherein the aggregation processing module is specifically configured to: perform aggregation processing on the original data table according to a preset time interval;
    其中，所述时间间隔通过以下步骤调整：The time interval is adjusted by the following steps:
    实时监测influxdb数据库所在服务器的内存消耗量；Monitor the memory consumption of the server where the influxdb database is located in real time;
    若所述内存消耗量在单位时间内的均值大于第一阈值，则按照预设比例逐步提高所述时间间隔，直至所述内存消耗量在单位时间内的均值小于所述第一阈值。If the average value of the memory consumption in the unit time is greater than the first threshold, the time interval is gradually increased according to a preset ratio until the average value of the memory consumption in the unit time is less than the first threshold.
  20. 根据权利要求17至19中任一项所述的装置，其特征在于，还包括：The device according to any one of claims 17 to 19, further comprising:
    内存消耗监测模块，用于实时监测influxdb数据库所在服务器的内存消耗量；Memory consumption monitoring module, used to monitor the memory consumption of the server where the influxdb database is located in real time;
    数据时效调整模块，用于根据所述内存消耗量调整所述原始数据表的数据时效；A data age adjustment module, configured to adjust the data age of the original data table according to the memory consumption amount;
    内存数据清除模块，用于若所述原始数据表的数据超过所述数据时效，则在所述服务器的内存中清除所述原始数据表。The memory data clearing module is configured to clear the original data table from the memory of the server if the data of the original data table exceeds the data age.
PCT/CN2018/104974 2018-06-12 2018-09-11 Method for calling influxdb database by service system, and storage medium, terminal device and apparatus WO2019237533A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810603099.2A CN108897796B (en) 2018-06-12 2018-06-12 Method for calling Influxdb database by service system, storage medium and server
CN201810603099.2 2018-06-12

Publications (1)

Publication Number Publication Date
WO2019237533A1 true WO2019237533A1 (en) 2019-12-19

Family

ID=64344971

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/104974 WO2019237533A1 (en) 2018-06-12 2018-09-11 Method for calling influxdb database by service system, and storage medium, terminal device and apparatus

Country Status (2)

Country Link
CN (1) CN108897796B (en)
WO (1) WO2019237533A1 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109947853A (en) * 2019-03-25 2019-06-28 阿里巴巴集团控股有限公司 A kind of business activity change cognitive method, system and server
CN111459937B (en) * 2020-03-27 2024-06-07 中国平安人寿保险股份有限公司 Data table association method, device, server and storage medium
CN113792039B (en) * 2021-03-15 2024-03-01 北京京东振世信息技术有限公司 Data processing method and device, electronic equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107015872A (en) * 2016-12-09 2017-08-04 上海壹账通金融科技有限公司 The processing method and processing device of monitoring data
CN107404417A (en) * 2017-07-25 2017-11-28 郑州云海信息技术有限公司 A kind of processing method of monitoring data, processing unit and processing system
CN107463479A (en) * 2017-07-11 2017-12-12 上海精数信息科技有限公司 A kind of social data monitoring system
CN107729219A (en) * 2017-11-17 2018-02-23 北京联想超融合科技有限公司 Resource monitoring method, device and terminal based on super fusion storage system

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106897280B (en) * 2015-12-17 2020-07-14 菜鸟智能物流控股有限公司 Data query method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107015872A (en) * 2016-12-09 2017-08-04 上海壹账通金融科技有限公司 The processing method and processing device of monitoring data
CN107463479A (en) * 2017-07-11 2017-12-12 上海精数信息科技有限公司 A kind of social data monitoring system
CN107404417A (en) * 2017-07-25 2017-11-28 郑州云海信息技术有限公司 A kind of processing method of monitoring data, processing unit and processing system
CN107729219A (en) * 2017-11-17 2018-02-23 北京联想超融合科技有限公司 Resource monitoring method, device and terminal based on super fusion storage system

Also Published As

Publication number Publication date
CN108897796A (en) 2018-11-27
CN108897796B (en) 2023-07-14

Similar Documents

Publication Publication Date Title
US20200372039A1 (en) Data processing method, apparatus, and system
WO2019237533A1 (en) Method for calling influxdb database by service system, and storage medium, terminal device and apparatus
CN110493065B (en) Alarm correlation degree analysis method and system for cloud center operation and maintenance
WO2018077293A1 (en) Data transmission method and system, and electronic device
WO2021036449A1 (en) Dimension data processing method and apparatus, computer device, and storage medium
CN109815344B (en) Network model training system, method, apparatus and medium based on parameter sharing
EP3937022B1 (en) Method and apparatus of monitoring interface performance of distributed application, device and storage medium
CN103312544A (en) Method, equipment and system for controlling terminals during log file reporting
CN110389967B (en) Data storage method, device, server and storage medium
US20230144100A1 (en) Method and apparatus for managing and controlling resource, device and storage medium
CN111932135B (en) Client risk identification method and device based on distributed database
CN111382182A (en) Data processing method and device, electronic equipment and storage medium
WO2023082681A1 (en) Data processing method and apparatus based on batch-stream integration, computer device, and medium
CN110620699A (en) Message arrival rate determination method, device, equipment and computer readable storage medium
CN110659294A (en) Space-time data ad hoc query method, system, electronic device and storage medium
CN116611411A (en) Business system report generation method, device, equipment and storage medium
WO2020125529A1 (en) Application method, system and apparatus for interactive voice response menu, and storage medium
WO2019062404A1 (en) Application program processing method and apparatus, storage medium, and electronic device
WO2019134230A1 (en) Database monitoring method, apparatus, terminal device and storage medium
CN104518913B (en) A kind of cloud service method for detecting abnormality based on artificial immunity
CN110347726A (en) A kind of efficient time series data is integrated to store inquiry system and method
CN115309638A (en) Method and device for assisting model optimization
US11736562B1 (en) Method and system for achieving high availability of service under high-load scene in distributed system
WO2020220534A1 (en) Middleware-based data processing method and related apparatus
CN114143590A (en) Video playing method, server and storage medium

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: 18922351

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 18922351

Country of ref document: EP

Kind code of ref document: A1