|
|
Keywords:
Subset,
Query,
Table,
Virtual,
Representation
That which is seen or beheld; sight presented to the natural or intellectual eye; scene; prospect; as, the view from a window.
The pictorial representation of a scene; a sketch, either drawn or painted; as, a fine view of Lake George.
An alternative way of looking at the data in one or more tables. A view is usually created as a subset of the columns from one or more tables. In ODBC, views are generally equivalent to tables.
An alternative representation of data from one or more tables. A view can include all or some of the columns contained in the table on which it is defined.
A logical table whose data are not physically stored. A view is defined to access a subset of the columns stored in a row, access a set of columns stored in different rows, or avoid creating a redundant copy of data that is already stored.
As far as DataSplice is concerned, a view is the basic object that users see. In essence, a view is a configurable "window" into a database. This basically consists of a SQL statement defining the target data for the view as well as additional meta-information relating to how the view should be accessed and manipulated be the user. Unfortunately view is a fairly overloaded word in the context of databases. It is also usually used to describe a pre-configured statement in a database to provide a view of data that is not explicitly stored in a single table. In this context it is similar to a DataSplice view (a SQL Statement) except it does not define any of the additional information present in DataSplice views. In fact, DataSplice views can certainly be set up to access database views simply by providing a SQL statement that queries the latter. In many cases where complex SQL is needed to provide the desired data this is necessary for DataSplice to be able to perform the correct query. More Information
A "virtual table" that is generated "on-the-fly" when accessed.
An object that displays the data in a document. Windows are one type of view, although menus, dialogs, and graphs can be views, too.
viewable object.
1. The current display of information in the infobase. A full view displays the entire infobase (you may scroll from the top of the infobase to the bottom). A narrow view displays a sub-set of the infobase. 2. One of the predefined pane configurations for Cataloger's Desktop (normal, query, document, contents, and hit list).
A means of accessing a subset of the database as if it were a table. The view may: be restricted to named columns, be restricted to specific rows, change column names, derive new columns, and give access to a combination of related tables and/or views. Oracle, 1998. ()
A logical table that consists of data that is generated by a query.
A table display whose structure and content are derived from an existing table via a query.
A view is a document which displays data from a data table. You can also update and insert data into a data table via a view. A single data table can have multiple views, and each different view can display selected parts of the complete data table.
graphic art consisting of the graphic or photographic representation of a visual percept; "he painted scenes from everyday life"; "figure 2 shows photographic and schematic views of the equipment"
a (A) A Table in the database belonging to different schema
a convenience table that links to the underlying data through a SELECT statement
a database object, but it is a virtual table
a database object made up of columns from one or more database tables, combined into one logical table
a database object that looks and functions exactly like a table, except that it can contain data from multiple base tables
a data modelling concept that supports the formulation of queries that can span multiple JACK databases
a defined subset of a multi-element record which will be subsequently used for accessing data from the record
a derived table registered in the catalog
a dictionary object that you can use until you drop it
a local representation of the current membership of a group
a logical overlay over one or more tables
a logical representation of another table or combination of tables
a logical representation of a subset or superset of information in schema objects
a logical representation of data from one or more tables
a logical representation of physical columns from one or multiple tables
a logical table created within SQL
a means of limiting access to a complete table or joining two or more tables
a method of organising table data to meet a specific need
a named, derived table whose definition is a persistent part of the database
a named query, used to simplify complex commonly-run SQL SELECTs
a named specification of a result table
an indexable collection of rows (a table of records , an array of elements )
a part of the database that's obtained by selecting some of the tables, some of the column names, and some rows
a permanent virtual table that you create by naming an SQL-J statement
a perspective representation of the landscape in which detail is shown as if projected on an oblique plane (e
a pre-compiled virtual table that is generated by a user-defined SELECT statement
a predefined selection of data from one or more tables
a predefined way of sorting and filtering a table
a query against base tables
a query of one or more tables that provides another way of presenting information
a query that is stored in the data dictionary
a query which when called looks like a table
a representation of a set of system elements and the relations associated with them
a software representation or a document about software
a specific subset of data in a table, showing all or some of the fields and all or some of the records
a subset of a database that is the result of the evaluation of a query
a subset of a datatype's fields (e
a subset of a table that can be accessed as if it were an actual table
a subset of information related to the entity
a subset of the columns in the database, displayed in a particular order and with specified display widths
a subset of the corresponding table that can be used instead of the table - in other words it is a virtual table
a subset of the entire configuration that can be navigated as an object hierarchy
a subset of the input requirements document, composed of those sentences dealing with a particular argument
a synthetic table
a table in more ways than one
a table, on which you do SELECT, INSERT, UPDATE and DELETE
a tool that allows querying of historical and real-time events
a tree, a hierarchical clustering of model variables into named subsets
a type of intersection between a table and a query
a very handy mechanism for insulating the complexity of the database
a very handy mechanism for providing a layer hiding complexity in the database
a virtual table and can be used to access data through the use of the SELECT statement
a virtual table based on the result of a SELECT query
|
