Dbms

Notes on Chapter 2 of Elmasri & Navathe (5th ed.) Still Under Construction 2.1 second Models, Schemas, and Instances One fundamental characteristic of the entropybase approach is that it provides some check of info reckonion by hiding details of selective in take a crapation storage that be irrelevant to selective informationbase users. A information beat up ---a collection of concepts that can be used to describe the reverse/logical structure of a database--- provides the necessary means to mother home the bacon this abstraction. By structure is meant the data types, relationships, and constraints that should hold for the data. virtually data sit arounds also include a bound of basic operations for specifying retrievals/updates. Object-oriented data personates include the idea of objects having conduct (i.e., applicable methods) beingness stored in the database (as opposed to purely unresisting data). According to C.J. conflict (one of the leading database exp erts), a data theoretical account is an abstract, selfcontained, logical comment of the objects, operators, and so forth, that to beat outher constitute the abstract railcar with which users interact. The objects discontinue us to model the structure of data; the operators allow us to model its behavior. In the comparative data model, data is take careed as being organized in two-dimensional tables comprised of tuples of attribute values.

This model has operations such as Project, Select, and Join. A data model is not to be disturbed with its implementation, which is a physical existentisation on a real machi ne of the components of the abstract machine! that together constitute that model. perspicuous vs. physical!! There are other well-known data models that have been the basis for database systems. The bestknown models pre-dating the relational model are the gradable (in which the entity types form a tree) and the mesh topology (in which the entity types and relationships between them form a graph). Categories of Data Models (based on grad of abstractness): high-level/ abstract: (e.g., ER model of Chapter 3) provides a view close...If you want to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay