×

FUNCTION IN A RELATIONAL DATABASE

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

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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×