Most of the complexities of hose requirements are still present with personal, desktop-based database systems. Types of people involved: Three types of people are involved with a general-purpose DB’S: 1. DB’S developers – These are the people that design and build the DB’S product, and the only ones who touch its code. They are typically the employees of a DB’S vendor (e. G. , Oracle, MOM, Microsoft, Sybase), or, in the case of Open source Dobbs (e. G. , Myself, Posters), volunteers or people supported by interested companies and organizations.
They are typically skilled systems programmers. DB’S placement is a complicated task, and some of the popular Dobbs have been under development and enhancement (also to follow progress in technology) for decades. 2. Application developers and database administrators – These are the people that design and build a database-based application that uses the DB’S. The latter group members design the needed database and maintain it. The first group members write the needed application programs which the application comprises.
Both are well familiar with the DB’S product and use its user interfaces (as well as usually other tools) for their work. Sometimes the application itself is packaged and sold as a separate product, which may include the DB’S inside (see embedded database; subject to proper DB’S licensing), or sold separately as an add-on to the DB’S. 3. Application’s end-users (e. G. , accountants, insurance people, medical doctors, etc. ) – These people know the application and its end-user interfaces, but need not know nor understand the underlying DB’S.
Thus, though they are the intended and main beneficiaries of a DB’S, they are only indirectly involved with it. Database Administrator: * A database administrator (short form DAB) is a person responsible for he installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. * The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.
Duties: A database administrator’s responsibilities can include the following tasks: * Installing and upgrading the database server and application tools * Allocating system storage and planning future storage requirements for the database system Modifying the database structure, as necessary, from information given by application developers * Enrolling users and maintaining system security * Ensuring compliance with database vendor license agreement * Controlling and monitoring user access to the database * Monitoring and optimizing the performance of the database * Planning for backup and recovery of database information * Maintaining archived data * Backing up and restoring databases * Contacting database vendor for technical support * Generating various reports by querying from database as per need.