Apparatus and method for adjusting data sizes in database operations

• US 5,832,509 A
• Filed: 12/17/1996
• Issued: 11/03/1998
• Est. Priority Date: 12/17/1996
• Status: Expired due to Fees

• Current Assignee: Chrysler Corporation (Stellantis NV)
• Original Assignee: Chrysler Corporation (Stellantis NV)
• Inventors: Mortis, George, Cicala, William
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): HO, RUAY L
• Application Number:
  US08/767,885
• Time in Patent Office: 686 Days
• Field of Search: 707/1, 707/100, 707/200, 707/5, 707/10, 707/104, 707/206, 395/200.33, 395/200.57, 395/800.11, 395/674, 395/730, 364/146, 364/188, 364/189, 364/240, 364/164, 705/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

An apparatus for adjusting the size of data as it is exchanged between a computer program and a database in situations when the computer program and the database use different formats for the data which is to be exchanged. A datum transfer direction determinator determines whether the datum which has the incompatible data format is being transferred to the database or to the computer program. The determinator examines the database operation issued from the computer program to determine whether the computer program is to receive the datum as in the case of a retrieve database operation or the database is to receive the data as in the case of an insert database operation. Based upon the datum direction and a predetermined adjustment value, a data size adjuster then adjusts the size of the data to be compatible with the data size used by the intended recipient of the data.

Claims

1. An apparatus for adjusting the size of a datum being transferred between a computer program and a data store, said datum being transferred based upon a datum transfer command issued from said computer program, said datum transfer command operating upon said data store, said computer program using said datum with a first size, said data store using said datum with a second size, said first size differing from said second size, comprising:

a datum transfer direction determinator coupled to said computer program for determining a datum transfer direction, said datum transfer direction indicating whether said datum is being transferred to said computer program from said data store or said datum is being transferred to said data store from said computer program, said determining of said datum transfer direction being based upon said datum transfer command, said datum transfer direction being determined after said computer program has issued said datum transfer command; and

a data size adjuster coupled to said datum transfer direction determinator and to said computer program and to said data store for adjusting the size of said datum based upon the determined datum transfer direction and upon a predetermined data size adjustment value, said adjusting being performed after said datum transfer direction determinator has determined the datum transfer direction and before said datum transfer command has operated upon said data store, said adjusted size of said datum being equal to the first size or the second size depending upon the datum transfer direction.

2. The apparatus according to claim 1 wherein said datum transfer command is a database operation, said datum transfer direction determinator using a database operation determinator to determine the type of database operation to be performed upon said database by said computer program, said type of database operation being determined by analyzing said database operation after said computer program has sent said database operation and before said database has received said database operation, said data store being a database.

3. The apparatus according to claim 2 wherein said adjusted size of said datum is equal to the first size when said database operation is a retrieval database command, and wherein said adjusted size of said datum is equal to the second size when said database operation is an inserting or replacing database command.

4. The apparatus according to claim 2 further comprising an internal segment table and an internal key table, said internal segment table storing the name of said database, the name of said datum, and an adjustment size for said datum, said internal key table storing the name of said database, keys of said database, the name of said datum, and an adjustment size for said datum.

5. The apparatus according to claim 2 wherein said data size adjuster increases the size of said datum based upon said data size adjustment value, and wherein said data size adjuster decreases the size of said datum based upon said data size adjustment value, said data size adjustment value being indicative of the number of bytes to adjust the size of said datum.

6. The apparatus according to claim 2 wherein said data size adjuster adds a predetermined string to said datum when said data size adjuster is to increase the size of said datum, wherein the size of said predetermined string is based upon said data size adjustment value.

7. The apparatus according to claim 2 wherein said data size adjuster deletes a predetermined number of ending positions of said datum when said data size adjuster is to decrease the size of said datum, said predetermined amount being based upon said data size adjustment value.

8. The apparatus according to claim 2 wherein said data size adjuster adjusts the size of said datum within a predetermined input/output area.

9. A method for adjusting the size of a datum being transferred between a computer program and a data store, said datum being transferred based upon a datum transfer command issued from said computer program, said datum transfer command operating upon said data store, said computer program using said datum with a first size, said data store using said datum with a second size, said first size differing from said second size, comprising the steps of:

receiving the datum transfer command from said computer program;

determining a data transfer direction, said datum transfer direction indicating whether said datum is being transferred to said computer program from said data store or said datum is being transferred to said data store from said computer program, said determining of said datum transfer direction being based upon said datum transfer command;

adjusting the size of said datum based upon the determined datum transfer direction and upon a predetermined data size adjustment value, said adjusted size of said datum being equal to the first size or the second size depending upon the datum transfer direction; and

sending the datum in its adjusted data size to an intended recipient, said intended recipient being based upon said determined datum transfer direction.

10. The method according to claim 9 wherein said datum transfer command is a database operation, said method comprising the further step of determining the type of database operation to be performed upon said database by said computer program, said type of database operation being determined by analyzing said database operation after said computer program has sent said database operation and before said database has received said database operation, said data store being a database.

11. The method according to claim 10 wherein said adjusted size of said datum is equal to the first size when said database operation is a retrieval database command.

12. The method according to claim 10 wherein said adjusted size of said datum is equal to the second size when said database operation is an inserting or replacing database operation command.

13. The method according to claim 10 wherein an internal segment table stores the name of said database, the name of said datum, and an adjustment size for said datum, and wherein an internal key table stores the name of said database, keys of said database, the name of said datum, and an adjustment size for said datum.

14. The method according to claim 10 further comprising the steps of:

increasing the size of said datum based upon said data size adjustment value; and

decreasing the size of said datum based upon said data size adjustment value, said data size adjustment value being indicative of the number of bytes to adjust the size of said datum.

15. The method according to claim 10 further comprising the step of:

adding a predetermined string to said datum when the size of said datum is to be increased, wherein the size of said predetermined string is based upon said data size adjustment value.

16. The method according to claim 10 further comprising the step of:

deleting a predetermined number of ending positions of said datum by a predetermined amount when the size of said datum is to be decreased, said predetermined amount being based upon said data size adjustment value.

17. The method according to claim 10 further comprising the step of:

adjusting the size of said datum within a predetermined input/output area.

18. An apparatus for adjusting the size of a datum being transferred between a computer program and a data store, said datum being transferred based upon a datum transfer command issued from said computer program, said datum transfer command operating upon said data store wherein said datum transfer command is a database operation, said computer program using said datum with a first size, said data store using said datum with a second size, said first size differing from said second size, comprising:

a datum transfer direction determinator coupled to said computer program for determining a datum transfer direction, said datum transfer direction indicating whether said datum is being transferred to said computer program from said data store or said datum is being transferred to said data store from said computer program, said determining of said datum transfer direction being based upon said datum transfer command, said datum transfer direction being determined after said computer program has issued said datum transfer command, said datum transfer direction determinator using a database operation determinator to determine the type of database operation to be performed upon said database by said computer program, said type of database operation being determined by analyzing said database operation after said computer program has sent said database operation and before said database has received said database operation, said data store being a database; and

a data size adjuster coupled to said datum transfer direction determinator and to said computer program and to said data store for adjusting the size of said datum based upon the determined datum transfer direction and upon a predetermined data size adjustment value, said adjusting being performed after said datum transfer direction determinator has determined the datum transfer direction and before said datum transfer command has operated upon said data store, said adjusted size of said datum being equal to the first size or the second size depending upon the datum transfer direction, wherein said adjusted size of said datum is equal to the first size when said database operation is a retrieval database command.

19. The apparatus according to claim 18 further comprising:

an internal segment table, said internal segment table storing the name of said database, the name of said datum, and said adjustment size for said datum; and

an internal key table, said internal key table storing the name of said data base, keys of said database, the name of said datum, and said adjustment size for said datum.

20. The apparatus according to claim 18 wherein said data size adjuster increases the size of said datum based upon said data size adjustment value, and wherein said data size adjuster decreases the size of said datum based upon said data size adjustment value, said data size adjustment value being indicative of the number of bytes to adjust the size of said datum.

21. The apparatus according to claim 18 wherein said data size adjuster adds a predetermined string to said datum when said data size adjuster is to increase the size of said datum, wherein the size of said predetermined string is based upon said data size adjustment value.

22. The apparatus according to claim 18 wherein said data size adjuster deletes a predetermined number of ending positions of said datum when said data size adjuster is to decrease the size of said datum, said predetermined amount being based upon said data size adjustment value.

23. The apparatus according to claim 18 wherein said data size adjuster adjusts the size of said datum within a predetermined input/output area.

24. An apparatus for adjusting the size of a datum being transferred between a computer program and a data store, said datum being transferred based upon a datum transfer command issued from said computer program, said datum transfer command operating upon said data store wherein said datum transfer command is a database operation, said computer program using said datum with a first size, said data store using said datum with a second size, said first size differing from said second size, comprising:

a datum transfer direction determinator coupled to said computer program for determining a datum transfer direction, said datum transfer direction indicating whether said datum is being transferred to said computer program from said data store or said datum is being transferred to said data store from said computer program, said determining of said datum transfer direction being based upon said datum transfer command, said datum transfer direction being determined after said computer program has issued said datum transfer command, said datum transfer direction determinator using a database operation determinator to determine the type of database operation to be performed upon said database by said computer program, said type of database operation being determined by analyzing said database operation after said computer program has sent said database operation and before said database has received said database operation, said data store being a database; and

a data size adjuster coupled to said datum transfer direction determinator and to said computer program and to said data store for adjusting the size of said datum based upon the determined datum transfer direction and upon a predetermined data size adjustment value, said adjusting being performed after said datum transfer direction determinator has determined the datum transfer direction and before said datum transfer command has operated upon said data store, said adjusted size of said datum being equal to the first size or the second size depending upon the datum transfer direction, wherein said adjusted size of said datum is equal to the second size when said database operation is an inserting or replacing database command.

25. The apparatus according to claim 24 further comprising:

an internal segment table, said internal segment table storing the name of said database, the name of said datum, and said adjustment size for said datum; and

an internal key table, said internal key table storing the name of said database, keys of said database, the name of said datum, and said adjustment size for said datum.

26. The apparatus according to claim 24 wherein said data size adjuster increases the size of said datum based upon said data size adjustment value, and wherein said data size adjuster decreases the size of said datum based upon said data size adjustment value, said data size adjustment value being indicative of the number of bytes to adjust the size of said datum.

27. The apparatus according to claim 24 wherein said data size adjuster adds a predetermined string to said datum when said data size adjuster is to increase the size of said datum, wherein the size of said predetermined string is based upon said data size adjustment value.

28. The apparatus according to claim 24 wherein said data size adjuster deletes a predetermined number of ending positions of said datum when said data size adjuster is to decrease the size of said datum, said predetermined amount being based upon said data size adjustment value.

29. The apparatus according to claim 24 wherein said data size adjuster adjusts the size of said datum within a predetermined input/output area.

30. A method for adjusting the size of a datum being transferred between a computer program and a data store, said datum being transferred based upon a datum transfer command issued from said computer program, said datum transfer command operating upon said data store, wherein said datum transfer command is a database operation, said computer program using said datum with a first size, said data store using said datum with a second size, said first size differing from said second size, comprising the steps of:

receiving the datum transfer command from said computer program;

determining a data transfer direction, said datum transfer direction indicating whether said datum is being transferred to said computer program from said data store or said datum is being transferred to said data store from said computer program, said determining of said datum transfer direction being based upon said datum transfer command;

adjusting the size of said datum based upon the determined datum transfer direction and upon a predetermined data size adjustment value, said adjusted size of said datum being equal to the first size or the second size depending upon the datum transfer direction, wherein said adjusted size of said datum is equal to the first size when said database operation is a retrieval database command;

sending the datum in its adjusted data size to an intended recipient, said intended recipient being based upon said determined datum transfer direction; and

determining the type of database operation to be performed upon said database by said computer program, said type of database operation being determined by analyzing said database operation after said computer program has sent said database operation and before said database has received said database operation, said data store being a database.

31. The method according to claim 30 wherein said adjusted size of said datum is equal to the second size when said database operation is an inserting or replacing database operation command.

32. The method according to claim 30 wherein an internal segment table stores the name of said database, the name of said datum, and an adjustment size for said datum, and wherein an internal key table stores the name of said database, keys of said database, the name of said datum, and an adjustment size for said datum.

33. The method according to claim 30 further comprising the steps of:

increasing the size of said datum based upon said data size adjustment value; and

decreasing the size of said datum based upon said data size adjustment value, said data size adjustment value being indicative of the number of bytes to adjust the size of said datum.

34. The method according to claim 30 further comprising the step of:

adding a predetermined string to said datum when the size of said datum is to be increased, wherein the size of said predetermined string is based upon said data size adjustment value.

35. The method according to claim 30 further comprising the step of:

deleting a predetermined number of ending positions of said datum by a predetermined amount when the size of said datum is to be decreased, said predetermined amount being based upon said data size adjustment value.

36. The method according to claim 30 further comprising the step of:

adjusting the size of said datum within a predetermined input/output area.