Oracle: Administration Workshop II

Data administration is a process whereby data resources are arranged and monitored in the field of information systems and computer science. This is done through a database management system(DBMS).

What are the advantages of Data Administration?

Data Administration through using DBMS has a wide range of features. These are as follows,

1. Controlling Data Redundancy
2. Data Consistency
3. Data Sharing
4. Data Integration
5. Data Security
6. Development of an Application
7. Creating Forms
8. Control over Concurrency
9. Backup and Recover Options
10. Data Independency
11. Advanced Capabilities
12. Report Writers

1. Controlling Data Redundancy

When working in a traditional system (non-database), multiple files of the same data can get created at many places. However Database Administration ensures that all the files are integrated into only one database. This makes sure that the same files are not copied more than once.

1. Data Consistency

Checking Data Redundancy also ensures Data Consistency. If an item only appears one, any update required on its value is performed only once and the update is made available to all users.

1. Data Sharing

Data Administration allows sharing of data easier among authorised users of the said data management system.

1. Data Integration

In a database management system, data on a database is saved in the form of tables. A system has multiple tables which can allow relationships to be drawn and retrieve data.

1. Data Security

Data security involves protecting the data of a system from non-authorised users. Data administration ensures that this security is maintained.

1. Development of an Application

The database management system provides tools that can be used to develop an application programs. Hence, this reduces cost and time required to develop an application.

1. Creating Forms

Forms are a user-friendly, simple way of entering data that can be retrieved and used later. One of the important functions of a database management system is forms. The system allows for creation of forms and administering it can ensure that the information entered is monitored regularly.

1. Control over Concurrency

In a traditional system, there is a high probability of data being overwritten if two users are accessing the same data simultaneously. However, a database management system ensures that such concurrency is kept in check and prevents such glitches from affecting data.

1. Backup and Recovery Options

In a database management system, sub-systems like backup and recovery are automatically provided to protect data from being lost. In a traditional computer-file system this is a highly time consuming process (especially if the data is large) where the user has to constantly create backup systems to protect data.

1. Data Independence

In a database management system, the database and application are separated-a process that is referred to as data independence. The advantage of this is that database can be modified without modifying the application itself.

1. Advanced Capabilities

A database management system provides features like reporting data through the internet and accessing files online.

1. Report Writers

A database management system allows for reports to be created easily through providing report writing tools. These can be edited and modified easily. It is saved along with the database and behaves like a constituent of the software.

What is the role and responsibility of a Data Administrator?

Database, irrespective of its size, requires at least of Database Administrator, also known as DBA. An Oracle Database may have many users and hence, can be very large in size. It is therefore clear that database administration is often not job for only one person to handle but involves work that need to be shared among a group of responsible DBAs.

According to a manual on Oracle Database Administration, a database administrator’s responsibilities can cover the following responsibilities,

• Installing and upgrading the Oracle Database server and application tools
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed an application
• Creating primary objects (tables, views, indexes) once application developers have designed an application
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with Oracle license agreements
• 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 on tape
• Backing up and restoring the database
• Contacting Oracle for technical support

What is the Database Administration Training?

The course on Data Administration discusses core concepts, with an in-depth engagement with the basic components of Data Administration and the way to use it in a real world situation.

Some of the concepts that are going to be in the course include

• RMAN Configuration
• Creating Backup with RMAN
• Flashback Technologies
• Managing Memory of Database
• Managing Database Performance

What are the prerequisites for this Database Administration Training?

The basic requirement for this course is a computer with a working internet.

A previous experience in programming is also highly desirous.

Who is this Database Administration Training designed for?

The course is especially suited for the following categories of people

• Database Administrators
• Technical Consultants
• System Analysts
• Portal Developers
• Application developers
• People who wish to know about Data Administration.

Currently there are no Q&As for this course. Be the first to ask a question.