I. Talking about relational databases and DBAs

In the work, the Enterprise DBA personnel, reading in the evening, occasionally, share it.

Here's a look at the issues related to the job content of the DBA's responsibilities. Of course, since the future of the domestic DBA is so great (and of course it is built on the premise of Technology), I would like to learn this skill as well.

Database specification

As an Oracle practitioner, designing a database is essential to designing an efficient and elegant database for an enterprise database application, avoiding the redundancy of the database, and designing a well-designed database, which must follow certain rules, and the database paradigm is the basis for efficient database design.

1. Fields must have a single attribute attribute, no more = = "Eliminate duplicate records in the table

2. Table to be unique primary key column = = "Determine table row

3. Fields in a table cannot contain non-primary key fields that already appear in other tables = = "Avoid data redundancy

Example

1. For example, the address can be divided into provincial cities and counties streets

Telephone can be divided into home phone work telephone

2. Primary key column not explained

3. Avoid redundancy, avoid storage anomalies, solve requirements by reference, only need to change one data, otherwise there will be inconsistent.

DBA Role Classification

DBA for backup Recovery

DBA for application Development

DBA for database optimization

DBA Responsibilities and Tasks

• Installing and upgrading Oracle Server and application tools

• Allocate the memory of the database and the memory required by the planning database system in the future

• When system analysis and designers design a database schema, plan and create major database storage structures, such as tablespaces and data files

• After the logical storage structure has been created, an application designer needs to create a database object.

• The DBA modifies the database structure based on the needs of the application developer.

• Maintain the security of the user and user passwords on the database to report the security of the database itself

• Control and monitor user access to the database

• Monitor and optimize the performance of your database

• Planning information for backup and recovery databases

• Back up the database on a regular basis and recover the database in the event of a catastrophic failure

DBA's work objectives

1. Security, secure data, and secure access to the database

2. Backup to ensure resiliency in the event of an outstanding disaster or system failure

3. Performance to ensure optimal performance of database system

4. Design to ensure that the database is designed to meet the needs of the enterprise

5. Implementation to ensure the correct implementation of new database systems and applications

DBA Foundation Task steps

1. Evaluate the hardware of the database server

How much disk space may be consumed by the Oracle database

Whether or how many disk devices are available for use with Oracle databases

How much memory the Oracle instance needs to occupy the server

Consider a redundant array of disks, CPU speed, and disk I/O performance

2. Installing Oracle Database Software

3. Planning the logical structure of the database

The logical structure of the database affects the performance of the system and various database management operations, including the following

Computing performance of--oracle database

--Performance of database access operations

--performance of backup and operation

4. Create and open a database

Using DBCA

5. Backing Up the database

Manufacturers have integrated, but need seamless backup recovery must be optimized for processing

6. Registering Database Users

Create users, assign permissions and roles

7. Implementing Database Design

Create table spaces to implement logical structures, tables, views, indexes, sequences, processes, packages ...

8. Perform a full database backup

Get into the habit of having a full backup of the database after the database structure has changed

9. Tuning Database Performance

The most important work for DBAs. The Oracle database provides the Database Explorer with control over resource allocations for different groups of users that we can manipulate.

10. Download and install the patch pack

11. Cloning a database to another server

Vendor integration

This will be installed, created, optimized, and configured on the test computer. Then clone to the production environment by cloning

-----above need to undergo repeated practice and testing, in order to obtain an optimal database-------

If you write it wrong, don't spray it, thank you.

This article is from the "richylu____ Records" blog, so be sure to keep this source http://richylu.blog.51cto.com/1481674/1877561

I. Talking about relational databases and DBAs