0
by telling the professor at ODU homework ?'s are being posted on this website
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is dbms architecture?
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.
What is RDBMS explain its architecture.?
RDBMS : Architecture of a Database Management SystemThe architecture of a database management system can be broadly divided into three levels :a. External levelb. Conceptual levelc. Internal levelThe External LevelThis is the highest level, one that is closest to the user. It is also called the user view. The user view is different from the way data is stored in the database. This view describes only a part of the actual database. Because each user is not concerned with the entire database, only the part that is relevant to the user is visible. For example, end users and application programmers get different external views.For example, an instructor will view the database as a collection of students and courses offered by the university. An administrator will view the database as a collection of records on the stock of course material provided by the university. The instructor is concerned with only a portion of database that is relevant to the instructor and the administrator is concerned with only the portion of database that is relevant to the administrator. These portions of database, which are viewed, by the instructor and administrator are reffered as their user's view or external view.Each user uses a language to carry out database operations. The application programmer uses either a conventional third-generation language, such as COBOL or C, or a fourth-generation language specific to the DBMS, such as visual FoxPro or MS Access.The end user uses a query language to access data from the database. A query language is a combination of three subordinate language :§ Data Definition Language (DDL)§ Data Manipulation Language (DML)§ Data Control Language (DCL)The data definition language defines and declares the database object, while the data manipulation language performs operations on these objects. The data control language is used to control the user's access to database objects.The Conceptual LevelThis level comes between the external and the internal levels. The conceptual level represents the entire database as a whole, and is used by the DBA. This level is the view of the data "as it really is". The user's view of the data is constrained by the language that they are using. At the conceptual level, the data is viewed without any of these constraints.The Internal LevelThis level deals with the physical storage of data, and is the lowest level of the architecture. The internal level describes the physical sequence of the stored records.Following is an example of the three levels :ExternalCout
Mapping in DBMS architecture?
We know that three view-levels are described by means of three schemas. These schemas are stored in the data dictionary. In DBMS, each user refers only to its own external schema. Hence, the DBMS must transform a request on. a specified external schema into a request against conceptual schema, and then into a request against internal schema to store and retrieve data to and from the database. The process to convert a request (from external level) and the result between view levels is called mapping. The mapping defines the correspondence between three view levels. The mapping description is also stored in data dictionary. The DBMS is responsible for mapping between these three types of schemas. There are two types of mapping. (i) External-Conceptual mapping (ii) Conceptual-Internal mapping External-Conceptual Mapping An external-conceptual mapping defines the correspondence between a particular external view and the conceptual view. The external-conceptual mapping tells the DBMS which objects on the conceptual level correspond to the objects requested on a particular user's external view. If changes are made to either an external view or conceptual view, then mapping must be changed accordingly. Conceptual-Internal Mapping The conceptual-internal mapping defines the correspondence between the conceptual view and the internal view, i.e. database stored on the physical storage device. It describes how conceptual records are stored and retrieved to and from the storage device. This means that conceptual-internal mapping tells the DBMS that how the conceptual! records are physically represented. If the structure of the stored database is changed, then the mapping must be changed accordingly. It is the responsibility of DBA to manage such changes.
Which model represents the end user's view of the database?
the ---- of a database presents the views that the end user have
What are the different views of data in a database management systems?
In a database management system, data can be viewed in three main ways: Conceptual view: Represents the overall framework or structure of the entire database. External view: Shows a subset of the database and is tailored to meet individual user requirements. Physical view: Describes how data is stored on the physical storage media.
Explain the architecture of DBMS?
the architecture of dbms contains three levels 1/ external level:different users views of the database,shows relevant data for a particular user. 2/conceptual level:global view pf the database;describes what data is stored and its relationships. 3/internal level:physical representation of the database on the computer, Describes how the data is stored in the database.
What is data abstraction in DBMS?
Purpose of database users with an abstract view of the data that is system hides certain details of how the data are stored and maintained. It gives an architecture is to separate the user applications and the physical database.
Explain the layered architecture of a DBMS?
The ANSI/SPARC architecture is divided into three levels, known as the internal, conceptual, and external levels.The internal level is the one closest to physical storage, i.e., it is the one concerned with the way the data is physically stored.The external level is the one closest to the users i.e., it is the one concerned with the way the data is viewed by individual users.The conceptual level is a "level of indirection" between the other two.If the external level is concerned with individual user views, then the conceptual level is concerned with a community user view. In other words, there will be many distinct external views, each consisting of a more or less of a abstract representation of some portion of the total database, and there will be precisely one conceptual view, consisting of a similarly abstract representation of the database in it's entirely. Likewise, there will be precisely one internal view, representing the total database as physically stored. When we describe some representation as abstract here, we merely mean that it involves user-oriented constructs such as logical records and fields instead of machine-oriented constructs such as bits and bytes.The external level: The external level is the individual user level. A given user can be either an application programmer or an end user of any degree of sophistication. The DBA is an important special case. Unlike other users, however, the DBA will need to be interested in the conceptual and internal levels also.The conceptual level: The conceptual view is a representation of the entire information content of the database, again (as with an external view) in a form that is somewhat abstract in comparison with the way in which the data is physically stored. It will also be quite different, in general, in the way from which any particular user views the data. Broadly speaking, the conceptual view is intended to be the view of the data "as it really is", rather than as users are forced to see it by the constraints of the particular language or hardware they might be using.The internal level: The third level of the architecture is the internal level. The internal view is a low level representation of the entire database; it consists of many occurrences of each of many types of internal record. "Internal record" is the ANSI/SPARC term for the construct that we have been calling a stored record.
Describe the external level of the ansi sparc?
this is the user view of the database, where the customer interacts with the database through the help of graphical user interface (GUI) Benny Pah
How do you xxplain the ANSI SPARK data model?
The ANSI-SPARC Architecture, where ANSI-SPARC stands for American National Standards Institute, Standards Planning And Requirements Committee, is an abstract design standard for a Database Management System (DBMS), first proposed in 1975 .A standard three level approach to database design has been agreed.- External level- Conceptual level- Internal level (includes physical data storage)The 3 Level Architecture has the aim of enabling users to access the same data but with a personalised view of it. The distancing of the internal level from the external level means that users do not need to know how the data is physically stored in the database. This level separation also allows the Database Administrator (DBA) to change the database storage structures without affecting the users' views.External Level (User Views)A user's view of the database describes a part of the database that is relevant to a particular user. It excludes irrelevant data as well as data which the user is not authorised to access.Conceptual LevelThe conceptual level is a way of describing what data is stored within the whole database and how the data is inter-related. The conceptual level does not specify how the data is physically stored.Internal LevelThe internal level involves how the database is physically represented on the computer system. It describes how the data is actually stored in the database and on the computer hardware.Most modern commercial DBMS are based on this system. The ANSI-SPARC model however never became a formal standard.
Who is the most important user of a database?
Short answer, from a DBA's point of view - Each person who logs into the database. A DB system is there to provide data to the end user. If users can't get their data the database is useless. "Important", in this case, is an extremely subjective term.
Objective of three level architecture in simple language?
All users should be able to access same data.A user's view is immune to changes made in other views.Users should not need to know physical database storage details.DBA should be able to change database storage structures without affecting the users' views.Internal structure of database should be unaffected by changes to physical aspects of storage.DBA should be able to change conceptual structure of database without affecting all users.
