System and methods for facilitating a linear grid database with data organization by dimension
First Claim
1. A method for querying organized data, comprising:
- receiving a data query at a data query interface, wherein the data query references at least two dimensions of data;
providing at least one node associated with a first dimension of data referenced by the data query;
providing a set of memory storage locations associated with a second dimension of data referenced by the data query;
determining whether the data query requires accessing an external database;
if the data query requires accessing the external database, executing a first sequence, comprising;
creating an external filter query and an external support column query;
accessing the external database with the external filter query;
requesting data from the at least one node;
retrieving data from at least one memory storage location identified by the second dimension of data referenced by the data query;
accessing the external database with the external support column query; and
merging data received from the at least one node and the external database;
if the data query does not require accessing the external database, executing a second sequence, comprising;
requesting data from the at least one node, wherein the node executes one or more processes for retrieving the requested data from at least one memory storage location identified by the second dimension of data referenced by the data query; and
merging data received from the at least one node.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and methods for organizing and querying data within a linear grid management system. Data having multiple dimensions is associated with physical locations, where a first dimension is associated with a node and a second dimension is associated with a data storage identifier of a memory storage device. The data may have a third dimension which provides a field for ordering data within the memory storage device. Metadata may be used to map a logical table to data stored in the memory storage device. The data query may be divided into multiple subqueries, wherein each subquery is related directly to one node associated with a data storage identifier related to a memory storage device. A preSQL and postSQL process may be generated to access an external database. A dispatcher may manage data subrequests and a node may generate a unique and efficient parsing process from the received data subrequest.
-
Citations
26 Claims
-
1. A method for querying organized data, comprising:
-
receiving a data query at a data query interface, wherein the data query references at least two dimensions of data; providing at least one node associated with a first dimension of data referenced by the data query; providing a set of memory storage locations associated with a second dimension of data referenced by the data query; determining whether the data query requires accessing an external database; if the data query requires accessing the external database, executing a first sequence, comprising; creating an external filter query and an external support column query; accessing the external database with the external filter query; requesting data from the at least one node; retrieving data from at least one memory storage location identified by the second dimension of data referenced by the data query; accessing the external database with the external support column query; and merging data received from the at least one node and the external database; if the data query does not require accessing the external database, executing a second sequence, comprising; requesting data from the at least one node, wherein the node executes one or more processes for retrieving the requested data from at least one memory storage location identified by the second dimension of data referenced by the data query; and merging data received from the at least one node. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-readable medium for querying organized data having computer executable instructions for performing steps comprising:
-
receiving a data query at a data query interface, wherein the data query references at least two dimensions of data; providing at least one node associated with a first dimension of data referenced by the data query; providing a set of memory storage locations associated with a second dimension of data referenced by the data query; determining whether the data query requires accessing an external database; if the data query requires accessing the external database, executing a first sequence, comprising; creating an external filter query and an external support column query; accessing the external database with the external filter query; requesting data from the at least one node; retrieving data from at least one memory storage location identified by the second dimension of data referenced by the data query; accessing the external database with the external support column query; and merging data received from the at least one node and the external database; if the data query does not require accessing the external database, executing a second sequence, comprising; requesting data from the at least one node, wherein the node executes one or more processes for retrieving the requested data from at least one memory storage location identified by the second dimension of data referenced by the data query; and merging data received from the at least one node. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification