An enhanced database system and method for media production and distribution enables the aggregation of assets using external unique IDs. The use of the external IDs allows the searching of Media Asset Management database to be performed without any prior knowledge of the actual database. The search configuration defines a set of search environment parameters that are imported into the search database during a configuration stage and which are used by the search services to provide client applications with an interface to create, validate, and execute queries.