Major Description
Currently, tag-definitions, tags and service-resources are stored in database using a normalized form. When constructing resource->tag mappings, this schema design may lead to a large number of database accesses, thereby causing a major performance bottleneck when the number of resource->tag associations is large.
Denormalized schema will reduce the number of database accesses, and improve overall performance significantly.