The other main feature of the database is that
it will allow multiple users to access the database at the same time and
sharing of data is possible. The database must comprise concurrency control
software to ensure that quite a few users trying to update the same data at the
same time, it should conserve in a controlled manner. In file system move
toward many programmers will be creating files over a long period and a variety
of files have different format, in various application languages.
A multi-user database whose users have assortment
of applications must provide facilities for describing multiple views. In
traditional file system, if any modifies are made to the structure of the files
if will have an effect on all the programs, so changes to the formation of a
file may need changing of all programs that access the file. But in case of
database advance the structure of the database is stored individually in the
system catalog from the access of the application programs. This belonging is
known as program-data independence.
Consequently there is possibility of
information receiving duplicated, this redundancy is storing similar data
multiple times leads to higher costs and wastage of space. This may effect in
data inconsistency in the application; this is since update is done to some of
the files only and not all the files. Furthermore in database approach multiple
views can be created. View is a tailored demonstration of information contained
in one or more tables. View is also known as "Virtual table" because
view does not hold physically stored records and will not engage any space.
DBMS Assignment Help is easy to get online and there are many kind of assignment help in all subject .
Database can be used to give persistent
storage for data structures and program objects that resulted in object
oriented database approach. Traditional systems undergone from impedance
mismatch problem and complexity in accessing the data, which is evaded in object
oriented database system. Database can be used to stand for complex
relationships amongst data's as well as to recover and update connected data
easily and efficiently.
Resource article: http://www.expertsbuzz.com/
Resource article: http://www.expertsbuzz.com/
Comments
Post a Comment