Granted Patent B2

US 12,743,530 · App. 18/924,356 · Granted Sep 22, 2026

Inventors: Julia E Hart (East Windsor, CT); Louis Francis Neal (Philadelphia, PA); William L Cooper (Port St Joe, FL)

Assignee: HARTFORD FIRE INSURANCE COMPANY

G06F21/604G06F21/6227

Abstract

Claims (64)

1 . A cloud migration data discovery system implemented via a back-end application computer server, comprising:

a data store that contains electronic records, each electronic record representing a schema, and including, for each schema, a schema identifier, one or more schema table names included in the schema, and at least one database object parameter;

the back-end application computer server, coupled to the data store, including:

a computer processor; and

a computer memory, coupled to the computer processor, storing instructions that, when executed by the computer processor, cause the back-end application computer server to:

receive a request for information about at least one table, the request including at least a requested table name;

determine whether a corresponding table exists for the at least one requested table name, the determination based on a comparison of the requested table name to a first schema including the one or more schema table names;

identify an access role in a case the corresponding table exists, wherein the corresponding table is accessible based in part on the access role;

generate a view in response to the determination, wherein the view shows one of:

a) a database, a schema and a table name for each table, in a case the corresponding table exists, or

b) an indication the requested table name is not migrated to a cloud computing environment, in a case the corresponding table does not exist; and

a communication port coupled to the back-end application computer server to facilitate a transmission of data with remote user devices to support interactive user interface displays, including the generated views, via a distributed communication network.

2 . The system of claim 1 , wherein the schema represents tables migrated to a cloud computing environment.

3 . The system of claim 2 , further comprising instructions to, prior to generation of the view:

in a case the requested table name is not present in the first schema, transmit a query to the cloud computing environment, the query including the requested table name;

receive a response from the cloud computing environment, the response indicating one of: the requested table name is present in the cloud computing environment or the requested table name is absent from the cloud computing environment; and

generate the view.

4 . The system of claim 1 , wherein the determination the corresponding table exists is based on a match between the requested table name and the schema table name.

5 . The system of claim 4 , wherein the match is a same text in both the requested table name and the schema table name.

6 . The system of claim 1 , wherein the determination the corresponding table exists further comprises instructions to:

determine the requested table name does not match the schema table name;

identify an abbreviation in one of the requested table name and the schema table name;

translate the abbreviation;

generate a match candidate by replacing the abbreviation with the translation; and

determine the match candidate matches one of the requested table name or the schema table name.

7 . The system of claim 1 , wherein the determination the corresponding table exists further comprises instructions to:

perform a partial match search.

8 . The system of claim 1 , wherein the access role is linked to the schema table name.

9 . The system of claim 8 , wherein access provided by the access role is access for every table in the schema.

10 . The system of claim 8 , the access role grants at least one of read, create, update, delete and use privileges.

11 . A computer-implemented method comprising:

receiving a request for information about at least one table, the request including at least a requested table name;

determining whether a corresponding table exists for the at least one requested table name, the determination based on a comparison of the requested table name to a first schema including one or more schema table names, wherein the schema represents tables migrated to a cloud computing environment;

identifying an access role in a case the corresponding table exists, wherein the corresponding table is accessible based in part on the access role; and

generating a view in response to the determination, wherein the view shows one of:

a) a database, a schema and a table name for each table, in a case the corresponding table exists, or

b) an indication the requested table name is not migrated to the cloud environment, in a case the corresponding table does not exist.

12 . The method of claim 11 , further comprising, prior to generation of the view:

in a case the requested table name is not present in the first schema, transmitting a query to the cloud computing environment, the query including the requested table name;

receiving a response from the cloud computing environment, the response indicating one of: the requested table name is present in the cloud computing environment or the requested table name is absent from the cloud computing environment; and

generate the view.

13 . The method of claim 11 , wherein the determination the corresponding table exists is based on a match between the requested table name and the schema table name.

14 . The method of claim 11 , wherein the determination the corresponding table exists further comprises:

determining the requested table name does not match the schema table name;

identifying an abbreviation in one of the requested table name and the schema table name;

translating the abbreviation;

generating a match candidate by replacing the abbreviation with the translation; and

determining the match candidate matches one of the requested table name or the schema table name.

15 . The method of claim 11 , wherein the determination the corresponding table exists further comprises:

performing a partial match search.

16 . The method of claim 11 , wherein the access role is linked to the schema table name.

17 . The method of claim 16 , the access role grants at least one of read, create, update, delete modify and use privileges.

18 . One or more non-transitory computer-readable media storing program code that, when executed by a computing system, causes the computing system to perform operations comprising:

receiving a request for information about at least one table, the request including at least a requested table name;

determining whether a corresponding table exists for the at least one requested table name, the determination based on a comparison of the requested table name to a first schema including the one or more schema table names, wherein the schema represents tables migrated to a cloud computing environment;

identifying an access role in a case the corresponding table exists, wherein the corresponding table is accessible based in part on the access role; and

generating a view in response to the determination, wherein the view shows one of:

a) a database, a schema and a table name for each table, in a case the corresponding table exists, or

b) an indication the requested table name is not migrated to the cloud environment, in a case the corresponding table does not exist.

19 . The media of claim 18 , further comprising, prior to generation of the view:

in a case the requested table name is not present in the first schema, transmitting a query to the cloud computing environment, the query including the requested table name;

receiving a response from the cloud computing environment, the response indicating one of: the requested table name is present in the cloud computing environment or the requested table name is absent from the cloud computing environment; and

generate the view.

20 . The media of claim 18 , wherein the determination the corresponding table exists is based on a match between the requested table name and the schema table name.

Assignments (1)

Continuity (1)

References Cited (204)