Data policies, procedures, standards Planning- development of organization's IT strategy, enterprise model, cost/benefit model, design of database environment, and administration plan. Data conflict (ownership) resolution Data analysis- Define and model data requirements, business rules, operational requirements, and maintain corporate data dictionary Internal marketing of DA concepts Managing the data repository What are the functions of a database administrator? Selection of hardware and software Keep up with current technological trends
A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies and new design approaches. Typically, a DBA has either a degree in Computer Science and some on-the-job training with a particular database product or more extensive experience with a range of database products. A DBA is usually expected to have experience with one or more of the major database management products, such as Structured Query Language, SAP, and Oracle-based database management software. > The following are the functions of a Database administrator - **Schema Definition** The Database Administrator creates the database schema by executing DDL statements. Schema includes the logical structure of database table(Relation) like data types of attributes,length of attributes,integrity constraints etc. - **Storage structure and access method definition** Database tables or indexes are stored in the following ways: Flat files,Heaps,B+ Tree etc.. - **Schema and physical organization modification** The DBA carries out changes to the existing schema and physical organization. - **Granting authorization for data access** The DBA provides different access rights to the users according to their level. Ordinary users might have highly restricted access to data, while you go up in the hierarchy to the administrator ,you will get more access rights. - **Routine Maintenance** Some of the routine maintenance activities of a DBA is given below. - Taking backup of database periodically - Ensuring enough disk space is available all the time. - Monitoring jobs running on the database. - Ensure that performance is not degraded by some expensive task submitted by some users. - Performance Tuning
A data administration (also known as a database administration manager, data architect, or information center manager) is a high level function responsible for the overall management of data resources in an organization. In order to perform its duties, the DA must know a good deal of system analysis and programming. These are the functions of a data administrator (not to be confused with database administrator functions): 1. Data policies, procedures, standards 2. Planning- development of organization's IT strategy, enterprise model, cost/benefit model, design of database environment, and administration plan. 3. Data conflict (ownership) resolution 4. Data analysis- Define and model data requirements, business rules, operational requirements, and maintain corporate data dictionary 5. Internal marketing of DA concepts 6. Managing the data repository What are the functions of a database administrator? 1. Selection of hardware and software Keep up with current technological trends Predict future changes Emphasis on established off the shelf products 2. Managing data security and privacy Protection of data against accidental or intentional loss, destruction, or misuse Firewalls Establishment of user privileges Complicated by use of distributed systems such as internet access and client/ server technology.