Method of automatically removing leading and trailing space characters from data being entered into a database system

• US 7,475,086 B2
• Filed: 05/31/2006
• Issued: 01/06/2009
• Est. Priority Date: 05/31/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: International Business Machines Corporation
• Inventors: Dinh, Hung T., Pham, Phong A., Hu, Teng
• Primary Examiner(s): NGUYEN, CAM LINH T
• Application Number:
  US11/421,132
• Publication Number:
  US 20070282849A1
• Time in Patent Office: 951 Days
• Field of Search: 707 1- 4, 707/10, 707100-1041, 382/309, 382/310
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2448 for particular applications; for extensibility, e.g. user defined types
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A computer Implemented method of automatically removing space characters from data being entered into a database system are provided. When a user creates a table in a database system into which data having leading and/or trailing character spaces may be entered, the user may specifically instruct the database system to remove any character spaces before entering the data into the table. Consequently, when a piece of data is being entered into the table, the database system will determine whether the piece of data includes leading and/or trailing character spaces. If so, the database system will automatically remove the character spaces from the piece of data before it is entered into the table. Hence, the use of TRIM functions when retrieving data from the database system will be obviated.

Claims

1. A computer implemented method of automatically removing space characters from data being entered into a database system comprising:

creating a table through which data is to be entered into the database system, the table having at least one column;

indicating upon creation of the table whether leading and trailing space characters from data being entered into the at least one column are to be removed;

enabling a user to issue an insert command in order to enter the data into the at least one column;

determining, in response to receiving the insert command, whether there is an indication associated with the at least one column that leading and trailing space characters from the data being entered into the at least one column are to be removed,

removing leading and trailing space characters from the data being entered into the at least one column if it is determined that there is an indication that leading and trailing space characters from the data being entered into the at least one column are to be removed;

leaving leading and trailing space characters from the data being entered into the at least one column if it is determined that there is not an indication that leading and trailing space characters from the data being entered into the at least one column are to be removed; and

entering the data into the at least one column.

2. The computer implemented method of claim 1 wherein indicating upon creation of the table whether leading and trailing space characters from data being entered into the at least one column are to be removed includes determining whether the data to be entered into the at least one column is character data.

3. The computer implemented method of claim 2 wherein the indication is a bit set in the at least one column.

4. The computer implemented method of claim 3 wherein the data is being entered to update data in the table.