Discuss the two functions of Data Administration (DA) and Database Administration (DBA). Summarize the responsibilities of each. Are both these functions essential in an organization which utilizes databases? How can an organization fulfill the needs of either of these functions? (If using the internet to additionally research this question, be careful not to use any job ads or resumes/employment descriptions as these typically are too general to be useful or are not checked for technical accuracy.)
Data Administration (DA):
This is the administrative activity. It is responsible for managing the data resources. It is including database planning, dealing with the technical issues such as security enforcement, performance and backup and recovery associated with managing a data base.
Data base Administration (DBA):
This is a technical level function responsible for physical database design, security enforcement, and database performance. It is including maintaining data dictionary, monitoring performance, and imposing organizational standards and security.
The Responsibilities of Data Administration (DA):
Defining data: The responsibility considered data planning, formative user needs and denoting conceptual and external schema.
Creating data: Denoting validation and editing process and suggestion give to people on data collection procedures.
Retiring data: Denoting retirement policies Informing and servicing users: Response to end-user/client/user queries, providing information for clarify user doubts and refining end-users.
Maintaining database integrity: Budding and spread organization wide standards, supporting end users to formulate application controls.
The Responsibilities of Data base Administration (DBA): Defining data: Denoting internal schema like computer oriented definition.
Creating data: Organize programs to create data.
Retiring data: Implementing retirement polices.
Informing and servicing users: Response to programmer queries, providing internal schema information and refining programmers.
Maintaining database integrity: Implementing data base controls. Design application controls.
Yes, Both Data Administration (DA) and Database Administration (DBA) are essential in an organization which utilizes databases. Because, both are responsible for running and controlling the activities associated with the corporate information and database etc.
The DA is more concerned with the early stages of the life cycle and DBA is more concerned with the later stages from application design to maintenance.
An organization fulfill the needs to follow functions: Reduce time complexity and secure purpose system the DA and DBA can be the responsibility of more people. The open source technologies and databases on diverse platforms that must be managed concurrently in many organizations. The embedded of rules in databases the form of triggers, tables and user-defined function. The fast growth in the size of databases stimulated by the storage of complex data types.