International Business Machines Corporation

Randy Richardt

Hui-I Hsiao

Kenneth Carlin Nelson

Tawei Hu

Alan T Yaung

James Lin

Lily Liang

Dwayne Lorenzo Richardson

Parag V Tijare

Ed Gallagher

A content management system is provided including a server computer and a client computer. The server includes a data repository and a stored procedure. The disclosed methodology provides a way of handling parameter passing of structured data for stored procedures in the system. The system is capable of both encoding data into a structured data format and decoding data from the structured data format. The structured data format employs a binary large object (BLOB) and character large object (CLOB) to achieve handling of fixed length binary data and variable length character data. Advantageously, the stored procedure interface need not be rewritten and customized for each stored procedure in the server.

Method and apparatus of parameter passing of structured data for stored procedures in a content management system

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.

Content management system and methodology featuring query conversion capability for efficient searching

Growing community of inventors

San Jose, CA, United States of America

Randy Richardt