Patent ID: 8924921

Claim:
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; and analysing 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, and wherein 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; and creating a database artifact for the data model information identified in the analyzed data use code;