ViewsLook again at the left column of the Object Browser. You already know what a table is - a storehouse for data of the same type. But what about those other terms? A view is a virtual table created by combining records from real tables. The records that make up a view remain in their original tables, but they can be accessed and searched through the view. What does this mean for you? If you're a database programmer, the difference is crucial. For the rest of you, the difference is... nothing. For the purpose of searching for data, a view is a table, and a table is a view. You can search views just like tables, by listing them in the from block. In fact, many of the so-called "tables" you have been using are actually views! The specObj "table" is actually a view created from the specObjAll table, which contains both good and bad spectra. The PhotoPrimary, Star, Galaxy, and Unknown databases are all views created from the PhotoObj table. You've been using these views all along! Try searching the same area of sky using the SpecObjAll table and the SpecObj view, or the PhotoObj table and Star, Galaxy, or Unknown views. What differences do you see? When you are ready to move on, click Next to learn about functions.
|
||
 |
