Hi .....
Basically there are are two Views regarding to DBMS.
(1)Regression based Views
(2) Interpolation based Views
Regression based Views:
Regression techniques are routinely and very successfully
used in many application domains to model the values of a
continuous dependent variable as a function of the values of
a set of independent or predictor variables. These models are
thus a natural fit in many environmental monitoring applications
that use sensor networks to monitor physical properties
such as temperature, humidity, light etcWe describe a second type of view in this section, the interpolation
view. In an interpolation view an interpolation function is used to estimate the missing values from known
values that bracket the missing value. The process is similar
to table lookup: given a table T of tuples of the form
(T, V ), and a set of T0 values with unknown V 0 values, we
can estimate the v0 2 V 0 value that corresponds to a particular
t0 2 T0 by looking up two pairs (t1, v1) and (t2, v2)
in T such that t1 _ t0 _ t2. We then use the interpolation
function to compute the value v0 from v1 and v2..There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
DBMS
Hierarchical DBMSNetwork DBMSRelational DBMS
1. Following are the different types of dbmsMySQLMicrosoft SQL ServerMS AccessFoxproSAPdBASETibero 6
combines everything into a single system including, DBMS software,hardware, application programs and user interface
Types of Attributes in Dbms areKey or non key attributesRequired or optional AttributesSimple or composite AttributesSingle-valued and multi-valued AttributesStored, Coded or derived Attributes
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.
Armstrong rules are complete or sound in dbms by clarifying the types of situations which need to be achieved and done.
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)
errjklerjqlwrjqwewqerlkwrlqewlrkqwerqewrqwklrjqweklodo tari ma no chodu
Physical schema,logical schema and sub schemas
total 6 normal forms