# US 8,572,063 B2 · Computer-implemented method for operating a database and corresponding computer-system

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

- Number: US 8,572,063 B2
- Document ID: US8572063B2
- Status: Granted
- Kind: B2
- Application number: 12/827,874
- Filed: 2010-06-30
- Published: 2011-06-30
- Granted: 2013-10-29
- Earliest claimed: 2009-06-30
- Assignees: Hasso-Plattner-Institut fur Softwaresytemtechnik GmbH
- Applicants: Hasso Plattner; Jens Krueger; Martin Grund; Alexander Zeier
- Inventors: Hasso Plattner; Jens Krueger; Martin Grund; Alexander Zeier
- Web page: https://patentgrep.com/patent/US8572063B2

## CPC

- G06F 16/2477: {Temporal data queries}
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The invention relates to a computer-implemented method for operating a database comprising the step of updating a binary status of a tuple in the database. The binary status field either contains a null value or a time stamp. The update can be done in-place or by using an insert-only approach.

## Claims

### Claim 1

A computer-implemented method for operating a database, comprising:
storing a tuple having a binary status field in the database;
updating a binary status of the tuple in the database by means of in-place updating the binary status field of the tuple with a time stamp;
executing, by a computer system, a query that uses the binary status field; and
outputting, by the computer system, a result of the query.

### Claim 2 (depends on 1)

The method according to claim 1, wherein the database is a column store database.

### Claim 3 (depends on 2)

The method according to claim 2, wherein the column containing the binary status fields is stored uncompressed.

### Claim 4

A computer-implemented method for operating a database, comprising:
storing a tuple having a binary status field in the database;
updating a binary status of the tuple in the database by means of inserting an updated tuple into the database, wherein the binary status field of the updated tuple contains a time stamp;
executing, by a computer system, a query that uses the binary status field; and
outputting, by the computer system, a result of the query.

### Claim 5 (depends on 4)

The method according to claim 4, wherein the database is a column store database.

### Claim 6 (depends on 5)

The method according to claim 5, wherein the column containing the binary status fields is stored uncompressed.

### Claim 7

A computer system that implements a computer program for operating a database, said computer system including a processor that is configured to execute the computer program and a memory that is configured to store the database, said computer program embodied on a non-transitive storage medium and comprising:
an updating component for updating a binary status of a tuple in the database by means of in-place updating the binary status field of the tuple with a time stamp;
an executing component for executing a query that uses the binary status field; and
an outputting component for outputting a result of the query.

### Claim 8

A computer system that implements a computer program for operating a database, said computer system including a processor that is configured to execute the computer program and a memory that is configured to store the database, said computer program embodied on a non-transitive storage medium and comprising:
an updating component for updating a binary status of a tuple in the database by means of inserting an updated tuple into the database, wherein the binary status field of the updated tuple contains a time stamp;
an executing component for executing a query that uses the binary status field; and
an outputting component for outputting a result of the query.