three levels of data abstraction
are:
1. Physical level : how the data is
stored physically and where it is
stored in
database.
2. Logical level : what information
or data is stored in the database
(like what is the
datatype or what is format of
data.
3.View level : end users work on
view level. if any amendment is
made it can be
saved by other name.
for the database to be usable it
must retrieve data efficently.this
efficency led designer to use
complex data structure in the
database
Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transaction level is usually referred to as atomic level data. Low granularity refers to data that is summarized or aggregated, usually from the atomic level data. Summarized data can be lightly summarized as in daily or weekly summaries or highly summarized data such as yearly averages and totals.
Hi, High level Data modelling is the process of define and analyze the data requirement.
Data fields
three levels of data abstraction are: 1. Physical level : how the data is stored physically and where it is stored in database. 2. Logical level : what information or data is stored in the database (like what is the datatype or what is format of data. 3.View level : end users work on view level. if any amendment is made it can be saved by other name. for the database to be usable it must retrieve data efficently.this efficency led designer to use complex data structure in the database
three levels of data abstraction are: 1. Physical level : how the data is stored physically and where it is stored in database. 2. Logical level : what information or data is stored in the database (like what is the datatype or what is format of data. 3.View level : end users work on view level. if any amendment is made it can be saved by other name. for the database to be usable it must retrieve data efficently.this efficency led designer to use complex data structure in the database
how data are stored would be in a physical layer
external level
implementation level
Elementary data link protocols must agree at the most rudimentary level. The data frame must be constructed from this level, and all protocols must agree.
dictionary
The machine level.
A system diagram is known as a first level DFD (Level 0 DFD) A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system.