Component of Database System

Basically there are four component of Data System:
1.    Data 
2.    Hardware
3.    Software
4.    Users  
Data
•Database systems are available in smaller or larger systems
Single-user system:
–System in which at most one user can access the database at any given time
Multi-user system:
–System in which many users can access the database at the same time
•Data in the database is both integrated and shared
Integrated:
–database is a unification of several distinct files
–The redundancy among the files are partially or wholly eliminated
Shared :
–Different users can have access to the same data
–I.e, database can be shared among different users

Hardware

•Hardware components consists of
–Secondary storage volumes
•Magnetic disks, I/O devices, device controllers, I/O channels etc.
–Hardware processor and associated main memory that support the execution of the database system software

Software

•Between the actually stored data and the users of the system, there is a layer of software called as Database Management System(DBMS).
–DBMS is also called as database manager or database server
•All requests for accessing the database are handled by the DBMS
•Thus the main function of DBMS is to shield the database users from the hardware-level details

Users

Application Programmers
End User
Database Administrator

Users-Application Programmers

• Responsible for writing application programs which allow end users to access the database interactively.
•Application can be written in some programming languages like COBOL ,C, C++, Java etc..
•Programs access the database by issuing appropriate requests to the DBMS
 Users- End Users

         Persons who access database for querying, updating and generating reports
         Categories
       Casual End Users
       Naïve or parametric users
       Sophisticated end users
       Stand alone users
         Casual End Users:
       Occasional access
       Different information each time
       Typically middle or high level managers or occasional browsers
         Naïve or parametric end users
       Constant querying and updating database
       Use standard queries
Users- Database administrator

         a person who has the central responsibility of data is data administrator
         Data administrator is a manager.
         The technical person who implements data manager’s decision is Database administrator(DBA)
         DBA is responsible for
         Creating the actual database
         Authorizing access
         Coordinating and monitoring the db use
         Acquiring hardware and software resources
         Ensures that system operates with adequate performance

4 comments :


  1. Hai,

    Nicely written post. I am just about to start a new blog and there could not have been a better guide than this one for some good pointers. I am looking forward to starting a successful blog after reading this incredibly useful post of yours. Waiting for more such posts like this.

    Keep writing and sharing!

    Camellia
    SAP Training in Chennai

    ReplyDelete
  2. Thank you for sharing this information about the DBMS. Its very useful for me thank you. And please keep update like this with this site.

    SAP MM Training in Chennai

    ReplyDelete
  3. Wow really amazing. I got excellent information about the java. Its really nice. so thank you for posting and please keep update like this

    digital marketing training Chennai

    ReplyDelete
  4. Very attarctive information.great to know about this new methods.The points are really motivable for the readers.Great and useful article.
    SEO training in chennai adyar

    ReplyDelete