DISPLAYING HIDDEN ROWS IN A DATABASE AFTER AN EXPIRATION DATE

• US 20120054223A1
• Filed: 08/30/2010
• Published: 03/01/2012
• Est. Priority Date: 08/30/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Konik, Rafal P., Theuer, Mark W., Venz, Michael A.
• Granted Patent: US 8,392,374 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries

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

1. A method comprising:

storing a first row of data in a database; and

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.

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:

hiding the first row with a first key until the current date is later than the hidden expiration date and until a second row with a second key is added to the database.

4. The method of claim 1, 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 a second row with a second key is preexisting in the database prior to the storing the first row of data in the database.

5. The method of claim 1, 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.

6. The method of claim 5, 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.

7. The method of claim 1, further comprising:

storing the hidden expiration date in the first row.

8. The method of claim 1, further comprising:

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

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

storing a first row of data in a database; and

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.

10. The computer-readable storage medium of claim 9, 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 a second row with a second key is added to the database.

11. The computer-readable storage medium of claim 9, 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 a second row with a second key is preexisting in the database prior to storing the first row of data in the database.

12. The computer-readable storage medium of claim 9, 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.

13. The computer-readable storage medium of claim 12, 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.

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

storing the hidden expiration date in the first row.

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

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

16. 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,

storing the hidden expiration date in the first row, and

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

17. The computer system of claim 16, 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 a second row with a second key is added to the database.

18. The computer system of claim 16, 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 a second row with a second key is preexisting in the database prior to the storing the first row of data in the database.

19. The computer system of claim 16, 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.

20. The computer system of claim 19, 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.