System and method for data abstraction using formatted system variables

• US 8,561,019 B2
• Filed: 08/11/2006
• Issued: 10/15/2013
• Est. Priority Date: 08/11/2006
• Status: Active Grant

• Current Assignee: Adaptive Intelligence LLC
• Original Assignee: Adaptive Intelligence LLC
• Inventors: Lyle, James G.
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): HAYIM, SAMUEL E
• Application Number:
  US11/502,849
• Publication Number:
  US 20080126291A1
• Time in Patent Office: 2,622 Days
• Field of Search: None
• US Class Current: 717/111
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A system, method and software product retrieve a formatted data value from a data layer to a business logic layer by invoking a formatted variable abstraction procedure from the business logic layer, passing at least one parameter to the formatted variable abstraction procedure (the at least one parameter identifying a formatted system variable), and building a dynamic statement based upon the formatted system variable such that execution of the dynamic statement: accesses a formatted variable table based upon the formatted system variable to locate information relating to the formatted system variable; retrieves one or more data items based upon the information; formats the data items to form the formatted data value based upon the information; and returns the formatted data value to the business logic layer.

Claims

1. A method for retrieving a formatted data value from a data layer to a business logic layer, comprising:

invoking a first procedure within the business logic layer the first procedure being a formatted variable abstraction procedure preprogrammed for a particular formatted variable;

passing at least one parameter to the first procedure, the at least one parameter identifying a formatted system variable; and

selecting, from a table of formatted variables and based upon the formatted system variable, a second procedure, the second procedure being a separate procedure from the first procedure;

building, within the first procedure, a dynamic statement to identify the second procedure from the table, such that execution, by the first procedure, of the dynamic statement invokes the second procedure to;

retrieve one or more data items from the data layer;

format the data items, within the second procedure, to form a formatted data value before returning from the dynamic statement; and

return the formatted data value to the dynamic statement, and return the formatted data value from the dynamic statement to the business logic layer via the first procedure,

wherein the at least one parameter includes one or more of tag name, key value, return status, return value, subject key value, and image.

2. The method of claim 1, wherein the first procedure returns an alternate fixed value when the second procedure is not found.

3. The method of claim 1, wherein a second parameter passed to the first procedure is passed to the second procedure by the dynamic statement to identify the data items.

4. The method of claim 1, wherein the returned formatted data value is only a string of characters.

5. The method of claim 1, wherein, for the formatted system variable, the table of formatted variables defines whether the returned formatted data value is user modifiable.

20. The system of claim 3, wherein the second parameter includes one or more of return status, return value, subject key value, and image.

6. A method for data abstraction between a business logic layer and a data layer, comprising:

invoking a first procedure from the business logic layer with at least one parameter identifying a formatted system variable, the first procedure being a data abstraction procedure preprogrammed for a particular data value;

accessing, from the first procedure, a first database table in the data layer to retrieve a database package name and a database program name of a second procedure based upon the formatted system variable, the second procedure being a separate procedure from the first procedure;

building, if the package name indicates that the second procedure is valid, a dynamic statement within the first procedure that, upon execution, invokes the second procedure within the data layer to retrieve and format a data value from the data layer procedure;

retrieving, if the package name and program name does not indicate the valid procedure, an alternate fixed value from the first database table based upon the formatted system variable and assigning it to the formatted data value; and

returning the formatted data value to the business logic layer,

wherein the at least one parameter includes one or more of tag name, key value, return status, return value, subject key value, and image.

7. The method of claim 6, the step of building comprising:

accessing, from the second procedure invoked within the first procedure, at least one additional database table based upon a second parameter to retrieve additional data for inclusion in the formatted data value.

8. The method of claim 6, wherein the dynamic statement is a dynamic SQL statement.

9. The method of claim 6, further comprising returning a status indicating success or failure of returning the formatted data value.

10. The method of claim 9, further comprising validating length of the data value before return.

21. The system of claim 7, wherein the second parameter includes one or more of return status, return value, subject key value, and image.

11. A software product comprising instructions, stored on physical computer-readable non-transitory media, wherein the instructions, when executed by a computer, perform steps for data abstraction between a business logic layer and a data layer, comprising:

instructions for invoking a first procedure from the business logic layer with at least one parameter identifying a formatted system variable, the first procedure being a data abstraction procedure preprogrammed for a particular data value;

instructions for accessing, from the first procedure, a first database table in the data layer to retrieve a package name and program name based upon the formatted system variable;

instructions for building, if the package name indicates a valid package, a dynamic statement within the first procedure that, upon execution, invokes a second procedure within the data layer, identified by the program name and the package name, to retrieve a formatted data value from the data layer and return the formatted data value from the dynamic statement, the second procedure being a separate procedure from the first procedure;

instructions for retrieving, if the package name does not indicate a valid package, an alternate fixed value for use as the formatted data value from the first database table based upon the formatted system variable; and

instructions for returning the formatted data value to the business logic layer,

wherein the at least one parameter includes one or more of tag name, key value, return status, return value, subject key value, and image.

12. The method of claim 11, the step of building comprising:

accessing, from the invoked first procedure, at least one additional database table based upon a second parameter to retrieve additional data for inclusion in the formatted data value.

13. The method of claim 11, wherein the dynamic statement is a dynamic SQL statement.

14. The method of claim 11, further comprising returning a status indicating success or failure of returning the formatted data value.

15. The method of claim 11, further comprising validating length of the data value before return.

22. The system of claim 12, wherein the second parameter includes one or more of return status, return value, subject key value, and image.

16. A system stored in a non-transitory computer-readable medium for data abstraction between a business logic layer of an application server and a data layer of a database server, wherein the application server and the database server are implemented by a computer, comprising:

means for invoking, within the application server, a formatted variable abstraction procedure from the business logic layer;

means for passing, within the application server, at least one parameter to the formatted variable abstraction procedure, the at least one parameter identifying a formatted system variable; and

means for building a dynamic statement based upon the formatted system variable such that execution of the dynamic statement within the application server;

accesses a formatted variable table within the database server based upon the formatted system variable to locate information within the data layer relating to the formatted system variable;

retrieves one or more data items from the database server based upon the information;

formats the data items to form the formatted data value based upon the information; and

returns the formatted data value to the business logic layer

wherein the parameter includes one or more of tag name, key value, return status, return value, subject key value, and image, and

means for returning a status indicating success or failure of returning the formatted data value.

17. The system of claim 16, wherein the dynamic statement is a dynamic SQL statement.

18. The system of claim 16, wherein a second parameter passed to the formatted variable abstraction procedure identifies the data items.

19. The system of claim 16, further comprising means for validating the length of the formatted data value.