Progress database.

Can you provide the context in which you are hearing or reading these terms?

A "storage object" is a generic term for a table, index or LOB (character large object or binary large object).
 
ya sure....i studied that in following context...

"Storage objects are collections of disk space associated with one or more specific database objects. Each storage object is an instance of a database object described in the schema.
Types of storage objects include tables and indexes."


here i can't get what is storage object and what is database object.....


could you please help me???
 
I think what this means is that the DB object is the table or index definition in the meta-schema, whereas the storage object is the actual implementation of that definition, i.e. the table or object itself.

Imagine your DB contains a Customer table. That table, which contains customer records, is the storage object which is assigned to a storage area. The definition of the Customer table, which collectively resides in the schema in records in _File, _Field, _StorageObject, etc., is the database object.
 
The definition of logical versus physical depends on the point of view:

  • From the design point of view (ERD diagram) entities and keys are logical objects and their physical implementations are tables and indexes.
  • From the database point of view tables and indexes comprise the logical database model and as Rob has pointed out this is stored in the schema of the database. The storage area where the database objects (table and indexes) reside is the physical database model. The application is only interested in the logical one whereas the database engine and some database administrators are more interested in the physical one.


Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top