Method, system, and program product to support multiple content-management data models

• US 7,043,490 B2
• Filed: 03/05/2002
• Issued: 05/09/2006
• Est. Priority Date: 03/05/2002
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Liang, Lily, Hu, Tawei, Richardt, Randal J., Nelson, Kenneth C., Choy, David M.
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Lu, Kuen S.
• Application Number:
  US10/091,919
• Publication Number:
  US 20030172049A1
• Time in Patent Office: 1,526 Days
• Field of Search: 707/1, 707/2, 707/103.R, 707/101, 707/102, 707/104.1, 707/10, 715/513
• US Class Current: 1/1
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• 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: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Methods, systems, and program products for managing multimedia content. These are built upon a combination of a high level content model for specific multimedia content types and a low level physical for mapping to a data engine. The method, system, and program product include representing multimedia content management objects and managing the objects in a relational database. The relational database is adapted for representing data in a plurality of relational database tables, where each of the relational database tables has at least one row with a plurality of columns. Content is managed by associating the object as an item to a row in a first relational database table; and associating additional components, if any, of the object to additional relational database tables.

Claims

1. A method of representing a multimedia content management object as an item in a relational database adapted for representing multimedia content management data in one or more relational database tables, each of said relational database tables having at least one row with a plurality of columns, said method comprising:

associating a root component of the content management object with a row in a first relational database table;

associating attributes of the root component with corresponding columns of the first relational database table;

associating additional components of the content management object, if any, with rows in additional relational database tables; and

using the item defined by the relational database tables to construct a plurality of high level content management data models, each corresponding to a different application.

2. The method of claim 1, wherein each of the additional components comprises a child component of a root component or a child component of another component.

3. The method of claim 2, further comprising using a foreign key in a child component to reference its parent component.

4. The method of claim 1, wherein an attribute comprises a pointer to a data resource stored in a separate repository.

5. The method of claim 1, wherein an attribute comprises a pointer to another content management object.

6. The method of claim 1, wherein a row in a table comprises a link between a source item and a target item.

7. A method of representing a multimedia content management object in a database comprising a high level content model and a low level physical model of multimedia content data, said low level physical model providing a mapping to a data engine, said method comprising:

a. entering multimedia content data metadata and schema in the low level physical model, and

b. mapping the metadata and schema to the data engine, wherein the low level physical model supports a plurality of high level content models, and wherein the high level content models each corresponds to a different application.

8. The method of claim 7, wherein the high level content model comprises an application program interface embodying a representation of one or more data structures and constraints.

9. The method of claim 7, wherein the high level content model supports a plurality of content application requirements.

10. The method of claim 7, wherein the low level physical model is extensible.

11. The method of claim 7, further comprising adding additional high level content models.

12. The method of claim 7, wherein the data engine is chosen from the group consisting of relational database management systems, object oriented database management systems, object-relational database management systems and XML data repositories.

13. A method of managing a multimedia content management system comprising a multimedia content management object including multimedia object components and multimedia object attributes, said multimedia content management object represented as an item in a relational database adapted for representing multimedia content management data in one or more relational database tables, each of said relational database tables having at least one row with a plurality of columns, said method comprising:

associating a root component of the content management object with a row in a first relational database table;

associating attributes of the root component with corresponding columns of the first relational database table;

associating additional components of the content management object, if any, with rows in additional relational database tables; and

using the item defined by the relational database tables to construct a plurality of high level content management data models, each corresponding to a different application.

14. The method of claim 13, wherein each of the additional components comprises a child component of a root component or a child component of another component.

15. The method of claim 14, further comprising using a foreign key in a child component to reference its parent component.

16. The method of claim 13, wherein an attribute comprises a pointer to a data resource stored in a separate repository.

17. The method of claim 13, wherein an attribute comprises a pointer to another content management object.

18. The method of claim 13, wherein a row in another table comprises a link between a source item and a target item.

19. A system for managing and delivering one or more multimedia data object items of a multimedia content management object from a multimedia data object content repository through a multimedia data object content server to a client, each of the multimedia data object items comprising multimedia data object attributes and components, and wherein the multimedia data object content server is controlled and configured to:

a. associate a root component of the content management object with a row in a first relational database table;

b. associate attributes of the root component with corresponding columns of the first relational database table; and

c. associate additional components of the content management object, if any, with corresponding rows in additional relational database tables;

wherein the data object items are used to construct a plurality of high level data models, each corresponding to a different application.

20. The system of claim 19 wherein, each of the additional components comprises a child component of the root component, or a child component of another child component.

21. The system of claim 20, wherein a foreign key is used in a child component to reference its parent component.

22. The system of claim 19, wherein an attribute comprises a pointer to a data resource stored in a separate repository.

23. The system of claim 19, wherein an attribute comprises a pointer to another content management object.

24. The system of claim 19, wherein a row in another table comprises a link between a source item and a target item.

25. A program product comprising computer readable code on one or more media, said program code being capable of controlling and configuring a computer system having one or more computers to manage a multimedia content management system having a high level content model and a low level physical model of multimedia content data, said low level physical model providing a mapping to a data engine, by representing a multimedia content management object in a database by the method comprising:

a. entering multimedia content data metadata and schema in the low level physical model, and

b. mapping the metadata and schema to the data engine, wherein the low level physical model supports a plurality of high level content models, and wherein the high level content models each corresponds to a different application.

26. The program product of claim 25, wherein the high level content model comprises an application program interface embodying a representation of one or more data structures and constraints.

27. The program product of claim 25, wherein the high level content model supports a plurality of content application requirements.

28. The program product of claim 25, wherein the low level physical model is extensible.

29. The program product of claim 25, wherein the low level physical model supports additional high level content models.

30. The program product of claim 25, wherein the data engine is chosen from the group consisting of relational database management systems, object oriented database management systems, object-relational database management systems, and XML data repositones.

31. A program product comprising computer readable code on one or more media, said program code being capable of controlling and configuring a computer system having one or more computers to manage a multimedia content management system comprising a multimedia content management object having multimedia object components and multimedia object attributes, said multimedia content management object represented as an item in a relational database adapted for representing multimedia content management data in one or more relational database tables, each of said relational database tables having at least one row with a plurality of columns, by a method comprising:

associating a root component of the content management object with a row in a first relational database table;

associating attributes of the root component with corresponding columns of the first relational database table;

associating additional components of the content management object, if any, with rows in additional relational database tables; and

using the item defined by the relational database tables to construct a plurality of high level data models, each corresponding to a different application.

32. The program product of claim 31, wherein each of the additional components comprises a child component of the root component or a child component of another child component.

33. The program product of claim 32, further comprising program code to direct the computer system to use a foreign key in a child component to reference its parent component.

34. The program product of claim 31, wherein an attribute comprises a pointer to a data resource stored in a separate repository.

35. The program product of claim 31, further comprising program code for populating a multimedia content management system with content schema and metadata, said program code adapted to configure and control the computer to

a. present a query to a user as to a content item;

b. based upon the end user'"'"'s response, present a subsequent query as to the content item;

c. based upon the end user'"'"'s further responses, determine the sub-components and attributes of the item.

36. A method of populating a multimedia content management system with content schema and metadata, said content management system comprising a multimedia content management object having multimedia object components and multimedia object attributes, and a relational database adapted for representing component and attribute data in one or more relational database tables, each of said relational database tables having at least one row with a plurality of columns, said method comprising:

presenting a query to a user as to a content item;

based upon the end user'"'"'s response, presenting a subsequent query as to the content item;

based upon the end user'"'"'s further responses, determining the components and attributes of the content item;

associating each component of the content item with a row in a separate relational database table; and

associating attributes of the content item with corresponding columns of the relational database tables, wherein the content item is suitable for constructing a plurality of high level content management data models, each corresponding to a different application.

37. The method of claim 36, further comprising using a foreign key in a child component to reference its parent component.

38. The method of claim 36, wherein a sub-component comprises a child component of a root component or a child component of another child component.

39. The method of claim 36, wherein an attribute comprises a pointer to a data repository where the component is stored.

40. The method of claim 36, wherein an attribute comprises a pointer to a data resource stored in a separate repository.

41. The method of claim 36, wherein a row in another table comprises a link between a source item and a target item.