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.
Published at : Updated