Query task processing based on memory allocation and performance criteria
First Claim
Patent Images
1. A system for maximizing memory and processing efficiencies in a computer system, the system comprising:
- one or more processors; and
computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including;
receiving, at one of the one or more processors, a digital request from a client computer;
creating and storing, in a computer storage, data in a plurality of column sources;
creating and storing, in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and
at the one of the one or more processors, providing operations including;
a select query operation, the select query operation comprising;
receiving a select query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object;
creating and storing, in the computer memory separate from the computer storage, the second table object;
creating and storing, in the computer memory, a copy of the subset of rows assigned to the second table object;
creating and storing in the computer memory separate from the computer storage a second table object index mapping the copy of the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and
storing, in a result column in the computer storage, a result set from executing a formula in the form of a subset of rows assigned to the second table object, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula.
3 Assignments
0 Petitions
Accused Products
Abstract
Described are methods, systems and computer readable media for query task operations based on memory allocation and performance criteria.
519 Citations
42 Claims
-
1. A system for maximizing memory and processing efficiencies in a computer system, the system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; receiving, at one of the one or more processors, a digital request from a client computer; creating and storing, in a computer storage, data in a plurality of column sources; creating and storing, in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and at the one of the one or more processors, providing operations including; a select query operation, the select query operation comprising; receiving a select query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing, in the computer memory separate from the computer storage, the second table object; creating and storing, in the computer memory, a copy of the subset of rows assigned to the second table object; creating and storing in the computer memory separate from the computer storage a second table object index mapping the copy of the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing, in a result column in the computer storage, a result set from executing a formula in the form of a subset of rows assigned to the second table object, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (2)
-
-
3. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; receiving, at one of the one or more processors, on a query server computer, a digital request from a client computer; creating and storing, in a computer storage, data in a plurality of column sources; creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and at the one of the one or more processors, providing operations including; an update query operation, the update query operation comprising; receiving an update query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a-result column in the computer storage, a result set from executing a formula in the form of a map, thereby reducing repeat processing time for re-executing the formula. - View Dependent Claims (4)
-
-
5. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; receiving, at one of the one or more processors, on a query server computer, a digital request from a client computer;
creating and storing, in a computer storage, data in a plurality of column sources;creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and at the one of the one or more processors, providing operations including; a view query operation, the view query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a-result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (6)
-
-
7. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; receiving, at one of the one or more processors, on a query server computer, a digital request from a client computer; creating and storing, in a computer storage, data in a plurality of column sources; creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and at the one of the one or more processors, providing operations including; an update view query operation, the update view query operation comprising; receiving a query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (8)
-
-
9. A method comprising:
-
creating and storing, in a computer storage data, a plurality of column sources; creating and storing, in a computer memory, a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and providing operations including; a select query operation, the select query operation comprising; receiving a select query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing, in the computer memory separate from the computer storage, the second table object; creating and storing, in the computer memory, a copy of the subset of rows assigned to the second table object; creating and storing in the computer memory separate from the computer storage a second table object index mapping the copy of the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing, for a result column in the computer storage, a result set from executing a formula in the form of a subset of rows assigned to the second table object, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (10)
-
-
11. A method comprising:
-
creating and storing in a computer storage data in a plurality of column sources; creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and providing operations including; an update query operation, the update query operation comprising; receiving an update query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a-result column in the computer storage, a result set from executing a formula in the form of a map, thereby reducing repeat processing time for re-executing the formula. - View Dependent Claims (12)
-
-
13. A method comprising:
-
creating and storing in a computer storage data in a plurality of column sources; creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and providing operations including; a view query operation, the view query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (14)
-
-
15. A method comprising:
-
creating and storing in a computer storage data in a plurality of column sources; creating and storing in a computer memory a first table object index mapping data in the plurality of column sources to a first table object, the computer memory having faster access time than the computer storage; and providing operations including; an update view query operation, the update view query operation comprising; receiving an update view query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory separate from the computer storage, the second table object; accessing in the computer memory separate from the computer storage the first table object index to the subset of rows assigned to the second table object; and storing, for a-result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (16)
-
-
17. A method comprising:
-
storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; creating and storing in the computer memory a copy of the subset of rows assigned to the second table object; creating and storing in the computer memory a second table object index mapping the copy of the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing, for a result column in the computer storage, a result set from executing a formula of the first table, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (18, 19, 20)
-
-
21. A method comprising:
-
storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; creating and storing in the computer memory a second table object index mapping the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing, for a result column in the computer storage, a result set from executing a formula of the first table, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (22, 23, 24, 25)
-
-
26. A method comprising:
-
storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage, wherein the first table object index is arranged according to a strict ordering; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; accessing in the computer memory the first table object index to the subset of rows assigned to the second table object; and storing, for a result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (27, 28)
-
-
29. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; creating and storing in the computer memory a copy of the subset of rows assigned to the second table object; creating and storing in the computer memory a second table object index mapping the copy of the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing a result column including storing a result set from executing a formula of the first table, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (30, 31, 32)
-
-
33. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; creating and storing in the computer memory a second table object index mapping the subset of rows assigned to the second table object to the one or more of the plurality of column sources from the first table object; and storing a result column including storing a result set from executing a formula of the first table, thereby eliminating repeat processing time for re-executing the formula and providing faster access to the subset of rows assigned to the second table object than access provided via repeat processing for re-executing the formula. - View Dependent Claims (34, 35, 36, 37)
-
-
38. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage, wherein the first table object index is arranged according to a strict ordering; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from one or more of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; accessing in the computer memory the first table object index to the subset of rows assigned to the second table object; and storing a result column including storing a formula configured to generate a result set, thereby reducing use of computer memory. - View Dependent Claims (39, 40)
-
-
41. A system comprising:
-
one or more processors; and computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; accessing in the computer memory the first table object index to the subset of rows assigned to the second table object; and storing a result column including storing a formula configured to generate a result set, thereby reducing use of computer memory.
-
-
42. A method comprising:
-
storing, in a computer memory, a first table object index mapping data in a plurality of column sources to a first table object, the data in the plurality of column sources being stored in a computer storage; and providing operations including; a query operation, the query operation comprising; receiving a query task to assign to a second table object a subset of rows from all of the plurality of column sources from the first table object; creating and storing in the computer memory the second table object; accessing in the computer memory the first table object index to the subset of rows assigned to the second table object; and storing, for a result column in the computer storage, a formula configured to generate a result set, thereby reducing use of computer memory.
-
Specification