Database Reference
In-Depth Information
executed in this algorithm.
GTRQ
rows
denotes the retrieved rows from RDBMS after
executing the
GTRQ
queryStr
.
.
Store Rows in Array Algorithm: This subsidiary algorithm is used to store the
retrieved data from a CTT or a VET in a two-dimensional array. The number of array
rows corresponds a number of retrieved rows, and the number of array columns cor-
responds a number of retrieved columns. The column names are stored in the
rst
element of the two-dimensional array, and the columns
values are stored in the rest of
the array elements. The details of this algorithm are outlined in Algorithm 3.
'
Denition 3 (Store Rows in Array Algorithm).
SRA
rowsList
denotes a set of retrieved
rows from a CTT or a VET where each of these rows is denoted by
SRA
row
. Each
SRA
row
is a set of columns and each column is denoted by
SRA
col
.
SRA
rown
(
SRA
colm
)
denotes a value stored in the
SRA
colm
of the
SRA
rown
.
SRA
rowsListSize
denotes the size
of the
SRA
rowsList
.
SRA
rowSize
denotes the size of the
SRA
row
.
SRA
colNames
denotes a set of
column names of a CTT or a VET.
SRA
colNamesSize
denotes the size of the
SRA
colNames
.
SRA
array
denotes a two dimensional array to store the retrieved rows.
.
Search WWH ::
Custom Search