System for categorical data encoding

• US 10,275,182 B2
• Filed: 02/24/2016
• Issued: 04/30/2019
• Est. Priority Date: 02/24/2016
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Kephart, Aaron D., Howie, Charles C., Glover, DeAundra K., Nutter, Darla, Lewis, Greg M., Price, Jesse A.
• Primary Examiner(s): Hasan, Syed H
• Application Number:
  US15/052,689
• Publication Number:
  US 20170242629A1
• Time in Patent Office: 1,161 Days
• CPC Class Codes: G06F 16/2457 with adaptation to user needs
• CPC Class Codes: G06F 3/0608 Saving storage space on storage systems
• CPC Class Codes: G06F 3/064 Management of blocks
• CPC Class Codes: G06F 3/0641 De-duplication techniques
• CPC Class Codes: G06F 3/0661 Format or protocol conversion arrangements
• CPC Class Codes: G06F 3/067 Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]
• CPC Class Codes: G06F 3/0683 Plurality of storage devices

Abstract

Embodiments of the present invention relate to apparatuses, systems, methods and computer program products for a technology configuration system. Specifically, the system typically provides operational data processing of a plurality of records associated with information technology operational activities, for dynamic transformation of data and evaluation of interdependencies of technology resources. In other aspects, the system typically provides technical language processing of the plurality of records for transforming technical and descriptive data, and constructing categorical activity records. The system may be configured to achieve significant reduction in memory storage and processing requirements by performing categorical data encoding of the plurality of records. The system may employ a dynamic categorical data decoding process, which delivers a reduction in processing time when the encoded records are decoded for evaluating the exposure of technology change events to technology incidents and modifying such technology change events.

Claims

1. A computerized system for categorical data encoding, wherein the computerized system provides a data encoding module configured for systematic compression of data associated with information technology operational activities to reduce storage requirements, comprising:

a computer apparatus including at least one processor, at least one memory device, and a network communication device; and

categorical data encoding module stored in the at least one memory device comprising computer readable instructions, that when executed by the at least one processor, cause the at least one processor to;

retrieve a plurality of records regarding a plurality of information technology operational activities from an activity record database, wherein each record of the plurality of records is associated with a plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determine, for each record of the plurality of records, one or more first data fields and one or more second data fields of the plurality of data fields;

transform, for each data field of the plurality of data fields, the technology identifier data into a binary value;

encode using a categorical data encoding algorithm, for each record of the plurality of records, the binary values associated with the plurality of data fields into one or more encoded words, each encoded word comprising a predetermined number of characters; and

store an encoded record, for each record of the plurality of records, in the activity record database, wherein the encoded record comprises the one or more encoded words corresponding to the plurality of data fields associated with the record regarding the information technology operational activity.

2. The system of claim 1, wherein determining the one or more first data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the first data fields of the plurality of data fields, wherein the first data fields are associated with a predetermined first number of possible entries.

3. The system of claim 1, wherein determining the one or more second data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database;

determining the type of content for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the second data fields of the plurality of data fields, wherein the second data fields are associated with a second number of possible entries that is greater than a predetermined threshold and/or the type of content in each of the second data fields comprises a predetermined content type.

4. The system of claim 1, wherein transforming the technology identifier data into a binary value, further comprises:

determining, for each first data field of the plurality of data fields, a predetermined first number of data sub-fields, wherein at least one data sub-field matches the technology identifier data of the first data field; and

assigning a binary value to each data sub-field based on the technology identifier data associated with the first data field.

5. The system of claim 4, wherein assigning a binary value to each data sub-field further comprises:

assigning a value of one for each data sub-field that matches the technology identifier data associated with the first data field; and

assigning a value of zero for each data sub-field that does not match the technology identifier data associated with the first data field.

6. The system of claim 1, wherein transforming the technology identifier data into a binary value, further comprises converting, for each second data field of the plurality of data fields, the technology identifier data associated with the second data field into a binary value.

7. The system of claim 1, wherein encoding the plurality of records regarding a plurality of information technology operational activities further comprises:

determining, for each record of the plurality of records, one or more categorical groups, wherein each categorical group is associated with one or more data fields of the plurality of data fields; and

encoding, for each categorical group of the one or more categorical groups, the binary values associated with the one or more data fields into an encoded word.

8. A computer program product for categorical data encoding, wherein the computer program product is configured for systematic compression of data associated with information technology operational activities to reduce storage requirements, comprising a non-transitory computer-readable storage medium having computer-executable instructions to:

retrieve a plurality of records regarding a plurality of information technology operational activities from an activity record database, wherein each record of the plurality of records is associated with a plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determine, for each record of the plurality of records, one or more first data fields and one or more second data fields of the plurality of data fields;

transform, for each data field of the plurality of data fields, the technology identifier data into a binary value;

encode using a categorical data encoding algorithm, for each record of the plurality of records, the binary values associated with the plurality of data fields into one or more encoded words, each encoded word comprising a predetermined number of characters; and

store an encoded record, for each record of the plurality of records, in the activity record database, wherein the encoded record comprises the one or more encoded words corresponding to the plurality of data fields associated with the record regarding the information technology operational activity.

9. The computer program product of claim 8, wherein determining the one or more first data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the first data fields of the plurality of data fields, wherein the first data fields are associated with a predetermined first number of possible entries.

10. The computer program product of claim 8, wherein determining the one or more second data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database;

determining the type of content for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the second data fields of the plurality of data fields, wherein the second data fields are associated with a second number of possible entries that is greater than a predetermined threshold and/or the type of content in each of the second data fields comprises a predetermined content type.

11. The computer program product of claim 8, wherein transforming the technology identifier data into a binary value, further comprises:

determining, for each first data field of the plurality of data fields, a predetermined first number of data sub-fields, wherein at least one data sub-field matches the technology identifier data of the first data field; and

assigning a binary value to each data sub-field based on the technology identifier data associated with the first data field.

12. The computer program product of claim 11, wherein assigning a binary value to each data sub-field further comprises:

assigning a value of one for each data sub-field that matches the technology identifier data associated with the first data field; and

assigning a value of zero for each data sub-field that does not match the technology identifier data associated with the first data field.

13. The computer program product of claim 8, wherein transforming the technology identifier data into a binary value, further comprises converting, for each second data field of the plurality of data fields, the technology identifier data associated with the second data field into a binary value.

14. The computer program product of claim 8, wherein encoding the plurality of records regarding a plurality of information technology operational activities further comprises:

determining, for each record of the plurality of records, one or more categorical groups, wherein each categorical group is associated with one or more data fields of the plurality of data fields; and

encoding, for each categorical group of the one or more categorical groups, the binary values associated with the one or more data fields into an encoded word.

15. A computerized method for categorical data encoding, wherein the method is configured for systematic compression of data associated with information technology operational activities to reduce storage requirements, comprising:

retrieving a plurality of records regarding a plurality of information technology operational activities from an activity record database, wherein each record of the plurality of records is associated with a plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining, for each record of the plurality of records, one or more first data fields and one or more second data fields of the plurality of data fields;

transforming, for each data field of the plurality of data fields, the technology identifier data into a binary value;

encoding using a categorical data encoding algorithm, for each record of the plurality of records, the binary values associated with the plurality of data fields into one or more encoded words, each encoded word comprising a predetermined number of characters; and

storing an encoded record, for each record of the plurality of records, in the activity record database, wherein the encoded record comprises the one or more encoded words corresponding to the plurality of data fields associated with the record regarding the information technology operational activity.

16. The computerized method of claim 15, wherein determining the one or more first data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the first data fields of the plurality of data fields, wherein the first data fields are associated with a predetermined first number of possible entries.

17. The computerized method of claim 15, wherein determining the one or more second data fields further comprises:

analyzing, for each record of the plurality of records, the plurality of data fields comprising technology identifier data associated with an information technology operational activity;

determining the number of possible entries for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database;

determining the type of content for each of the plurality of data fields, based on retrieving technology identifier data from a categorical context database; and

determining the second data fields of the plurality of data fields, wherein the second data fields are associated with a second number of possible entries that is greater than a predetermined threshold and/or the type of content in each of the second data fields comprises a predetermined content type.

18. The computerized method of claim 15, wherein transforming the technology identifier data into a binary value, further comprises:

determining, for each first data field of the plurality of data fields, a predetermined first number of data sub-fields, wherein at least one data sub-field matches the technology identifier data of the first data field; and

assigning a binary value to each data sub-field based on the technology identifier data associated with the first data field.

19. The computerized method of claim 18, wherein assigning a binary value to each data sub-field further comprises:

assigning a value of one for each data sub-field that matches the technology identifier data associated with the first data field; and

assigning a value of zero for each data sub-field that does not match the technology identifier data associated with the first data field.

20. The computerized method of claim 15, wherein transforming the technology identifier data into a binary value, further comprises converting, for each second data field of the plurality of data fields, the technology identifier data associated with the second data field into a binary value.