Data subscription method, device, server and system

Abstract

The invention provides a data subscription method, comprising the steps of: generating subscription information in response to a subscription activation instruction; performing security verification on the subscription information, generating a security log record through the security verification; reading the email template, and generating hypertext email information and the structured query language according to the subscription information, executing the structured query language, and returning the query result to a mail generating module; by the mail generating module, generating an emailattachment according to the query result, and sending the mail. The above data subscription method is capable of realizing different customization requirements of the user for data subscription, and ensuring that the subscription data is quickly and timely launched. Users may use different terminals to quickly and efficiently query multiple servers or distributed servers with high security and effective SQL injection prevention.

Description

technical field [0001] The invention belongs to the technical field of the Internet, and in particular relates to a data subscription method, device, server and system. Background technique [0002] Data query and data subscription are two main methods of data acquisition in the Internet. For the data query requirements newly submitted by users, each existing business system needs to go through a complete set of processes of requirement acceptance, requirement realization, result testing, and requirement launch. The launch cycle of the entire function is long, and the involvement of various aspects is also relatively complicated. [0003] Therefore, if the data query requirement is only a non-general requirement for serving VIP users, the existing technology often transfers the operation and maintenance personnel to directly access the database for data query, and then export the results to the user. However, if these requirements are frequently queried or require immediat...

AI Technical Summary

Problems solved by technology

[0004] In terms of data subscription: push report is the main means of data subscription. There are currently very mature technologies for report generation, but the current various report platforms are very heavy, and a certain knowledge background is required to use them.

Moreover, accessing this type of report system often brings many complexity and security problems to the business system, especially when VIP users only need simple reports such as monitoring and early warning, statistical summary, etc., it is better to let the operation and maintenance Personnel directly export data from the database, and then use Excel to generate reports—this is also a common practice in existing technologies, but its efficiency and cost are still difficult to ignore.

[0005] When the existing technology serves VIP users, it is difficult to meet the high-frequency query and instant feedback requirements of their non-general needs in terms of data query; and cost challenges

Images