ORACLE11G from scratch-20141128

ORACLE11G from scratch-20141128

1. Oracle Database Overview

1.1 structure and composition

Oracle Database 11G has four editions: Enterprise Edition, Standard Edition, Standard Edition 1, and individual edition.

1.1.1, Enterprise Edition

Advantages:

High reliability. Prevents server faults, site faults, and human errors, and reduces the planned downtime.

High security. Ensures data security compliance with regulations by leveraging row-level security, fine-grained auditing, transparent data encryption, and comprehensive data recall.

Better data management.

One-step business intelligence. High-performance data warehouses, online analysis and processing, and data mining.

1.1.2, Standard Edition

Automatic Management on multiple platforms.

Rich development functions.

Flexible customization services.

1.1.3 Standard Edition 1

Application Service Support.

Automatic Management on multiple platforms.

Comprehensive development functions.

Flexible customization services.

1.1.4. Personal Edition

Oracle is a basic database management service for DBMS. It is applicable to single-user development environments and is mainly controlled by developers.

1.2 Basic Terms

1.2.1 Database

The DataBase stores data on a computer's storage device.

1.2.2. Database Management System

DBMS (DataBase Management System) implements various Management and operations on data in the DataBase, scientifically organizes and stores data, efficiently obtains and maintains data, establishes user accounts and assigns permissions, and provides various operation functions to users.

All operations of the database system, including query, update, and various controls, are performed through DBMS.

DBMS can be divided into mesh, hierarchical, relational, and object-oriented.

1.2.3. Database System

DBS are composed of databases, DataBase management systems (and their development tools), application systems, and DataBase administrators.

(1) The Database Administrator (DBA) manages and monitors the database system with negative elements, and solves system problems in applications for users.

Responsibilities:

A. determine the information content and structure in the database.

B. Determine the database storage structure and access policy.

C. monitor the operation of the database (whether the system runs normally and how efficient the system is), and promptly handle problems encountered during the operation of the database system.

D. Security Management. The system security is ensured through system permission settings and integrity control.

E. routine maintenance.

F. Manage relevant database documents.

(2) system analysts and database designers

The system analyst is responsible for Application System Requirement Analysis and Specification Description, and works with the user and DBA to determine the hardware and software configurations of the system, and participates in the outline design of the database system.

(3) application programmers

Software programmers responsible for designing and developing functional modules of the application system, who write specific applications based on the database structure, and perform debugging and installation.

(4) User

The final note. User Interfaces of applications use databases.