IP Library › Granted Patent US 12,248,614
Granted Patent B2
US 12,248,614 · App. 18/411,993 · Granted Mar 11, 2025

Computer-implemented methods, apparatuses, and computer program products for frequency based operations

Inventors: Ananya Bandyopadhyay (Ranchi, IN); Shalini Jha (Hyderabad, IN)
Assignee: Wells Fargo Bank, N.A.
G06F21/6254G06F16/215G06F16/25G06F16/285
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 12,248,614
App. No.
18/411,993
Granted
Mar 11, 2025
Kind
B2
Abstract

Computer-implemented methods, apparatuses, and computer program products are provided for frequency based operations. An example computer-implemented method includes receiving a request for data transfer of a plurality of data elements of a production data environment to a non-production data environment. The method includes determining an access frequency associated with each data element and grouping each data element into a first set of data elements or a second set of data elements based upon the determined access frequency. The method further includes refreshing the first set of data elements according to a first refresh protocol defining a first refresh rate and refreshing the second set of data elements according to a second refresh protocol defining a second refresh rate less than the first refresh rate. The method also includes outputting the plurality of data elements to the non-production data environment.

Claims (63)

1. A computer-implemented method for optimization of frequency based operations, the computer-implemented method comprising:

generating a usage metric corresponding to usage of a plurality of data elements;

determining, based on the usage metric, an access frequency associated with each data element of the plurality of data elements;

grouping each data element of the plurality of data elements into a first set of data elements or a second set of data elements based upon the determined access frequency;

refreshing the first set of data elements according to a first refresh protocol defining a first refresh rate;

refreshing the second set of data elements according to a second refresh protocol, wherein the second refresh protocol defines a second refresh rate less than the first refresh rate; and

outputting the plurality of refreshed data elements to a non-production data environment.

2. The computer-implemented method according to claim 1 , wherein the non-production data environment is associated with a business domain from amongst a plurality of business domains.

3. The computer-implemented method according to claim 1 , wherein determining the access frequency associated with each data element further comprises:

determining an access count for each data element of the plurality of data elements;

comparing the access count for each data element of the plurality of data elements with a frequency threshold;

in an instance in which the access count satisfies the frequency threshold, grouping a data element of the plurality of data elements in the first set of data elements; and

in an instance in which the access count fails to satisfy the frequency threshold, grouping a data element of the plurality of data elements in the second set of data elements.

4. The computer-implemented method according to claim 3 , wherein the access count is determined based upon operations in a production data environment.

5. The computer-implemented method according to claim 3 , wherein the access count is determined based upon operations in the non-production data environment.

6. The computer-implemented method according to claim 1 , wherein grouping each data element further comprises:

determining one or more data dependencies associated with a first data element;

grouping the first data element into the first set of data elements based upon the determined access frequency; and

grouping a second data element into the first set of data elements based upon a data dependency between the first data element and the second data element.

7. The computer-implemented method according to claim 1 , wherein the first refresh protocol and the second refresh protocol employ one or more data masking or synthetic data generation operations associated with the first set of data elements and the second set of data elements, respectively.

8. The computer-implemented method according to claim 1 , wherein the first refresh protocol employs static data masking operations and the second refresh protocol employs dynamic data masking operations.

9. An apparatus for optimization of frequency based operations, the apparatus comprising:

access circuitry configured to:

generate a usage metric corresponding to usage of a plurality of data elements,

determine, based on the usage metric, an access frequency associated with each data element of the plurality of data elements, and

group each data element of the plurality of data elements into a first set of data elements or a second set of data elements based upon the determined access frequency;

transfer circuitry configured to:

refresh the first set of data elements according to a first refresh protocol defining a first refresh rate, and

refresh the second set of data elements according to a second refresh protocol, wherein the second refresh protocol defines a second refresh rate less than the first refresh rate; and

communications circuitry configured to output the plurality of refreshed data elements to a non-production data environment.

10. The apparatus according to claim 9 , wherein the non-production data environment is associated with a business domain from amongst a plurality of business domains.

11. The apparatus according to claim 9 , wherein the access circuitry is further configured to:

determine an access count for each data element of the plurality of data elements;

compare the access count for each data element of the plurality of data elements with a frequency threshold;

in an instance in which the access count satisfies the frequency threshold, group a data element of the plurality of data elements in the first set of data elements; and

in an instance in which the access count fails to satisfy the frequency threshold, group a data element of the plurality of data elements in the second set of data elements.

12. The apparatus according to claim 11 , wherein the access count is determined based upon operations in a production data environment.

13. The apparatus according to claim 11 , wherein the access count is determined based upon operations in the non-production data environment.

14. The apparatus according to claim 9 , wherein the access circuitry is further configured to:

determine one or more data dependencies associated with a first data element;

group the first data element into the first set of data elements based upon the determined access frequency; and

group a second data element into the first set of data elements based upon a data dependency between the first data element and the second data element.

15. The apparatus according to claim 9 , wherein the transfer circuitry is further configured to employ one or more data masking or synthetic data generation operations associated with the first set of data elements and the second set of data elements as defined by the first refresh protocol and the second refresh protocol, respectively.

16. The apparatus according to claim 9 , wherein the transfer circuitry is further configured to employ static data masking operations as defined by the first refresh protocol and employ dynamic data masking operations as defined by the second refresh protocol.

17. A non-transitory computer-readable storage medium for optimization of frequency based operations, the non-transitory computer-readable storage medium storing instructions that, when executed, cause an apparatus to:

generate a usage metric corresponding to usage of a plurality of data elements;

determine, based on the usage metric, an access frequency associated with each data element of the plurality of data elements;

group each data element of the plurality of data elements into a first set of data elements or a second set of data elements based upon the determined access frequency;

refresh the first set of data elements according to a first refresh protocol defining a first refresh rate;

refresh the second set of data elements according to a second refresh protocol, wherein the second refresh protocol defines a second refresh rate less than the first refresh rate; and

output the plurality of refreshed data elements to a non-production data environment.

18. The non-transitory computer-readable storage medium according to claim 17 storing instruction that, when executed, cause the apparatus to:

determine an access count for each data element of the plurality of data elements;

compare the access count for each data element of the plurality of data elements with a frequency threshold;

in an instance in which the access count satisfies the frequency threshold, group a data element of the plurality of data elements in the first set of data elements; and

in an instance in which the access count fails to satisfy the frequency threshold, group a data element of the plurality of data elements in the second set of data elements.

19. The non-transitory computer-readable storage medium according to claim 17 storing instruction that, when executed, cause the apparatus to:

determine one or more data dependencies associated with a first data element;

group the first data element into the first set of data elements based upon the determined access frequency; and

group a second data element into the first set of data elements based upon a data dependency between the first data element and the second data element.

20. The non-transitory computer-readable storage medium according to claim 17 storing instruction that, when executed, cause the apparatus to:

employ static data masking operations in performing the first refresh protocol; and

employ dynamic data masking operations in performing the second refresh protocol.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 12, 2024
From: BANDYOPADHYAY, ANANYA; JHA, SHALINI
To: WELLS FARGO BANK, N.A.
Reel/Frame 067708/0364 →
Continuity (2)
Continuation 17242718 · Apr 28, 2021
Related Publication 20240152650A1 · May 9, 2024
References Cited (57)
US 7043636B2 · Smeets · 2006 [cited by applicant]
US 7370140B2 · Sartore · 2008 [cited by applicant]
US 8363519B2 · Lubbers · 2013 [cited by applicant]
US 8677320B2 · Wilson · 2014 [cited by applicant]
US 8797798B2 · Conley · 2014 [cited by applicant]
US 8930381B2 · Raghunathan · 2015 [cited by examiner]
US 9058430B2 · Pal · 2015 [cited by applicant]
US 9123422B2 · Yu · 2015 [cited by applicant]
US 9268674B1 · Ben-Cnaan · 2016 [cited by applicant]
US 9317219B2 · Kawakita · 2016 [cited by applicant]
US 9317411B2 · Kalyanasundram · 2016 [cited by applicant]
US 9355703B2 · Lee · 2016 [cited by applicant]
US 9356966B2 · Patwardhan · 2016 [cited by applicant]
US 9432298B1 · Smith · 2016 [cited by applicant]
US 9720616B2 · Yu · 2017 [cited by applicant]
US 9741016B2 · Chen · 2017 [cited by applicant]
US 9865313B2 · Bahramshahry · 2018 [cited by examiner]
US 10013336B2 · Shah · 2018 [cited by applicant]
US 10289533B2 · Kunz · 2019 [cited by applicant]
US 10324827B2 · Narayanan · 2019 [cited by applicant]
US 10339038B1 · Singh · 2019 [cited by examiner]
US 10454898B2 · Howard · 2019 [cited by applicant]
US 10467130B2 · Raghavan · 2019 [cited by applicant]
US 10467220B2 · Li · 2019 [cited by applicant]
US 10482004B2 · Angermayer · 2019 [cited by applicant]
US 10741143B2 · Dimitrov · 2020 [cited by applicant]
US 10754574B1 · Jo · 2020 [cited by examiner]
US 10790005B1 · He · 2020 [cited by applicant]
US 20060265338A1 · Rutkowski · 2006 [cited by examiner]
US 20130139003A1 · Patwardhan · 2013 [cited by examiner]
US 20140164405A1 · Tsai · 2014 [cited by applicant]
US 20140181982A1 · Guo · 2014 [cited by applicant]
US 20160147797A1 · Dolph · 2016 [cited by examiner]
US 20180176597A1 · Edpalm · 2018 [cited by applicant]
US 20190028531A1 · Nagar · 2019 [cited by examiner]
US 20190228763A1 · Czarnowski · 2019 [cited by applicant]
US 20190318205A1 · Loo · 2019 [cited by applicant]
US 20190377820A1 · Kruempelmann · 2019 [cited by applicant]
US 20200019489A1 · Shanmugam · 2020 [cited by applicant]
US 20200058346A1 · Ito · 2020 [cited by applicant]
US 20200089903A1 · Cachin · 2020 [cited by applicant]
US 20200110696A1 · Liegard · 2020 [cited by applicant]
US 20200311304A1 · Parthasarathy · 2020 [cited by examiner]
US 20200322127A1 · Lozac'H · 2020 [cited by applicant]
US 20200334268A1 · Vasireddy · 2020 [cited by examiner]
US 20220014351A1 · Jung · 2022 [cited by examiner]
CN 103870480A · 2014 [cited by applicant]
CN 110399733A · 2019 [cited by applicant]
WO 2018224277A1 · 2018 [cited by applicant]
WO 2019193479A1 · 2019 [cited by applicant]
WO 2020099046A1 · 2020 [cited by applicant]
Chao, Tan; “A Model-Based Approach to Generate Dynamic Synthetic Test Data,” 2019 12th IEEE Conference on Software Testing, Validation and Verification (ICST), Retrieved from http://dx.doi.org/10.1109/ICST.2019.00063, A… [cited by applicant]
Hamad, Haj et al.; “Scalable Quality and Testing Lab (SQTL): Mission-Critical Applications Testing,” 2019 International Conference on Computer and Information Sciences (ICCIS), Retrieved from http://dx.doi.org/10.1109/I… [cited by applicant]
Jain, Ruby et al.; “An Approach Towards the Development of Scalable Data Masking for Preserving Privacy of Sensitive Business Data,” Artificial Intelligence and Evolutionary Computations in Engineering Systems (AISC) vo… [cited by applicant]
Onu, Peter et al.; “Cloud Computing and IoT application: current statuses and prospect for industrial development,” 9th International Conference on Operations and Supply Chain Management, Vietnam 2019, retrieved from ht… [cited by applicant]
Kasturi, Santanam; “Some Aspects of Test Data Management Strategy,” 2020 IEEE International Conference on Computing, Power, and Computing Technologies (GUCON), Oct. 2-4, 2020, p. 6-11 (7 pages). [cited by applicant]
Price, Huw; “Moving Beyond the Masking and Subsetting: Realizing the Value of Test Data Management,” CA Technologies, Aug. 2015 (12 pages). [cited by applicant]