Ultimate access to all questions.
You are planning to deploy a new storage system for your mobile application, which serves as a media streaming service. After evaluating different options, you determine that Google Cloud Datastore is the most suitable solution for your needs. Your application has entities characterized by multiple properties, with some properties capable of taking multiple values. For instance, within the 'Movie' entity, both the 'actors' property and the 'tags' property can hold multiple values, whereas the 'date released' property is singular.
A typical query requirement for your application may include fetching all movies with a specific 'actor' identified as <actorname>
and sorting the results by the 'date_released', or retrieving all movies categorized under the 'Comedy' tag sorted by 'date_released'.
How can you structure your indexing strategy to effectively prevent a combinatorial explosion in the number of indexes when handling these queries?