Systems and method of generating custom messages based on rule-based database queries in a cloud platform

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• storing, at a cloud storage location, a collection of audio files;
• storing, at the cloud storage location, a first type of destination information identifying one or more locations of venues where are announcements are rendered;
• storing, at the cloud storage location, a second type of destination information identifying location information corresponding to a plurality of different geographic locations where a plurality of edge devices are located, wherein the location information identifies areas within the one more locations of the venues;
• receiving a message from a first requesting device of a plurality of requesting devices, the message including a plurality of fields of information;
• retrieving information stored in the cloud storage location based on the information included in the plurality of fields, the retrieved information including second type of information corresponding to a first edge device;
• generating an action list based on the retrieved information;
• determining an available time slot at a first geographic location of the first edge device when the first edge device is available to render an announcement based on an announcement schedule for the first edge device at the first geographic location stored in a cache;
• updating an action list based on the determined available time slot;
• retrieving an audio file from the collection of audio files based on the second type of information;
• negotiating a channel with an audio controller and the first device;
• generating a channel identifier corresponding to the channel;
• providing channel identifier to the first requesting device;
• transmitting notification to the audio controller that a subscription has been established to the channel;
• transmitting a compressed bit array to first edge device using the channel, a compressed array including the audio file and the updated action list, wherein the first edge device is to render an announcement at the determined available time slot based on the information in the updated action list;
• and
• terminating the channel after the compressed bit array is transmitted.

A system comprising:

• at least one hardware processor;
• and
• at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
• storing, at a cloud storage location, a collection of audio files;
• storing, at the cloud storage location, a first type of destination information identifying one or more locations of venues where are announcements are rendered;
• storing, at the cloud storage location, a second type of destination information identifying location information corresponding to a plurality of different geographic locations where a plurality of edge devices are located, wherein the location information identifies areas within the one more locations of the venues;
• receiving a message from a first requesting device of a plurality of requesting devices, the message including a plurality of fields of information;
• retrieving information stored in the cloud storage location based on the information included in the plurality of fields, the retrieved information including second type of information corresponding to a first edge device;
• generating an action list based on the retrieved information;
• determining an available time slot at a first geographic location of the first edge device when the first edge device is available to render an announcement based on an announcement schedule for the first edge device at the first geographic location stored in a cache;
• updating an action list based on the determined available time slot;
• retrieving an audio file from the collection of audio files based on the second type of information;
• negotiating a channel with an audio controller and the first device;
• generating a channel identifier corresponding to the channel;
• providing channel identifier to the first requesting device;
• transmitting notification to the audio controller that a subscription has been established to the channel;
• transmitting a compressed bit array to first edge device using the channel, a compressed array including the audio file and the updated action list, wherein the first edge device is to render an announcement at the determined available time slot based on the information in the updated action list;
• and
• terminating the channel after the compressed bit array is transmitted.