Basic HTML version of Foils prepared 7 October 97

Foil 13 Relational Rules - 2

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


1 Rule 2: Access rows by content only rule - we can only retrieve rows/columns by their content (attribute values that exist), i.e., there is no order defined for the rows or columns
  • Example: you cannot issue the query 'get the 2nd row in the person_info_table',
    • or 'get the 1st column in all the rows of phone_list_table'.
  • You can only do 'get the row from person_info_table whose pid equals to 2 ',
    • or 'get the column values of all the rows in phone_list_table where the column is named as phone no '

in Table To:


© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998