Content management system and methodology featuring query conversion capability for efficient searching
First Claim
1. A method of searching data including hierarchical metadata in a content management system, the content management system containing a plurality of items comprising hierarchical item metadata, and the content management system defining a tree-based hierarchical relationship between child components of the plurality of items, the method comprising:
- receiving a hierarchical query string in context of the tree-based hierarchical relationship; and
translating the hierarchical query string into a relational database query string, the relational database query string defining interrelationships between associated relational database tables, wherein the step of translating the hierarchical query string comprises identifying a root of the hierarchical metadata, and extracting the interrelationships between the associated relational database tables based on the tree-based hierarchical relationship of the child components.
1 Assignment
0 Petitions
Accused Products
Abstract
A content management system is provided including a library server in which user and system metadata is stored in a plurality of tables forming a tree-based storage hierarchy. The metadata is stored in a first data format compatible with a complex query language such as Structured Query Language (SQL). A query processor in the library server maps the first data format to a second data format which is compatible with a simpler query language such as XML query language. A client'"'"'s user experience is substantially simplified when queries are presented to the system.
-
Citations
21 Claims
-
1. A method of searching data including hierarchical metadata in a content management system, the content management system containing a plurality of items comprising hierarchical item metadata, and the content management system defining a tree-based hierarchical relationship between child components of the plurality of items, the method comprising:
-
receiving a hierarchical query string in context of the tree-based hierarchical relationship; and
translating the hierarchical query string into a relational database query string, the relational database query string defining interrelationships between associated relational database tables, wherein the step of translating the hierarchical query string comprises identifying a root of the hierarchical metadata, and extracting the interrelationships between the associated relational database tables based on the tree-based hierarchical relationship of the child components. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer-implemented content management system for searching hierarchical metadata, the computer-implemented content management system containing a plurality of items comprising hierarchical item metadata, and the computer-implemented content management system defining a tree-based hierarchical relationship between child components of the plurality of items, the computer-implemented content management system comprising:
-
a query processor adapted to process a hierarchical query string in context of the tree-based hierarchical relationship; and
a library server adapted to translate the hierarchical query string into a relational database query string, the relational database query string defining interrelationships between associated relational database tables, wherein translating the hierarchical query string comprises identifying a root of the hierarchical metadata and extracting the interrelationships between the associated relational database tables based on the tree-based hierarchical relationship of the child components of the plurality of items. - View Dependent Claims (13, 14)
-
-
15. A computer program product comprising a combination of code segments stored in a computer-readable memory and executable by a processor in a cache server, the computer program product comprising:
-
at least one code segment operable to receive a hierarchical query string for querying hierarchical metadata in a context of a tree-based hierarchical relationship in which a plurality of items comprise a plurality of child components; and
at least one code segment operable to translate the hierarchical query string into a relational database query string, the relational database query string defining interrelationships between associated relational database tables, wherein the at least one code segment operable to translate the hierarchical query string into the relational database query string comprises at least one code segment operable to identify a root of the hierarchical metadata and to extract the interrelationships between the associated relational database tables based on the tree-based hierarchical relationship of the child components of the plurality of items. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification