FUNCTION IN A RELATIONAL DATABASE

• US 20100005113A1
• Filed: 07/02/2008
• Published: 01/07/2010
• Est. Priority Date: 07/02/2008
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Lee, David P., Dinh, Hung T., Pham, Phong A., Hu, Teng
• Application Number:
  US12/166,502
• Publication Number:
  US 20100005113A1
• Time in Patent Office: Days
• US Class Current: 707/101
• CPC Class Codes: G06F 16/24553 of query operations

Abstract

A method of retrieval and presentation of data in denormalized format may include accessing a relational database of CHARACTER or VARCHAR data types in normal form, applying a database command SUMTEXT(column name, delimiter string) to the relational database, retrieving related sets of text strings from the relational database, truncating leading blanks and trailing blanks in each string, limiting the length of each string to a predetermined value, appending related strings using a delimiter string specified, and presenting denormalized data strings.

Claims

1. A method of retrieval and presentation of text data in denormalized format comprising:

accessing a relational database of CHARACTER or VARCHAR data types in normal form;

applying a database command SUMTEXT(column name, delimiter string) to said relational database;

retrieving related sets of text strings from said relational database;

truncating leading blanks and trailing blanks in each string;

limiting the length of each string to a predetermined value;

appending related strings using a delimiter string specified; and

presenting denormalized data string, wherein said presented data string is truncated at a predefined maximum length.