User feedback processing of metadata associated with digital media files

• US 20040002993A1
• Filed: 06/26/2002
• Published: 01/01/2004
• Est. Priority Date: 06/26/2002
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Toussaint, Keith M., McCartney, Jason E. D., Springer, T. Brian Jr.
• Application Number:
  US10/180,449
• Publication Number:
  US 20040002993A1
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06F 16/48 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually

Abstract

System and methods for processing user feedback data corresponding to digital media files. Client computers execute a media player program for rendering media files to their users. A server receives user-provided data entries relating to content of the media files and performs per field conflict resolution to determine relationships between the entries. Based on the relationships, the server aggregates the data entries and then defines new metadata records from the aggregated data for publishing to the users. The invention is directed to a user feedback data schema.

Claims

1. A method of processing metadata comprising:

maintaining a database of metadata records, said metadata records each corresponding to one or more media files and relating to content of the corresponding media files, said media files being adapted for rendering by a media player program executed on one or more client computers;

collecting a plurality of user-provided data entries from the client computers, said data entries each corresponding to a specific media file and relating to the content of the corresponding specific media file;

determining relationships between the data entries and aggregating the data entries based thereon; and

defining one or more new metadata records in the metadata database from the aggregated data entries.

2. The method of claim 1 further comprising receiving, by a server associated with the metadata database, an identifier representative of the specific media file for each of the data entries from the client computers, said client computers and said server being coupled to a data communication network, and searching the metadata database for metadata records corresponding to the specific media file as a function of the identifier.

3. The method of claim 2 further comprising proceeding with collecting a plurality of user-provided data entries from the client computers if no metadata record corresponding to the specific media file represented by the identifier is found.

4. The method of claim 2 further comprising retrieving each of the metadata records found in the metadata database corresponding to the specific media file represented by the identifier, formatting the retrieved metadata records for rendering by the media player program, and returning the formatted metadata records via the data communication network to the respective client computer for rendering with the corresponding specific media file.

5. The method of claim 2 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the identifier is representative of offset of the tracks on the disc.

6. The method of claim 2 wherein the specific media file includes digital content of a digital versatile disc and wherein the identifier is representative of menu information on the disc.

7. The method of claim 2 wherein the identifier comprises a physical ID and further comprising mapping the physical ID to a logical ID, said logical ID being representative of content characteristics of the specific media file and configured for use in querying the metadata database.

8. The method of claim 7 wherein searching the metadata database for metadata records corresponding to the specific media file comprises attempting to identify whether the logical ID already exists for the specific media file.

9. The method of claim 1 wherein determining relationships between the data entries and aggregating the data entries based thereon comprise defining a model record from one or more of the data entries based on at least one property of content-related data and applying subsequent user-provided data entries to the model record based on the property.

10. The method of claim 9 further comprising performing text matching to determine which of the data entries contain content-related data matching the model record.

11. The method of claim 9 wherein applying subsequent user-provided data entries to the model record comprises performing per field conflict resolution on the content-related data in the data entries.

12. The method of claim 11 wherein performing per field conflict resolution comprises populating the model record with the most frequently entered content-related data contained in the subsequent user-provided data entries.

13. The method of claim 9 wherein the at least one property of content-related data contains information identifying a performer of the content of the corresponding specific media file.

14. The method of claim 9 wherein the at least one property of content-related data contains information identifying a title of the content of the corresponding specific media file.

15. The method of claim 9 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the at least one property of content-related data contains information representative of offset of the tracks on the disc.

16. The method of claim 9 wherein the specific media file includes digital content of a digital versatile disc and wherein the at least one property of content-related data contains information representative of menu information on the disc.

17. The method of claim 1 wherein the data entries contain content-related data in a plurality of fields and wherein determining relationships between the data entries and aggregating the data entries based thereon comprise performing per field conflict resolution on the content-related data.

18. The method of claim 1 further comprising storing the plurality of user-provided data entries from the client computers for subsequent processing, said user-provided data entries being stored separately from the aggregated user-provided data entries from which the newly defined metadata records are defined.

19. The method of claim 1 wherein maintaining the metadata database comprises maintaining a canonical table of the metadata records that contain content-related data obtained from one or more trusted sources and further comprising preventing the content-related data of the newly defined metadata records from supplanting the content-related data of the metadata records in the canonical table for the corresponding media files.

20. The method of claim 1 further comprising updating the metadata records in the metadata database with the newly defined metadata records.

21. The method of claim 1 further comprising defining a user feedback data schema for the data entries, said schema having a base table identifying each of the data entries collected from the client computers and a plurality of related tables organizing the content-related data of the data entries.

22. The method of claim 21 wherein the specific media file for each of the data entries from the client computers has an identifier representative thereof and wherein the related tables of the user feedback data schema include an identifier table for storing matches and modifications to the identifiers.

23. The method of claim 21 wherein the related tables of the user feedback data schema include an album table for storing new album entries and modifications to album name and/or performer associated therewith.

24. The method of claim 22 wherein the album table contains content-related data from the user-provided data entries and wherein the content-related data is selected from one or more of the following:

title, performer, primary artist, and genre.

25. The method of claim 21 wherein the related tables of the user feedback data schema include a person table for storing new and modified names of performers not included in another of the related tables.

26. The method of claim 25 wherein the person table contains content-related data from the user-provided data entries and wherein the content-related data is selected from one or more of the following:

full name of performer, sort name of performer, and genre.

27. The method of claim 21 wherein the related tables of the user feedback data schema include a track table for storing additions and modifications to track information for the media files.

28. The method of claim 1 wherein the metadata records each contain content-related data and wherein the content-related data is selected from one or more of the following:

title, composer, performer, genre, studio, director, rating, art, and description of content of the corresponding media file.

29. The method of claim 1 wherein collecting a plurality of user-provided data entries from the client computers comprises causing a wizard user interface to be presented to a user via the respective client computer so that information pertaining to the user'"'"'s specific media file can be collected from the user.

30. The method of claim 1 wherein one or more computer-readable media have computer-executable instructions for performing the method of claim 1.

31. A method of processing metadata comprising:

collecting a plurality of user-provided data entries from one or more client computers, said data entries each corresponding to a specific media file and relating to content of the corresponding specific media file, said media files being adapted for rendering by a media player program executed on the client computers;

defining a model record from one or more of the data entries based on at least one property of content-related data;

performing per field conflict resolution on the content-related data in the data entries;

populating the model record based on the per field conflict resolution; and

defining one or more new metadata records in the metadata database from the model record.

32. The method of claim 31 further comprising performing text matching to determine which of the data entries contain content-related data matching the model record.

33. The method of claim 31 wherein the per field conflict resolution comprises determining the most frequently entered content-related data contained in the user-provided data entries.

34. The method of claim 31 wherein the at least one property of content-related data contains information identifying a performer of the content of the corresponding specific media file.

35. The method of claim 31 wherein the at least one property of content-related data contains information identifying a title of the content of the corresponding specific media file.

36. The method of claim 31 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the at least one property of content-related data contains information representative of offset of the tracks on the disc.

37. The method of claim 31 wherein the specific media file includes digital content of a digital versatile disc and wherein the at least one property of content-related data contains information representative of menu information on the disc.

38. The method of claim 31 further comprising receiving, by a server associated with the metadata database, an identifier representative of the specific media file for each of the data entries from the client computers, said client computers and said server being coupled to a data communication network, and searching the metadata database for metadata records corresponding to the specific media file as a function of the identifier.

39. The method of claim 38 further comprising retrieving each of the metadata records found in the metadata database corresponding to the specific media file represented by the identifier, formatting the retrieved metadata records for rendering by the media player program, and returning the formatted metadata records via the data communication network to the respective client computer for rendering with the corresponding specific media file.

40. The method of claim 38 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the identifier is representative of offset of the tracks on the disc.

41. The method of claim 38 wherein the specific media file includes digital content of a digital versatile disc and wherein the identifier is representative of menu information on the disc.

42. The method of claim 38 wherein the identifier comprises a physical ID and further comprising mapping the physical ID to a logical ID, said logical ID being representative of content characteristics of the specific media file and configured for use in querying the metadata database.

43. The method of claim 42 wherein searching the metadata database for metadata records corresponding to the specific media file comprises attempting to identify whether the logical ID already exists for the specific media file.

44. The method of claim 31 wherein maintaining the metadata database comprises maintaining a canonical table of the metadata records that contain content-related data obtained from one or more trusted sources and further comprising preventing the content-related data of the newly defined metadata records from supplanting the content-related data of the metadata records in the canonical table for the corresponding media files.

45. The method of claim 31 further comprising updating the metadata records in the metadata database with the newly defined metadata records.

46. The method of claim 31 wherein the metadata records each contain content-related data and wherein the content-related data is selected from one or more of the following:

title, composer, performer, genre, studio, director, rating, art, and description of content of the corresponding media file.

47. The method of claim 31 wherein collecting a plurality of user-provided data entries from the client computers comprises causing a wizard user interface to be presented to a user via the respective client computer so that information pertaining to the user'"'"'s specific media file can be collected from the user.

48. The method of claim 31 wherein one or more computer-readable media have computer-executable instructions for performing the method of claim 31.

49. A system for processing user feedback comprising:

one or more client computers coupled to a data communication network, said client computers executing a media player program for rendering media files to users of the client computers;

a database of metadata records, said metadata records each corresponding to one or more media files and relating to content of the corresponding media files;

a database of user-provided data entries from the client computers, said data entries each corresponding to a specific media file and relating to the content of the corresponding specific media file; and

a server coupled to the data communication network, said server being associated with the databases and receiving the user-provided data entries via the data communication network, said server determining relationships between the data entries, aggregating the data entries based thereon, and defining one or more new metadata records in the metadata database from the aggregated data entries.

50. The system of claim 49 wherein the specific media file for each of the data entries from the client computers has an identifier representative thereof and wherein the server conducts a search the metadata database for metadata records corresponding to the specific media file as a function of the identifier.

51. The system of claim 50 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the identifier is representative of offset of the tracks on the disc.

52. The system of claim 50 wherein the specific media file includes digital content of a digital versatile disc and wherein the identifier is representative of menu information on the disc.

53. The system of claim 49 further comprising a model record defined from one or more of the data entries based on at least one property of content-related data, and wherein the server applies subsequent user-provided data entries to the model record based on the property.

54. The system of claim 53 wherein the server performs text matching to determine which of the data entries contain content-related data matching the model record.

55. The system of claim 53 wherein the server performs per field conflict resolution on the content-related data in the data entries.

56. The system of claim 55 wherein the server populates the model record with the most frequently entered content-related data contained in the subsequent user-provided data entries.

57. The system of claim 53 wherein the at least one property of content-related data contains information identifying a performer of the content of the corresponding specific media file.

58. The system of claim 53 wherein the at least one property of content-related data contains information identifying a title of the content of the corresponding specific media file.

59. The system of claim 53 wherein the specific media file includes digital content of one or more tracks of a compact disc and wherein the at least one property of content-related data contains information representative of offset of the tracks on the disc.

60. The system of claim 53 wherein the specific media file includes digital content of a digital versatile disc and wherein the at least one property of content-related data contains information representative of menu information on the disc.

61. The system of claim 49 wherein the data entries contain content-related data in a plurality of fields and wherein the server performs per field conflict resolution on the content-related data to aggregate the data entries.

62. The system of claim 49 wherein the metadata database includes a canonical table of the metadata records that contain content-related data obtained from one or more trusted sources and wherein data conflicts are resolved in favor of the canonical table.

63. The system of claim 49 wherein the metadata records in the metadata database are updated with the newly defined metadata records.

64. The system of claim 49 wherein the newly defined metadata records do not contain redundant data with respect to the other metadata records.

65. The system of claim 49 wherein the metadata records each contain content-related data and wherein the content-related data is selected from one or more of the following:

title, composer, performer, genre, studio, director, rating, art, and description of content of the corresponding media file.

66. The system of claim 49 further comprising a wizard user interface to be presented to a user via the respective client computer so that information pertaining to the user'"'"'s specific media file can be collected from the user.

67. A user feedback data schema comprising:

a base table identifying each of a plurality of user-provided data entries collected from one or more client computers, said data entries each corresponding to a specific media file and relating to content of the corresponding specific media file, said media file being adapted for rendering by a media player program executed on the client computers; and

a plurality of tables related to the base table each for organizing content-related data of the data entries, said related tables organizing selected content-related data in different tables for feeding directly to a database of metadata records, said metadata records each corresponding to one or more media files and relating to the content of the corresponding media files.

68. The schema of claim 67 wherein the related tables include an album table for storing new album entries and modifications to album name and/or performer associated therewith.

69. The schema of claim 68 wherein the album table contains content-related data from the user-provided data entries and wherein the content-related data is selected from one or more of the following:

title, performer, primary artist, and genre.

70. The schema of claim 67 wherein the related tables include a person table for storing new and modified names of performers not included in another of the related tables.

71. The schema of claim 70 wherein the person table contains content-related data from the user-provided data entries and wherein the content-related data is selected from one or more of the following:

full name of performer, sort name of performer, and genre.

72. The schema of claim 67 wherein the related tables include a track table for storing additions and modifications to track information for the media files.

73. The schema of claim 67 wherein the specific media file for each of the data entries from the client computers has an identifier representative thereof and wherein the related tables include an identifier table for storing matches and modifications to the identifiers.

74. The schema of claim 67 wherein the specific media file includes digital content of one or more tracks of a compact disc (CD) and wherein the related tables are organized according to a basic CD metadata schema.