CN113821515A

CN113821515A - Method for inquiring and analyzing linkage rate based on MySql

Info

Publication number: CN113821515A
Application number: CN202111130324.3A
Authority: CN
Inventors: 王连喜
Original assignee: Beijing Huibo Technology Co ltd
Current assignee: Beijing Huibo Technology Co ltd
Priority date: 2021-09-26
Filing date: 2021-09-26
Publication date: 2021-12-21

Abstract

The invention discloses a method for analyzing the joint rate based on MySql query. The method comprises the following steps: a user enters a joint rate analysis page, selects or inputs order data parameters to be queried, and submits a custom task; receives the order data parameters of the custom task, and converts the parameters to the parameters. Pass it into the background, and then MySql executes the custom task; MySql executes the custom task, and after MySql executes the custom task, the table that obtains the result of calculating the joint rate is saved in the database result table; when the user queries the task status and task result , the user association rate analysis page returns the custom task execution result and status to the user according to the data in the database result table. The invention analyzes the joint rate through a complete and efficient mysql data table, and from the aspect of specific data, can more clearly see the joint and correlation between various commodities, and helps the merchants to reasonably promote the commodities and increase the sales volume.

Description

Method for inquiring and analyzing linkage rate based on MySql

Technical Field

The invention relates to the technical field of computer application, in particular to a method for inquiring and analyzing linkage rate based on MySql.

Background

In the field of sales, it is important for merchants to sell commodities with relevance, but the relevance defined by the merchants is different from the relevance understood by users, and wrong marketing is likely to be half the time. For a shopping center pursuing multi-business mixed consumption, the associated consumption is the core of the shopping center operation, and when the brand combination is fixed, the associated rate can be improved or not by increasing the unit price of customers.

Disclosure of Invention

Aiming at the technical problems in the related art, the invention provides a method for inquiring and analyzing the linkage rate based on MySql, which can overcome the defects of the prior art.

In order to achieve the technical purpose, the technical scheme of the invention is realized as follows:

a method for analyzing linkage rate based on MySql query comprises the following steps:

s1, the user enters the linkage rate analysis page, selects or inputs the order data parameter to be inquired, and creates and submits the self-defined task;

s2, receiving order data parameters of the custom task, transmitting the parameters to a background, and then, MySql executing the custom task;

s3, the MySql executes a user-defined task, firstly, the MySql creates a table 1, the table 1 reads order data, calculates the number of users who purchase each commodity, creates a table 2, the table 2 calculates the number of users who purchase a commodity I and a commodity II, the table 1 is left-associated with the table 2, filters out data in the table 2 with the same commodity, calculates the linkage rate at the same time, creates a table 3, and outputs the calculated linkage rate result to the table 3;

s4, creating a table 4 by the MySql, wherein the table 4 is used for storing the client type, associating the table 3 with the table 4, creating a table 5 by the MySql, and outputting the association rate to the table 5;

s5, after the MySql executes the user-defined task, saving the table 5 for obtaining the result of calculating the linkage rate into a database result table;

and S6, when the user inquires the task state and the task result, the user association rate analysis page returns the self-defined task execution result and state to the user according to the data of the database result table.

Further, the order data parameters to be inquired comprise input parameters, a time range, commodities to be analyzed, commodity order data, a linkage rate range, a recommendable people number range and a predicted success people number range.

Further, in step S3, when the user number of the purchased commodity is calculated in table 1 and table 2, it is necessary to perform deduplication in advance based on the unique identification ID of the user.

Further, in step S4, the client types include an important client and a common client, and when the important client outputs the association rate again, all the association rates are normally output, and the important client includes important data in approximately 90 days; when the common client outputs the linkage rate, only the linkage rate data with the linkage rate more than 10% is output, and the important data of nearly 90 days are not included.

Further, the user selects screening, exporting or directly selecting marketing according to the returned results.

The invention has the beneficial effects that: the linkage rate is analyzed through a complete and efficient mysql data table, and the linkage and relevance among various commodities can be more clearly seen from the aspect of specific data; two kinds of execution methods of one set of flow, laminating reality, high efficiency execution analysis task more, moreover, the inquiry scope is big, and the maximize supports inquiry yesterday data, more is favorable to customer analysis and marketing, and help the trade company rationally promote commodity, improve the sales volume.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.

Fig. 1 is a flowchart of a method for analyzing linkage rate based on MySql query according to an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention belong to the protection scope of the present invention, and for the convenience of understanding the above technical solutions of the present invention, the above technical solutions of the present invention are described in detail below by specific use modes.

As shown in fig. 1, according to the method for analyzing the linkage rate based on MySql query in the embodiment of the present invention, the implementation steps include: firstly, a user enters a linkage rate analysis page, selects or inputs order data parameters to be inquired, and creates and submits a custom task. The order data parameters to be inquired comprise input parameters, a time range, commodities to be analyzed, commodity order data, a linkage rate range, a recommendable people number range and a predicted success people number range.

And transmitting the received order data parameters of the custom task into a background, and then executing the custom task by MySql.

The MySql executes a user-defined task, firstly, the MySql creates a table 1, the table 1 reads order data, calculates the number of users purchased by each commodity, creates a table 2 by the MySql, calculates the number of users who purchased a commodity I and a commodity II at the same time by the table 2, the table 1 is left-associated with the table 2, filters out data in the table 2 with the same commodity, calculates the linkage rate at the same time, creates a table 3, and outputs the calculated linkage rate result to the table 3; when the number of users purchasing commodities is calculated in the tables 1 and 2, duplication removal needs to be performed in advance according to the unique identification ID of the users; MySql creates table 4, wherein table 4 is used for storing the client type and associating table 3 with table 4; the MySql creates a table 5 again, and the association rate is output to the table 5; the client types comprise key clients and common clients, when the key clients output the linkage rate again, all the linkage rates are normally output, and important data in nearly 90 days are contained (the calculation cycle is T +1, and the calculation is carried out by using the data in nearly 90 days before today); when the common client outputs the linkage rate, only the linkage rate data with the linkage rate more than 10% is output, and the important data of nearly 90 days are not included.

And after the MySql executes the custom task, saving the table 5 for obtaining the result of calculating the linkage rate into a database result table.

And when the user inquires the task state and the task result, the user association rate analysis page returns the user-defined task execution result and state to the user according to the data of the database result table, and the user selects screening, exporting or directly selects marketing according to the returned result.

In conclusion, by means of the technical scheme, the linkage rate is analyzed through the complete and efficient mysql data table, and the linkage and relevance among commodities can be more clearly seen from the aspect of specific data; two kinds of execution methods of one set of flow, more laminating reality, high efficiency execution analysis task, moreover, the inquiry scope is big, and the maximize supports inquiry yesterday data, more is favorable to customer analysis and marketing, and help the trade company rationally promote commodity, improve the sales volume, brings actual convenient experience effect for the user.

The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.

Claims

1. a method based on MySql query analysis joint rate, is characterized in that, comprises the following steps:

S1: The user enters the joint rate analysis page, selects or enters the order data parameters to be queried, and creates and submits a custom task;

S2: Receive the order data parameters of the custom task, and pass the parameters into the background, and then MySql executes the custom task;

S3: MySql performs custom tasks. First, MySql creates table 1, table 1 reads the order data, and calculates the number of users who have purchased each product, MySql creates table 2, and table 2 calculates the purchase of product 1 and purchased product 2 at the same time The number of users, the left associated table 2 of the table 1, and filter out the data in the table 2 that the commodity is the same, calculate the joint rate at the same time, create a table 3, and output the calculated joint rate result to the table 3 ;

S4: MySql creates table 4, table 4 is used for storing customer type, and described table 3 and table 4 are associated, MySql creates table 5 again, and joint rate is outputted to described table 5;

S5: After MySql completes the execution of the custom task, the table 5 that obtains the result of calculating the joint rate is saved in the database result table;

S6: When the user inquires about the task status and the task result, the user association rate analysis page returns the user-defined task execution result and status to the user according to the data in the database result table.

2. the method for analyzing joint rate based on MySql query according to claim 1, is characterized in that, described order data parameter to be queried includes input parameter, time scope, commodity to be analyzed, commodity order data, joint rate range , the range of the number of people who can be recommended and the range of the number of people who are expected to succeed.

3. the method based on MySql query analysis joint rate according to claim 1, is characterized in that, in step S3, described table 1 and table 2, when calculating the number of users of commodity purchase, need in advance according to user's unique identification ID Carry out deduplication.

4. the method based on MySql query analysis joint rate according to claim 1, is characterized in that, in step S4, described customer type comprises key customer and common customer, when described key customer outputs joint rate again, normally output all. The joint rate also includes important data in the past 90 days; when ordinary customers output the joint rate, only the joint rate data with a joint rate > 10% or more is output, excluding important data in the past 90 days.

5 . The method for analyzing the joint rate based on MySql query according to claim 1 , wherein the user selects screening, exporting or directly selecting marketing according to the returned result. 6 .