Abstracting business logic into centralized database controls

摘要

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.

主权项

1. A computer-implemented method for abstracting business logic in a legacy application into a relational database, the method comprising:
identifying the data use code in one or more subcomponents of the business logic comprising business logic code, user interface code, one or more data tables, one or more files, and database coding, the identifying the data use code comprising;
analyzing the business logic code for implementing a business rule; andanalysing the user interface code, the one or more data tables, the one or more files, and the database coding for constraint checking code and data model information,
wherein the business logic code contains a first instance of the data use code,wherein the user interface code contains a second instance of the data use code, andwherein the one or more files contain a third instance of the data use code; consolidating the first instance of the data use code in the business logic code and the second instance of the data use code in the user interface code to generate a first general data model; consolidating the third data code instance in the one or more files to generate a second general data model; implementing the first and the second general data models, in centralized database controls, comprising:
creating a stored procedure for the business rule implementation identified in the analyzed data use code;creating one or more database triggers for the constraint checking code identified in the analyzed data use code; andcreating a database artifact for the data model information identified in the analyzed data use code;