People Innovation Excellence

DBMS and It’s User

Data is a raw facts, which can be recorded and which has a latent meaning. Database is a collection of such data, more accurately it is a collection of related data. To create database, we must use software that can create several tables that contains data that we need in the business process. Software which is used to manage such databases is called DBMS. For e.g. Oracle, IBM DB2, Microsoft Access, Microsoft SQL Server, Sybase. DBMS software is a collection of programs which facilitate in access, retrieval, security, creation and sharing of database among its users or other applications. Primary Goal of DBMS Software is to provide an efficient and convenient way of storing and retrieving data.

DBMS is a very common software that has been used in different industries like Universities, Banking, Railways, Airlines,and a lot of other industries. Database System is designed to handle very large amount of data and may extend up to several Terabytes of size. Every day, we have to recover our data in case of system crashes, and also protect the data for any unauthorized access and manipulation. We also use database every day in our daily life. During logging into email account, user-id and encrypted password associated with it is retrieved. During ATM transaction, money is debited and account is updated with the same in the Database System of the bank, these types of use make us End Users. End users are basically consumers who are using a product; they might use it for generating monthly reports, withdrawing money from bank or for specialized and complex use like forecasting sales for next season.

Before database has been built, database designer gather requirements from all prospective users; level of access required for each user or a group and designs the DB which meets the requirement.  Database designers are responsible for identifying data that suitable for database structure. They are generally part of Database Administrators, who needed to administer and monitor usage of the Database. They are responsible to tune the Database for performance issues, to grant access of DB to users and initiate recovery in event of system crash and protect the system in case of security issues.

The other person is Application programmers, who build user interfaces and applications based on end users’ requirement. They develop applications which make data retrieval, creation of reports more convenient. They are fully aware of all the functionalities of DB and use it to their advantage.

Reference:

https://www.managementstudyguide.com/database-management-system-articles.htm


Published at :
Written By
Marisa Karsen
Subject & Content Coordinator Information Systems | School of Information Systems http://sis.binus.ac.id/
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close