Displaying hidden rows in a database after an expiration date
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
13 Citations
11 Claims
-
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. - View Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8, 9)
-
-
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. - View Dependent Claims (11)
-
Specification