database administrator
database administrator (DBA) A person or member of a group that is responsible for the specification, design, implementation, efficient operation, and maintenance of a database. The identification of a distinct role for database administration (DBA) follows from the concept of data independence, and from the realization that databases form an important and valuable corporate resource.
The DBA person or group would work with users in establishing application requirements and creating an appropriate data model of the information to be held in the database as part of the activity of system specification; would encode the data model as the logical schema of the database using the appropriate data description language together with any required user views; would specify the initial storage schema after consideration of the relative importance of the various activities to be carried out against the database; would advise and work with programmers whose programs access the database; and would be responsible for the initial setting up and loading of the database as part of the activity of system implementation.
The activity is an ongoing one involving the monitoring of performance and any consequential modification of the storage schema to improve it, responsibility for backup and recovery, for creating further user views as required, and generally with database integrity, security, and efficiency. The work is usually seen as encompassing both the business modeling role at one extreme and, at the other, the day-to-day technical problems of making the database system work effectively in practice.
The DBA person or group would work with users in establishing application requirements and creating an appropriate data model of the information to be held in the database as part of the activity of system specification; would encode the data model as the logical schema of the database using the appropriate data description language together with any required user views; would specify the initial storage schema after consideration of the relative importance of the various activities to be carried out against the database; would advise and work with programmers whose programs access the database; and would be responsible for the initial setting up and loading of the database as part of the activity of system implementation.
The activity is an ongoing one involving the monitoring of performance and any consequential modification of the storage schema to improve it, responsibility for backup and recovery, for creating further user views as required, and generally with database integrity, security, and efficiency. The work is usually seen as encompassing both the business modeling role at one extreme and, at the other, the day-to-day technical problems of making the database system work effectively in practice.
More From encyclopedia.com
Data Warehousing , Data warehousing refers to the organization and assembly of data created from day-to-day business operations. Data warehousing enables a user to retr… Data , Data
The word data (singular, datum ) is originally Latin for “things given or granted.” Because of its humble and generic meaning, the term enjoys c… Database Administration , Database administration is simply maintaining records of any type—customer lists, vendor histories, or addresses, for example—using computer software… data communications , data communications The collection and redistribution of information (data) through communication channels. Data communications may involve the trans… Data Mining , Data mining is the process of discovering potentially useful, interesting, and previously unknown patterns from a large collection of data. The proce… Systems Design , A system can be defined in several ways, including: (1) a set of interrelated parts that function as a whole to achieve a common purpose; (2) a piece…
You Might Also Like
NEARBY TERMS
database administrator