CN114490635A - Push processing method capable of controlling speed in real time based on message push - Google Patents
Push processing method capable of controlling speed in real time based on message push Download PDFInfo
- Publication number
- CN114490635A CN114490635A CN202111614799.XA CN202111614799A CN114490635A CN 114490635 A CN114490635 A CN 114490635A CN 202111614799 A CN202111614799 A CN 202111614799A CN 114490635 A CN114490635 A CN 114490635A
- Authority
- CN
- China
- Prior art keywords
- message
- database
- serial number
- push
- pushing
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 19
- 238000000605 extraction Methods 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 9
- 230000006399 behavior Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000011144 upstream manufacturing Methods 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/2291—User-Defined Types; Storage 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to the technical field of message pushing, in particular to a pushing processing method capable of controlling speed in real time based on message pushing; taking the serial number of the message sending entity as an index of a relational database, and establishing a message sending database and a message receipt database; performing message matching according to the serial number and the keywords of the relational database, extracting database information, and acquiring entity data of a message sender; forwarding the corresponding message according to the entity data; configuring MYSQL keywords in a relational database into controllable parameters, and carrying out message pushing rate; compared with the traditional message pushing method, the method increases rate control, is not limited to message pushing according to the processing result of a third party, is safer, can not cause message loss due to system restarting, and can control the number of pushed messages in real time.
Description
Technical Field
The invention relates to the technical field of message pushing, in particular to a pushing processing method capable of controlling speed in real time based on message pushing.
Background
The cloud push assistant 5g needs to perform message notification for a specific user according to the requirement of the partner, and needs to acquire the result of the message notification to the user in real time and perform operation of the upstream and downstream services.
The traditional message pushing processing method has higher requirement on the processing speed of the system, processes in a multi-memory mode, and has very high limits on data security and the processing speed of the system.
Disclosure of Invention
The invention aims to provide a message pushing-based push processing method capable of controlling the speed in real time, and aims to solve the technical problems that the message pushing processing method in the prior art has high requirements on the processing speed of a system, processes the system in a multi-memory mode, and has high limits on data security and the processing speed of the system.
In order to achieve the above object, the present invention provides a push processing method capable of controlling a rate in real time based on message push, which includes the following steps: taking the serial number of the message sending entity as an index of a relational database, and establishing a message sending database and a message receipt database;
performing message matching according to the serial number of the relational database and the MYSQL keyword, extracting database information, and acquiring entity data of a message sender;
forwarding processing of corresponding messages is carried out according to the entity data, and message pushing is completed;
and configuring MYSQL keywords in the relational database into controllable parameters, and performing rate control of message pushing.
Wherein, in the step of establishing the message sending database and the message receipt database by using the serial number of the message sending entity as the index of the relational database:
each message sending entity corresponds to a serial number, the serial number is an msg _ id field and is set as a relational database index, receipt information of each message sending entity corresponds to a serial number, and the receipt information is the same as the serial number of the corresponding message sending entity.
Wherein, in the step of establishing the message sending database and the message receipt database by using the serial number of the message sending entity as the index of the relational database:
the message sending database stores entity data of each message sending entity, the entity data comprise specific information of a sender, a push address and a forwarding interface, and the sent information and receipt information are respectively stored in the message sending database and the message receipt database and are associated through corresponding serial numbers.
The method comprises the following steps of performing message matching according to the serial number of the relational database and MYSQL keywords, extracting database information and obtaining entity data of a message sender:
and the format of the MYSQL keyword is LEFT JOIN, the number of messages is matched by using a serial number msg _ id and the MYSQL keyword through a matching module, and entity data is extracted.
Wherein, in the step of forwarding the corresponding message according to the entity data and completing message pushing:
and finishing the forwarding processing of the corresponding message according to the pushing address or the forwarding interface in the entity data. The method comprises the following steps of configuring MYSQL keywords in a relational database into controllable parameters, and performing message pushing rate control:
setting a timer to extract messages once every 1S, asynchronously processing the content of message extraction, configuring the key word LIMIT SIZE taken from the database as a controllable parameter, realizing the rate control, and achieving the real-time rate control according to the specific sending quantity.
The invention relates to a pushing processing method capable of controlling the speed in real time based on message pushing, which takes the serial number of a message sending entity as the index of a relational database, and establishes a message sending database and a message receipt database; performing message matching according to the serial number of the relational database and the MYSQL keyword, extracting database information, and acquiring entity data of a message sender; forwarding processing of corresponding messages is carried out according to the entity data, and message pushing is completed; configuring MYSQL keywords in a relational database into controllable parameters, and carrying out message pushing rate; compared with the traditional message pushing, the method increases rate control, is not limited to message pushing according to the processing result of a third party any more, is safer relative to a memory, does not lose messages due to the restarting of a system, and can control the number of pushed messages in real time.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic block diagram of a push processing method capable of controlling a rate in real time based on message push according to the present invention.
Fig. 2 is a flowchart of steps of a push processing method capable of controlling a rate in real time based on message pushing according to the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
Referring to fig. 1 and fig. 2, the present invention provides a push processing method capable of controlling a rate in real time based on message pushing, including the following steps:
s1: taking the serial number of the message sending entity as an index of a relational database, and establishing a message sending database and a message receipt database;
s2: performing message matching according to the serial number of the relational database and the MYSQL keyword, extracting database information, and acquiring entity data of a message sender;
s3: forwarding processing of corresponding messages is carried out according to the entity data, and message pushing is completed;
s4: and configuring MYSQL keywords in the relational database into controllable parameters, and performing rate control of message pushing.
In step S1, each sending message entity corresponds to a serial number, the serial number is an msg _ id field, and is set as a relational database index, the receipt information of each sending message entity corresponds to a serial number, and the receipt information is the same as the serial number of the corresponding sending message entity; the message sending database stores entity data of each message sending entity, the entity data comprise specific information of a sender, a push address and a forwarding interface, and the sent information and receipt information are respectively stored in the message sending database and the message receipt database and are associated through corresponding serial numbers.
In step S2, the MYSQL keyword is in LEFT JOIN format, and the number of messages is matched by using the serial number msg _ id and the MYSQL keyword through a matching module to extract entity data; the matching module extracts by:
SELECT AFROM
TABLE_REPORT REPORT LEFT JOIN TABLE_SEND SEND ON REPORT.MSG_ID＝SEND.MSG_ID
LIMIT SIZE；
and according to the database message extracted by the matching module, entity message correspondence is carried out, and the specific information, the push address and the like of the sender are obtained according to each attribute information of the message sending entity.
In step S3, a corresponding message forwarding process is performed according to the information of the sender in the message sending entity, such as a message push address or a message forwarding interface and other related forwarding channels; the specific information of the sender comprises geographic data, user data and behavior data of the sender, the user data comprises a name, the age of a user, the communication number of the user, the height of the user and the weight of the user, the behavior data comprises behavior data, targeted pushing is carried out according to the specific information of the sender, and pushing efficiency is improved.
In step S4, setting a timer to extract messages every 1S, asynchronously processing the content of message extraction, configuring the key word LIMIT SIZE fetched from the database as a controllable parameter, implementing rate control, and achieving real-time rate control according to the specific sending amount; in the conventional message forwarding processing, a message forwarding entity is stored in a cache during sending, and after message receipt, memory message matching is performed according to msg _ id, so that the sent message entity is inquired and forwarded. Compared with the traditional processing method, the method increases rate control, is not limited to message pushing according to the processing result of a third party, is safer relative to a memory, can not lose messages due to the restart of a system, and can control the number of pushed messages in real time.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (6)
1. A push processing method capable of controlling speed in real time based on message push is characterized by comprising the following steps:
taking the serial number of the message sending entity as an index of a relational database, and establishing a message sending database and a message receipt database;
performing message matching according to the serial number of the relational database and the MYSQL keyword, extracting database information, and acquiring entity data of a message sender;
forwarding processing of corresponding messages is carried out according to the entity data, and message pushing is completed;
and configuring MYSQL keywords in the relational database into controllable parameters, and performing rate control of message pushing.
2. The push processing method capable of controlling the rate in real time based on message push as claimed in claim 1, wherein in the step of establishing the message sending database and the message receipt database by using the serial number of the sending message entity as the index of the relational database:
each message sending entity corresponds to a serial number, the serial number is an msg _ id field and is set as a relational database index, receipt information of each message sending entity corresponds to a serial number, and the receipt information is the same as the serial number of the corresponding message sending entity.
3. The push processing method capable of controlling the rate in real time based on message push as claimed in claim 2, wherein in the step of establishing the message sending database and the message receipt database by using the serial number of the sending message entity as the index of the relational database:
the message sending database stores entity data of each message sending entity, the entity data comprise specific information of a sender, a push address and a forwarding interface, and the sent information and receipt information are respectively stored in the message sending database and the message receipt database and are associated through corresponding serial numbers.
4. The push processing method based on message push and capable of controlling rate in real time as claimed in claim 3, wherein in the step of performing message matching according to the serial number of the relational database and the MYSQL keyword, extracting database information, and obtaining entity data of the message sender:
the format of the MYSQL keyword is LEFT JOIN, the number of messages is matched through a matching module by using a serial number msg _ id and the MYSQL keyword, and entity data is extracted.
5. The push processing method capable of controlling the rate in real time based on message pushing as claimed in claim 4, wherein in the step of performing the forwarding processing of the corresponding message according to the entity data and completing the message pushing:
and finishing the forwarding processing of the corresponding message according to the pushing address or the forwarding interface in the entity data.
6. The push processing method capable of controlling the rate in real time based on message pushing according to claim 5, wherein in the step of configuring MYSQL keywords in the relational database as controllable parameters to perform the rate control of message pushing:
setting a timer to extract messages once every 1S, asynchronously processing the content of message extraction, configuring the key word LIMIT SIZE taken from the database as a controllable parameter, realizing the rate control, and achieving the real-time rate control according to the specific sending quantity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111614799.XA CN114490635A (en) | 2021-12-27 | 2021-12-27 | Push processing method capable of controlling speed in real time based on message push |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111614799.XA CN114490635A (en) | 2021-12-27 | 2021-12-27 | Push processing method capable of controlling speed in real time based on message push |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114490635A true CN114490635A (en) | 2022-05-13 |
Family
ID=81495609
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111614799.XA Pending CN114490635A (en) | 2021-12-27 | 2021-12-27 | Push processing method capable of controlling speed in real time based on message push |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114490635A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160308796A1 (en) * | 2013-12-06 | 2016-10-20 | Tencent Technology (Shenzhen) Company Limited | Instant messaging system and method |
| CN106713124A (en) * | 2017-01-24 | 2017-05-24 | 深圳市启仑智能科技有限公司 | Message push method and system based on MQTT and MYSQL |
| WO2017196244A1 (en) * | 2016-05-13 | 2017-11-16 | Telefonaktiebolaget Lm Ericsson (Publ) | User equipment procedures to control uplink beamforming |
| CN109445965A (en) * | 2018-11-07 | 2019-03-08 | 北京明朝万达科技股份有限公司 | By the Redis and MySQL message treatment method realized and equipment |
| CN110290049A (en) * | 2019-05-20 | 2019-09-27 | 深圳壹账通智能科技有限公司 | Information push method, server and computer readable storage medium |
-
2021
- 2021-12-27 CN CN202111614799.XA patent/CN114490635A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160308796A1 (en) * | 2013-12-06 | 2016-10-20 | Tencent Technology (Shenzhen) Company Limited | Instant messaging system and method |
| WO2017196244A1 (en) * | 2016-05-13 | 2017-11-16 | Telefonaktiebolaget Lm Ericsson (Publ) | User equipment procedures to control uplink beamforming |
| CN106713124A (en) * | 2017-01-24 | 2017-05-24 | 深圳市启仑智能科技有限公司 | Message push method and system based on MQTT and MYSQL |
| CN109445965A (en) * | 2018-11-07 | 2019-03-08 | 北京明朝万达科技股份有限公司 | By the Redis and MySQL message treatment method realized and equipment |
| CN110290049A (en) * | 2019-05-20 | 2019-09-27 | 深圳壹账通智能科技有限公司 | Information push method, server and computer readable storage medium |
Non-Patent Citations (2)
| Title |
|---|
| PAN_JUNBIAO: "MySQL使用Limit关键字限制查询结果的数量", Retrieved from the Internet <URL:https://blog.csdn.net/pan_junbiao/article/details/85930892> * |
| 许高山，江志军，兰剑，李延保编；张光义总主编: "面向新工科5G移动通信十三五规划教材 分组传送技术", vol. 2021, 28 February 2021, 北京：中国铁道出版社, pages: 32 - 44 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11258737B2 (en) | Instant messaging method, apparatus and system based on email system | |
| US11196784B2 (en) | Method, apparatus and system for creating discussion group based on instant messaging | |
| CN100586112C (en) | Method for establishing contact list and managing contact information in instant communication | |
| JP2014531660A (en) | Method, apparatus and storage medium for adding friends in a social network | |
| CN102611637A (en) | Group realization method and system | |
| CN106059892A (en) | Message engine integrated with communication system | |
| CN104077341A (en) | Keyword auto-response mapping relation generation method and device in instant messaging | |
| US20090088198A1 (en) | Message processing method, ssmn processor and message service center | |
| CN103501374A (en) | Telephone book sequencing method and device as well as terminal | |
| CN102769640B (en) | The update method of user profile, server and system | |
| WO2020011043A1 (en) | Method, device and system for acquiring logistics object distribution information | |
| CN105354020A (en) | Json format data analytic method and data receiving end | |
| WO2013016993A1 (en) | Search method, system and device | |
| CN103533169A (en) | Method for positioning and linking field of electronic business card based on mobile terminal | |
| CN103369479A (en) | Information generation method and mobile terminal | |
| CN108768835B (en) | Mail analysis method, device, server and storage medium | |
| CN112929257B (en) | Multi-scene message sending method, device, server and storage medium | |
| CN104050204A (en) | Method of combining network data and mobile device using the same | |
| CN114490635A (en) | Push processing method capable of controlling speed in real time based on message push | |
| CN105120046A (en) | Method and device for creating address book according to note information of new number | |
| CN114390452B (en) | Message sending method and related equipment | |
| WO2015180306A1 (en) | Method and device for querying instant message, and computer storage medium | |
| CN111211967B (en) | Group member notification method and device | |
| CN113988954A (en) | Financing product marketing method and device | |
| CN107104889A (en) | A kind of rough draft mail synchronization method, device and terminal based on IMAP protocol |
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 |