Data storage architecture for an enterprise communication system

A computer program product for managing a group-based storage system accessible via a plurality of client devices, the computer program product comprising at least one non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions comprising an executable portion, wherein when executed by a processor the executable portion causes the processor to:

• shard a plurality of databases defined by discrete physical database storage devices into a plurality of data shards comprising:
• channel-specific shards each having an associated channel identifier;
• group-specific shards each having an associated group identifier;
• and
• user-specific shards each having an associated user identifier;
• wherein sharding the plurality of discrete physical database storage devices comprises:
• receiving a channel creation request from a client device associated with a given user identifier;
• generating a new channel-specific shard within one of the plurality of discrete physical database storage devices corresponding to the channel creation request;
• populating the new channel-specific shard with linking data linking the new channel-specific shard with one or more linked group-specific shards of the one or more group-specific shards and one or more linked user-specific shards of the one or more user-specific shards;
• and
• populating the one or more linked group-specific shards and the one or more linked user-specific shards with data identifying the new shard;
• correlate each channel identifier with one or more group identifiers;
• and
• control access to each of the plurality of channel-specific shards based at least in part on linking data associated with each channel-specific shard, channel membership, and group membership by:
• receiving an access request from the client device to access data stored on one or more channel-specific shards;
• determining channel membership and group membership for the client device;
• providing the client device with access to data stored in one or more channel-specific shards having associated channel identifiers and group identifiers matching the determined channel membership and group membership for the client device.

A group-based data storage system accessible by a plurality of client devices, the group-based data storage system comprising:

• a plurality of discrete physical database storage devices each defining a database, wherein each of the plurality of discrete physical database storage devices encompass at least one non-transitory computer-readable storage medium, and wherein each database is sharded into a plurality of data shards collectively comprising:
• a plurality of channel shards each having an associated channel identifier of a plurality of channel identifiers and each storing data exchanged between client devices in association with the channel identifier and each storing channel settings in association with a corresponding channel identifier and identifying one or more group identifiers associated with the corresponding channel identifier;
• a plurality of group shards each corresponding to a single group identifier, wherein each group shard of the plurality of group shards stores data indicative of channel creation authorization for new channels associated with the group shard and stores group policies for the single group identifier;
• and
• a plurality of user shards each having an associated user identifier of a plurality of user identifiers and each user shard identifying channel membership and group membership for the associated user identifier;
• and
• a remote computing platform comprising at least a processor and a memory having computer coded instructions therein, and wherein, when executed by the processor, the computer coded instructions cause the processor to:
• control channel creation authorization for new channel shards requested by a client device associated with a particular user identifier of the plurality of user identifiers based at least in part on a group shard of the plurality of group shards corresponding with the particular user identifier;
• and
• maintain compliance of channel settings associated with new channels relative to group policies associated with group identifiers that are associated with corresponding channel identifiers.

A computer program product for managing a group-based storage system accessible via a plurality of client devices, the computer program product comprising at least one non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions comprising an executable portion, wherein when executed by a processor the executable portion causes the processor to:

• shard a plurality of databases defined by discrete physical database storage devices into a plurality of data shards comprising:
• a plurality of channel shards each having an associated channel identifier of a plurality of channel identifiers and each storing data exchanged between client devices in association with the channel identifier and each storing channel settings in association with a corresponding channel identifier and identifying one or more group identifiers associated with the corresponding channel identifier;
• a plurality of group shards each corresponding to a single group identifier, wherein each group shard of the plurality of group shards stores data indicative of channel creation authorization for new channels associated with the group shard and stores group policies for the single group identifier;
• and
• a plurality of user shards each having an associated user identifier of a plurality of user identifiers and each user shard identifying channel membership and group membership for the associated user identifier;
• control channel creation authorization for new channel shards requested by a client device associated with a particular user identifier of the plurality of user identifiers based at least in part on a group shard of the plurality of group shards corresponding with the particular user identifier;
• and
• maintain compliance of channel settings associated with new channels relative to group policies associated with group identifiers that are associated with corresponding channel identifiers.