Abstracting Business Logic into Centralized Database Controls

• US 20100269088A1
• Filed: 04/20/2009
• Published: 10/21/2010
• Est. Priority Date: 04/20/2009
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Salz, Richard Donald, Rush, Jon, Sandberg, Michael John, Tate, Kay Anderson
• Granted Patent: US 8,924,921 B2
• Time in Patent Office: Days
• US Class Current: 717/104
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Methods, systems, and products for abstracting business logic into centralized database controls are disclosed herein. In one general embodiment, a method, executed by a computer system, includes identifying data use code in business logic: analyzing the data use code to determine a general data model: and implementing the general data model in the centralized database controls. The general data model is an abstraction embodying the functionality inherent in the data use code. In specific embodiments, identifying data use code in the business logic may be carried out by identifying the data use code in at least one subcomponent of the business logic, such as a user interface code component, a database coding, a table, or a file. The computer system may remove the data use code from the business logic or designate the data use code for removal.

Claims

1. A computer-implemented method for abstracting business logic into centralized database controls, the method comprising:

identifying data use code in the business logic;

analyzing the data use code to determine a general data model;

implementing the general data model in the centralized database controls.

2. The method of claim 1 wherein identifying data use code in the business logic comprises identifying the data use code in at least one subcomponent of the business logic selected from the group of a user interface code component, a data table, a file, and a database coding.

3. The method of claim 1 further comprising designating the data use code for removal from the business logic.

4. The method of claim 1 further comprising removing the data use code from the business logic.

5. The method of claim 1 wherein analyzing the data use code comprises consolidating a plurality of instances of the data use code into the general data model.

6. The method of claim 5 wherein identifying the data use code in business logic comprises identifying instances of the data use code in subcomponents of the business logic of at least two types selected from the group of business logic code, user interface code, a data table, database coding, and a file.

7. The method of claim 1 wherein the data use code comprises constraint checking code and implementing the general data model comprises creating database triggers.

8. The method of claim 1 wherein the data use code comprises a business rule implementation and implementing the general data model comprises creating stored procedures.

9. The method of claim 1 wherein the data use code comprises data model information and implementing the general data model comprises creating data base artifacts.

10. A computer program product disposed on a computer-readable medium for abstracting business logic into centralized database controls, the computer program product comprising:

computer program instructions for identifying data use code in the business logic;

computer program instructions for analyzing the data use code to determine a general data model; and

computer program instructions for implementing the general data model in the centralized database controls.

11. The computer program product of claim 10 wherein computer program instructions for identifying data use code in the business logic comprise computer program instructions for identifying the data use code in at least one subcomponent of the business logic selected from the group of a user interface code component, a data table, a file, and a database coding.

12. The computer program product of claim 10 further comprising computer program instructions for designating the data use code for removal from the business logic.

13. The computer program product of claim 10 further comprising computer program instructions for removing the data use code from the business logic.

14. The computer program product of claim 10 wherein computer program instructions for analyzing the data use code comprise computer program instructions for consolidating a plurality of instances of the data use code into the general data model.

15. The computer program product of claim 14 wherein computer program instructions for identifying the data use code in the business logic comprise computer program instructions for identifying instances of the data use code in subcomponents of the business logic of at least two types selected from the group of business logic code, user interface code, a data table, database coding, and a file.

16. The computer program product of claim 10 wherein the data use code comprises constraint checking code and computer program instructions for implementing the general data model comprise computer program instructions for creating database triggers.

17. The computer program product of claim 10 wherein the data use code comprises a business rule implementation and computer program instructions for implementing the general data model comprise computer program instructions for creating stored procedures.

18. The computer program product of claim 10 wherein the data use code comprises data model information and computer program instructions for implementing the general data model comprise computer program instructions for creating data base artifacts.

19. A system for abstracting business logic into centralized database controls, the system comprising:

a processor; and

a computer memory operatively coupled to the processor, the computer memory having disposed within it;

computer program instructions for identifying data use code in the business logic;

computer program instructions for analyzing the data use code to determine a general data model; and

computer program instructions for implementing the general data model in the centralized database controls.

20. The system of claim 19 wherein computer program instructions for identifying data use code in the business logic comprise computer program instructions for identifying the data use code in at least one subcomponent of the business logic selected from the group of a user interface code component, a data table, a file, and a database coding.