The functions of dba, Database Management System

Assignment Help:

The functions of DBA?


Related Discussions:- The functions of dba

Optimistic concurrency control, Optimistic Concurrency Control Is locki...

Optimistic Concurrency Control Is locking the only way to stop concurrency related problems? There exist some other ways too. One such way is known as an Optimistic Concurrency

What is persistency, What is persistency? Persistency ensures which dat...

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

Define network dbms, Define Network DBMS The NDBMS is built primarily o...

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

By which techniquestransaction processing is associated, By which technique...

By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

Benefits of views-data control, Benefits: It limits data access. ...

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

Single-valued dependencies, Single-Valued Dependencies A database is a ...

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

E-commerce and business intelligence systems., Your friend owns and operate...

Your friend owns and operates a wholesale shoe business with annual revenues of $5 million dollars. His wholesale business specializes in supplying and supporting retailers with sh

Define about the stored procedure, Define about the Stored Procedure - ...

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

What is de-normalization, What is De-normalization? De-normalization is...

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

12/5/2013 4:46:57 AM

The functions of DBA include-

(i) Database Design- Conceptual Database Design consists primarily of defining data elements to be included in database, the relationship that exists between them and the value constraints apply. A value constraint is rule defining permissible values for specific data items.
Physical Database Design determines physical structure of database and includes such decisions as what access methods would be used to retrieve data and what indexes would be built to improve performance of system.

(ii) User Training- the DBA is responsible for educating users in structure of database and in its access through the DBMS. This will be done in formal training sessions by interacting with users to create database views, through user''s manuals and episodic memos and through company information centres. An information centre is a region where users are provided with facilities to do their own computing.

(iii) Database Security and Integrity- The concept of combining an organization''s data into one common pool accessible to all has both compensation and disadvantage. The clear advantage of data sharing is offset by the drawback that data could be misused by the users who do not have original responsibility and authority over data. The DBA supplies procedures and controls to avoid abuse of data.

Access of database is at last controlled by password mechanism, whereby user attempting contact gives a system-validates password. A system allows validated user only those contact rights recorded in data dictionary. DBA is responsible for assigning passwords and controlling privileges. Data integrity refers to problems of maintaining accuracy and consistency of data values. Security mechanisms are as passwords and data views protect data integrity.

(iv) Database System Performance- A database system being simultaneously accessed by many users may respond very slowly at times because physical problems associated with users competing for same resources are not unimportant. Thus, the DBA staff should include technically capable.

 

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd