What is dbms architecture?

Answer 1

1. External view : this is a highest level of abstraction as seen by user. This level of abstraction describes only the part of entry database. It is based on the conceptual model, is the end user view of data environment. Each external view described by means of a schema called an external schema or subschema. The external schema consists of the definition of the logical records and the relationships in the external view. The external schema also contains he method of deriving the objects in the external view from the objects in the conceptual view. The object include entities, attributes and relationships.

2. Conceptual level : at this level of database abstraction all the database entities and the relationships among them are included. One conceptual view represents the entire database. the conceptual schema defines ths conceptual view. It there is only one conceptual schema per database. This schema also contains the method deriving from the objects in the conceptual view from the objects in the internal view.. at this level a database is described logically rather then physically in term of data structure.

3. Internal(physical) level : this lowest level of abstraction. it closest to physical storage device. It describes how data are actually stored on the storage medium. The internal schema, which contains the definition of the stored record, the method representing the data fields, expresses the internal view and the access aids used.