Synchronization of metadata

• US 8,019,737 B2
• Filed: 03/13/2008
• Issued: 09/13/2011
• Est. Priority Date: 03/13/2008
• Status: Active Grant

• Current Assignee: HBC Solutions Incorporated (AEG Holdings, Inc.)
• Original Assignee: Harris Corporation (L3Harris Technologies, Inc.)
• Inventors: Van Pelt, Brian, Kocsis, Charles F., Turlapati, Srinivas, Bergstrom, Pamela V.
• Primary Examiner(s): Padmanabhan; Kavita
• Application Number:
  US12/047,704
• Publication Number:
  US 20090234850A1
• Time in Patent Office: 1,279 Days
• Field of Search: None
• US Class Current: 707/694
• CPC Class Codes: G06F 16/213 with details for schema evolution support

Abstract

A system to synchronize metadata for a plurality of applications. The system includes content administration rules programmed to define policies for updating metadata in the master database and policies for propagating updates in the metadata to the plurality of applications. The metadata describes at least one asset represented as data residing in at least one of the plurality of applications. A rules engine is programmed to apply at least a first set of the content administration rules to a metadata record received from a first application of the plurality of applications to control updating corresponding metadata stored in a master database. Changes in the corresponding metadata made to the master database can be propagated to at least one second application of the plurality of applications according to a second set of the content administration rules predefined for each of the at least one second application.

Claims

1. A system to synchronize metadata for a plurality of applications comprising:

memory for storing computer executable instructions; and

a processing unit for accessing the memory and executing the computer executable instructions, the computer executable instructions comprising;

content administration rules programmed to define policies for updating a master database that stores a plurality of metadata records and policies for propagating updates of the metadata records in the master database to the plurality of applications, each metadata record comprising a plurality of metadata fields describing at least one asset represented as data residing in at least one of the plurality of applications;

a rules engine that is programmed to apply at least a first set of the content administration rules to a metadata record received from a first application of the plurality of applications to control updating fields in a corresponding metadata record of the plurality of metadata records stored in the master database, changes in the corresponding metadata record made to the master database being selectively propagated to at least one second application of the plurality of applications according to a second set of the content administration rules that is predefined for each of the at least one second application,

wherein at least one of the plurality of applications includes a set of metadata records that corresponding to a proper subset of the plurality of metadata records stored in the master database,

wherein the content administration rules further comprise;

precedence rules that define a ranking among the plurality of applications for each of a plurality of metadata fields of a given metadata record of the plurality of metadata records stored in the master database, the rules engine applying the precedence rules determine if a given metadata field in the metadata record from the first application has priority to overwrite a corresponding metadata field in a corresponding metadata record in the master database that has been set by another of the plurality of applications in the system; and

ownership rules that define which of the plurality of applications is an owner of each respective metadata field of the plurality of metadata fields for a given metadata record of the plurality of metadata records stored in the master database, wherein at least two different applications of the plurality of applications are owners of different metadata fields of the plurality of metadata fields for the given metadata record, the rules engine applying the ownership rules determine if the first application has authority to modify the corresponding metadata field in the corresponding metadata record in the master database, the master database being updated depending on application of the precedence rules and the ownership rules by the rules engine.

2. The system of claim 1, further comprising at least two precedence rule profiles, each of the at least two precedence rule profiles including a set of the precedence rules stored in the memory, the rules engine selecting one of the at least two precedence rule profiles to apply to the metadata record from the first application according to a type of the metadata record from the first application, wherein the metadata record from the first application is one of (i) a content type metadata record that describes content of at least one asset residing on the first application or (ii) a material type metadata record that describes a physical media on which the at least one asset residing on the first application is stored.

3. The system of claim 2, wherein the type of the metadata record is defined by at least one metadata field of the metadata record from the first application.

4. The system of claim 1, wherein the content administration rules further comprises applicability rules that identify a relevance of each of the metadata fields, for each of the plurality of metadata records stored in the master database, to control which changes to metadata fields to propagate to each of the plurality of applications, the system further comprising a publish component that is programmed to propagate updates to each of the at least one second application in response to the master database being updated and according to application of the applicability rules for each respective one of the at least one second application.

5. The system of claim 4, further comprising at least two applicability rule profiles stored in the memory, each of the at least two applicability rule profiles including a set of the applicability rules, the publish component selecting one of the at least two applicability rule profiles to apply to an updated metadata record in the master database according to at least one of a type and purpose of the metadata record being updated in the master database, wherein the updated metadata record is one of (i) a content type metadata record that describes content of at least one asset residing on the first application or (ii) a material type metadata record that describes a physical media on which the at least one asset residing on the first application is stored.

6. The system of claim 5, wherein the at least one of a type and purpose of the metadata record is defined by at least one metadata field of the metadata record being updated in the master database.

7. The system of claim 1, further comprising a matching engine programmed to provide the rules engine with the metadata record from the first application in response to detecting an occurrence of a match between the metadata record from the first application and a metadata record in the master database.

8. The system of claim 7, wherein the content administration rules further comprise key field rules that identify at least one key metadata field to be utilized for matching records, the matching engine further comprising:

a key field extractor that extracts the at least one key metadata field from the metadata record from the first application and the metadata record stored in the master database according to the key field rules, the matching engine comparing the extracted key metadata fields to determine the occurrence of a match between the metadata record from the first application and the metadata record stored in the master database.

9. The system of claim 8, wherein the key field rules further comprise at least one weight value assigned to each key metadata field to establish a relative importance of the key metadata fields, the matching engine comparing the extracted key metadata fields and the weight value associated with each of the extracted key metadata fields relative to a threshold to determine the occurrence of a match between the metadata record from the first application and the metadata record stored in the master database.

10. The system of claim 9, further comprising at least two key field rule profiles stored in the memory, each of the at least two key field rule profiles including a set of the key field rules, the matching engine applying one of the at least two key field rule profiles for determining the occurrence of a match between the metadata record from the first application and the metadata record stored in the master database, the applied one of the at least two key field rule profiles being selected according to at least one metadata field in the metadata record from the first application.

11. The system of claim 10, wherein the matching engine selects the one of the at least two key field rule profiles to be applied according a type of the metadata record from the first application, wherein the metadata record from the first application is one of (i) a content type metadata record that describes content of at least one asset residing on the first application and (ii) a material type metadata record that describes a physical media on which the at least one asset residing on the first application is stored.

12. The system of claim 1, wherein the computer executable instructions further comprise a synchronization manager that provides a user interface programmed to establish the content administration rules.

13. The system of claim 12, wherein the synchronization manager further comprises:

a precedence user interface responsive to user inputs to program precedence rules, the precedence rules defining a ranking among the plurality of applications for each of a plurality of metadata fields to control overwriting for each of the metadata fields for a given metadata record stored in the master database; and

an ownership user interface responsive user inputs to program ownership rules for each of a plurality of metadata fields in the given metadata record to control propagation of changes for each of the plurality of metadata fields in the given metadata record stored in the master database.

14. The system of claim 13, wherein the synchronization manager further comprises:

an applicability user interface responsive to user inputs to program applicability rules that define a relevance of each of the plurality of metadata fields in the given metadata record stored in the master database to each of the plurality of applications; and

a key field user interface responsive to user inputs to program key field rules that establish which of at least one key field to utilize to control matching information in the metadata record from the first application with at least one metadata record in the master database.

15. The system of claim 1, wherein the at least one asset comprises a plurality of assets in the at least one of fields of broadcasting and advertising.

16. The system of claim 1, wherein the at least one asset comprises a plurality of assets including a set of material assets and logical content assets.

17. The system of claim 1, wherein the computer executable instructions further comprise a messaging controller programmed to propagate changes in metadata fields made to at least one metadata record of the plurality of metadata records stored in the master database to the at least one second application of the plurality of applications according to the second set of the content administration rules predefined for each of the at least one second application;

wherein each of the plurality of applications subscribe to a communication platform that is employed by the messaging controller to enable communication of messages in the system.

18. A system for field-level synchronization of metadata records for a plurality of applications running in a broadcast or content delivery platform, the metadata records describing at least one of a material asset or a logical content asset, the system comprising:

memory for storing computer executable instructions; and

a processing unit for accessing the memory and executing the computer executable instructions, the computer executable instructions comprising;

a matching engine programmed to detect an occurrence of a match between a metadata record received from a first application of the plurality of applications and a corresponding master metadata record stored in a master database based on a first set of content administration rules, wherein each of the metadata record received from the first application and the master metadata record comprises a plurality of metadata fields;

a rules engine that is programmed to control updating metadata fields of the corresponding master metadata record based on an application of a second set of content administration rules to at least a substantial portion of metadata fields of the metadata record received from the first application, the matching engine providing the rules engine with the at least a substantial portion of the metadata fields of the metadata record received from the first application in response to detecting the occurrence of a match; and

wherein the second set of content administration rules comprises;

precedence rules that define a ranking among the plurality of applications for each of a plurality of metadata fields of a given metadata record of the plurality of metadata records stored in the master database, the rules engine applying the precedence rules determine if a given metadata field in the metadata record from the first application has priority to overwrite a corresponding metadata field in a corresponding metadata record in the master database that has been set by another of the plurality of applications in the system; and

ownership rules that define which of the plurality of applications is an owner of each respective metadata field of the plurality of metadata fields for a given metadata record of the plurality of metadata records stored in the master database, wherein at least two different applications of the plurality of applications are owners of different metadata fields of the plurality of metadata fields for the given metadata record, the rules engine applying the ownership rules determine if the first application has authority to modify the corresponding metadata field in the corresponding metadata record in the master database, the master database being updated depending on application of the precedence rules and the ownership rules by the rules engine; and

an update component programmed to publish updates in metadata records to at least some of the plurality of applications for field-level synchronization according to updates made to the corresponding master metadata record in the master database, such that at least one of the plurality of applications represents field-level information in at least one metadata field differently from the master database.

19. The system of claim 18, wherein the computer executable instructions further comprise a synchronization manager that provides a user interface programmed to establish at least some of the content administration rules.

20. The system of claim 18, wherein the second set of content administration rules further comprises a plurality of rule profiles, each of the plurality of rule profiles including a set of predefined content administration rules, the rules engine selecting a corresponding one of the rule profiles to apply to the at least a substantial portion of the metadata fields of the metadata record provided by the matching engine, the corresponding one of the rule profiles being selected according to at least one metadata field in the metadata record received from the first application.

21. A method for synchronizing fields of metadata records, each metadata record describes associated data residing in at least two applications and in a master database, the method comprising:

receiving at a synchronization system executing on a computer system, from a first application, a message that includes at least one metadata record comprising plurality of metadata fields;

in response to matching the at least one metadata record with a corresponding master record from the master database stored in memory, applying a set of content administration rules to control selectively updating metadata fields in the corresponding master record, wherein the content administration rules comprise;

precedence rules that define a ranking among the at least two applications for each of a plurality of metadata fields of a given metadata record of the plurality of metadata records stored in the master database, the precedence rules being applied to determine if a given metadata field in the metadata record from the first application has priority to overwrite a corresponding metadata field in a corresponding metadata record in the master database that has been set by another of the at least two applications in the system; and

ownership rules that define which of the plurality of applications is an owner of each respective metadata field of the plurality of metadata fields for a given metadata record of the plurality of metadata records stored in the master database, wherein the at least two different applications are owners of different metadata fields of the plurality of metadata fields for the given metadata record, the ownership rules being applied determine if the first application has authority to modify the corresponding metadata field in the corresponding metadata record in the master database, the master database being updated depending on application of the precedence rules and the ownership rules by the rules engine; and

publishing changes in the corresponding master record to at least one other application according to applicability rules defined for the at least one other application, such that in response to the publishing, the at least one other application represents information in at least one metadata field of the corresponding master record differently from the master database.

22. The method of claim 21, wherein the content administration rules further comprise:

ownership rules that define an ownership status for each application for each of the metadata fields in the at least one metadata record, wherein each of the at least two different applications are owners of different metadata fields in a given record of the at least one metadata record; and

precedence rules that defines a priority for each of the metadata fields in the at least one metadata record, wherein the priority is set in response to a user input.

23. The method of claim 22, further comprising programming at least two of the ownership rules, the precedence rules and the applicability rules prior to receiving the message at the synchronization system.

24. The method of claim 21, further comprising performing, at the computer system, matching between at least one metadata field in the at least one metadata record received from the first application with respective metadata fields in the corresponding master record according to a set of predefined key field rules, the predefined key field rules establishing which metadata fields to utilize when performing the matching.