Enhanced database scheme to support advanced media production and distribution

1. A method comprising:

receiving a user search query;

synchronizing, via at least one processor, search results from at least two data sources in response to the user search query, the data sources comprising a central database comprising an asset table for a plurality of external databases storing media assets, and at least one of a file repository and another site, wherein an asset comprises an aggregation of information regarding a media essence;

establishing a search configuration in response to the user search query

aggregating the synchronized search results from the at least two data sources, said aggregating including assigning an identifier for each application corresponding to a respective asset; and

presenting the aggregated search results to the user as one search result.

2. The method according to claim 1 , wherein said aggregating further comprises:

forming an asset table in a database by encapsulating the assigned identifier for each application.

3. The method according to claim 1 , wherein said establishing comprises defining search environment parameters involved in the search.

4. The method according to claim 3 , further comprising importing the search environment parameters into a search database during configuration of the search in response to the search query to provide client applications an interface to create, validate and execute the search query.

5. The method according to claim 3 , wherein said defining comprises identifying metadata descriptions associated with each asset, wherein the user search query is dynamically created for a database using the metadata description during the establishing of the search configuration.

6. The method according to claim 2 , wherein the forming further comprises establishing a virtual asset address within the database using the identifier.

7. An apparatus comprising:

means for synchronizing search results from at least two data sources in response to a user search query, the data sources comprising a central database comprising an asset table for a plurality of external databases storing media assets, and at least one of a file repository and another site, wherein an asset comprises an aggregation of information regarding a media essence;

means for establishing a search configuration in response to the user search query

means for aggregating the synchronized search results from the at least two data sources, said aggregating including assigning an identifier for each application corresponding to a respective asset; and

means for presenting the aggregated search results to the user as one search result.

8. The apparatus according to claim 7 , wherein a synchronization service manages linkage of data in the plurality of external databases to the central database.

9. The apparatus according to claim 8 , wherein the plurality of databases store related assets.

10. The apparatus according to claim 9 , wherein the related assets comprise different metadata.

11. The apparatus according to claim 10 , wherein one of the plurality of databases stores a first asset comprising a first media essence, and wherein a second of the plurality of databases stores a second asset related to the first asset and rights management information related to the first asset.

12. The apparatus according to claim 7 , wherein said means for aggregating forms an asset table in a database by encapsulating the assigned identifier for each application.

13. The apparatus according to claim 12 , wherein the forming further comprises establishing a virtual asset address within the database using the identifier.

14. The apparatus according to claim 7 , wherein said means for establishing defines search environment parameters involved in the search.

15. The apparatus according to claim 14 , further comprising means for importing the search environment parameters into a search database during configuration of the search in response to the search query to provide client applications an interface to create, validate and execute the search query.

16. The apparatus according to claim 14 , wherein said defining comprises identifying metadata descriptions associated with each asset, wherein the user search query is dynamically created for a database using the metadata description during the establishing of the search configuration.

17. A non-transitory computer-readable medium storing computer executable code, comprising code to:

synchronize search results from at least two data sources in response to a user search query, the data sources comprising a central database comprising an asset table for a plurality of external databases storing media assets, and at least one of a file repository and another site, wherein an asset comprises an aggregation of information regarding a media essence;

establish a search configuration in response to the user search query

aggregate the synchronized search results from the at least two data sources, said aggregating including assigning an identifier for each application corresponding to a respective asset; and

present the aggregated search results to the user as one search result.

18. The computer-readable medium according to claim 17 , wherein aggregating includes forming an asset table in a database by encapsulating the assigned identifier for each application.

19. The computer-readable medium according to claim 18 , wherein the forming further comprises establishing a virtual asset address within the database using the identifier.

20. The computer-readable medium according to claim 17 , wherein said establishing includes defining search environment parameters involved in the search.