CN113821515A - Method for inquiring and analyzing linkage rate based on MySql - Google Patents
Method for inquiring and analyzing linkage rate based on MySql Download PDFInfo
- Publication number
- CN113821515A CN113821515A CN202111130324.3A CN202111130324A CN113821515A CN 113821515 A CN113821515 A CN 113821515A CN 202111130324 A CN202111130324 A CN 202111130324A CN 113821515 A CN113821515 A CN 113821515A
- Authority
- CN
- China
- Prior art keywords
- mysql
- user
- task
- linkage
- rate
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 15
- 238000012216 screening Methods 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000002349 favourable effect Effects 0.000 description 2
- 238000010030 laminating Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
Abstract
The invention discloses a method for inquiring and analyzing linkage rate based on MySql, which comprises the steps that a user enters a linkage rate analysis page, selects or inputs order data parameters to be inquired and submits a custom task; receiving order data parameters of the custom task, transmitting the parameters to a background, and then executing the custom task by MySql; the MySql executes a user-defined task, and after the MySql executes the user-defined task, the table for obtaining the result of calculating the linkage rate is stored in 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. According to the invention, 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; the system helps merchants to reasonably market commodities and improve sales volume.
Description
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 (5)
1. A method for analyzing linkage rate based on MySql query is characterized by comprising 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.
2. The method of claim 1, wherein the order data parameters to be queried include input parameters, time range, commodity to be analyzed, commodity order data, linkage rate range, recommendable people number range, and expected success people number range.
3. The method of claim 1, wherein in step S3, when the number of users purchasing commodities is calculated in table 1 and table 2, the duplication removal needs to be performed in advance according to the unique ID of the user.
4. The method according to claim 1, wherein in step S4, the client types include important clients and normal clients, and when the important clients output the connection rate again, all the connection rates are normally output and contain important data in about 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.
5. The method for MySql-based query analysis linkage rate according to claim 1, wherein the user selects screening, exporting or directly selecting marketing according to the returned results.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111130324.3A CN113821515A (en) | 2021-09-26 | 2021-09-26 | Method for inquiring and analyzing linkage rate based on MySql |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111130324.3A CN113821515A (en) | 2021-09-26 | 2021-09-26 | Method for inquiring and analyzing linkage rate based on MySql |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113821515A true CN113821515A (en) | 2021-12-21 |
Family
ID=78921416
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111130324.3A Pending CN113821515A (en) | 2021-09-26 | 2021-09-26 | Method for inquiring and analyzing linkage rate based on MySql |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113821515A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7080070B1 (en) * | 1999-07-02 | 2006-07-18 | Amazon Technologies, Inc. | System and methods for browsing a database of items and conducting associated transactions |
| CN109376192A (en) * | 2018-09-20 | 2019-02-22 | 北京空中信使信息技术有限公司 | A kind of user retains analysis method, device, electronic equipment and storage medium |
| CN110069335A (en) * | 2019-05-07 | 2019-07-30 | 江苏满运软件科技有限公司 | Task processing system, method, computer equipment and storage medium |
| CN110457023A (en) * | 2019-07-23 | 2019-11-15 | 东软集团股份有限公司 | Task creation method, apparatus, storage medium and electronic equipment |
| CN111258819A (en) * | 2020-01-22 | 2020-06-09 | 山东新北洋信息技术股份有限公司 | Data acquisition method, device and system for MySQL database backup file |
| CN112699647A (en) * | 2020-12-31 | 2021-04-23 | 杭州立思辰安科科技有限公司 | Implementation method for supporting custom report |
-
2021
- 2021-09-26 CN CN202111130324.3A patent/CN113821515A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7080070B1 (en) * | 1999-07-02 | 2006-07-18 | Amazon Technologies, Inc. | System and methods for browsing a database of items and conducting associated transactions |
| CN109376192A (en) * | 2018-09-20 | 2019-02-22 | 北京空中信使信息技术有限公司 | A kind of user retains analysis method, device, electronic equipment and storage medium |
| CN110069335A (en) * | 2019-05-07 | 2019-07-30 | 江苏满运软件科技有限公司 | Task processing system, method, computer equipment and storage medium |
| CN110457023A (en) * | 2019-07-23 | 2019-11-15 | 东软集团股份有限公司 | Task creation method, apparatus, storage medium and electronic equipment |
| CN111258819A (en) * | 2020-01-22 | 2020-06-09 | 山东新北洋信息技术股份有限公司 | Data acquisition method, device and system for MySQL database backup file |
| CN112699647A (en) * | 2020-12-31 | 2021-04-23 | 杭州立思辰安科科技有限公司 | Implementation method for supporting custom report |
Non-Patent Citations (1)
| Title |
|---|
| 沈小鱼: "什么是联单率，零售电商行业的联单率一般在多少？", pages 1, Retrieved from the Internet <URL:https://www.zhihu.com/question/21823750> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Fishman | The Wal-Mart you don't know | |
| CN112837118B (en) | Commodity recommendation method and device for enterprise users | |
| CN108182575A (en) | A kind of realization system and method for the multi-party income real time settlement of internet electric business | |
| CN106445905B (en) | Question and answer data processing, automatic question-answering method and device | |
| CN105184600A (en) | Rule and operation-based electronic business platform price engine implementing method | |
| CN106156972B (en) | Logistics service information providing method and device | |
| CN107025531A (en) | Address modification information processing method and processing device | |
| CN110347924A (en) | Fruits and vegetables market management system and fruit-vegetable information method for pushing | |
| CN107146122B (en) | Data processing method and device | |
| US20070156566A1 (en) | System and method for seller and item filters | |
| CN105528725A (en) | Account product transaction processing method and system and transaction server | |
| CN110084643A (en) | A kind of merchandise valuation method and device based on historical trading distribution | |
| CN103577999A (en) | Online shopping mall system | |
| JPH1091684A (en) | Article display method for on-line shopping | |
| CN113763125A (en) | Method and device for generating purchase order about purchased goods | |
| CN110648188A (en) | Cross-border trade BPO service recommendation system based on user preference | |
| WO1999026173A1 (en) | A configurable electronic trading system and the method therefor | |
| CN113821515A (en) | Method for inquiring and analyzing linkage rate based on MySql | |
| CN112507202A (en) | Method and system for multi-mall distribution and commodity search | |
| CN110866220A (en) | Selection recommendation system in e-commerce activity process | |
| CN110097425A (en) | A kind of shops's management system | |
| CN114219589A (en) | Virtual entity object generation and page display method and device and electronic equipment | |
| CN114186024A (en) | Recommendation method and device | |
| CN111429195A (en) | Method and system for realizing scenic e-commerce system | |
| CN108460650A (en) | A kind of online commodity trading system design based on C/S and B/S patterns |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |