IP Library › Granted Patent US 8,392,374
Granted Patent B2
US 8,392,374 · App. 12/871,113 · Granted Mar 5, 2013

Displaying hidden rows in a database after an expiration date

Inventors: Rafal P. Konik (Oronoco, MN); Mark W. Theuer (Rochester, MN); Michael A. Venz (Rochester, MN)
Assignee: International Business Machines Corporation
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,392,374
App. No.
12/871,113
Granted
Mar 5, 2013
Kind
B2
Abstract

In an embodiment, a first row of data is stored in a database. The first row of data is hidden until a current date is later than a hidden expiration date. An indication is returned, to a requestor, that the first row does not exist in response to a query from the requestor that specifies a key that identifies the first row if the current date is before the hidden expiration date. The first row is returned, to the requestor, in response to the query if the current date is after the hidden expiration date.

Claims (35)

1. A computer-implemented method comprising:

storing a first row of data in a database;

hiding the first row of data until a current date is later than a hidden expiration date, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises returning, to a requestor, an indication that the first row does not exist in response to a query from the requestor that specifies a key that identifies the first row if the current date is before the hidden expiration date and returning, to the requestor, the first row in response to the query from the requestor that specifies the key that identifies the first row if the current date is after the hidden expiration date and a second row with a second key has been added to the database, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date and until the second row with the second key is added to the database, wherein the second key is specified in a non-hidden row condition in the database and wherein truth of the non-hidden row condition is evaluated;

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date if another row with another key is preexisting in the database prior to the storing the first row of data in the database; and

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row until the current date is later than the hidden expiration date and a number of a plurality of rows with a first key are added before a first date.

2. The method of claim 1 , further comprising:

performing the storing the first row in response to a request that specifies the hidden expiration date.

3. The method of claim 1 , wherein the hiding the first row until the current date is later than the hidden expiration date further comprises:

if the number of the plurality of rows are not added before the first date, then changing the first date to a second date that is later than the second date and hiding the first row until the current date is later than the hidden expiration date and the number of a plurality of rows with the first key are added before the second date.

4. The method of claim 1 , further comprising:

storing the hidden expiration date in the first row.

5. The method of claim 1 , further comprising:

storing a view status in the first row that indicates whether the first row is hidden.

6. A computer-readable storage medium encoded with instructions, wherein the instructions when executed comprise:

storing a first row of data in a database;

hiding the first row of data until a current date is later than a hidden expiration date, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises returning, to a requestor, an indication that the first row does not exist in response to a query from the requestor that specifies a key that identifies the first row if the current date is before the hidden expiration date and returning, to the requestor, the first row in response to the query from the requestor that specifies the key that identifies the first row if the current date is after the hidden expiration date and a second row with a second key has been added to the database, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date and until the second row with the second key is added to the database, wherein the second key is specified in a non-hidden row condition in the database and wherein truth of the non-hidden row condition is evaluated;

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date if another row with another key is preexisting in the database prior to the storing the first row of data in the database; and

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row until the current date is later than the hidden expiration date and a number of a plurality of rows with a first key are added before a first date.

7. The computer-readable storage medium of claim 6 , wherein the hiding the first row until the current date is later than the hidden expiration date further comprises:

if the number of the plurality of rows are not added before the first date, then changing the first date to a second date that is later than the second date and hiding the first row until the current date is later than the hidden expiration date and the number of a plurality of rows with the first key are added before the second date.

8. The computer-readable storage medium of claim 6 , further comprising:

storing the hidden expiration date in the first row.

9. The computer-readable storage medium of claim 6 , further comprising:

storing a view status in the first row that indicates whether the first row is hidden.

10. A computer system, comprising:

a processor; and

memory communicatively coupled to the processor, wherein the memory is encoded with instructions that when executed on the processor comprise:

storing a first row of data in a database,

hiding the first row of data until a current date is later than a hidden expiration date, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises returning, to a requestor, an indication that the first row does not exist in response to a query from the requestor that specifies a key that identifies the first row if the current date is before the hidden expiration date and returning, to the requestor, the first row in response to the query from the requestor that specifies the key that identifies the first row if the current date is after the hidden expiration date and a second row with a second key has been added to the database, wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date and until the second row with the second key is added to the database, wherein the second key is specified in a non-hidden row condition in the database and wherein truth of the non-hidden row condition is evaluated,

storing the hidden expiration date in the first row,

storing a view status in the first row that indicates whether the first row is hidden,

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row with a first key until the current date is later than the hidden expiration date if another row with another key is preexisting in the database prior to the storing the first row of data in the database; and

wherein the hiding the first row until the current date is later than the hidden expiration date further comprises hiding the first row until the current date is later than the hidden expiration date and a number of plurality of rows with a first key are added before a first date.

11. The computer system of claim 10 , wherein the hiding the first row until the current date is later than the hidden expiration date further comprises:

if the number of the plurality of rows are not added before the first date, then changing the first date to a second date that is later than the second date and hiding the first row until the current date is later than the hidden expiration date and the number of a plurality of rows with the first key are added before the second date.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 30, 2010
From: KONIK, RAFAL P.; THEUER, MARK W.; VENZ, MICHAEL A.
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 024905/0780 →
Continuity (1)
Related Publication 20120054223A1 · Mar 1, 2012