Fundamentals of Database system

DATA:- known facts that can be recorded and that have implicit meaning.

DATABASE:-collection of related data.

PROPERTIES OF DATABASE

A database represents some aspect of the real world, sometimes called the mini world . Database represents some properties

1. A database is a logically coherent collection of data with some inherent meaning.

2.A database is designed, built, and populated with data for a specific purpose.

3.A database is designed, built, and populated with data for a specific purpose.

DATABASE MANAGEMENT SYSTEM:-A database management system (DBMS) is a computerized system that enables users to create and maintain a database.

Design of a new application for an existing database or design of a brand new database starts off with a phase called requirements specification and analysis.

These requirements are documented in detail and transformed into a conceptual design that can be represented and manipulated using some computerized tools so that it can be easily maintained, modified, and transformed into a database implementation.

The design is then translated to a logical design that can be expressed in a data model implemented in a commercial DBMS.

The final stage is physical design, during which further specifications are provided for storing and accessing the database.

CHARACTERISTICS OF DATABASE APPROACH

1.Self-describing nature of a database system.

2.Insulation between programs and data, and data abstraction

3.Support of multiple views of the data

4.Sharing of data and multi user transaction processing

There are different types of workers with regard to database management which can be categorized as ACTORS ON THE SCENE and WORKERS BEHIND THE SCENE

ACTORS ON THE SCENE

Database Administrators :- The DBA is responsible for authorizing access to the database, coordinating and monitoring its use, and acquiring software and hardware resources as needed.

Database Designers:-Database designers are responsible for identifying the data to be stored in the database and for choosing appropriate structures to represent and store this data.

End User:-End users are the people whose jobs require access to the database for querying updating, and generating reports; the database primarily exists for their use.

WORKERS BEHIND THE SCENE

DBMS system designers and implementer :-design and implement the DBMS modules and interfaces as a software package.

Tool developers design and implement tools ,the software packages that facilitate database modeling and design, database system design, and improved performances.

Operators and maintenance personnel are responsible for the actual running and maintenance of the hardware and software environment for the database system.

ADVANTAGES OF USING DBMS APPROACH

  1. Controlling Redundancy
  2. Restricting Unauthorized Access
  3. Providing Persistent Storage for Program Objects
  4. Providing Backup and Recovery
  5. Providing Multiple User Interfaces

CIRCUMSTANCES WHEN NOT TO USE DBMS

  1. High initial investment in hardware, software, and training.
  2. The generality that a DBMS provides for defining and processing data
  3. Overhead for providing security, concurrency control, recovery, and integrity functions

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store