Views do not really contain or store data. Views are stored query. They are already stored query to be presented to clients when such specific queries are interpreted by analogous application processes. Views do not actually have data contains in it. They are alternatively known as base tables, and derive data from tables. All updating, adding and deleting of data inside of view affect base tables directly. All these operations can be performed within the specification of views but with some restrictions than the open space filled with tables where all these modifications such as adding, subtracting and deleting of data can be done in a considerable manner.


When there is similarity between columns of two or more tables they are clustered together. So cluster can have one or more tables and they are brought together in terms of similarity of columns. They are physically stored together in order to ensure that data more feasible and this creates speediness of data tables. Similarly, related rows are physically stored together due to the process of indexing so as related columns are physically stored together in order to improve performance of disc access. It cools the server and makes physical drive access snappier than earlier circumstances.

Like indexes of clusters do not affect application design. It works bereft any operating system and it performs the task to a considerable extent. Slowly, it creates an entire cache of database and with time this does not affect heavily on system resources. It means data stored in a clustered table are being accessed similarly by SQL in the same way data being accessed by no clustered table.


Synonyms are names that have been assumed temporarily for any table, view, procedure, sequence or user-defined object type. Due to its specified characteristics it does not hold any space inside the data base. Due to its characteristic, it holds the definition in the data dictionary. There are different type of database objects that are reflected in schema objects of databases. Logical structures of data are recognized as schema objects. A schema is a set of such logical structures of data. Schema holds the same name of data as explained earlier. Each user has a single schema. Schema objects can be created and manipulated by clients from the logical structure of a database and can be edited, deleted and modified through application processes as well as SQL commands and queries.

Schema objects hold logical data storage structures. It does not have a single wired connection to every database unit of server. Then how come such data are systematically stored inside database? Schema objects are logically stored inside table space of the database. Each object has some place of data files inside table space for the database.

Examples of objects are tables, indexes and clusters and many more. There are some specified objects such as tables, indexes and clustered which can specify space of data files of tablespace from logical storage mediums. In this way, it gives the upper hand to the system administrator to control space of objects from logical storage mediums. After reading this user can think of there must be some relationship between a schema and tablespaces. As it is evident that the scheme works in a similar manner in logical storage spaces as in the same manner it works within the physical structure of tablespaces. Actually there are no such real relationships between schema and tablespaces. There are no meaningful rules for schema to be included inside tablespaces.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *