Systems and methods for data warehousing
AssigneeState Street Corporation
InventorsKevin Sullivan, Rajeev K. Jain, Kartikesh Herur
Life of this patent
Estimating the term…
Abstract
A system and method are disclosed for private cloud computing and for the development and deployment of cloud applications in the private cloud. The private cloud computing system and method of the present invention include as components at least a cloud controller, a cloud stack, Service Registry, and a cloud application builder.
Claims18
A system for business process outsourcing in a cloud computing environment, including
- a computer-implemented data warehouse that is capable of being accessed and operated by at least one computer system user client device that is connected to the cloud computing environment,
- the system comprising:
- a computer system capable of being connected to the cloud computing environment and capable of authorizing the at least one computer system user to connect predetermined access levels to the cloud computing environment;
- and
- the computer-implemented data warehouse further including:
- (A) a computer-implemented data acquisition layer configured to receive input data from at least one data source;
- (B) a computer-implemented platform layer including:
- (1) a data hub inbound layer configured to receive the input data from the at least one data source in a controlled and auditable manner, to perform preprocessing of the input data;
- (2) a core layer configured to receive the input data from the data hub inbound layer, the core layer including:
- (a) a processing engine configured to process the input data and to generate a plurality of data marts based on at least one model and at least one rule, wherein each of the data marts is a repository for data and is a subset of the data warehouse that pertains to data for a single department, business unit or specific use case, the processing engine being configured to apply meta-logic rules to process the input data, store the processed input data in successive interim data marts of at least one sequence of two or more interim data marts and transmit the processed input data from the interim data marts to the data marts for storage;
- (b) an at least one database for storing the processed data;
- (c) an at least one repository database storing the at least one model and the meta-logic rules-specified by the at least one computer system user;
- and
- (3) a data hub outbound layer configured to receive data from the plurality of data marts;
- and
- (C) an information delivery layer configured to receive the data from the plurality of data marts, to format the received data from the plurality of data marts, and to provide the formatted data from the plurality of data marts to the at least one computer system user.
A computer-implemented method for generating a data mart for deployment in a cloud environment that can be accessed by system user client devices having authorization to access the cloud environment, comprising the steps of:
- (A) creating with a first computer data elements directed to at least a plurality of information elements that are capable of being applicable to a plurality of businesses and storing such data elements in a first cloud environment database to form a searchable data element dictionary;
- (B) creating with the first computer a plurality of categories that include data elements retrieved from the data element dictionary, with creating each of the categories to include data elements relating to at least one predetermined business issue, and storing the plurality of categories in a second cloud environment database to form a searchable category library;
- (C) creating with the first computer at least one data mart that includes one or more categories retrieved from the categories library and integrating the data elements of the retrieved categories into the at least one data mart, with the data mart including information elements relating a plurality of predetermined business issues, wherein each of the data marts is a repository for data and is a subset of the data warehouse that pertains to data for a single department, business unit or specific use case, the integrating comprising applying meta-logic rules to process the data elements, store the processed data elements in successive interim data marts of at least one sequence of two or more interim data marts and transmit the processed input data from at least some of the interim data marts to the data mart for storage;
- and
- (D) the system user client device accessing and retrieving information elements from the data mart created at step (C) for system user consumption for use in the system user's business.
Dependencies are inferred from the claim text.