Monday, 3 February 2020

Database Fundamentals

0 comments

Database Fundamentals


? A database is a collection of persistent data that is used by the application system of some
enterprise. The enterprise may be a Bank, a Hospital, an Educational Institution, a Library,
etc.
? The word persistence means once the data of the database is accepted by the DBMS, it can
then be removed from the database only by some explicit request.
? It cannot be deleted or modified because of some side effect just like the programming
language variables.
? There are several advantages of storing the data in database rather than storing it in
operating system files. An example, university database, to illustrate this concept was
discussed.
? In the DBMS environment we speak of many people. For example, the main people involved
are DBA, Database Designers, and various types of users.
? Though database approach has few disadvantages under some specific circumstances, the
use of database is indispensable. The major implications of database approach are:
? Potential for enforcing standards
? Reduced application development time
? Flexibility
? Economically viable
? Data integrity and security
 ? Database need not be used always. There are occasions where you manage your data with
out a database.


Data Abstraction: A database management system is a collection of interrelated files and a set
of programs that allow users to access and modify these files. A major purpose of a database
system is to provide users with an abstract view of the data. This is called data abstraction.
Data processing: The process of converting the facts into meaningful information is known as
data processing. Data processing is also known as information processing.
Data: Data is the raw material from which useful information is derived.
Database: A shared collection of logically related data along with the description of the data that
suits to the needs of large enterprises.
Metadata: Data that describe the properties or characteristics of other data.

No comments:

Post a Comment