CN112328600A - Electronic coupon management method - Google Patents
Electronic coupon management method Download PDFInfo
- Publication number
- CN112328600A CN112328600A CN202011281317.9A CN202011281317A CN112328600A CN 112328600 A CN112328600 A CN 112328600A CN 202011281317 A CN202011281317 A CN 202011281317A CN 112328600 A CN112328600 A CN 112328600A
- Authority
- CN
- China
- Prior art keywords
- data table
- electronic
- electronic coupon
- electronic coupons
- sub
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 9
- 238000000034 method Methods 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 6
- 238000012423 maintenance Methods 0.000 abstract description 3
- 238000013523 data management Methods 0.000 abstract description 2
- 230000007547 defect Effects 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000036314 physical performance Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
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
- 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/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0211—Determining the effectiveness of discounts or incentives
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Game Theory and Decision Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an electronic coupon management method, which relates to the technical field of data management, and is characterized in that an unused data table, a used data table and an invalid data table are respectively established for each electronic coupon according to a database sub-table algorithm, and the electronic coupons in the unused data table, the used data table and the invalid data table are regularly updated according to the current time, the use time of each electronic coupon, the validity period of each electronic coupon and the refund time of each electronic coupon, so that the expandability and the query efficiency are improved, and the maintenance is easy.
Description
Technical Field
The invention relates to the technical field of data management, in particular to an electronic coupon management method.
Background
With the development of services, the user population is larger and larger, and the service data generated by the users is also continuously increased. User marketing is often available for user-oriented services throughout various internet industry fields. The most common and common means for marketing by users is to host offers and send electronic coupons. The former is the right that a user who satisfies the condition can enjoy, and the latter is an "asset" of the user itself. Which is a one-to-many scenario for the user. With the expansion of business and the increasing of user groups, the data volume of the electronic coupons is also increasing explosively, and for this situation, how to reasonably manage the electronic coupons becomes important.
At present, the mainstream electronic coupon data storage schemes include single table storage based on the MySQL database and sub-table storage based on the MySQL database. The defects of single table storage based on the MySQL database are as follows: the supportable data volume is limited, and when the data volume is expanded to a trillion level, the scheme can reach the bottleneck of physical performance of the database, so that the optimization is not convenient; the defects of the branch table storage based on the MySQL database are as follows: since the electronic coupons are only divided into valid electronic coupons and invalid electronic coupons, the invalid electronic coupons generally involve little inquiry, but the data volume of the valid electronic coupons is large (the problem of the data volume is analyzed subsequently by the scheme), and therefore, when the valid electronic coupons and the invalid electronic coupons are mixed together and stored, the inquiry efficiency is low.
Disclosure of Invention
In order to solve the defects of the prior art, the embodiment of the invention provides an electronic coupon management method, which comprises the following steps:
respectively creating an unused data table, a used data table and an invalid data table for each electronic coupon according to a database sub-table algorithm, wherein the unused data table stores the electronic coupons which are not used currently and are within the validity period, the used data table stores the electronic coupons which are used already, and the invalid data table stores the electronic coupons which have passed the validity period and are not refunded and the electronic coupons which are refunded;
and updating the electronic coupons in the unused data table, the used data table and the invalid data table at regular time according to the current time, the use time of each electronic coupon, the validity period of each electronic coupon and the refund time of each electronic coupon.
Preferably, the creating the unused data table, the used data table, and the invalid data table for each electronic coupon according to the database sub-table algorithm comprises:
and creating a plurality of sub-tables according to the user identification to obtain an unused data table.
Preferably, the creating the unused data table, the used data table, and the invalid data table for each electronic coupon according to the database sub-table algorithm comprises:
and creating a plurality of sub-tables according to the sequence of the using time of the electronic coupons to obtain a used data table.
Preferably, the creating the unused data table, the used data table, and the invalid data table for each electronic coupon according to the database sub-table algorithm comprises:
and creating a plurality of sub-tables according to the time sequence of the expiration or refund of the electronic coupons to obtain an invalid data table.
Preferably, the number of sub-tables in the used data table is in a set first proportion with the number of users.
Preferably, the number of sub-tables in the used data table is in a set second proportion to the number of issued electronic coupons.
The electronic coupon management method provided by the embodiment of the invention has the following beneficial effects: and respectively creating an unused data table, a used data table and an invalid data table for each electronic coupon by using a database sub-table algorithm, thereby realizing a flexible expansion, easy maintenance and efficient query electronic coupon storage scheme.
Detailed Description
The present invention will be described in detail with reference to the following embodiments.
The electronic coupon management method provided by the embodiment of the invention comprises the following steps:
s101, respectively creating an unused data table, a used data table and an invalid data table for each electronic coupon according to a database table-splitting algorithm, wherein the unused data table stores the electronic coupons which are not used currently and are within the validity period, the used data table stores the electronic coupons which are used already, and the invalid data table stores the electronic coupons which have passed the validity period and are not refunded and the electronic coupons which are refunded;
and S102, updating the electronic coupons in the unused data table, the used data table and the invalid data table at regular time according to the current time, the use time of each electronic coupon, the validity period of each electronic coupon and the refund time of each electronic coupon.
When the electronic coupon in the unused data table is used, deleting the electronic coupon from the unused data table and writing the electronic coupon into the used data table; and when the electronic coupon in the unused data table passes the validity period or refunds, deleting the electronic coupon from the unused data table and writing the electronic coupon into the invalid data table.
Optionally, the creating an unused data table, a used data table, and an invalid data table for each electronic coupon according to a database sorting algorithm includes:
and creating a plurality of sub-tables according to the user identification to obtain an unused data table.
Wherein one sub-table corresponds to one electronic coupon. The electronic coupon issued to the user is first written to the user unused table. Because the unused table is subjected to sub-table processing according to the user identification, the electronic coupons of the same user can fall into a specific data table by combining the user identification, and all the unused electronic coupons of the user are ensured to be finally stored in the data table. The electronic coupons which are not used by the user are inquired according to the dimension of the user, and the inquiry condition necessarily comprises user identification. Therefore, the sub-tables where all the electronic coupons which are not used by the user are located can be inquired through the user identification, and the user can directly inquire through the sub-tables. Because the data amount of the single table after the table division is small, the efficiency is higher no matter the electronic coupon is newly added or inquired.
The electronic coupons not in the used list are hot data, after the list is divided, whether the coupon list is inquired or the available coupon information is inquired during order settlement, the user identification is used for inquiring, the specific sub-list can be directly hit, only one list is inquired, the data is conveniently inquired, and the inquiry efficiency is improved.
Optionally, the creating an unused data table, a used data table, and an invalid data table for each electronic coupon according to a database sorting algorithm includes:
and creating a plurality of sub-tables according to the sequence of the using time of the electronic coupons to obtain a used data table.
As a specific embodiment of the present invention, if the usage time of the electronic coupon is 7/6/2020, the corresponding sub-table name of the electronic coupon is coupon _ 202007.
Optionally, the creating an unused data table, a used data table, and an invalid data table for each electronic coupon according to a database sorting algorithm includes:
and creating a plurality of sub-tables according to the time sequence of the expiration or refund of the electronic coupons to obtain an invalid data table.
The data amount in the invalid data table is the largest and is also cold data relative to the unused data table and the used data table. Recently expired electronic coupons may be related to a query operation, and electronic coupons that are expired for a long time are not typically related to a query operation.
Optionally, the number of sub-tables in the used data table is in a set first proportion to the number of users.
As a specific example, according to historical data analysis, the ratio of the number of the unused coupons to the number of the users is about 1:2, so that the number of the tables of the unused data table is 50% of the number of the tables of the user data.
Optionally, the number of sub-tables in the used data table is in a set second proportion to the number of issued electronic coupons.
As a specific example, based on historical data analysis, for every 10 coupons issued, approximately 1 coupon is eventually used, i.e., the second ratio is 1: 10.
According to the electronic coupon management method provided by the embodiment of the invention, the unused data table, the used data table and the invalid data table are respectively created for each electronic coupon according to the database sub-table algorithm, and the electronic coupons in the unused data table, the used data table and the invalid data table are regularly updated according to the current time, the use time of each electronic coupon, the validity period of each electronic coupon and the refund time of each electronic coupon, so that the expandability and the query efficiency are improved, and the maintenance is easy.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (8)
1. An electronic coupon management method, comprising:
respectively creating an unused data table, a used data table and an invalid data table for each electronic coupon according to a database sub-table algorithm, wherein the unused data table stores the electronic coupons which are not used currently and are within the validity period, the used data table stores the electronic coupons which are used already, and the invalid data table stores the electronic coupons which have passed the validity period and are not refunded and the electronic coupons which are refunded;
and updating the electronic coupons in the unused data table, the used data table and the invalid data table at regular time according to the current time, the use time of each electronic coupon, the validity period of each electronic coupon and the refund time of each electronic coupon.
2. The method of managing electronic coupons according to claim 1 wherein creating an unused data table, a used data table, and an invalid data table for each electronic coupon, respectively, according to a database-to-table algorithm comprises:
and creating a plurality of sub-tables according to the user identification to obtain an unused data table.
3. The method of managing electronic coupons according to claim 1 wherein creating an unused data table, a used data table, and an invalid data table for each electronic coupon, respectively, according to a database-to-table algorithm comprises:
and creating a plurality of sub-tables according to the sequence of the using time of the electronic coupons to obtain a used data table.
4. The method of managing electronic coupons according to claim 1 wherein creating an unused data table, a used data table, and an invalid data table for each electronic coupon, respectively, according to a database-to-table algorithm comprises:
and creating a plurality of sub-tables according to the time sequence of the expiration or refund of the electronic coupons to obtain an invalid data table.
5. The method of claim 1, wherein the number of sub-tables in the used data table is a set first ratio to the number of users.
6. The method for managing electronic coupons according to claim 1 wherein the number of sub-tables in said used data table is in a set second ratio to the number of electronic coupons issued.
7. A computer program product, characterized in that the computer program product comprises a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions that, when executed by a computer, cause the computer to perform the method of claims 1-4.
8. A non-transitory computer-readable storage medium storing computer instructions that cause a computer to perform the method of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011281317.9A CN112328600A (en) | 2020-11-16 | 2020-11-16 | Electronic coupon management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011281317.9A CN112328600A (en) | 2020-11-16 | 2020-11-16 | Electronic coupon management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112328600A true CN112328600A (en) | 2021-02-05 |
Family
ID=74317825
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011281317.9A Pending CN112328600A (en) | 2020-11-16 | 2020-11-16 | Electronic coupon management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112328600A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113205173A (en) * | 2021-05-28 | 2021-08-03 | 中国工商银行股份有限公司 | Electronic ticket selection method and device |
| CN113935770A (en) * | 2021-10-11 | 2022-01-14 | 贵州众酒联酒业科技有限公司 | Public bank consumption feedback system based on internet |
| CN117611249A (en) * | 2024-01-16 | 2024-02-27 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567428A (en) * | 2010-12-30 | 2012-07-11 | 中国移动通信集团浙江有限公司 | Method and device for managing life cycle of online data |
| CN106022812A (en) * | 2015-11-06 | 2016-10-12 | 刘翔英 | Discount coupon electronized issuing, use and transaction method |
| CN108062314A (en) * | 2016-11-07 | 2018-05-22 | 北京京东尚科信息技术有限公司 | Dynamic divides table data processing method and device |
| CN109582682A (en) * | 2018-11-02 | 2019-04-05 | 中国平安人寿保险股份有限公司 | Data processing method, device and storage medium, computer equipment |
| CN110363515A (en) * | 2019-06-05 | 2019-10-22 | 阿里巴巴集团控股有限公司 | Equity card account information querying method, system, server and readable storage medium storing program for executing |
-
2020
- 2020-11-16 CN CN202011281317.9A patent/CN112328600A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567428A (en) * | 2010-12-30 | 2012-07-11 | 中国移动通信集团浙江有限公司 | Method and device for managing life cycle of online data |
| CN106022812A (en) * | 2015-11-06 | 2016-10-12 | 刘翔英 | Discount coupon electronized issuing, use and transaction method |
| CN108062314A (en) * | 2016-11-07 | 2018-05-22 | 北京京东尚科信息技术有限公司 | Dynamic divides table data processing method and device |
| CN109582682A (en) * | 2018-11-02 | 2019-04-05 | 中国平安人寿保险股份有限公司 | Data processing method, device and storage medium, computer equipment |
| CN110363515A (en) * | 2019-06-05 | 2019-10-22 | 阿里巴巴集团控股有限公司 | Equity card account information querying method, system, server and readable storage medium storing program for executing |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113205173A (en) * | 2021-05-28 | 2021-08-03 | 中国工商银行股份有限公司 | Electronic ticket selection method and device |
| CN113935770A (en) * | 2021-10-11 | 2022-01-14 | 贵州众酒联酒业科技有限公司 | Public bank consumption feedback system based on internet |
| CN117611249A (en) * | 2024-01-16 | 2024-02-27 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
| CN117611249B (en) * | 2024-01-16 | 2024-04-16 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112328600A (en) | Electronic coupon management method | |
| JP5598017B2 (en) | Judgment program, method and apparatus | |
| CN105550270B (en) | Data base query method and device | |
| CN103748579A (en) | Processing data in a mapreduce framework | |
| CN104536965B (en) | A kind of data query display systems under the conditions of big data and method | |
| CN103516591A (en) | Method and device for achieving enterprise address list in instant communication platform | |
| CN102725753A (en) | Method and apparatus for optimizing data access, method and apparatus for optimizing data storage | |
| AU2006330838A1 (en) | Method and system for providing enhanced matching from customer driven queries | |
| CN106933891A (en) | Access the method for distributed data base and the device of Distributed database service | |
| US7266539B2 (en) | Managing attributed-tagged index entries | |
| US20090030880A1 (en) | Model-Based Analysis | |
| CN106933836A (en) | A kind of date storage method and system based on point table | |
| CN102799651B (en) | Query processing device and method | |
| US7725495B2 (en) | Implementing referential integrity in a database hosting service | |
| EP2662783A1 (en) | Data archiving approach leveraging database layer functionality | |
| CN105978744A (en) | Resource allocation method, device and system | |
| CN101739523B (en) | Data permission control method and device | |
| US20030050886A1 (en) | Method and apparatus for managing the versioning of business objects using a state machine | |
| CN104463460A (en) | Method and device for processing scheduling information for network data delivery | |
| CN101751423A (en) | Article duplicate checking method and system | |
| CN111709769A (en) | Data processing method and device | |
| US20170270559A1 (en) | Server-Side Automated Shopping List Management, Intelligent Coupon Generation and Coupon-Influenced Product Selection | |
| WO2017124991A1 (en) | Media information publishing method, system and computer storage medium | |
| US20090327093A1 (en) | Satisfying rules through a configuration of list processing methods | |
| CN113763069A (en) | Method, device and equipment for generating article information display page and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210205 |
|
| RJ01 | Rejection of invention patent application after publication |