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

US7082455B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Tawei Hu · San Jose, US
• James Lin · Aliso Viejo, US
• Kenneth Carlin Nelson · Hollister, US
• Alan T. Yaung · San Jose, US
• Randy Richardt · San Jose, US
• Lily Liang · Shanghai, CN
• Ed Gallagher · San Jose, US
• Dwayne L. Richardson · San Francisco, US

Key dates

• Filing date: Apr 23, 2002
• Grant date: Jul 25, 2006
• Expiry date: Mar 20, 2024

Classification

• Technology area (CPC H): Electricity
• CPC primary: H04L69/06
• WIPO field: Digital communication
• WIPO sector: Electrical engineering

Abstract

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.