Enhanced database scheme to support advanced media production and distribution

• US 9,400,827 B2
• Filed: 01/07/2014
• Issued: 07/26/2016
• Est. Priority Date: 04/13/2007
• Status: Active Grant

• Current Assignee: Grass Valley Canada (Belden Inc.)
• Original Assignee: Gvbb Holdings SARL (Vislink Technologies, Inc.)
• Inventors: Du Fosse, Eric, Durand, Cassiano, Reiner, Wilfried
• Primary Examiner(s): Nguyen, Cam-Linh
• Application Number:
  US14/149,623
• Publication Number:
  US 20140122426A1
• Time in Patent Office: 931 Days
• Field of Search: 707/610, 707/802
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/48 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9538 Presentation of query results

Abstract

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.

Claims

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.