# US 2025/0165457 A1 · Data processing method and data processing device

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0165457 A1
- Document ID: US20250165457A1
- Status: Published application
- Kind: A1
- Application number: 18/413,002
- Filed: 2024-01-15
- Published: 2025-05-22
- Earliest claimed: 2023-11-16
- Assignees: Inventec (Pudong) Technology Corporation; Inventec Corporation
- Applicants: Inventec (Pudong) Technology Corp.; Inventec Corporation
- Inventors: Wei-Chao Chen; Ming-Chi Chang; Ghih-Pin Wei; Shu-Huei Yang
- Web page: https://patentgrep.com/patent/US20250165457A1

## CPC

- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A data processing method applied in a data center is provided. The data processing method includes obtaining stored procedures of a development environment, a data quality assurance system environment and a production environment and column information of all tables, for each stored procedure, analyzing the stored procedure and determining whether the stored procedure contains a wildcard, converting and restoring the stored procedure into a restored stored procedure with complete column information based on the wildcard, generating column lineage graphs of the development environment, the data quality assurance system environment and the production environment respectively according to the restored stored procedures of the development environment, the data quality assurance system environment and the production environment, comparing the column lineage graphs of the development environment, the data quality assurance system environment and the production environment to generate a comparison result and performing a notification function according to the comparison result.

## Claims

### Claim 1

A data processing method, applied in a data center, comprising:
obtaining stored procedures of a development environment, a data quality assurance system environment and a production environment and column information of all tables from the data center;
for each stored procedure, analyzing the stored procedure and determining whether the stored procedure contains a wildcard;
for each stored procedure, converting and restoring the stored procedure into a restored stored procedure with complete column information based on the wildcard;
generating column lineage graphs of the development environment, the data quality assurance system environment and the production environment respectively according to the restored stored procedures of the development environment, the data quality assurance system environment and the production environment; and
comparing the column lineage graphs of the development environment, the data quality assurance system environment and the production environment to generate a comparison result and performing a notification function according to the comparison result.

### Claim 2 (depends on 1)

The data processing method of claim 1, wherein the step of for each stored procedure converting and restoring the stored procedure into the restored stored procedure with complete column information based on the wildcard comprises:
analyzing contextual information of the wildcard in the stored procedure to determine whether the wildcard is included in a selection query statement;
when determining that the wildcard is in the selection query statement, determining a specified table to be queried in the selection query statement, wherein the selection query statement comprises a first clause and a second clause, the second clause is after the first clause, and the wildcard is in the first clause of the selection query statement, wherein the step comprises determining the specified table to be queried from the second clause of the selection query statement;
comparing the specified table with the obtained column information of all tables to determine all column information corresponding to the specified table; and
replacing the wildcard in the stored procedure with all column information corresponding to the specified table to generate the restored stored procedure with complete column information.

### Claim 3 (depends on 1)

The data processing method of claim 1, wherein the step of for each stored procedure, converting and restoring the stored procedure into the restored stored procedure with complete column information based on the wildcard comprises:
for each stored procedure, when determining that the stored procedure does not contain any wildcard, the stored procedure is outputted as the restored stored procedure.

### Claim 4 (depends on 1)

The data processing method of claim 1, wherein the step of generating column lineage graphs of the development environment, the data quality assurance system environment and the production environment respectively according to the restored stored procedures of the development environment, the data quality assurance system environment and the production environment comprises:
parsing each restored stored procedure to determine directed graphs of all columns of the restored stored procedure for each environment of the development environment, the data quality assurance system environment and the production environment; and
merging directed graphs of columns of all restored stored procedures in each environment to generate a column lineage graph for each environment.

### Claim 5 (depends on 4)

The data processing method of claim 4, wherein the step of merging the directed graphs of the columns of all restored stored procedures in each environment to generate the column lineage graph for each environment comprises:
when determining that a source column of a first restored stored procedure and a target column of a second restored stored procedure are the same column, merging a first node representing the source column of the first restored stored procedure and a second node representing the target column of the second restored stored procedure.

### Claim 6 (depends on 1)

The data processing method of claim 1, wherein the step of comparing the column lineage graphs of the development environment, the data quality assurance system environment and the production environment to generate the comparison result and performing the notification function according to the comparison result comprises:
comparing the column lineage graphs of at least two environments, source directed subgraphs or target directed subgraphs corresponding to at least one column of the column lineage graphs of at least two environments among the development environment, the data quality assurance system environment and the production environment to generate the comparison result; and
when the comparison result indicates that there is a difference between the column lineage graphs of two of the development environment, the data quality assurance system environment and the production environment, generating and sending a notification signal to execute the notification function.

### Claim 7

A data processing device, applied in a data center, comprising:
a storage device, configured to store instructions;
a processor circuit, configured to execute the instructions of:
obtaining stored procedures of a development environment, a data quality assurance system environment and a production environment and column information of all tables from the data center;
for each stored procedure, analyzing the stored procedure and determining whether the stored procedure contains a wildcard;
for each stored procedure, converting and restoring the stored procedure into a restored stored procedure with complete column information based on the wildcard;
generating column lineage graphs of the development environment, the data quality assurance system environment and the production environment respectively according to the restored stored procedures of the development environment, the data quality assurance system environment and the production environment; and
comparing the column lineage graphs of the development environment, the data quality assurance system environment and the production environment to generate a comparison result and performing a notification function according to the comparison result.

### Claim 8 (depends on 7)

The data processing device of claim 7, wherein the instructions further comprise:
analyzing contextual information of the wildcard in the stored procedure to determine whether the wildcard is included in a selection query statement;
when determining that the wildcard is in the selection query statement, determining a specified table to be queried in the selection query statement, wherein the selection query statement comprises a first clause and a second clause, the second clause is after the first clause, and the wildcard is in the first clause of the selection query statement, wherein the step comprises determining the specified table to be queried from the second clause of the selection query statement;
comparing the specified table with the obtained column information of all tables to determine all column information corresponding to the specified table; and
replacing the wildcard in the stored procedure with all column information corresponding to the specified table to generate the restored stored procedure with complete column information.

### Claim 9 (depends on 7)

The data processing device of claim 7, wherein the instructions further comprise:
for each stored procedure, when determining that the stored procedure does not contain any wildcard, the stored procedure is outputted as the restored stored procedure.

### Claim 10 (depends on 7)

The data processing device of claim 7, wherein the instructions further comprise:
parsing each restored stored procedure to determine directed graphs of all columns of the restored stored procedure for each environment of the development environment, the data quality assurance system environment and the production environment; and
merging directed graphs of columns of all restored stored procedures in each environment to generate a column lineage graph for each environment.

### Claim 11 (depends on 10)

The data processing device of claim 10, wherein the instructions further comprise:
when determining that a source column of a first restored stored procedure and a target column of a second restored stored procedure are the same column, merging a first node representing the source column of the first restored stored procedure and a second node representing the target column of the second restored stored procedure.

### Claim 12 (depends on 7)

The data processing device of claim 7, wherein the instructions further comprise:
comparing the column lineage graphs of at least two environments, source directed subgraphs or target directed subgraphs corresponding to at least one column of the column lineage graphs of at least two environments among the development environment, the data quality assurance system environment and the production environment to generate the comparison result; and
when the comparison result indicates that there is a difference between the column lineage graphs of two of the development environment, the data quality assurance system environment and the production environment, generating and sending a notification signal to execute the notification function.
