CA2477126A1 - Support for multiple content-management data models - Google Patents

Support for multiple content-management data models Download PDF

Info

Publication number
CA2477126A1
CA2477126A1 CA002477126A CA2477126A CA2477126A1 CA 2477126 A1 CA2477126 A1 CA 2477126A1 CA 002477126 A CA002477126 A CA 002477126A CA 2477126 A CA2477126 A CA 2477126A CA 2477126 A1 CA2477126 A1 CA 2477126A1
Authority
CA
Canada
Prior art keywords
relational database
data
multimedia
item
content
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CA002477126A
Other languages
French (fr)
Other versions
CA2477126C (en
Inventor
Randal James Richardt
David Mun-Hien Choy
Tawei Hu
Lily Liang
Kenneth Carlin Nelson
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of CA2477126A1 publication Critical patent/CA2477126A1/en
Application granted granted Critical
Publication of CA2477126C publication Critical patent/CA2477126C/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/48—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Multimedia (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Library & Information Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)

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 (10)

1. A method of representing a multimedia content management object in a database comprising one or more high level content models and a low level physical model of the 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 representation, and b. mapping the metadata and schema to the data engine.
2. The method of claim 1 wherein the one or more high level content models comprises an application program interface embodying a representation of data structure and constraints.
3. The method of claim 1 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.
4. A method of claim 1 wherein the mapping to a data engine comprises a method of representing the 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:
a. associating a root component of the object as an item to a row in a first relational database table;
b. associating attributes of the root component to corresponding columns of the first relational database table;
c. associating additional components of the object, if any, to rows in additional relational database tables; and d. wherein the item is used as a building block to construct a plurality of high level content management data models.
5. The method of claim 4 further comprising a method of managing a multimedia content management system comprising the multimedia content management object and the relational database.
6. The method of claim 4 or claim 5 wherein each of the additional components comprises a child component of a root component or a child component of another component.
7. The method of claim 4 or claim 5 wherein an attribute comprises a pointer to a data resource stored in a separate repository.
8. The method of claim 4 or claim 5 wherein a row in a table comprises a link between a source item and a target item.
9. A computer program product comprising instructions which, when executed on a data processing system having a non-volatile memory storage device, causes said system to carry out a method as claimed in any one of claim 1 to claim 8.
10. A system for managing and delivering multimedia data object items from a multimedia data object content repository through a multimedia data object content server to a client, wherein the multimedia data object comprises multimedia data object items, 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 object to a row in a first relational database table;
b. associate attributes of the root component to corresponding columns of the first relational database table; and c. associate additional components of the object, if any, to corresponding rows in additional relational database tables;
wherein the item is used as a building block to construct a plurality of high level data models.
CA2477126A 2002-03-05 2003-02-14 Support for multiple content-management data models Expired - Lifetime CA2477126C (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US10/091,919 US7043490B2 (en) 2002-03-05 2002-03-05 Method, system, and program product to support multiple content-management data models
US10/091,919 2002-03-05
PCT/GB2003/000679 WO2003075176A2 (en) 2002-03-05 2003-02-14 Support for multiple content-management data models

Publications (2)

Publication Number Publication Date
CA2477126A1 true CA2477126A1 (en) 2003-09-12
CA2477126C CA2477126C (en) 2011-07-26

Family

ID=27787764

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2477126A Expired - Lifetime CA2477126C (en) 2002-03-05 2003-02-14 Support for multiple content-management data models

Country Status (9)

Country Link
US (1) US7043490B2 (en)
EP (1) EP1530762A2 (en)
JP (1) JP4222947B2 (en)
KR (1) KR100745442B1 (en)
CN (1) CN100470538C (en)
AU (1) AU2003215716A1 (en)
BR (1) BR0308269A (en)
CA (1) CA2477126C (en)
WO (1) WO2003075176A2 (en)

Families Citing this family (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040015514A1 (en) * 2002-04-03 2004-01-22 Austin Melton Method and system for managing data objects
US7925246B2 (en) 2002-12-11 2011-04-12 Leader Technologies, Inc. Radio/telephony interoperability system
US8195714B2 (en) 2002-12-11 2012-06-05 Leaper Technologies, Inc. Context instantiated application protocol
US7380217B2 (en) * 2003-06-06 2008-05-27 Intellecspace Coropration Method of graphical presentation of relationships between individuals, business entities, and organizations
US7287037B2 (en) * 2003-08-28 2007-10-23 International Business Machines Corporation Method and apparatus for generating service oriented state data mapping between extensible meta-data model and state data including logical abstraction
US7313572B2 (en) * 2003-09-30 2007-12-25 Oracle International Corporation Attribute partitioning for user extensibility
US7284235B2 (en) * 2003-10-15 2007-10-16 Microsoft Corp Creation of content versions using content layers
US7379945B1 (en) 2003-10-20 2008-05-27 International Business Machines Corporation Virtual foldering system for blending process and content in a collaborative environment
US20050091271A1 (en) * 2003-10-23 2005-04-28 Kasy Srinivas Systems and methods that schematize audio/video data
US8965936B2 (en) 2004-02-26 2015-02-24 Comcast Cable Holdings, Llc Method and apparatus for allocating client resources to multiple applications
US7289997B1 (en) * 2004-04-23 2007-10-30 Sun Microsystems, Inc. System and method for an extensible metadata driven application framework
US7213022B2 (en) * 2004-04-29 2007-05-01 Filenet Corporation Enterprise content management network-attached system
KR100622130B1 (en) * 2004-12-21 2006-09-19 한국전자통신연구원 Crash recovery system and method for a distributed file server using object based storage
AU2006271465A1 (en) * 2005-07-20 2007-01-25 Renovo Limited Data storage method
US8356053B2 (en) * 2005-10-20 2013-01-15 Oracle International Corporation Managing relationships between resources stored within a repository
US20070143250A1 (en) * 2005-12-20 2007-06-21 Beckman Coulter, Inc. Adaptable database system
US8046677B2 (en) * 2006-01-30 2011-10-25 International Business Machines Corporation Displaying relationships between tabular data using spatial identifiers
KR100705600B1 (en) * 2006-03-13 2007-04-09 삼성전자주식회사 Database managing apparatus and method in element management system
DE102006034407A1 (en) * 2006-07-25 2008-01-31 Robert Bosch Gmbh Update procedure for databases, in particular navigation databases
US7730088B2 (en) * 2006-09-14 2010-06-01 International Business Machines Corporation Queriable hierarchical text data
US7552127B2 (en) * 2006-12-19 2009-06-23 International Business Machines Corporation System and method for providing platform-independent content services for users for content from content applications leveraging Atom, XLink, XML Query content management systems
CA2676279A1 (en) 2007-01-22 2008-07-31 Syracuse University Distributed video content management and sharing system
US7702644B2 (en) 2007-01-25 2010-04-20 Ludi Labs, Inc. Data management system and method to host applications and manage storage, finding and retrieval of typed items with support for tagging, connections, and situated queries
US8355972B2 (en) * 2007-04-17 2013-01-15 Intellectspace Corporation Systems and methods for displaying information about financial markets
US20080270458A1 (en) * 2007-04-24 2008-10-30 Gvelesiani Aleksandr L Systems and methods for displaying information about business related entities
US7925645B2 (en) * 2007-07-19 2011-04-12 Microsoft Corporation Dynamic metadata filtering for classifier prediction
WO2010115204A2 (en) * 2009-04-03 2010-10-07 Wishlist Holdings Limited System and method for building and using member hierarchy structures
US20110216640A1 (en) * 2009-07-17 2011-09-08 James Curtis Universal multimedia distribution, storage, and playback systems, and methods
US9047288B2 (en) * 2012-01-06 2015-06-02 Apple Inc. Intelligent data delivery and storage based on data characteristics
CN104035943B (en) * 2013-03-08 2018-07-06 联想(北京)有限公司 Store the method and respective server of data
CN105760372A (en) * 2014-12-15 2016-07-13 中兴通讯股份有限公司 Conversion method and conversion device for object-oriented model data
CN106484404A (en) * 2016-09-23 2017-03-08 北京赢点科技有限公司 Content Management System and the method for custom content model and attribute
EP3451190B1 (en) * 2017-09-04 2020-02-26 Sap Se Model-based analysis in a relational database
CN112883249B (en) * 2021-03-26 2022-10-14 瀚高基础软件股份有限公司 Layout document processing method and device and application method of device

Family Cites Families (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5560005A (en) * 1994-02-25 1996-09-24 Actamed Corp. Methods and systems for object-based relational distributed databases
US6466992B2 (en) * 1994-12-07 2002-10-15 Next Computer, Inc. Method for providing stand-in objects
US6078925A (en) 1995-05-01 2000-06-20 International Business Machines Corporation Computer program product for database relational extenders
US5913205A (en) * 1996-03-29 1999-06-15 Virage, Inc. Query optimization for visual information retrieval system
US5907846A (en) * 1996-06-07 1999-05-25 Electronic Data Systems Corporation Method and system for accessing relational databases using objects
US6078926A (en) * 1997-12-18 2000-06-20 Persistence Software, Inc. Method and apparatus for performing multi-class object fetch in a database management system
US6263342B1 (en) 1998-04-01 2001-07-17 International Business Machines Corp. Federated searching of heterogeneous datastores using a federated datastore object
US6233586B1 (en) 1998-04-01 2001-05-15 International Business Machines Corp. Federated searching of heterogeneous datastores using a federated query object
US6272488B1 (en) 1998-04-01 2001-08-07 International Business Machines Corporation Managing results of federated searches across heterogeneous datastores with a federated collection object
WO2000045294A1 (en) 1999-01-27 2000-08-03 British Broadcasting Corporation Broadcast media metadata structure
JP2000250791A (en) * 1999-03-03 2000-09-14 Nec Corp Method and device for displaying message in dml object reproduction mode and recording medium with this method programmed and recorded therein
US6732331B1 (en) * 2000-02-15 2004-05-04 Vlad Alexander System and process for managing content organized in a tag-delimited template using metadata
US7668798B2 (en) * 2000-04-04 2010-02-23 Red Hat, Inc. System and method for accessing data in disparate information sources
GB0015896D0 (en) 2000-06-28 2000-08-23 Twi Interactive Inc Multimedia publishing system
US6647396B2 (en) * 2000-12-28 2003-11-11 Trilogy Development Group, Inc. Classification based content management system

Also Published As

Publication number Publication date
WO2003075176A3 (en) 2005-03-17
AU2003215716A1 (en) 2003-09-16
CN100470538C (en) 2009-03-18
EP1530762A2 (en) 2005-05-18
KR20040086346A (en) 2004-10-08
US20030172049A1 (en) 2003-09-11
WO2003075176A2 (en) 2003-09-12
CN1653449A (en) 2005-08-10
JP4222947B2 (en) 2009-02-12
JP2006507554A (en) 2006-03-02
BR0308269A (en) 2007-01-09
US7043490B2 (en) 2006-05-09
CA2477126C (en) 2011-07-26
KR100745442B1 (en) 2007-08-03

Similar Documents

Publication Publication Date Title
CA2477126A1 (en) Support for multiple content-management data models
JP2006507554A5 (en)
Martinez et al. Integrating data warehouses with web data: A survey
US9747360B2 (en) Mapping non-relational database objects into a relational database model
US8311998B2 (en) System and methods for facilitating a linear grid database with data organization by dimension
US6662188B1 (en) Metadata model
WO2006064383A3 (en) Automated relational schema generation within a multidimentional enterprise software system
US20040243618A1 (en) Methods and systems for auto-partitioning of schema objects
WO2005029247A3 (en) Computer systems and methods for platform independent presentation design
US20130097151A1 (en) Transformation of complex data source result sets to normalized sets for manipulation and presentation
US20080086478A1 (en) Semantical partitioning of data
US20120169713A1 (en) Automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model
US20090319487A1 (en) Scalar representation for a logical group of columns in relational databases
CN105404634A (en) Key-Value data block based data management method and system
WO2013175422A4 (en) Methodology supported business intelligence (bi) software and system
WO2013154521A1 (en) Creating an archival model
US20050198011A1 (en) System and method for managing presentation of data
US20110022629A1 (en) Data access
US7860879B2 (en) SMO scripting optimization
SE0202593D0 (en) A Computer program product and associated methods for searching a database of objects, connecting objects in such a database, and exporting data from at least arbitrary database
Eshtay et al. Implementing bi-temporal properties into various NoSQL database categories
Sreemathy et al. Data validation in ETL using TALEND
Pedersen Managing complex multidimensional data
El-Sayed et al. Efficiently supporting order in XML query processing
Chebotko et al. XML subtree reconstruction from relational storage of XML documents

Legal Events

Date Code Title Description
EEER Examination request
MKEX Expiry

Effective date: 20230214

MKEX Expiry

Effective date: 20230214