Business constructs

• US 8,356,042 B1
• Filed: 01/18/2011
• Issued: 01/15/2013
• Est. Priority Date: 01/18/2011
• Status: Active Grant

• Current Assignee: The PNC Financial Services Group, Inc.
• Original Assignee: The PNC Financial Services Group, Inc.
• Inventors: Moncla, Brenda, Ghosh, Sujit
• Primary Examiner(s): Wu, Yicun
• Application Number:
  US13/008,684
• Time in Patent Office: 728 Days
• Field of Search: 707/756, 717/120, 709/202, 709/217, 709/246, 709/219, 709/232
• US Class Current: 707/756
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

Various systems, processes, tools and techniques are provided for managing and processing data within a computing environment including a data warehouse component. Certain embodiments of the business construct of the invention can provide an interim stage for mapping data prior to loading the data into the data warehouse. When embodied as standard interface files, each of the business constructs can represent a business object that is of importance to a corporate entity or other enterprise.

Claims

1. A method for processing data, the method comprising:

storing at least one business construct in a computer-readable medium operatively associated with an enterprise information platform;

at least one data mart in the enterprise information platform supporting analytical requirements of a business function related to a corporate entity associated with the enterprise information platform;

at least one analytic engine in the enterprise information platform performing analyses related to the business function of the corporate entity, the at least one analytic engine in the enterprise information platform being operatively associated with the at least one data mart; and

the at least one business construct mapping data from at least one data source independent of the enterprise information platform at a stage prior to loading the data from the at least one data source into a data warehouse component operatively associated with the enterprise information platform; and

wherein the at least one business construct is a standard interface file (“

SIF”

) that communicates data into an enterprise data exchange layer of the enterprise information platform and that comprises multiple attributes representing a business object of the corporate entity, wherein the attributes of the business object are commonly applicable to multiple versions of the same object across multiple data sources; and

executing, with a processor of the enterprise platform, the at least one business construct for loading the mapped data into the data warehouse component.

2. The method of claim 1, further comprising transmitting data loaded by the business construct through at least one information architecture component associated with the business object of the corporate entity.

3. The method of claim 1, wherein the at least one data source is a data source associated with a financial institution and the method further comprising translating data communicated between the enterprise information platform and the data source using the business construct, wherein the translating comprises translating the data in the data source from banking data warehouse entity relationship structures of the financial institution to information structures that are standardized for the enterprise information platform.

4. The method of claim 1, further comprising programming the business construct to include all attributes common to the business object of the corporate entity on which the business construct is based.

5. The method of claim 1, wherein the at least one business construct comprises data associated with an asset class and the asset class is at least one of mitigants, revolving loans, installment loans, and mortgages.

6. The method of claim 1, further comprising using the at least one business construct for mapping, organizing, and integrating organized and unorganized data managed by multiple data source systems that are independent of the enterprise information platform into a format for processing by at least one component operatively associated with the enterprise information platform.

7. The method of claim 1, wherein the at least one data mart comprises SIF derived data related to functional asset classes.

8. The method of claim 1, wherein the at least one analytic engine performing analyses comprises the at least one analytic engine implementing data derived from the at least one business construct.

9. The method of claim 1, further comprising using at least one staging standard interface file as an interface between the enterprise information platform and one or more of a plurality of data sources that are independent of the enterprise information platform.

10. The method of claim 1, wherein the at least one data mart supporting analytical requirements of the business function comprises supporting generating reports associated with the business function of the corporate entity using the at least one business construct.

11. The method of claim 1, wherein the at least one business construct is a plurality of business constructs, and the method further comprising the enterprise information platform receiving data from a plurality of source data systems using the plurality of business constructs.

12. The method of claim 11, wherein data stored in at least one of the source data systems is not compatible with data stored in at least one other different source data system.

13. The method of claim 1, further comprising communicating data into an enterprise data exchange layer for storing data derived from multiple business constructs in the at least one data mart based on a classification.

14. The method of claim 13, wherein the classification is selected from the group consisting of product, line of business, and functional asset family.

15. The method of claim 1, wherein the business object of the corporate entity is a business object in the financial services industry.

16. The method of claim 1, further comprising determining the business object of the corporate entity based upon an asset class of a financial institution.

17. The method of claim 1, further comprising transforming the data in the at least one data source into a standard set of information within the at least one business construct that describes business operations of the corporate entity, loading the data into the data warehouse component of the corporate entity, and applying the data to at least one pre-existing downstream process of the corporate entity.

18. The method of claim 17, wherein applying the data to the pre-existing downstream process of the corporate entity comprises generating integrated reporting based on the at least one business construct.

19. The method of claim 1, wherein the corporate entity is a financial services provider, and wherein the at least one analytic engine in the enterprise information platform performing analyses related to the business function of the corporate entity comprises the at least one analytic engine performs calculations associated with the financial services provider.

20. The method of claim 1, wherein the corporate entity is a financial services provider and the at least one data source is associated with an entity that was previously acquired by the financial services provider.