Database for a capture system
First Claim
1. A computer implemented method comprising:
- receiving a query for one or more objects captured by a capture system, wherein the capture system includes a tag database for storing tags that index captured objects in storage, the tag database comprising;
a first set of tables comprising a first input table for inserting tags within a first time range and a first search table for storing the tags, anda second set of tables comprising a second input table for inserting tags within a second time range, and a second search table for storing the tags, whereinthe second time range is larger than the first time range;
determining whether a query time range exceeds the first time range;
searching the first set of tables if the query time range does not exceed the first time range;
if the query time range exceeds the first time range, determining whether the query time range exceeds the second time range; and
searching the second set of tables if the query time range exceeds the first time range but does not exceed the second time range.
10 Assignments
0 Petitions
Accused Products
Abstract
A tag database storing tags indexing captured object can be searched efficiently. In one embodiment, such a search begins by receiving a query for one or more objects captured by a capture system, and determining whether a query time range exceeds a time range of a set of fast tables. In one embodiment, the invention further includes searching the set of fast tables if the query time range does not exceed the time range of the fast tables, the set of fast tables containing tags having meta-data related to captured objects. In one embodiment, the invention further includes searching a set of hourly tables if the query time range does exceed the time range of the fast tables. In one embodiment, the present invention further includes searching a set of daily tables if the query time range also exceeds the time range of the hourly tables.
399 Citations
20 Claims
-
1. A computer implemented method comprising:
-
receiving a query for one or more objects captured by a capture system, wherein the capture system includes a tag database for storing tags that index captured objects in storage, the tag database comprising; a first set of tables comprising a first input table for inserting tags within a first time range and a first search table for storing the tags, and a second set of tables comprising a second input table for inserting tags within a second time range, and a second search table for storing the tags, wherein the second time range is larger than the first time range; determining whether a query time range exceeds the first time range; searching the first set of tables if the query time range does not exceed the first time range; if the query time range exceeds the first time range, determining whether the query time range exceeds the second time range; and searching the second set of tables if the query time range exceeds the first time range but does not exceed the second time range. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. Logic encoded in non-transitory media that includes instructions for execution and when executed by a processor, is operable to perform operations comprising:
-
receiving a query for one or more objects captured by a capture system, wherein the capture system includes a tag database for storing tags that index captured objects in storage, the tag database comprising; a first set of tables comprising a first input table for inserting tags within a first time range and a first search table for storing the tags, and a second set of tables comprising a second input table for inserting tags within a second time range, and a second search table for storing the tags, wherein the second time range is larger than the first time range; determining whether a query time range exceeds the first time range; searching the first set of tables if the query time range does not exceed the first time range; if the query time range exceeds the first time range, determining whether the query time range exceeds the second time range; and searching the second set of tables if the query time range exceeds the first time range but does not exceed the second time range. - View Dependent Claims (12, 13, 14, 15)
-
-
16. An apparatus comprising:
-
a memory for storing data; and a processor operable to execute instructions associated with the data, wherein the processor and the memory cooperate, such that the apparatus is configured for; receiving a query for one or more objects captured by a capture system, wherein the capture system includes a tag database for storing tags that index captured objects in storage, the tag database comprising; a first set of tables comprising a first input table for inserting tags within a first time range and a first search table for storing the tags, and a second set of tables comprising a second input table for inserting tags within a second time range, and a second search table for storing the tags, wherein the second time range is larger than the first time range; determining whether a query time range exceeds the first time range; searching the first set of tables if the query time range does not exceed the first time range; if the query time range exceeds the first time range, determining whether the query time range exceeds the second time range; and searching the second set of tables if the query time range exceeds the first time range but does not exceed the second time range. - View Dependent Claims (17, 18, 19, 20)
-
Specification