Processor configured to process data in a database by simultaneously processing row data of key pairs which include a key of a first table in the database, and a matching key and a unique row of a second table in the database
A processor is also provided for processing data in a database, wherein the database includes a first table and a second table. Each of the tables have a plurality of rows of data, wherein a key identifies one or more rows of data in the tables. There is a plurality of matching key pairs among the tables. Each key pair includes a key of a first table, and a matching key and a unique row of a second table. In operation, row data of key pairs associated with a first row of the second table are simultaneously processed, and row data of key pairs associated with any remaining rows of the second table in sequential row order are then simultaneously processed.
1 . A processor configured to process data in a database, wherein the database includes a first table and a second table, each of the tables having a plurality of rows of data, wherein a key identifies one or more rows of data in the tables, and wherein there is a plurality of matching key pairs among the tables, each key pair including (i) a key of a first table, and (ii) a matching key and a unique row of a second table, wherein the processor is configured to:
(a) simultaneously process row data of key pairs associated with a first row of the second table of the database; and
(b) simultaneously process row data of key pairs associated with any remaining rows of the second table of the database in sequential row order.
2 . The processor of claim 1 wherein the processing of the row data includes reading, updates, inserts.
3 . The processor of claim 1 wherein the data in the database is organized as sequential data.
4 . The processor of claim 1 wherein the data in the database is organized as non-sequential data.
5 . The processor of claim 1 wherein the keys of the first table are primary keys, and the keys of the second table are foreign keys.