# US 12,216,682 B2 · Method and device for validating data sets in a database

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

- Number: US 12,216,682 B2
- Document ID: US12216682B2
- Status: Granted
- Kind: B2
- Application number: 18/362,640
- Filed: 2023-07-31
- Published: 2024-02-08
- Granted: 2025-02-04
- Earliest claimed: 2022-08-04
- Assignees: Robert Bosch GmbH
- Applicants: Robert Bosch GmbH
- Inventors: Daniel Zander; Ajay Kumar Nagaraj; Christopher Juerges; David Huber; Joseph Trotta
- Web page: https://patentgrep.com/patent/US12216682B2

## CPC

- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/278: {Data partitioning, e.g. horizontal or vertical partitioning}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method is for validating a data set in a distributed database system in which the data set is stored distributedly on computers of the distributed database system. The method includes sending a request to one of the computers by a central computer. The request has a command to check for a given criterion of a partial data set of the data set on the computer to which the request was sent.

## Claims

### Claim 1

A computer-implemented method for validating a data set in a distributed database system, the distributed database system comprising a plurality of computers and a central computer, the method comprising:
storing the data set in the distributed database system, the data set including a table having a plurality of columns, each column of the plurality of columns being associated with a data type, each row of the data set having an entry, the data set being stored distributedly on the plurality of the computers with respect to the plurality of columns;
sending, with the central computer, a request to the plurality of computers, the request including a command to check a respective partial data set of the data set stored on each respective computer of the plurality of computers;
checking, with each respective computer of the plurality of computers, whether entries in an entire column of the respective partial data set satisfy a criterion;
returning, with each respective computer of the plurality of computers, a respective message to the central computer indicating a result of the checking of the respective partial data set; and
validating, with the central computer, the data set depending on the respective message received from each respective computer of the plurality of computers.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, wherein the central computer simultaneously sends the request to the plurality of computers.

### Claim 3 (depends on 1)

The computer-implemented method of claim 1, wherein the criterion is a data type of the respective partial data set or a nullability or property of the respective partial data set.

### Claim 4 (depends on 3)

The computer-implemented method of claim 3, wherein the criterion includes a range of values of the entries, a maximum/minimum length of the entries, or a property of a uniqueness of columns.

### Claim 5 (depends on 1)

The computer-implemented method of claim 1, wherein a device is configured to perform the method.

### Claim 6 (depends on 1)

The computer-implemented method of claim 1, wherein a computer program includes instructions that, when the computer program is executed by a computer, cause the computer to carry out the method.

### Claim 7 (depends on 6)

The computer-implemented method of claim 6, wherein the computer program is stored on a non-transitory machine-readable storage medium.