The claimed subject matter provides a system and/or a method that facilitates paging and/or cursoring over the results of a query associated with a file storage system. An interface component can receive the query targeted to the file storage system including at least one key that relates to data. A
The claimed subject matter provides a system and/or a method that facilitates paging and/or cursoring over the results of a query associated with a file storage system. An interface component can receive the query targeted to the file storage system including at least one key that relates to data. A query component can enable cursoring over a query operation on a query result utilizing the key in order to provide an extended set of query operators.
대표청구항▼
What is claimed is: 1. A computer implemented system that facilitates paging over the results of a query, comprising: at least a processor; and a memory that retains a file storage system and code instructions, at least a portion of the code instructions when executed by at least the processor impl
What is claimed is: 1. A computer implemented system that facilitates paging over the results of a query, comprising: at least a processor; and a memory that retains a file storage system and code instructions, at least a portion of the code instructions when executed by at least the processor implement the following components: an interface component that receives the query targeted to the file storage system including a key that relates to data; and a query component that performs at least the following: generates a query result that includes an advanced key, wherein the advanced key is derived from the result of the query, but is not maintained from the input of the query, the advanced key comprising a value from one or more columns of each row in the query result that uniquely identifies each row in the query result; stores, using a row position component, the advanced key to maintain logical domain row currency without requiring the storage of the state of the file storage system, wherein the row position component maps a three-valued logic in the query into a two-valued representation of values utilized in a sort order; and processes requests for cursoring and paging on the query result over a set of query operations utilizing the advanced key that uniquely identifies each row in the query result, wherein cursoring includes querying the query result and paging includes forward scrolling, backward scrolling, and bookmark positioning. 2. The system of claim 1, further comprising an application that provides the query and cursors on the query result utilizing the advanced key. 3. The system of claim 2, wherein the application is at least one of the following: a client database application; an email client; a file system client; a database application; a pure database application; a web application; and an online catalog that displays data. 4. The system of claim 1, wherein the file storage system is at least one of the following: a database system; an object relational database system; a database-based file storage system that represents information as complex types; a structured data system; and an unstructured data system. 5. The system of claim 1, wherein query operators for which an advanced key is derived from the query result but not maintained from the input of the query include: the Rollup, Group By, and Sequence functions. 6. The system of claim 1, wherein the two-valued representation is utilized to compare at least one key related to a column. 7. The system of claim 1, wherein the row position component provides an ascend and a descend sort; variable-length data; a multiple column key; and an efficient comparison. 8. The system of claim 1, wherein the query component, the interface, and the file storage system runs on a server-side and an application that utilizes the query result with the advanced key to cursor runs on a client-side. 9. A computer-implemented method that facilitates paging over the results of a query, the method comprising: employing a processor to execute code instructions retained in a memory, the code instructions when executed by the processor effect acts comprising: generating a query result that includes an advanced key, wherein the advanced key is derived from the result of the query, but is not maintained from the input of the query, the advanced key comprising a value from one or more columns of each row in the query result that uniquely identifies each row in the query result; storing the advanced key to maintain logical domain row currency without requiring the storage of the state of the file storage system; mapping a three-valued logic in the query into a two-valued representation of values utilized in a short order; and processing requests for cursoring and paging on the query result over a set of query operations utilizing the advanced key that uniquely identifies each row in the query result, wherein cursoring includes querying the query result and paging includes forward scrolling, backward scrolling, and bookmark positioning. 10. The method of claim 9, the acts further comprising: generating the advanced key over a logical query processor operation tree. 11. A computer storage medium storing computer executable instructions which when executed by a processor perform the following acts: generating a query result that includes an advanced key, wherein the advanced key is derived from the result of the query, but is not maintained from the input of the query, the advanced key comprising a value from one or more columns of each row in the query result that uniquely identifies each row in the query result; storing the advanced key to maintain logical domain row currency without requiring the storage of the state of the file storage system; mapping a three-valued logic in the query into a two-valued representation of values utilized in a sort order; and processing requests for cursoring and paging on the query result over a set of query operations utilizing the advanced key that uniquely identifies each row in the query result, wherein cursoring includes querying the query result and paging includes forward scrolling, backward scrolling, and bookmark positioning. 12. The method of claim 9 wherein the cursoring comprises keyset cursoring.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (3)
Chang, Daniel T.; Donn, Siyi Terry; Hembry, Douglas Michael; Lee, Tae Jae; Soetarman, Basuki N.; Summers, Robert N.; Tung, Frank C., Federated searches of heterogeneous datastores using a federated datastore object.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Adding information or functionality to a rendered document via association with an electronic counterpart.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Aggregate analysis of text captures performed by multiple users from rendered documents.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Association of a portable scanner with input/output and storage devices.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Association of a portable scanner with input/output and storage devices.
King, Martin T.; Stephens, Redwood; Mannby, Claes-Fredrik; Peterson, Jesse; Sanvitale, Mark; Smith, Michael J., Automatically capturing information, such as capturing information using a document-aware device.
King, Martin T.; Stephens, Redwood; Mannby, Claes-Fredrik; Peterson, Jesse; Sanvitale, Mark; Smith, Michael J.; Daley-Watson, Christopher J., Automatically providing content associated with captured information, such as information captured in real-time.
King, Martin Towle; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Quentin, Capturing text from rendered documents using supplement information.
King, Martin Towle; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Quentin, Capturing text from rendered documents using supplemental information.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Determining actions involving captured information and electronic content associated with rendered documents.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Handheld device for capturing text from both a document printed on paper and a document displayed on a dynamic display device.
King, Martin T.; Stephens, Redwood; Mannby, Claes-Fredrik; Peterson, Jesse; Sanvitale, Mark; Smith, Michael J., Identifying a document by performing spectral analysis on the contents of the document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Methods and systems for initiating application processes by data capture from rendered documents.
King, Martin T.; Stephens, Redwood; Mannby, Claes-Fredrik; Peterson, Jesse; Sanvitale, Mark; Smith, Michael J., Performing actions based on capturing information from rendered documents, such as documents under copyright.
King, Martin T.; Stephens, Redwood; Mannby, Claes-Fredrik; Peterson, Jesse; Sanvitale, Mark; Smith, Michael J., Performing actions based on capturing information from rendered documents, such as documents under copyright.
King, Martin Towle; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Quentin, Processing techniques for text capture from a rendered document.
King, Martin T.; Kushler, Clifford A.; Stafford-Fraser, James Q.; Grover, Dale L., Processing techniques for visual capture data from a rendered document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Search engines and systems with handheld document data capture devices.
King, Martin Towle; Stafford-Fraser, James Quentin; Kushler, Clifford A.; Grover, Dale L., System and method for information gathering utilizing form identifiers.
Cotner, Curt L.; Iyer, Balakrishna R.; Kulkarni, Krishnarao G.; Lyle, Robert W., Technique to introduce advanced functional behaviors in a database management system without introducing new data types.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Triggering actions in response to optically or acoustically capturing keywords from a rendered document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Triggering actions in response to optically or acoustically capturing keywords from a rendered document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Triggering actions in response to optically or acoustically capturing keywords from a rendered document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Triggering actions in response to optically or acoustically capturing keywords from a rendered document.
King, Martin T.; Grover, Dale L.; Kushler, Clifford A.; Stafford-Fraser, James Q., Triggering actions in response to optically or acoustically capturing keywords from a rendered document.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.