IP Library Granted Patent US 10,671,628
Granted Patent B2
US 10,671,628 · App. 16/358,570 · Granted Jun 2, 2020

Systems and methods for data warehousing

Inventors: Kevin Sullivan (Cohasset, MA); Rajeev K. Jain (Wellesley, MA); Kartikesh Herur (Franklin, MA)
Assignee: STATE STREET BANK AND TRUST COMPANY
G06F16/254G06F9/5072G06F16/2455H04L41/0806
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,671,628
App. No.
16/358,570
Granted
Jun 2, 2020
Kind
B2
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.

Claims (38)

1. A system for business process outsourcing in a cloud computing environment, including

a data hub inbound layer configured to receive input data from at least one data source in a controlled and auditable manner, to perform preprocessing of the input data;

a core layer configured to receive the input data from the data hub inbound layer, the core layer including:

a processing engine configured to:

apply a first model and at least one rule of a first set of rules to the input data to generate a plurality of first level interim marts comprising first data, wherein the first data is input data processed in accordance with the at least one model and the at least one rule, and the first model and the first set of rules are defined and specific for the first level interim marts,

apply a second model and at least one rule from a second set of rules to the first data from the first level interim marts and second data from an additional source to generate second level interim marts comprising third data, wherein the third data is the first data and the second data processed in accordance with the second model and the one rule form the second set of rules, and the second model and the second set of rules are defined and specific for the second level interim marts, and

apply a third model and at least one rule from a third set of rules to the third data from the second level interim marts to generate a plurality of data marts comprising processed data, wherein the processed data is the third data processed in accordance with the at least the third model and the at least one rule from the third set of rules, and the third model and the third set of rules defined and specific for the plurality of data marts;

the processing engine to generate data lineage tracking from the at least one data source to the at least one computer system user, the data lineage tracking to track processing of the input data and second data through the first level interim marts, the second level interim marts, and the plurality of data marts to the at least one computer system user, the data lineage tracking to enable updating of at least one of the plurality of data marts based on changes in data; and

a data hub outbound layer configured to receive data from the plurality of data mart.

2. The system of claim 1 , wherein the at least one model and the at least one rule include being programmable by the at least one computer system user.

3. The system of claim 1 , wherein the data marts include being auto-refreshed on realtime basis.

4. The system of claim 1 , wherein the processing engine modifies the input data to create a new data set.

5. The system of claim 1 , wherein the input data includes being controlled and stored in the computer-implemented platform layer “As Of,” “As At,” or “Sysdate” from multiple sources and dynamically created hierarchies.

6. The system of claim 5 , wherein “Sysdate” includes a date and time data is entered into the system.

7. The system of claim 5 , wherein “As Of’ includes a date and time when reported data is correct.

8. The system of claim 7 , wherein “As At” includes an exact date and time “As Of’ data is inserted.

9. The system of claim 5 , wherein each input data includes an “As Of,” an “As At,” and a “Sysdate” time and date associated with it.

10. The system of claim 1 , wherein the system includes a multi-tenant environment.

11. The system of claim 1 , wherein the system includes being used concurrently by multiple system users.

12. The system of claim 11 , wherein multiple system users include being a combination of at least one computer system and at least one human user.

13. The system of claim 1 , wherein the system can be integrated in a cloud computing environment.

14. The system of claim 1 , further includes a security framework that further includes at least one of a single and a multifactor authentication option.

15. The system of claim 1 , wherein the information delivery layer further includes at least one data proxy is capable of being connected to standard BI tools.

16. The system of claim 15 , wherein the BI tools includes being be connected to the system through a secure web service cloud.

17. A computer-implemented method for generating data marts for deployment in a cloud environment that can be accessed by system user client devices having authorization to access the cloud environment, comprising:

receiving, by a computer-implemented data acquisition layer, input data from at least one data source in a controlled and auditable manner, to perform preprocessing of the input data;

applying, by a computer-implemented platform layer, at least one model from a plurality of models and at least one rule from a plurality of rules to the input data to generate a plurality of first level interim marts comprising first data, wherein the plurality of models and the plurality of rules are stored in an at least one repository database and the first data is input data processed in accordance with the at least one model and the at least one rule defined and specific for the plurality of first level interim marts;

applying, by a computer-implemented platform layer, at least one model from the plurality of models and at least one rule from the plurality of rules to the first data from the first level interim marts and second data from an additional source to generate second level interim marts comprising third data, wherein the third data is the first data and the second data processed in accordance with the at least one model and at least one rule defined and specific for the second level interim marts;

applying, by a computer-implemented platform layer, at least one model of the plurality of models and at least one rule of the plurality of rules to the third data from the second level interim marts to generate a plurality of data marts comprising processed data, wherein the processed data is the third data processed in accordance with the at least one model and the at least one rule defined and specific for the plurality of data marts;

generating, by a computer-implemented platform layer, data lineage tracking from the at least one data source to the at least one computer system user, the data lineage tracking to track processing of the input data and second data through the first level interim marts, the second level interim marts, and the plurality of data marts to the at least one computer system user, the data lineage tracking to enable updating of at least one of the plurality of data marts based on changes in data; and

receiving, by an information delivery layer, the processed data from the plurality of data marts.

18. The computer-implemented method of claim 17 , wherein the data marts include being auto-refreshed on realtime basis.

19. The computer-implemented method of claim 17 , wherein the input data includes being controlled and stored in the computer-implemented platform layer “As Of,” “As At,” or “Sysdate” from multiple sources and dynamically created hierarchies.

20. The computer-implemented method of claim 19 , wherein “Sysdate” includes a date and time data is entered into the system.

21. The computer-implemented method of claim 19 , wherein “As Of includes a date and time when reported data is correct.

22. The computer-implemented method of claim 21 , wherein “As At” includes an exact date and time “As Of’ data is inserted.

23. The computer-implemented method of claim 19 , wherein each input data includes an “As Of,” an “As At,” and a “Sysdate” time and date associated with it.

24. The computer-implemented method of claim 17 , comprising, enabling, via a security framework, a single and a multifactor authentication option for the system.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 9, 2022
From: SULLIVAN, KEVIN; JAIN, RAJEEV K.; HERUR, KARTIKESH
To: STATE STREET CORPORATION
Reel/Frame 059212/0852 →
Continuity (5)
Continuation 14824113 · Aug 12, 2015
Continuation In Part 13921856 · Jun 19, 2013
Continuation 13180487 · Jul 11, 2011
Provisional Application 61363092 · Jul 9, 2010
Related Publication 20190294613A1 · Sep 26, 2019
Cited By (2)
US 12,450,619 US 12,462,056