System and method for data abstraction using formatted system variables

• US 20080126291A1
• Filed: 08/11/2006
• Published: 05/29/2008
• Est. Priority Date: 08/11/2006
• Status: Active Grant

• Current Assignee: Adaptive Intelligence LLC
• Original Assignee: Adaptive Intelligence LLC
• Inventors: Lyle, James G.
• Granted Patent: US 8,561,019 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• 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 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.

2. The method of claim 1, wherein the dynamic statement is a dynamic SQL statement.

3. The method of claim 1, wherein a second parameter passed to the formatted variable abstraction procedure identifies the data items.

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

5. The method of claim 4, further comprising validating the length of the formatted data value.

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

invoking a data abstraction procedure from the business logic layer with at least one parameter identifying a formatted system variable;

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

building, if the package name and program name indicate a valid procedure, a dynamic statement within the data abstraction procedure that, upon execution, invokes the procedure to retrieve a formatted data value;

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

returning the formatted data value to the business logic layer.

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

accessing, from the invoked data abstraction 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.

11. A software product comprising instructions, stored on computer-readable 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 data abstraction procedure from the business logic layer with at least one parameter identifying a formatted system variable;

instructions for accessing, from the data abstraction procedure, a first database table 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 data abstraction procedure that, upon execution, invokes a procedure, identified by the program name and the package name, to retrieve a formatted data value;

instructions for retrieving, if the package name does not indicate a valid package, 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.

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

accessing, from the invoked data abstraction 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.

16. A system for data abstraction between a business logic layer and a data layer, comprising:

means for invoking a formatted variable abstraction procedure from the business logic layer;

means for passing 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;

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.

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 returning a status indicating success or failure of returning the formatted data value.

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