ORACLE 11G Learn from scratch-20141128

1. Oracle Database Overview

1.1. Structure and composition

Oracle Database 11G has a total of 4 versions, Enterprise, standard, standard 1, and personal.

1.1.1, Enterprise Edition

Advantages:

High reliability. Prevent server failures, site failures, and human error occurrences, and reduce planned downtime.

High security. Ensure data security compliance with row-level security, granular auditing, transparent data encryption, and comprehensive recall of data.

Better data management.

One step ahead of business intelligence. High-performance data warehousing, on-line Analytical processing and data mining.

1.1.2, Standard Edition

Multi-platform automatic management.

Rich development features.

Flexible custom-made services.

1.1.3, Standard Edition 1

App service support.

Multi-platform automatic management.

Comprehensive development capabilities.

Flexible custom-made services.

1.1.4, Personal Edition

Provides Oracle's basic database management services as a DBMS for single-user development environments, primarily for developer control.

1.2. Basic terminology

1.2.1, database

The database stores the data in a warehouse on top of the computer's storage device.

1.2.2, database management system

DBMS (Database Management System) implements various management and operation of data in databases, organizes and stores data scientifically, efficiently obtains and maintains data, completes the establishment of user accounts and assigns permissions, and provides various operational functions to users.

All operations of the database system, including queries, updates, and various controls, are carried out through the DBMS.

DBMS can be divided into network type, hierarchical type, relational type, object-oriented type and so on.

1.2.3, database system

DBS (Database System,dbs) is comprised of databases, database management systems (and their development tools), application systems, and database administrators.

(1) The database administrator (DBA) to manage and monitor the database system, negative for users to solve the problems in the application of the system.

Duty:

A. Determine the content and structure of the information in the database.

b, determine the database storage structure and access policy.

c, monitoring the operation of the database (System operation is normal, system efficiency), timely processing of the database system in the course of the problems arising from the operation.

D, security management, through the system's permission settings, Integrity control to ensure the security of the system.

E, daily maintenance.

F. Management of database related documents.

(2) System analyst and Database Designer

The system analyst is responsible for the application system requirements analysis and specification, and with the user and DBA, to determine the system hardware, software configuration, and participate in the database system summary design.

(3) Application programmer

A software programmer responsible for designing and developing application functional modules, who write specific applications based on the database structure, and debug and install them.

(4) User

End up in mind. Camel over the user interface of the application using the database.

ORACLE 11G Learn from scratch-20141128