A data subscription method, device, server and system

Abstract

The present invention proposes a data subscription method, including: generating subscription information in response to a subscription activation instruction; performing security verification on the subscription information, and generating a security log record if it passes the security verification; reading an email template, and generating a hypertext email according to the subscription information information and structured query language, execute the structured query language, and return the query result to the email generation module; the email generation module generates email attachments according to the query result, and sends the email. The above data subscription method can realize different customization requirements of users for data subscription, and ensure fast and timely online subscription of subscription data. Users can use different terminals to quickly and effectively query multiple servers or distributed servers, with high security and effective prevention of SQL injection.

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