Business constructs

• US 8,370,371 B1
• Filed: 01/18/2011
• Issued: 02/05/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,750
• Time in Patent Office: 749 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 system for processing data, the system comprising:

an enterprise information platform including at least one processor and at least one business construct stored in a computer-readable medium of the enterprise information platform;

at least one data mart in the enterprise information platform and 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 operatively associated with the at least one data mart and implementing data derived from the at least one business construct to perform analyses related to the business function of the corporate entity; 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 business object across multiple data sources; and

wherein the at least one business construct maps data from at least one data source at an interim stage prior to loading the data into a data warehouse component operatively associated with the enterprise information platform; and

wherein the at least one data mart supports generating reports associated with the business function of the corporate entity using the at least one business construct.

2. The system of claim 1, wherein the enterprise information platform is further programmed to transmit data loaded by the business construct through at least one information architecture component associated with the business object of the corporate entity.

3. The system of claim 1, wherein the at least one data source is a data source associated with a financial institution and the business construct translates the data in the at least one 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 system of claim 1, wherein the at least one business construct comprises attributes common to the business object of the corporate entity on which the business construct is based.

5. The system 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 system of claim 1, wherein the at least one business construct maps, organizes, and integrates 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 system of claim 1, wherein the at least one data mart comprises SIF derived data related to functional asset classes.

8. The system of claim 7, wherein the corporate entity is a financial services provider, and the at least one analytic engine performs calculations associated with the financial services provider.

9. The system of claim 1, further comprising at least one staging standard interface file programmed 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 system 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.

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

12. The system 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 system of claim 1, wherein the enterprise information platform is further programmed for 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 system of claim 13, wherein the classification is selected from the group consisting of product, line of business, and functional asset family.

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

16. The system of claim 1, wherein the business object of the corporate entity is an asset class of a financial institution.

17. A method for development of a data warehouse comprising:

defining at least one business construct as a standard interface file (“

SIF”

) having at least one predefined business domain attribute that represents a business object of a corporate entity, the at least one predefined business domain attribute of the business object being commonly applicable to multiple versions of the business object across multiple data sources;

mapping data in a source data system of an entity independent of the corporate entity to the business construct at an interim stage prior to loading the data into a data warehouse component operatively associated with an enterprise information platform of the corporate entity, the data warehouse component comprising a non-transitory computer readable medium;

transforming the data in the source data system 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 17, wherein the at least one business construct comprises at least one attribute of an asset class of a financial institution.

20. The method of claim 17, wherein the at least one business construct comprises a single business construct, and the single business construct standardizes content from a plurality of source data systems.